[sork] passwd ignores hostspec parameter in backends.php

Joris joris at ideeel.nl
Mon Apr 24 05:36:15 PDT 2006


re

>Only because it uses the same username doesn't mean it's from the same
>configuration. You didn't show us your preference configuration, so
>the logs could as well be (and probably are) from the prefs driver.

No. They are definately not. this username was unique for 
backends.php specifically to exclude this. No  other prefs file uses 
it. You could have deducted that from the observation that the other 
queries succeeded. This is shown again below.

* all horde prefs file use the username 'horde'. I have specifically 
altered the username in backends.prefs so it would show up on the logs.

* no other aspects of horde give access denied. The contents of the 
horde mysql database show that horde can connect, select and update. 
the problem is only on passwd.

horde conf.php:
* $conf['sql']['username'] = 'horde';

and: mysql showing the prefs driver:
060424 10:21:44    3760 Connect     horde at localhost on
                    3760 Init DB     horde
                    3760 Quit
                    3761 Connect     horde at localhost on
                    3761 Init DB     horde
                    3761 Init DB     horde
                    3761 Query       SELECT datatree_id, 
datatree_parents FROM horde_datatree WHERE datatree_name = 'horde' 
AND group_uid = 'horde.perms' ORDER BY datatree_id

BUT:

backends.php:
* 'hostspec'   => 'mysql.ideeel.net',
'* username'   => 'UNAMEFORPASSWD',

and Mysql log:
*  2726 Connect     Access denied for user 'UNAMEFORPASSWD'@'localhost'
* (using password: YES)

Again: this username is *only* used in the backends.php. It is not 
used anywhere else. The log on the sql is placed (tail -f) at the 
exact time as the submit button for passwd is entered.

and conf.php:
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: passwd/config/conf.xml,v 1.12 2005/10/09 14:48:58 jan Exp $
$conf['menu']['apps'] = array('imp', 'ingo', 'kronolith');
$conf['backend']['backend_list'] = 'hidden';
$conf['user']['change'] = true;
$conf['user']['refused'] = array('root', 'bin', 'daemon', 'adm', 'lp', 'shutdow
$conf['password']['strengthtests'] = false;
$conf['hooks']['full_name'] = true;
$conf['hooks']['default_username'] = false;
$conf['hooks']['username'] = false;
$conf['hooks']['userdn'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

To my knowledge this shows that passwd connects to localhost instead 
of the value indicated in hostspec.
If you believe otherwise please indicate what information or tests you need.

joris




More information about the sork mailing list