[sr-dev] [kamailio/kamailio] when using db_text, can't use relative path, only full path is working in kamailio 4.4 (#1224)

Jurijs Ivolga notifications at github.com
Thu Aug 31 09:58:48 CEST 2017


<!--
Kamailio Project uses GitHub Issues only for bugs in the code or feature requests.

If you have questions about using Kamailio or related to its configuration file,
ask on sr-users mailing list:

  * http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

If you have questions about developing extensions to Kamailio or its existing
C code, ask on sr-dev mailing list

  * http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

Please try to fill this template as much as possible for any issue. It helps the
developers to troubleshoot the issue.

If you submit a feature request (or enhancement), you can delete the text of
the template and only add the description of what you would like to be added.

If there is no content to be filled in a section, the entire section can be removed.

You can delete the comments from the template sections when filling.

You can delete next line and everything above before submitting (it is a comment).
-->

### Description

when using db_text, can't use relative path, only full path is working in kamailio 4.4

modparam("lcr", "db_url", "text://dbtext") -- do not work

modparam("lcr", "db_url", "text:///usr/local/etc/kamailio/dbtext") -- works as expected


### Troubleshooting

#### Reproduction

<!--
If the issue can be reproduced, describe how it can be done.
-->

#### Debugging Data

<!--
If you got a core dump, use gdb to extract troubleshooting data - full backtrace,
local variables and the list of the code at the issue location.

  gdb /path/to/kamailio /path/to/corefile
  bt full
  info locals
  list

If you are familiar with gdb, feel free to attach more of what you consider to
be relevant.
-->

```
(paste your debugging data here)
```

#### Log Messages

<!--
Check the syslog file and if there are relevant log messages printed by Kamailio, add them next, or attach to issue, or provide a link to download them (e.g., to a pastebin site).
-->

```
 0(1) DEBUG: db_text [dbt_file.c:104]: dbt_load_file(): db is [/usr/local/etc/kamailio/]
 0(1) DEBUG: db_text [dbt_file.c:119]: dbt_load_file(): loading file [/usr/local/etc/kamailio/]
 0(1) DEBUG: db_text [dbt_tb.c:181]: dbt_table_new(): mtime is 1504165928
 0(1) ERROR: db_text [dbt_base.c:215]: dbt_query(): table version not loaded! (too few columns)
 0(1) ERROR: db_text [dbt_base.c:357]: dbt_query(): failed to query the table!
 0(1) ERROR: <core> [db.c:397]: db_table_version(): error in db_query
 0(1) ERROR: <core> [db.c:436]: db_check_table_version(): querying version for table lcr_rule
 0(1) ERROR: lcr [lcr_mod.c:649]: mod_init(): error during table version check
 0(1) ERROR: <core> [sr_module.c:967]: init_mod(): Error while initializing module lcr (/usr/local/lib64/kamailio/modules/lcr.so)

```

#### SIP Traffic

<!--
If the issue is exposed by processing specific SIP messages, grab them with ngrep or save in a pcap file, then add them next, or attach to issue, or provide a link to download them (e.g., to a pastebin site).
-->

```
(paste your sip traffic here)
```

### Possible Solutions

<!--
If you found a solution or workaround for the issue, describe it. Ideally, provide a pull request with a fix.
-->

use full path

### Additional Information

  * **Kamailio Version** - output of `kamailio -v`

```
version: kamailio 4.4.6 (x86_64/linux) 897942
flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, 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
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 8MB
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
id: 897942
compiled on 06:27:57 Aug 31 2017 with gcc 6.3.0

```

* **Operating System**:

<!--
Details about the operating system, the type: Linux (e.g.,: Debian 8.4, Ubuntu 16.04, CentOS 7.1, ...), MacOS, xBSD, Solaris, ...;
Kernel details (output of `uname -a`)
-->

```
Debian GNU/Linux 9 \n \l

4.4.0-87-generic #110-Ubuntu SMP Tue Jul 18 12:55:35 UTC 2017 x86_64 GNU/Linux

```


-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1224
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20170831/4a076085/attachment-0001.html>


More information about the sr-dev mailing list