mhlarsen9237
11-03-2002, 06:05 PM
I've got an apache 1.3.26 server working with mysql and php. I've installed them all from source to /usr/local/??? mysql, apache. MySQL works with the queries my php scripts runs.
I'm trying to get this mod_log_mysql module working. I've compiled it as a DSO. I have the following in my httpd.conf file:
LoadModule mysql_log_module libexec/mod_log_mysql.so
MySQLLoginInfo 127.0.0.1 usename password
MySQLDatabase apache
MySQLTransferLogTable access_log
MySQLTransferLogFormat AcfRhluTrmHtUpsS
I am certain that the username and password work to access mysql and have privildges on the database and table named.
I have the following in /etc/my.cnf
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
#log-bin
server-id = 1
log=/var/log/mysql-messages
The problem is that the module isn't logging anything to the database. I've been monkeying around with this for hours trying to get it to work. It would really helpful if I could find the logs from mysql so I can see if it's even trying to log this stuff, but I can't. Based on what's in my.cnf I figured that I should find them in /var/log/mysql-messages, but there is no such file and I after running updatedb and locate mysql-messages I can't find my log files. Any idea where to look?
Thanks,
I'm trying to get this mod_log_mysql module working. I've compiled it as a DSO. I have the following in my httpd.conf file:
LoadModule mysql_log_module libexec/mod_log_mysql.so
MySQLLoginInfo 127.0.0.1 usename password
MySQLDatabase apache
MySQLTransferLogTable access_log
MySQLTransferLogFormat AcfRhluTrmHtUpsS
I am certain that the username and password work to access mysql and have privildges on the database and table named.
I have the following in /etc/my.cnf
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
#log-bin
server-id = 1
log=/var/log/mysql-messages
The problem is that the module isn't logging anything to the database. I've been monkeying around with this for hours trying to get it to work. It would really helpful if I could find the logs from mysql so I can see if it's even trying to log this stuff, but I can't. Based on what's in my.cnf I figured that I should find them in /var/log/mysql-messages, but there is no such file and I after running updatedb and locate mysql-messages I can't find my log files. Any idea where to look?
Thanks,