Re: Compile PHP with MySQL support

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 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'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/