How do I use SQLAuth with Emeralds Database?

Answer

By default, Emerald does not add anything to the Email field in the SubAccounts Table. You need to add each user’s email address to this field. Once these have been entered then you can use the following SQL Config entries.

Verify Account Exists

SELECT DISTINCT sa.Email FROM SubAccounts sa WHERE sa.Email = '%s@%s'

Authentication

SELECT DISTINCT sa.Password FROM SubAccounts sa WHERE sa.Email = '%s@%s'

Listing users in a domain

SELECT DISTINCT sa.Email FROM SubAccounts sa WHERE sa.Email LIKE '%%@%s

Keywords:SQL SQLAuth Emerald database authentication configuration ODBC