Snort mailing list archives
Re: DB ERROR
From: twig les <twigles () yahoo com>
Date: Thu, 12 Dec 2002 07:43:20 -0800 (PST)
Hehehe, I just had this one. It seems that when you connect to mysql via 127.0.0.1 you use a TCP port, and when you use localhost you use a socket. The socket is faster and preferred, thus default. It seems that a config file of yours has 127... in it. The quick and dirty way is to add the grant statement for snort@127..., but unless you have a specific reason to use the 127 addy (my reason was using stunnel) I would find that reference to it and change it to 'localhost'. --- "Luo, Philip" <Philip_Luo () adp com> wrote:
I am getting the following error when I looked at any one of the alerts at ACID. I remembered I did run this command at mysql grant INSERT,SELECT,CREATE,DELETE on snort.* to snort@localhost identified by "snort"; Database ERROR:Database ERROR:Access denied for user: 'snort@127.0.0.1' to database 'snort' -phil
===== ----------------------------------------------------------- If you give a man a fish, he can eat for a day If you bludgeon him to death, you can eat the fish yourself ----------------------------------------------------------- __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- DB ERROR Luo, Philip (Dec 12)
- Re: DB ERROR twig les (Dec 12)
- Re: DB ERROR Jens Krabbenhoeft (Dec 12)
- <Possible follow-ups>
- RE: DB ERROR Luo, Philip (Dec 13)
- Re: DB ERROR Steve Suehring (Dec 13)
- Re: DB ERROR twig les (Dec 13)
- Re: DB ERROR Steve Suehring (Dec 13)
- RE: DB ERROR Luo, Philip (Dec 16)
- RE: DB ERROR Luo, Philip (Dec 19)
- Re: DB ERROR Steve Suehring (Dec 19)
- RE: DB ERROR Luo, Philip (Dec 19)
- Re: DB ERROR 'Steve Suehring' (Dec 19)