MariaDB, PHP, and mysql_connect() issue on Installation scripts

evil · 2013-03-31 16:19:16

I searched for this issue and turned out nothing..

I am using an installation script on my web server and i get this error:

function mysql_connect() not found:
Your system does not appear to have mysql available within php

I followed the wiki and have uncommented the following lines

extension=pdo_mysql.so
extension=mysqli.so
extension=mysql.so

I have also restarted the httpd daemon several times. I am using MariaDB because I know arch is dropping mysql. I followed the MariaDB wiki too and have it set-up properly.

Here is my "mysqli" section of phpinfo()

MysqlI Support enabled
Client API library version mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0

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 /var/run/mysqld/mysqld.sock /var/run/mysqld/mysqld.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off

and here is "mysqlnd" in phpinfo()

mysqlnd
mysqlnd enabled
Version mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Compression supported
SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins mysqlnd,example,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password
API Extensions mysqli

MySQL is running as I have set-up a database and user for this installation script.

evil · 2013-03-31 19:33:44

I dropped to the command line and tried to run php and realized that mysql.so was named mssql.so..

so for anyone that has this issue, when you install php, unless they change it next release, that's a typo you have to fix when uncommented the mysql extension

Last edited by evil (2013-03-31 19:34:12)

WorMzy · 2013-03-31 20:07:58

That's not a typo.. mssql and mysql are two different things.

Arch Linux

#1 2013-03-31 16:19:16

MariaDB, PHP, and mysql_connect() issue on Installation scripts

#2 2013-03-31 19:33:44

Re: MariaDB, PHP, and mysql_connect() issue on Installation scripts

#3 2013-03-31 20:07:58

Re: MariaDB, PHP, and mysql_connect() issue on Installation scripts

Board footer