Dear all,
I am trying to use SER with PostgreSQL but in separate boxes, one for the proxy and the other one with the DB backend.
A group of colleagues succeed in installing everything in the same box, but I am trying to go further, because the database is also part of a bigger database system application and We would like to gather everything together.
Anyway I got an authorized 401 code when I try to log on in the SER system. I am trying to find out what is going on. I have downloaded the sip_scenario utility to analyse the tcpdump files generated with the ethernet utility. Anyway I still dont see what happens when the SER server tries to connect with the PostgreSQL database, the tcpdump tool says that there is any kind of connection but I dont know really what is going on.
Can anyone give any hint to help me out?
Many thanks in advance
Miguel
Hi,
A couple of ideas.
1) Can you connect with psql from box A to box B's postgres? 2) Have you fixed the connect string in ser.cfg to use the connect information you used on step 1)?
I am using postgres between machines with SER.
-g
On Sep 22, 2004, at 10:36 AM, Miguel González Castaños wrote:
Dear all,
I am trying to use SER with PostgreSQL but in separate boxes, one for the proxy and the other one with the DB backend.
A group of colleagues succeed in installing everything in the same box, but I am trying to go further, because the database is also part of a bigger database system application and We would like to gather everything together.
Anyway I got an authorized 401 code when I try to log on in the SER system. I am trying to find out what is going on. I have downloaded the sip_scenario utility to analyse the tcpdump files generated with the ethernet utility. Anyway I still dont see what happens when the SER server tries to connect with the PostgreSQL database, the tcpdump tool says that there is any kind of connection but I dont know really what is going on.
Can anyone give any hint to help me out?
Many thanks in advance
Miguel
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Greg Fausak www.AddaBrand.com (US) 469-546-1265
Greg Fausak escribió:
Hi,
A couple of ideas.
- Can you connect with psql from box A to box B's postgres?
- Have you fixed the connect string in ser.cfg to use the connect
information you used on step 1)?
There is nothing like to get up in the morning and being fresher to try things...
I used ethereal instead of tcpdump and I saw the statements being issued. Everything was fine...the select, the connection, only that the result of the select was not the one expected...Then I issued the select in the psql frontend and then I saw where the mistake was...the SIP_DOMAIN global variable didnt match the SER box machine...Now fixed and working...
Anyway I think it would be desirable to make some kind of setup where you can install the SER and the database backend in different boxes...At least a tutorial...I will try to do one myself...
Regards
Miguel
-
Greg Fausak -
Miguel González Castaños