[imp] MySQL Fatal Error on Login (was: Host of Problems with IMP)

[Rodolfo Segleau]

OK, I've solved all of the problems by upgrading to Apache 2.0.36 and PHP 
4.2.0 (yea, yea, I know it's the bleeding edge, but I couldn't get 1.3.19 to 
parse the PHP correctly with 4.2.0).

But now I have an interesting question: when I try to log in, IMP tries to 
connect to the db (mysql 2.3.x) to log in with root@sigil instead of 
root@localhost. These are the settings to the db in conf/horde.php

$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'root';
$conf['prefs']['params']['password'] = '**************';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

And this is the error that the IMP spits out:

object(db_error)(7) {
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(-24)
  ["message"]=>
  string(24) "DB Error: connect failed"
  ["userinfo"]=>
  string(81) " [nativecode=Access denied for user: 'root@sigil' (Using 
password: YES)] ** Array"
  ["callback"]=>
  NULL
}
[/var/www/webmail-html/horde/lib/Prefs/sql.php : 102]

So how do I force it to always use @localhost and not @sigil.

Thanks in advance.

Cheers,

Rodolfo


<snip>
>Ok, I'm about to pull my hair out, this is driving me insane. I'm trying to
>migrate from TWIG 2.7.5 to Horde/IMP 3.0. I have the following 
>configuration
>(HW&SW):
>
>HW:
>Alphaserver 800 (ev56 based)
>
>SW:
>RedHat Linux 7.1 (2.4 kernel)
>Apache 1.3.19
>PHP 4.2.0
>UW-IMAP 2000c
>Horde 2.0-1
>IMP 3.0
>Turba 1.0
>Sendmail 8.11
>Mysql
>
>   These are the problems:
>   If I don't touch any of the files, everything works great (except that I
>can't do anything). As soon as I start configuring the files to my site
>(horde.php, registery.php, conf.php, servers.php), Apache starts 
>segfaulting
>and the index.php doesn't load the page completely. For example, the bottom
>bar and the login box appear, but the rest of the page is white (if you 
>want
>to check, you can go to webmail.mechanus.org/horde/index.php). If I place a
>valid user/pass in the login box, it just returns to the login box as if
>nothing happened. The horde.log reports that it can't authenticate (the
>famous line 332 error and now the line 43 error in login.php for horde) and
>the IMAP log says that it can't authenticate the user ????.
>   I've been reading the lists, but I can't seem to find the solution 
>there.
>Any suggestions?
>
>Cheers,
>
>Rodolfo
>
>
>
>_________________________________________________________________
>Send and receive Hotmail on your mobile device: http://mobile.msn.com
>
>
>--
>IMP mailing list
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: imp-unsubscribe@lists.horde.org




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com