Hi,

Solved this problem.

#!define DBURL "postgres://asterisk:password@Float.ing.IP.pgpool:9999/kamailio" #!ifdef WITH_ASTERISK #!define DBASTURL "postgres://asterisk:password@Float.ing.IP.pgpool:9999/asterisk" #!endif #!endif

I have changed below as follow. #!define DBURL "postgres://asterisk:password@Float.ing.IP.pgpool/kamailio" #!ifdef WITH_ASTERISK #!define DBASTURL "postgres://asterisk:password@Float.ing.IP.pgpool/asterisk" #!endif #!endif

I defined the port as 9999 for pgpool2postgres that was not correct. I removed the definition port as 9999 for pgpool2postgres that is working all and fine.

I do not know the reason. By the way I will report to the ALL.

Thank you for kamailio and Daniel, ALL!

Noriyuki Hayashi in Japan

On Mon, 13 Jun 2016 11:03:19 +0200 Daniel-Constantin Mierla miconda@gmail.com wrote:

Hello,

to understand properly, kamailio is working fine byt psql is not working, right?

If yes, maybe you can run psql with more verbosity to see why is not working.

Otherwise, I am not a postgres user, so can't help with more specific details.

Cheers, Daniel

On 10/06/16 07:53, Noriyuki Hayashi wrote:

...

Hi,

I am testing on CentOS 6.6 x86.64 kamailio-4.3.5 postgresql-9.4.6 pgpool-II-pg94-3.5.2

When I using floating IP as 192.168.192.143 that kamailio is working. But I could not access to psql -h 192.168.192.143 -p 9999 -U postgres asterisk.

Let me know if you have this issue with much appriciated.

Thank you.

#!define DBURL "postgres://asterisk:password@192.168.192.143:9999/kamailio" #!ifdef WITH_ASTERISK #!define DBASTURL "postgres://asterisk:password@192.168.192.143:9999/asterisk" #!endif #!endif

Noriyuki Hayashi Japan.

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla http://www.asipto.com - http://www.kamailio.org http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda