[SR-Users] Module db_postgresql not found

[Phillip Thern]

      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 |
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20220722/da8ebd9f/attachment.htm>