[SR-Users] Bad config - you can not call 'handle_publish' function (db_url not set)

Mon May 10 19:10:38 CEST 2021

Hello,

do you use utils module? If yes, what is your operating system and the
compiler version (if you compiled from sources, not installing from
packages)?

Cheers,
Daniel

On 10.05.21 15:01, Marrold wrote:
> Hi,
>
> We're trying to upgrade from 5.3.X to 5.4.5 however kamailio will not
> start and produces the following error, despite the db_url being set
> in the config and printed in the logs:
>
> Bad config - you can not call 'handle_publish' function (db_url not set)
>
> Looking at the code this error only seems plausible if the
> /pres_library_mode/ is set to 1 here
> <https://github.com/kamailio/kamailio/blob/cc2a9518207e36b7b18aef5c8714f0c21da3dd95/src/modules/presence/presence.c#L296> but
> we don't see the corresponding "switch to library mode" message in the
> debug logs which leaves me a bit stuck - I've included the grepped
> logs at the bottom of the message.
>
> Does anyone have any ideas what is causing this issue? I've seen a
> previous issue relating to interactions between presence and
> presence_xml which we're also using, but it looks like this was fixed
> in an older version.
>
> Any suggestions appreciated.
>
> # ----- presence params -----
> modparam("presence", "db_url", DBURL)
> modparam("presence", "db_update_period", 20)
> modparam("presence", "clean_period", 60)
> modparam("presence", "local_log_facility", "LOG_LOCAL3")
> modparam("presence", "max_expires", 14430)
>
> # ----- presence_xml params -----
> modparam("presence_xml", "db_url", DBURL)
> modparam("presence_xml", "force_active", 1)
>
> root at kamailio:/etc/kamailio# grep -i "presence"
> /var/log/kamailio/kamailio.log
> May 10 12:44:14 kamailio /sbin/kamailio[23729]: ERROR: presence
> [presence.c:656]: fixup_presence(): Bad config - you can not call
> 'handle_publish' function (db_url not set)
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.y:1810]:
> yyparse(): loading module presence.so
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:525]: load_module(): trying to load
> </lib64/kamailio/modules/presence.so>
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/kemi.c:2927]:
> sr_kemi_modules_add(): adding module: presence
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:287]: register_module(): register PV from: presence
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.lex:1796]:
> pp_define(): defining id: MOD_presence
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.y:1810]:
> yyparse(): loading module presence_xml.so
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:525]: load_module(): trying to load
> </lib64/kamailio/modules/presence_xml.so>
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/kemi.c:2927]:
> sr_kemi_modules_add(): adding module: presence_xml
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.lex:1796]:
> pp_define(): defining id: MOD_presence_xml
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.y:1810]:
> yyparse(): loading module presence_mwi.so
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:525]: load_module(): trying to load
> </lib64/kamailio/modules/presence_mwi.so>
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.lex:1796]:
> pp_define(): defining id: MOD_presence_mwi
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.y:1810]:
> yyparse(): loading module presence_dialoginfo.so
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:525]: load_module(): trying to load
> </lib64/kamailio/modules/presence_dialoginfo.so>
> May 10 12:44:41 kamailio kamailio: DEBUG: <core> [core/cfg.lex:1796]:
> pp_define(): defining id: MOD_presence_dialoginfo
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence' matches
> module 'presence'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <db_url> in module
> presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <db_url> in module
> presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence' matches
> module 'presence'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <db_update_period>
> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <db_update_period>
> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence' matches
> module 'presence'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <clean_period> in
> module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <clean_period> in
> module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence' matches
> module 'presence'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found
> <local_log_facility> in module presence
> [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found
> <local_log_facility> in module presence
> [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence' matches
> module 'presence'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <max_expires> in
> module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <max_expires> in
> module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence_xml' matches
> module 'presence_xml'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <db_url> in module
> presence_xml [/lib64/kamailio/modules/presence_xml.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <db_url> in module
> presence_xml [/lib64/kamailio/modules/presence_xml.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:107]: set_mod_param_regex(): 'presence_xml' matches
> module 'presence_xml'
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:744]: find_param_export(): found <force_active> in
> module presence_xml [/lib64/kamailio/modules/presence_xml.so]
> May 10 12:44:41 kamailio kamailio: DEBUG: <core>
> [core/modparam.c:123]: set_mod_param_regex(): found <force_active> in
> module presence_xml [/lib64/kamailio/modules/presence_xml.so]
> May 10 12:44:43 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:652]: find_mod_export_record(): found export of
> <handle_publish> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:43 kamailio kamailio: DEBUG: <core>
> [core/sr_module.c:652]: find_mod_export_record(): found export of
> <handle_subscribe> in module presence
> [/lib64/kamailio/modules/presence.so]
> May 10 12:44:43 kamailio kamailio: DEBUG: <core> [core/route.c:129]:
> route_add(): mapping routing block (0x560e73f9a440)[PRESENCE] to 11
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:873]: init_mod(): presence
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [presence.c:293]: mod_init():
> db_url=mysql://kamailio:PASSWORD@localhost/kamailio (len=50
> addr=0x7f3a33d4e288)
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [presence.c:337]: mod_init(): server_address parameter not set in
> configuration file
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [subscribe.c:2529]: restore_db_subs(): loading information from
> database 0 records
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:873]: init_mod(): presence_xml
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence_xml
> [presence_xml.c:170]: mod_init():
> db_url=mysql://kamailio:PASSWORD@localhost/kamailio (len=50
> addr=0x7f3a33d4ef00)
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:652]: find_mod_export_record(): found export of
> <bind_presence> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [presence/1]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [presence.winfo/2]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:239]: add_event(): successfully added event: presence -
> len= 8
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence_xml
> [add_events.c:75]: xml_add_events(): added 'presence' event to
> presence module
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [presence.winfo/2]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [presence/1]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:188]: add_event(): Found wipeer event [presence] for
> event [presence.winfo]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:239]: add_event(): successfully added event:
> presence.winfo - len= 14
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence_xml
> [add_events.c:94]: xml_add_events(): added 'presence.winfo' event to
> presence module
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [xcap-diff/0]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [xcap-diff.winfo/0]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:239]: add_event(): successfully added event: xcap-diff -
> len= 9
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence_xml
> [add_events.c:132]: xml_add_events(): added 'xcap-diff' event to
> presence module
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:873]: init_mod(): presence_mwi
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:652]: find_mod_export_record(): found export of
> <bind_presence> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [message-summary/6]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [message-summary.winfo/0]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:239]: add_event(): successfully added event:
> message-summary - len= 15
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:873]: init_mod(): presence_dialoginfo
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: <core>
> [core/sr_module.c:652]: find_mod_export_record(): found export of
> <bind_presence> in module presence [/lib64/kamailio/modules/presence.so]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [dialog/5]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:324]: search_event(): start event= [dialog.winfo/0]
> May 10 12:44:45 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [event_list.c:239]: add_event(): successfully added event: dialog - len= 6
> May 10 12:44:47 kamailio /sbin/kamailio[23830]: ERROR: presence
> [presence.c:656]: fixup_presence(): Bad config - you can not call
> 'handle_publish' function (db_url not set)
> May 10 12:44:47 kamailio /sbin/kamailio[23830]: DEBUG: presence_xml
> [presence_xml.c:295]: destroy(): start
> May 10 12:44:47 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [subscribe.c:2433]: timer_db_update(): db_update timer
> May 10 12:44:47 kamailio /sbin/kamailio[23830]: DEBUG: presence
> [subscribe.c:2137]: update_db_subs_timer(): update_db_subs_timer: start
>
>
>
>
>
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
>   * sr-users at 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

-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Online
May 17-20, 2021 (Europe Timezone) - June 7-10, 2021 (America Timezone)
  * https://www.asipto.com/sw/kamailio-advanced-training-online/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20210510/74aa748f/attachment.htm>