[horde] Change Database IP Got Something Strange ??

[Manilal K M]

PLEASE keep the replies to the list

On 23/08/06, james <g9224 at cs.nccu.edu.tw> wrote:
>
> Manilal K M 提到:
>
> > On 23/08/06, james <g9224 at cs.nccu.edu.tw> wrote:
> >
> >>
> >> Some reason I have to change Database IP.
> >>
> >> If i change database ip and modify $conf['sql']['hostspec'] in
> >> horde/config/conf.php.
> >>
> >> Then I will get some error like :
> >>
> >> DB Error: Unable to connect to PostgreSQL server: could not connect to
> >> server:
> >> Operation timed out  Is the server running on host
> >> &quot;xxx.xxx.xxx.xxx&quot;
> >> and accepting      TCP/IP connections on port 5432?] ** Array [on
> >> line 388
> >> of
> >> "/home/www/htdocs/horde/lib/Horde/Prefs/sql.php"]
> >>
> >> xxx.xxx.xxx.xxx is the old ip.
> >>
> >> And I saw in kronolith_events, mnemo_memos, nag_tasks, turba_objects
> >> tables,
> >> there have field name xxxx_uid, database's data will something like
> >> xxxxxxxxxxxxxxxxxx at old-ip
> >>
> >> I think maybe this reason cause the error. Does anybody know how to
> >> solve
> >> it ?
> >> Thanks.
> >>
> >> This is not a Horde Error.
> >
> > Probably you are running PostgreSQL without the " -i " option.
> > Remember that
> > if you want to connect pgsql from IPs other than  localhost or
> > 127.0.0.1then you have to run the  postmaster with  -i option. In
> > addition to this
> > you may also need to edit pg_hba.conf to get permission for the new IP.
> > Read more at:
> > Check your PostgreSQL configuration, especially pg_hba.conf.
> >
> > regards
> > Manilal
>
>
> I dump pg server1 data to pg server2
> It can correctly connect to new database server, but there still have
> some connections to old database.
>
> It's work.
> pg server1 horde ---------------------------->pg server2
> (Old IP) (Another IP) always have connections (New IP)
>
>
> 1. If i tune off pg server1，horde server will get the error messages i
> mention above.
> 2. If i tune on pg server1，I can see some "select" SQL in Log file.
>
> So I think there are some php code will get database data, and find
> xxxx_uid field have some data like xxxxxxxxxxxxxxxxxx at host-ip, then goto
> host-ip to take something back.
>
> I don't know why need to log host ip into database ? Or maybe my thought
> is wronge ?
>

I am actually confused with your  network. Wait for some other peers to
respond.
regards
Manilal