[sork] Cannot connect to external MySQL server
Jan Schneider
jan at horde.org
Tue Sep 15 13:44:27 UTC 2009
Zitat von Seba <free4cd at googlemail.com>:
> Version: Passwd 3.1.1
>
> I use Horde/IMP on a webserver with an own mysql database. User
> accounts and passwords are stored on antoher mysql server. I've
> configured Passwd so far but I when I try to change the password of an
> user I get the message;
>
> Unable to connect to SQL server (Verbindung zum SQL Server kann nicht
> hergestellt werden).
>
> All needed pear modules should be installed like PEAR,Mail,Log,DB...
>
>>> From this webserver I can connect to the remote MySQL server with the
> mysql client (command line) without problems but not with the passwd
> application. The backend.php seems to be correctly configured.
>
> 'params' => array(
> 'phptype' => 'mysql',
> 'hostspec' => 'ip of the external server',
> 'username' => 'hordepwd',
> 'password' => 'password of the user',
> 'encryption' => 'plain',
> 'database' => 'mail',
> 'table' => 'mailbox',
> 'user_col' => 'username',
> 'pass_col' => 'password',
> 'show_encryption' => false
>
> On the remote sql server there's no firewall active and the mysql
> server is listening on port 3306.
You miss the 'protocol' entry that should be set to 'tcp'.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
More information about the sork
mailing list