Apps
Knowledge
People
Register
Login


-
- Content .- Fans (20) .- Knowledge Base (6) . 

user_sql

   2.3  

ownCloud Tool

Score 66%
Version Control:  Link
Minimum required   ownCloud 5
Maximum required   ownCloud 9.1
Downloads:  3354
Submitted:  Nov 27 2012
Updated:  Jan 11 2017

Description:

We recently switched to SAML-based authentication, thus development has stopped! v2.3 is the last official release.

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.




Changelog:

v2.3 A few bug fixes and update for ownCloud 9.1
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




LicenseAGPL
ownCloud 9.1
ownCloud 9.0
ownCloud 8.2
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  6  7  8 

-

 Using Wordpress SQL db as user backend

 
 by ingowertenbruch on: Dec 22 2016
 
Score 50%

Hi,

Is it possible to get this running with Nextcloud against a Wordpress SQL database? I donwloaded the source from the nextcloud-apps website and managed to get a connection to the database. The users are synchronized to nextcloud; nevertheless the user authentication fails. Maybe the correct encryption type of the pw-field is missing, I don't know. I tried all available options without success.
Did anyone get this running ?


Reply to this

-

 Re: Using Wordpress SQL db as user backend

 
 by andyboeh on: Dec 31 2016
 
Score 50%

Wordpress seems to use phpass (=Joomla 2.5.18 phpass), but uses 8 rounds instead of 10. You could try changing the line

$hasher = new \PasswordHash(10, true);

to

$hasher = new \PasswordHash(8, true);

and trying it again with the Joomla 2.5.18 phpass type. If that works, drop me a line so that I can add support for it in user_sql.


Reply to this

-

 Re: Re: Using Wordpress SQL db as user backend

 
 by ingowertenbruch on: Jan 2 2017
 
Score 50%

Many thanks, I just tried it out, but unfortunately it doesn't work.
Just to be sure: I changed the line in the "user_sql.php" to:

if($this -> settings['set_crypt_type'] === 'joomla2')
{
if(!class_exists('\PasswordHash'))
require_once('PasswordHash.php');
$hasher = new \PasswordHash(8, true);
$ret = $hasher -> CheckPassword($password, $db_pass);
}

Further I have set the Encryption Type to "Joomla > 2.5.18 phpass"

The logfile doesn't help me that much, I see a couple of entries like:

{"reqId":"cgBTe570Gedz+ueiYfI1","remoteAddr":"*.*.*.*","app":"OC_USER_SQL","message":"userExists() for UID: ingo.wertenbruch cacheVal: ","level":0,"time":"2017-01-02T08:58:46+00:00","method":"GET","url":"\/nextcloud\/index.php\/apps\/theming\/loginbackground?v=10","user":"ingo.wertenbruch"}



Reply to this

-

 Re: Re: Re: Using Wordpress SQL db as user backend

 
 by andyboeh on: Jan 3 2017
 
Score 50%

I just installed WordPress 4.7 and it works just fine with the Joomla phpass crypt type even without changing a single line of code!

I suspect your configuration to be broken.


Reply to this

-

 Re: Re: Re: Re: Using Wordpress SQL db as user bac

 
 by ingowertenbruch on: Jan 11 2017
 
Score 50%

Hi, and sorry for my late answer.

I now can confirm that it works like a charm with the encryption type "Joomla > 2.5.18 phpass".
:-)

The only thing I currently don't fully understand is the way the mail attribute is synced.
The setting is "SQL always wins" and I can see a synced mail attribute on ca. 50% of the users.
Is this a background task ?
A far as I can tell the attribut is synced when a user logs in.


Reply to this

-

 Re: Re: Re: Re: Re: Using Wordpress SQL db as user

 
 by ingowertenbruch on: Jan 11 2017
 
Score 50%

Okay, forget about the email-sync problem. It works, it's just a matter of time.

Thumbs up !


Reply to this

-

 Nextcloud 11

 
 by ingowertenbruch on: Jan 16 2017
 
Score 50%

Is it planned to offer a version for Nextcloud 11 ?


Reply to this

-

 Re: Nextcloud 11

 
 by andyboeh on: Jan 16 2017
 
Score 50%

We recently switched to SAML-based authentication, thus development has stopped! v2.3 is the last official release.


Reply to this

-
.

 Re: Re: Nextcloud 11

 
 by dpauso on: Jan 20 2017
 
Score 50%

bad news for all of us (thats why i'm still OC and not NC user)

maybe someone can continue your job ;-)


Reply to this

goto page: prev   1  2  3  4  5  6  7  8 

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-2017 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.