MRatWork Forum by Mustafa Ramadhan - mysql error saat instalasi

Sponsor:
Server and Web Integrator
Link:
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:

MRatWork Forum | Please login or register. | 2017-11-07, 19:28:03

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- mysql error saat instalasi

« previous next »

- Print

Pages: [1] 2 3 Go Down

### Author Topic: mysql error saat instalasi (Read 2006 times)

0 Members and 1 Guest are viewing this topic.

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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
.//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

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### 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!) --

#### Wibowo

- Master
- Posts: 391
- Karma: +0/-0
- Gender:

##### 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

- Print

Pages: [1] 2 3 Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- mysql error saat instalasi

Top 10 Social Networking: Facebook Twitter LinkedIn Pinterest Google Plus Tumblr Instagram VK Flickr Vine

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.043 seconds with 17 queries.

Mirror created by MasterkinG32.CoM