[horde] works fine on localhost, but not remotly

[Michael Rubinsky]

Quoting Luís Azevedo <luis.azev at gmail.com>:

> Hi again,
>
> I'm running Horde Webmail on a Windows 2003 R2 server wtih
> apache/php/mysql, windows service "Mail server POP3/SMTP)" and
> everything works fine on localhost.
>
> Now I'm trying to access remotly on http://xx.xxx.xxx.xxx/horde but
> i'm getting errors:
>
> ...
> DB Error: connect failed
> [line 724 of C:\Program Files\Apache Software
> Foundation\Apache2.2\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>]: Access
> denied for user 'root'@'95.xxx.xxx.xxx' (using password: YES)] **
> mysql(mysql)://root:PASSWORD at tcp+95.xxx.xxx.xxx:3306/horde?persistent=&charset=utf-8&ssl=&splitread=
>     [backtrace] => Array
>         (
>             [0] => Array
>                 (
>                     [file] => C:\Program Files\Apache Software
> Foundation\Apache2.2\htdocs\horde\pear\php\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>]: Access
> denied for user 'root'@'95.xxx.xxx.xxx' (using password: YES)]
>                         )
>
>                 )
> ...
> ...
> Does anyone know how to set it correctly?

You most likely need to add the root at 95.xxx.xxx.xxx user to have  
permissions on the mysql server. Maybe you don't have it added with  
the correct IP? If the mysql server is on the local box, you could  
also use a unix socket instead.



mike

The Horde Project (www.horde.org)
mrubinsk at horde.org