I installed rc1 a while ago, but just got around to playing with it
recently and noticed that it's not working _at all_ I simply get a
blank screen when I try to load it.
I turned on error_reporting = E_ALL in php.ini and have looked in
the server's httpd-error logs to no avail, I still get a blank screen
when I try to access RC (and yes, I did restart apache after making
changes to php.ini)
There's also nothing but the .htaccess file in roundcube's logs/
directory.
On 7/25/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
I installed rc1 a while ago, but just got around to playing with it recently and noticed that it's not working _at all_ I simply get a blank screen when I try to load it.
I turned on error_reporting = E_ALL in php.ini and have looked in the server's httpd-error logs to no avail, I still get a blank screen when I try to access RC (and yes, I did restart apache after making changes to php.ini)
There's also nothing but the .htaccess file in roundcube's logs/ directory.
Hello,
Have you updated your database after installation. Or if this is a fresh installation, you have built the correct database?
kmn _______________________________________________ List info: http://lists.roundcube.net/users/
On 25-Jul-2007, at 20:16, kmnair wrote:
On 7/25/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
I installed rc1 a while ago, but just got around to playing with it recently and noticed that it's not working _at all_ I simply get a blank screen when I try to load it.
Have you updated your database after installation. Or if this is a fresh installation, you have built the correct database?
Since my configurations were gone,I just wiped the old database and
re-initialized it following the procedure in the INSTALL document.
As I said, I can access the database from the command-line, so I know
it's not a password issue (unless RC has an issue with a 14 character
password containing letters and numbers).
I am no longer getting a blank screen, but am still getting "DATABASE
ERROR: CONNECTION FAILED!"
On 7/26/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
On 25-Jul-2007, at 20:16, kmnair wrote:
On 7/25/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
I installed rc1 a while ago, but just got around to playing with it recently and noticed that it's not working _at all_ I simply get a blank screen when I try to load it.
Have you updated your database after installation. Or if this is a fresh installation, you have built the correct database?
Since my configurations were gone,I just wiped the old database and re-initialized it following the procedure in the INSTALL document. As I said, I can access the database from the command-line, so I know it's not a password issue (unless RC has an issue with a 14 character password containing letters and numbers).
I am no longer getting a blank screen, but am still getting "DATABASE ERROR: CONNECTION FAILED!"
-- Lewis Butler 303.564.2512
That is a very specific error messge and it usually means just that. Are you sure the roundcube user has dba access on the database. It would be better to check the permissions once again.
I am not aware of any restrictions on the length/nature of password, since it is a sql issue and not an RC issue. What is the database that you are using, mysql or pgsql.
kmn _______________________________________________ List info: http://lists.roundcube.net/users/
On 26-Jul-2007, at 11:02, kmnair wrote:
That is a very specific error messge and it usually means just that. Are you sure the roundcube user has dba access on the database. It would be better to check the permissions once again.
phpMyAdmin reports for the user 'rc-user'@'localhost':
+-Database-specific privileges--- | Database Privileges Grant Table-specific privileges Action | rc-database ALL PRIVILEGES Yes No
I am not aware of any restrictions on the length/nature of password, since it is a sql issue and not an RC issue. What is the database that you are using, mysql or pgsql.
mysql 4.1.22
On 7/27/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
On 26-Jul-2007, at 11:02, kmnair wrote:
That is a very specific error messge and it usually means just that. Are you sure the roundcube user has dba access on the database. It would be better to check the permissions once again.
phpMyAdmin reports for the user 'rc-user'@'localhost':
+-Database-specific privileges--- | Database Privileges Grant Table-specific privileges Action | rc-database ALL PRIVILEGES Yes No
I am not aware of any restrictions on the length/nature of password, since it is a sql issue and not an RC issue. What is the database that you are using, mysql or pgsql.
mysql 4.1.22
-- Lewis Butler 303.564.2512
The SQL folder contains two mysql.initial files. Did you use the mysql.initial or mysql5.initial file. If you have used the mysql5 file by mistake, this could be the reason.
I would suggest rebuilding the database once again using mysql.initial.
HTH
kmn _______________________________________________ List info: http://lists.roundcube.net/users/
On 26-Jul-2007, at 22:23, kmnair wrote:
The SQL folder contains two mysql.initial files. Did you use the mysql.initial or mysql5.initial file. If you have used the mysql5 file by mistake, this could be the reason.
This is the exact command I used:
mysql -u rc-user -p rc-database < SQL/mysql.initial.sql
and then I pasted in the password for the rc-user
On 7/27/07, Lewis Butler lbutler+roundcube@covisp.net wrote:
On 26-Jul-2007, at 22:23, kmnair wrote:
The SQL folder contains two mysql.initial files. Did you use the mysql.initial or mysql5.initial file. If you have used the mysql5 file by mistake, this could be the reason.
This is the exact command I used:
mysql -u rc-user -p rc-database < SQL/mysql.initial.sql
and then I pasted in the password for the rc-user
-- Lewis Butler 303.564.2512
Sorry, I am not at all familiar with the command line operation. Since you have mentioned that you have phpMyAdmin, why dont you try to use that. I agree, some people find the command line more comfortable, but it is also prone for errors if one is not very proficient.
kmn _______________________________________________ List info: http://lists.roundcube.net/users/
[Oops, forgot to send to list]
On 27-Jul-2007, at 07:47, kmnair wrote:
Sorry, I am not at all familiar with the command line operation. Since you have mentioned that you have phpMyAdmin, why dont you try to use that. I agree, some people find the command line more comfortable, but it is also prone for errors if one is not very proficient.
Recreated the database (in phpMyAdmin), the user (in phpMyAdmin), and
generated a new (8 character) password. It would be somewhat useful
is RC reported any sort of error that was at all useful or showed the
exact text of the query that was failing; but I can't seem to get it
to log anything at all to ANY log file. I even have
*.* /var/log/all.log
in /etc/syslog.conf but nothing at all is getting logged when I try
to access RC.
I threw together a little php script to login to mysql and check the
tables and IT works without issue and is using the same username and
password.
I have no where else to go from here.
in fact I think roundcube should have a log function so when user have problem, just chose the log, verbose log, very verbose log or debug mode so user can find the wrong place and fix it quickly.
I use a wrong mysql password in db.inc.php and the login screen print out mysql connect error, I think such error message should cc to log file too, screen printed error message was not properly be seen by user everytime, so cc to log file is a good choice.
I found there's some config about log in main.inc.php: // system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace $rcmail_config['debug_level'] = 4;
when I switch the debug_level to 8, I found a blank console window on the left top screen, maybe trace not implemented too.
BTW, add a line under the [mysqld] secion in my.cnf file should log everything and you can find out if your mysql was wrong configed. log=/var/log/mysqld.log
Lewis Butler 写道:
[Oops, forgot to send to list]
On 27-Jul-2007, at 07:47, kmnair wrote:
Sorry, I am not at all familiar with the command line operation. Since you have mentioned that you have phpMyAdmin, why dont you try to use that. I agree, some people find the command line more comfortable, but it is also prone for errors if one is not very proficient.
Recreated the database (in phpMyAdmin), the user (in phpMyAdmin), and generated a new (8 character) password. It would be somewhat useful is RC reported any sort of error that was at all useful or showed the exact text of the query that was failing; but I can't seem to get it to log anything at all to ANY log file. I even have
*.* /var/log/all.log
in /etc/syslog.conf but nothing at all is getting logged when I try to access RC.
I threw together a little php script to login to mysql and check the tables and IT works without issue and is using the same username and password.
I have no where else to go from here.
List info: http://lists.roundcube.net/users/
On 27-Jul-2007, at 19:51, tangaish.en wrote:
BTW, add a line under the [mysqld] secion in my.cnf file should log
everything and you can find out if your mysql was wrong configed. log=/var/log/mysqld.log
4 Connect Access denied for user
'roundcube'@'localhost' (using password: YES)
$ grep local /www/roundcube/config/db.inc.php $rcmail_config['db_dsnw'] = 'mysql://rc-user:<password>@localhost/rc- data';
So somewhere roundcube is trying to login as user 'roundcube'.
Well, this, FINALLY, led to the problem, the web path to roundcube
was linked against an old install.
So now I am back to a blank screen on load. Sigh.
BUT, at least now there is some logging in logs/errors:
[28-Jul-2007 06:52:57] PHP Warning: preg_split() [<a
href='function.preg-split'>function.preg-split</a>]: Compilation
failed: lookbehind assertion is not fixed length at offset 7 in /usr/
local/www/data-dist/roundcube/program/lib/DB/common.php on line 751
[28-Jul-2007 06:52:57] PHP Warning: Invalid argument supplied for
foreach() in /usr/local/www/data-dist/roundcube/program/lib/DB/
common.php on line 756
[28-Jul-2007 06:52:57 -0600] DB Error: DB Error: mismatch Query: [DB
Error: mismatch] in /usr/local/www/data-dist/roundcube/program/
include/rcube_db.inc on line 505
[28-Jul-2007 06:52:57] PHP Fatal error: Call to a member function
getMessage() on a non-object in /usr/local/www/data-dist/roundcube/
program/include/rcube_db.inc on line 366
mysql 4.1.22 php 5.2.3
Not liking php5, eh?