====== Migrate vpopmail Accounts to LDAP ======
<toc></toc>
1. Dump the accounts from MySQL

<code>
mysqldump -u root -p vpopmail vpopmail &gt; vpopmail.mydump
</code>
2. Convert mysql dump to LDIF with reformatting

<code>
awk -F\' 'BEGIN {OFS=&quot;\n&quot;;} NF==15 {print &quot;dn: cn=&quot;$8&quot;,ou=&quot;$4&quot;,ou=qmail,o=company&quot;,&quot;cn: &quot;$8,&quot;objectClass: top&quot;,&quot;objectClass: person&quot;,&quot;objectClass: qmailUser&quot;,&quot;mail: &quot;$2&quot;@&quot;$4,&quot;sn: &quot;$8,&quot;uid: &quot;$2&quot;@&quot;$4,&quot;mailMessageStore: &quot;$10,&quot;userPassword: {CRYPT}&quot;$6,&quot;&quot;}' vpopmail.mydump &gt; qmail-ldap.ldif
</code>
<em>Accounts which contain an apostrophe will be missing (O'Reilly) because that is what we're using for delimeters.</em>  Find offenders with:

<code>
awk -F\' 'NF &gt; 15' vpopmail.mydump
</code>
3. Manually add a section to the top of the LDIF file to create each domain OU.  You should also clean up any records which are obviously invalid.

<code>
dn: ou=domain.com,ou=qmail,o=company
objectClass: top
objectClass: organizationalUnit
ou: domain.com
description: domain.com
</code>
4. Import the LDIF file into the LDAP directory

<code>
ldapadd -vx -h localhost -D &quot;cn=manager,o=company&quot; -W -f qmail-ldap.ldif
</code>