[imp] Changing Identity

[Kevin M. Myer]

Quoting ls at lonely-star.org:

> Thanks, that sounds very easy.
> The Problem: The option button does not appear. After looking in the 
> faq, I did
> the following:
> I create a database called 'horde' and created a table using:
>
> mysql> CREATE TABLE horde_prefs (
>    ->     pref_uid        VARCHAR(255) NOT NULL,
>    ->     pref_scope      VARCHAR(16) NOT NULL DEFAULT '',
>    ->     pref_name       VARCHAR(32) NOT NULL,
>    ->     pref_value      TEXT,
>    -> --
>    ->     PRIMARY KEY (pref_uid, pref_scope, pref_name)
>    -> );
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde;
> Query OK, 0 rows affected (0.09 sec)

If you really have assigned a password, as you list below in your 
config, then the GRANT statement should be:

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_prefs TO horde at localhost 
identified by 'yourhordepassword';

> In my horde/config/conf.php I changed
>
> $conf['prefs']['driver'] = 'none';
>
> to
>
> $conf['prefs']['driver'] = 'sql';
> $conf['prefs']['params'] = array();
> $conf['prefs']['params']['phptype'] = 'mysql';
> $conf['prefs']['params']['hostspec'] = 'localhost';
> $conf['prefs']['params']['username'] = 'horde';
> $conf['prefs']['params']['password'] = '***********';
> $conf['prefs']['params']['database'] = 'horde';
> $conf['prefs']['params']['table'] = 'horde_prefs';
> $conf['prefs']['params']['charset'] = 'iso-8859-1';
>
> Still no "option" button. What do I have to do?
> Thanks!
> Nathan

If you missed setting up a preference backend, there might be other 
things you have missed too.  You might want to read the INSTALL 
document, but you're on the right track, I think.

Kevin



-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org