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. 2024-05-10, 00:49:39

Author Topic: On every reboot I get 'Could not open database connection'  (Read 7444 times)

0 Members and 1 Guest are viewing this topic.

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Since I switched to mariadb on every reboot I get 'Could not open database connection' when acces kloxo-MR panel. The same when loading the websites.

The only way to recover is to use this commands on every restart :

[root@trader ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@trader ~]# kloxo service restart
-bash: kloxo: command not found
[root@trader ~]# /etc/init.d/mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@trader ~]# sh /script/restart
Stopping kloxo-phpcgi:                                     [FAILED]
Starting kloxo-phpcgi:                                     [  OK  ]
Stopping kloxo-hiawatha:                                   [FAILED]
Starting kloxo-hiawatha:                                   [  OK  ]
[root@trader ~]# sh /script/restart
Stopping kloxo-phpcgi:                                     [  OK  ]
Starting kloxo-phpcgi:                                     [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]


I have used bellow steps to update mysql to mariadb but fail on step 3 because first file was/is not present on my server:

Code: [Select]
1. Change /etc/yum.repos.d/kloxo-mr.repo:

from:
Code:
[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/$releasever/$basearch/
mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* mariadb*

to:
Code:
[kloxo-mr-centalt]
name=Kloxo-MR - centalt - $basearch
baseurl=http://centos.alt.ru/repository/centos/$releasever/$basearch/
mirrorlist=http://rpms.potissima.com/repo/mirrors/centalt-centos-$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl*


2. Run:
yum clean all
yum update

3. copy '/etc/my.cnf.rpmsave' to '/etc/my.cnf.d/my.cnf'.


4. Restart mysql with 'service mysqld restart'.


How can I solve this problem now ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: On every reboot I get 'Could not open database connectio
« Reply #1 on: 2013-08-26, 00:43:40 »
Try 'chkconfig mysqld on; service mysql restart'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #2 on: 2013-08-26, 00:54:57 »
Imediatelly after reboot:
Code: [Select]
chkconfig mysqld on; service mysql restart
mysql: unrecognized service
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #3 on: 2013-08-26, 00:57:59 »
I just reboot it and none of the above commands makes to errror go away, '/usr/local/lxlabs/kloxo/etc/conf/kloxo.pass' content changes for no reason and I need to change it to mysql pass in order for error to be gone but the error  'Could not open database connection' comes back on next reboot.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #4 on: 2013-08-26, 01:11:53 »
It looks like the error is gone, I didn't do anything but to change 'kloxo.pass' content with mysql pass which I already did it once 20 mintes ago with error coming back on reboot. I don't understand why the content of 'kloxo.pass' is changed after reboot . What test/fix commands should I make via SSH in order to check if everything is fine and fix any problems, I don't want this problem to come back :roll:
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: On every reboot I get 'Could not open database connectio
« Reply #5 on: 2013-08-26, 01:46:13 »
Sorry 'chkconfig mysqld on; service mysqld restart'
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #6 on: 2013-08-26, 04:10:49 »
Thank you.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #7 on: 2013-08-26, 05:22:35 »
I just reboot it the server and when I tried to acces panel on browser:  'Kloxo-MR: error 503 found!' .

Need to to that->

]# service kloxo restart
Stopping kloxo-phpcgi:                                     [FAILED]
Starting kloxo-phpcgi:                                     [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]


Reboot it again and nothing wrong..

Is my Panel broken ?
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: On every reboot I get 'Could not open database connectio
« Reply #8 on: 2013-08-26, 16:44:44 »
IF you found after reboot, kloxo not running run 'chkconfig kloxo on'.

Sometimes, services not running well without 'chkconfig on'.
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline crossing

  • Senior Member
  • *
  • Posts: 336
  • Karma: +0/-0
    • View Profile
Re: On every reboot I get 'Could not open database connectio
« Reply #9 on: 2013-08-26, 16:50:22 »
That's great, thank you for your support :) .
« Last Edit: 1970-01-01, 01:00:00 by Guest »
Kloxo-MR -> Great Panel ->  Great person behind it ->  Mustafa

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.043 seconds with 22 queries.

web stats analysis