[Tickets #3819] NEW: passwd mysql backend

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=3819
-----------------------------------------------------------------------
 Ticket             | 3819
 Created By         | joris at ideeel.nl
 Summary            | passwd mysql backend
 Queue              | Passwd
 Version            | 3.0
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


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

I'm really sorry to resubmit but Jan dismissed the old one because he did
not bother to read the mail (except for the first few lines). Please read it
properly this time. Passwd *is* checking localhost while it should not. I've
taken out the prefs lines from the mysql log to avoid further confusion.
Look at the supplied hostname (LALALA) that shows that passwd is checking
the wrong host.

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',
<SNIP>
    '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)
2726 Connect     Access denied for user 'LALALA'@'localhost' (using
password: YES)
                   2725 Quit