|Version Control: Link|
Minimum required ownCloud 5
|Submitted: Nov 27 2012|
Updated: May 27 2015
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 database configured with System (Crypt).
Support for DisplayNames as available in OC5+ is also available.
v0.9.2 adds ability to map domains. This was developed specifically for PostfixAdmin, which stores the e-mail address as usernames. With this configuration, users from cloud.foo.com can log in as user (instead of firstname.lastname@example.org) and those from cloud.bar.com can use user, too (instead of email@example.com).
Recently, compatibility with ownCloud 8 was added.
Please use the bug tracker at https://code.rnb-consulting.at/tag/owncloud_user_sql_plugin when reporting bugs and issues.
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