[horde] remote mysql db

[samer khalil]

It is all working fine now.
It worked when i removed  $conf['sql]['port']=3306; from conf.php !
allthough Mysql is listenning on this port.

tks guys.

SK

On 10/4/06, samer khalil <samerk1 at gmail.com> wrote:
>
> 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
> >
>
>