Problem Installing mod_log_sql RedHat 7.0
Mark Walther <[email protected]>
| Newsgroups | gmane.comp.apache.mod-log-sql |
|---|---|
| Message-ID | <[email protected]> |
Hi, I need some help please with installing mod_log_sql on a redhat 7.0 system. I am seeing two different error messages in the httpd/error_log file. 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' The error code 111 in the mysql error codes, says: connection refused; is this correct and what does the 636 for mod_log_sql mean? 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. The error code 1151 in the mysql C API Error Codes, says: Too many delayed threads in use. In either case after examining the log/mysql-message file there are no "insert for apachelogs file". I have given the apachelogs user access under localhost, machine1 and full.path.to.machine1.com. I have double checked the LogSQL setup in the httpd.conf file and they are OK. I have login in under the apachelogs user and can access the mysql . I have checked the tables and structure of the data tables using the PHP mysqladmin program and they all match the installation documents. Any ideas what I should try next? Also are there any archives for this list and if so how do I access them? Thank you for any help you may be able to give me. Mark __________________________________________________________________ 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/