[sr-dev] [kamailio/kamailio] Module db_postgresql not found (Issue #3196)

[MenschLink]

<!--
Kamailio Project uses GitHub Issues only for bugs in the code or feature requests. Please use this template only for bug reports.

If you have questions about using Kamailio or related to its configuration file, ask on sr-users mailing list:

  * http://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

If you have questions about developing extensions to Kamailio or its existing C code, ask on sr-dev mailing list:

  * http://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-dev

Please try to fill this template as much as possible for any issue. It helps the developers to troubleshoot the issue.

If there is no content to be filled in a section, the entire section can be removed.

You can delete the comments from the template sections when filling.

You can delete next line and everything above before submitting (it is a comment).
-->

### Description

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


### Troubleshooting

#### Reproduction

<!--
If the issue can be reproduced, describe how it can be done.
-->

#### 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

<!--
Check the syslog file and if there are relevant log messages printed by Kamailio, add them next, or attach to issue, or provide a link to download them (e.g., to a pastebin site).
-->

```
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

<!--
If you found a solution or workaround for the issue, describe it. Ideally, provide a pull request with a fix.
-->

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**:

<!--
Details about the operating system, the type: Linux (e.g.,: Debian 8.4, Ubuntu 16.04, CentOS 7.1, ...), MacOS, xBSD, Solaris, ...;
Kernel details (output of `lsb_release -a` and `uname -a`)
-->

```
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

```


-- 
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3196
You are receiving this because you are subscribed to this thread.

Message ID: <kamailio/kamailio/issues/3196 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20220722/4950ec9e/attachment.htm>