mysql problem

[WarezFreaks]

I upgraded my mysql and after the upgrade my whole site did not work anymore. And with that I mean my browser could not connect to my site.

I upgraded it via webhost manager and my current (upgraded) version is 5.1.51

Any idea on how to fix this problem?

WarezFreaks Reviewed by WarezFreaks on 1st Nov 2010. mysql problem I upgraded my mysql and after the upgrade my whole site did not work anymore. And with that I mean my browser could not connect to my site. I upgraded it via webhost manager and my current (upgraded) version is 5.1.51 Any idea on how to fix this problem? Rating: 5

[desiboy]

restart mysql deamon ,if you are good in ssh or you can restart it from whm as well .

[WarezFreaks]

I restarted mysql via whm twice now but without any result.

[vgnheart]

what error u got while restarting mysql ?

do u have any firewall installed ?

tried restarting apache ?


Note : if its just mysql error. then port 80 will work correctly.and u will be getting db error on forum. but here port 80 not responding at all. so apache screwed or firewall blocking

[desiboy]

and what did you get after restarting ? any error ?
check the logs files
var/lib/mysql/$(hostname).err

it will have some useful info .. also /var/cpanel/updatelogs/update contains logs on the update process. so checking it will give ,some useful info to debug.

if your whole site is not working, then I think Apache is not working ..
even restart it ..

[WarezFreaks]

I did not get any error, after upgrading my site was just gone.

[desiboy]

dude, if only MYSQL is not working, your site/script will give error that it's unable to connect to mysql server ..
so I think even apache is not working.. so check its status, restart it..

[WarezFreaks]

when I tried to restart apache I got this error:

Apache restart failed. Unable to load pid from pid file and no httpd process found in process list.

If apache restart reported success but it failed soon after, it may be caused by oddities with mod_ssl.

You should run /scripts/ssl_crt_status as part of your troubleshooting process. Pass it --help for more details.

Also be sure to examine apache's variouse log files.
Apache Restart Output:
httpd: Syntax error on line 42 of /usr/local/apache/conf/httpd.conf: Syntax error on line 9 of /usr/local/apache/conf/php.conf: Cannot load /usr/local/apache/modules/libphp5.so into server: /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/apache/modules/libphp5.so)

[desiboy]

looks like php and mysql modules are not installed properly ..
simple solution ,as your using whm : just recompile apache with desired php modules..

[WarezFreaks]

and how do I know what php modules I need/check ?