Scott can you help me ??

[Danny]

Hi Scott i trying to compile php 5.2.1 in my plesk 8.1, i ever compile my php from source but with the new 5.2 i cant get to work.
The problem is with the mysqli extension.

This is my configure line

Code: Select all

./configure --host=i686-redhat-linux-gnu --build=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu 
--program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc 
--datadir=/usr/share --includedir=/usr/include 
--libdir=/usr/lib --libexecdir=/usr/libexec 
--localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info 
--cache-file=../config.cache 
--with-config-file-path=/etc 
--with-config-file-scan-dir=/etc/php.d 
--enable-force-cgi-redirect 
--disable-debug 
--enable-pic 
--disable-rpath 
--enable-inline-optimization 
--with-bz2 
--with-db4=/usr 
--with-curl 
--with-exec-dir=/usr/bin 
--with-freetype-dir=/usr 
--with-png-dir=/usr 
--with-gd 
--enable-gd-native-ttf 
--without-gdbm 
--with-gettext 
--with-ncurses 
--with-gmp 
--with-iconv 
--with-jpeg-dir=/usr 
--with-openssl 
--with-png 
--with-pspell 
--with-regex=system 
--with-xml 
--with-expat-dir=/usr 
--with-dom=shared,/usr 
--with-dom-xslt=/usr 
--with-dom-exslt=/usr 
--with-xmlrpc=shared 
--with-zlib 
--with-layout=GNU 
--enable-bcmath 
--enable-exif 
--enable-ftp 
--enable-magic-quotes 
--enable-sockets 
--enable-sysvsem 
--enable-sysvshm 
--enable-track-vars 
--enable-trans-sid 
--enable-yp 
--enable-wddx 
--with-pear=/usr/share/pear 
--with-ldap=shared 
--with-mhash=shared 
--with-mcrypt=shared 
--enable-xslt=shared 
--with-xslt-sablot 
--with-sablot-js=/usr 
--enable-memory-limit 
--enable-bcmath 
--enable-shmop 
--enable-calendar 
--enable-dbx 
--enable-dio 
--enable-mcal 
--enable-mbstring=shared 
--enable-mbstr-enc-trans 
--enable-mbregex 
--with-apxs2=/usr/sbin/apxs 
--without-sqlite --without-pgsql 
--with-mysqli=/usr/local/mysql/bin/mysql_config 
--with-kerberos 
--with-imap --with-imap-ssl=/usr/include/openssl

My enviroment CentOS 4.4, mysql precompiled binaries
mysql-standard-4.1.22-pc-linux-gnu-i686
The mysqlclient is mysqlclient14-4.1.22-1.el4s1.1.rpm
My problem is with the default socket, if i review phpinfo() i can see MYSQLI_SOCKET = /tmp/mysql.sock but my good socket is in /var/lib/mysql/mysql.sock

I dont undertand whats up because the mysql_config output is

Code: Select all

[root@srv01 daniel]# /usr/local/mysql/bin/mysql_config --socket
/var/lib/mysql/mysql.sock

I i compile php 4.4.6 or php4.4.5 with
--with-mysql=/usr/local/mysql and
--with-mysql-sock=/var/lib/mysql/mysql.sock
All work ok.

I try to pass as parameter --with-mysqli-sock=/var/lib/mysql/mysql.sock but dont work.

Thanks for your help

[Danny]

Solved. Thanks a lot

[Nothing]

Solved. Thanks a lot

maybe you can tell to other people how you solve that ?

If anyone had the same problem one day ...

Thanks

[Danny]

I use the mysql precompiled binaries with icc (Intel compiler) that is more faster that the compiled with GCC, the problem is that php cant be compiled with gcc if you use mysql compiled with icc.

I make a yum install mysql-devel from art and problem solved.

I have now php5.2.1 with xcache and my forums fly

Excuse my broken English

[Fantu]

where you take mysql 5 and php 5.2.1? in yum on my server not show it

[Danny]

where you take mysql 5 and php 5.2.1? in yum on my server not show it

As you can see i compile php by hand , in my CentOS 4.4 i see Mysql5 from CentosPlus channel but i not update to it because i think that Plesk do not support MySQL5

[Fantu]

plesk 8 support mysql 5...is in the news of admin login

[Danny]

plesk 8 support mysql 5...is in the news of admin login

Very good hear this , the if you want simply enable centosplus repo and make a yum update mysql.
If you update to mysql5 please put your impressions here

[Fantu]

i'm noob with linux and i don't want how the server have problem...fo that i ask councils here...
I only know that plesk 8 support mysql 5 and php 5 but not are in the automatic updater...
i have install yum and config for this site but mysql isn't present and php is only 5.0.4 and have i problem how i have explain i other topic
i search to update server without have problem^^''