MRatWork Forum by Mustafa Ramadhan
Language Specific Discussions => Indonesia Users => Topic started by: ryanita on 2015-11-21, 14:51:03
-
Dear rekan2, para senior kloxo mr...mohon bantuannya....vps saya selalu masalah "Could not connect: Connection refused" saya sudah update dengan versi terbaru....ketika msql direstar Ok akan tetapi sekitar 30- 1 jam kembali lagi "Could not connect: Connection refused"
Nb: ketika saya memakai kloxo 6.5 tidak ada masalah....
Mohon bantuan dan pencerahannya....
terimakasih sebelum dan sesudahnya
Berikut sysinfo
A. Kloxo-MR: 7.0.0.b-2015103001
- Web: hiawatha-9.15.0-f.6.mr.el6.i686
- PHP: php54s-5.4.45-1.ius.el6 (cgi mode)
B. Plateform:
- OS: CentOS release 6.7 (Final) i686
- Hostname: insyaallah
C. Services:
1. MySQL: MariaDB-server-10.0.22-1.el6.i686
2. PHP:
- Branch: php54-cli-5.4.45-1.ius.el6.i686
- Multiple:
* php52m-5.2.17-102.mr.el6
* php53m-5.3.29-1.ius.el6
* php54m-5.4.45-1.ius.el6
* php55m-5.5.30-1.ius.el6
* php56m-5.6.15-1.ius.el6
- Used: --Use PHP Branch--
3. Httpd: httpd-2.2.31-1.mr.el6.i386
- PHP Type: php-fpm_event
4. Lighttpd: --uninstalled--
5. Hiawatha: --unused--
6. Nginx: nginx-1.9.7-1.el6.ngx.i386
7. Cache: --uninstalled--
8. Dns: nsd-4.1.6-1.mr.el6.i686
9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
- with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
D. Memory:
total used free shared buffers cached
Mem: 498 488 10 27 4 52
-/+ buffers/cache: 431 67
Swap: 0 0 0
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/vda1 20G 2.5G 17G 14% /
-
Coba:
sh /script/reset-mysql-root-password PASSWORDBARU
mysql_upgrade --user=root --password=PASSWORDBARU
-
muncul error pak
Version check failed. Got the following error when calling the 'mysql' command l ine client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib /mysql/mysql.sock' (111 "Connection refused")
FATAL ERROR: Upgrade failed
-
ok setalh di restar all dan kemudian dijalankan
sh /script/reset-mysql-root-password PASSWORDBARU
mysql_upgrade --user=root --password=PASSWORDBARU
semuanya Ok akan tetapi setelah 30 menit kembali seperti semula pak "Could not connect: Connection refused"
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Phase 2/6: Fixing views
Phase 3/6: Running 'mysql_fix_privilege_tables'
Phase 4/6: Fixing table and database names
Phase 5/6: Checking and upgrading tables
Processing databases
information_schema
kirez_kirez
kirez_kirez.oc_comment OK
kirez_kirez.oc_options OK
kirez_kirez.oc_posts OK
kirez_kirez.oc_report OK
kirez_kirez.oc_search OK
kirez_kirez.oc_terms OK
kirez_kirez.oc_users OK
kloxo
kloxo.actionlog OK
kloxo.addondomain OK
kloxo.allowedip OK
kloxo.anonftpipaddress OK
kloxo.aspnet OK
kloxo.autoresponder OK
kloxo.auxiliary OK
kloxo.blockedip OK
kloxo.client OK
kloxo.clienttemplate OK
kloxo.component OK
kloxo.cron OK
kloxo.customaction OK
kloxo.custombutton OK
kloxo.davuser OK
kloxo.dbadmin OK
kloxo.dirprotect OK
kloxo.dns OK
kloxo.dnsslave OK
kloxo.dnstemplate OK
kloxo.domain OK
kloxo.domaindefault OK
kloxo.domainipaddress OK
kloxo.domaintemplate OK
kloxo.domaintraffic OK
kloxo.driver OK
kloxo.firewall OK
kloxo.ftpuser OK
kloxo.general OK
kloxo.genlist OK
kloxo.hostdeny OK
kloxo.installsoft OK
kloxo.interface_template OK
kloxo.ipaddress OK
kloxo.jailed OK
kloxo.license OK
kloxo.llog OK
kloxo.loginattempt OK
kloxo.lxbackup OK
kloxo.lxguard OK
kloxo.lxguardhit OK
kloxo.lxguardwhitelist OK
kloxo.lxupdate OK
kloxo.mailaccount OK
kloxo.mailfilter OK
kloxo.mailforward OK
kloxo.mailinglist OK
kloxo.mimetype OK
kloxo.mmail OK
kloxo.module OK
kloxo.mssqldb OK
kloxo.mssqldbuser OK
kloxo.mysqldb OK
kloxo.mysqldbuser OK
kloxo.ndskshortcut OK
kloxo.ndsktoolbar OK
kloxo.notification OK
kloxo.odbc OK
kloxo.phpini OK
kloxo.proxy OK
kloxo.proxyacl OK
kloxo.pserver OK
kloxo.rdnsrange OK
kloxo.resourceplan OK
kloxo.reversedns OK
kloxo.rubyrails OK
kloxo.serverftp OK
kloxo.servermail OK
kloxo.serverspam OK
kloxo.serverweb OK
kloxo.service OK
kloxo.skipbackup OK
kloxo.smessage OK
kloxo.sp_childspecialplay OK
kloxo.sp_lstclass OK
kloxo.sp_specialplay OK
kloxo.spam OK
kloxo.ssession OK
kloxo.sshconfig OK
kloxo.sslcert OK
kloxo.sslipaddress OK
kloxo.ticket OK
kloxo.ticketconfig OK
kloxo.tickethistory OK
kloxo.utmp OK
kloxo.uuser OK
kloxo.version OK
kloxo.watchdog OK
kloxo.web OK
kloxo.webhandler OK
kloxo.webmimetype OK
lomak_lomak
lomak_lomak.oc_comment OK
lomak_lomak.oc_options OK
lomak_lomak.oc_posts OK
lomak_lomak.oc_report OK
lomak_lomak.oc_search OK
lomak_lomak.oc_terms OK
lomak_lomak.oc_users OK
mydns
performance_schema
powerdns
powerdns.cryptokeys OK
powerdns.domainmetadata OK
powerdns.domains OK
powerdns.perm_items OK
powerdns.perm_templ OK
powerdns.perm_templ_items OK
powerdns.records OK
powerdns.supermasters OK
powerdns.tsigkeys OK
powerdns.users OK
powerdns.zone_templ OK
powerdns.zone_templ_records OK
powerdns.zones OK
roundcubemail
roundcubemail.cache OK
roundcubemail.cache_index OK
roundcubemail.cache_messages OK
roundcubemail.cache_shared OK
roundcubemail.cache_thread OK
roundcubemail.contactgroupmembers OK
roundcubemail.contactgroups OK
roundcubemail.contacts OK
roundcubemail.dictionary OK
roundcubemail.identities OK
roundcubemail.searches OK
roundcubemail.session OK
roundcubemail.system OK
roundcubemail.users OK
test
vpopmail
vpopmail.dir_control OK
vpopmail.lastauth OK
vpopmail.vpopmail OK
Phase 6/6: Running 'FLUSH PRIVILEGES'
OK
-
Infokan 'dir -l /var/lib/mysql'.
-
dir -l /var/lib/mysql
total 111572
-rw-rw---- 1 mysql mysql 16384 Nov 21 20:34 aria_log.00000001
-rw-rw---- 1 mysql mysql 52 Nov 21 20:34 aria_log_control
-rw-rw---- 1 mysql mysql 12582912 Nov 21 08:13 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Nov 21 08:13 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Nov 21 07:37 ib_logfile1
drwx------ 2 mysql mysql 12288 Nov 21 08:13 kloxo
drwx------ 2 mysql mysql 4096 Nov 21 10:54 loggu_loggu
-rw-rw---- 1 mysql mysql 0 Nov 21 07:40 multi-master.info
drwx------ 2 mysql mysql 4096 Nov 21 07:42 mydns
drwx--x--x 2 mysql mysql 4096 Nov 21 20:35 mysql
srwxrwxrwx 1 mysql mysql 0 Nov 21 20:34 mysql.sock
-rw-r--r-- 1 root root 15 Nov 21 20:35 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Nov 21 20:35 performance_schema
drwx------ 2 mysql mysql 4096 Nov 21 08:13 powerdns
drwx------ 2 mysql mysql 4096 Nov 21 08:13 roundcubemail
drwxr-xr-x 2 mysql mysql 4096 Nov 21 07:37 test
-rw-r----- 1 mysql root 920507 Nov 21 20:35 testong.err
-rw-rw---- 1 mysql mysql 5 Nov 21 20:34 testong.pid
drwx------ 2 mysql mysql 4096 Nov 21 08:13 tipez_tipez
drwx------ 2 mysql mysql 4096 Nov 21 08:13 vpopmail
-
COba lihat isi file testong.err misalnya dengan 'cat /var/lib/mysql/testong.err' untuk telusuri error.
-
ini pak....apakah masalah di memorynya pak ya......memory terlalu kecil :)
151121 18:08:10 [Note] Plugin 'InnoDB' is disabled.
151121 18:08:10 [ERROR] mysqld: Out of memory (Needed 131006464 bytes)
151121 18:08:10 [ERROR] mysqld: Out of memory (Needed 98254848 bytes)
151121 18:08:10 [ERROR] mysqld: Out of memory (Needed 73678848 bytes)
151121 18:08:10 [ERROR] mysqld: Out of memory (Needed 55246848 bytes)
151121 19:27:01 [Warning] Checking table: './tipez_tipez/oc_search'
151121 19:27:03 mysqld_safe Number of processes running now: 0
151121 19:27:03 mysqld_safe mysqld restarted
151121 19:27:03 [Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as pro cess 27961 ...
151121 19:27:03 [Note] Plugin 'InnoDB' is disabled.
151121 19:27:03 [ERROR] mysqld: Out of memory (Needed 131006464 bytes)
151121 19:27:03 [ERROR] mysqld: Out of memory (Needed 98254848 bytes)
151121 19:27:03 [ERROR] mysqld: Out of memory (Needed 73678848 bytes)
151121 19:27:03 [Note] Plugin 'FEEDBACK' is disabled.
151121 19:27:03 [Note] Server socket created on IP: '::'.
151121 19:27:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.22-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 Mar iaDB Server
151121 19:27:14 mysqld_safe Number of processes running now: 0
151121 19:27:14 mysqld_safe mysqld restarted
151121 19:27:14 [Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as pro cess 29320 ...
151121 19:27:14 [Note] Plugin 'InnoDB' is disabled.
151121 19:27:14 [ERROR] mysqld: Out of memory (Needed 131006464 bytes)
151121 19:27:14 [ERROR] mysqld: Out of memory (Needed 98254848 bytes)
151121 19:27:14 [ERROR] mysqld: Out of memory (Needed 73678848 bytes)
151121 19:27:14 [Note] Plugin 'FEEDBACK' is disabled.
151121 19:27:14 [Note] Server socket created on IP: '::'.
151121 19:27:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.22-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 Mar iaDB Server
151121 19:27:15 [ERROR] mysqld: Table './tipez_tipez/oc_search' is marked as cra shed and should be repaired
151121 19:27:15 [Warning] Checking table: './tipez_tipez/oc_search'
151121 19:27:16 mysqld_safe Number of processes running now: 0
151121 19:27:16 mysqld_safe mysqld restarted
151121 19:27:16 [Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as pro cess 29491 ...
151121 19:27:16 [Note] Plugin 'InnoDB' is disabled.
151121 19:27:16 [ERROR] mysqld: Out of memory (Needed 131006464 bytes)
151121 19:27:16 [ERROR] mysqld: Out of memory (Needed 98254848 bytes)
151121 19:27:16 [ERROR] mysqld: Out of memory (Needed 73678848 bytes)
151121 19:27:16 [Note] Plugin 'FEEDBACK' is disabled.
151121 19:27:16 [Note] Server socket created on IP: '::'.
151121 19:27:16 [Note] /usr/sbin/mysqld: ready for connections.
-
Coba 'yum install mysqltuner -y; mysqltuner --user root --pass PASSWORANDA' (ganti PASSWORDANDA dengan password sebenarnya yang anda lakukan melalui reset-mysql-root-password).
Mungkin perlu anda lakukan optimize untuk mysql.
-
Baca juga http://askubuntu.com/questions/422037/optimising-mysql-settings-mysqld-running-out-of-memory.
Ingat file yang anda perlu ubah adalah /etc/my.cnf.d/server.cnf dan BUKAN /etc/my.cnf. Ini karena yang anda pakai adalah MariaDB dan BUKAN MySQL.