<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'Sans Serif'; font-size:10pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Never mind. A stupid mistake on my part. I should have just copied from my working 2.4.5 instead of relying on faulty memory.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On Monday, October 14, 2019 7:32:18 P.M. PDT Robert Dyck wrote:<br /></p>
<p style=" margin-top:12px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">I am test driving 3.0.1. Using menuconfig I compiled the core, the default modules and extra modules mysql, presence, presence_xml and xcap.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Using menuconfig I generated a residential script with auth and presence. I want to use db_text with this minimal installation. I tweaked the configuration to load the db_text module and the db_url. The configuration appears to be correct as far as syntax is concerned. I recycled the "subscriber" table from a working 2.4.5 installation.</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Usrloc does not initialize at runtime. Where have I gone wrong?</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">modparam("usrloc", "working_mode_preset", "single-instance-sql-write-back") </span><span style=" font-family:'monospace';"><br />modparam("usrloc", "db_url", <br /># "mysql://opensips:opensipsrw@localhost/opensips") # CUSTOMIZE ME <br /> "textdb:///usr/share/opensips/dbtext/opensips")<br /></span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><span style=" font-family:'monospace'; color:#000000; background-color:#ffffff;">modparam("auth_db", "db_url", </span><span style=" font-family:'monospace';"><br /># "mysql://opensips:opensipsrw@localhost/opensips") # CUSTOMIZE ME <br /> "dbtext:///usr/share/opensips/dbtext/opensips")<br /></span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:init_mod: register MI for db_text</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:init_mod: initializing module usrloc</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:usrloc:mod_init: initializing</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:usrloc:check_runtime_config: ul config: db_mode=-1, cluster_mode=0, rrp=1, sql_wm=2</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] INFO:usrloc:ul_init_locks: locks array size 512</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_bind_api> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:db_bind_mod: using export interface to bind db_textdb</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_use_table> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_init> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_close> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_query> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_fetch_result> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_raw_query> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_free_result> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_insert> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_delete> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_update> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_replace> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_last_inserted_id> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] DBG:core:find_mod_export: <db_insert_update> in module db_textdb not found</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] ERROR:core:db_check_api: module db_textdb does not export db_use_table function</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] ERROR:usrloc:mod_init: failed to bind database module</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:40px; margin-right:40px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Oct 14 19:12:07 [16761] ERROR:core:init_mod: failed to initialize module usrloc</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br /><br /></p></body></html>