Re: Problem Installing mod_log_sql RedHat 7.0

Chris Powell wrote:

>> 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
>
>  
>
Chris,
Thank you for your help.  The word 'scoket' was a miss type by me the 
correct line should have read '/var/lib/mysql/mysql.sock' .  I will try 
to change the boot up sequence and see if that fixes the first error 
message.

Mark