Apps
Knowledge
People
Register
Login


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

user_sql

   2.1  

ownCloud Tool

Score 66%
Version Control:  Link
Minimum required   ownCloud 5
Maximum required   ownCloud 8.2
Downloads:  2427
Submitted:  Nov 27 2012
Updated:  Jan 8 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.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 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 

-

 Strange exception in log

 
 by brandis on: Nov 16 2015
 
Score 50%

I have a very strange exception in the owncloud log file and I think it is related to user_sql (if not, I will be happy to open a bug somewhere else):

{"reqId":"VkpNJFVYGzMAAAtnzl0AAAAF","remoteAddr":"1.2.3.4","app":"caldav","message":"Exception: {"Message":"An exception occurred while executing 'SELECT FROM mailbox WHERE username = :uid AND active' with params ["user@domain.de"]:nnSQLSTATE[42000]:
Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mailbox WHERE username = 'user@domain.de' AND active' at line 1","Code":0,"Trace":"#0

It says "caldav" in the error message, but the problem seems to come from the login. I can login as admin in the web interface, but not as a normal user with an email address. The desktop client for example works without a problem, and also the carddav synchronization, but that throws an exception, but continues to work.

Could you help here? Thanks!

BTW, I tried to use the bug tracker mentioned in the description, but this does not seem to work.


Reply to this

-

 Re: Strange exception in log

 
 by andyboeh on: Nov 17 2015
 
Score 50%

Please increase the log level to "DEBUG" and send me the detailed error log, preferably via E-Mail or the bug tracker.

The bug tracker works, it's just called "Tasks". Click on "Open Tasks" on the left and on "Create new Task..." in the upper right corner.


Reply to this

-

 Re: Re: Strange exception in log

 
 by brandis on: Nov 18 2015
 
Score 50%

It is working now. I fiddled a little bit with the configuration of user_sql yesterday, since then it works. A little bit strange since I did not change any configuration, I only filled in all advanced configuration options, which were not configured before.


Reply to this

-

 Re: Re: Re: Strange exception in log

 
 by andyboeh on: Nov 18 2015
 
Score 50%

I see - according to the log snippet, you did not specify username and password column, that's why it failed.

In an earlier version of user_sql, default values for the columns were defined. The current version doesn't seem to have those, so I'm going to add some sanity checking before saving is allowed.

Thanks for the report!


Reply to this

-
.

 owncloud 8.2 and user_sql

 
 by maciejstromich on: Dec 17 2015
 
Score 50%

owncloud 8.2 changes logging

Quote:
OC_Log::write -> \OCP\Util::writeLog
OC_Log::DEBUG -> \OCP\Util::DEBUG


So fix user_sql in ownCloud 8.2 I had to

Quote:
vim apps/user_sql/user_sql.php
:%s/OC_Log::write/\\OCP\\Util::writeLog/g
:%s/OC_Log::/\\OCP\\Util::/g


Thanks for the awesome plugin! :-)


Reply to this

-

 Re: owncloud 8.2 and user_sql

 
 by andyboeh on: Dec 17 2015
 
Score 50%

Thanks for your comment and your great feedback!

However, I suppose you are running an older version of user_sql, this has already been fixed in July (https://www.aboehler.at/hg/user_sql/rev/0eb61392edc6).


Reply to this

-

 Re: Re: owncloud 8.2 and user_sql

 
 by maciejstromich on: Dec 17 2015
 
Score 50%

Hm... looks like it. I've never upgraded user_sql plugin for any of the 8.1.* versions after the 8.0 -> 8.1 upgrade.

I will install your newest version for 8.1 in 8.2 and check if anything needs to be done.

Thanks for the reply


Reply to this

-

 Re: Re: Re: owncloud 8.2 and user_sql

 
 by andyboeh on: Dec 17 2015
 
Score 50%

I'm running it on 8.2 for a couple of weeks now and didn't experience issues. Thus, I just updated the download links and compatibility status for 8.2.

If you find any issues, don't hesitate to post them.


Reply to this

-

 Re: Re: Re: Re: owncloud 8.2 and user_sql

 
 by maciejstromich on: Dec 18 2015
 
Score 50%

Yeah, I noticed after posting a comment :-)

The only issue I had was the same as brandis had with SQL syntax, but after logging in as an owncloud native admin account and saving default settings for user_sql everything went back to normal.

Once again thanks for making my life easier :-)


Reply to this

-

 Re: Re: Re: Re: Re: owncloud 8.2 and user_sql

 
 by andyboeh on: Dec 18 2015
 
Score 50%

Hm, well, maybe something's wrong with the database update script (the way settings are stored has changed, maybe there's a problem with the update script).


Reply to this

-

 No app name specified

 
 by ThomasZastrow on: Jan 22 2016
 
Score 50%

I downloaded the archive, unzipped it and put it into the "app" folder of my OC installation (fresh 8.2.2 installation). The app shows up unter "Disabled Apps", when enabling it, I got the error:

"No app name specified"


Reply to this

-

 No app name specified

 
 by ThomasZastrow on: Jan 22 2016
 
Score 50%

I downloaded the archive, unzipped it and put it into the "app" folder of my OC installation (fresh 8.2.2 installation). The app shows up unter "Disabled Apps", when enabling it, I got the error:

"No app name specified"


Reply to this

-

 No app name specified

 
 by ThomasZastrow on: Jan 22 2016
 
Score 50%

I downloaded the archive, unzipped it and put it into the "app" folder of my OC installation (fresh 8.2.2 installation). The app shows up unter "Disabled Apps", when enabling it, I got the error:

"No app name specified"


Reply to this

-

 Re: No app name specified

 
 by andyboeh on: Jan 25 2016
 
Score 50%

1) The folder needs to be called "apps", not "app".

2) The folder for user_sql needs to be called user_sql. If you just untar, you need to rename it afterwards, because the name in the archive contains the mercurial changeset.


Reply to this

-

 Re: Re: No app name specified

 
 by ThomasZastrow on: 2 days ago
 
Score 50%

Thank you very much, and sorry for the duplicated posting :-)


Reply to this

goto page: prev   1  2  3  4  5  6 

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.