Re: Can't connect to db after upgrade

[James Lay <jlay () slave-tothe-box net>]

On 12/30/07 7:34 AM, "Stephen Bernacki" <snort () f copacetic net> wrote:

> James Lay wrote:
> > Hey all!
> >
> > After doing an upgrade to snort from 2.4 to 2.8, I now get:
> >
> > Dec 29 13:10:56 gateway snort[16646]: FATAL ERROR: database:
> > mysql_error: Can't connect to MySQL server on '172.16.1.2' (110)
> >
> > I can connect manually with:
> >
> > [13:16:30 me@gateway:~$] mysql -u snort -p -D snort
> > Enter password:
> [snip]
>
> You didn't specify what operating system you're running, but under Linux
> (CentOS 4.5), /usr/bin/perror returns:
>
> centos4> perror 110
> OS error code 110:  Connection timed out
>
> Your manual connection is likely succeeding because it's using the local
> mysql unix domain socket, not the TCP socket that snort is trying to use.
>
> To troubleshoot further, try specifying the protocol and host to connect
> to on the mysql command line:
>
> centos4> mysql -h 172.16.1.2  --protocol=tcp  -u snort -p -D snort
>
> You should now experience the same type of error that Snort is seeing.
>  From this point I'd recommend checking your local firewall rules,
> making sure that the locally running MySQL has a tcp socket listening on
> the port you think it does, or configuring Snort to use the local MySQL
> unix domain socket instead.
>
> Steve


I'll be butched...that's TOTALLY what happened.  I have snort/mysql
installed on 4 machines and this is the only one with this issue.  I looked
but couldn't see how to config snort to use unix domain sockets.  I checked
the firewall and all seemed well as this is the same machine.  Very weird!
Can someone point me in the right direction for telling snort to use unix
domain sockets?

Thanks all!

James



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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