Access denied for user: '@192.168.0.1' -SNORT-

[mike Hughes]

Hey whats up?

when i created the mysql database on my windows machine this is what i did:

cd c:\mysql\bin

MySQL grant INSERT,SELECT,CREATE,DELETE on snort.* to snort;

grant INSERT,SELECT,CREATE,DELETE on snort.* to sensor1 at 172.42.64.11;

## IS THIS right was it suppose to be named sensor1 at my inetrnet ip or was it 
suppose to be named my LAN ip og my LINUX machine??
Well then i did:

exit

MySQL -u snort snort < c:\SnortM\snortdb\create_mysql

Exit ( To exit the shell window)












>From: Net Llama! <netllama at linux-sxs.org>
>Reply-To: linux-users at linux-sxs.org
>To: linux-users at linux-sxs.org
>Subject: RE: Access denied for user: '@192.168.0.1'  -SNORT-
>Date: Mon, 10 Feb 2003 10:30:44 -0500 (EST)
>
>In deed, that sounds like the problem to me as well.  "@192.168.0.1"
>sounds like a really strange name for a mysql user.  You sure that you set
>it up properly?
>
>On Mon, 10 Feb 2003, Wil McGilvery wrote:
>
> > I am not an expert on snort, but it looks like the user that is trying 
>to log onto your database does not have permission to access it.
> >
> > Have you tried to access your database with that user outside of snort?
> >
> > www.mysql.com has very good documentation about setting up and 
>configuring a database.
> >
> >
> > Wil McGilvery
> > Manager, Digital Media
> >
> >
> >
> > 416-744-7191
> > 416-716-3964 (cell)
> > 1-888-622-3729
> > 416-744-0406  FAX
> > www.LynchDigital.com
> >
> >
> > -----Original Message-----
> > From: mike Hughes [mailto:mikehughes013 at hotmail.com]
> > Sent: Monday, February 10, 2003 6:13 AM
> > To: linux-users at linux-sxs.org
> > Subject: Access denied for user: '@192.168.0.1' -SNORT-
> >
> > whaaats up guys...
> >
> > I have worked at this for a while now but cant figure it out...I have 
>been
> > trying to get snort working using this as my reference but am stuck on 
>the
> > send to last step HELP!
> > here is my reference:
> > http://www.sans.org/rr/intrusion/practical_guide.php
> > Fragment Problems: 0
> > telnet_decode arguments:
> > Ports to decode telnet on: 21 23 25 119
> > ERROR spp_arpspoof /etc/snort/snort.conf(39) => Cannot initialize
> > arpspoof_detect_host without arpspoof
> > database: compiled support for ( mysql )
> > database: configured to use mysql
> > database: database name = snort
> > database: user = sensor1
> > database: host = 192.168.0.69
> > database: port = 3306
> > database: sensor name = Sensor1
> > database: detail level = full
> > database: mysql_error: Access denied for user: '@192.168.0.1' to 
>database
> > 'snort'
> > Fatal Error, Quitting..
> >
> > How can i debug this and try to figure out what setting is wrong???
> > Im a newbie to mysql  soo im not too sure how to see those settings: but 
>i
> > followed the directions properly.
>
>--
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Lonni J Friedman				netllama at linux-sxs.org
>Linux Step-by-step & TyGeMo		     http://netllama.ipfox.com
>
>_______________________________________________
>Linux-users mailing list
>Linux-users at linux-sxs.org
>Unsubscribe/Suspend/Etc -> 
>http://www.linux-sxs.org/mailman/listinfo/linux-users


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus