Apps
Knowledge
People
Register
Login


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

user_sql

   2.3  

ownCloud Tool

Score 66%
Version Control:  Link
Minimum required   ownCloud 5
Maximum required   ownCloud 9.1
Downloads:  2984
Submitted:  Nov 27 2012
Updated:  Aug 30 2016

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

-
.

 SHA256

 
 by blablanet on: Mar 14 2016
 
Score 50%

Sorry I not have idea if previously I post in the right place. I try SHA256 but say password is incorrect . I am missing something?


Reply to this

-
.

 Re: SHA256

 
 by blablanet on: Mar 14 2016
 
Score 50%

I look your SSHA256 My SHA256 Password start with {SHA256}1+X0I3hmfF7F.. and you password start with {SHA256}GyNgHX0I3hmfF7FFdNK8lt.... That make impossible login with SHA256 I am missing something here?


Reply to this

-

 Re: Re: SHA256

 
 by andyboeh on: Mar 14 2016
 
Score 50%

I think you are mixing up SHA256 and SSHA256. What user_sql supports is SSHA256 (Salted SHA256), and this was provided by a user. I cannot test this.

You seem to be wanting support for SHA256, without the salt, right?


Reply to this

-
.

 Re: Re: Re: SHA256

 
 by blablanet on: Mar 14 2016
 
Score 50%

yes I believe I need only SHA256 that will support many other integrations of owncloud with other apps like Sogo


Reply to this

-

 Re: Re: Re: Re: SHA256

 
 by andyboeh on: Mar 14 2016
 
Score 50%

Good, I'm glad you got a pointer into the right direction. I'll be happy to apply any patches you come up with!


Reply to this

-

 Re: Re: Re: Re: Re: SHA256

 
 by blablanet on: Mar 14 2016
 
Score 50%

I already change to IMAP but I will look about


Reply to this

-
.

 Vbulletin 5 connect

 
 by huankarlos on: Apr 18 2016
 
Score 50%

How can I connect to vbulletin 5 db? How ecryption type?


Reply to this

-

 Re: Vbulletin 5 connect

 
 by huankarlos on: Apr 22 2016
 
Score 50%

connection verified, but tables in owncloud db doesn't created :(


Reply to this

-

 Owncloud 9.1

 
 by markjansennl on: Aug 3 2016
 
Score 50%

I noticed Owncloud 9.1 introduces "Pluggable authentication: plugin system that supports different authentication schemes" (according to the Changelog).

Does this have any effect on the functioning of your app? Or the need for your app?

Thanks.


Reply to this

-

 Re: Owncloud 9.1

 
 by andyboeh on: Aug 4 2016
 
Score 50%

Usually, I update user_sql a few days to weeks after a new ownCloud release is available, as I update it for my own needs when I update my server. I haven't had a look into the Pluggable Authentication System, yet.


Reply to this

-

 Re: Re: Owncloud 9.1

 
 by markjansennl on: Aug 6 2016
 
Score 50%

Ok, many thanks for the quick reply. I'll check this page regularly to see whether or not there's an update compatible with 9.1 (and if so, whether or not to upgrade to 9.1).

Your plug-in is great.


Reply to this

-

 Re: Re: Re: Owncloud 9.1

 
 by dpauso on: Aug 10 2016
 
Score 50%

I tried the 9.0-version at 9.1 and it's running very well...


Reply to this

-

 Re: Owncloud 9.1

 
 by andyboeh on: Aug 30 2016
 
Score 50%

Finally, I updated to OC 9.1 and tested user_sql. So far, it seems to be running fine. I released a new version which has basically the maximum version set to OC 9.1 today.


Reply to this

-
.

 Not working After 9.1 Update

 
 by nimble78 on: Aug 29 2016
 
Score 50%

Hallo,

keine Ahnung warum, aber ich habe mene OWNCLOUD auf 9.1 upgedatet und habe jetzt das Problem, dass deine Hammer-APP nicht mehr funktioniert.

Beim einrichten, verbindet er sich auf den Server wo meine Userdaten liegen (Joomla) , lässt mich auch ohne Probleme die Tables auswählen und speichern. Dann geht aber nichts mehr:

Beim Anmelden läuft er in ein Timeout:
The connection to the server was reset while the page was loading.

danach bekomme ich diese Meldung von OWNCLOUD:
Access forbidden

CSRF check failed

Hast du irgendeine Idee, die mir weiterhelfen könnte...


Reply to this

-

 Re: Not working After 9.1 Update

 
 by nimble78 on: Aug 29 2016
 
Score 50%

Ich hätte auch ein Log-File, mit dem ich leider überhaupt nichts anfangen kann, wo aber sehr viel drin steht was da passiert / nicht passiert...


Reply to this

-

 Re: Re: Not working After 9.1 Update

 
 by nimble78 on: Aug 29 2016
 
Score 50%

hi,

it seems a bug from owncloud:

https://central.owncloud.org/t/csrf-check-failed-after-upgrade-to-9-1/922

After i deaactivated file_share it worked. Sorry for the confusion.


Reply to this

-

 Re: Not working After 9.1 Update

 
 by andyboeh on: Aug 30 2016
 
Score 50%

Please do not post in German in a public, English board.

Anyway, you sorted it out yourself plus a version compatible with 9.1 has been released today (which just contains an updated maximum version XML file).


Reply to this

-
.

 Working After 9.1 Update

 
 by martinsy on: Sep 13 2016
 
Score 50%

I can confirm that github version is working well after 9.1 upgrade. Finally I can see my encrypted data again . Thank you very much!


Reply to this

-

 Re: Working After 9.1 Update

 
 by andyboeh on: Sep 13 2016
 
Score 50%

Which github version are you referring to? user_sql is not hosted on github!


Reply to this

-
.

 Re: Re: Working After 9.1 Update

 
 by martinsy on: Sep 13 2016
 
Score 50%

Sorry, my comment should be to 'secure_container' app.
https://github.com/e-alfred/owncloud-securecontainer


Reply to this

-
.

 error on ownCloud 9.1.0 (stable)

 
 by Mojo1988 on: Sep 17 2016
 
Score 50%

Hello,

Ive done now a upgrade to ownCloud 9.1.0 (stable)

In the "user_sql.php" I add on line 523 till 543
{
$password = md5($pw);
/////////////////////////////////////////////////////////////////////////////////////////////////////////

} elseif($this -> settings['set_crypt_type'] === 'pdx')
{
$salt="1234";function salt($input) {return md5($salt.":".htmlspecialchars($input).":".$salt);} //.settings.salt
$password = salt(htmlspecialchars($pw));
//////////////////////////////////////////////////////////////////////////////////////////////////////////
} elseif($this -> settings['set_crypt_type'] === 'system')


this is for my own salt to my connection to database,
but if i'll try to login, i got error 500,
but if I login with the admin acc, I'll see all users of the Database,
only the login doesn't work.


Reply to this

-

 Re: error on ownCloud 9.1.0 (stable)

 
 by andyboeh on: Sep 17 2016
 
Score 50%

I'm certain you'll understand that I can't help you with your custom modifications. Check the logs and debug!


Reply to this

-

 Re: Re: error on ownCloud 9.1.0 (stable)

 
 by Mojo1988 on: Sep 19 2016
 
Score 50%

okay I disabled my customized code, and greatet a mysql database with md5 password,

after Ive done this, I got the error

Internal Server Error


Reply to this

-

 Re: Re: Re: error on ownCloud 9.1.0 (stable)

 
 by andyboeh on: Sep 19 2016
 
Score 50%

Then please create an issue at the issue tracker and paste the detailed log file there, indicating the error message.


Reply to this

goto page: prev   1  2  3  4  5  6  7 

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