I am fairly certain that my DB is set up correctly. I am also using phpBB2, for example, and it doesn't have any problems. I have created a user named roundcube and a DB named roundcube, and I can access it with the command line client easily; for example:
$ mysqlshow -u roundcube -p roundcube session Database: roundcube Table: session Rows: 0 +---------+-------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+ | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | +---------+-------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+ | sess_id | varchar(32) | latin1_swedish_ci | | PRI | | | select,insert,update,references | | | created | datetime | NULL | | | 0000-00-00 00:00:00 | | select,insert,update,references | | | changed | datetime | NULL | | | 0000-00-00 00:00:00 | | select,insert,update,references | | | ip | varchar(15) | latin1_swedish_ci | | | | | select,insert,update,references | | | vars | text | latin1_swedish_ci | | | | | select,insert,update,references | | +---------+-------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+
and my DSN in config/db.inc.php is:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:roundcube@localhost/roundcube';
So, as far as I can tell, it is configured correctly. Is it possible to tell what credentials it is trying to use to connect to MySQL, or specfically what caused the error?
Thanks, P. J.
On Tue, Jan 17, 2006 at 05:27:08PM +0100, thomas br?derli wrote:
Hi
The main error is "DB Error: connect failed". This means that either the DSN you configured in config/db.inc.php is not right or that PHP in general can't connect to the MySQL database. Do you have other PHP apps that use MySQL (i.e. phpMyAdmin) running on that server? If you have, then check the settings they use and try to apply them to the RoundCube configuration.
Regards, Thomas
P. J. Reed wrote:
I just subscribed to this mailing list, so hopefully this question hasn't been asked a thousand times, but I couldn't find any archives of the users list, only the dev list.
Anyway, I'm trying to set up RoundCube on my personal web server. I've set up a database and edited the config files appropriately, but when I try to access index.php, I get the following error:
DB Error in /home/speed/public_html/roundcube/program/include/rcube_db.inc (63): DB Error: connect failed
Fatal error: Call to undefined function: query() in /home/speed/public_html/roundcube/program/include/rcube_db.inc on line 124
I've poked around a little bit, and I have no idea what's wrong, but I'll admit that I don't know much about PHP.
If it matters, I'm using Apache 1.3.20, PHP 4.4.1, and MySQL 4.1.16.
Thanks, P. J.
--
Br?ckfeldstrasse 10a / CH-3012 Bern / Phone +41-31-301 05 29 GnuPG public key http://brotherli.ch/public-key