{"id":41,"date":"2016-06-29T11:14:15","date_gmt":"2016-06-29T19:14:15","guid":{"rendered":"http:\/\/iaastalk.com\/?p=41"},"modified":"2016-06-29T12:23:44","modified_gmt":"2016-06-29T20:23:44","slug":"quick-qmailtoaster-migrate-to-postfix","status":"publish","type":"post","link":"http:\/\/iaastalk.com\/?p=41","title":{"rendered":"quick qmailtoaster migrate to  Postfix"},"content":{"rendered":"<p>assume you are running example.com with qmailtoaster.<\/p>\n<ol>\n<li>install latest <a href=\"http:\/\/www.iredmail.org\">iredmail<\/a> which significantly simplify the whole process of installation and configuration.<\/li>\n<li>dump and import vpopmail\u00a0 into new db.<\/li>\n<li>copy\u00a0 \/home\/vpopmail\/domains\/* to \/var\/vmail1<\/li>\n<li>chown -R vmail:vmail \/var\/vmail1<\/li>\n<li>run following to move all the accounts into postfix vmail.mailbox table.<\/li>\n<li>done<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<pre>INSERT INTO vmail.mailbox ( username      , password                               , name      ,language  , storagebasedirectory   , storagenode   , maildir                , quota , domain           , transport , department , rank     , employeeid , isadmin , isglobaladmin , enablesmtp , enablesmtpsecured , enablepop3 , enablepop3secured , enableimap , enableimapsecured , enabledeliver , enablelda , enablemanagesieve , enablemanagesievesecured , enablesieve , enablesievesecured , enableinternal , enabledoveadm , `enablelib-storage` , `enableindexer-worker` , enablelmtp , enabledsync , enablesogo  , lastlogindate       , lastloginipv4 , lastloginprotocol , settings                  , passwordlastchange  , created , modified, expired               , active , local_part )\r\nSELECT                    concat(r.pw_name,'@example.com') , r.pw_passwd , r.pw_gecos, 'en_US'  , '\/var\/vmail'           , 'vmail1'      , substring(r.pw_dir,24) ,     0 ,'example.com' , ''        , ''         , 'normal' , ''       ,       0 ,             0 ,          1 ,                 1 ,          1 ,                 1 ,          1 ,                 1 ,             1 ,         1 ,                 1 ,                        1 ,           1 ,                  1 ,              1 ,             1 ,                 1 ,                    1 ,          1 ,           1 ,          1  , '1970-01-01 01:01:01' ,           0 , ''                , '' , '1970-01-01 01:01:01' , now()   , now()   , '9999-12-31 00:00:00' ,      1 , r.pw_name\r\nFROM vpopmail.example_com r;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>assume you are running example.com with qmailtoaster. install latest iredmail which significantly simplify the whole process of installation and configuration. dump and import vpopmail\u00a0 into new db. copy\u00a0 \/home\/vpopmail\/domains\/* to \/var\/vmail1 chown -R vmail:vmail \/var\/vmail1 run following to move all the accounts into postfix vmail.mailbox table. done &nbsp; INSERT INTO vmail.mailbox ( username , password [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/posts\/41"}],"collection":[{"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/iaastalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":3,"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":44,"href":"http:\/\/iaastalk.com\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/44"}],"wp:attachment":[{"href":"http:\/\/iaastalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/iaastalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/iaastalk.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}