Courierauth convert.sh

#!/bin/bash
TMP=/tmp/user_pre.tmp
TMP2=/tmp/user_pre.final
 
# MySQL DB layout for authdaemon
#1 | id              | char(128)        | NO   | MUL |         |       |
#2 | crypt           | char(128)        | NO   |     |         |       |
#3 | clear           | char(128)        | NO   |     |         |       |
#4 | name            | char(128)        | NO   |     |         |       |
#5 | uid             | int(10) unsigned | NO   |     | 65534   |       |
#6 | gid             | int(10) unsigned | NO   |     | 65534   |       |
#7 | home            | char(255)        | NO   |     |         |       |
#8 | maildir         | char(255)        | NO   |     |         |       |
#9 | defaultdelivery | char(255)        | NO   |     |         |       |
#10| quota           | char(255)        | NO   |     |         |       |
#11| options         | char(255)        | NO   |     |         |       |
 
 
 
echo "#resetting file" > $TMP
 
#get users and output to a csv format.
 
for i in `find /usr/local/sites -maxdepth 2 -type f -name ".qmail-*"`;
  do echo -e `echo $i | sed 's/.qmail-*//g' | cut -d"/" -f6`"@"`cat $i | cut -d- -f1`","`grep $(cat $i) /etc/shadow | cut -d: -f2`",,,"`grep $(cat $i) /etc/passwd |\
 cut -d: -f3,4,6 | sed 's/\:/\,/g'`",,,, " >> $TMP;
  sleep 3
done