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
-
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.
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):
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):
vi /usr/local/lxlabs/koloxo/etc/conf/koloxo.pass
replace with mysql password
sh /script/restart
Note: 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 :
[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:
-
my site goes down now :cry: :cry:
pleaaass some one help me
look at this terminal reply :
[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
-
Try tail -f /var/log/mysqld.log
-
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.