Author Topic: MDB2 Error: not found  (Read 8646 times)

Offline nmoudgil

  • Newbie
  • *
  • Posts: 3
MDB2 Error: not found
« on: February 11, 2010, 10:53:18 AM »
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:

Code: [Select]
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":

Code: [Select]
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...

Code: [Select]
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
MDB2 Error: not found
« Reply #1 on: February 11, 2010, 11:26:59 AM »
RoundCube looks for the mysql driver not a database. The "pear list" doesn't list php's mysql driver. try installing the driver using these instructions PHP: Installation - Manual

Offline Martian

  • Jr. Member
  • **
  • Posts: 35
MDB2 Error: not found
« Reply #2 on: February 11, 2010, 10:53:51 PM »
You need to make sure that you have allowed TCP connections on the MySQL host pc since it is a different PC (apologies if you already know that).  Also be sure to check your host file and make sure that the PC the is running Roundcube is specifically allowed.

Martain

Offline omoiza

  • Newbie
  • *
  • Posts: 9
MDB2 Error: not found
« Reply #3 on: October 21, 2010, 08:51:30 AM »
friend to solve the problem? Here I am with a similar problem ... it is detecting erroneously as POSTGRES...

-=-=
Friends, I got that mysql was listed as active, I installed php5-mysql php5-mycrpt and also what was missing (not to influence, but at least it is better meets the requirements). I'm still looking for the fileinfo, until I saw where he was replaced by the RoundCube libmagic but does not agree: (. If I find the solution post here.

Grateful to those who have tips.
« Last Edit: October 21, 2010, 11:49:05 AM by omoiza »

Offline Gautham Vignesh

  • Jr. Member
  • **
  • Posts: 41
MDB2 Error: not found
« Reply #4 on: November 11, 2010, 12:51:55 PM »
Hi,
    How this error can be fixed :

I am having all databases under "NOT INSTALLED" category
even though i configured the databses required for roundcubemail.


DB Error: [Error message: extension mysql is not compiled into PHP]
 ** mysql(mysql)://root:xxx@localhost/roundcubemail in /var/www/roundcubemail-0.4.2/program/include/rcube_mdb2.php on line 101 (GET /roundcubemail-0.4.2/)
____________
B.Gautham Vignesh

__________________