[SR-Users] db.c can't find dp_postgressql

Phillip Thern phil at thern.wtf
Fri Jul 22 20:52:03 CEST 2022


      so, I don't actually know if my previous message found you, or if
      you replied, since my syslog suddenly grew to 26 GB and my server
      couldn't receive any mail because of it...



      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/3b777949/attachment.htm>


More information about the sr-users mailing list