[imp] Problem getting Horde Groupware Webmail Edition 1.2.3 to work

[Son Truong]

Further to this. I've set up an alias 'horde' for MySQL server, and 
these are the new DB error messages I get:
________

DB_Error Object
(
    [error_message_prefix] =>
    [mode] => 1
    [level] => 1024
    [code] => -26
    [message] => DB Error: insufficient permissions
    [userinfo] =>  [nativecode=1044 ** Access denied for user 
'horde'@'my-webmail' to database 'horde'] ** 
mysql(mysql)://horde:PASSWORD at tcp+horde:3306/horde?persistent=&charset=utf-8&ssl=1
    [backtrace] => Array
        (
            [0] => Array
                (
                    [file] => /usr/local/apache2/htdocs/horde/pear/DB.php
                    [line] => 966
                    [function] => PEAR_Error
                    [class] => PEAR_Error
                    [type] => ->
                    [args] => Array
                        (
                            [0] => DB Error: insufficient permissions
                            [1] => -26
                            [2] => 1
                            [3] => 1024
                            [4] =>  [nativecode=1044 ** Access denied 
for user 'horde'@'my-webmail' to database 'horde']
                        )

                )
________

The last line is interesting, in that it is trying to get to a database 
called 'horde', but with my setup my horde database is not called 
'horde' but 'new_horde'... Is there some hardwired code in this 'pear' 
module..?

Son Truong wrote:
>
> Hello,
>
> I've been running Horde Groupware Webmail Edition 1.2 on a test server 
> just fine. On this same test server I've remove this version's horde 
> directory under htdocs, and installed the new 1.2.3 version.
>
> I've pointed this new version at a different MySQL database (5.1.30 - 
> previously 5.0.67) and gotten the scripts/setup.php to work fine - 
> installing the required tables for this new version.
>
> But when I go to the webmail page I get these errors:
>
> _______
>
> Warning: Invalid argument supplied for foreach() in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1249
>
> Warning: Invalid argument supplied for foreach() in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1249
>
> Warning: explode() [function.explode]: Empty delimiter in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMAP/Tree.php on line 406
>
> Warning: Invalid argument supplied for foreach() in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1249
>
> Warning: Invalid argument supplied for foreach() in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1249
>
> Warning: explode() [function.explode]: Empty delimiter in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMAP/Tree.php on line 406
>
> Warning: reset() [function.reset]: Passed variable is not an array or 
> object in /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1240
>
> Warning: key() [function.key]: Passed variable is not an array or 
> object in /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1241
>
> Warning: Invalid argument supplied for foreach() in 
> /usr/local/apache2/htdocs/horde/imp/lib/IMP.php on line 1249
> A fatal error has occurred
> DB Error: connect failed
>
> [line 724 of /usr/local/apache2/htdocs/horde/lib/Horde/Group/sql.php]
> Details:
> The full error message is logged in Horde's log file, and is shown 
> below only to administrators. Non-administrative users will not see 
> error details.
>
> DB_Error Object
> (
>    [error_message_prefix] =>
>    [mode] => 1
>    [level] => 1024
>    [code] => -24
>    [message] => DB Error: connect failed
>    [userinfo] =>  [nativecode=mysql_connect() [<a 
> href='function.mysql-connect'>function.mysql-connect</a>]: Unknown 
> MySQL server host 'horde' (1)] ** 
> mysql(mysql)://horde:PASSWORD at tcp+horde:3306/horde?persistent=&charset=utf-8&ssl=1 
>
>    [backtrace] => Array
>        (
>            [0] => Array
>                (
>                    [file] => /usr/local/apache2/htdocs/horde/pear/DB.php
>                    [line] => 966
>                    [function] => PEAR_Error
>                    [class] => PEAR_Error
>                    [type] => ->
>                    [args] => Array
>                        (
>                            [0] => DB Error: connect failed
>                            [1] => -24
>                            [2] => 1
>                            [3] => 1024
>                            [4] =>  [nativecode=mysql_connect() [<a 
> href='function.mysql-connect'>function.mysql-connect</a>]: Unknown 
> MySQL server host 'horde' (1)]
>                        )
>
>                )
>
> _______
>
> I've no idea what is going wrong here. I've checked the 
> horde/config/conf.php file for the Mysql hostspec and it points at the 
> correct MySQL server - which is not 'horde' as indicated by the above 
> error message.
>
> Do I need a different version of Pear or something like that?
>
> Any help appreciated.
>
> Regards,
> Son
>


-- 
Son V Truong * Unix System Programmer * Systems Group
LIS: IT Services * University of St Andrews
01334 462373 * svt at st-andrews.ac.uk
++
The University of St Andrews is a charity registered in Scotland: No SC013532