What ver of syslog-ng are u running? The dbName, dbPassword, and dbUsername are stored in the script and that script then takes the input from the mysql.pipe,  or from the command line
mysql -u root --password=passwd syslog < /tmp/mysql.pipe
 
Look the scripts,, http://www.vermeer.org/syslog/scripts 
 
michael


>>> cat_roger22@hotmail.com 09/24/02 08:13AM >>>
Hi *,
I didn't understood the posts on the mailing list about the entryes
inserted into syslog-db, I've some questions:

destination d_mysql {
  pipe("/var/chroot/syslog-ng/tmp/mysql.pipe"
        template("INSERT INTO logs
                (host, facility, priority, level, tag, date, time,
program, msg)
                VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL',
'$TAG',
                '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM',
'$MSG' );\n")
        template_escape(yes));
};

I verified  the conf file with "-s" option and it didn't returned any
error.
The Db works fine and I noticed that other people have the same
problem...What is the solution ?
...And... Where is set the DB name  variable ?...in a conf file I
suppose....but where is that ?

I Activated the debug option but the output was :

gc_mark: Marking object of class 'UNKNOWN' (1)

I see the same output even if I don't use mysql option....

Ciao

_______________________________________________
syslog-ng maillist  -  syslog-ng@lists.balabit.hu
https://lists.balabit.hu/mailman/listinfo/syslog-ng
Frequently asked questions at http://www.campin.net/syslog-ng/faq.html