I have worked on this issue for few days but I don't know what is needed. My MySQL is installed in a different machine (host). I opened the port on that machine as well. All the machines are Red Hat Enterprise Linux. When I "Start Installation" from going to rouncube installer from web browser it shows the following:
Checking available databases
Check which of the supported extensions are installed. At least one of them is required.
MySQL: NOT AVAILABLE(Not installed)
MySQLi: NOT AVAILABLE(Not installed)
PostgreSQL: NOT AVAILABLE(Not installed)
SQLite (v2): OK
I assume it's looking for MySQL database and not the driver. Neverthless, here is the "pear list":
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.3.3 stable
Console_Getopt 1.2.3 stable
File 1.4.0alpha1 alpha
File_CSV 1.0.0alpha1 alpha
File_Util 1.0.0alpha1 alpha
Fileinfo 1.0.4 stable
MDB2 2.4.1 stable
MDB2_Driver_mysql 1.4.1 stable
MDB2_Driver_mysqli 1.4.1 stable
PEAR 1.9.0 stable
Structures_Graph 1.0.2 stable
XML_Util 1.2.1 stable
Here is my db.ini.php:
<?php
/*
+-----------------------------------------------------------------------+
| Configuration file for database access |
| |
| This file is part of the RoundCube Webmail client |
| Copyright (C) 2005-2009, RoundCube Dev. - Switzerland |
| Licensed under the GNU GPL |
| |
+-----------------------------------------------------------------------+
*/
$rcmail_config = array();
// PEAR database DSN for read/write operations
// format is db_provider://user:password@host/database
// For examples see http://pear.php.net/manual/en/package.database.mdb2.intro-dsn.php
// currently supported db_providers: mysql, mysqli, pgsql, sqlite, mssql
//$rcmail_config['db_dsnw'] = 'sqlite://roundcubemail?mode=0646';
$rcmail_config['db_dsnw'] = 'mysql://roundcubeadmin:ADMINPASSWORD@MYHOSTNAME:3306/roundcubemail';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// Warning: for SQLite use absolute path in DSN:
// sqlite example: 'sqlite:////full/path/to/sqlite.db?mode=0646';
// PEAR database DSN for read only operations (if empty write database will be used)
// useful for database replication
$rcmail_config['db_dsnr'] = '';
// maximum length of a query in bytes
$rcmail_config['db_max_length'] = 512000; // 500K
// use persistent db-connections
// beware this will not "always" work as expected
// see: http://www.php.net/manual/en/features.persistent-connections.php
$rcmail_config['db_persistent'] = FALSE;
// you can define specific table names used to store webmail data
$rcmail_config['db_table_users'] = 'users';
$rcmail_config['db_table_identities'] = 'identities';
$rcmail_config['db_table_contacts'] = 'contacts';
$rcmail_config['db_table_session'] = 'session';
$rcmail_config['db_table_cache'] = 'cache';
$rcmail_config['db_table_messages'] = 'messages';
// you can define specific sequence names used in PostgreSQL
$rcmail_config['db_sequence_users'] = 'user_ids';
$rcmail_config['db_sequence_identities'] = 'identity_ids';
$rcmail_config['db_sequence_contacts'] = 'contact_ids';
$rcmail_config['db_sequence_cache'] = 'cache_ids';
$rcmail_config['db_sequence_messages'] = 'message_ids';
// end db config file
?>
May be I need to add something to the path? Or php.ini?? I have no idea...I did go through few threads and did what they said but again no luck...here is what I included in my php.ini...
include_path = ".:/usr/local/include:/usr/local/lib/php:/usr/local/bin/pear:/usr/local/lib/php/data/MDB2_Driver_mysql"
[MySQL]
mysql.default_port = 3306
mysql.default_host = MYHOSTNAME
Do I need to add anything else anywhere am I missing something?