I want to set up a central log server, doing this on RH9. Using msyslog, a replacement for syslog which can log to a mysql db. I originally had msyslogd logging successfully to mysql. Great, but I want to be able to view my logs via http, and after having trouble setting up apache with PHP support and the tie-in to mysql, I decided to use XAMPP (formerly LAMPP) ver 1.3, which installs all the components I need apache, PHP, mysql, PHPAdmin (and other items) as a package. (I uninstalled mysql and apache first.)
Very nice but now I can't get msyslog to connect to mysql. In the logs, I have: om_mysql: sending messages to localhost, database msyslog, table syslogTB. om_mysql_write: Lost connection! [Can't connect to local MySQL server through socket '/var/lib/mysq That last line is truncated in the log. I presume it would complete with the socket file, which would be defined in my /etc/my.conf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Can anyone tell me where to start on this? Thanks!! Scott ===== -- To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public. -- Theodore Roosevelt, 1918 . __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]