[syslog-ng]Syslog-ng and MySQL

[Hamilton, Andrew]

This is a permissions problem with mysql.  It uses a couple of different
things to authenticate a user.  The user, the host and the password.  Make
sure you have root@(ipaddr) in the user table.  That is not the same as
root@localhost, or root@hostname.  You can also have a user with a "%" as
the host entry which will allow a user from any host to login.  NOT
RECOMMENDED FOR THE ROOT ACCOUNT.  

Regards,

Drew

-----Original Message-----
From: Madziarczyk, Jonathan [mailto:than@cityofevanston.org]
Sent: Monday, March 24, 2003 11:57 AM
To: syslog-ng@lists.balabit.hu
Subject: [syslog-ng]Syslog-ng and MySQL


So I'm trying to log to a MySQL database with Syslog-ng.  I followed the
directions on "campin.net" and everything looks good.

However when I try to look at the data, I get the message "[MySQL][ODBC
3.51 Driver] Access Denied for user: 'root@(IPAddr)' (Using password:
YES).  I'm using the odbc driver on a pc to look at the server.  Is this
a MySQL permissions problem or is there something else I should be
looking at?  If it is, what do I need to add to let this work?


Thanks
_______________________________________________
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