Problem solved! Actually, my problem wasn't the same as yours, but thanks to a clue I got from what you said, I was able to figure it out. I noticed that if I tried to have it log in to an account without a password, it would work, and I had the same problem with another application some time ago...
Newer versions of MySQL use a password hashing scheme that is not compatible with older versions, and applications designed to work with the older version can't handle the newer one. The easiest way to fix that is by doing this:
GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY OLD_PASSWORD('roundcube');
This sets the password using the old hashing mechanism, and after that, RoundCube is now working. Thanks!
P. J.
On Tue, 17 Jan 2006 13:58:59 -0600, "Wanat, David A [FPM]" dwanat@iastate.edu wrote:
I had a similar problem... I had to run this SQL to grant appropriate privileges to my MySQL user for roundcube to work, even though said user already had all privileges.
GRANT ALL PRIVILEGES ON database.* TO user@localhost IDENTIFIED BY 'password';
I hope this helps -David
-----Original Message----- From: Phillip Reed [mailto:speed@sakabatou.net] Sent: Tuesday, January 17, 2006 1:53 PM To: users@lists.roundcube.net Subject: Re: Call to undefined function: query() when trying to install
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
-
P.J.Reed