Running Debian with Apache/MySQL/Dovecot/Postfix.
We installed from apt this time, whereas previous instances, we grabbed a
tar or the like with wget. We made sure we had gotten roundcube-mysql as
well. And we followed the installer wizard within apt. This seemed to
configure a lot automatically that we are used to doing manually.
When I attempt to login to the web GUI, I get the error 'Connection to
storage server failed'.
In my mail logs I see the following entries:
Mar 7 15:27:55 <machine-name> dovecot: imap-login: Disconnected (no auth attempts in 0
secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS, session=<xXIBJ/i8hpV/AAAB>
The thing that stands out is that the user is empty.
I have confirmed that the apt wizard did generated a roundcube MySQL user,
I was able to login as that user, confirmed the roundcube database was
created, and was able to query from it as the roundcube user.
When I query SELECT * FROM users in the roundcube database in MySQL, it is
completely empty. I could be wrong, but I suspect this is the problem.
But on previous systems where we had roundcube, I see the users table is
populated. However, I never really knew how this table got its entries?
Does roundcube somehow have to communicate with Dovecot (or to the
Dovecot database?) to get existing users? Should a straight-up IMAP login
be occurring the first time using that Web GUI login screen, and *then* it
populates the roundcube.users table?
I'm feeling like this is a chicken-or-the-egg situation. Not sure how to
proceed next?
Here some conf files if they are relevant:
debian-db.php:
<?php
$dbuser='roundcube';
$dbpass='<password>';
$basepath='';
$dbname='roundcube';
$dbserver='127.0.0.1';
$dbport='3306';
$dbtype='mysql';
(suspiciously no closing ?> php tag?? Should it matter?)
debian-db-roundcube.php:
<?php
include_once("/etc/roundcube/debian-db.php");
switch ($dbtype) {
case "sqlite":
case "sqlite3":
$config['db_dsnw'] = "sqlite:///$basepath/$dbname?mode=0640";
break;
default:
if ($dbport != '') $dbport=":$dbport";
if ($dbserver == '') $dbserver="127.0.0.1";
$config['db_dsnw'] =
"$dbtype://$dbuser:$dbpass@$dbserver$dbport/$dbname";
break;
}
?>
_______________________________________________
Roundcube Users mailing list
[email protected]
http://lists.roundcube.net/mailman/listinfo/users
