[horde] Dynamic, Minimalist, Traditional selection?

[horde at corwyn.net]

Missed a ')', should be
$query = str_replace('\L',$this->_db->quote($userID), $query);

Still missing how to get it to actually enable.  I have figured out 
that it shouldn't be in
>  if (!function_exists('_horde_hook_signup_addextra')) {
  because I'm trying to get it to work in the users function not the 
signup function.

At 10:46 AM 10/10/2008, horde at corwyn.net wrote:
>At 05:18 AM 10/10/2008, Jan Schneider wrote:
>>>I see the login driver needs to be the application driver to trigger
>>>the choices for Dyn, Min, and Trad, yes?.  How does everything else
>>>know what to pick?
>
>Still a question
>
>>No, Horde can stretch even more. :) You can achieve that by creating a
>>_horde_hook_signup_addextra hook. If you've gone through that, it
>>would great if you could add instructions to the howto.
>
>A better point here is whether _I_ can stretch more. *sigh*. 
>Catch-22 I think, but we'll give 'er a go.
>
>Ok, so in config/conf.php I add as part of my composite query next 
>to 'query_add':
>'query_add2' => 'INSERT INTO alias 
>(address,goto,domain,created,modified) VALUES (\L, \L, RIGHT(\L, 
>(LENGTH(\L)-(INSTR(\L, \'@\')))), now(), now());';
>
>in config/hooks.php I add:
>  if (!function_exists('_horde_hook_signup_addextra')) {
>    function _horde_hook_signup_addextra($userID)
>    {
>        global $conf;
>
>        require_once 'DB.php';
>        $_db = &DB::connect($conf['mysqli'], true);
>        $query = $this->_params['query_add2'];
>        $query = str_replace('\L',$this->_db->quote($userID, $query);
>        $result = $_db->query($query);
>
>        return is_a($result, 'PEAR_Error') ? $result : true;
>    }
>}
>
>(which I at least thing will work based on the code from 
>horde/lib/Horde/Auth/customsql.php)
>
>However, config/hooks.php says: "Having a hook function in this file 
>does NOT mean that the hook will automatically be used. YOU MUST 
>enable the hook."
>
> From the documentation in hooks.php, that looks like I need
>horde_hook_somethig or other,
>or do I set
>$conf[hooks][auth2] = true
>
>or something in between?
>
>I feel like it's close, but not working!
>
>Rick
>
>
>>>//composite of mysql and application driver
>>>$conf['auth']['driver'] = 'composite';
>>>//composite mysql driver
>>>$conf['auth']['params']['drivers']['customsql_mod']['driver'] = 'customsql';
>>>$conf['auth']['params']['drivers']['customsql_mod']['params'] = array(
>>>'phptype' => 'mysqli',
>>>'protocol' => 'unix',
>>>'hostspec' => 'localhost',
>>>'username' => 'postfix',
>>>'password' => 'pfix1723',
>>>'database' => 'postfix',
>>>'query_auth' => 'SELECT * FROM mailbox WHERE username = \L and
>>>password=\P; ',
>>>'query_add' => 'INSERT INTO mailbox
>>>(username,password,maildir,quota,domain,created,modified) VALUES
>>>(\L, \P, CONCAT(RIGHT(\L, (LENGTH(\L)-(INSTR(\L, \'@\')))), \'/\',
>>>LEFT(\L, INSTR(\L,\'@\')-1) , \'/\') ,\'512000000\', RIGHT(\L,
>>>(LENGTH(\L)-(INSTR(\L, \'@\')))), now(), now());',
>>>'query_getpw' => 'SELECT password FROM mailbox WHERE username = \L;',
>>>'query_update' => 'UPDATE mailbox SET username = \L WHERE username =
>>>\O) LIMIT 1;',
>>>'query_resetpassword' => 'UPDATE mailbox SET password = \P WHERE
>>>username = \L;',
>>>'query_remove' => 'DELETE FROM mailbox WHERE username = \L;',
>>>'query_list' => 'SELECT * FROM mailbox;',
>>>'query_exists' => 'SELECT 1 FROM mailbox WHERE username = \L;',
>>>'encryption' => 'crypt-md5',
>>>'show_encryption' => false);
>>>//composite application driver
>>>$conf['auth']['params']['drivers']['application_mod']['driver'] =
>>>'application';
>>>$conf['auth']['params']['drivers']['application_mod']['params'] = array(
>>>    'app' => 'imp');
>>>//selecting the login driver
>>>$conf['auth']['params']['admin_driver'] = 'customsql_mod';
>>>$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';
>>>if (!function_exists('_horde_select_loginscreen')) {
>>>     function _horde_select_loginscreen()
>>>     {
>>>         return 'application_mod';
>>>     }
>>>}
>>>
>>>
>>>At 07:50 PM 10/9/2008, Jan Schneider wrote:
>>>>2b. Use composite authentication.
>>
>>Jan.
>