[horde] How to create a useracount

[Jerry Doran]

What is the variation of this for MS SQL? 
It keeps telling me I cannot find database.
This is two expamples of what i have tried

$conf['prefs']['params']['phptype'] = 'sql';
>> > $conf['prefs']['params']['hostspec'] = 'sqlserver.domain.com';
>> > $conf['prefs']['params']['username'] = 'horde';
>> > $conf['prefs']['params']['password'] = 'horde';
>> > $conf['prefs']['params']['database'] = 'horde';
>> > $conf['prefs']['params']['table'] = 'horde_prefs';

$conf['prefs']['params']['phptype'] = 'mssql-odbc';
>> > $conf['prefs']['params']['hostspec'] = 'horde';
>> > $conf['prefs']['params']['username'] = 'horde';
>> > $conf['prefs']['params']['password'] = 'horde';
>> > $conf['prefs']['params']['database'] = 'horde';
>> > $conf['prefs']['params']['table'] = 'horde_prefs';


Any help is appreciated. Thanks,

Jerry



*********** REPLY SEPARATOR  ***********

On 9/11/2003 at 3:45 PM Chrigi Hartmann wrote:

>Hi Etienne
>
>[...]
>> > // This is an example configuration for a MySQL preference backend.
>> > // The SQL script to setup the preference database is placed in
>> > // horde/scripts/db/prefs.sql.
>> > $conf['prefs']['params']['phptype'] = 'mysql';
>> > $conf['prefs']['params']['hostspec'] = 'localhost';
>> > $conf['prefs']['params']['username'] = 'horde';
>> > $conf['prefs']['params']['password'] = 'horde';
>> > $conf['prefs']['params']['database'] = 'horde';
>> > $conf['prefs']['params']['table'] = 'horde_prefs';
>> > *********************************************************************
>>
>> That's your problem.  You defined a preferences backend, not an
>> authentication backend.  You need to edit the following section of your
>> horde.php :
>>
>> ---
>> /**
>>  ** Horde Authentication
>>  **/
>>
>> // If you want to use IMP with Horde and don't want to let the users
>> // login twice (once for Horde and once for IMP) you can setup Horde
>> // to let IMP do the authentication stuff. Just uncomment the
>> // auth/login/logout lines in registry.php instead of configuring the
>> // following settings.
>>
>> // What backend should we use for authenticating users to Horde? Valid
>> // options are currently 'imap', 'ldap', 'mcal', 'sql', 'ftp', 'smb',
>> // 'krb5' and 'radius'.
>> $conf['auth']['driver'] = 'sql';
>>
>> // An array holding any parameters that the Auth object will need to
>> // function correctly.
>> $conf['auth']['params'] = array();
>> ---
>>
>> >From there on, you need to populate $conf['auth']['params'] with
>> something similar to what you did for the prefs backend :
>>
>> ---
>> $conf['auth']['params']['phptype'] = 'mysql';
>> $conf['auth']['params']['hostspec'] = 'localhost';
>> $conf['auth']['params']['username'] = 'horde';
>> $conf['auth']['params']['password'] = 'horde';
>> $conf['auth']['params']['database'] = 'horde';
>> // This will need to be verified
>> $conf['auth']['params']['table'] = 'horde_auth';
>> ---
>>
>> Don't forget
>> to create the table with the script provided in the scripts/ directory
>> of your installation.
>
>THIS WAS THE SOLUTION! Here in switzerland we say 'danke viiielmaaal' ;-)
>Now everything works. but the table provided in the scripts directory made
>a
>table horde_users and not horde_auth. I edited this and now it works.
>
>Thank you very much again for your help. is pretty nice from you!
>
>Greets, chrigi Hartmann
>
>
>-- 
>Horde mailing list
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: horde-unsubscribe at lists.horde.org