MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: ar1246 on 2014-03-01, 00:05:10

Title: <HELP>Error establishing a database connection
Post by: ar1246 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

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork 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'.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 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?

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork on 2014-03-01, 04:59:31

Jangan-jangan databasenya 'rusak'.

Coba jalankan 'sh /script/mysql-optimize --select=repair'.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 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 ***

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork 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.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 on 2014-03-01, 09:35:28

Quote from: MRatWork 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.

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. :-\

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork on 2014-03-01, 10:46:37

coba anda convert mysql anda ke myisam storage-engine dengan 'sh /script/mysql-convert --engine=myisam'.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 on 2014-03-01, 12:16:57

masih eror pak  :(
knp yah

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork on 2014-03-01, 12:57:48

Anda lihat saja isi /var/log/mysql.log.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 on 2014-03-01, 23:23:13

nyerah pak  :(
inul aja deh, cz keadaan darurat  :D

Title: Re: <HELP>Error establishing a database connection
Post by: MRatWork 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.

Title: Re: <HELP>Error establishing a database connection
Post by: ar1246 on 2014-03-02, 03:24:08

ok siap pak