Apps
Knowledge
People
Register
Login



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

user_sql

   0.8.0  

ownCloud Tool

Score 53%
Version Control:  Link
Downloads:  783
Submitted:  Nov 27 2012
Updated:  Jun 8 2013

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 and mysql_encrypt encryption types, based on the PostfixAdmin functions.

It was developed to authenticate against a postfixadmin database configured with mySQL ENCRYPT().

Experimental support for DisplayNames is available in the OC5 branch in my repository (see homepage).




Changelog:

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
Send to a friend
Subscribe
Other  Apps  from andyboeh
Report inappropriate content



goto page: prev   1  2 

-

 Error enabling app

 
 by bl00513 on: Sep 24 2013
 
Score 50%

Hi all,

I've downloaded, unzipped, and untarred the app into /var/www/owncloud/apps. I go into the apps menu to enable the new app, but I get an error message saying "error enabling app". I'm running PHP Version 5.3.10-1ubuntu3.8 with Apache 2, on Ubuntu Server 12.04. I'm running OwnCloud v 5.0.11. Here's what I pulled from the error log:

Debug core include path for class "Zend_Search_Lucene_Document" starts with "apps/" 2013-09-24T15:06:57+00:00
Fatal PHP SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'appid' cannot be null at /var/www/owncloud/lib/db.php#1075 2013-09- 24T15:06:50+00:00
Warning PHP Invalid argument supplied for foreach() at /var/www/owncloud/lib/installer.php#420 2013-09-24T15:06:50+00:00
Warning PHP Invalid argument supplied for foreach() at /var/www/owncloud/lib/installer.php#417 2013-09-24T15:06:50+00:00
Fatal PHP SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'appid' cannot be null at /var/www/owncloud/lib/db.php#1075 2013-09-24T14:58:21+00:00
Warning PHP Invalid argument supplied for foreach() at /var/www/owncloud/lib/installer.php#420 2013-09-24T14:58:21+00:00

Does anyone have any idea as to what I'm doing wrong here? Have I missed some basic step?

Thanks!


Reply to this

-

 Re: Error enabling app

 
 by dsjodin on: Sep 25 2013
 
Score 50%

Hi,

I had some similar issue when I installed it. I discovered that when I had unpacked it under /owncloud/apps it has some numbers in the folder name. My solution was to rename the user_sql-62837468607b to just user_sql.

//Daniel


Reply to this

-

 Re: Re: Error enabling app

 
 by bl00513 on: Sep 25 2013
 
Score 50%

Hah... that was the problem. I cannot believe the solution was that simple. Thanks a ton for the response!


Reply to this

-

 adding users

 
 by bl00513 on: Sep 25 2013
 
Score 50%

I've got the app activate and talking to my database; however it doesn't seem to be pulling in any users. If the app is configured correctly, will the users actually get added to the user list in OwnCloud? Also, my passwords are stored as a salted hash? I imagine I'll have to work around that, but would this prevent the users from populating?


Reply to this

-

 app works fine, adding email addresse ?

 
 by defaliz on: Dec 3 2013
 
Score 50%

Hello, this app is very useful for me...
but it will be good to insert email adresse
like for displayname...

is it possible ?

thanks a lot
alain


Reply to this

-

 Re: app works fine, adding email addresse ?

 
 by andyboeh on: Dec 11 2013
 
Score 50%

Hi,
thanks for your suggestion! I just checked a few inner workings of ownCloud and can say: Yes, it sure is possible. There could be a checkbox and a further line edit for specifying the column to use.

I'm going to add this feature, but it will take a few days to weeks, as I'm quite busy right now. I'll reply to this post once it's done.


Reply to this

-

 Joomla didn't work

 
 by evilshinobi on: Mar 21 2014
 
Score 50%
evilshinobievilshinobi
Community Project
Home
-
A. Hartmann 0

Community Project
Switzerland
Last visit Apr 15 2014
0 Friends

More info
Send a message
Add as friend
Other contents
--

Hi, great app!
I could connect to my joomla database and every single user are now listed in owncloud. very easy!

But they can't log in, why is that so? Can't even change the passwort or something. What did I do wrong?


Reply to this

-

 active user

 
 by vegenet on: Apr 2 2014
 
Score 50%

Hi,

what shall i put in the "User Active Column" field
to use the postfixadmindb active/inactive feature ?

Thanks, Carsten


Reply to this

-

 active user

 
 by vegenet on: Apr 2 2014
 
Score 50%

Hi,

what shall i put in the "User Active Column" field
to use the postfixadmindb active/inactive feature ?

Thanks, Carsten


Reply to this

goto page: prev   1  2 

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