Users created in an external mysql database

Authentication & Security
1

Hi I have the following scenario and would like some guidance.
I have users setup in a mysql database.
Each user already has a username and password.
For the purpose of our web app our current registration and user management works fine but now we would like to incorporate dream factory as an end point for our api. The problem I’m coming across is that from what I’ve read all the users and passwords need to be handled by dream factory for users. This will be a problem since we can’t ask all users to reset their passwords. Is there away we can put an “api key” into our current database and then do some server logic to make sure that it exist?

Here is my solution but I’m not even sure if I’m going about this the right way. I’m a rookie at this.

  1. In our database we would automatically create a table with an api key.
  2. We would grant access via a role to the needed tables.
  3. We would do a server logic that says
    myapicolumn = apitoken from app. If this is true they can access the api if not then they wouldn’t be able to.

If the above scenario is just not the way to go about this can you please point me in the right direction?

2

Hello Omar,

Have you discovered a method of authentication based on exiting SQL DB with username/password stored in table?

Regards,
Jeff

3

No unfortunately I didn’t.

4

Anyone else have any ideas on how to work with an external user db and still allow for those users to be tied with dreamfactory roles, etc? I’d really really, like to use my own user db with dreamfactory without having to duplicate all my thousands of users. Please provide some guidance?