Untitled

    #!/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