Apps
Knowledge
People
Register
Login


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

user_sql

   1.0  

ownCloud Tool

Score 63%
Version Control:  Link
Minimum required   ownCloud 5
Downloads:  1427
Submitted:  Nov 27 2012
Updated:  Nov 18 2014

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 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 user@foo.com) and those from cloud.bar.com can use user, too (instead of user@bar.com).




Changelog:

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
Send to a friend
Subscribe
Other  Apps  from andyboeh
Report inappropriate content



goto page: prev   1  2  3  4 

-
.

 auto autorisations

 
 by moonkir on: Nov 24 2014
 
Score 50%

Is it possible to use this plugin automatically authenticate users Wordpress?


Reply to this

-

 Re: auto autorisations

 
 by andyboeh on: Nov 24 2014
 
Score 50%

Sorry, I'm not sure if I've correctly understood your question.

Where shall your users be stored, Wordpress or ownCloud?

What do you mean by 'automatically'?


Reply to this

-

 Re: Re: auto autorisations

 
 by moonkir on: Nov 24 2014
 
Score 50%

I have users in Wordpress
As these users to connect to owncloud
that they would not enter a password and login in owncloud
and use a password which they introduced in WordPress
Users - necessary authorization


Reply to this

-

 Re: Re: Re: auto autorisations

 
 by andyboeh on: Nov 24 2014
 
Score 50%

No, this doesn't work that way, sorry. What you're looking for is a Single-Sign-On solution (SSO). You should check out SAML or OpenID.

What might be possible is that your users can use the SAME username and password as for ownCloud, but they need to enter them for each system separately.


Reply to this

-

 Redmine

 
 by gamafranco on: Jan 21 2015
 
Score 50%

Is it possible to enable authentication via redmine?


Reply to this

-

 Re: Redmine

 
 by andyboeh on: Jan 22 2015
 
Score 50%

I don't use Redmine, but it seems that Redmine uses a different encryption type.

I could try to implement support for it, but I need you to test it. Send me a private message in case you'd like to try.


Reply to this

-

 Re: Re: Redmine

 
 by gamafranco on: Jan 22 2015
 
Score 50%

Thanks so much for the quick reply. I will PM.


Reply to this

-
.

 Compatibly @ Owncloud 8

 
 by dpauso on: Feb 9 2015
 
Score 50%

Does anyone have some experience with "user_sql" in OwnCloud 8.0

---------

Hat Jemand schon Erfahrungen mit der "user_sql"-App und Owncloud 8 gemacht?


Reply to this

-

 Re: Compatibly @ Owncloud 8

 
 by horstk on: Feb 28 2015
 
Score 63%

Can't get it running. I get the error
"Failed to connect to the database: could not find driver"
Nevertheless it works correctly on the same server with owncloud 7.0.4 and the mysql driver is installed.


Reply to this

-

 Re: Compatibly @ Owncloud 8

 
 by markjansennl on: Mar 1 2015
 
Score 50%

I'm very interested to know about the compatability too, therefore this reply (so I get email notifications about any response).


Reply to this

-

 Re: Compatibly @ Owncloud 8

 
 by andyboeh on: Mar 1 2015
 
Score 50%

I just pushed a fix for ownCloud 8 to the hg repo. Please test and report back.


Reply to this

-

 Re: Re: Compatibly @ Owncloud 8

 
 by horstk on: Mar 1 2015
 
Score 50%

Works now, thanks


Reply to this

-

 Works for me on 7.0.2 but not 7.0.3 not 7.0.4

 
 by bonomani on: Feb 18 2015
 
Score 50%

Just to report that it works for me for version 7.0.2 version but it seems to be broken starting with 7.0.3
Also I use it with moodle 2.7.2 that use bcrypt (so I use encryption type=Joomla > 2.5.18 phpass, you should may be call it "bcrypt" !) .
The moodle database has multiple fields: Suspended and Deleted. It would be nice to have 2(or 3) authentification fields and the possibility to inverse the condition !


Reply to this

-

 Works for me on 7.0.2 but not 7.0.3 not 7.0.4

 
 by bonomani on: Feb 18 2015
 
Score 50%

Just to report that it works for me for version 7.0.2 version but it seems to be broken starting with 7.0.3
Also I use it with moodle 2.7.2 that use bcrypt (so I use encryption type=Joomla > 2.5.18 phpass, you should may be call it "bcrypt" !) .
The moodle database has multiple fields: Suspended and Deleted. It would be nice to have 2(or 3) authentification fields and the possibility to inverse the condition !


Reply to this

-

 Re: Works for me on 7.0.2 but not 7.0.3 not 7.0.4

 
 by andyboeh on: Feb 18 2015
 
Score 50%

Hey,

for me, it works fine on 7.0.4.

Regarding Moodle: If it is really bcrypt, then the encryption type should be "System (crypt)", not "Joomla > 2.5.18".


Reply to this

goto page: prev   1  2  3  4 

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.