[horde] remote mysql db

[samer khalil]

I actually have a Mysql running on server2, and when i modify conf,php to
connect to the local Mysql all works fine.
It starts looking when ask horde to connect to the remote sql.

SK

On 10/4/06, Jan Schneider <jan at horde.org> wrote:
>
> Zitat von samer khalil <samerk1 at gmail.com>:
>
> > Hello,
> >  I am using horde 3.1.3 with imp 4.1.3 on 2 diferent web servers with a
> > single Mysql db on one of them.
> > When am logged in to the sever hosting the database eveything goes well.
> >
> > On the second web server in have in my conf.php:
> >
> > $conf['sql']['persistent'] = false;
> > $conf['sql']['hostspec'] = ' 192.168.1.1';
> > $conf['sql']['username'] = 'horde';
> > $conf['sql']['password'] = 'xxxxxxxx';
> > $conf['sql']['port'] = 3306;
> > $conf['sql']['protocol'] = 'tcp';
> > $conf['sql']['database'] = 'horde';
> > $conf['sql']['charset'] = 'iso-8859-1';
> > $conf['sql']['phptype'] = 'mysql';
> >
> > from the command line mysql connection works fine:
> > # mysql -u horde -p -h 192.168.1.1
> > Enter password:
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 162 to server version: 5.0.22-standard
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > mysql>
> >
> > When I attempt to login in through horde, i get the home page but never
> logs
> > in. It keeps looping.
>
> And do you have any hint that this is related to the remote db server?
>
> > On the Auth server the user is authenticating correcty and a Db
> connection
> > is openned with the original server (it shows in netstat -nta)
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
> --
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>