There are many different types already in the app to choose.
If you use a SQL DB from a common php CMS (Wordpress, Joomla, Q2A etc.) it is most likely “bcrypt”, which is called “Joomla >2.5.18 phpass” in the drop down menu from this app. Try that one first
Otherwise it might be one of the others, but those are mostly very outdated.
No idea if base64 is supported, but it shouldn’t be too hard to extend the code if you have a sample from your main application that creates those hashes.
user_sql is a suplementary login system, so that is intended behaviour. I also do not see how that is bad. Just keep one admin user for emergencies (connection to external DB can fail) and otherwise get all the users from the external DB.
I’ve tested with the most recent commit. Unluckily enough I am not able to identify the spot(s) for either adding salted SHA512 or change salted SHA256 to salted SHA512 which should do the trick in my case. Can you advise?
Just installed the user_sql app, but as we stored the user name (it is an email address) in two separated columns (the local part and the domain part) and this app only have a col_username field to set, we cannot use this app to query users.
I think it will be more fixable to have a custom sql query field for the user query.
Managed to integrate Drupal 7 password verification (read-only, i.e. excluded Password updates). I’m ready to share with people interested - of course without any warranty,
if you use a database, which supports views (e.g. mysql, mariadb and many others) you can use a table view in order to create a table, which contains these bothe fields in one column. Build a select statement like CREATE VIEW viewname AS SELECT CONCAT(local_part,domain_part) AS email,password FROM your_table.
The use this view as your source table. This view gets dynmically updated, when the underlying table changes.