6 Apr
2023
6 Apr
'23
4:04 p.m.
Hi
Give it a try without modparams to see if it works, I have the same
config but without modparams and it runs without problems.
Else have a look into the kamailio logfile for errors.
Or check config with "kamailio -c"?
Regards
Stefan
Am 06.04.23 um 15:18 schrieb georgy.grigoryev(a)snapcom.fr:
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 sr-users-leave(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only
to the sender!
Edit mailing list options or unsubscribe:
7 Apr
7 Apr
1:46 p.m.
Hello,
I added the modparams because i thought i needed them.
Withough the modparams it's the same thing!
Sadly, the logs are not much of help.
2:49 p.m.
Kamailio only works if i change the WITH_PGSQL to WITH_MYSQL
#!ifdef WITH_MYSQL
#!define DBURL "postgres://USER:PASS@IP:PORT/kamailio"
#!endif
but no data is being sent
391
days inactive
392
days old
2 comments
2 participants
participants (2)
-
georgy.grigoryev＠snapcom.fr -
Stefan