Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-05-03, 22:27:44
« previous next »
Pages: [1] 2 3   Go Down

Author Topic: mysql error saat instalasi  (Read 9583 times)

0 Members and 1 Guest are viewing this topic.

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
mysql error saat instalasi
« on: 2016-10-06, 16:44:59 »
saya baru deploy vps baru, saat install kloxomr, selalu gagal di starting mysql
ini errornya pak

>>> Processing basic Kloxo-MR configures (setting and database) <<<
Starting MySQL. ERROR!
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
Connect failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
>>> Execute os_fix_lxlabs_permission() <<<
>>> Execute os_create_program_service() <<<
>>> Execute os_create_kloxo_service_once() <<<
>>> Execute create_mysql_db() for MASTER <<<
>>> Execute create_database() for MASTER <<<

sudah berulang sekitar 3-4 kali pak
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #1 on: 2016-10-06, 16:59:38 »
Periksa file mysql log error dengan 'cat /var/lib/mysql/*.err'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #2 on: 2016-10-06, 17:01:17 »
Juga infokan 'cat /etc/*release; uname -m; dir -l /etc/yum.repos.d'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #3 on: 2016-10-06, 17:04:30 »
ini pak

cat /var/lib/mysql/*.err

161006 15:23:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161006 15:23:29 [Note] /usr/sbin/mysqld (mysqld 10.0.27-MariaDB) starting as process 15805 ...
161006 15:23:29 [Note] Plugin 'InnoDB' is disabled.
161006 15:23:29 [Note] Plugin 'FEEDBACK' is disabled.
161006 15:23:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
161006 15:23:29 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
161006 15:23:29 [Note] Server socket created on IP: '::'.
161006 15:23:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
161006 15:23:29 mysqld_safe mysqld from pid file /var/lib/mysql/ibnkhaldun.hostmikro.com.pid ended

cat /etc/*release; uname -m; dir -l /etc/yum.repos.d
CentOS release 6.8 (Final)
CentOS release 6.8 (Final)
CentOS release 6.8 (Final)
x86_64
total 36
-rw-r--r--. 1 root root 1991 Mei 18 19:47 CentOS-Base.repo
-rw-r--r--. 1 root root  647 Mei 18 19:47 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root  289 Mei 18 19:47 CentOS-fasttrack.repo
-rw-r--r--. 1 root root  630 Mei 18 19:47 CentOS-Media.repo
-rw-r--r--. 1 root root 6259 Mei 18 19:47 CentOS-Vault.repo
-rw-r--r--. 1 root root 9241 Okt  6 15:17 mratwork.repo
Logged

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #4 on: 2016-10-06, 19:06:48 »
update

saat ini sudah berhasil diinstall, tapi setelah instalasi, mau restart semua (sh /script/restart-all -y) error seperti ini


Stopping php-fpm:                                          [FAILED]
Starting php-fpm: [06-Oct-2016 17:27:26] ERROR: No pool defined. at least one pool section must be specified in config file
[06-Oct-2016 17:27:26] ERROR: failed to post process the configuration
[06-Oct-2016 17:27:26] ERROR: FPM initialization failed
                                                           [FAILED]
-------------------------------------------------------------------


halaman login kloxomr juga error, blank dengan tulisan

 Fatal error: Call to undefined method stdClass::getObject() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxlib.php on line 2361
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #5 on: 2016-10-07, 01:51:29 »
Coba jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA; sh /script/mysql-optimizer --select=upgrade'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #6 on: 2016-10-07, 02:59:05 »
Quote from: MRatWork on 2016-10-07, 01:51:29
Coba jalankan 'sh /script/reset-mysql-root-password PASSWORDANDA; sh /script/mysql-optimizer --select=upgrade'.

sudah bisa diinstall pak
tapi saat mau login lewat browser,muncul error ini pak

Fatal error: Call to undefined method stdClass::getObject() in /usr/local/lxlabs/kloxo/httpdocs/lib/php/lxlib.php on line 2361

Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #7 on: 2016-10-07, 03:51:43 »
Coba Kloxo-MR di-restart dengan 'sh /script/restart'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #8 on: 2016-10-10, 17:13:04 »
sudah solved pak
sekarang problem barunya, setiap akses domain pakai 'www' yang ditampilkan adalah halaman default index.html milik kloxomr

padahal root folder domain sudah dipindah, dan index.html dari kloxo sudah dihapus
problem ada di ssl maupun non-ssl
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #9 on: 2016-10-11, 03:11:45 »
Apa hasil pengujian dns melalui intodns.com tidak ada error untuk www?.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #10 on: 2016-10-11, 08:13:04 »
tidak ada pak
intodns normal, cek pakai dig dan ping juga normal
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #11 on: 2016-10-11, 08:20:33 »
Maksudnya tidak ada 'A record' untuk www di domain tersebut?.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #12 on: 2016-10-11, 08:51:45 »
tidak ada pak
www sebagai cname dari mydomain.com

kasusnya sama seperti di sini pak
https://forum.mratwork.com/kloxo-mr-technical-helps/website-don't-read-index-html/msg54375/?topicseen#new

tampilan output halamannya juga sama
http://i.share.pho.to/7592b880_o.png
Logged

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: mysql error saat instalasi
« Reply #13 on: 2016-10-11, 08:57:06 »
Saya tidak menemukan masalah ketika akses ke eljuhany.com dan www.eljuhany.com.

Bisa jadi anda perlu clear cache dari browser.

Tapi, pengujian di intodns.com menemukan masalah untuk ns dari domain tersebut.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Wibowo

  • Master
  • **
  • Posts: 391
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: mysql error saat instalasi
« Reply #14 on: 2016-10-11, 09:00:01 »
itu bukan domain saya pak, itu dari link kasus yg serupa di salah satu sobforum mratwork ini

saya coba akses pakai curl di terminal, hasilnya sama saja pak
cache browser juga sudah saya clear
bahkan pindah2 browser dan device tetap sama saja
Logged
Pages: [1] 2 3   Go Up
« previous next »
 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.05 seconds with 19 queries.

web stats analysis