# Manual Security Setup

**URL:** <https://forum.inductiveautomation.com/t/manual-security-setup/8265>\
**Category:** Ignition\
**Created:** [April 4, 2014, 9:02pm UTC](https://forum.inductiveautomation.com/t/manual-security-setup/8265 "2014-04-04T21:02:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![WildeKurt](https://avatars.discourse-cdn.com/v4/letter/w/50afbb/32.png) [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\
**Post date:** [April 4, 2014, 9:02pm UTC](https://forum.inductiveautomation.com/t/manual-security-setup/8265/1 "2014-04-04T21:02:45Z")

</div>

There seems to be some difference between the 7.5 and 7.6 manual security setup. I’m setting up a 7.6 gateway but can’t seem to get authentication to work. The setup page is different from a working example I have on a 7.5.10 system. Here’s what I’m trying to do:

Authentication query:  
SELECT FirstName, LastName FROM USERS WHERE Username = ? AND Password = SHA1(?)  
List Roles Query:  
SELECT Rolename from ROLES  
User’s Role Query:  
SELECT Rolename from USER\_ROLE\_MAPPING where Username = ?  
ListUsersQuery:  
SELECT Username,FirstName,LastName,Notes FROM USERS

All I get when trying to log in is a nondescript ‘SQL exception during authentication’ error.

On the older versions setup there are other fields such as Hash Function and variables like username and password are listed like $username$ and $password$. The newer one just uses ?'s in the examples. What am I doing wrong. Thanks for any help.

---

<div class="post-metadata">

**Author:** ![WildeKurt](https://avatars.discourse-cdn.com/v4/letter/w/50afbb/32.png) [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\
**Post date:** [April 8, 2014, 11:59am UTC](https://forum.inductiveautomation.com/t/manual-security-setup/8265/2 "2014-04-08T11:59:28Z")

</div>

-