quasi wrote:

I get a blank page. It says nothing. If I try to access roundcube.myserver.com/index.php Apache Log error file says: [Thu Mar 2 01:14:56 2006] [error] PHP Notice: DB Error: connect failed in /WebServer/roundcubemail/program/include/bugs.inc on line 80 [Thu Mar 2 01:14:56 2006] [error] PHP Fatal error: Call to undefined function: query() in /WebServer/roundcubemail/program/include/rcube_db.inc on line 213

I also have exactly the same problem only on Debian (Apache 2.0.5.4, PHP 5.1.2-1, mysql 5.0.18-8)

Regards,

Alex

Geoffrey McCaleb wrote:

I had the same problem as well. It turned out that I had set the wrong db name in the config (the username and password and host were all correct).

Geoffrey

Roundcube config:

$rcmail_config['db_dsnw'] = 'mysql://roundcube:secret@localhost/roundcube'; // postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail'; // sqlite example: 'sqlite://./sqlite.db?mode=0646';

MySQL dump:

mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | gallery2 | | joomla | | mysql | | roundcube | | test | +--------------------+

This looks okay to me but I may be missing something.

Alex

On Thu, 2006-03-02 at 13:37 +0000, Alex Pimperton wrote:

quasi wrote:

...

I get a blank page. It says nothing. If I try to access roundcube.myserver.com/index.php Apache Log error file says: [Thu Mar 2 01:14:56 2006] [error] PHP Notice: DB Error: connect failed in /WebServer/roundcubemail/program/include/bugs.inc on line 80 [Thu Mar 2 01:14:56 2006] [error] PHP Fatal error: Call to undefined function: query() in /WebServer/roundcubemail/program/include/rcube_db.inc on line 213

I also have exactly the same problem only on Debian (Apache 2.0.5.4, PHP 5.1.2-1, mysql 5.0.18-8)

I also initially had the same problem and it was caused by not having all the prerequisetes installed and not properly authenticating to the mysql database. Here are a few things to try:

1. In main.inc.php set debug_level to 15 so you'll get diagnostics:

$rcmail_config['debug_level'] = 15;

2. Set the database word to a known value (foo in this example)) and

make sure that is what roundcube is using:

% mysql

use mysql update user set password=PASSWORD("foo") where user="roundcube";

In db.inc.php:

$rcmail_config['db_dsnw'] = 'mysql://roundcube:foo@localhost/roundcubemail';

3. Make sure you've got all the php components installed, especially

php-mysql and php-pear

HTH,

I've tried everything you suggested.

Bringing the loglevel to 15 outputs in browser: DB Error in /WebServer/roundcubemail/program/include/rcube_db.inc
(97): DB Error: connect failed

Fatal error: Call to undefined function: query() in /WebServer/ roundcubemail/program/include/rcube_db.inc on line 213

Line 213 says: $result = $this->db_handle->query($query, $params);

What (97) is error of I don't know.

I'm not sure about the php-mysql and the php-pear parts. Shouldnt
they be installed by default with my php version?

/q.

2 mar 2006 kl. 17.58 skrev Alex Pimperton:

John Dennis wrote:

...

I also initially had the same problem and it was caused by not having all the prerequisetes installed and not properly authenticating to
the mysql database. Here are a few things to try:

1. In main.inc.php set debug_level to 15 so you'll get diagnostics:

$rcmail_config['debug_level'] = 15;

2. Set the database word to a known value (foo in this example)) and

make sure that is what roundcube is using:

% mysql

...

use mysql update user set password=PASSWORD("foo") where user="roundcube";

In db.inc.php:

$rcmail_config['db_dsnw'] = 'mysql://roundcube:foo@localhost/ roundcubemail';

3. Make sure you've got all the php components installed, especially

php-mysql and php-pear

Thanks very much for your help.

I removed the database and user, flushed privileges and then re- created and it works fine now.

Either MySQL or myself must have got confused...

Alex

-- This message has been scanned for viruses and dangerous content by MailScanner , and is believed to be clean.

On Thu, 2006-03-02 at 18:20 +0100, quasi wrote:

I've tried everything you suggested.

Not quite :-)

Bringing the loglevel to 15 outputs in browser: DB Error in /WebServer/roundcubemail/program/include/rcube_db.inc (97): DB Error: connect failed

Fatal error: Call to undefined function: query() in /WebServer/roundcubemail/program/include/rcube_db.inc on line 213

Line 213 says: $result = $this->db_handle->query($query, $params);

What (97) is error of I don't know.

I'm not sure about the php-mysql and the php-pear parts. Shouldnt they be installed by default with my php version?

You're missing php database components. It's not safe to just assume they're installed. I don't know what type of system you're on so I may not be able to help you determine the presence or absence of php components, but I can tell you that on Fedora/RHEL PHP is "alacarte", you install only what you need and these components are not installed when you install php.

I'm not 100% certain you need php-pear, for me this was a little bit of a trial and error, but I was getting exactly that error until I started adding php components.

If you're on a Fedora system you can do this:

% rpm -qa | grep php

this will tell which php components are installed, if you're missing them you can do something like this:

% yum install php-mysql