#!bin/bash
#==============================
#Owner: Adam Miller.
#Creator: Adam Miller.
#Function: To automatically add users to an SFTP server using information stored on a MySQL server.
#Date: 26th of September, 2011.
#==============================

n=1;

end=51;

while [ $n != $end ]
do

echo "SELECT username FROM backup_clients WHERE id = '$n';" | mysql --disable-column-names -pXXXXXX clients

username=`echo "SELECT username FROM backup_clients WHERE id = '$n';" | mysql --disable-column-names -pXXXXXX clients`

echo "SELECT password FROM backup_clients WHERE id = '$n';" | mysql --disable-column-names -pXXXXXX clients

password=`echo "SELECT password FROM backup_clients WHERE id = '$n';" | mysql --disable-column-names -pXXXXXX clients`

pw=$(perl -e 'print crypt($ARGV[0], "password")' $password)

mkdir /home/$username

useradd -d /home/"$username" -p $pw "$username"

adduser $username sftponly

chown root.root /home/"$username"

mkdir /home/"$username"/backup

chmod a+w /home/"$username"/backup

setquota -u $username 0 20971520 0 0 /home/

(( n= $n + 1 ))

done

DATE=`date`;

echo "log completed.            -       $DATE" >> addclient.logs.text
echo " " >> addclient.logs.text


exit 0