C:\mysql\bin>mysql -u sensor1 -p snort
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.55-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW DATABASE
->
mysql> SHOW GRANTS
->
This shouldnt be like this im guessing? ;( HOw can i fix this?
From: "Wil McGilvery" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: RE: Access denied for user: '@192.168.0.1' -SNORT-
Date: Mon, 10 Feb 2003 16:40:02 -0500
I believe the syntax is the same regardless of what O/S you have.
Have you tried connecting from your shell?
shell> mysql -u (user_name) -p (name of database use mysql or test)
<enter password when prompted or leave blank if no password>
To see your databases use ..
mysql> SHOW DATABASES
To see priviledges for sensor1@"ipaddress" use..
mysql> SHOW GRANTS FOR sensor1@"ipaddress"
I noticed that you used [EMAIL PROTECTED] when you granted privileges and the snort error used @192.168.0.1. You may want to check this out.
There are some very good admin tools that will assist you in the administration of mysql.
Try:
http://www.phpwizard.net/projects/phpMyAdmin/
http://www.webyog.com/sqlyog/index.html
HTH
Regards,
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: Net Llama! [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 3:57 PM
To: [EMAIL PROTECTED]
Subject: RE: Access denied for user: '@192.168.0.1' -SNORT-
I've never used mysql on a windoze box, so its really hard to say if what
you did was right or wrong.
On Mon, 10 Feb 2003, mike Hughes wrote:
> 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 [EMAIL PROTECTED];
>
> ## IS THIS right was it suppose to be named sensor1@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! <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >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:[EMAIL PROTECTED]]
> > > Sent: Monday, February 10, 2003 6:13 AM
> > > To: [EMAIL PROTECTED]
> > > 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 [EMAIL PROTECTED]
Linux Step-by-step & TyGeMo http://netllama.ipfox.com
_______________________________________________
Linux-users mailing list
[EMAIL PROTECTED]
Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
_______________________________________________
Linux-users mailing list
[EMAIL PROTECTED]
Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
_______________________________________________
Linux-users mailing list
[EMAIL PROTECTED]
Unsubscribe/Suspend/Etc -> http://www.linux-sxs.org/mailman/listinfo/linux-users
