<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <h3 dir="auto">Description</h3>
    <p dir="auto">I loaded module "db_postgres.so". I expected kamilio
      to start. It didn't</p>
    <h3 dir="auto">Troubleshooting</h3>
    <h4 dir="auto">Reproduction</h4>
    <h4 dir="auto">config file</h4>
    <div class="snippet-clipboard-content notranslate position-relative
      overflow-auto">
      <pre class="notranslate"><code>#!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

</code></pre>
    </div>
    <h4 dir="auto">Log Messages</h4>
    <div class="snippet-clipboard-content notranslate position-relative
      overflow-auto">
      <pre class="notranslate"><code>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)


</code></pre>
    </div>
    <p dir="auto">output from ls of modules directory:</p>
    <div class="snippet-clipboard-content notranslate position-relative
      overflow-auto">
      <pre class="notranslate"><code>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

</code></pre>
    </div>
    <h3 dir="auto">Possible Solutions</h3>
    <p dir="auto">tried renaming db_postgres.so to db_postgresql.so, but
      that didn't work, so I reversed it</p>
    <h3 dir="auto">Additional Information</h3>
    <ul dir="auto">
      <li><strong>Kamailio Version</strong> - output of <code
          class="notranslate">kamailio -v</code></li>
    </ul>
    <div class="snippet-clipboard-content notranslate position-relative
      overflow-auto">
      <pre class="notranslate"><code>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

</code></pre>
    </div>
    <ul dir="auto">
      <li><strong>Operating System</strong>:</li>
    </ul>
    <pre class="notranslate"><code>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

</code></pre>
  </body>
</html>