|Version Control: Link|
Minimum required ownCloud 5
Maximum required ownCloud 9.0
|Submitted: Nov 27 2012|
Updated: Mar 16 2016
Authenticate against an arbitrary SQL database. The backend also provides retrieval of all users, so that you can share files as well.
It is heavily based on user_imap, user_ldap, user_pwauth and user_redmine. After installation, simply enable the app in your admin account and configure the database details.
Currently, it supports md5, md5crypt, cleartext, system, mysql password, Joomla MD5, Joomla phpass, Redmine and mysql_encrypt encryption types, based on the PostfixAdmin functions.
It was developed to authenticate against a postfixadmin/vimbadmin database configured with System (Crypt).
Recently, compatibility with ownCloud 8.1 was added.
Please use the bug tracker at https://code.rnb-consulting.at/tag/owncloud_user_sql_plugin when reporting bugs and issues. Click on "Tasks" on the left hand side and then on "Create Task..." in the upper right corner.
v2.2 Update for ownCloud 9.0
v2.1 Add support for getHome() to have users in different data directories
v2.0 Add auto-completion for columns and table, support verification of database settings. Switch to OC DBAL.
v1.99 Add Multi-Host support and ownCloud 8.1 compatibility
v1.5 Add possibility to synchronise E-Mail addresses (disabled by default)
v1.4 Add possibility to invert active logic
v1.3 Add support for Redmine
v1.2 Comopatibility with ownCloud 8
v1.1 Add support for SSHA256 hashes
v1.0 Add support for Joomla 2.5.18+ encryption, bugfix
v0.9.2 - Add Domain Mapping options
v0.9.1 - New Admin interface, branch merge and bugfix (caching, checkbox saving)
v0.9.0 - Add support for DisplayNames (in oc5 branch)
v0.8.0 - Add Joomla encryption type as well as improvements on cache handling
v0.7.1 - Fixed possible CSRF vulnerability
v0.7 - Added support for mySQL PASSWORD() encryption as per request. Currently UNTESTED.
v0.6 - Fixed some SQL injection problems
v0.5 - Add more encryption types based on PostfixAdmin
v0.4 - Enable password change, configurable possibility to add/strip domains from usernames (postfixadmin stores usernames as complete email address including domain)
v0.3 - Use separate column to specify active users, enable
v0.2 - Ported to PDO (based on user_redmine) and thus now also supports PostgreSQL
v0.1 - Initial Version against OC 4.5.2