Installation Process cannot recognize MySQL 5.0

Help with getting the CMS CORE package up and running. This does not include 3rd party modules, PHP scripts, anything downloaded via module manager or from any external source.
Locked
PBlue
Forum Members
Forum Members
Posts: 43
Joined: Tue Nov 07, 2006 5:54 am

Installation Process cannot recognize MySQL 5.0

Post by PBlue »

At Step 3 of the Installation process, the install script cannot find mysql and I have nothing to choose from the "Database Type" and the following error message appears:

Database Type: 
No valid database drivers appear to be compiled into your PHP install. Please confirm that you have mysql, mysqli, and/or postgres7 support installed, and try again.


In fact, I can connect to mysql using the console with the user "cms_user" and password "cms_pass" and access the database "cms".

# mysql -u cms_user -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use cms;
Database changed

mysql> show tables;
Empty set (0.00 sec)

mysql>


The database "cms" has been created and the user "cms_user" has been granted privileges.

Basic information:
(1) I am using Fedora Core 6.
(2) Mysql version is 5.0.22

Please can anybody advise what's wrong?
Dee
Power Poster
Power Poster
Posts: 1197
Joined: Sun Mar 19, 2006 8:46 pm

Re: Installation Process cannot recognize MySQL 5.0

Post by Dee »

It looks like your PHP install lacks mysql support. You probably need to install some php-mysql package.
PBlue
Forum Members
Forum Members
Posts: 43
Joined: Tue Nov 07, 2006 5:54 am

Re: Installation Process cannot recognize MySQL 5.0

Post by PBlue »

Yes, you are right!

After I execute #yum install php-mysql and then I can install CMS Made Simple successfully.

More information about php-mysql:

Name  : php-mysql
Arch  : i386
Version: 5.1.6
Release: 3.1.fc6
Size  : 82 k
Repo  : updates
Summary: A module for PHP applications that use MySQL databases.
Description:
The php-mysql package contains a dynamic shared object that will add
MySQL database support to PHP. MySQL is an object-relational database
management system. PHP is an HTML-embeddable scripting language. If
you need MySQL support for PHP applications, you will need to install
this package and the php package.

So CMSMS can work with Fedora Core 6 and MySQL 5 without any problem.
chmod411

Re: Installation Process cannot recognize MySQL 5.0

Post by chmod411 »

Hello - I'm trying the install cms as well, and I have been reading your forum to find out where I can get php-mysql package together. I have downloaded both mysql-essential 5.0.27 and php 5.2.1. I use Apache 2.0.5 on Windows XP SP2.

I also got the same error at step 3 - I have nothing to choose from the Database type and "Database Type:   
No valid database drivers appear to be compiled into your PHP install. Please confirm that you have mysql, mysqli, and/or postgres7 support installed, and try again."

I have done mysql command, the database "cms" has been created, and privileges for cms_user has been granted.

You mentioned in here that there is a php-mysql package, can someone send me the link where to find this package? Thank you.
Locked

Return to “[locked] Installation, Setup and Upgrade”