[ASK] Mengembalikan Database yang terhapus di Kloxo-MR

[bijikopi]

Assalamualaikum sodara sodara DWH, semoga sehat selalu untuk anda semua
Mau nanya nih, jadi ceritanya beberapa saat yang lalu saya mengalami error data login, baca baca thread di sana sini akhirnya saya putusin reset dengan perintah :

sh /script/upcp -y

Proses jalan, sampai nemu error berikut :

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62
Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116
Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48
Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106
Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106
localhost doesn't have parent_clname
Error - no authentication database connection. Initial open.

Hasil "sh /script/sysinfo" :

[root@bijikopi ~]# sh /script/sysinfo
Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: implode(): Invalid arguments passed in /usr/local/lxlabs/kloxo/bin/fix/sysinfo.php on line 219

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Getobject Created the general admin object fresh in client-admin ...


/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:1073: debugBacktrace()<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:1893: initObjectIfUndef(general)<br>
/usr/local/lxlabs/kloxo/bin/fix/sysinfo.php:304: getObject(general)<br>


A. Control Panel:
- Kloxo-MR: 7.0.0.c-2019070501
- Web: hiawatha-10.9.0-f.2.mr.el7.x86_64
- PHP: php56s - 5.6.40-1.ius.el7 (fpm mode)
B. Plateform:
- OS: CentOS Linux release 7.7.1908 (Core) x86_64
- Hostname: bijikopi
C. Services:
1. MySQL: MariaDB-server-10.0.38-1.el7.centos.x86_64
2. PHP:
- Installed:
- Branch: php56u-cli-5.6.40-1.ius.el7.x86_64
- Multiple:
* php54m - 5.4.45-14.mr.el7
* php55m - 5.5.38-1.ius.el7
* php56m - 5.6.40-1.ius.el7
* php70m - 7.0.33-1.ius.el7
* php71m - 7.1.33-1.el7.ius
* php72m - 7.2.26-1.el7.ius
* php73m - 7.3.13-1.el7.ius
- Used: php73m-fpm
- Multiple: enable
3. Web Used: apache
- Hiawatha: hiawatha-10.9.0-f.2.mr.el7.x86_64
- Lighttpd: lighttpd-1.4.54-1.el7.x86_64
- Nginx: nginx-1.19.6-1.el7.ngx.x86_64
- Apache: httpd24u-2.4.46-1.el7.ius.x86_64
- PHP Type: php-fpm_event (default)
- Secondary PHP: on
4. WebCache: none
- ATS: --uninstalled--
- Squid: --uninstalled--
- Varnish: --uninstalled--
5. Dns: bind
- Bind: bind-9.9.9-1.mr.el7.x86_64
- DJBDns: djbdns-1.05-17.4.mr.el7.x86_64
- NSD: nsd-4.2.4-1.el7.x86_64
- PowerDNS: pdns-4.1.14-1.el7.x86_64
- Yadifa: yadifa-2.3.11-1.el7.x86_64
6. Mail: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
- pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el7.x86_64
- smtp: qmail-toaster-1.03-1.3.57.mr.el7.x86_64
- spam: bogofilter-1.2.5-1.el7.x86_64
7. FTP: pure-ftpd
- pure-ftpd: pure-ftpd-1.0.49-1.mr.el7.x86_64
8. Stats: awstats
- awstats: kloxomr-stats-awstats-7.7-1.mr.noarch
D. Memory:
total used free shared buff/cache available
Mem: 8388607 279 8379876 53 8451 8388244
Swap: 0 0 0
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/simfs 20G 16G 4.9G 76% /


*** Process Time: 00:00:00:22.22929 (dd:hh:mm:ss:xxxxxx) ***

* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
(importance after Kloxo-MR update)

[root@bijikopi ~]#

Terima kasih sebelumnya, ditunggu saran sarannya Tuan

 

[pluto01]

Assalamualaikum sodara sodara DWH, semoga sehat selalu untuk anda semua
Mau nanya nih, jadi ceritanya beberapa saat yang lalu saya mengalami error data login

Wa'alaikumssalam Wr Wb
Betul kloxo-mr sistem loginnya di database

Sepertinya sh /script/upcp -y ini untuk proses upgrade yach ?
Jika coba sh /script/fixall bagaimana (seingat saya dulu waktu pernah pakai ini berfungsi untuk auto fix issue yang ada dalam system)

localhost doesn't have parent_clname
Error - no authentication database connection. Initial open.

Jika dari info ini sepertinya databasenya tidak berjalan dengan baik karena ada file yang tidak ditemukan (Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in )
Coba dicheck baris yang dinformasikan apakah yang dia butuhkan di sana?

Forumnya : https :// forum.mratwork.com

 

[bijikopi]

Iya Tuan, sudah saya coba sh /script/fix-all, pertamanya semua aplikasinya itu ter uninstalled, pas browsing di forum ketemu tread yg hampir mirip kasus yg saya alami, baru nyoba jalanin sh /script/upcp -y, hasilnya semua terestore kecuali database mysql nya, pas saya coba buka satu2, di (Warning: mysqli::mysqli(): (HY000/2002): No such file or directory ) ada file nya tapi pas saya buka ga ada command di script nya

 

[pluto01]

Tidak ada maksudnya isi filenya kosong atau ?
Jika emang filenya ada, kalau tidak salah kloxo-mr ada fix permissionya juga tapi tidak ingat perintah lengkapnya, mungkin bisa dicoba

 

[bijikopi]

Masih ada file nya, cuma ga ada isi sama sekali, sudah coba fix-permission jg masih sama Tuan

 

[Milea Adnan]

Assalamualaikum sodara sodara DWH, semoga sehat selalu untuk anda semua
Mau nanya nih, jadi ceritanya beberapa saat yang lalu saya mengalami error data login, baca baca thread di sana sini akhirnya saya putusin reset dengan perintah :

Proses jalan, sampai nemu error berikut :


Hasil "sh /script/sysinfo" :

Terima kasih sebelumnya, ditunggu saran sarannya Tuan

waalaikumussalaam warahmatullaah wabarakaatuh

Jalankan ini dulu :

sh /script/resetpassword master PASSWORDANDA

setelah itu baru reinstall Kloxo-MR anda :

sh /script/upcp -y

 

[bijikopi]

waalaikumussalaam warahmatullaah wabarakaatuh

Jalankan ini dulu :

sh /script/resetpassword master PASSWORDANDA

setelah itu baru reinstall Kloxo-MR anda :

sh /script/upcp -y

hasilnya seperti ini :

[root@bijikopi ~]# sh /script/resetpassword master **************

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Getobject Created the general admin object fresh in client-admin ...


/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:1073: debugBacktrace()<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:1893: initObjectIfUndef(general)<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:380: getObject(general)<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:738: doCustomAction()<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:856: syncEntireObject()<br>
/usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php:887: doWas()<br>
/usr/local/lxlabs/kloxo/bin/common/resetpassword.php was()<br>


Notice: Undefined property: General::$customaction_b in /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php on line 380

Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

doing the real sync this admin on server localhost


Warning: mysqli::mysqli(): (HY000/2002): No such file or directory in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 62

Warning: mysqli::query(): Couldn't fetch mysqli in /usr/local/lxlabs/kloxo/httpdocs/lib/php/sqlitelib.php on line 116

Warning: Invalid argument supplied for foreach() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 48

Notice: Undefined index: localhost in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Notice: Trying to get property of non-object in /usr/local/lxlabs/kloxo/httpdocs/lib/php/gbllib.php on line 106

Fatal error: Uncaught exception 'lxException' with message 'only_admin_can_modify_general' in /usr/local/lxlabs/kloxo/httpdocs/lib/php/generallib.php:177
Stack trace:
#0 /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php(742): General->createExtraVariables()
#1 /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php(775): Lxclass->syncEntireObject()
#2 /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php(856): Lxclass->syncEntireObject()
#3 /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxclass.php(887): Lxclass->doWas()
#4 /usr/local/lxlabs/kloxo/bin/common/resetpassword.php(22): Lxclass->was()
#5 {main}
thrown in /usr/local/lxlabs/kloxo/httpdocs/lib/php/generallib.php on line 177
[root@bijikopi ~]#

 

[bijikopi]

untuk hasil sh /script/upcp -y :

[root@bijikopi ~]# sh /script/upcp -y
-------------------------------------------------------------------
WARNING:
- Need change hostname with qualify to FQDN
(use 'server1.domain.com' instead 'server1')
- May trouble for web and mail without FQDN hostname
-------------------------------------------------------------------
- For OpenVZ VPS, change hostname from VPS panel
- For Others, change 'HOSTNAME' in '/etc/sysconfig/network' file
- Reboot after change hostname

[root@bijikopi ~]#

 

[bijikopi]

update setelah mengulangi step step diatas, kembali start dari :

sh /script/resetpassword master PASSWORDANDA

hasilnya masih sama, mengalami kendala di sini Tuan :

*** Execute Update (cleanup) - END ***
>>> Create slavedb_driver <<<
>>> Creating Vpopmail database <<<
Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
>>> Fix Vpopmail settings <<<
>>> Prepare 'defaults' paths <<<
>>> Setup default configure for Webserver <<<
Error - no authentication database connection. Initial open.
- Fix ftp-all services
- Fix skeleton services
- Fix Hiawatha service
*** Execute Update (cleanup) - END ***

... Wait until finished (restart services) ...

sepertinya ada masalah waktu penginstallan paket mariadb :

MariaDB-client x86_64 10.0.38-1.el7.centos mratwork-mariadb 10 M
MariaDB-common x86_64 10.0.38-1.el7.centos mratwork-mariadb 43 k

 

[idnix]

last update 17 month ago di repo nya
nunggu dev nya muncul disini aja