# Database user source in manual mode, looking for more detail

**URL:** <https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376>\
**Category:** Ignition\
**Created:** [August 4, 2020, 5:25pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376 "2020-08-04T17:25:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [August 4, 2020, 5:25pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/1 "2020-08-04T17:25:05Z")

</div>

I am not finding a lot of detail in setting up a database user source in manual mode. I have a table in my database that I can display in Perspective when I use the internal user source to log in.

 ![ig_cvozuser_table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/5/55aa83970154929854642d920b4a6dacdb0a9872.jpeg)

When I change the user source to this table, using a database user source in manual mode, the gateway shows no items in the table:

 ![ig_cvozuser_noitemsgateway](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/0/207eeeb2b2bf1b988f0b7cf3d44306ca5b886763.jpeg)

I think I have setup the queries properly, but I cannot login with the user source set to this table.

Is there more detail than I find in the user manual on how to get a database user source in manual mode to work?

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [August 4, 2020, 7:26pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/2 "2020-08-04T19:26:16Z")

</div>

I am getting  
[profileName=Ig\_Gold] User listing query not specified  
but I did specify the query  
select fname, lname, schedule from ignition8goldtest.goldusers\_users where username = ? and passwd = MD5(?)  
in the authentication query

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [August 4, 2020, 7:33pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/3 "2020-08-04T19:33:48Z")

</div>

For List User Query I have:  
select \* from ignition8goldtest.goldusers\_users

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 4, 2020, 7:58pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/4 "2020-08-04T19:58:24Z")

</div>

Psst! You aren’t supposed to post cert exam questions here (or anywhere else, actually). The point of an exam is to test _ **your** _ ability to solve the problem(s).

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [August 4, 2020, 8:01pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/5 "2020-08-04T20:01:05Z")

</div>

It was not a certification exam question. I am using an old database but the question I am asking was not on any certification exam I took.

I was able to figure out some of my problems. There are particular ways the tables and queries have to be specified that I had to reverse engineer. I think I have it working now, and when I have it fully tested I will post some information here.

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [August 5, 2020, 6:51pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376/6 "2020-08-05T18:51:28Z")

</div>

The attached PDF captures what I have learned so far about user authentication through a database connection using manual mode. If you can fill in the gaps, it would be very helpful to know.

[Ignition\_Users\_Database\_ManualMode\_200805.pdf](https://forum.inductiveautomation.com/uploads/short-url/rb3JfgOT4hRX6qvMCbhyA4Rt1aV.pdf) (129.4 KB)