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/