Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2018-11-15, 07:26:50

Author Topic: Could not open database connection anyway  (Read 4791 times)

0 Members and 1 Guest are viewing this topic.

Offline eragorn

  • Junior Member
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Could not open database connection anyway
« 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
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/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 :
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:
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline eragorn

  • Junior Member
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Could not open database connection anyway
« Reply #1 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
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,962
  • Karma: +1/-0
    • View Profile
Re: Could not open database connection anyway
« Reply #2 on: 2013-01-26, 22:28:37 »
Try tail -f /var/log/mysqld.log
« Last Edit: 1970-01-01, 01:00:00 by Guest »

Offline Tsanten

  • Global Moderator
  • Junior Member
  • *****
  • Posts: 49
  • Karma: +0/-0
    • View Profile
Re: Could not open database connection anyway
« Reply #3 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.
« Last Edit: 1970-01-01, 01:00:00 by Guest »

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.064 seconds with 25 queries.

web stats analysis