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@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@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
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.
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
-
georgy.grigoryev＠snapcom.fr -
Stefan