Mike Sperano wrote: > Hi Everyone > > I have everything up and running and all seems to work well the only problem, > I am getting stuck on is my sql database is filling up really fast. What I > have noticed is when syslog-ng pipes the logs over to the mysql.pipe file and > then the syslog2mysql.sh script runs but the script keeps repeating all of > the messages that are in the pipe file over and over and over so with in > minutes the database is expanding with a repeat of the same exact message. > Can anyone shed so light >
Your problem sounds like you have created a regular file called "mysql.pipe". The mysql.pipe object is not a "file", it is a FIFO socket. FIFO means first-in, first-out. In other words, when you read a line from a fifo socket, that line is removed automatically from the device. To create this device, you don't just create a regular unix file (as with the "touch" command). You need to create a fifo pipe with the "mkfifo" command. This should be described somewhere in the documentation which I don't have handy at the moment. Cheers, /Jason ------------------------------------------------------------------------- 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/ _______________________________________________ Php-syslog-ng-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
