Hello,
Am Dienstag, 11. Oktober 2011 schrieb Simon Loewenthal:
> The database was exported using mysqldump --all-databases>backup.sql,
> and imported with mysql <backup.sql
>
> The postfix installtion is a tar ball from the old server, along with
> the dovecot/postfix/roundcube installations.
>
> In the new set-up, postfixadmin creates the user in the roundcube
> database, but it is not seen in the mailserver database!
Just curious: you say "roundcube database" - is this the same database
that is also used by postfix? Or a different one?
> Existing users (those that exist in the mailserver and roundcube
> database) can log in.
>
>
> What is strange that one can log in via RoundCube (IMAP->dovecot) with
> the newly created user, but one cannot use IMAP directly with
> Dovecot, nor with AUTH PLAIN over smtp to postfix.
Sounds like it accesses an out-of-date database.
Check your config if you have the hostname or IP of the old server
hardcoded somewhere so that it queries the database on the old server.
Or you really have two separate databases (I never used roundcube, so I
don't know if it needs something like that) and need to sync them
somehow. If it worked on the old server, implement the same thing on the
new one ;-)
> What I see in the log files are:
> dovecot: auth-worker(default): sql(te...@ex...,127.0.0.1):
> unknown user
>
> Which makes sense, because the user was never put into the mailserver
> database...
>
>
> I have verified that the user postfixadmin has the correct grants on
> the database specified in the config.inc.php, and the md5sum on both
> old and new config.inc.php are the same.
Same question here: hardcoded hostname or IP of the old server?
Oh, BTW: does setup.php give any hints or errors?
> I have logging enabled in the config.inc.php :
> $CONF['logging'] = 'YES';
>
>
> My question:
> Where is the logging sent to? I cannot find it. At least then I could
> start to diagnose the this with possible error messages.
$CONF[logging] enables logging of all modifications on mailboxes,
aliases etc. It's stored in the database (table "log") and available in
the "view log" page of PostfixAdmin.
Just to be sure, also check your apache error log.
Regards,
Christian Boltz
--
Du hast jetzt relativ kompliziert die völlig korrekte Aussage:
"SPF ist krank, funktioniert nicht und vom Ansatz her bereits defekt."
formuliert. [Peer Heinlein in postfixbuch-users]
|