MRatWork Forum by Mustafa Ramadhan
Language Specific Discussions => Indonesia Users => Topic started by: prandah on 2013-07-23, 13:29:38
-
kenapa ya kok bisa gini ?
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Headers and client library minor version mismatch. Headers:50169 Library:50312
/home/admin/xxx/includes/class_core.php on line 317
MySQL Error :
Error Number :
Request Date : Tuesday, July 23rd 2013 @ 03:29:27 AM
Error Date : Tuesday, July 23rd 2013 @ 03:29:27 AM
Script : http://www.xxxxx.net
Referrer :
IP Address : 199.48.164.133
Username :
Classname : vB_Database
MySQL Version :
-
Anda pakai Mysql bawaan Centos, Mysql bawaan IUS (dikenal sebagai Mysql51 atau Mysql55), mariadb bawaan centalt atau MariaDB bawaan mariadb.org?.
Apakah php*-mysql, php*-mysqli dan php*-pdo-mysql sudah terinstall?.
-
A. Kloxo-MR: 6.5.0.f-2013031828
B. OS: CentOS release 6.4 (Final) x86_64
C. Apps:
1. MySQL: MariaDB-server-5.5.32-1.x86_64
2. PHP: php53u-5.3.27-1.ius.el6.x86_64
3. Httpd: httpd-2.2.25-1.el6.x86_64
4. Lighttpd: --uninstalled--
5. Nginx: nginx-1.5.2-1.el6.x86_64
6. Qmail: qmail-toaster-1.03-1.3.27.mr.el6.x86_64
- with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
7. Dns: bind-9.9.2-3.P2.el6.x86_64
D. Php-type (for Httpd/proxy): php-fpm_event
E. Memory:
total used free shared buffers cached
Mem: 24020 10727 13292 0 354 8519
-/+ buffers/cache: 1853 22166
Swap: 23998 0 23998
[root@juniper ~]#
pakek MariaDB dari MR
untuk php53u mysql udah terinstall :D
-
Installed Packages
MariaDB-client.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-common.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-compat.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-devel.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-server.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-shared.x86_64 5.5.32-1 @kloxo-mr-mariadb64
-
Jangan-jangan ini masalah di VBulletin yang salah identifikasi jika pakai MariaDB. Coba googling saja masalah VBulletin dengan MariaDB.
-
ini lengkapnya
[root@juniper ~]# yum list installed | grep MariaDB*
MariaDB-client.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-common.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-compat.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-devel.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-server.x86_64 5.5.32-1 @kloxo-mr-mariadb64
MariaDB-shared.x86_64 5.5.32-1 @kloxo-mr-mariadb64
[root@juniper ~]# yum list installed | grep php53u*
php53u.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-cli.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-common.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-devel.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-fpm.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-gd.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-mbstring.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-mysql.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-pdo.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-pear.noarch 1:1.9.4-3.ius.el6 @kloxo-mr-ius
[root@juniper ~]#
apa ada yang kurang ya?
uda post juga di vBulletin : http://www.vbulletin.com/forum/forum/vb ... to-mariadb (http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/3984239-error-after-change-mysql-to-mariadb)
-
Coba periksa dengan 'yum list mysqlclient*'. Jangan masih ada. Mysqlclient tidak diperlukan di MariaDB karena sudah built-in.
Jika ada coba remove.
-
[root@juniper ~]# yum list mysqlclient*
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Loading mirror speeds from cached hostfile
* base: mirror.millry.co
* extras: centos.mirror.netriplex.com
* kloxo-mr-epel: fedora.mirror.netriplex.com
* kloxo-mr-ius: mirror.symnds.com
* updates: centos.aol.com
0 packages excluded due to repository protections
Available Packages
mysqlclient16.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
mysqlclient16-debuginfo.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
mysqlclient16-devel.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
[root@juniper ~]#
apa di remove ajah ?
-
[root@juniper ~]# yum list mysqlclient*
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Loading mirror speeds from cached hostfile
* base: mirror.millry.co
* extras: centos.mirror.netriplex.com
* kloxo-mr-epel: fedora.mirror.netriplex.com
* kloxo-mr-ius: mirror.symnds.com
* updates: centos.aol.com
0 packages excluded due to repository protections
Available Packages
mysqlclient16.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
mysqlclient16-debuginfo.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
mysqlclient16-devel.x86_64 5.1.61-1.ius.el6 kloxo-mr-ius
[root@juniper ~]#
apa di remove ajah ?
Ini artinya ada tapi tidak terinstall.
-
owh solusinya trus gimana ya ? heheh
dah mupeng nih soale ada yg mau beli nih forum :D
-
Di vBulletin config coba ubah pemakaian mysql ke mysqli
-
udah
malah keluar gini
Database error in vBulletin :
mysqli_real_connect() [<a href='function.mysqli-real-connect'>function.mysqli-real-connect</a>]: Headers and client library minor version mismatch. Headers:50169 Library:50312
/home/admin/xxxx/includes/class_core.php on line 1356
MySQL Error :
Error Number :
Request Date : Tuesday, July 23rd 2013 @ 06:24:26 PM
Error Date : Tuesday, July 23rd 2013 @ 06:24:26 PM
Script : http://www.xxxx.net/install/
Referrer :
IP Address : 199.48.164.133
Username :
Classname : vB_Database_MySQLi
MySQL Version :
-
saya coba di server saya satunya lancar jaya hehehe :D
-
saya coba di server saya satunya lancar jaya hehehe :D
Centos versi yang sama?.
Coba bandingkan kedua Server siapa tahu ada yang tidak sama php externsion-nya. Jalankan 'yum list installed php*' di kedua server untuk lihat apa yang beda.
-
beda mas
yang dedi 1 pakek centong 6 yang dedi atunya lagi centong 5
ini centong 6
[root@juniper ~]# yum list installed php*
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Loading mirror speeds from cached hostfile
* base: mirror.millry.co
* extras: centos.mirror.netriplex.com
* kloxo-mr-epel: fedora.mirror.netriplex.com
* kloxo-mr-ius: mirror.symnds.com
* updates: mirror.umd.edu
0 packages excluded due to repository protections
Installed Packages
php53u.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-cli.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-common.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-devel.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-fpm.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-gd.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-mbstring.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-mysql.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-pdo.x86_64 5.3.27-1.ius.el6 @kloxo-mr-ius
php53u-pear.noarch 1:1.9.4-3.ius.el6 @kloxo-mr-ius
[root@juniper ~]#
ini centong 5
[root@venus ~]# yum list installed php*
Loaded plugins: fastestmirror, priorities, protectbase, replace, security
Loading mirror speeds from cached hostfile
* base: centos-mirror.jchost.net
* extras: dallas.tx.mirror.xygenhosting.com
* kloxo-mr-epel: mirror.steadfast.net
* kloxo-mr-ius: ord.mirror.rackspace.com
* kloxo-mr-ius-c5: ord.mirror.rackspace.com
* updates: centos.corenetworks.net
Excluding Packages from Kloxo-MR - centalt - x86_64
Finished
Excluding Packages from Kloxo-MR - IUS Community Packages for EL 5 - x86_64
Finished
Reducing Kloxo-MR - IUS Community Packages for EL 5 (special) - x86_64 to included packages only
Finished
0 packages excluded due to repository protections
Installed Packages
php53u.x86_64 5.3.25-1.ius.el5 installed
php53u-cli.x86_64 5.3.25-1.ius.el5 installed
php53u-common.x86_64 5.3.25-1.ius.el5 installed
php53u-devel.x86_64 5.3.25-1.ius.el5 installed
php53u-fpm.x86_64 5.3.25-1.ius.el5 installed
php53u-gd.x86_64 5.3.25-1.ius.el5 installed
php53u-mbstring.x86_64 5.3.25-1.ius.el5 installed
php53u-mysql.x86_64 5.3.25-1.ius.el5 installed
php53u-pdo.x86_64 5.3.25-1.ius.el5 installed
php53u-pear.noarch 1:1.9.4-3.ius.el5 installed
[root@venus ~]#
-
Versinya beda. Jangan-jangan versi di Centos 6 (5.3.27-1.ius) ada bug.
Coba saja kembalikan ke mysql pakai script kebalikan 'sh /script/mariadb-to-mysql'.