<p></p>
<h3 dir="auto">Description</h3>
<p dir="auto">Unexpected behavior when using db_text.so</p>
<h4 dir="auto">Debugging Data</h4>
<pre class="notranslate"><code class="notranslate">root@kamailio:/usr/lib/x86_64-linux-gnu/kamailio/kamctl# grep -r DB_PATH *
kamdbctl.dbtext:if [ -z "$DB_PATH" ] ; then
kamdbctl.dbtext:        DB_PATH="/usr/local/etc/kamailio/dbtext"
kamdbctl.dbtext:DB_PATH=$1
kamdbctl.dbtext:minfo "DBTEXT ... erasing all files at: $DB_PATH"
kamdbctl.dbtext:rm -rf $DB_PATH
kamdbctl.dbtext:        merr "kamailio_create function takes one param (DB_PATH)"
kamdbctl.dbtext:DB_PATH=$1
kamdbctl.dbtext:minfo "creating DBTEXT tables at: $DB_PATH ..."
kamdbctl.dbtext:mkdir -p $DB_PATH
kamdbctl.dbtext:    cp $DB_SCHEMA/$TABLE $DB_PATH/$TABLE
kamdbctl.dbtext:        merr "presence_create function takes one param (DB_PATH)"
kamdbctl.dbtext:DB_PATH=$1
kamdbctl.dbtext:minfo "creating DBTEXT presence tables at: $DB_PATH ..."
kamdbctl.dbtext:mkdir -p $DB_PATH
kamdbctl.dbtext:    cp $DB_SCHEMA/$TABLE $DB_PATH/$TABLE
kamdbctl.dbtext:minfo "creating DBTEXT extra tables at: $DB_PATH ..."
kamdbctl.dbtext:    cp $DB_SCHEMA/$TABLE $DB_PATH/$TABLE
</code></pre>
<pre class="notranslate"><code class="notranslate">root@kamailioz99s1:/usr/lib/x86_64-linux-gnu/kamailio/kamctl# grep -r DBTEXT_PATH *
dbtextdb/dbtextdb.py:    if 'DBTEXT_PATH' not in os.environ or not os.environ['DBTEXT_PATH']:
dbtextdb/dbtextdb.py:        print('DBTEXT_PATH must be set')
dbtextdb/dbtextdb.py:        location = os.environ['DBTEXT_PATH']
kamctl.dbtext:  DBTEXT_PATH="$MYLIBDIR/dbtext/kamailio/"
kamctl.dbtext:if [ -z "$DBTEXT_PATH" ] ; then
kamctl.dbtext:  DBTEXT_PATH="/usr/share/kamailio/dbtext/kamailio"
kamctl.dbtext:export DBTEXT_PATH
</code></pre>
<h3 dir="auto">Possible Solutions</h3>
<p dir="auto">The simplest way to fix it is to add the lines to the file <code class="notranslate">kamctlrc</code></p>
<pre class="notranslate"><code class="notranslate">root@kamailioz99s1:~/backup/orig# diff kamctlrc kamctlrc.orig
32,34d31
< # database path used by kamctl.dbtext and dbtextdb.py
< # DBTEXT_PATH="/usr/local/etc/kamailio/dbtext"
<
</code></pre>
<h3 dir="auto">Additional Information</h3>
<ul dir="auto">
<li><strong>Kamailio Version</strong> - output of <code class="notranslate">kamailio -v</code></li>
</ul>
<pre class="notranslate"><code class="notranslate">version: kamailio 5.3.9 (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_BLACKLIST, 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 7.5.0
</code></pre>
<ul dir="auto">
<li><strong>Operating System</strong>:</li>
</ul>
<pre class="notranslate"><code class="notranslate">DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=18.04
DISTRIB_CODENAME=bionic
DISTRIB_DESCRIPTION="Ubuntu 18.04.6 LTS"
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/3170">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/ABO7UZOKG6AM6F6HFLZSBY3VRQRUHANCNFSM52FHY7QQ">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/ABO7UZLW2Q4PNTI77WUNALTVRQRUHA5CNFSM52FHY7Q2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4TGNFJ3A.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><kamailio/kamailio/issues/3170</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/kamailio/kamailio/issues/3170",
"url": "https://github.com/kamailio/kamailio/issues/3170",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>