I am getting DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
Login to mySQL database is successful using command prompt with the same username/password I use in db.inc.php This is my db.inc.php (password removed):
Code:
<?php $rcmail_config = array(); $rcmail_config['db_dsnw'] = 'mysql://ytbmailc_ytbmail:mypassword@localhost/ytbmailc_roundcubemail'; $rcmail_config['db_dsnr'] = ''; $rcmail_config['db_backend'] = 'db'; $rcmail_config['db_max_length'] = 512000; // 500K $rcmail_config['db_persistent'] = TRUE; $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'; $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 ?>
I'm stumped at this point. Can anyone help?
No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started.
Try using the IP address of the mySQL server instead of localhost.
~Brett
William Moreno wrote:
I am getting DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
Login to mySQL database is successful using command prompt with the same username/password I use in db.inc.php This is my db.inc.php (password removed):
Code:
<?php $rcmail_config = array(); $rcmail_config['db_dsnw'] = 'mysql://ytbmailc_ytbmail:mypassword@localhost/ytbmailc_roundcubemail'; $rcmail_config['db_dsnr'] = ''; $rcmail_config['db_backend'] = 'db'; $rcmail_config['db_max_length'] = 512000; // 500K $rcmail_config['db_persistent'] = TRUE; $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'; $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 ?>
I'm stumped at this point. Can anyone help?
No need to miss a message. Get email on-the-go http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail with Yahoo! Mail for Mobile. Get started. http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail
hi, William...
On 1/21/07, William Moreno morenointl@yahoo.com wrote:
I am getting DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
what OS are you running, php version and database engine.....check your log files to see if it shows you the error on connecting.
one more thing, login may be successful with that username and password, but does that user have privileges on that database?
Login to mySQL database is successful using command prompt with the same
username/password I use in db.inc.php This is my db.inc.php (password removed):
Code:
<?php $rcmail_config = array(); $rcmail_config['db_dsnw'] = 'mysql://ytbmailc_ytbmail:mypassword@localhost /ytbmailc_roundcubemail'; $rcmail_config['db_dsnr'] = ''; $rcmail_config['db_backend'] = 'db'; $rcmail_config['db_max_length'] = 512000; // 500K $rcmail_config['db_persistent'] = TRUE; $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'; $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 ?>
I'm stumped at this point. Can anyone help?
No need to miss a message. Get email on-the-go http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A with Yahoo! Mail for Mobile. Get started.http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A
I would echo the idea of checking priviledges on the database for the account you're using. If it's on the same server as roundcube I would generally want to use localhost rather than a network-accessible interface. My 2 cents.
On 1/22/07, Mike Barnard mike.barnardq@gmail.com wrote:
hi, William...
On 1/21/07, William Moreno morenointl@yahoo.com wrote:
I am getting DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
what OS are you running, php version and database engine.....check your log files to see if it shows you the error on connecting.
one more thing, login may be successful with that username and password, but does that user have privileges on that database?
Login to mySQL database is successful using command prompt with the same
username/password I use in db.inc.php This is my db.inc.php (password removed):
Code:
<?php $rcmail_config = array(); $rcmail_config['db_dsnw'] = ' mysql://ytbmailc_ytbmail:mypassword@localhost/ytbmailc_roundcubemail'; $rcmail_config[ 'db_dsnr'] = ''; $rcmail_config[ 'db_backend'] = 'db'; $rcmail_config ['db_max_length'] = 512000; // 500K $rcmail_config['db_persistent'] = TRUE; $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' ; $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 ?>
I'm stumped at this point. Can anyone help?
No need to miss a message. Get email on-the-go http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A with Yahoo! Mail for Mobile. Get started.http://us.rd.yahoo.com/evt=43910/*http://mobile.yahoo.com/mail%0A
--
Of course, you might discount this possibility, but remember that one in a million chances happen 99% of the time.
ph10
-
Brett Patterson -
Jeff Davis -
Mike Barnard -
William Moreno