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.
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
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).
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.
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.