Just tried to install roundcube, followed the guide here: http://www.paulstamatiou.com/2005/10/29/how-to-setup-roundcube- webmail-on-your-server/
I did everything, but still I ran into some problems.
When I try to access the site at: http://roundcube.myserver.com
I get a blank page. It says nothing. If I try to access roundcube.myserver.com/index.php
also same blank page. I can access the images but not the .php files.
My system is OS X Server 10.4.5 And I have installed MAMP 1.1.1 (PHP
5.1.2, MYSQL 4.1.12, Apache 2.0.55)
Phpmyadmin runs fine, and so does other projects in the mysql DB.
Apache Log Access file says: GET /HTTPD/1.1" 200 5
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
Anyone knows what's up?
Am I missing some php modules? No mysql connection? what?
/quasi
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
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
On Thu, 02 Mar 2006 13:37:19 +0000, Alex Pimperton alex@erus.co.uk 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)
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
Sorry to ask the obvious, but does that user have permissions for that db?
On another angle, if you physically change the db name in the config, do you get a mysql error? If you don't, it might help narrow down the problem.
Geoffrey
On Thu, 02 Mar 2006 14:05:45 +0000, Alex Pimperton alex@erus.co.uk wrote:
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:
- In main.inc.php set debug_level to 15 so you'll get diagnostics:
$rcmail_config['debug_level'] = 15;
- 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';
- Make sure you've got all the php components installed, especially
php-mysql and php-pear
HTH,
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:
- In main.inc.php set debug_level to 15 so you'll get diagnostics:
$rcmail_config['debug_level'] = 15;
- 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';
- 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
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:
- In main.inc.php set debug_level to 15 so you'll get diagnostics:
$rcmail_config['debug_level'] = 15;
- 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';
- 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.
Either the password, username, or actual host of the database server is incorrect. The line 213 error is because of the initial non-connection error. Double check your settings.... (again if it's already been suggested)
~Brett
quasi wrote:
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:
- In main.inc.php set debug_level to 15 so you'll get diagnostics:
$rcmail_config['debug_level'] = 15;
- 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';
- 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
-
Alex Pimperton -
Brett Patterson -
Geoffrey McCaleb -
John Dennis -
quasi