Snort mailing list archives
Re: Can't connect to db after upgrade
From: Stephen Bernacki <snort () f copacetic net>
Date: Sun, 30 Dec 2007 09:34:26 -0500
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
Current thread:
- Can't connect to db after upgrade James Lay (Dec 29)
- Re: Can't connect to db after upgrade Stephen Bernacki (Dec 30)
- Re: Can't connect to db after upgrade James Lay (Dec 31)
- Re: Can't connect to db after upgrade Stephen Bernacki (Dec 30)