Roundcube Community Forum

 

Can't ge to work

Started by Epic.Nme, January 30, 2008, 06:22:40 PM

Previous topic - Next topic

Epic.Nme

Hello I want exactly what RoundCube provides... So I'm trying get this to work on my website.... So far I have done the following...

UNDER "db.inc.php"
+"$rcmail_config['db_dsnw']" to "mysql://demouser:[email protected]/roundcube"
Then saved

Under "main.inc.php"
+" $rcmail_config['enable_caching'] = '' " to " $rcmail_config['enable_caching'] = 'FALSE' "
+" $rcmail_config['default_host'] = '' " to " $rcmail_config['default_host'] = 'imap.domain.com' "
+" $rcmail_config['default_port'] = 143" to " Left it the same "
+" $rcmail_config['smtp_server'] = '' " to " $rcmail_config['smtp_server'] = 'smtp.aaogc.com' "
+" $rcmail_config['smtp_port'] = 25" to " Left it the same "
+" $rcmail_config['smtp_user'] = ''; $rcmail_config['smtp_pass'] = '' " to " $rcmail_config['smtp_user'] = '%u'; $rcmail_config['smtp_pass'] = '%p' "
Then saved

Uploaded to mail.aaogc.com, then typed http://mail.aaogc.com/mysql.initial.sql
now when I go to Http://mail.aaogc.com I get
"DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator."

Any help is greatly appreciated.

corpo

Might I suggest you read the "Database" section of the INSTALL file provided with roundcube? It details everything you need to know about setting up the database, a step which you appear to have completely skipped over. Of course, the guide to setting up the database includes only command line instructions, so if you're more of a pointy-clicky type (or your hosting provider does not provide shell access), I would suggest you look into phpMyAdmin.


Epic.Nme

I set up my data base....
Name:aaogccom_mail
Username:aaogccom_mail
Pass: ****

I just didn't include those details.. Once I created this database Am I suppose to do something to it?

corpo

Yes - you need to initialize the database with the mysql.initial.sql file in the SQL folder at the root of the roundcube folder. If you have command line access this is done by cd'ing to the root of the roundcube directory, and typing the following command "mysql -u aaogccom_mail -p aaogccom_mail < SQL/mysql.initial.sql" you'll be prompted for the database password, enter it. This may not work if your hosting provider uses a different server/address for mysql dbs - in which case, find out what that url is and insert "-h
" before the -u in the mysql command. If you don't have/like command line access - phpMyAdmin will allow you to upload sql files (look for something like "import"). Make sure that your db config parameters match those for your mysql database ($rcmail_config['db_dsnw'] = 'mysql://aaogccom_mail:password@/aaogccom_mail'). If you manage all that, you should be up and running.

stevef1011

I am having the same problem. However prior to the database error message I am receiving the following:

A Runtime Error has occurred
Do you wish to Debug?

Line 11
Error: 'rcmail' is undefined

This pops up in a window before getting to the database error message. I am positive I setup the database correctly. A few more examples and explanations of the php files in the config folder may help. Is the code posted by Epic.Nme correct?

Any help would be appreciated.