Re: Can't connect to db after upgrade

[Stephen Bernacki <snort () f copacetic net>]

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
-- 
Steve Bernacki, Jr
To date, the Pan-Massachusetts Challenge has raised 204 million
dollars for cancer research.  Get involved!  http://www.pmc.org/


-------------------------------------------------------------------------
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