[Tickets #3817] NEW: hostspec parameter ignored for sql backends

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=3817
-----------------------------------------------------------------------
 Ticket             | 3817
 Created By         | joris at ideeel.nl
 Summary            | hostspec parameter ignored for sql backends
 Queue              | Passwd
 Version            | 3.0
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


joris at ideeel.nl (2006-04-23 10:52) wrote:

I run horde on machine A (wallach) which authenticates against machine B
(mysql) . In my prefs I have hostspec set to "'hostspec'   =>
'mysql.ideeel.net',". HOwever, when I run passwd it does not query the
remote machine but the local instead. Thus the hostspec value is ignored.

** backends.php **
$backends['sql'] = array (
    'name' => 'Ideeel.net POP3',
    'preferred' => '',
    'password policy' => array(
        'minLength' => 2,
        'maxLength' => 8,
        'maxSpace' => 0,
        'minUpper' => 0,
        'minLower' => 0,
        'minNumeric' => 0,
        'minSymbols' => 0
    ),
    'driver' => 'sql',
    'params' => array(
        'phptype'    => 'mysql',
        'hostspec'   => 'mysql.ideeel.net',
        'username'   => 'LALALA',
        'password'   => 'dbpasswd',
        'encryption' => 'plaintext',
        'database'   => 'LOLOLO',
        'table'      => 'users',
        'user_col'   => 'user_uid',
        'pass_col'   => 'user_pass',
        'show_encryption' => false
    )
);

** mysql log on localhost (= wrong machine)
060423 19:51:01    2725 Connect     horde at localhost on
                   2725 Init DB     horde
                   2725 Init DB     horde
                   2725 Init DB     horde
                   2725 Query       SELECT pref_scope, pref_name, pref_value
FROM horde_prefs WHERE pref_uid = 'joris' AND (pref_scope = 'passwd' OR
pref_scope = 'horde') ORDER BY pref_scope
                   2726 Connect     Access denied for user
'LALALA'@'localhost' (using password: YES)
                   2725 Quit