Re: Problem Installing mod_log_sql RedHat 7.0

"Chris Powell" <[email protected]>
Newsgroups gmane.comp.apache.mod-log-sql
Message-ID <[email protected]>
>  1) One error message I see after cold booting (no matter how many 
>times you reboot same message): [error] mod_log_sql: child spawned but 
>unable to open database link.
> [debug] mod_log_sql.c (636): mod_log_sql: database connection error: 
>Can't Connect to MySQL server on 'full.url.path.to.my.machine1.com'(111).
>[debug] mod_log_sql.c(637): HOST:  'full.url.path.to.my.machine1.com' 
>PORT: '3306'  DB: 'apachelogs'	USER: 'loguser'  SOCKET: 
>'/var/lib/mysql/mysql.scoket'

Just FYI, the number in parenthesis is the line number of the soure code on
which the error occurred, not the error code itself.  

Looks to me like your Apache server is starting before your MySQL server? 
Since they live on the same machine, your MySQL needs to start first.

>2)  If is just restart httpd I get a totally different error message:
> [debug] mod_log_sql (630):  HOST:  'full.url.path.to.my.machine1.com' 
>PORT: '3306'  DB: 'apachelogs'	USER: 'loguser'  SOCKET: 
>'/var/lib/mysql/mysql.scoket'
>[debug] mod_log_sql.c(1151): mod_log_sql: open_logdb_link successful.

I'd wager that your misspelled word "scoket" has something to do with why
you're not seeing any info in the logs. :-)

Chris



__________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]>
with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
The module homepage is http://www.grubbybaby.com/mod_log_sql/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.