[sork] backends.local.php not obeyed.

[Simon Brereton]

On 8 November 2011 14:56, Simon Brereton <simon.brereton at buongiorno.com> wrote:
> On 8 November 2011 13:37, Simon Brereton <simon.brereton at buongiorno.com> wrote:
>> On 8 November 2011 11:17, Ralf Lang <lang at b1-systems.de> wrote:
>>> Am Dienstag, 8. November 2011, 16:22:00 schrieb Simon Brereton:
>>>> On 8 November 2011 09:37, Ralf Lang <lang at b1-systems.de> wrote:
>>>> > Am Dienstag, 8. November 2011, 15:31:12 schrieb Simon Brereton:
>>>> >> On 2 November 2011 15:18, Simon Brereton
>>>> >> <simon.brereton at buongiorno.com>
>>>> >>
>>>> >> wrote:
>>>> >> > On 2 November 2011 15:03, Simon Brereton
>>>> >> > <simon.brereton at buongiorno.com>
>>>> >> >
>>>> >> > wrote:
>>
>>>> >> > "/usr/share/horde4/passwd/config/backends.php"]
>>>> >> >
>>>> >> >
>>>> >> >
>>>> >> > 116 $backends['hordesql'] = array (
>>>> >> > 117     'disabled' => false,
>>>> >> > 118     'name' => 'Horde SQL Authentication',
>>>> >> > 119     'preferred' => '',
>>>> >> > 120     'policy' => array(
>>>> >> > 121         'minLength' => 6,
>>>> >> > 122         'minNumeric' => 1,
>>>> >> > 123     ),
>>>> >> > 124     'driver' => 'Sql',
>>>> >> > 125     'params' => array_merge(
>>>> >> > 126         $GLOBALS['conf']['sql'],
>>>> >> > 127         array('table' => 'horde_users',
>>>> >> > 128               'user_col' => 'user_uid',
>>>> >> > 129               'pass_col' => 'user_pass',
>>>> >> > 130               'show_encryption' => false,
>>>> >> > 131               'encryption' =>
>>>> >> > $GLOBALS['conf']['auth']['params']['encryption'])
>>>> >> > 132     ),
>>>> >> > 133 );
>>>> >> >
>>>> >> >
>>>> >> > I haven't touched anything in backends.php
>>>> >>
>>>> >> Anyone got anything to add before I have another go at this?
>>>> >>
>>>> >>
>>>> >> Thanks.
>>>> >>
>>>> >> Simon
>>>> > If you're only editing the horde sql backend, you could also use the
>>>> > "Horde" backend instead of the Sql backend.
>>>>
>>>> By Horde backend you mean the Horde DB? All my auth is done against
>>>> IMAP (dovecot) which uses a separate DB (also used by postfix) for
>>>> domains/mail accounts.
>>>>
>>>> As far as I know, I have to use the SQL backend to change that.
>>>>
>>>> Simon
>>>
>>> See line 117:
>>>
>>> Horde Sql Backend is NOT disabled - why?
>>
>> Er..  Because I try not to edit backends.php - it's my understanding
>> that any changes I make there will be over-written on upgrade.
>>
>> But I disabled it in the backends.local.php and of course now it's working.
>>
>> After a fashion - that is to say, my next issue is with the query..  I
>> get this error:
>>
>> Failure in changing password for All Services: sql: unable to load sub
>> driver: Could not instantiate PDO with DSN
>> "mysql:encryption=crypt;table=Mail;user_col=Email;pass_col=Password;query_lookup=SELECT
>> Password FROM Mail WHERE Email = %u;query_modify=UPDATE Mail SET
>> Password = %e WHERE Email = %u;name=Mail and VPN
>> Services;driver=Sql;required=1;is_subdriver=1;host=127.0.0.1;dbname=Mail".
>> PDOException: SQLSTATE[HY000] [2003] Can't connect to MySQL server on
>> '127.0.0.1' (111)[Tue 08 Nov 2011 01:29:43 PM EST]
>>
>> 139        'sql' => array(
>> 140                         'name' => 'Mail and VPN Services',
>> 141                         'driver' => 'Sql',
>> 142                         'required' => true,
>> 143                         'params' => array(
>> 144          'phptype'    => 'mysql',
>> 145          'hostspec'   => 'localhost',
>> 146          'username'   => 'noneedtoknowbutitsright',
>> 147          'password'   => 'imnottellingyouthat',
>> 148          'encryption' => 'crypt',
>> 149          'database'   => 'Mail',
>> 150          'table'      => 'Mail',
>> 151          'user_col'   => 'Email',
>> 152          'pass_col'   => 'Password',
>> 153          'show_encryption' => false,
>> 154          // The following two settings allow you to specify custom
>> queries for
>> 155          // lookup and modify functions if special functions need to be
>> 156          // performed.  In places where a username or a password needs to be
>> 157          // used, refer to this placeholder reference:
>> 158          //    %u -> gets substituted with the user
>> 159          //    %p -> gets substituted with the plaintext password
>> 160          //    %e -> gets substituted with the encrypted password
>> 161          //
>> 162          'query_lookup' => 'SELECT Password FROM Mail WHERE Email = %u',
>> 163          'query_modify' => 'UPDATE Mail SET Password = %e WHERE Email = %u',
>> 164         ),
>> 165     ))
>> 166  ));
>>
>>
>> I so wasn't expecting it to complain about not being able to connect
>> to mysql that I don't know where to go next.  I was at least expecting
>> to debug the query - but the connection..?
>
>
> Is it possible to connect to MySQL on a socket?
>
> mail:~# mysql -u root -p -h 127.0.0.1
> Enter password:
> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
>
> I have networking for mysql turned off.  Since everything is running
> on the same host, I have no wish to turn that on.

Would anyone like to comment on this?

It used to work just fine in H3 without needing a connection (I'm
pretty sure - I don't have that platform any more to check, but I'm
sure network connections to mysql were turned off).

Thanks.

Simon