Authenticate OpenVPN against a DB

OpenVPN_DBAuth.ps1

# Script requires ODBC Connector MySql/MariaDB
$data = Get-Content "$args"
$username = $data[0]
$password = $data[1]

 #connection - pwsh.exe Get-OdbcDriver
 $driver = "MariaDB ODBC 3.1 Driver"
 $Server = "127.0.0.1"
 $DBName = "openvpn"
 $User = "openvpn"
 $PW = "abcd1234"
 
 # Connect to the database
 $Connection = New-Object System.Data.ODBC.ODBCConnection
 $Connection.connectionstring = "DRIVER={$driver};" +
    "Server = $Server;" +
    "Database = $DBName;" +
    "UID = $User;" +
    "PWD= $PW;" +
    "Option = 3"
 $Connection.Open()
 
# Hint, create a DB with two varchar columns, one named password and another named user
 $Query = "SELECT * FROM openvpn.users WHERE password = `"$password`" AND user = `"$username`""
 $Command = New-Object System.Data.ODBC.ODBCCommand($Query, $Connection)
$DataTable = New-Object -TypeName System.Data.DataTable
$Reader = $Command.ExecuteReader()
$DataTable.Load($Reader)
if (@($DataTable).count -gt 0) { (Write-Host "ok"); exit 0 }
$Connection.Dispose()
Write-Host "not ok"
exit 1