[SR-Users] 【Issue of kamailio with pgpool】

[Noriyuki Hayashi]

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 at 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 at 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
>