Apps
Knowledge
People
Register
Login


-
- Content .- Fans (13) .- Knowledge Base (1) . 

user_sql

   2.0  

ownCloud Tool

Score 64%
Version Control:  Link
Minimum required   ownCloud 5
Maximum required   ownCloud 8.1
Downloads:  1887
Submitted:  Nov 27 2012
Updated:  2 days ago

Description:

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.




Changelog:

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




LicenseAGPL
ownCloud 8.1
ownCloud 8.0
Send to a friend
Subscribe
Other  Apps  from andyboeh
Report inappropriate content



goto page: prev   1  2  3  4  5 

-
.

 joomla user group

 
 by Sovo on: Mar 31 2015
 
Score 50%

Very good application and very good work! would it be possible to add the ability to manage users by group?


Reply to this

-

 Re: joomla user group

 
 by andyboeh on: Apr 7 2015
 
Score 50%

Sure - please go ahead and implement it yourself!

This question has already been asked twice, and the answer stays the same: I don't have any plans to integrate group support, sorry.


Reply to this

-

 Re: Re: joomla user group

 
 by Sovo on: Apr 7 2015
 
Score 50%

Ok thanks !


Reply to this

-

 ownCloud 8.1

 
 by quietscheente on: Jul 8 2015
 
Score 63%

I just upgraded my ownCloud installation to version 8.1. But the user_sql app seems to be broken with this version.
After enabling the user_sql app, I just can find the following error message in my log:
PHP Fatal error: Class 'OC\Cache' not found in /var/www/owncloud/apps/user_sql/user_sql.php on line 59


Reply to this

-

 Re: ownCloud 8.1

 
 by andyboeh on: Jul 8 2015
 
Score 50%

Thanks for the report.
However, if you check the "Maximum Required Version" on the application page, you may find out that it is still at 8.0. It simply hasn't been tested with 8.1, yet.


Reply to this

-

 Re: Re: ownCloud 8.1

 
 by markjansennl on: Jul 11 2015
 
Score 63%

Could you perhaps give an indication as to the planning of releasing a version compatible with OC8.1? Thanks


Reply to this

-

 Re: Re: Re: ownCloud 8.1

 
 by andyboeh on: Jul 11 2015
 
Score 63%

There will definitely be a version compatible with ownCloud 8.1.

However, user_sql is a spare-time project, so: Please don't ask for ETAs.


Reply to this

-
.

 Re: Re: Re: Re: ownCloud 8.1

 
 by dpauso on: Jul 29 2015
 
Score 50%

thanks for 1.99 Version.
But it's not working on my joomla 2.5.18 -> OC 8.1

Error: Class 'OCA\user_sql\PasswordHash' not found at /apps/user_sql/user_sql.php#222

and before:
Trying to load settings for domain: xxx
Loaded settings for domain: xxx
Encrypting and checking password
Fetching result...
Executing query...


i always used encryption-type joomla > 2.5.18 phpass
if i try joomla md5:
Login failed: 'userxy'
Passwords do not match, return false
pacrypt() done, return


Reply to this

-

 Re: Re: Re: Re: Re: ownCloud 8.1

 
 by andyboeh on: Jul 29 2015
 
Score 63%

That was a regression, it should be fixed now.

Unfortunately, I can't test all encryption types because I personally don't use them - Joomla support is one of those.

Could you please test it and report back?


Reply to this

-

 Re: Re: Re: Re: Re: Re: ownCloud 8.1

 
 by dpauso on: Jul 29 2015
 
Score 50%

yes, i would like to do it!



-

 Re: Re: Re: Re: Re: Re: ownCloud 8.1

 
 by dpauso on: Jul 29 2015
 
Score 50%

now it's working with oc 8.1!!!!
Big thanks!!!! :-)
Greetings from germany!



goto page: prev   1  2  3  4  5 

Add commentBack




-
 
 Who we are
Contact
Register
Explore
Apps
Knowledge
People
Participate
Add App
Public API
About apps.ownCloud.com
Legal Notice
Report Abuse
 

Copyright 2011-2015 apps.ownCloud.com Team  
All rights reserved. apps.ownCloud.com is not liable for any content or goods on this site.
All contributors are responsible for the lawfulness of their uploads.