Directly write new users to membership_users (loginname/password)

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
AppGini Super Hero
AppGini Super Hero
Posts: 541
Joined: 2019-05-21 22:42

Directly write new users to membership_users (loginname/password)

Post by onoehring » 2019-06-18 10:49

as this cost me some time to figure out how to transfer credentials from offline to online application, I thought you might like it.

I want to start this suggestion by explaining my setting:
A database application on the desktop. There are some users. I want these users to be able to log into the AppGini web application using their desktop credentials.

Solution is actually quite simple:
When you save the users password in the "desktop" version (hopefully somehow encrypted/hashed), hash it also as MD5. Probably this is quite easy.
Now you can simply export the name the users should have as loginname in AppGini with that MD5 password into the AppGini database (SQL).
Table membership_users, field memberID gets the loginname and field passMD5 gets the MD5 hashed password.

When the users logs in the first time into AppGini, his MD5 hashed password will get additional security as AppGini will bcrypt it.

Of course you will need to add some more fields (see membership_users table for details).

Thanks to the developers this procedure is completely transparent and the users does not notice.

Some postings I was involved, you might find useful:
Backup your database (viewtopic.php?f=4&t=3341); Improve security (viewtopic.php?f=4&t=3168); Field Permissions (viewtopic.php?f=4&t=3308); Custom (error) message (viewtopic.php?f=7&t=1740&p=10871#p10906); Audit Log (viewtopic.php?f=4&t=1369&p=10407); Two Factor Authentication (viewtopic.php?f=7&t=3306&p=11478); Add 2nd SAVE CHANGES button (viewtopic.php?f=2&t=3242&p=11104); Place a search on details view (viewtopic.php?f=2&t=3479&p=12484#p12484); Column-Value-Based-Permissions (viewtopic.php?f=4&t=3498)

User avatar
Site Admin
Posts: 1089
Joined: 2012-09-27 14:46

Re: Directly write new users to membership_users (loginname/password)

Post by a.gneady » 2019-07-03 11:48

Thanks for sharing this, Olaf :)
:idea: Calendar plugin: Organize your data into beautiful calendars. NEW
:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.
:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

Post Reply