[sork] sork Digest, Vol 760, Issue 1

[Roger Howorth]

On 29 Feb 2012, at 12:00, sork-request at lists.horde.org wrote:

> Send sork mailing list submissions to
> 	sork at lists.horde.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.horde.org/mailman/listinfo/sork
> or, via email, send a message with subject or body 'help' to
> 	sork-request at lists.horde.org
> 
> You can reach the person managing the list at
> 	sork-owner at lists.horde.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of sork digest..."
> 
> 
> Today's Topics:
> 
>   1. SQL backend problem (Roger Howorth)
>   2. Re: SQL backend problem (Ralf Lang)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 29 Feb 2012 11:43:33 +0000
> From: Roger Howorth <roger at rogerh.com>
> To: sork at lists.horde.org
> Subject: [sork] SQL backend problem
> Message-ID: <E7C70B38-628E-491E-B976-1FC651E97EC6 at rogerh.com>
> Content-Type: text/plain; charset=us-ascii
> 
> I've done a fresh install of Passwd H4 (4.0.1) using Pear. 
> 
> I'm getting the following errors in my log: 
> 
> Feb 28 22:35:45 schee HORDE: [passwd] PHP ERROR: Undefined index: 
> encryption [pid 12702 on line 136 of 
> "/var/www/horde-oct/passwd/config/backends.php"] 
> Feb 28 22:35:45 schee HORDE: [passwd] PHP ERROR: Undefined index: db 
> [pid 12702 on line 92 of 
> "/var/www/horde-oct/passwd/lib/Factory/Driver.php"] 
> 
> I can fix the 'db' index error by changing the index 'database' to 'db' 
> in my passwd/config/backends.local.php, but can't seem to deal with the 
> encryption index problem. 
> 
> Grateful for any other input on this. 
> 
> -Roger
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 29 Feb 2012 12:53:58 +0100
> From: Ralf Lang <lang at b1-systems.de>
> To: sork at lists.horde.org
> Subject: Re: [sork] SQL backend problem
> Message-ID: <4F4E11D6.5050805 at b1-systems.de>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Am 29.02.2012 12:43, schrieb Roger Howorth:
>> I've done a fresh install of Passwd H4 (4.0.1) using Pear.
>> 
>> I'm getting the following errors in my log:
>> 
>> Feb 28 22:35:45 schee HORDE: [passwd] PHP ERROR: Undefined index: 
>> encryption [pid 12702 on line 136 of 
>> "/var/www/horde-oct/passwd/config/backends.php"] Feb 28 22:35:45
>> schee HORDE: [passwd] PHP ERROR: Undefined index: db [pid 12702 on
>> line 92 of "/var/www/horde-oct/passwd/lib/Factory/Driver.php"]
>> 
>> I can fix the 'db' index error by changing the index 'database' to
>> 'db' in my passwd/config/backends.local.php, but can't seem to deal
>> with the encryption index problem.
>> 
>> Grateful for any other input on this.
>> 
>> -Roger
> $db is actually the database driver object. You should not set that
> parameter manually. Can you send your backends.local.php and your
> exact version of Passwd?
> 
> If you authenticate horde 4 via SQL, you probably want to use the
> "Horde" driver instead of the SQL driver.
> 
> - -- 
> Ralf Lang
> Linux Consultant / Developer
> Tel.: +49-170-6381563
> Mail: lang at b1-systems.de
> 
> B1 Systems GmbH
> Osterfeldstra?e 7 / 85088 Vohburg / http://www.b1-systems.de
> GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.18 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
> 
> iEYEARECAAYFAk9OEdYACgkQCs1dsHJ/X7DdrQCeJ2BZX7bSeA7yELA5xo+Sh6nk
> O7UAn1c/JQ7ej2ok23Op8D4K5J1Ng4YH
> =L0zu
> -----END PGP SIGNATURE-----
> 
> 
> ------------------------------
> 
> -- 
> Sork mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: sork-unsubscribe at lists.horde.org
> 
> 
> End of sork Digest, Vol 760, Issue 1
> ************************************
Thanks for your reply.

The version of passwd is 4.0.1 - or is there another version number you need, if so,pls explain.

Normally my users login using Horde IMAP authentication, but my IMAP server uses a SQL backend and my imap server doesn't support password changes, so for Horde passwd I need to modify the SQL database directly - presumably using the mysql module for this is correct?

-Roger.

backend.local.php
<?php

$backends['hordesql'] = array (
    'disabled' => true,
);


$backends['sql'] = array (
    'disabled' => false,
    'name' => 'SQL Server',
    'preferred' => '',
    'policy' => array(
        'minLength' => 5,
        'minNumeric' => 1,
    ),
    'driver' => 'Sql',
    'params' => array(
        'phptype' => 'mysql',
        'hostspec' => 'localhost',
        'username' => 'mail',
        'password' => '***********',
        'encryption' => 'plain',
        'database' => 'mail',
        'table' => 'users',
        'user_col' => 'email',
        'pass_col' => 'clear',
        'show_encryption' => false,
        // The following two settings allow you to specify custom queries for
        // lookup and modify functions if special functions need to be
        // performed.  In places where a username or a password needs to be
        // used, refer to this placeholder reference:
        //    %d -> gets substituted with the domain
        //    %u -> gets substituted with the user
        //    %U -> gets substituted with the user without a domain part
        //    %p -> gets substituted with the plaintext password
        //    %e -> gets substituted with the encrypted password
        //
       //  'query_lookup' => 'SELECT clear FROM users WHERE email= %u',
       //  'query_modify' => 'UPDATE users SET clear= %p WHERE email= %u',
    ),
);

?>