RE: mysql_error: Lost connection to MySQL server during query

["Brian M. Diehl" <bdiehl () a1limo com>]

FWIW,  You can also edit /etc/my.cnf
And add 
set-variable = thread_stack=512k
(under the [mysqld] section)

That worked for me on MySQL 3.23.54a-4 & RedHat 8.0

HTH,
--B.

-----Original Message-----
From: Ben Swaby [mailto:BSwaby () InvestmentScorecard com] 
Sent: Tuesday, February 11, 2003 2:20 PM
To: snort-users () lists sourceforge net
Subject: [Snort-users] mysql_error: Lost connection to MySQL server
during query


I have been using Linux for only 2 weeks so my question may be an easy
answer (I hope). 

Running
- Redhat 8
- Snort 1.9.0
- MySQL 3.23.54a-4
- Webmin 1.060
- P4 2.4Ghz, 512mb RAM


Currently I have successfully installed snort, ACID, MYSQL, and Webmin
using Steven J. Scott's paper " Snort Installation Manual - Snort,
MySQL, Redhat 7.3 " on a Redhat 8.0 box(PC1).  My main problem is when I
setup a new snort box to log information to the main database (PC1) I
get the following error when I run 

Command
/usr/local/bin/snort -c /etc/snort/snort.conf


Error returned
database: mysql_error:  Lost connection to MySQL server during query


In the snort.conf file I have specified 

Output database: log, mysql, user=snort password=xxxxxxxx dbname=snort
host=10.1.0.61 sensor_name=624Snort port=3306

Location
Currently both snort boxes are on the same switch in the same VLAN.

As far as I know I don't have any firewall software turned on in mySQL.
I have also run a port scan on PC1 and verified that port 3306 is open.


I have searched the forums and found some things but nothing seem to
help.


Thanks for any help that you can give.

Ben Swaby




-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld =omething 2 See!
http://www.vasoftware.com
_______________________________________________
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=ort-users


-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
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