Hi,

Kamailio gets the module name from the database url. Somewhere in your config, you are using a postgresql:// url. Change it to postgres://

On 22 July 2022 6:52:03 pm UTC, Phillip Thern <phil@thern.wtf> wrote:

so, I don't actually know if my previous message found you, or if you replied, since my syslog suddenly grew to 26 GB and my server couldn't receive any mail because of it...


Description

I loaded module "db_postgres.so". I expected kamilio to start. It didn't

Troubleshooting

Reproduction

config file

#!KAMAILIO
#!define WITH_POSTGRESSQL
#!define WITH_AUTH
#!define WITH_USRLOCDB
#!define WITH_PRESENCE
#!define WITH_MSGREBUILD
#!define WITH_NAT
#!define WITH_NATSIPPING
.
.
.
#!ifdef WITH_POSTGRESSQL
loadmodule "db_postgres.so"
#!endif

Log Messages

Jul 22 10:31:16 opensips /usr/sbin/kamailio[8975]: ERROR: <core> [db.c:204]: db_bind_mod(): Module db_postgresql not found. Missing loadmodule? 
Jul 22 10:31:16 opensips /usr/sbin/kamailio[8975]: ERROR: usrloc [usrloc_mod.c:361]: mod_init(): failed to bind database module
Jul 22 10:31:16 opensips /usr/sbin/kamailio[8975]: ERROR: <core> [core/sr_module.c:942]: init_mod(): Error while initializing module usrloc (/usr/lib/x86_64-linux-gnu/kamailio/modules/usrloc.so)


output from ls of modules directory:

acc.so		  call_obj.so	   dialog.so	    ipops.so	   msrp.so	     presence_conference.so  qos.so	   sipcapture.so  statsd.so	   uid_avp_db.so
acc_diameter.so   carrierroute.so  dialplan.so	    jsonrpcs.so    mtree.so	     presence_dialoginfo.so  ratelimit.so  sipdump.so	  stun.so	   uid_domain.so
alias_db.so	  cfg_db.so	   dispatcher.so    keepalive.so   nat_traversal.so  presence_mwi.so	     regex.so	   sipjson.so	  tcpops.so	   uid_gflags.so
app_jsdt.so	  cfg_rpc.so	   diversion.so     kemix.so	   nathelper.so      presence_profile.so     registrar.so  sipt.so	  textops.so	   uid_uri_db.so
app_sqlang.so	  cfgt.so	   dmq.so	    kex.so	   nosip.so	     presence_reginfo.so     rls.so	   siptrace.so	  textopsx.so	   uri_db.so
async.so	  cfgutils.so	   dmq_usrloc.so    lcr.so	   outbound.so	     presence_xml.so	     rr.so	   siputils.so	  timer.so	   userblocklist.so
auth.so		  corex.so	   domain.so	    log_custom.so  p_usrloc.so	     pua.so		     rtimer.so	   sl.so	  tm.so		   usrloc.so
auth_db.so	  counters.so	   domainpolicy.so  lrkproxy.so    path.so	     pua_bla.so		     rtjson.so	   sms.so	  tmrec.so	   xcap_client.so
auth_diameter.so  ctl.so	   drouting.so	    mangler.so	   pdb.so	     pua_dialoginfo.so	     rtpengine.so  smsops.so	  tmx.so	   xcap_server.so
auth_xkeys.so	  db2_ops.so	   enum.so	    matrix.so	   pdt.so	     pua_reginfo.so	     rtpproxy.so   speeddial.so   topoh.so	   xhttp.so
avp.so		  db_cluster.so    evrexec.so	    maxfwd.so	   permissions.so    pua_rpc.so		     sanity.so	   sqlops.so	  topos.so	   xhttp_prom.so
avpops.so	  db_flatstore.so  exec.so	    mediaproxy.so  pike.so	     pua_usrloc.so	     sca.so	   ss7ops.so	  tsilo.so	   xhttp_rpc.so
benchmark.so	  db_postgres.so   group.so	    mohqueue.so    pipelimit.so      pua_xmpp.so	     sdpops.so	   sst.so	  uac.so	   xlog.so
blst.so		  db_text.so	   htable.so	    mqueue.so	   prefix_route.so   pv.so		     seas.so	   statistics.so  uac_redirect.so  xprint.so
call_control.so   debugger.so	   imc.so	    msilo.so	   presence.so	     pv_headers.so	     secfilter.so  statsc.so	  uid_auth_db.so

Possible Solutions

tried renaming db_postgres.so to db_postgresql.so, but that didn't work, so I reversed it

Additional Information

version: kamailio 5.5.4 (x86_64/linux) 
flags: USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MMAP, PKG_MALLOC, Q_MALLOC, F_MALLOC, TLSF_MALLOC, DBG_SR_MEMORY, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT, USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLOCKLIST, HAVE_RESOLV_RES, TLS_PTHREAD_MUTEX_SHARED
ADAPTIVE_WAIT_LOOPS 1024, MAX_RECV_BUFFER_SIZE 262144, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: unknown 
compiled with gcc 10.2.1

Distributor ID:	Debian
Description:	Debian GNU/Linux 11 (bullseye)
Release:	11
Codename:	bullseye

Linux opensips 5.10.0-16-amd64 #1 SMP Debian 5.10.127-1 (2022-06-30) x86_64 GNU/Linux

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.