MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: redpages on 2013-04-09, 07:45:38

Title: Baru install Kloxo MR langsung "Could not open database.."
Post by: redpages on 2013-04-09, 07:45:38
Hallo kawan2..

Saya sudah sering berhasil install Kloxo tapi kenapa dari semalam hingga pagi ini hasil install kloxo (fresh) selalu mendapati 'Could not open database connection".
Saya sudah coba jalankan instruksi segala reset di "http://wiki.lxcenter.org/Change+Password+via+SSH". Tapi hasilnya sama. Saya reinstall VPS juga sama. Tak perlu saya sebutkan konfigurasi Kloxo karena problem tersebut sudah muncul sebelum saya setting macam2.

Biasanya saya cukup running "service kloxo restart" sudah berjalan, tapi ini tetap " 'Could not open database connection".

Mohon pencerahannya. kalau perlu saya bisa berikan user root vps nya. Sudah kadung putus asa :D
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-09, 10:04:14
Link anda salah. Itu link untuk Kloxo dan bukan untuk Kloxo-MR.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-09, 15:10:21
Quote from: "MRatWork"
Link anda salah. Itu link untuk Kloxo dan bukan untuk Kloxo-MR.

link di viewtopic.php?f=4&t=1660 (http://forum.mratwork.com/viewtopic.php?f=4&t=1660) juga sudah saya coba. tapi tetap.

Barusan saya install ulang (fresh/reinstall VPS) dan ternyata error sudah terjadi saat installasi tapi kloxo MR tetap menyatakan sukses. (attach).

Saya install di centos 5 32bit
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-09, 15:14:41
coba saja jalankan 'sh /script/reset-mysql-root-password; sh /script/cleanup'
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-09, 15:25:22
Quote from: "MRatWork"
coba saja jalankan 'sh /script/reset-mysql-root-password; sh /script/cleanup'

Sepertinya tidak berhasil. hasilnya spt ini :

Code: [Select]
login as: root
root@198.98.98.16's password:
Last login: Tue Apr  9 11:52:15 2013 from 125.164.135.108
[root@server20 ~]# sh /script/reset-mysql-root-password; sh /script/cleanup
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
Password unsuccessfully reset
*** Executing Update (cleanup) - BEGIN ***
Fix Database Issues
- Fix admin account database settings
- Set default database settings
- Fix resourceplan settings in database
- Alter some database tables to fit that of Kloxo
- Set default welcome text at Kloxo login page
- Remove default db password if exists
- Create flag dir
Fix IP Address
- Fix process
Fix Services
- Fix process
Create domain backup dirs
- Create process
- Create OS system user admin
- User admin exists
Set Watchdog defaults
- Set process
Fix MySQL root password
- Fix process
Set admin contact email
- Set process
Get Kloxo License info
- Get process
- Create database interface template (Forced)
Fix Self SSL
- Fix process
Prepare for Kloxo
- OS Create Kloxo init.d service file and copy core php.ini (lxphp)
- OS Fix programroot path permissions
- OS Restart Kloxo service
Check for bogofilter
- wordlist.db already exists
Initialize phpMyAdmin configfile
/script/cleanup: line 3: 20091 Terminated              lxphp.exe ../bin/common/c                                                                                        leanup.php
[root@server20 ~]# - phpMyAdmin: Set db password in configfile
Initialize OS admin account description
- Initialize process
Remove Old dirs
- Remove process
Initialize Some Binary files
- php-cgi binary already installed
- Symlink /usr/local/bin/php already exists
Remove lighttpd errorlog
- Remove process
Fix the secure logfile
- Fix process
Clean hosts.deny
- Clean process
Turn off mouse daemon
- Turn off process
Initialize Kloxo bind config files
- No need to initialize
Killing gettraffic system process
- Killing process
Checking for rpm packages
- For maildrop-toaster package
- For spamdyke package
- For spamdyke-utils package
- For pure-ftpd package
- For webalizer package
- For php-mcrypt package
- For dos2unix package
- For rrdtool package
- For xinetd package
- For lxjailshell package
- For php-xml package
- For libmhash package
- For lxphp package
Initialize /script/ dir
- Initialize processes
Install Kloxo service
- Install process
Installing jailshell to system
- Already exists
Set /home permission to 0755
- Set process
- chown apache:apache FOR /home/kloxo/httpd/ AND INSIDE
- chmod 644 FOR *.php* INSIDE /home/kloxo/httpd/
- chmod 755 FOR /home/kloxo/httpd/ AND INSIDE
- chmod 771 FOR /home/kloxo/httpd/
Initialize apache config
- /home/kloxo/httpd/apache dir already exists
- /etc/httpd/conf.d dir already exists
- /home/apache/tpl dir already exists
- /home/apache/conf dir already exists
- /home/apache/etc dir already exists
- /home/apache/etc/conf dir already exists
- /home/apache/etc/conf.d dir already exists
Copy all contents of apache
- Copy /usr/local/lxlabs/kloxo/file/apache to /home/apache
- Copy /home/apache/etc/conf.d/~lxcenter.conf to /etc/httpd/conf.d/~lxcenter.con                                                                                        f
- Copy /home/apache/etc/conf.d/ssl.conf to /etc/httpd/conf.d/ssl.conf
- Copy /home/apache/etc/conf/httpd.conf to /etc/httpd/conf/httpd.conf
- chown root:root FOR /home/apache/ AND INSIDE
Initialize lighttpd config
- /home/kloxo/httpd/lighttpd dir already exists
- /etc/lighttpd/conf.d dir already exists
- /home/lighttpd/tpl dir already exists
- /home/lighttpd/conf dir already exists
- /home/lighttpd/etc dir already exists
- /home/lighttpd/etc/conf dir already exists
- /home/lighttpd/etc/conf.d dir already exists
Copy all contents of lighttpd
- Copy /usr/local/lxlabs/kloxo/file/lighttpd to /home/lighttpd
- Copy /home/lighttpd/etc/conf.d/~lxcenter.conf to /etc/lighttpd/conf.d/~lxcente                                                                                        r.conf
- Copy /home/lighttpd/etc/conf.d/ssl.conf to /etc/lighttpd/conf.d/ssl.conf
- Copy /home/lighttpd/etc/conf/lighttpd.conf to /etc/lighttpd/lighttpd.conf
- chown root:root FOR /home/lighttpd/ AND INSIDE
Initialize nginx config
- /home/kloxo/httpd/nginx dir already exists
- /etc/nginx/conf.d dir already exists
- /home/nginx/tpl dir already exists
- /home/nginx/conf dir already exists
- /home/nginx/etc dir already exists
- /home/nginx/etc/conf dir already exists
- /home/nginx/etc/conf.d dir already exists
Copy all contents of nginx
- Copy /usr/local/lxlabs/kloxo/file/nginx to /home/nginx
- Copy /home/nginx/etc/conf.d/~lxcenter.conf to /etc/nginx/conf.d/~lxcenter.conf
- Copy /home/nginx/etc/conf/nginx.conf to /etc/nginx/nginx.conf
- chown root:root FOR /home/nginx/ AND INSIDE
- Install /etc/php-fpm.conf
- Copy php-fpm init to /etc/init.d dir
Initialize PureFtp service
- Initialize process
- Restart xinetd service for pureftp
Initialize Mail service
- Initialize process
Enable xinetd service
- Enable process
Fix suexec
- Fix process
Install/Fix Services/Permissions/Configfiles
- Create lxphp.exe Symlink
- Set permissions for /usr/bin/php-cgi
- Set permissions for closeallinput binary
- Set permissions for lxphpsu binary
- Set permissions for phpsuexec.sh script
- Set permissions for /home/kloxo/httpd/lighttpd/ dir
- Set permissions for /var/lib/php/session/ dir
- Set permissions for /var/bogofilter/ dir
- Kill sisinfoc system process
Initialize nobody.sh script
- Initialize process
Execute/remove/initialize/install script
- Execute lxpopuser.sh
- Remove /home/kloxo/httpd/script dir
- Initialize /home/kloxo/httpd/script dir
- Set ownership apache:apache for /home/kloxo/httpd/script dir
- Install phpinfo.php into /home/kloxo/httpd/script dir
Enable the correct drivers (Service daemons)
- Uninstall spam__spamassassin
- Uninstall dns__djbdns
- Uninstall web__lighttpd
- Uninstall web__nginx
Remove cache dir
- Remove process
Restart syslog service
- Restart process
Initialize awstats dirdata
- Initialize process
Initialize logrotate
Update Kloxo database
- Updating process
Preparing RoundCube database
- Mysql root password incorrect
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-09, 16:56:29
Kalau soal roundcube, coba 'sh /script/fixmail-all; sh /script/cleanup'.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-09, 17:56:43
Quote from: "MRatWork"
Kalau soal roundcube, coba 'sh /script/fixmail-all; sh /script/cleanup'.

Prosesnya berhenti lama di tahap "Preparing RoundCube database"

Code: [Select]
...
- Uninstall spam__spamassassin
- Uninstall dns__djbdns
- Uninstall web__lighttpd
- Uninstall web__nginx
Remove cache dir
- Remove process
Restart syslog service
- Restart process
Initialize awstats dirdata
- Initialize process
Initialize logrotate
Update Kloxo database
- Updating process
Preparing RoundCube database
- Mysql root password incorrect
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-09, 18:06:06
Masuk ke panel kemudian ganti password pada 'mysql password reset' dan kemudian jalankan 'sh /script/fixmail-all'.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-09, 18:29:55
Quote from: "MRatWork"
Masuk ke panel kemudian ganti password pada 'mysql password reset' dan kemudian jalankan 'sh /script/fixmail-all'.

SIP!! TERIMA KASIH  :D
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-09, 19:25:04
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: zenkul on 2013-04-10, 12:55:56
Quote from: "MRatWork"
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)

mohon ma'af Pak MR,

kalau membaca topik tsb, saya mendadak jadi buta huruf ..... tapi saya janji akan donasi $1 / Rp.10.000,- bila sudah memungkinkan.

salam hormat dari jombang
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-10, 15:25:46
Quote from: "zenkul"
Quote from: "MRatWork"
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)

mohon ma'af Pak MR,

kalau membaca topik tsb, saya mendadak jadi buta huruf ..... tapi saya janji akan donasi $1 / Rp.10.000,- bila sudah memungkinkan.

salam hormat dari jombang
Kalau cuma USD 5-10/tahun sudah cukup sekali. Ini untuk menunjang pengembangan Kloxo-MR itu sendiri (tentunya nanti akan ada yang lain-lain nanti).

Lama-lama kalau minus terus kan berat buat saya. Tidak perlu sampai lebih tapi cukup tutup ongkos saja.

Yang lebih utama malah bukan nilai uangnya tapi malah kesediakan menyumbang (seberapa besarpun itu) akan memberikan dukungan moral untuk meneruskan 'project' ini.

Setidaknya seperti LXCenter dimana semua resource (sewa servers dan license software) sudah ketutup dan atau ada sponsor sehingga tidak minus.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-13, 08:58:26
Quote from: "MRatWork"
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)

saya sudah kirim donasi, Confirmation number: 32A19929M0277205E. Insyallah kalau ada rejeki bulan depan saya akan kirim donasi lagi. Tetap jaya buat Kloxo MR.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: MRatWork on 2013-04-13, 13:44:42
Quote from: "redpages"
Quote from: "MRatWork"
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)

saya sudah kirim donasi, Confirmation number: 32A19929M0277205E. Insyallah kalau ada rejeki bulan depan saya akan kirim donasi lagi. Tetap jaya buat Kloxo MR.
Ada yang kirim dengan Confirmation number 30D88306HB0780150 dari email anda. Apa bukan ini?.
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: prandah on 2013-04-13, 13:53:04
OOT semua neh :)
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: redpages on 2013-04-13, 14:13:09
Quote from: "MRatWork"
Quote from: "redpages"
Quote from: "MRatWork"
Jangan lewat baca viewtopic.php?f=9&t=4495 (http://forum.mratwork.com/viewtopic.php?f=9&t=4495)

saya sudah kirim donasi, Confirmation number: 32A19929M0277205E. Insyallah kalau ada rejeki bulan depan saya akan kirim donasi lagi. Tetap jaya buat Kloxo MR.
Ada yang kirim dengan Confirmation number 30D88306HB0780150 dari email anda. Apa bukan ini?.

Rasanya bukan. Saya cek lagi: Donation Sent (Unique Transaction ID #32A19929M0277205E). Time: 08:54:57 GMT+07:00
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: zenkul on 2013-04-13, 14:31:48
Quote from: "goblog"
OOT semua neh :)

Hallo Om Prandah

Status isu memang sudah  :   fixed   ยป closed (fixed)

dan sekarang tinggal OOT-nya

BTW, selamat anak-nya ternyata sudah di-banca'i (kenduri adat jowo), selamat ya  :?:
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: prandah on 2013-04-13, 17:32:56
Aih kok werruh :)
Title: Re: Baru install Kloxo MR langsung "Could not open database.
Post by: zenkul on 2013-04-13, 17:42:19
Quote from: "goblog"
Aih kok werruh :)

iya dong, karena sudah di-trawang sama Eyang "Subur"
hehehehe ....... salam