On Thu, 9 Jun 2005, Claudinei Matos wrote: > I did installed mod_log_sql and and setup the conf file using default > options as template. > well, I also followed a tutorial that actually is for a old version > but following the default options I did the adjusts. > I did create the database and executed the query to create database > but nothing is logged to mysql and even to sql file and all I get is > the errors below: > > [error] (13)Permission denied: attempted append of local preserve file > '/var/log/apache2/mod_slog_sql_preserve.sql' but failed. > [error] mod_log_sql: child spawned but unable to open database link > > I've changed log file owner to apache user and group and also changed > permition to 666 but even with this apache can't to write to sql file. > I also did recreated the apache user permission and apache still can't > open database link. > > I really don't know what to do since it appears to be so easy to setup > and I really did all the things that articles says.
What username and password is Apache using? Can you login to MySQL with that username and password? You dont say if you created any logins for this application. MySQL logs errors into /var/log/mysql/mysqld.err - what does it say? Also check disk space is OK - MySQL writes into folders under /var. -- -- [email protected] mailing list
