Originally I posted this in the incorrect forum ( http://roundcubeforum.net/forum/index.php?topic=434.0 ) I'm such a fool.
My error:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)
My error log:
[19-Aug-2006 09:40:07 -0400] DB Error: DB Error: connect failed in /home/riponcom/public_html/mail/program/include/rcube_db.inc on line 105
[19-Aug-2006 09:43:48 -0400] DB Error: DB Error: connect failed in /home/riponcom/public_html/mail/program/include/rcube_db.inc on line 105
[19-Aug-2006 09:52:36 -0400] DB Error: DB Error: connect failed in /home/riponcom/public_html/mail/program/include/rcube_db.inc on line 105
I have read previous topics on the same issue, however, I was unable to find any typos in my documents.
I haven't yet gone through the 'installation process' because I can't get to the index file. I have CDMODed the 'mysql.initial' to execute. I've used cpanel to create the databases/username. They have named them as 'riponcom_roundcube' (database) and 'riponcom_cube' (username). Where as I named them originally as 'roundcube' (database) and 'cube' (username). I have replaced these as the paths but the programme still fails to work.
PHP version 4.4.2
MySQL version 4.1.21-standard
Db.inc.php:
/*
+-----------------------------------------------------------------------+
| Configuration file for database access |
| |
| This file is part of the RoundCube Webmail client |
| Copyright (C) 2005, 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/databse
// currentyl suported db_providers: mysql, sqlite
$rcmail_config['db_dsnw'] = 'mysql://riponcom_cube:password@localhost/riponcom_roundcube';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// sqlite example: 'sqlite://./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'] = '';
// database backend to use (only db or mdb2 are supported)
$rcmail_config['db_backend'] = 'db';
// maximum length of a query in bytes
$rcmail_config['db_max_length'] = 512000; // 500K
// use persistent db-connections
$rcmail_config['db_persistent'] = TRUE;
// 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
?>
Thanks.
Hi,
I ran into the same problem.
One workaround is
Set the Debug-Level in the main.inc.php to 4
$rcmail_config['debug_level'] = 4;
If you get an error like "could not connect to database" (i don't remember it exactly),
try to login to the db on the commandline
eg. mysql -u rc_user -p rc_db
with your password. if that fails, you should give the following a try
log into the db as root or a privileged user
and do a
FLUSH PRIVILEGES;
That worked for me,
Tucker
Thanks. I really appreciate the reply. I set the debug level in main.inc.php to 4. Responded with this error:
DB Error in /home/riponcom/public_html/mail/program/include/rcube_db.inc (105): DB Error: connect failed
SERVICE CURRENTLY NOT AVAILABLE!
DB Error: connect failed
It hasn't seem to have logged the error in the logs. I ran a SQL query on the database? I wasn't sure if that's what I was supposed to do. I recieved this error
"SQL query:
FLUSH PRIVILEGES ;
MySQL said:
#1227 - Access denied; you need the RELOAD privilege for this operation "
I logged presumably into phpMyAdmin as root.
Oh, there is a link in phpMyAdmin on the startpage (the page on that you are able to create new databases)
Its called Reload MySQL
I would really advise you to revisit the username and database name in phpadmin
Really a database riponcom_roundcube ?
And really a user riponcom_cube in the mysql.user - table?
It now comes up with "DB Error in /home/riponcom/public_html/mail/program/include/rcube_db.inc (105): DB Error: insufficient permissions
SERVICE CURRENTLY NOT AVAILABLE!
DB Error: insufficient permissions"
I changed the user/password in the db.inc.php file. I changed it to just riponcom and the database 'roundcube'. I have deleted the user in cpanel but it makes no difference to this permissions error.
(http://www.riponcommunitychurch.co.uk/james/images/mysql.jpg)
So, i took a little look at cpanel and
this screenshot was a brilliant idea!
Of course you can't connect, cause there are no tables in the riponcom_roundcube database!
1. Select the database (as you did) in phpMyAdmin
2. click at the SQL Button just over the Database SelectBox
3. A second window will open with tabs/registers
4. Go to the "Import Files" Tab
5. Upload the file "mysql.initial.sql" from the SQL-Folder of your local roundcube-archive/folder click on the GO-BUtton
Now you will have a (6) behind your roundcube database.
In your db.inc.php change the line again back in the way you started:
$rcmail_config['db_dsnw'] = 'mysql://riponcom_cube:password@localhost/riponcom_roundcube';
I assume that this user has enough permissions (you gave him all?), SELECT, UPDATE, INSERT,DELETE would be sufficient - but perhaps you will do something else in this database latzer, so leave it by ALL.
But if not: !!! Got to cpanel and grant him permissions !!!
I think, that will work!
Tucker
Sorry, I didn't realize from the very beginning that you are working with cpanel - and i know (knew) nothing about cpanel. ???
Thanks, that worked. :)
Ok, maybe not.. I'm trying to login with one of my e-mails I created in cpanel.
I get this error:
IMAP Error: Authentication for
[email protected] failed (LOGIN): "a001 NO Login failed."