#!/bin/bash
    HOST=localhost
    USER=XXXXX
    PASS=XXXXX
    DATABASE=XXXXX
    TABLE=XXXXX
     
    # Sanitize and crypt
    #username=${username//[^a-zA-Z0-9_!#$%&'*+-/=?^`~@./]}
    username=`echo -n $username | tr A-Z a-z`
    #password=${password//[^a-zA-Z0-9_!#$%&'*+-/=?^`~@./]}
    password=`echo doveadm pw -p $password -s MD5-CRYPT | cut -f2 -d'}'`
     
    query=`mysql -u $USER -p $PASS -D $DATABASE -h $HOST -e "SELECT username FROM $TABLE WHERE ( (vpn = '1') AND (username = '$username') AND (password = ('$password')) );"`
     
    if ( "$query" == "$username" ); then
    echo success
    exit 0
    else
    echo fail
    exit 1
    fi