MRatWork Forum by Mustafa Ramadhan
Language Specific Discussions => Indonesia Users => Topic started by: Radiit on 2016-03-16, 09:57:17
-
Mohon bantuanya master2 saya ga bisa login ke kloxo awalnya gara2 keapus mysql terus saya instal lg dan ternyata malah ga bisa login ke master adminnya. saya coba convert ke mariaDB "sh /script/mysql-to-mariadb" hasilnya webnya yang terinstal di vps jalan normal tapi masalahnya cuma ga bisa login ke kloxonya. Tolong bantuanya donk
-
Sudah dicoba jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA'?.
Jika tidak beres juga, coba Kloxo-MR di-reinstall dengan 'sh /script/upcp -y'. Setelah reinstall perlu dilakukan lagi re-configure di 'switch programs' dan 'webserver configure'.
-
Sudah dicoba jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA'?.
Jika tidak beres juga, coba Kloxo-MR di-reinstall dengan 'sh /script/upcp -y'. Setelah reinstall perlu dilakukan lagi re-configure di 'switch programs' dan 'webserver configure'.
sh /script/reset-mysql-root-password PASSWORDANDA
Hasilnya
Notice : The resource you have requested doesn't exist. The server returned the error message: <br> only_admin_can_modify_general nname <br>
sh /script/upcp -y
Hasilnya ada eror
Create mysql.sock...
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
ERROR! MySQL server PID file could not be found!
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Starting MySQL. ERROR!
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Setting Mysql for always running after reboot and restart now...
Warning: skipping '!includedir /etc/my.cnf.d' directive as maximum includerecursion level was reached in file /etc/my.cnf.d/my.cnf at line 10
Starting MySQL. ERROR!
Belum bsa login ke 7778 mod.
-
Anda pakai Kloxo-MR 6.5 atau 7.0?. Infokan 'sh /script/sysinfo'.
-
Anda pakai Kloxo-MR 6.5 atau 7.0?. Infokan 'sh /script/sysinfo'.
Pake Kloxo versi 7.0
sh /script/sysinfo
cat: /etc/rc.d/init.d/php-fpm: No such file or directory
*** Please wait...***
A. Control Panel:
- Kloxo-MR: 7.0.0.b-2016030202
- Web: hiawatha-10.1.0-f.6.mr.el6.x86_64
- PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
- OS: CentOS release 6.7 (Final) x86_64
- Hostname: signsdiabetes.org
C. Services:
1. MySQL: MariaDB-server-10.0.24-1.el6.x86_64
2. PHP:
- Branch: php54-cli-5.4.45-1.ius.el6.x86_64
- Used: --Use PHP Branch--
3. Web Used:
- Hiawatha: --unused--
- Lighttpd: --uninstalled--
- Nginx: --uninstalled--
- Httpd: httpd-2.2.31-1.mr.el6.x86_64
- PHP Type: [unknown]
4. WebCache:
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns:
- Bind: bind-9.9.7-1.mr.el6.x86_64
- DJBDns: --uninstalled--
- NSD: --uninstalled--
- PowerDNS: --uninstalled--
- Yadifa: --uninstalled--
6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
- pop3/imap4: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
- spam:
D. Memory:
total used free shared buffers cached
Mem: 2048 109 1938 2 0 44
-/+ buffers/cache: 64 1983
Swap: 2048 0 2048
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/simfs 80G 5.0G 76G 7% /
*** Process Time: 00:00:00:02.2543 (dd:hh:mm:ss:xxxxxx) ***
* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
(importance after Kloxo-MR update)
-
Coba hapus dengan 'rm -f /etc/my.cnf.d/my.cnf'
-
Coba hapus dengan 'rm -f /etc/my.cnf.d/my.cnf'
Hasilnya erornya hilang tapi web skrng ga bisa diakses dan 7778 masih blum bsa login.
saya coba 'sh/ script/cleanup' ternyata ada eror
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
-
Coba 'sh /script/mysql-optimize --select=upgrade'.
-
Coba 'sh /script/mysql-optimize --select=upgrade'.
Hasilnya
Mysql Check/Repair/Optimize/Upgrade
- Upgrading database
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
FATAL ERROR: Upgrade failed
- MySQL Service restart
-
Jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA; sh /script/mysql-optimize --select=upgrade'. Ganti 'PASSWORDANDA' dengan password yang anda inginkan.
-
Jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA; sh /script/mysql-optimize --select=upgrade'. Ganti 'PASSWORDANDA' dengan password yang anda inginkan.
Hasilnya jalan lancar semua gak ada eror tp blm bsa masuk juga ke 7778.
-
Coba anda ganti password panel dengan 'sh /script/resetpassword master PASSWORDANDA'.
-
Coba anda ganti password panel dengan 'sh /script/resetpassword master PASSWORDANDA'.
Hsilnya gini pak.
Notice : The resource you have requested doesn't exist. The server returned the error message: <br> only_admin_can_modify_general nname <br>
-
Hmm. Aneh.
Coba beri saya akses ke ssh dan Kloxo-MR panel anda. Kirim via PM.
-
Hmm. Aneh.
Coba beri saya akses ke ssh dan Kloxo-MR panel anda. Kirim via PM.
dah saya kirim yah
-
Masalah terjadi karena ada kerusakan dari database kloxo.
Langkah perbaikan:
1. Merubah nama kloxo database dari kloxo ke kloxoold
2. Install ulang kloxo-mr dengan 'sh /script/upcp -y'
3. Import data 'self backup' tanggal 15 (karena yang tanggal 16 rusak)
4. jalankan 'sh /script/cleanup'
5. reboot
-
Masalah terjadi karena ada kerusakan dari database kloxo.
Langkah perbaikan:
1. Merubah nama kloxo database dari kloxo ke kloxoold
2. Install ulang kloxo-mr dengan 'sh /script/upcp -y'
3. Import data 'self backup' tanggal 15 (karena yang tanggal 16 rusak)
4. jalankan 'sh /script/cleanup'
5. reboot
iIssued sloved . thanks master.