Apps
Knowledge
People
Register
Login
APPS
-

FORUM
-


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

user_sql

   0.7.1  

ownCloud Tool

Score 53%
andyboehandyboeh
Blog:  http://blog.aboehler.at
Downloads:  341
Submitted:  Nov 27 2012
Updated:  Mar 2 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().




Changelog:

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




License: AGPL
Send to a friend
Subscribe
Other  Apps  from andyboeh
Report inappropriate content

-
.

 Error 500

 
 by puffi on: Dec 12 2012  
Score 50%
puffipuffi

Hi,

I have a server error 500, but it only happens when I enable this extensions. Probably linked to the apache running under CGI, but I have no idea about the hosting...

Thanks for any help,
Daniel

Error log:
[Wed Dec 12 15:19:19 2012] [error] [client 193.5.240.1] FastCGI: incomplete headers (0 bytes) received from server "/var/run/hcgi/278124"

Error displayed in browser:

Server error!

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

If you think this is a server error, please contact the webmaster.

Error 500

Wed Dec 12 15:36:45 2012
Apache/2.2.22 (FreeBSD) mod_ssl/2.2.22 OpenSSL/1.0.1c mod_hcgi/0.9.4 DAV/2


Reply to this

-

 Re: Error 500

 
 by andyboeh on: Dec 13 2012  
Score 50%
andyboehandyboeh

Hey,

unfortunately I can't reproduce this issue, especially not given the fact that mod_hcgi seems to be a proprietary PHP accelerator.

However, if you would like to help debug this issue, I can send you a version with very verbose logging enabled so that we can see what's going on right before it crashes.

Please contact me via E-Mail in this case!

Andreas


Reply to this

-

 Some features

 
 by Knah-Tsaeb on: Jan 9 2013  
Score 50%
Knah-TsaebKnah-Tsaeb

Hi, thanks for your work.

I not use PostfixAdmin, but a similar solution, and i have multiple domains and users. Your apps work like a charm.

1°) Can you use domain for group
exemple : user@toto.com => add user in group toto

2°) If I remove user in Owncloud, after your apps import. In the next "scan" apps reimport my deleted user. Maybie you can add field in your apps config for store info for don't reimport delete user.


Thanks


Reply to this

-

 Re: Some features

 
 by andyboeh on: Jan 9 2013  
Score 50%
andyboehandyboeh

Hi,

ad 1)
That would be possible, however, I currently don't have any plans to complete group support. I could imagine a checkbox "Treat domain as group".

ad 2)
No. You cannot delete users within owncloud if this app is enabled, it should display an error message (you can't create users either). Your external system must handle this. Use the "active" column if you want to disable certain users.


Reply to this

-

 Re: Re: Some features

 
 by Knah-Tsaeb on: Jan 9 2013  
Score 50%
Knah-TsaebKnah-Tsaeb

I have a column active, but for exemple i have generique email contact@toto.com, this adress have no any reason to access to Owncloud, is not a real user. But the email must be active.

I add new column for 'active' => 'owncloud', and use that for define owncloud account.

But thank for response.


Reply to this

-
.

 Download website currently down?!

 
 by jochenwezel on: Jan 28 2013  
Score 50%
jochenwezeljochenwezel
CompuMaster GmbH

the whole blog website at http://blog.aboehler.at doesn't response any more, currently :-(

Is there any alternative download URL available?


Reply to this

-

 Re: Download website currently down?!

 
 by andyboeh on: Jan 29 2013  
Score 50%
andyboehandyboeh

yes, currently down; my ISP cut the connection.

I'm migrating the system to a new hoster, I hope that the website is back up tonight.


Reply to this

-
.

 MS SQL server support

 
 by jochenwezel on: Jan 30 2013  
Score 50%
jochenwezeljochenwezel
CompuMaster GmbH

I'd like to use the user_sql module with my local MS SQL server (user accounts already exist there in tables).

Does it makes sense to extend current sql server support for MySql and PostgreSql with MS sql server support?
Or should we better create a fork on user_sql?

Is the code already available somewhere at Git, Svn, ... for preparing some commits?


Reply to this

-

 Re: MS SQL server support

 
 by andyboeh on: Jan 30 2013  
Score 50%
andyboehandyboeh

sure, go ahead. in fact it's PDO-based, so adding an entry for MS SQL and maybe adapting the one or the other query should be enough.

usually, there is a mercurial repository for development, however my host is currently down.

if you send me patches, i'll be happy to commit them, i can't test on ms sql though. i'll post back as soon as the repo is back up.


Reply to this

-
.

 MYSQL PASSWORD() Support

 
 by Kita on: Feb 12 2013  
Score 50%
KitaKita
Home

Hi,

great stuff :)
i need MySQL PASSWORD()-Function can you add in the next Release?

Greetings,
Kita


Reply to this

-

 Re: MYSQL PASSWORD() Support

 
 by andyboeh on: Feb 16 2013  
Score 50%
andyboehandyboeh

I just committed support for this, however it is untested.
Could you report back your results? Could you please test password changing as well?


Reply to this

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