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



ownCloud Tool

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


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 when reporting bugs and issues. Click on "Tasks" on the left hand side and then on "Create Task..." in the upper right corner.


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

ownCloud 8.1
ownCloud 8.0
Send to a friend
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":"","app":"caldav","message":"Exception: {"Message":"An exception occurred while executing 'SELECT FROM mailbox WHERE username = :uid AND active' with params [""]: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 = '' 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

goto page: prev   1  2  3  4  5  6 

Add commentBack

 Who we are
Add App
Public API
Legal Notice
Report Abuse

Copyright 2011-2015 Team  
All rights reserved. is not liable for any content or goods on this site.
All contributors are responsible for the lawfulness of their uploads.