Apps
Knowledge
People
Register
Login


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

user_sql

   2.0  

ownCloud Tool

Score 66%
Version Control:  Link
Minimum required   ownCloud 5
Maximum required   ownCloud 8.1
Downloads:  1981
Submitted:  Nov 27 2012
Updated:  Aug 10 2015

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!



-

 Undefined variable at view.php

 
 by dpauso on: Aug 5 2015
 
Score 50%

Hi Andy,

everything works fine, but i've got one error in my log. I made a clean oc 8.1 install and after installing your app (+ configure), there's this error coming up very often:

Error PHP Undefined variable: content at lib/private/files/view.php#1357

so your app could be the problem. everything is working, so this is just a unimportant problem, but
could you have a look?
on owncloud-forums it isn't known.


Reply to this

-

 Re: Undefined variable at view.php

 
 by andyboeh on: Aug 5 2015
 
Score 50%

IMHO that's an ownCloud bug and completely unrelated to user_sql. Please report to the ownCloud team.


Reply to this

-
.

 password change not possible : 8.1 to joomla

 
 by hele on: Aug 7 2015
 
Score 50%

hi,
thanks for your great app!
It worked very well, until I made the update to 8.1
now the password change doesn't work any more.

I use "Joomla > 2.5.18 phpass" and "Allow password changing" and it worked before.

If I change now the password, the tick appears, that it worked, but it didn't.

Any ideas?


Reply to this

-
.

 Re: password change not possible : 8.1 to joomla

 
 by hele on: Aug 10 2015
 
Score 50%

in the mysql.log appears the UPDATE request as followed

Quote:
UPDATE ser12_users SET password = '$P$Dwwah2BMjJj5PnLLtH5cH81HNzbaj30' WHERE username = '$P$Dwwah2BMjJj5PnLLtH5cH81HNzbaj30'


So the username ist overwritten by the password.... but I can't find where.

I parsed the helper.php but I didn't find the error. Seems quite ok. (query and bindParam)
If I use the params direktly, the UDATE works...


Reply to this

-

 Re: Re: password change not possible : 8.1 to joom

 
 by andyboeh on: Aug 10 2015
 
Score 50%

It should be fixed now, please update.

That was a nasty bug that took me quite a while to find!


Reply to this

-

 WordPress

 
 by kylesouza on: Aug 13 2015
 
Score 50%

This should be able to get usernames and passwords from a WordPress database, right? Has anyone tried that with this app?


Reply to this

-

 Re: WordPress

 
 by andyboeh on: Aug 14 2015
 
Score 50%

Why don't you try it yourself?

I just checked my ancient Wordpress database, the hashes seem to be PHPass, so it should work with the Joomla > 2.5.18 PHPass setting. I don't know if Wordpress has changed the encryption method, though.


Reply to this

-

 Re: Re: WordPress

 
 by kylesouza on: Aug 18 2015
 
Score 50%

Hi Andy, I did try it right after I asked, and thought I had commented back on here with my results. WordPress does use PHPpass. I need to investigate further, but it does not work with that setting. When a username and password are entered nothing happens, the page reloads, but no login occurs. I need to check out logs and such.


Reply to this

-

 Re: WordPress

 
 by kylesouza on: Aug 18 2015
 
Score 50%

Okay, it is working with Wordpress, encryption type Joomla > 2.5.18 phpass, check the "Invert Active Column".


Reply to this

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.