#!/bin/bash

echo dit script maakt een user aan in Sogo.

read -p "Username: " username
read -p "Password: " password
read -p "Volledige naam: " naam
read -p "E-mail: " email

# gebruiker aanmaken in mysql
output=`mysql -uroot <<EOD
use sogo;
INSERT INTO sogo_users VALUES ('$username', '$username', MD5('$password'), '$naam', '$email');
EOD`

# log
logfile=/root/ng.log
date >> $logfile
echo "mail account:" >> $logfile
echo "Username: $username" >> $logfile
echo "Paswoord: $password" >> $logfile
echo "Naam:     $naam" >> $logfile
echo "E-mail:   $email" >> $logfile