"SERVICE CURRENTLY NOT AVAILABLE!"

[Phase3]

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:

<?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://userassword@host/databse
// currentyl suported db_providers: mysql, sqlite

$rcmail_config['db_dsnw'] = 'mysql://riponcom_cubeassword@localhost/riponcom_roundcube';
// postgres example: 'pgsql://roundcubeass@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.

[Tucker]

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

[Phase3]

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.

[Tucker]

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?

[Phase3]

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.

[Tucker]

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.

[Phase3]

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 james@riponcommunitychurch.co.uk failed (LOGIN): "a001 NO Login failed."