Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

[Johan H. <Jo...@do...>]

>-----Oorspronkelijk bericht-----
>Van: Christian Boltz [mailto:pos...@cb...] 
>Verzonden: dinsdag 6 november 2012 19:37
>Aan: pos...@li...
>Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

>Hello,

>Am Dienstag, 6. November 2012 schrieb Robert Schetterer:
>> Am 06.11.2012 09:59, schrieb Johan Hendriks:
>> > I try to get Owncloud running in combination with posfixadmin.

>> http://forum.owncloud.org/viewtopic.php?f=3&t=2250
>> 
>> --snip
>> change the password check functions in owncloud/lib/user/database.php 
>> and let them check versus your joomla user database entries instead of 
>> the owncloud database.
>> --snip

>Instead of changing core code of OwnCloud, better write a small plugin. 
>The plugin to authentificate against a redmine database might be a good starting point ;-)

>http://apps.owncloud.com/content/show.php/user_redmine?content=150740


>Another way is to use IMAP logins to verify the user password. There's already an ownClowd plugin to do that, but I >can't guarantee for anything ;-)

>http://apps.owncloud.com/content/show.php?content=148653&forumpage=0


>Note that I didn't test any of the plugins mentioned above. I don't even use OwnCloud ;-)


>Regards,

>Christian Boltz


Thanks all for the answers.
And sorry if this is the wrong mailinglist.

I have it working with the user_imap and i can read the users from the DB.
But i want a cleaner way so even if the imap server is down, users can still use owncloud and authenticate against the database.

Also using user_redmine AND plain MD5 i got it working

The thing is that it is not working if i use md5crypt.
That way it seems impossible to get the password!


This is the code from user_remine
$sql = 'SELECT login FROM users WHERE login = :uid';
        $sql .= ' AND hashed_password = SHA1(CONCAT(salt, SHA1(:password)))';

If i use $CONF['encrypt'] = 'md5'; in config.inc.php in postfixadmin,
And change the password for a user through postfixadmin
And use the following: 
$sql = 'SELECT username FROM mailbox WHERE username = :uid';
        $sql .= ' AND password = MD5(:password)';
Then i can login.

But if i use the following in config.inc.php
$CONF['encrypt'] = 'md5crypt'; which i have in production.
Then i can not login.
So i need a way to get the password, maybe need some salt? I really do not know.
But this goes byond my knowledge.
I am so close to get this to work, but the md5crypt keeps me from using it.

Thanks again all
gr
Johan