6.0.0-beta1
8/7/25

[#3817] hostspec parameter ignored for sql backends
Summary hostspec parameter ignored for sql backends
Queue Passwd
Queue Version 3.0
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester joris (at) ideeel (dot) nl
Created 04/23/2006 (7046 days ago)
Due
Updated 04/23/2006 (7046 days ago)
Assigned
Resolved 04/23/2006 (7046 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
04/23/2006 11:20:53 PM Jan Schneider Comment #2
State ⇒ Not A Bug
Reply to this comment
This is not the sql log from Passwd.
04/23/2006 05:52:43 PM joris (at) ideeel (dot) nl Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ hostspec parameter ignored for sql backends
Queue ⇒ Passwd
Reply to this comment
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@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




Saved Queries