MRatWork Forum by Mustafa Ramadhan

Language Specific Discussions => Indonesia Users => Topic started by: ariefewweb on 2013-02-24, 09:25:30

Title: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 09:25:30
Untuk install kali ini saya mendapatkan error sbb

Code: [Select]
Creating Vpopmail database...
which: no mysql in (/usr/sbin:/sbin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/u
sr/sbin:/usr/bin:/root/bin)
mysql client is not there
Prepare /home/kloxo/httpd...
No log handling enabled - turning on stderr logging
Created directory: /var/lib/net-snmp/mib_indexes
Could not Connect to Database on localhost using root user
Could not open database connection.PHP Warning:  PHP Startup: Unable to load dyn
amic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/php/modules/mysqli.
so: symbol mysql_client_errors, version libmysqlclient_18 not defined in file li
bmysqlclient.so.18 with link time reference in Unknown on line 0
Create mysql.sock...
mysqld: unrecognized service
start: unrecognized service
mysqld: unrecognized service
Setting Mysql for always running after reboot and restart now...
error reading information on service mysqld: No such file or directory
mysqld: unrecognized service

dan kloxo 7778 tidak bisa dibuka
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 09:37:34
reboot masih tetap error

/script/cleanup
Code: [Select]
Could not open database connection.

service kloxo restart
Code: [Select]
Stopping kloxo: Waiting for the process to die.....
Stopped kloxo

Starting kloxo: 11
Could not open database connection.2013-02-24 03:38:04: (network.c.709) SSL: error:02001002:system library:fopen:No such file or directory /usr/local/lxlabs/kloxo/etc/program.ca
 SUCCESS! MySQL running (12399)
/etc/init.d/kloxo: line 53: 12670 Terminated              
lxphp.exe ../bin/execatinit.php
Started kloxo
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 09:39:03
Informasikan disini hasil dari 'sh /script/sysinfo'.

Bisa jadi mysql dan atau php-mysql gagal diinstall.
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 09:40:12
Ini 'fresh install' atau update?
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 09:51:32
kulakukan

Code: [Select]
mksock /var/lib/mysql/mysql.sock
ln /etc/init.d/mysql /etc/init.d/mysqld

lalu

sh ./kloxo-mr-dev.sh

Code: [Select]
Click 'Enter' to finishing this processPHP Warning:  PHP Startup: Unable to load
 dynamic library '/usr/lib/php/modules/mysqli.so' - /usr/lib/php/modules/mysqli.so: symbol mysql_client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference in Unknown on line 0

dengan hasil kloxo 7778 bisa terbuka
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 09:53:14
Quote from: "MRatWork"
Ini 'fresh install' atau update?

fresh install alias reinstall centos 6 64 2x, centos 6 32 1x
kuulangi terus dengan hasil sama
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 09:55:00
Quote from: "MRatWork"
Informasikan disini hasil dari 'sh /script/sysinfo'.

Bisa jadi mysql dan atau php-mysql gagal diinstall.

hasil :

Code: [Select]
A. Kloxo-MR: 6.5.0.c.2013022301

B. OS: CentOS release 6.3 (Final) x86_64

C. Apps:
   1. MySQL: --uninstalled--
   2. PHP: php-5.3.21-1.el6.x86_64
   3. Httpd: httpd-2.2.23-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.x86_64

D. Php-type (for Httpd/proxy):

memang saat proses install ada sekilas kulihat setelah mysqld terinstall .. lalu di uninstall sendiri....
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 09:56:12
coba install secara manual 'yum install mysql*'. Bisa jadi gagal pada tahap ini. Juga 'yum install php-mysql'
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 10:01:06
Quote from: "MRatWork"
coba install secara manual 'yum install mysql*'. Bisa jadi gagal pada tahap ini.

banyak terjadi conflict

Aku kok gak pernah ngalamin gini sebelumnya
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 10:08:24
Bisa jadi karena ada package mysql dari centos tapi repo lain ada juga dan ini mengakibatkan conflict.

Coba pakai mysql branch lain dengan menjalankan 'yum install mysql51*'
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 10:14:13
setelah bisa masuk ke kloxo 7778, ku 'otak-atik' service sampai hijau semua pak.
sekarang bisa melakukan sh /script/cleanup
mysql dan phpadmin di kloxo juga gak masalah, tapi anehnya di sh /script/sysinfo, MySQL: --uninstalled--
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 10:19:25
Quote from: "MRatWork"
Bisa jadi karena ada package mysql dari centos tapi repo lain ada juga dan ini mengakibatkan conflict.

Coba pakai mysql branch lain dengan menjalankan 'yum install mysql51*'

hasil
Code: [Select]
No package mysql51* available.
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 10:32:33
Sorry, only mysql and mysql55 branch on centos 6.

So, you can run 'yum install mysql55*' or try 'yum remove mysql*.i386 mysql*.i686; yum install mysql*.x86_64'
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 10:38:46
Quote from: "MRatWork"
Sorry, only mysql and mysql55 branch on centos 6.

So, you can run 'yum install mysql55*' or try 'yum remove mysql*.i386 mysql*.i686; yum install mysql*.x86_64'

hasil
Code: [Select]
...................
Error: mysql55-server conflicts with MariaDB-server
Error: mysql55-libs conflicts with MariaDB-shared
....................
Error: mysql55 conflicts with MariaDB-server
..................
Error: mysql55-test conflicts with MariaDB-test
Error: mysql55-devel conflicts with MariaDB-devel
Error: mysql55-libs conflicts with MariaDB-compat
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

kok ada mariadb
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 10:45:00
Wah, ini karena saya masukkan mariadb dalam repo. Tunggu sekitar 10-20 menit. Akan saya perbaiki.
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 10:48:50
Sebelumnya jalan dulu 'yum clean all'

Coba ulangi lagi tahap installnya. file kloxo-mr.repo sudah saya sesuaikan.
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 10:59:38
Hehehe....
Tadinya sih mau bilang kalau mariadb saat instalasi meremove mysql sebelumnya... Tapi ragu2 alias gak berani :D
Saat install sekilas memang mysqld terinstall lalu mariadb ikut terinstall juga. Maka akhirnya mysqld teruninstall.
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 11:08:51
Sekarang posisi mariadb repo di kloxo-mr.repo adalah disable ('enable=0').

Artinya ini masih dalam persiapan pindah ke MariaDB. Celakanya, MariaDB (juga Mysql 5.5) mengharuskan innodb selalu aktif (tidak ada 'skip-innodb' di /etc/my.cnf'). Disamping masalah-masalah lain.
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 11:10:01
Quote from: "MRatWork"
Sebelumnya jalan dulu 'yum clean all'

Coba ulangi lagi tahap installnya. file kloxo-mr.repo sudah saya sesuaikan.

gak berhasil bersih, sekarang kucoba reinstall centos 6 64 dan fresh install
*reinstall yg ke-4
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 11:11:49
Malah coba saja install mysql saja. Dengan syarat /etc/yum.repos.d/kloxo-mr.repo sudah diubah.
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 11:14:29
Quote from: "MRatWork"
Malah coba saja install mysql saja. Dengan syarat /etc/yum.repos.d/kloxo-mr.repo sudah diubah.
Sekalian nyoba install secara keseluruhan aja Pak... mumpung ada vps kosong
Title: Re: mysqld: unrecognized service
Post by: MRatWork on 2013-02-24, 11:15:26
Saya baru coba install sebelum tulisan ini di centos 6 64bit. Berjalan lancar.
Title: Re: mysqld: unrecognized service
Post by: ariefewweb on 2013-02-24, 11:24:11
instalasi mulus pak

sh /script/sysinfo
Code: [Select]
A. Kloxo-MR: 6.5.0.c.2013022401

B. OS: CentOS release 6.3 (Final) x86_64

C. Apps:
   1. MySQL: mysql-5.5.29-1.el6.x86_64
   2. PHP: php-5.3.21-1.el6.x86_64
   3. Httpd: httpd-2.2.23-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.x86_64