Hi Georgy,
I am running kamailio-4.3.7-2.2.x86_64 with
postgresql-bdr94-bdr-1.0.7-1.cs7.x86_64
by own forked version on CentOS7.9.
Please refer below kamailio.cfg.
#!KAMAILIO
#!enable postgresql
#!define WITH_PGSQL
---
#!ifdef WITH_PGSQL
# - database URL - used to connect to database server by modules such
# as: auth_db, acc, usrloc, a.s.o.
#!define DBURL "postgres://PGUSER:PASS@IP:5432/kamailio"
#!ifdef WITH_ASTERISK
#!define DBASTURL "postgres://PGUSER:PASS@IP:5432/asteriskDB"
#!endif
#!endif
#!ifdef WITH_PGSQL
loadmodule "db_postgres.so"
#!endif
#!ifdef WITH_DISPATCHER
loadmodule "dispatcher.so"
loadmodule "sqlops.so"
#!endif
#!ifdef WITH_DISPATCHER
# ----- dispatcher params -----
modparam("dispatcher", "db_url", DBURL)
modparam("dispatcher", "table_name", "dispatcher")
modparam("dispatcher", "flags", 2)
modparam("dispatcher", "dst_avp", "$avp(AVP_DST)")
modparam("dispatcher", "grp_avp", "$avp(AVP_GRP)")
modparam("dispatcher", "cnt_avp", "$avp(AVP_CNT)")
modparam("sqlops","sqlcon","ca=>postgres://PGUSER:PASS@IP:5432/kamailio")
#!endif
*Point
kamailio-4.3.7-2 has a bug my guessing, only Port 5432/TCP is working.
So, I needed install postgre-libs and sever for run the command.
Now Kamailio is running 3 servers.
I am not sure Kamailio 5.5.5 but postgresq14 alomost same.
I hope this helps for you.
Regards,
Noriyuki.Hayashi Japan
On Thu, 6 Apr 2023 17:30:15 +0200
Paolo Visintin <[email protected]> wrote:
> Hello Georgy,
> Regarding your Kamailio configuration with PostgreSQL, could you please
> provide more information about the error that Kamailio is giving when it
> tries to connect to the database? Knowing the error message would help in
> identifying the issue.
>
> Il giorno gio 6 apr 2023 alle ore 15:32 <[email protected]> ha
> scritto:
>
> > Hello everyone,
> >
> > I'm trying to connect Kamailio 5.5.5 to my PostgreSQL 14.
> > They are on two different servers.
> > I have created the Kamailio DB on the Postgre with the help of the command
> > "kamdbctl create"
> > I'm able to connect to the database with no problem.
> > The problem is in the kamailio.cfg file, i have added this so far:
> >
> > #!define WITH_PGSQL
> >
> > #!ifdef WITH_PGSQL
> > #!define DBURL "postgres://USER:PASSWORD@IP:POPT/kamailio"
> > #!endif
> >
> > #!ifdef WITH_PGSQL
> > loadmodule "db_postgres.so"
> > #!endif
> >
> > modparam("db_postgres", "retries", 3)
> > modparam("db_postgres", "timeout", 10)
> > modparam("db_postgres", "tcp_keepalive", 600)
> > modparam("db_postgres", "lockset", 6)
> > modparam("db_postgres", "bytea_output_escape", 0)
> >
> > But my kamailio doenst like this configuration, can someone help me find
> > the problem?
> >
> > Thank you in advance!
> >
> > Best Regards!
> > __________________________________________________________
> > Kamailio - Users Mailing List - Non Commercial Discussions
> > To unsubscribe send an email to [email protected]
> > Important: keep the mailing list in the recipients, do not reply only to
> > the sender!
> > Edit mailing list options or unsubscribe:
> >
>
>
> --
> *TLC 4.0*: 20 anni di *esperienza* al tuo servizio per sviluppare *soluzioni
> voce e dati innovative*
> Paolo Visintin
>
> *evoseed s.r.l.*
>
> phone: +39 346 09 86 641
> mail: [email protected]
> site: evoseed.io
> address: Via Lucrezio 13, Trieste ItalyFissa
> <https://calendly.com/paolo-visintin-evoseed/30min> una call con me
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Telecommunications Association License No. A-18-9191
Government Resell License No. 301039703002
WATS CO.,LTD.
Kawana Bldg, 5F Kamata
Ota-ku Tokyo, 144-0052 JAPAN
Phone 81-50-5830-5940
Ext&Mobile：201 VoiceMailDirect：201*1
FAX 81-50-5830-5941
http://wats.gr.jp
Mail： wats @ wats.gr.jp
Please remove the space between @ as double side
Key fingerprint = B53D FF2F BFEA FDA8 1439 38AA 8281 9A3E C9B6 2FC9
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe:
