I'm running Apache 2.0.46 with PHP 4.3.2 on...
Articles and Tips: qna
01 Sep 2003
Q.
I'm running Apache 2.0.46 with PHP 4.3.2 on an OS/2 Warp 4.5.2 web server, connecting to a MySQL database on my NetWare 6 Support Pack 3 server. When making a larger than 256-character post to a database (I'm currently using PHP/MySQL for Geeklog), I'm seeing consistent timeouts from the server. In the Geeklog error log, I get messages similar to the following:
Lost connection to MySQL server during query SQL in question: REPLACE INTO gl_stories
or
Lost connection to MySQL server during query SQL in question: UPDATE gl_blocks SET content =...
Is there a setting I need to change either in php.ini or in my.cnf to address this?
A.
This may happen usually either due to:
Some problem with the PHP build, or
Mysqld on the server is getting restarted for some reason.
You can verify this by seeing if MYSQLD.NLM on the NetWare server is restarting soon after executing the query that is failing.
If the server is not restarting, then there is some problem with the PHP client. Increase the connection time value and try again. Also, execute the same query from the mysql client (MYSQL.NLM) on the NetWare server and see if it works from there.
* Originally published in Novell AppNotes
Disclaimer
The origin of this information may be internal or external to Novell. While Novell makes all reasonable efforts to verify this information, Novell does not make explicit or implied claims to its validity.