Re: [gentoo-server] mod_log_sql can't connect do db and can't write to file

[Michael Cummings]

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 <kashani-list@××××××××.net> 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
> > --
> > gentoo-server@g.o 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
-- 
gentoo-server@g.o mailing list