And apache can write to the directory that the file is in? i know in a vanilla install that directory is only writeable root...
On Thursday 09 June 2005 18:32, Claudinei Matos wrote: > On 6/9/05, kashani <[EMAIL PROTECTED]> wrote: > > Claudinei Matos wrote: > > > [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 > > > > Assuming it's not a software issue, have you verified that you can > > connect to your database server from the client using the same > > credentials? > > > > kashani > > -- > > [email protected] mailing list > > yeah, I can connect to mysql with the specified user/password. > I also tried to use my admin user and that's faill too. > What is stranger is that even the preserve file can't be writed. > > that's my configuration for mod_log_sql: > > <IfModule mod_log_sql.c> > # LogSQLMassVirtualHosting automatically sets LogSQLCreateTables to > 'on' LogSQLMassVirtualHosting on > > LogSQLDBParam user apache > LogSQLDBParam passwd apacheuserpassword > LogSQLDBParam host localhost > LogSQLDBParam database apachelogs > LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock > LogSQLMachineID localhost > > LogSQlPreserveFile /var/log/apache2/mod_slog_sql_preserve.sql > </IfModule> > > And that's the permission for preserv file: > > -rw-rw-rw- 1 apache apache 5 Jun 9 18:09 > /var/log/apache2/mod_slog_sql_preserve.sql > > > Tks in advice, > > Claudinei Matos -- [email protected] mailing list
