[imp] Having problems with the user preferences.
Brent J. Nordquist
bjn@horde.org
Wed, 14 Mar 2001 06:15:51 -0600 (CST)
On Tue, 13 Mar 2001, Bill Mitcheson <turtle@pyramus.com> wrote:
> We are still getting the following error when trying to update the
> preferences page:
>
> Warning: MySQL: Unable to save result set in
> /a/samson/usr/exports/webpages/service/horde/imp/lib/db.mysql on line
> 229
Bill, are you getting the messages from the list? I've asked you twice
whether you are able to connect to the database from the command line. I
really think that should be your next troubleshooting step. Again:
> I had asked:
>
> > > Can you use the host, user, password, etc. specified there
> > > to log into MySQL from the command-line on the IMP server? This
> > > makes sure MySQL in general is working.
>
> If you have the following settings:
>
> /* Database Configuration */
> $default->use_db = true;
> $default->database_driver = 'mysql';
> $default->db_user_name = 'hordemgr';
> $default->db_password = 'password';
> $default->db_security_nag = true;
> $default->db_name = 'horde';
> $default->db_server_name = 'db.example.com';
>
> Then you should be able to run this command from the shell on the
> server:
>
> mysql -h db.example.com -u hordemgr -p horde
> Password: <type password>
>
> If that doesn't connect, then that's your problem... the MySQL database,
> tables, and user aren't set up right, or the settings don't match. Then
> you'd want to re-read the install documentation for the database part.
--
Brent J. Nordquist <bjn@horde.org>
Yahoo!: Brent_Nordquist / AIM: BrentJNordquist / ICQ: 76158942