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

[Tim Anderson]

Hi,

Kamailio gets the module name from the database url. Somewhere in your config, you are using a postgresql:// url. Change it to postgres://

On 22 July 2022 6:52:03 pm UTC, Phillip Thern <phil at thern.wtf> wrote:
>
>      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 |

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20220723/eff72590/attachment.htm>