mysql 3.23 -> mysql 4.0.14 renders ZM usless

[johnmiles79]

I upgraded mysql 3.2.3 to 4.0.14, ensured that PHP is working, ensured that phpMyAdmin is working, ensured that I can view the databases, ensured that the users in zm authentication exists.

In an attempt to load zm.php, it worked, until I rebooted the server, nowI receive a blank page when I attempt to load zm.php. and I cannot figure out what has happened. The incident occurs to my b2 blogger tool (although unrelated to this forum).

Would someone please offer any advice?

[zoneminder]

Hi John,

Does your phpmyadmin still work after a reboot? The reason I ask is that it may be that you would have to link php with the new mysql libraries unless it uses dynamic libraries. If you didn't restart apache before rebooting I expect it was probably still using the old image in memory. You could create a simple php file to test this, maybe call it debug.php and fill it in as follows,

<?php
phpinfo();
?>

then access it and see what it says about mysql.


That may not be the problem of course, was there anything in your web server error log to indicate any problems?

Regards,

Phil,

[zoneminder]

ps. What version of ZM are you running?

[johnmiles79]

yes, phpmyadmin works after reboot, and using the <? phpinfo(); ?> works as well.

I'm using zm 0.9.15

I really have no idea why this could happen, its very unusual.

What I've done is drop the entire ZM database and recreate it, and recompile ZM and still the problem occurs.

I do not even know where to begin to troubleshoot this. Currently my logs show nothing, infact the logs arn't showing anything becaues zoneminder cannot load.

[johnmiles79]

ok nevermind, the problem was solved by first recompiling all the perl modules.. (dbd::mysql, dbi, etc...) and then rebooting (yeah I had to reboot for some reason)