Odhiambo WASHINGTON
2007-May-29 15:02 UTC
[Dovecot] Migration from tpop3d to dovecot - troubles galore!
Hi people,
I am trying to migrate some users from tpop3d (Maildir mailboxes) to
dovecot. The most important aspect of this migration, and which I
cannot seem to get right, is to first be able to make dovecot to
authenticate against the current DB being used by tpop3d so that
I can use imapsync to transfer the user mails. And I do believe
that is what I am unable to get right!!
So here goes what I have tried so far:
Take a case of one username, eddie, who belongs to the domain,
demo.wananchi.com.
1. This query is what I am using for password_query. I do suspect it is
wrong, but well, this is what it yields from the current DB:
mysql> SELECT CONCAT(domain.path, '/', popbox.mbox_name),
popbox.password_hash FROM popbox, domain WHERE popbox.local_part =
'eddie' AND popbox.
domain_name = 'demo.wananchi.com' AND popbox.domain_name =
domain.domain_name;
+--------------------------------------------+---------------------------------------+
| CONCAT(domain.path, '/', popbox.mbox_name) | password_hash
|
+--------------------------------------------+---------------------------------------+
| /var/spool/virtual/demo.wananchi.com/eddie |
{md5}897fad9cbef974ff95254417234ff1df |
+--------------------------------------------+---------------------------------------+
2. This is what I use for user_query and the result:
mysql> SELECT CONCAT(domain.path, '/', popbox.mbox_name) as home, 6
as uid, 6 as gid FROM popbox, domain WHERE popbox.local_part = 'eddie'
AND
popbox.domain_name = 'demo.wananchi.com' AND popbox.domain_name =
domain.domain_name;
+-------------------------------------------------+-----+-----+
| home | uid | gid |
+-------------------------------------------------+-----+-----+
| /var/spool/virtual/nyerimunicipal.co.ke/eddie | 6 | 6 |
+-------------------------------------------------+-----+-----+
3. Getting a typical user would need this query, for example:
mysql> select CONCAT(local_part,'\@',domain_name) as user from popbox
limit 10;
+-------------------------+
| user |
+-------------------------+
| eddie at demo.wananchi.com |
+-------------------------+
4. My tables, and the data they contain:
(a)
mysql> desc popbox;
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| domain_name | varchar(255) | | PRI | | |
| local_part | varchar(255) | | PRI | | |
| password_hash | varchar(255) | YES | | NULL | |
| mbox_name | varchar(255) | YES | | NULL | |
| password_hash2 | varchar(255) | YES | | NULL | |
+----------------+--------------+------+-----+---------+-------+
(b)
mysql> select * from popbox limit 1;
+-------------------+------------+---------------------------------------+-----------+----------------+
| domain_name | local_part | password_hash |
mbox_name | password_hash2 |
+-------------------+------------+---------------------------------------+-----------+----------------+
| demo.wananchi.com | eddie | {md5}7bb1be8a78498a9de40098a593199819 | eddie
| 9IYjWHc4Cs9/w |
+-------------------+------------+---------------------------------------+-----------+----------------+
PS: Not all users have password_hash2, which I think is Unix crypt!!!
(c)
mysql> desc domain;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| domain_name | varchar(255) | | PRI | | |
| unix_user | varchar(255) | YES | | NULL | |
| password_hash | varchar(255) | YES | | NULL | |
| path | varchar(255) | YES | | NULL | |
| max_popbox | int(11) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
(d)
mysql> select * from domain limit 1;
+--------------+-----------+---------------------------------------+--------------------------------------+-----------------+
| domain_name | unix_user | password_hash | path
| max_popbox |
+--------------+-----------+---------------------------------------+--------------------------------------+-----------------+
| dlsnovit.org | exim | {md5}d108219901e577db69c249645ae3a49f |
/var/spool/virtual/demo.wananchi.com | 5 |
+--------------+-----------+---------------------------------------+--------------------------------------+-----------------+
[root at ns2]#less /var/log/dovecot.log
dovecot: May 29 17:42:57 Warning: Killed with signal 15
dovecot: May 29 17:42:59 Info: Dovecot v1.0.0 starting up
dovecot: May 29 17:42:59 Info: auth-worker(default): mysql: Connected to
localhost (virtualemail)
dovecot: May 29 17:44:02 Info: auth(default): client in: AUTH 1 PLAIN
service=POP3 secured lip=62.8.64.4 rip=62.8.64.4 resp=AGVk
ZGllQGRlbW8ud2FuYW5jaGkuY29tAGJvZWluZzgdovecot: May 29 17:44:02 Info:
auth-worker(default): sql(eddie at demo.wananchi.com,62.8.64.4): query: SELECT
CONCAT(domain.path, '/', popbox.mbox_n
ame), popbox.password_hash FROM popbox, domain WHERE popbox.local_part =
'eddie' AND popbox.domain_name = 'demo.wananchi.com' AND
popbox.domain_n
ame = domain.domain_name
dovecot: May 29 17:44:02 Error: child 40402 (auth-worker) killed with signal 11
dovecot: May 29 17:44:03 Info: auth(default): client out: FAIL 1
user=eddie at demo.wananchi.com temp
dovecot: May 29 17:44:05 Info: pop3-login: Aborted login: user=<eddie at
demo.wananchi.com>, method=PLAIN, rip=62.8.64.4, lip=62.8.64.4, secured
o That password_hash - is it usable at all with dovecot?
o Could password_hash2 be used? I could popolate the table with a known
value and use it, just for imapsync to complete!!
o What default_pass_scheme should I use in my userdb configuration?
I'll very much appreciate help on this. I am currently testing with
pop3, but once I get successful authentication, I will switch to imap
for imapsync.
Thanks for your time, and help, and advise:-)
-Wash
http://www.netmeister.org/news/learn2quote.html
DISCLAIMER: See http://www.wananchi.com/bms/terms.php
--
+======================================================================+
|\ _,,,---,,_ | Odhiambo Washington <wash at wananchi.com>
Zzz /,`.-'`' -. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com
|,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922
'---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733
744121
+======================================================================+
One, with God, is always a majority, but many a martyr has been burned
at the stake while the votes were being counted.
-- Thomas B. Reed
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2243 bytes
Desc: not available
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070529/e7954078/attachment-0002.bin>
Possibly Parallel Threads
Wisdom of the Ancients
