Module db_postgresql not found

[MenschLink]

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

• Kamailio Version - output of kamailio -v

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

• Operating System:

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

[linuxmaniac]

Being about kamailio usage and kamailio.cfg, this should be discussed further on sr-users@lists.kamailio.org till it gets a resolution of an issue in the code or a feature request.

[MenschLink]

sent it to the mailing list

[whitetreebug]

modparam("usrloc", "db_url", DBURL)
if you define DBURL like this "postgresql://..." , kamailio will export "Module db_postgresql not found"

DBURL "postgres://..."