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-03-28, 12:31:43

Author Topic: <HELP>Error establishing a database connection  (Read 6149 times)

0 Members and 1 Guest are viewing this topic.

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
<HELP>Error establishing a database connection
« on: 2014-03-01, 00:05:10 »
Pak kok ketika mau login ke kloxo tulisannya "Error establishing a database connection" knapa yah?
udah reboot vps, run cleanup, fix-all, n juga restart all tp tetep  eror.
berikut sysinfonya:
Quote

A. Kloxo-MR: 6.5.0.f-2014020301

B. OS: CentOS release 6.5 (Final) x86_64

C. Apps:
   1. MySQL: mysql-5.5.34-1.el6.x86_64
   2. PHP: php53u-5.3.28-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.26-2.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.5.10-2.el6.x86_64
   6. Qmail: qmail-toaster-1.03-1.3.35.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
   7. Dns: bind-9.9.5-1.el6.x86_64

D. Php-type (for Httpd/proxy): php-fpm_worker

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1024        300        723          0          0        121
   -/+ buffers/cache:        179        844
   Swap:         1024          0       1024


Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #1 on: 2014-03-01, 03:49:42 »
Ada masalah di mysql. Coba jalankan 'sh /script/restart-all'.

Jika tetap tidak bisa, coba jalan 'sh /script/reset-mysql-root-password PASSWORDANDA'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #2 on: 2014-03-01, 04:52:30 »
udah coba jalankan 'sh /script/restart-all' dan 'sh /script/reset-mysql-root-password PASSWORDANDA', bahkan d reboot tapi masih eror gimana pak?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #3 on: 2014-03-01, 04:59:31 »
Jangan-jangan databasenya 'rusak'.

Coba jalankan 'sh /script/mysql-optimize --select=repair'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #4 on: 2014-03-01, 05:22:04 »
Masih pak
oia kalo di "sh /script/cleanup"
ada yg fail pas restart services
Quote
*** Restart services - BEGIN ***
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
Stopping named: .                                          [  OK  ]
Starting named:                                            [  OK  ]
Stopping httpd:                                            [FAILED]
Starting httpd: (98)Address already in use: make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
                                                           [FAILED]
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
Stopping nginx:.                                           [  OK  ]
Starting nginx:                                            [  OK  ]
Stopping qmail-toaster: svscan qmail logging.
qmail-send: no process killed
Starting qmail-toaster: svscan.
Stopping xinetd:                                           [  OK  ]
Starting xinetd:                                           [  OK  ]
Stopping kloxo-phpcgi:                                     [  OK  ]
Starting kloxo-phpcgi:                                     [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]
Stopping php-fpm:                                          [  OK  ]
Starting php-fpm:                                          [  OK  ]
*** Restart services - END ***
« Last Edit: 2014-03-01, 05:59:32 by ar1246 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #5 on: 2014-03-01, 06:30:02 »
Httpd tidak mau di-stop dalam proses restart-all. Coba 'service httpd stop; sh /script/restart-all'. Jika tidak mempan juga, direboot.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #6 on: 2014-03-01, 09:35:28 »
Httpd tidak mau di-stop dalam proses restart-all. Coba 'service httpd stop; sh /script/restart-all'. Jika tidak mempan juga, direboot.

kalo httpd udah ok. tp masih ada "Error establishing a database connection"
udah di reboot, restart servicenya, tapi tetep aja eror
kira kira apanya pak?
di install ulang pasti lancar lg, tapi gk bakalan tau penyebab erornya, masa ntar kalo gini lg harus di inul lg. :-\
« Last Edit: 2014-03-01, 10:08:14 by ar1246 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #7 on: 2014-03-01, 10:46:37 »
coba anda convert mysql anda ke myisam storage-engine dengan 'sh /script/mysql-convert --engine=myisam'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #8 on: 2014-03-01, 12:16:57 »
masih eror pak  :(
knp yah

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #9 on: 2014-03-01, 12:57:48 »
Anda lihat saja isi /var/log/mysql.log.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #10 on: 2014-03-01, 23:23:13 »
nyerah pak  :(
inul aja deh, cz keadaan darurat  :D

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: <HELP>Error establishing a database connection
« Reply #11 on: 2014-03-02, 02:22:48 »
Setelah reinstall jalankan 'sh /script/mysql-convert --engine=myisam' agar hemat memory dan lebih mudah di-maintain jika punya masalah di mysql.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline ar1246

  • Senior Member
  • *
  • Posts: 271
  • Karma: +0/-0
  • Gender: Male
    • View Profile
    • Web Hosting | Web Design Murah
Re: <HELP>Error establishing a database connection
« Reply #12 on: 2014-03-02, 03:24:08 »
ok siap pak

 


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

Page created in 0.07 seconds with 21 queries.

web stats analysis