[prev in list] [next in list] [prev in thread] [next in thread]
List: serusers
Subject: [SR-Users] Module db_postgresql not found
From: Phillip Thern <phil () thern ! wtf>
Date: 2022-07-22 10:52:13
Message-ID: f8984bd1-4ce9-b1c6-6655-5754b1e51e77 () thern ! wtf
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 |
[Attachment #5 (text/html)]
<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>
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
* sr-users@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
* https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic