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

Brought to you by: christian_boltz, gingerdog

postfixadmin-devel

[Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

From: Johan H. <Jo...@do...> - 2012-11-06 09:12:44

Hello all.

I try to get Owncloud running in combination with posfixadmin.

All goes well if i use normal MD5 encryption in my config.inc.php
$CONF['encrypt'] = 'md5';

This way i can do the following:

mysql> SELECT username FROM mailbox WHERE username = 'myt...@te...' AND password = md5('mypassword');
+----------------------------+
| username                   |
+----------------------------+
| myt...@te...|
+----------------------------+
1 row in set (0.00 sec)

The problem however is that my real database with over 200 users is using the md5crypt option.
$CONF['encrypt'] = 'md5crypt';

This way i can not get the password field to match.
Could someone help me with this.
I have spend days figuring this out, but my MySQL knowledge is falling short.

thanks for your time.
regards
Johan Hendriks

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

From: Robert S. <ro...@sc...> - 2012-11-06 09:34:02

Am 06.11.2012 09:59, schrieb Johan Hendriks:
> Hello all.
> 
> I try to get Owncloud running in combination with posfixadmin.
> 
> All goes well if i use normal MD5 encryption in my config.inc.php
> $CONF['encrypt'] = 'md5';
> 
> This way i can do the following:
> 
> mysql> SELECT username FROM mailbox WHERE username =
> 'myt...@te...' AND password = md5('mypassword');
> +----------------------------+
> | username                   |
> +----------------------------+
> | myt...@te...|
> +----------------------------+
> 1 row in set (0.00 sec)
> 
> The problem however is that my real database with over 200 users is
> using the md5crypt option.
> $CONF['encrypt'] = 'md5crypt';
> 
> This way i can not get the password field to match.
> Could someone help me with this.
> I have spend days figuring this out, but my MySQL knowledge is falling
> short.
> 
> thanks for your time.
> regards
> Johan Hendriks
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> 
> 
> 
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
> 

try

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



-- 
Best Regards
MfG Robert Schetterer

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

From: Christian B. <pos...@cb...> - 2012-11-06 18:55:23

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
-- 
> Also komm doch mal runter jetzt. Du hast da was falsch verstanden!
Gut, daß Du nichts flasch verstanden hast.
Hups, das war jetzt eine Spitze, die von Dir natürlich nicht hätte
kommen können. hups, noch eine.
[> toRBEN pOLLmann und Bernd Brodesser in suse-linux]

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

From: Johan H. <Jo...@do...> - 2012-11-07 11:57:18

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

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

From: Rudi F. <rud...@go...> - 2012-11-07 15:22:00

Look into the pfacrypt file.

There you find the way postfixadmin hashes the password.
You could copy pase that into the copied redmine plugin.


Am Mittwoch, 7. November 2012 12:56:59 schrieb Johan Hendriks:
>> -----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
>
>
>
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Johan H. <Jo...@do...> - 2012-11-08 08:16:12

Thanks for your reply.
I do not have a file pacrypt!
I do have the function pacrypt!
But i am not a real coder.
I will try to make it work, I think more people would benevit from it.

thanks
regards
Johan

________________________________________
Van: Rudi Floren [rud...@go...]
Verzonden: woensdag 7 november 2012 16:21
Aan: Johan Hendriks
CC: pos...@li...; Christian Boltz
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Look into the pfacrypt file.

There you find the way postfixadmin hashes the password.
You could copy pase that into the copied redmine plugin.


Am Mittwoch, 7. November 2012 12:56:59 schrieb Johan Hendriks:
>> -----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
>
>
>
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Johan H. <Jo...@do...> - 2012-11-08 13:05:58

If i add the function i get the error unexpected T_PRIVATE on line  72
Which is outside of the added code.
Well that goes waaaay beond my knowledge.
And i am not a coder so i stand ground :D

Too bad, because it could be a nice extension to the whole postfixadmin server.

I tink i use the imap function instead.

gr
Johan






Van: Rudi Floren [mailto:rud...@go...]
Verzonden: donderdag 8 november 2012 11:13
Aan: Johan Hendriks
Onderwerp: RE: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database


That's the one I meant.

Look for md5crypt inside pacrypt and try to understand what is done inside.
Am 08.11.2012 09:16 schrieb "Johan Hendriks" <Jo...@do...<mailto:Jo...@do...>>:
Thanks for your reply.
I do not have a file pacrypt!
I do have the function pacrypt!
But i am not a real coder.
I will try to make it work, I think more people would benevit from it.

thanks
regards
Johan

________________________________________
Van: Rudi Floren [rud...@go...<mailto:rud...@go...>]
Verzonden: woensdag 7 november 2012 16:21
Aan: Johan Hendriks
CC: pos...@li...<mailto:pos...@li...>; Christian Boltz
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Look into the pfacrypt file.

There you find the way postfixadmin hashes the password.
You could copy pase that into the copied redmine plugin.


Am Mittwoch, 7. November 2012 12:56:59 schrieb Johan Hendriks:
>> -----Oorspronkelijk bericht-----
>> Van: Christian Boltz [mailto:pos...@cb...<mailto:pos...@cb...>]
>> Verzonden: dinsdag 6 november 2012 19:37
>> Aan: pos...@li...<mailto: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<tel:06.11.2012%2009>: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
>
>
>
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Rudi F. <rud...@go...> - 2012-11-08 14:35:25

Send me the file from own cloud eventually I can implement it this evening
Am 08.11.2012 14:05 schrieb "Johan Hendriks" <Jo...@do...>:

>  If i add the function i get the error unexpected T_PRIVATE on line  72 **
> **
>
> Which is outside of the added code. ****
>
> Well that goes waaaay beond my knowledge.****
>
> And i am not a coder so i stand ground :D****
>
> ** **
>
> Too bad, because it could be a nice extension to the whole postfixadmin
> server.****
>
>
> I tink i use the imap function instead.
>
> gr****
>
> Johan
>
>
> ****
>
>
>
>
> ****
>
> ** **
>
> *Van:* Rudi Floren [mailto:rud...@go...]
> *Verzonden:* donderdag 8 november 2012 11:13
> *Aan:* Johan Hendriks
> *Onderwerp:* RE: [Postfixadmin-devel] Owncloud Authenticate against
> postfixadmin database****
>
> ** **
>
> That's the one I meant.****
>
> Look for md5crypt inside pacrypt and try to understand what is done inside.
> ****
>
> Am 08.11.2012 09:16 schrieb "Johan Hendriks" <Jo...@do...>:****
>
> Thanks for your reply.
> I do not have a file pacrypt!
> I do have the function pacrypt!
> But i am not a real coder.
> I will try to make it work, I think more people would benevit from it.
>
> thanks
> regards
> Johan
>
> ________________________________________
> Van: Rudi Floren [rud...@go...]
> Verzonden: woensdag 7 november 2012 16:21
> Aan: Johan Hendriks
> CC: pos...@li...; Christian Boltz
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
> postfixadmin database
>
> Look into the pfacrypt file.
>
> There you find the way postfixadmin hashes the password.
> You could copy pase that into the copied redmine plugin.
>
>
> Am Mittwoch, 7. November 2012 12:56:59 schrieb Johan Hendriks:
> >> -----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
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > LogMeIn Central: Instant, anywhere, Remote PC access and management.
> > Stay in control, update software, and manage PCs from one command center
> > Diagnose problems and improve visibility into emerging IT issues
> > Automate, monitor and manage. Do more in less time with Central
> > http://p.sf.net/sfu/logmein12331_d2d
> > _______________________________________________
> > Postfixadmin-devel mailing list
> > Pos...@li...
> > https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel****
>

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

From: Rudi F. <rud...@go...> - 2012-11-08 23:10:13

Attachments: user_postfixadmin.php

<?php

/**
 * ownCloud
 *
 * @author Steffen Zieger
 * @copyright 2012 Steffen Zieger <me...@sa...>
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU AFFERO GENERAL PUBLIC LICENSE
 * License as published by the Free Software Foundation; either
 * version 3 of the License, or any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU AFFERO GENERAL PUBLIC LICENSE for more details.
 *
 * You should have received a copy of the GNU Affero General Public
 * License along with this library.  If not, see <http://www.gnu.org/licenses/>.
 *
 */

class OC_User_Postfixadmin extends OC_User_Backend {
    protected $postfixadmin_db_host;
    protected $postfixadmin_db_name;
    protected $postfixadmin_db_user;
    protected $postfixadmin_db_password;
    protected $db;
    protected $db_conn;

    function __construct() {
        $this->db_conn = false;
        $db_host = OC_Appconfig::getValue('user_postfixadmin', 'postfixadmin_db_host','');
        $db_name = OC_Appconfig::getValue('user_postfixadmin', 'postfixadmin_db_name','');
        $db_driver = OC_Appconfig::getValue('user_postfixadmin', 'postfixadmin_db_driver', 'mysql');
        $db_user = OC_Appconfig::getValue('user_postfixadmin', 'postfixadmin_db_user','');
        $db_password = OC_Appconfig::getValue('user_postfixadmin', 'postfixadmin_db_password','');
        $dsn = "${db_driver}:host=${db_host};dbname=${db_name}";

        try {
            $this->db = new PDO($dsn, $db_user, $db_password);
            $this->db_conn = true;
        } catch (PDOException $e) {
            OC_Log::write('OC_User_Postfixadmin',
                'OC_User_Postfixadmin, Failed to connect to postfixadmin database: ' . $e->getMessage(),
                OC_Log::ERROR);
        }
        return false;
    }

    /**
     * @brief Set email address
     * @param $uid The username
     */
    private function setEmail($uid) {
        if (!$this->db_conn) {
            return false;
        }

        $sql = 'SELECT username FROM mailbox WHERE username = :uid';
        $sth = $this->db->prepare($sql);
        if ($sth->execute(array(':uid' => $uid))) {
            $row = $sth->fetch();

            if ($row) {
                if (OC_Preferences::setValue($uid, 'settings', 'email', $row['mail'])) {
                    return true;
                }
            }
        }
        return false;
    }

    /**
     * @brief Check if the password is correct
     * @param $uid The username
     * @param $password The password
     * @returns true/false
     */
    public function checkPassword($uid, $password){
        if (!$this->db_conn) {
            return false;
        }

        $pw = "";
        $pw = OC_User_Postfixadmin::md5crypt ($password, "");

        $sql = 'SELECT username FROM mailbox WHERE username = :uid';
        $sql .= ' AND password = :password';
        $sth = $this->db->prepare($sql);
        if ($sth->execute(array(':uid' => $uid, ':password' => $pw))) {
            $row = $sth->fetch();

            if ($row) {
                $this->setEmail($uid);
                return $row['username'];
            }
        }
        return false;
    }

    /**
     * @brief Get a list of all users
     * @returns array with all uids
     *
     * Get a list of all users
     */

       public function getUsers($search = '', $limit = null, $offset = null){
               $users = array();
               // we only know about logged in users
               if (isset($_SESSION['user_id']) AND $_SESSION['user_id'] ){
                       $users[] = $_SESSION['user_id'];
               }
               return $users;
       }


    /**
     * @brief check if a user exists
     * @param string $uid the username
     * @return boolean
     */

       public function userExists($uid){
               return(isset($_SESSION['user_id']) &&
                      $_SESSION['user_id'] == $uid);
       }

       //
        // md5crypt
        // Action: Creates MD5 encrypted password
        // Call: md5crypt (string cleartextpassword)
        //

        public function md5crypt ($pw, $salt="", $magic="")
        {
            $MAGIC = "$1$";

            if ($magic == "") $magic = $MAGIC;
            if ($salt == "") $salt = create_salt ();
            $slist = explode ("$", $salt);
            if ($slist[0] == "1") $salt = $slist[1];

            $salt = substr ($salt, 0, 8);
            $ctx = $pw . $magic . $salt;
            $final = hex2bin (md5 ($pw . $salt . $pw));

            for ($i=strlen ($pw); $i>0; $i-=16)
            {
                if ($i > 16)
                {
                    $ctx .= substr ($final,0,16);
                }
                else
                {
                    $ctx .= substr ($final,0,$i);
                }
            }
            $i = strlen ($pw);

            while ($i > 0)
            {
                if ($i & 1) $ctx .= chr (0);
                else $ctx .= $pw[0];
                $i = $i >> 1;
            }
            $final = hex2bin (md5 ($ctx));

            for ($i=0;$i<1000;$i++)
            {
                $ctx1 = "";
                if ($i & 1)
                {
                    $ctx1 .= $pw;
                }
                else
                {
                    $ctx1 .= substr ($final,0,16);
                }
                if ($i % 3) $ctx1 .= $salt;
                if ($i % 7) $ctx1 .= $pw;
                if ($i & 1)
                {
                    $ctx1 .= substr ($final,0,16);
                }
                else
                {
                    $ctx1 .= $pw;
                }
                $final = hex2bin (md5 ($ctx1));
            }
            $passwd = "";
            $passwd .= to64 (((ord ($final[0]) << 16) | (ord ($final[6]) << 8) | (ord ($final[12]))), 4);
            $passwd .= to64 (((ord ($final[1]) << 16) | (ord ($final[7]) << 8) | (ord ($final[13]))), 4);
            $passwd .= to64 (((ord ($final[2]) << 16) | (ord ($final[8]) << 8) | (ord ($final[14]))), 4);
            $passwd .= to64 (((ord ($final[3]) << 16) | (ord ($final[9]) << 8) | (ord ($final[15]))), 4);
            $passwd .= to64 (((ord ($final[4]) << 16) | (ord ($final[10]) << 8) | (ord ($final[5]))), 4);
            $passwd .= to64 (ord ($final[11]), 2);
            return "$magic$salt\$$passwd";
        }



 }
/**/ if (!function_exists('hex2bin')) { # PHP around 5.3.8 includes hex2bin as native function - http://php.net/hex2bin
function hex2bin ($str)
{
    $len = strlen ($str);
    $nstr = "";
    for ($i=0;$i<$len;$i+=2)
    {
        $num = sscanf (substr ($str,$i,2), "%x");
        $nstr.=chr ($num[0]);
    }
    return $nstr;
}
/**/ }

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

From: Johan H. <Jo...@do...> - 2012-11-09 08:36:20

Thanks for the file.

It does not work, the error i get is
[Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal error:  Call to undefined function create_salt() in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 147

I saw in the postfixadmin function.inc.php file the following


function create_salt () {
    srand ((double) microtime ()*1000000);
    $salt = substr (md5 (rand (0,9999999)), 0, 8);
    return $salt;
}

So i thougt i add it at the end of the file, but i keep getting the error??

thanks again.

gr
Johan



Van: Rudi Floren [mailto:rud...@go...]
Verzonden: vrijdag 9 november 2012 0:10
Aan: Johan Hendriks
CC: Rudi Floren; pos...@li...
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Try with these file.
i wrote it in less than 5 minutes.  so its untested.
please test before using in prod. env.




Am 08.11.2012 16:17, schrieb Johan Hendriks:

That fast, i am trying to get it done for at least a week or two  :(



Sometimes i think it is time to start programming.
But time restraints always catch up.

I send you a tar file which has the whole plugin.
I did not do the GetUser part because i got stuck on the md5crypt thing.

But i altered the user_phpbb3 plugin and that showed me all my users.



The user_postfixadmin.tar file it is a copy of the redmine plugin.

once enabled, you can set the db info in the admin page in owncloud

the file is user_posfixadmin.php



And many many thanks.



regards

Johan







________________________________
Van: Rudi Floren [rud...@go...<mailto:rud...@go...>]
Verzonden: donderdag 8 november 2012 15:35
Aan: Johan Hendriks
CC: pos...@li...<mailto:pos...@li...>
Onderwerp: RE: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Send me the file from own cloud eventually I can implement it this evening
Am 08.11.2012 14:05 schrieb "Johan Hendriks" <Jo...@do...<mailto:Jo...@do...>>:
If i add the function i get the error unexpected T_PRIVATE on line  72
Which is outside of the added code.
Well that goes waaaay beond my knowledge.
And i am not a coder so i stand ground :D

Too bad, because it could be a nice extension to the whole postfixadmin server.

I tink i use the imap function instead.

gr
Johan




Van: Rudi Floren [mailto:rud...@go...<mailto:rud...@go...>]
Verzonden: donderdag 8 november 2012 11:13
Aan: Johan Hendriks
Onderwerp: RE: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database


That's the one I meant.

Look for md5crypt inside pacrypt and try to understand what is done inside.
Am 08.11.2012 09<tel:08.11.2012%2009>:16 schrieb "Johan Hendriks" <Jo...@do...<mailto:Jo...@do...>>:
Thanks for your reply.
I do not have a file pacrypt!
I do have the function pacrypt!
But i am not a real coder.
I will try to make it work, I think more people would benevit from it.

thanks
regards
Johan

________________________________________
Van: Rudi Floren [rud...@go...<mailto:rud...@go...>]
Verzonden: woensdag 7 november 2012 16:21
Aan: Johan Hendriks
CC: pos...@li...<mailto:pos...@li...>; Christian Boltz
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Look into the pfacrypt file.

There you find the way postfixadmin hashes the password.
You could copy pase that into the copied redmine plugin.


Am Mittwoch, 7. November 2012 12:56:59 schrieb Johan Hendriks:
>> -----Oorspronkelijk bericht-----
>> Van: Christian Boltz [mailto:pos...@cb...<mailto:pos...@cb...>]
>> Verzonden: dinsdag 6 november 2012 19:37
>> Aan: pos...@li...<mailto: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<tel:06.11.2012%2009>: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
>
>
>
> ------------------------------------------------------------------------------
> LogMeIn Central: Instant, anywhere, Remote PC access and management.
> Stay in control, update software, and manage PCs from one command center
> Diagnose problems and improve visibility into emerging IT issues
> Automate, monitor and manage. Do more in less time with Central
> http://p.sf.net/sfu/logmein12331_d2d
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Christian B. <pos...@cb...> - 2012-11-12 20:32:07

Hello,

Am Freitag, 9. November 2012 schrieb Johan Hendriks:
> It does not work, the error i get is
> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
> error:  Call to undefined function create_salt() in
> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
> on line 147
> 
> I saw in the postfixadmin function.inc.php file the following
> 
> 
> function create_salt () {
>     srand ((double) microtime ()*1000000);
>     $salt = substr (md5 (rand (0,9999999)), 0, 8);
>     return $salt;
> }
> 
> So i thougt i add it at the end of the file, but i keep getting the
> error??

You probably added the function inside the class, which means you need 
to replace all calls of "create_salt" with 
"OC_User_Postfixadmin::create_salt"


Regards,

Christian Boltz
-- 
Der Tag hat 24 Stunden und wenn es sein muss,
dann arbeiten wir auch noch nachts!

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

From: Johan H. <Jo...@do...> - 2012-11-13 13:19:40

Attachments: user_postfixadmin.php

Thank you, that error is gone now, after that i got the same error on the hex2bin function.
Using the same method that error is gone also :D

Then i did get a method error on to64, but i solved that also.

So everything seems to function.

I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.

Then i log on to owncloud using my email adres with the new password set  through postfixadmin 
In the mysql log i see the following:

Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'

So it look much more like the password that is used, but stil no match.
If i look from within mysql itself i get.

mysql> select password from mailbox where username = 'j.h...@te...';
+------------------------------------+
| password                           |
+------------------------------------+
| $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
+------------------------------------+
1 row in set (0.00 sec)


The user_postfixadmin.php file is attached.

Thanks you all for your time and patience with me! 
regards 
Johan

________________________________________
Van: Christian Boltz [pos...@cb...]
Verzonden: maandag 12 november 2012 21:31
Aan: pos...@li...
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database

Hello,

Am Freitag, 9. November 2012 schrieb Johan Hendriks:
> It does not work, the error i get is
> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
> error:  Call to undefined function create_salt() in
> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
> on line 147
>
> I saw in the postfixadmin function.inc.php file the following
>
>
> function create_salt () {
>     srand ((double) microtime ()*1000000);
>     $salt = substr (md5 (rand (0,9999999)), 0, 8);
>     return $salt;
> }
>
> So i thougt i add it at the end of the file, but i keep getting the
> error??

You probably added the function inside the class, which means you need
to replace all calls of "create_salt" with
"OC_User_Postfixadmin::create_salt"


Regards,

Christian Boltz
--
Der Tag hat 24 Stunden und wenn es sein muss,
dann arbeiten wir auch noch nachts!


------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Postfixadmin-devel mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Rudi F. <rud...@go...> - 2012-11-13 13:33:50

Attachments: user_postfixadmin.php

I think the problem is the salt.

try this. its untested.


Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
> Using the same method that error is gone also :D
>
> Then i did get a method error on to64, but i solved that also.
>
> So everything seems to function.
>
> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>
> Then i log on to owncloud using my email adres with the new password set  through postfixadmin
> In the mysql log i see the following:
>
> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>
> So it look much more like the password that is used, but stil no match.
> If i look from within mysql itself i get.
>
> mysql> select password from mailbox where username = 'j.h...@te...';
> +------------------------------------+
> | password                           |
> +------------------------------------+
> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
> +------------------------------------+
> 1 row in set (0.00 sec)
>
>
> The user_postfixadmin.php file is attached.
>
> Thanks you all for your time and patience with me!
> regards
> Johan
>
> ________________________________________
> Van: Christian Boltz [pos...@cb...]
> Verzonden: maandag 12 november 2012 21:31
> Aan: pos...@li...
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database
>
> Hello,
>
> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>> It does not work, the error i get is
>> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
>> error:  Call to undefined function create_salt() in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 147
>>
>> I saw in the postfixadmin function.inc.php file the following
>>
>>
>> function create_salt () {
>>      srand ((double) microtime ()*1000000);
>>      $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>      return $salt;
>> }
>>
>> So i thougt i add it at the end of the file, but i keep getting the
>> error??
>
> You probably added the function inside the class, which means you need
> to replace all calls of "create_salt" with
> "OC_User_Postfixadmin::create_salt"
>
>
> Regards,
>
> Christian Boltz
> --
> Der Tag hat 24 Stunden und wenn es sein muss,
> dann arbeiten wir auch noch nachts!
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
>
>
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Johan H. <Jo...@do...> - 2012-11-13 13:40:06

That gives me the following error.

 [error] [client 192.168.50.102] PHP Parse error:  syntax error, unexpected '=', expecting ')' in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/

line 88 is 
 if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {

thanks
gr
Johan
________________________________________
Van: Rudi Floren [rud...@go...]
Verzonden: dinsdag 13 november 2012 14:33
Aan: Johan Hendriks
CC: pos...@li...; Christian Boltz
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

I think the problem is the salt.

try this. its untested.


Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
> Using the same method that error is gone also :D
>
> Then i did get a method error on to64, but i solved that also.
>
> So everything seems to function.
>
> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>
> Then i log on to owncloud using my email adres with the new password set  through postfixadmin
> In the mysql log i see the following:
>
> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>
> So it look much more like the password that is used, but stil no match.
> If i look from within mysql itself i get.
>
> mysql> select password from mailbox where username = 'j.h...@te...';
> +------------------------------------+
> | password                           |
> +------------------------------------+
> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
> +------------------------------------+
> 1 row in set (0.00 sec)
>
>
> The user_postfixadmin.php file is attached.
>
> Thanks you all for your time and patience with me!
> regards
> Johan
>
> ________________________________________
> Van: Christian Boltz [pos...@cb...]
> Verzonden: maandag 12 november 2012 21:31
> Aan: pos...@li...
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database
>
> Hello,
>
> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>> It does not work, the error i get is
>> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
>> error:  Call to undefined function create_salt() in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 147
>>
>> I saw in the postfixadmin function.inc.php file the following
>>
>>
>> function create_salt () {
>>      srand ((double) microtime ()*1000000);
>>      $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>      return $salt;
>> }
>>
>> So i thougt i add it at the end of the file, but i keep getting the
>> error??
>
> You probably added the function inside the class, which means you need
> to replace all calls of "create_salt" with
> "OC_User_Postfixadmin::create_salt"
>
>
> Regards,
>
> Christian Boltz
> --
> Der Tag hat 24 Stunden und wenn es sein muss,
> dann arbeiten wir auch noch nachts!
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
>
>
> _______________________________________________
> Postfixadmin-devel mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel

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

From: Rudi F. <rud...@go...> - 2012-11-13 13:41:01

the second = should be =>

Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
> That gives me the following error.
>
>   [error] [client 192.168.50.102] PHP Parse error:  syntax error, unexpected '=', expecting ')' in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
>
> line 88 is
>   if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>
> thanks
> gr
> Johan
> ________________________________________
> Van: Rudi Floren [rud...@go...]
> Verzonden: dinsdag 13 november 2012 14:33
> Aan: Johan Hendriks
> CC: pos...@li...; Christian Boltz
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> I think the problem is the salt.
>
> try this. its untested.
>
>
> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>> Using the same method that error is gone also :D
>>
>> Then i did get a method error on to64, but i solved that also.
>>
>> So everything seems to function.
>>
>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>
>> Then i log on to owncloud using my email adres with the new password set  through postfixadmin
>> In the mysql log i see the following:
>>
>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>
>> So it look much more like the password that is used, but stil no match.
>> If i look from within mysql itself i get.
>>
>> mysql> select password from mailbox where username = 'j.h...@te...';
>> +------------------------------------+
>> | password                           |
>> +------------------------------------+
>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>> +------------------------------------+
>> 1 row in set (0.00 sec)
>>
>>
>> The user_postfixadmin.php file is attached.
>>
>> Thanks you all for your time and patience with me!
>> regards
>> Johan
>>
>> ________________________________________
>> Van: Christian Boltz [pos...@cb...]
>> Verzonden: maandag 12 november 2012 21:31
>> Aan: pos...@li...
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database
>>
>> Hello,
>>
>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>> It does not work, the error i get is
>>> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
>>> error:  Call to undefined function create_salt() in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 147
>>>
>>> I saw in the postfixadmin function.inc.php file the following
>>>
>>>
>>> function create_salt () {
>>>       srand ((double) microtime ()*1000000);
>>>       $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>       return $salt;
>>> }
>>>
>>> So i thougt i add it at the end of the file, but i keep getting the
>>> error??
>>
>> You probably added the function inside the class, which means you need
>> to replace all calls of "create_salt" with
>> "OC_User_Postfixadmin::create_salt"
>>
>>
>> Regards,
>>
>> Christian Boltz
>> --
>> Der Tag hat 24 Stunden und wenn es sein muss,
>> dann arbeiten wir auch noch nachts!
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor your physical, virtual and cloud infrastructure from a single
>> web console. Get in-depth insight into apps, servers, databases, vmware,
>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>> Pricing starts from $795 for 25 servers or applications!
>> http://p.sf.net/sfu/zoho_dev2dev_nov
>> _______________________________________________
>> Postfixadmin-devel mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor your physical, virtual and cloud infrastructure from a single
>> web console. Get in-depth insight into apps, servers, databases, vmware,
>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>> Pricing starts from $795 for 25 servers or applications!
>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>
>>
>> _______________________________________________
>> Postfixadmin-devel mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>
>

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

From: Johan H. <Jo...@do...> - 2012-11-13 13:53:50

After that change i get the following.

So the line 88 looks like :
 if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {

[Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined variable: sth in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
[Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call to a member function execute() on a non-object in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/

gr
Johan


________________________________________
Van: Rudi Floren [rud...@go...]
Verzonden: dinsdag 13 november 2012 14:40
Aan: Johan Hendriks
CC: pos...@li...; Rudi Floren
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

the second = should be =>

Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
> That gives me the following error.
>
>   [error] [client 192.168.50.102] PHP Parse error:  syntax error, unexpected '=', expecting ')' in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
>
> line 88 is
>   if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>
> thanks
> gr
> Johan
> ________________________________________
> Van: Rudi Floren [rud...@go...]
> Verzonden: dinsdag 13 november 2012 14:33
> Aan: Johan Hendriks
> CC: pos...@li...; Christian Boltz
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> I think the problem is the salt.
>
> try this. its untested.
>
>
> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>> Using the same method that error is gone also :D
>>
>> Then i did get a method error on to64, but i solved that also.
>>
>> So everything seems to function.
>>
>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>
>> Then i log on to owncloud using my email adres with the new password set  through postfixadmin
>> In the mysql log i see the following:
>>
>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>
>> So it look much more like the password that is used, but stil no match.
>> If i look from within mysql itself i get.
>>
>> mysql> select password from mailbox where username = 'j.h...@te...';
>> +------------------------------------+
>> | password                           |
>> +------------------------------------+
>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>> +------------------------------------+
>> 1 row in set (0.00 sec)
>>
>>
>> The user_postfixadmin.php file is attached.
>>
>> Thanks you all for your time and patience with me!
>> regards
>> Johan
>>
>> ________________________________________
>> Van: Christian Boltz [pos...@cb...]
>> Verzonden: maandag 12 november 2012 21:31
>> Aan: pos...@li...
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database
>>
>> Hello,
>>
>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>> It does not work, the error i get is
>>> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
>>> error:  Call to undefined function create_salt() in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 147
>>>
>>> I saw in the postfixadmin function.inc.php file the following
>>>
>>>
>>> function create_salt () {
>>>       srand ((double) microtime ()*1000000);
>>>       $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>       return $salt;
>>> }
>>>
>>> So i thougt i add it at the end of the file, but i keep getting the
>>> error??
>>
>> You probably added the function inside the class, which means you need
>> to replace all calls of "create_salt" with
>> "OC_User_Postfixadmin::create_salt"
>>
>>
>> Regards,
>>
>> Christian Boltz
>> --
>> Der Tag hat 24 Stunden und wenn es sein muss,
>> dann arbeiten wir auch noch nachts!
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor your physical, virtual and cloud infrastructure from a single
>> web console. Get in-depth insight into apps, servers, databases, vmware,
>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>> Pricing starts from $795 for 25 servers or applications!
>> http://p.sf.net/sfu/zoho_dev2dev_nov
>> _______________________________________________
>> Postfixadmin-devel mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor your physical, virtual and cloud infrastructure from a single
>> web console. Get in-depth insight into apps, servers, databases, vmware,
>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>> Pricing starts from $795 for 25 servers or applications!
>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>
>>
>> _______________________________________________
>> Postfixadmin-devel mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>
>

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

From: Johan H. <Jo...@do...> - 2012-11-13 14:37:23

We are getting close :D

If i use the latest file i get the following.

[Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined index: mail in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 67, referer: http://192.168.50.200/owncloud/
[Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined index: username in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 94, referer: http://192.168.50.200/owncloud/

If i alter the code to 
#        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
        $sth = $this->db->prepare($sql);
        if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
            $row = $sth->fetch();
            if ($row) {
                    $this->setEmail($uid);
                    return $row['username'];

Then it works.
If i alter the code to 
        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
#        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
        $sth = $this->db->prepare($sql);
        if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
            $row = $sth->fetch();
            if ($row) {
                    $this->setEmail($uid);
                    return $row['password'];
Then it works also, except that my data directory is called $1$d7fc6e81$n8xTB.YOtAv0VmBvhy
So i guess that the return $row['password'] line gives owncloud the username to use

The problem is that it is not using the password field, i can use whatever password i want, owncloud will always let me in.

thanks

gr
johan



________________________________________
Van: Rudi Floren [rud...@go...]
Verzonden: dinsdag 13 november 2012 15:05
Aan: Johan Hendriks
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Am Dienstag, 13. November 2012 14:53:32 schrieb Johan Hendriks:
> After that change i get the following.
>
> So the line 88 looks like :
>   if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>
> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined variable: sth in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call to a member function execute() on a non-object in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
>
> gr
> Johan
>
>
> ________________________________________
> Van: Rudi Floren [rud...@go...]
> Verzonden: dinsdag 13 november 2012 14:40
> Aan: Johan Hendriks
> CC: pos...@li...; Rudi Floren
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> the second = should be =>
>
> Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
>> That gives me the following error.
>>
>>    [error] [client 192.168.50.102] PHP Parse error:  syntax error, unexpected '=', expecting ')' in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 88, referer: http://192.168.50.200/owncloud/
>>
>> line 88 is
>>    if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>>
>> thanks
>> gr
>> Johan
>> ________________________________________
>> Van: Rudi Floren [rud...@go...]
>> Verzonden: dinsdag 13 november 2012 14:33
>> Aan: Johan Hendriks
>> CC: pos...@li...; Christian Boltz
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>>
>> I think the problem is the salt.
>>
>> try this. its untested.
>>
>>
>> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>>> Using the same method that error is gone also :D
>>>
>>> Then i did get a method error on to64, but i solved that also.
>>>
>>> So everything seems to function.
>>>
>>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>>
>>> Then i log on to owncloud using my email adres with the new password set  through postfixadmin
>>> In the mysql log i see the following:
>>>
>>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>>
>>> So it look much more like the password that is used, but stil no match.
>>> If i look from within mysql itself i get.
>>>
>>> mysql> select password from mailbox where username = 'j.h...@te...';
>>> +------------------------------------+
>>> | password                           |
>>> +------------------------------------+
>>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>>> +------------------------------------+
>>> 1 row in set (0.00 sec)
>>>
>>>
>>> The user_postfixadmin.php file is attached.
>>>
>>> Thanks you all for your time and patience with me!
>>> regards
>>> Johan
>>>
>>> ________________________________________
>>> Van: Christian Boltz [pos...@cb...]
>>> Verzonden: maandag 12 november 2012 21:31
>>> Aan: pos...@li...
>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin  database
>>>
>>> Hello,
>>>
>>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>>> It does not work, the error i get is
>>>> [Fri Nov 09 09:32:00 2012] [error] [client 192.168.50.105] PHP Fatal
>>>> error:  Call to undefined function create_salt() in
>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>> on line 147
>>>>
>>>> I saw in the postfixadmin function.inc.php file the following
>>>>
>>>>
>>>> function create_salt () {
>>>>        srand ((double) microtime ()*1000000);
>>>>        $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>>        return $salt;
>>>> }
>>>>
>>>> So i thougt i add it at the end of the file, but i keep getting the
>>>> error??
>>>
>>> You probably added the function inside the class, which means you need
>>> to replace all calls of "create_salt" with
>>> "OC_User_Postfixadmin::create_salt"
>>>
>>>
>>> Regards,
>>>
>>> Christian Boltz
>>> --
>>> Der Tag hat 24 Stunden und wenn es sein muss,
>>> dann arbeiten wir auch noch nachts!
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Monitor your physical, virtual and cloud infrastructure from a single
>>> web console. Get in-depth insight into apps, servers, databases, vmware,
>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>>> Pricing starts from $795 for 25 servers or applications!
>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>> _______________________________________________
>>> Postfixadmin-devel mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Monitor your physical, virtual and cloud infrastructure from a single
>>> web console. Get in-depth insight into apps, servers, databases, vmware,
>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
>>> Pricing starts from $795 for 25 servers or applications!
>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>
>>>
>>> _______________________________________________
>>> Postfixadmin-devel mailing list
>>> Pos...@li...
>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>
>>
>
>

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

From: Johan H. <Jo...@do...> - 2012-11-14 07:52:28

No errors in the http-error.log file.
The login page returns the forgot password page!
So that is all working ok.

But still no login.

It gets the password field wrong.
In my mysql.log file i have this:

tail -f /var/log/mysql/mysql.log | grep hen
                18882 Query     SELECT `uid`, `password` FROM `oc_users` WHERE LOWER(`uid`) = LOWER('j.h...@te...')
                18883 Query     SELECT password FROM mailbox WHERE username = 'j.h...@te...' AND active = '1'
                18883 Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND active = '1' AND password = '$1$$1$d7fc6$1kExrEkwxej2AGTE2FqEo.'



From mysql itsel i got this:
mysql> select password from mailbox where username = 'j.h...@te...';
+------------------------------------+
| password                           |
+------------------------------------+
| $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
+------------------------------------+
1 row in set (0.00 sec)

mysql>


thanks again 

gr
Johan




-----Oorspronkelijk bericht-----
Van: Rudi Floren [mailto:rud...@go...] 
Verzonden: dinsdag 13 november 2012 17:58
Aan: Johan Hendriks
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Am Dienstag, 13. November 2012 15:37:05 schrieb Johan Hendriks:
> We are getting close :D
>
> If i use the latest file i get the following.
>
> [Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  
> Undefined index: mail in 
> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php 
> on line 67, referer: http://192.168.50.200/owncloud/ [Tue Nov 13 
> 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined 
> index: username in 
> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php 
> on line 94, referer: http://192.168.50.200/owncloud/
>
> If i alter the code to
> #        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>          $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>          $sth = $this->db->prepare($sql);
>          if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>              $row = $sth->fetch();
>              if ($row) {
>                      $this->setEmail($uid);
>                      return $row['username'];
>
> Then it works.
> If i alter the code to
>          $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
> #        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>          $sth = $this->db->prepare($sql);
>          if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>              $row = $sth->fetch();
>              if ($row) {
>                      $this->setEmail($uid);
>                      return $row['password']; Then it works also, 
> except that my data directory is called $1$d7fc6e81$n8xTB.YOtAv0VmBvhy 
> So i guess that the return $row['password'] line gives owncloud the 
> username to use
>
> The problem is that it is not using the password field, i can use whatever password i want, owncloud will always let me in.
>
> thanks
>
> gr
> johan
>
>
>
> ________________________________________
> Van: Rudi Floren [rud...@go...]
> Verzonden: dinsdag 13 november 2012 15:05
> Aan: Johan Hendriks
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against 
> postfixadmin database
>
> Am Dienstag, 13. November 2012 14:53:32 schrieb Johan Hendriks:
>> After that change i get the following.
>>
>> So the line 88 looks like :
>>    if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>
>> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP 
>> Notice:  Undefined variable: sth in 
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php 
>> on line 88, referer: http://192.168.50.200/owncloud/ [Tue Nov 13 
>> 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call 
>> to a member function execute() on a non-object in 
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php 
>> on line 88, referer: http://192.168.50.200/owncloud/
>>
>> gr
>> Johan
>>
>>
>> ________________________________________
>> Van: Rudi Floren [rud...@go...]
>> Verzonden: dinsdag 13 november 2012 14:40
>> Aan: Johan Hendriks
>> CC: pos...@li...; Rudi Floren
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against 
>> postfixadmin database
>>
>> the second = should be =>
>>
>> Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
>>> That gives me the following error.
>>>
>>>     [error] [client 192.168.50.102] PHP Parse error:  syntax error, 
>>> unexpected '=', expecting ')' in 
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php 
>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>
>>> line 88 is
>>>     if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>>>
>>> thanks
>>> gr
>>> Johan
>>> ________________________________________
>>> Van: Rudi Floren [rud...@go...]
>>> Verzonden: dinsdag 13 november 2012 14:33
>>> Aan: Johan Hendriks
>>> CC: pos...@li...; Christian Boltz
>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against 
>>> postfixadmin database
>>>
>>> I think the problem is the salt.
>>>
>>> try this. its untested.
>>>
>>>
>>> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>>>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>>>> Using the same method that error is gone also :D
>>>>
>>>> Then i did get a method error on to64, but i solved that also.
>>>>
>>>> So everything seems to function.
>>>>
>>>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>>>
>>>> Then i log on to owncloud using my email adres with the new 
>>>> password set  through postfixadmin In the mysql log i see the following:
>>>>
>>>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>>>
>>>> So it look much more like the password that is used, but stil no match.
>>>> If i look from within mysql itself i get.
>>>>
>>>> mysql> select password from mailbox where username = 
>>>> mysql> 'j.h...@te...';
>>>> +------------------------------------+
>>>> | password                           |
>>>> +------------------------------------+
>>>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>>>> +------------------------------------+
>>>> 1 row in set (0.00 sec)
>>>>
>>>>
>>>> The user_postfixadmin.php file is attached.
>>>>
>>>> Thanks you all for your time and patience with me!
>>>> regards
>>>> Johan
>>>>
>>>> ________________________________________
>>>> Van: Christian Boltz [pos...@cb...]
>>>> Verzonden: maandag 12 november 2012 21:31
>>>> Aan: pos...@li...
>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against 
>>>> postfixadmin  database
>>>>
>>>> Hello,
>>>>
>>>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>>>> It does not work, the error i get is [Fri Nov 09 09:32:00 2012] 
>>>>> [error] [client 192.168.50.105] PHP Fatal
>>>>> error:  Call to undefined function create_salt() in 
>>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.p
>>>>> hp
>>>>> on line 147
>>>>>
>>>>> I saw in the postfixadmin function.inc.php file the following
>>>>>
>>>>>
>>>>> function create_salt () {
>>>>>         srand ((double) microtime ()*1000000);
>>>>>         $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>>>         return $salt;
>>>>> }
>>>>>
>>>>> So i thougt i add it at the end of the file, but i keep getting 
>>>>> the error??
>>>>
>>>> You probably added the function inside the class, which means you 
>>>> need to replace all calls of "create_salt" with 
>>>> "OC_User_Postfixadmin::create_salt"
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Christian Boltz
>>>> --
>>>> Der Tag hat 24 Stunden und wenn es sein muss, dann arbeiten wir 
>>>> auch noch nachts!
>>>>
>>>>
>>>> -------------------------------------------------------------------
>>>> ----------- Monitor your physical, virtual and cloud infrastructure 
>>>> from a single web console. Get in-depth insight into apps, servers, 
>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day 
>>>> Free Trial.
>>>> Pricing starts from $795 for 25 servers or applications!
>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>> _______________________________________________
>>>> Postfixadmin-devel mailing list
>>>> Pos...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>
>>>>
>>>> -------------------------------------------------------------------
>>>> ----------- Monitor your physical, virtual and cloud infrastructure 
>>>> from a single web console. Get in-depth insight into apps, servers, 
>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day 
>>>> Free Trial.
>>>> Pricing starts from $795 for 25 servers or applications!
>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>
>>>>
>>>> _______________________________________________
>>>> Postfixadmin-devel mailing list
>>>> Pos...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>
>>>
>>
>>
>
>

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

From: Rudi F. <rud...@go...> - 2012-11-14 10:59:24

Attachments: user_postfixadmin.php

Now it should work. :)


Am Mittwoch, 14. November 2012 08:52:09 schrieb Johan Hendriks:
> No errors in the http-error.log file.
> The login page returns the forgot password page!
> So that is all working ok.
>
> But still no login.
>
> It gets the password field wrong.
> In my mysql.log file i have this:
>
> tail -f /var/log/mysql/mysql.log | grep hen
>                  18882 Query     SELECT `uid`, `password` FROM `oc_users` WHERE LOWER(`uid`) = LOWER('j.h...@te...')
>                  18883 Query     SELECT password FROM mailbox WHERE username = 'j.h...@te...' AND active = '1'
>                  18883 Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND active = '1' AND password = '$1$$1$d7fc6$1kExrEkwxej2AGTE2FqEo.'
>
>
>
>  From mysql itsel i got this:
> mysql> select password from mailbox where username = 'j.h...@te...';
> +------------------------------------+
> | password                           |
> +------------------------------------+
> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
> +------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
>
> thanks again
>
> gr
> Johan
>
>
>
>
> -----Oorspronkelijk bericht-----
> Van: Rudi Floren [mailto:rud...@go...]
> Verzonden: dinsdag 13 november 2012 17:58
> Aan: Johan Hendriks
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> Am Dienstag, 13. November 2012 15:37:05 schrieb Johan Hendriks:
>> We are getting close :D
>>
>> If i use the latest file i get the following.
>>
>> [Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:
>> Undefined index: mail in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 67, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>> 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined
>> index: username in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 94, referer: http://192.168.50.200/owncloud/
>>
>> If i alter the code to
>> #        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>>           $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>           $sth = $this->db->prepare($sql);
>>           if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>               $row = $sth->fetch();
>>               if ($row) {
>>                       $this->setEmail($uid);
>>                       return $row['username'];
>>
>> Then it works.
>> If i alter the code to
>>           $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>> #        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>           $sth = $this->db->prepare($sql);
>>           if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>               $row = $sth->fetch();
>>               if ($row) {
>>                       $this->setEmail($uid);
>>                       return $row['password']; Then it works also,
>> except that my data directory is called $1$d7fc6e81$n8xTB.YOtAv0VmBvhy
>> So i guess that the return $row['password'] line gives owncloud the
>> username to use
>>
>> The problem is that it is not using the password field, i can use whatever password i want, owncloud will always let me in.
>>
>> thanks
>>
>> gr
>> johan
>>
>>
>>
>> ________________________________________
>> Van: Rudi Floren [rud...@go...]
>> Verzonden: dinsdag 13 november 2012 15:05
>> Aan: Johan Hendriks
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>> postfixadmin database
>>
>> Am Dienstag, 13. November 2012 14:53:32 schrieb Johan Hendriks:
>>> After that change i get the following.
>>>
>>> So the line 88 looks like :
>>>     if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>>
>>> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP
>>> Notice:  Undefined variable: sth in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 88, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>>> 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call
>>> to a member function execute() on a non-object in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>
>>> gr
>>> Johan
>>>
>>>
>>> ________________________________________
>>> Van: Rudi Floren [rud...@go...]
>>> Verzonden: dinsdag 13 november 2012 14:40
>>> Aan: Johan Hendriks
>>> CC: pos...@li...; Rudi Floren
>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>> postfixadmin database
>>>
>>> the second = should be =>
>>>
>>> Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
>>>> That gives me the following error.
>>>>
>>>>      [error] [client 192.168.50.102] PHP Parse error:  syntax error,
>>>> unexpected '=', expecting ')' in
>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>>
>>>> line 88 is
>>>>      if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>>>>
>>>> thanks
>>>> gr
>>>> Johan
>>>> ________________________________________
>>>> Van: Rudi Floren [rud...@go...]
>>>> Verzonden: dinsdag 13 november 2012 14:33
>>>> Aan: Johan Hendriks
>>>> CC: pos...@li...; Christian Boltz
>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>> postfixadmin database
>>>>
>>>> I think the problem is the salt.
>>>>
>>>> try this. its untested.
>>>>
>>>>
>>>> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>>>>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>>>>> Using the same method that error is gone also :D
>>>>>
>>>>> Then i did get a method error on to64, but i solved that also.
>>>>>
>>>>> So everything seems to function.
>>>>>
>>>>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>>>>
>>>>> Then i log on to owncloud using my email adres with the new
>>>>> password set  through postfixadmin In the mysql log i see the following:
>>>>>
>>>>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>>>>
>>>>> So it look much more like the password that is used, but stil no match.
>>>>> If i look from within mysql itself i get.
>>>>>
>>>>> mysql> select password from mailbox where username =
>>>>> mysql> 'j.h...@te...';
>>>>> +------------------------------------+
>>>>> | password                           |
>>>>> +------------------------------------+
>>>>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>>>>> +------------------------------------+
>>>>> 1 row in set (0.00 sec)
>>>>>
>>>>>
>>>>> The user_postfixadmin.php file is attached.
>>>>>
>>>>> Thanks you all for your time and patience with me!
>>>>> regards
>>>>> Johan
>>>>>
>>>>> ________________________________________
>>>>> Van: Christian Boltz [pos...@cb...]
>>>>> Verzonden: maandag 12 november 2012 21:31
>>>>> Aan: pos...@li...
>>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>>> postfixadmin  database
>>>>>
>>>>> Hello,
>>>>>
>>>>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>>>>> It does not work, the error i get is [Fri Nov 09 09:32:00 2012]
>>>>>> [error] [client 192.168.50.105] PHP Fatal
>>>>>> error:  Call to undefined function create_salt() in
>>>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.p
>>>>>> hp
>>>>>> on line 147
>>>>>>
>>>>>> I saw in the postfixadmin function.inc.php file the following
>>>>>>
>>>>>>
>>>>>> function create_salt () {
>>>>>>          srand ((double) microtime ()*1000000);
>>>>>>          $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>>>>          return $salt;
>>>>>> }
>>>>>>
>>>>>> So i thougt i add it at the end of the file, but i keep getting
>>>>>> the error??
>>>>>
>>>>> You probably added the function inside the class, which means you
>>>>> need to replace all calls of "create_salt" with
>>>>> "OC_User_Postfixadmin::create_salt"
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> Christian Boltz
>>>>> --
>>>>> Der Tag hat 24 Stunden und wenn es sein muss, dann arbeiten wir
>>>>> auch noch nachts!
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>> Free Trial.
>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>> _______________________________________________
>>>>> Postfixadmin-devel mailing list
>>>>> Pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>> Free Trial.
>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Postfixadmin-devel mailing list
>>>>> Pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>
>>>>
>>>
>>>
>>
>>
>
>

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

From: Johan H. <Jo...@do...> - 2012-11-14 11:20:07

At first it did not, but the error log did show me an error on line 98
$pw = OC_User_Postfixadmin::md5crypt ($password, salt);

i did replace salt with $salt, and now i can log in using my postfixadmin credentials.
If i give a wrong password it deny's me access.

thank you very much, i feel a little quilty taking up so much of your time

one thing i do see is the following.


[Wed Nov 14 12:14:49 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined index: mail in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 67, referer: http://localhost/owncloud/

thank you very much again.

gr
Johan




-----Oorspronkelijk bericht-----
Van: Rudi Floren [mailto:rud...@go...] 
Verzonden: woensdag 14 november 2012 11:59
Aan: Johan Hendriks
CC: pos...@li...; Rudi Floren
Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database

Now it should work. :)


Am Mittwoch, 14. November 2012 08:52:09 schrieb Johan Hendriks:
> No errors in the http-error.log file.
> The login page returns the forgot password page!
> So that is all working ok.
>
> But still no login.
>
> It gets the password field wrong.
> In my mysql.log file i have this:
>
> tail -f /var/log/mysql/mysql.log | grep hen
>                  18882 Query     SELECT `uid`, `password` FROM `oc_users` WHERE LOWER(`uid`) = LOWER('j.h...@te...')
>                  18883 Query     SELECT password FROM mailbox WHERE username = 'j.h...@te...' AND active = '1'
>                  18883 Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND active = '1' AND password = '$1$$1$d7fc6$1kExrEkwxej2AGTE2FqEo.'
>
>
>
>  From mysql itsel i got this:
> mysql> select password from mailbox where username = 'j.h...@te...';
> +------------------------------------+
> | password                           |
> +------------------------------------+
> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
> +------------------------------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
>
> thanks again
>
> gr
> Johan
>
>
>
>
> -----Oorspronkelijk bericht-----
> Van: Rudi Floren [mailto:rud...@go...]
> Verzonden: dinsdag 13 november 2012 17:58
> Aan: Johan Hendriks
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> Am Dienstag, 13. November 2012 15:37:05 schrieb Johan Hendriks:
>> We are getting close :D
>>
>> If i use the latest file i get the following.
>>
>> [Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:
>> Undefined index: mail in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 67, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>> 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined
>> index: username in
>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>> on line 94, referer: http://192.168.50.200/owncloud/
>>
>> If i alter the code to
>> #        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>>           $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>           $sth = $this->db->prepare($sql);
>>           if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>               $row = $sth->fetch();
>>               if ($row) {
>>                       $this->setEmail($uid);
>>                       return $row['username'];
>>
>> Then it works.
>> If i alter the code to
>>           $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>> #        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>           $sth = $this->db->prepare($sql);
>>           if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>               $row = $sth->fetch();
>>               if ($row) {
>>                       $this->setEmail($uid);
>>                       return $row['password']; Then it works also,
>> except that my data directory is called $1$d7fc6e81$n8xTB.YOtAv0VmBvhy
>> So i guess that the return $row['password'] line gives owncloud the
>> username to use
>>
>> The problem is that it is not using the password field, i can use whatever password i want, owncloud will always let me in.
>>
>> thanks
>>
>> gr
>> johan
>>
>>
>>
>> ________________________________________
>> Van: Rudi Floren [rud...@go...]
>> Verzonden: dinsdag 13 november 2012 15:05
>> Aan: Johan Hendriks
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>> postfixadmin database
>>
>> Am Dienstag, 13. November 2012 14:53:32 schrieb Johan Hendriks:
>>> After that change i get the following.
>>>
>>> So the line 88 looks like :
>>>     if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>>
>>> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP
>>> Notice:  Undefined variable: sth in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 88, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>>> 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call
>>> to a member function execute() on a non-object in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>
>>> gr
>>> Johan
>>>
>>>
>>> ________________________________________
>>> Van: Rudi Floren [rud...@go...]
>>> Verzonden: dinsdag 13 november 2012 14:40
>>> Aan: Johan Hendriks
>>> CC: pos...@li...; Rudi Floren
>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>> postfixadmin database
>>>
>>> the second = should be =>
>>>
>>> Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
>>>> That gives me the following error.
>>>>
>>>>      [error] [client 192.168.50.102] PHP Parse error:  syntax error,
>>>> unexpected '=', expecting ')' in
>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>>
>>>> line 88 is
>>>>      if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>>>>
>>>> thanks
>>>> gr
>>>> Johan
>>>> ________________________________________
>>>> Van: Rudi Floren [rud...@go...]
>>>> Verzonden: dinsdag 13 november 2012 14:33
>>>> Aan: Johan Hendriks
>>>> CC: pos...@li...; Christian Boltz
>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>> postfixadmin database
>>>>
>>>> I think the problem is the salt.
>>>>
>>>> try this. its untested.
>>>>
>>>>
>>>> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>>>>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>>>>> Using the same method that error is gone also :D
>>>>>
>>>>> Then i did get a method error on to64, but i solved that also.
>>>>>
>>>>> So everything seems to function.
>>>>>
>>>>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>>>>
>>>>> Then i log on to owncloud using my email adres with the new
>>>>> password set  through postfixadmin In the mysql log i see the following:
>>>>>
>>>>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>>>>
>>>>> So it look much more like the password that is used, but stil no match.
>>>>> If i look from within mysql itself i get.
>>>>>
>>>>> mysql> select password from mailbox where username =
>>>>> mysql> 'j.h...@te...';
>>>>> +------------------------------------+
>>>>> | password                           |
>>>>> +------------------------------------+
>>>>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>>>>> +------------------------------------+
>>>>> 1 row in set (0.00 sec)
>>>>>
>>>>>
>>>>> The user_postfixadmin.php file is attached.
>>>>>
>>>>> Thanks you all for your time and patience with me!
>>>>> regards
>>>>> Johan
>>>>>
>>>>> ________________________________________
>>>>> Van: Christian Boltz [pos...@cb...]
>>>>> Verzonden: maandag 12 november 2012 21:31
>>>>> Aan: pos...@li...
>>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>>> postfixadmin  database
>>>>>
>>>>> Hello,
>>>>>
>>>>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>>>>> It does not work, the error i get is [Fri Nov 09 09:32:00 2012]
>>>>>> [error] [client 192.168.50.105] PHP Fatal
>>>>>> error:  Call to undefined function create_salt() in
>>>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.p
>>>>>> hp
>>>>>> on line 147
>>>>>>
>>>>>> I saw in the postfixadmin function.inc.php file the following
>>>>>>
>>>>>>
>>>>>> function create_salt () {
>>>>>>          srand ((double) microtime ()*1000000);
>>>>>>          $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>>>>          return $salt;
>>>>>> }
>>>>>>
>>>>>> So i thougt i add it at the end of the file, but i keep getting
>>>>>> the error??
>>>>>
>>>>> You probably added the function inside the class, which means you
>>>>> need to replace all calls of "create_salt" with
>>>>> "OC_User_Postfixadmin::create_salt"
>>>>>
>>>>>
>>>>> Regards,
>>>>>
>>>>> Christian Boltz
>>>>> --
>>>>> Der Tag hat 24 Stunden und wenn es sein muss, dann arbeiten wir
>>>>> auch noch nachts!
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>> Free Trial.
>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>> _______________________________________________
>>>>> Postfixadmin-devel mailing list
>>>>> Pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>>
>>>>>
>>>>> -------------------------------------------------------------------
>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>> Free Trial.
>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Postfixadmin-devel mailing list
>>>>> Pos...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>
>>>>
>>>
>>>
>>
>>
>
>

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

From: Rudi F. <rud...@go...> - 2012-11-14 11:22:01

Attachments: user_postfixadmin.php

Am Mittwoch, 14. November 2012 12:19:53 schrieb Johan Hendriks:
> At first it did not, but the error log did show me an error on line 98
> $pw = OC_User_Postfixadmin::md5crypt ($password, salt);
>
> i did replace salt with $salt, and now i can log in using my postfixadmin credentials.
> If i give a wrong password it deny's me access.
>
> thank you very much, i feel a little quilty taking up so much of your time
>
> one thing i do see is the following.
>
>
> [Wed Nov 14 12:14:49 2012] [error] [client 127.0.0.1] PHP Notice:  Undefined index: mail in /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php on line 67, referer: http://localhost/owncloud/
>
> thank you very much again.
>
> gr
> Johan
>
>
>
>
> -----Oorspronkelijk bericht-----
> Van: Rudi Floren [mailto:rud...@go...]
> Verzonden: woensdag 14 november 2012 11:59
> Aan: Johan Hendriks
> CC: pos...@li...; Rudi Floren
> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>
> Now it should work. :)
>
>
> Am Mittwoch, 14. November 2012 08:52:09 schrieb Johan Hendriks:
>> No errors in the http-error.log file.
>> The login page returns the forgot password page!
>> So that is all working ok.
>>
>> But still no login.
>>
>> It gets the password field wrong.
>> In my mysql.log file i have this:
>>
>> tail -f /var/log/mysql/mysql.log | grep hen
>>                   18882 Query     SELECT `uid`, `password` FROM `oc_users` WHERE LOWER(`uid`) = LOWER('j.h...@te...')
>>                   18883 Query     SELECT password FROM mailbox WHERE username = 'j.h...@te...' AND active = '1'
>>                   18883 Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND active = '1' AND password = '$1$$1$d7fc6$1kExrEkwxej2AGTE2FqEo.'
>>
>>
>>
>>   From mysql itsel i got this:
>> mysql> select password from mailbox where username = 'j.h...@te...';
>> +------------------------------------+
>> | password                           |
>> +------------------------------------+
>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>> +------------------------------------+
>> 1 row in set (0.00 sec)
>>
>> mysql>
>>
>>
>> thanks again
>>
>> gr
>> Johan
>>
>>
>>
>>
>> -----Oorspronkelijk bericht-----
>> Van: Rudi Floren [mailto:rud...@go...]
>> Verzonden: dinsdag 13 november 2012 17:58
>> Aan: Johan Hendriks
>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against postfixadmin database
>>
>> Am Dienstag, 13. November 2012 15:37:05 schrieb Johan Hendriks:
>>> We are getting close :D
>>>
>>> If i use the latest file i get the following.
>>>
>>> [Tue Nov 13 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:
>>> Undefined index: mail in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 67, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>>> 15:29:15 2012] [error] [client 192.168.50.102] PHP Notice:  Undefined
>>> index: username in
>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>> on line 94, referer: http://192.168.50.200/owncloud/
>>>
>>> If i alter the code to
>>> #        $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>>>            $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>>            $sth = $this->db->prepare($sql);
>>>            if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>>                $row = $sth->fetch();
>>>                if ($row) {
>>>                        $this->setEmail($uid);
>>>                        return $row['username'];
>>>
>>> Then it works.
>>> If i alter the code to
>>>            $sql = 'SELECT password FROM mailbox WHERE username = :uid AND active = :active';
>>> #        $sql = 'SELECT username FROM mailbox WHERE username = :uid AND active = :active';
>>>            $sth = $this->db->prepare($sql);
>>>            if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>>                $row = $sth->fetch();
>>>                if ($row) {
>>>                        $this->setEmail($uid);
>>>                        return $row['password']; Then it works also,
>>> except that my data directory is called $1$d7fc6e81$n8xTB.YOtAv0VmBvhy
>>> So i guess that the return $row['password'] line gives owncloud the
>>> username to use
>>>
>>> The problem is that it is not using the password field, i can use whatever password i want, owncloud will always let me in.
>>>
>>> thanks
>>>
>>> gr
>>> johan
>>>
>>>
>>>
>>> ________________________________________
>>> Van: Rudi Floren [rud...@go...]
>>> Verzonden: dinsdag 13 november 2012 15:05
>>> Aan: Johan Hendriks
>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>> postfixadmin database
>>>
>>> Am Dienstag, 13. November 2012 14:53:32 schrieb Johan Hendriks:
>>>> After that change i get the following.
>>>>
>>>> So the line 88 looks like :
>>>>      if ($sth->execute(array(':uid' => $uid, ':active' => 1))) {
>>>>
>>>> [Tue Nov 13 14:50:49 2012] [error] [client 192.168.50.102] PHP
>>>> Notice:  Undefined variable: sth in
>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>> on line 88, referer: http://192.168.50.200/owncloud/ [Tue Nov 13
>>>> 14:50:49 2012] [error] [client 192.168.50.102] PHP Fatal error:  Call
>>>> to a member function execute() on a non-object in
>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>>
>>>> gr
>>>> Johan
>>>>
>>>>
>>>> ________________________________________
>>>> Van: Rudi Floren [rud...@go...]
>>>> Verzonden: dinsdag 13 november 2012 14:40
>>>> Aan: Johan Hendriks
>>>> CC: pos...@li...; Rudi Floren
>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>> postfixadmin database
>>>>
>>>> the second = should be =>
>>>>
>>>> Am Dienstag, 13. November 2012 14:39:50 schrieb Johan Hendriks:
>>>>> That gives me the following error.
>>>>>
>>>>>       [error] [client 192.168.50.102] PHP Parse error:  syntax error,
>>>>> unexpected '=', expecting ')' in
>>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.php
>>>>> on line 88, referer: http://192.168.50.200/owncloud/
>>>>>
>>>>> line 88 is
>>>>>       if ($sth->execute(array(':uid' => $uid, ':active' = 1))) {
>>>>>
>>>>> thanks
>>>>> gr
>>>>> Johan
>>>>> ________________________________________
>>>>> Van: Rudi Floren [rud...@go...]
>>>>> Verzonden: dinsdag 13 november 2012 14:33
>>>>> Aan: Johan Hendriks
>>>>> CC: pos...@li...; Christian Boltz
>>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>>> postfixadmin database
>>>>>
>>>>> I think the problem is the salt.
>>>>>
>>>>> try this. its untested.
>>>>>
>>>>>
>>>>> Am Dienstag, 13. November 2012 14:19:14 schrieb Johan Hendriks:
>>>>>> Thank you, that error is gone now, after that i got the same error on the hex2bin function.
>>>>>> Using the same method that error is gone also :D
>>>>>>
>>>>>> Then i did get a method error on to64, but i solved that also.
>>>>>>
>>>>>> So everything seems to function.
>>>>>>
>>>>>> I set the encrypt to md5crypt in postfixadmin, and reset the password for the test user.
>>>>>>
>>>>>> Then i log on to owncloud using my email adres with the new
>>>>>> password set  through postfixadmin In the mysql log i see the following:
>>>>>>
>>>>>> Query     SELECT username FROM mailbox WHERE username = 'j.h...@te...' AND password = '$1$6be349d6$tckNf.G6.uv2DqWG1XlpL0'
>>>>>>
>>>>>> So it look much more like the password that is used, but stil no match.
>>>>>> If i look from within mysql itself i get.
>>>>>>
>>>>>> mysql> select password from mailbox where username =
>>>>>> mysql> 'j.h...@te...';
>>>>>> +------------------------------------+
>>>>>> | password                           |
>>>>>> +------------------------------------+
>>>>>> | $1$d7fc6e81$n8xTB.YOtAv0VmBvhy/Xv0 |
>>>>>> +------------------------------------+
>>>>>> 1 row in set (0.00 sec)
>>>>>>
>>>>>>
>>>>>> The user_postfixadmin.php file is attached.
>>>>>>
>>>>>> Thanks you all for your time and patience with me!
>>>>>> regards
>>>>>> Johan
>>>>>>
>>>>>> ________________________________________
>>>>>> Van: Christian Boltz [pos...@cb...]
>>>>>> Verzonden: maandag 12 november 2012 21:31
>>>>>> Aan: pos...@li...
>>>>>> Onderwerp: Re: [Postfixadmin-devel] Owncloud Authenticate against
>>>>>> postfixadmin  database
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> Am Freitag, 9. November 2012 schrieb Johan Hendriks:
>>>>>>> It does not work, the error i get is [Fri Nov 09 09:32:00 2012]
>>>>>>> [error] [client 192.168.50.105] PHP Fatal
>>>>>>> error:  Call to undefined function create_salt() in
>>>>>>> /usr/local/www/owncloud/apps/user_postfixadmin/user_postfixadmin.p
>>>>>>> hp
>>>>>>> on line 147
>>>>>>>
>>>>>>> I saw in the postfixadmin function.inc.php file the following
>>>>>>>
>>>>>>>
>>>>>>> function create_salt () {
>>>>>>>           srand ((double) microtime ()*1000000);
>>>>>>>           $salt = substr (md5 (rand (0,9999999)), 0, 8);
>>>>>>>           return $salt;
>>>>>>> }
>>>>>>>
>>>>>>> So i thougt i add it at the end of the file, but i keep getting
>>>>>>> the error??
>>>>>>
>>>>>> You probably added the function inside the class, which means you
>>>>>> need to replace all calls of "create_salt" with
>>>>>> "OC_User_Postfixadmin::create_salt"
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Christian Boltz
>>>>>> --
>>>>>> Der Tag hat 24 Stunden und wenn es sein muss, dann arbeiten wir
>>>>>> auch noch nachts!
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------------------
>>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>>> Free Trial.
>>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>>> _______________________________________________
>>>>>> Postfixadmin-devel mailing list
>>>>>> Pos...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------------------
>>>>>> ----------- Monitor your physical, virtual and cloud infrastructure
>>>>>> from a single web console. Get in-depth insight into apps, servers,
>>>>>> databases, vmware, SAP, cloud infrastructure, etc. Download 30-day
>>>>>> Free Trial.
>>>>>> Pricing starts from $795 for 25 servers or applications!
>>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Postfixadmin-devel mailing list
>>>>>> Pos...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/postfixadmin-devel
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>