Re: [PHP] Compile PHP with MySQL support

2011-10-13 Thread Sharl.Jimh.Tsin
在 2011-10-13四的 08:27 -0400,Nick Khamis写道:
> Hello Everyone,
> 
> I am trying to compile php from source using the following config:
> 
> ./configure --prefix=/usr/local/php
> --with-apxs2=/usr/local/apache/bin/apxs
> --with-config-file-path=/usr/local/php
> --with-mcrypt=/usr/local/bin/mcrypt --with-mysqli
> --with-gettext=./ext/gettext --with-pear
> --with-libxml-dir=/usr/include/libxml2 --with-zlib --with-gd
> --enable-pcntl
> 
> Note the mysqli without pointing to /usr/local/mysql/bin/mysql_config.
> The problem is MySQL is not installed on the machine, it is actually
> installed on another server.
> 
> MySQLi Suport:
> 
> mysqli
> MysqlI Support  enabled
> Client API library version  5.1.49
> Active Persistent Links 0
> Inactive Persistent Links   0
> Active Links0
> Client API header version   5.1.49
> MYSQLI_SOCKET   /var/run/mysqld/mysqld.sock
> 
> Directive   Local Value Master Value
> mysqli.allow_local_infile   On  On
> mysqli.allow_persistent On  On
> mysqli.default_host no valueno value
> mysqli.default_port 33063306
> mysqli.default_pw   no valueno value
> mysqli.default_socket   no valueno value
> mysqli.default_user no valueno value
> mysqli.max_linksUnlimited   Unlimited
> mysqli.max_persistent   Unlimited   Unlimited
> mysqli.reconnectOff Off
> 
> The machine I compiled PHP on does not have mysqli.so, and so I am
> recieving the "fatal call to undefined function mysql_connect()"
> error. Can someone tell me how to compile php from source with mysql
> support, but actually mysql is installed on a different server?

install it locally.otherwise impossible.

> 
> Can I download a precompile mysqli anywhere? The PHP version is 5.1.49
> as noted earlier.
> 
> Thanks in Advance,
> 
> Nick

-- 
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)

Using Gmail? Please read this important notice:
http://www.fsf.org/campaigns/jstrap/gmail?10073.


signature.asc
Description: This is a digitally signed message part


Re: [PHP] Compile PHP with MySQL support

2011-10-13 Thread Simon J Welsh
On 14/10/2011, at 1:27 AM, Nick Khamis wrote:

> Hello Everyone,
> 
> I am trying to compile php from source using the following config:
> 
> ./configure --prefix=/usr/local/php
> --with-apxs2=/usr/local/apache/bin/apxs
> --with-config-file-path=/usr/local/php
> --with-mcrypt=/usr/local/bin/mcrypt --with-mysqli
> --with-gettext=./ext/gettext --with-pear
> --with-libxml-dir=/usr/include/libxml2 --with-zlib --with-gd
> --enable-pcntl
> 
> Note the mysqli without pointing to /usr/local/mysql/bin/mysql_config.
> The problem is MySQL is not installed on the machine, it is actually
> installed on another server.
> 
> MySQLi Suport:
> 
> mysqli
> MysqlI Support  enabled
> Client API library version  5.1.49
> Active Persistent Links 0
> Inactive Persistent Links   0
> Active Links0
> Client API header version   5.1.49
> MYSQLI_SOCKET   /var/run/mysqld/mysqld.sock
> 
> Directive   Local Value Master Value
> mysqli.allow_local_infile   On  On
> mysqli.allow_persistent On  On
> mysqli.default_host no valueno value
> mysqli.default_port 33063306
> mysqli.default_pw   no valueno value
> mysqli.default_socket   no valueno value
> mysqli.default_user no valueno value
> mysqli.max_linksUnlimited   Unlimited
> mysqli.max_persistent   Unlimited   Unlimited
> mysqli.reconnectOff Off
> 
> The machine I compiled PHP on does not have mysqli.so, and so I am
> recieving the "fatal call to undefined function mysql_connect()"
> error. Can someone tell me how to compile php from source with mysql
> support, but actually mysql is installed on a different server?
> 
> Can I download a precompile mysqli anywhere? The PHP version is 5.1.49
> as noted earlier.
> 
> Thanks in Advance,
> 
> Nick


You've only compiled in MySQLi. You also need to pass --with-mysql to 
configure. As you can compile in MySQLi, you should have no problems with MySQL.

---
Simon Welsh
Admin of http://simon.geek.nz/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Compile PHP with MySQL support

2011-10-13 Thread Nick Khamis
Hello Everyone,

I am trying to compile php from source using the following config:

./configure --prefix=/usr/local/php
--with-apxs2=/usr/local/apache/bin/apxs
--with-config-file-path=/usr/local/php
--with-mcrypt=/usr/local/bin/mcrypt --with-mysqli
--with-gettext=./ext/gettext --with-pear
--with-libxml-dir=/usr/include/libxml2 --with-zlib --with-gd
--enable-pcntl

Note the mysqli without pointing to /usr/local/mysql/bin/mysql_config.
The problem is MySQL is not installed on the machine, it is actually
installed on another server.

MySQLi Suport:

mysqli
MysqlI Support  enabled
Client API library version  5.1.49
Active Persistent Links 0
Inactive Persistent Links   0
Active Links0
Client API header version   5.1.49
MYSQLI_SOCKET   /var/run/mysqld/mysqld.sock

Directive   Local Value Master Value
mysqli.allow_local_infile   On  On
mysqli.allow_persistent On  On
mysqli.default_host no valueno value
mysqli.default_port 33063306
mysqli.default_pw   no valueno value
mysqli.default_socket   no valueno value
mysqli.default_user no valueno value
mysqli.max_linksUnlimited   Unlimited
mysqli.max_persistent   Unlimited   Unlimited
mysqli.reconnectOff Off

The machine I compiled PHP on does not have mysqli.so, and so I am
recieving the "fatal call to undefined function mysql_connect()"
error. Can someone tell me how to compile php from source with mysql
support, but actually mysql is installed on a different server?

Can I download a precompile mysqli anywhere? The PHP version is 5.1.49
as noted earlier.

Thanks in Advance,

Nick