Re: Compile PHP with MySQLi (With MySQL on a remote server)

On 10/13/2011 05:59 PM, 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 Links 0 > 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 value no value > mysqli.default_port 3306 3306 > mysqli.default_pw no value no value > mysqli.default_socket no value no value > mysqli.default_user no value no value > mysqli.max_links Unlimited Unlimited > mysqli.max_persistent Unlimited Unlimited > mysqli.reconnect Off 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 don't need the mysql server to compile mysql{,i} modules, the client library is enough. Any special reason for not using mysqlnd, which will compile without needing the mysql client library? Or I guess it's not there in php 5.1 -- Nilesh Govindarajan http://nileshgr.com