Replying to myself:
On Thu, Feb 2, 2012 at 4:52 PM, Peter Peltonen <[email protected]> wrote:
> I do not see any marks of a connection attempt in the new IMAP
> server's (Dovecot) log.
>
> How to debug this further?
After turning MySQL query logging on and seeing the queries done by
Sogo while authenticating, I realised I had a typo in my CREATE VIEW
statement. After fixing that I could login via the web UI.
Also it should be noted that the SOGoIMAPServer needs to be defined in
the domain dict but not in the SOGoUserSources dict, so this is the
correct definition:
<key>newdomain.tld</key>
<dict>
<key>SOGoMailDomain</key>
<string>newdomain.tld</string>
<key>SOGoIMAPServer</key>
<string>imaps://newserver.tld:993</string>
<key>SOGoUserSources</key>
<array>
<dict>
<key>canAuthenticate</key>
<string>YES</string>
<key>id</key>
<string>newdomain.tld</string>
<key>isAddressBook</key>
<string>YES</string>
<key>type</key>
<string>sql</string>
<key>userPasswordAlgorithm</key>
<string>crypt</string>
<key>viewURL</key>
<string>mysql://sogocal:[email protected]:3306/vpopmail/sogo_newdomain</string>
</dict>
</array>
</dict>
Cheers,
Peter
--
[email protected]
https://inverse.ca/sogo/lists
