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
