Re: [PHP] Re: Problem between php4.4 and mysql
Thanks for all your help. Problem was that Up2date had installed php 4.3.2 onto our server and compiled no support for MySQL into Apache. I was getting no error messages, so it was only when I saw phpinfo() that I realised that the version had changed. Alex. On Mon, 22 Aug 2005 10:55:06 +1200, Jasper Bryant-Greene [EMAIL PROTECTED] said: M. Sokolewicz wrote: Jasper Bryant-Greene wrote: Well, it's hard to say without a bit more detail. Are you able to give us the actual error that PHP is giving on the database connected pages? I assume you are using the mysqli functions rather than the mysql functions to access your database? just in case you didn't know, mysqli wasn't available before PHP 5.0.0. The user states to be using PHP 4.4.x Apologies, didn't read his email properly. In that case, do you have MySQL set up to accept old passwords? The password-hashing function changed with MySQL 4.1, and the mysql PHP function uses the old function. Please remember to send replies to the list, there are other far more knowledgeable people out there who will be able to help too! Again, *please* send replies to the list as well, not just me! Jasper -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Problem between php4.4 and mysql
Sounds like you have a duplicate entry in your httpd.conf for the PHP module, 100% of the time ive seen that error is the above reason, so I suggest checking your LoadModule * sections, depending whether you have a shared libphp4.so module or built-in module there should or shouldnt be a LoadModule section present. HTH Alex Scott wrote: Hi there, I discovered that our website was not working properly today (To my horror). Hosted on redhat enterprise 4. I think that there is a problem with php 4.4 talking to Apache mysql 4.1 as the php pages which do not talk to the DB are working but other php pages are working. I restarted apache using the inetd script as well as mysql using the inetd script. However the problem exists. I can enter mysql through the shell and tables seem intact. I have no relevant errors in my log file. One thing I noticed was that when I went to restart Apache it said ( before restarting): [Sun Aug 21 10:39:08 2005] [warn] module php4_module is already loaded, skipping Should I try to be loading that module, somehow? Any suggestions in how to get PHP working with mysql again would be much appreciated as it is a busy sight, so slightly stressed. Thanks Alex. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Problem between php4.4 and mysql
On 21 Aug 2005, at 20:47, Alex Scott wrote: Thanks, Yes I found that it was also loading php.conf from conf.d , so moved that up a level restartedd apache and that error ceased. However I am still finding that the database connected php pages are not loading. I don't know why they just seemed to have stopped working, phpbb forum as well. When I loging I get a message about might have been hacked in the ssh window, but I don't know if that was just someone trying to login? Cheers for any more ideas, Alex. On 21 Aug 2005, at 19:39, JamesBenson wrote: Sounds like you have a duplicate entry in your httpd.conf for the PHP module, 100% of the time ive seen that error is the above reason, so I suggest checking your LoadModule * sections, depending whether you have a shared libphp4.so module or built-in module there should or shouldnt be a LoadModule section present. HTH Alex Scott wrote: Hi there, I discovered that our website was not working properly today (To my horror). Hosted on redhat enterprise 4. I think that there is a problem with php 4.4 talking to Apache mysql 4.1 as the php pages which do not talk to the DB are working but other php pages are working. I restarted apache using the inetd script as well as mysql using the inetd script. However the problem exists. I can enter mysql through the shell and tables seem intact. I have no relevant errors in my log file. One thing I noticed was that when I went to restart Apache it said ( before restarting): [Sun Aug 21 10:39:08 2005] [warn] module php4_module is already loaded, skipping Should I try to be loading that module, somehow? Any suggestions in how to get PHP working with mysql again would be much appreciated as it is a busy sight, so slightly stressed. Thanks Alex. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Problem between php4.4 and mysql
On 21 Aug 2005, at 21:24, Jasper Bryant-Greene wrote: As far as your database problem goes... Have you recently installed MySQL 4.1 or has it previously been working with MySQL 4.1? Alex Scott wrote: I Installed it about a month ago (from RPM's) and php 4.4 as well the two were working together fine until this morning it would seem. Do you have a theory? Well, it's hard to say without a bit more detail. Are you able to give us the actual error that PHP is giving on the database connected pages? I assume you are using the mysqli functions rather than the mysql functions to access your database? Please remember to send replies to the list, there are other far more knowledgeable people out there who will be able to help too! Jasper -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Problem between php4.4 and mysql
M. Sokolewicz wrote: Jasper Bryant-Greene wrote: Well, it's hard to say without a bit more detail. Are you able to give us the actual error that PHP is giving on the database connected pages? I assume you are using the mysqli functions rather than the mysql functions to access your database? just in case you didn't know, mysqli wasn't available before PHP 5.0.0. The user states to be using PHP 4.4.x Apologies, didn't read his email properly. In that case, do you have MySQL set up to accept old passwords? The password-hashing function changed with MySQL 4.1, and the mysql PHP function uses the old function. Please remember to send replies to the list, there are other far more knowledgeable people out there who will be able to help too! Again, *please* send replies to the list as well, not just me! Jasper -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php