[ASK] Mengembalikan Database yang terhapus di Kloxo-MR


bijikopi

bijikopi

Beginner 1.0
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
Click to expand...
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.
Click to expand...

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 ~]#
Click to expand...
Terima kasih sebelumnya, ditunggu saran sarannya Tuan :)
 
bijikopi said:
Assalamualaikum sodara sodara DWH, semoga sehat selalu untuk anda semua :)
Mau nanya nih, jadi ceritanya beberapa saat yang lalu saya mengalami error data login
Click to expand...
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)

bijikopi said:
localhost doesn't have parent_clname
Error - no authentication database connection. Initial open.
Click to expand...
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
 
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 :confused:
 
bijikopi said:
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 :)
Click to expand...

waalaikumussalaam warahmatullaah wabarakaatuh

Jalankan ini dulu :
Code: 
sh /script/resetpassword master PASSWORDANDA

setelah itu baru reinstall Kloxo-MR anda :
Code: 
sh /script/upcp -y
 
Milea Adnan said:
waalaikumussalaam warahmatullaah wabarakaatuh

Jalankan ini dulu :
Code: 
sh /script/resetpassword master PASSWORDANDA

setelah itu baru reinstall Kloxo-MR anda :
Code: 
sh /script/upcp -y
Click to expand...

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:22: 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 ~]#
Click to expand...
 
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 ~]#
Click to expand...
 
update setelah mengulangi step step diatas, kembali start dari :
sh /script/resetpassword master PASSWORDANDA
Click to expand...
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) ...
Click to expand...

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
Click to expand...
 
last update 17 month ago di repo nya
nunggu dev nya muncul disini aja :D
 
You must log in or register to reply here.
Back
Top