MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: eragorn on 2013-01-26, 16:51:23

Title: Could not open database connection anyway
Post by: eragorn on 2013-01-26, 16:51:23

hello
i dont know why and since when this problem made

when i enter myipaddress:7778 (even before login) i see a message that :
Could not open database connection.
(but style of kloxo completely loaded)
I think my problem relate to root password of mysql.
 

Quote

mustafaramadan said (http://forum.lxcenter.org/index.php?t=msg&th=15343&goto=79521&#msg_79521)
Run PHPMyAdmin and then click 'Priviliges'. Click action at 'koloxo' user. Click 'check all' at 'Global privileges' and type new password at 'Password'.

Or (from ssh):

Code: [Select]

mysql -u root -p
mysql> grant all on koloxo.* to koloxo@localhost identified by '{new password}';
mysql> flush privileges;
mysql> quit

End then (from ssh):

Code: [Select]

vi /usr/local/lxlabs/koloxo/etc/conf/koloxo.pass
replace with mysql password
sh /script/restartNote: change {new password} with your new password.

i do all of this works and when i run "sh /script/restart" at the end i see :

Code: [Select]

[root@unix ~]# sh /script/restart
Stopping koloxo: Waiting for the process to die.....
Stopped koloxo

Starting koloxo: 11
Could not open database connection.mysqld (pid 22496) is running...
Started koloxo

[/b]

can anyone help me  :cry:

Title: Re: Could not open database connection anyway
Post by: eragorn on 2013-01-26, 17:15:38

my site goes down now  :cry:  :cry:

 pleaaass some one help me

look at this terminal reply :

Code: [Select]

[root@unix ~]# sh /script/fixweb ; sh /script/fixphp ; sh /script/fixdns ; service nginx restart

- For help, type '/script/fixweb --help'
- No argument supplied. Defaulting to localhost (master) servers

Could not open database connection.
- For help, type '/script/fixphp --help'
- No argument supplied. Defaulting to localhost (master) servers

Could not open database connection.
- For help, type '/script/fixdns --help'
- No argument supplied. Defaulting to localhost (master) servers

Could not open .atabase connection

Title: Re: Could not open database connection anyway
Post by: Spacedust on 2013-01-26, 22:28:37

Try tail -f /var/log/mysqld.log

Title: Re: Could not open database connection anyway
Post by: Tsanten on 2013-01-27, 04:43:10

Already solved personally.
Permission all on user kloxo  database kloxo  and change password entering phpmyadmin put same pass on kloxo.pass restart mysql.All up and running.