squirrelmail/postfix issue

Luckily its not broken....

I work as a sysadmin for a school district and all of our backbone services(web/mail/dns/mysql/moodlw) are all run on freebsd.

Here is my problem, we just got a new superintendent and she would like all the email addresses in the district in her addressbook. I need to find a way to export this from postfix as a csv file so I can reimport it into squirrelmail. I have looked at postfixadmin and while it shows email address and unsername it doesnt have a function for an export. I also tried to get a member list from mailman but even after editing the file I still get errors...

Any Thoughts?

thanks
 
I don't know if it'll give you the format that you're looking for, but webmin has a feature to export user information.
 
Try using [cmd=""]mysql -u postfix -p postfix -Bs -e 'SELECT name,username FROM mailbox;' | tr '\t' ',' > addr.csv[/cmd]
 
Back
Top