sr-dev June 2019

sr-dev@lists.kamailio.org

19 participants
217 discussions

[kamailio/kamailio] DB_UNIXODBC always changes language and context (#1993)
by Ben Kaufman 03 Jul '19

03 Jul '19

### Description Using DB_UNIXODBC with an Azure SQL database works, however when starting Kamailio, errors are shown for : ``` 26(80403) ERROR: db_unixodbc [connection.c:219]: db_unixodbc_extract_error(): unixodbc:SQLDriverConnect=01000:3:5701:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'database-name'. ERROR: db_unixodbc [connection.c:219]: db_unixodbc_extract_error(): unixodbc:SQLDriverConnect=01000:2:5703:[unixODBC][Microsoft][ODBC Driver 17 for SQL … [View More]Server][SQL Server]Changed language setting to us_english. ``` Regarding changing the DB context, the database to be used is defined in my ```odbc.ini``` file ``` [dsnName] Driver=ODBC Driver 17 for SQL Server Description=Azure MS SQL Server Trace=No Server=tcp:azure-sql-server-name.database.windows.net,1433 Encrypt=yes TrustServerCertificate=no Connection Timeout=30 Database=databaseName ``` I'm not able to `USE databaseName` when connecting to an Azure DB. The default language is already US-English, and i'm guessing it's also Azure specific that it cannot be changed? ### Troubleshooting I'm not sure what troubleshooting can be done with this. The DB connection works, it's just these commands that fail, but since the result is already correct, it doesn't seem to functionally matter, aside from the errors being thrown. #### Reproduction This can be reproduced using an Azure SQL database. Create a single database and a dedicated user (with db_owner membership), and configure the ODBC connection as above. #### Debugging Data I'm not sure any additional debugging information is available. I'm happy to provide anything specific requested. #### Log Messages ``` 26(80403) ERROR: db_unixodbc [connection.c:219]: db_unixodbc_extract_error(): unixodbc:SQLDriverConnect=01000:3:5701:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed database context to 'database-name'. ERROR: db_unixodbc [connection.c:219]: db_unixodbc_extract_error(): unixodbc:SQLDriverConnect=01000:2:5703:[unixODBC][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Changed language setting to us_english. ``` ### Possible Solutions I would suspect that a parameter could be added to the DB_UNIXODBC module to make each of these behaviors (changing database and changing language) optional. Default config would retain the existing behavior, so it's just an override if desired. ### Additional Information * **Kamailio Version** - output of `kamailio -v` ``` version: kamailio 5.1.8 (x86_64/linux) flags: STATS: Off, USE_TCP, USE_TLS, USE_SCTP, TLS_HOOKS, USE_RAW_SOCKS, 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_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 6.3.0 ``` * **Operating System**: ``` Debian Stretch: 4.19.0-0.bpo.4-cloud-amd64 #1 SMP Debian 4.19.28-2~bpo9+1 (2019-03-27) 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/1993 [View Less]

4 7

[kamailio/kamailio] usrloc: fix memory leak on DB_ONLY mode on RPC commands (#1996)
by Victor Seva 02 Jul '19

02 Jul '19

<!-- IMPORTANT: - for detailed contributing guidelines, read: https://github.com/kamailio/kamailio/blob/master/.github/CONTRIBUTING.md - pull requests must be done to master branch, unless they are backports of fixes from master branch to a stable branch - backports to stable branches must be done with 'git cherry-pick -x ...' - code is contributed under BSD for core and main components (tm, sl, auth, tls) - code is contributed … [View More]

2 1

new child module for kamailio, is call "lre"
by Mojtaba 02 Jul '19

02 Jul '19

Hello Everyone, In the middle of developing hiops module, another child module has grown up. I've been developing another module for Kamailio, I called this "lre". It means light-rtp-engine. The concept of this module is using the capability of linux-Kernel packet forwarding to forward RTP packets between both parties in a session call. As far as we know, this new way has some advantage in large VoIP networks that are using Kamailio as Proxy or SBC. Regardless of transcoding, it could be done … [View More]

3 4

[kamailio/kamailio] After commit ce8d36f latency_limit_db requires us instead of ms (#1956)
by Marco Capetta 02 Jul '19

02 Jul '19

Long time ago I have added in the configuration: latency_limit_db=500 After the upgrade from version 5.1.7 to version 5.1.8, kamailio started printing a lot of log lines related to db slow query: <core> [db_query.c:68]: db_do_submit_query(): alert - query execution too long [1136 us] <core> [db_query.c:68]: db_do_submit_query(): alert - query execution too long [914 us] <core> [db_query.c:68]: db_do_submit_query(): alert - query execution too long [741 us] <core> [… [View More]

4 10

[kamailio/kamailio] uac module documentation should be honor s: prefix for kamcmd (#1988)
by Karsten Horsmann 01 Jul '19

01 Jul '19

Many sr-users seems to have the same problem with the documentation of uac module for requesting the actuall state of upstream sip-registrations. ### Description kamcmd uac.reg_enable auth_username 12345678 Not working kamcmd uac.reg_enable auth_username s:12345678 Working ### Expected behavior Documentation should meantion the kamcmd s: prefix for converting - in the examples. Meanfull if you are using a mysql-db. Dont testet all backends that are possible. https://lists.kamailio.org/… [View More]

2 2

[kamailio/kamailio] uri.param and param.value error when last character is delimiter (#1991)
by geejay101 01 Jul '19

01 Jul '19

### Description I am trying to extract a parameter with transformations from an URI in Kamailio 5.2.3, Centos 7 The problem occurs with uri.param and param.value transformation when the last character of the input string is the separator. I such case an error is thrown and no parameter value can be received. The code should be fixed so that empty parameters are simply skipped. # Example $var(someuri) = "sip:2660926042@23.26.41.95:65485;app-id=7537263245341023;"; # error with uri.param $var(… [View More]

2 4

git:master:0ff8ab02: lib: add missing line-break in DB init function error log
by Henning Westerholt 30 Jun '19

30 Jun '19

Module: kamailio Branch: master Commit: 0ff8ab02704f7c096464d49a9f697ebeaf99935e URL: https://github.com/kamailio/kamailio/commit/0ff8ab02704f7c096464d49a9f697eb… Author: Henning Westerholt <hw(a)skalatan.de> Committer: Henning Westerholt <hw(a)skalatan.de> Date: 2019-06-30T17:49:25+02:00 lib: add missing line-break in DB init function error log --- Modified: src/lib/srdb1/db.c --- Diff: https://github.com/kamailio/kamailio/commit/0ff8ab02704f7c096464d49a9f697eb… Patch: … [View More]

1 0

git:5.1:97cd5d01: call_control: add a note that the callcontrol application expect the MI interface
by Henning Westerholt 30 Jun '19

30 Jun '19

Module: kamailio Branch: 5.1 Commit: 97cd5d01bf07ef4bb4ede589ea453acfdc2806ff URL: https://github.com/kamailio/kamailio/commit/97cd5d01bf07ef4bb4ede589ea453ac… Author: Henning Westerholt <hw(a)skalatan.de> Committer: Henning Westerholt <hw(a)skalatan.de> Date: 2019-06-30T11:54:31+02:00 call_control: add a note that the callcontrol application expect the MI interface (cherry picked from commit 62d607f29593bcd645c7d068327e0bd4a0db0a8f) --- Modified: src/modules/call_control/doc/… [View More]

1 0

git:5.2:baf9e9fb: call_control: add a note that the callcontrol application expect the MI interface
by Henning Westerholt 30 Jun '19

30 Jun '19

Module: kamailio Branch: 5.2 Commit: baf9e9fbfcf3be043085a649eec3f396213bcb5c URL: https://github.com/kamailio/kamailio/commit/baf9e9fbfcf3be043085a649eec3f39… Author: Henning Westerholt <hw(a)skalatan.de> Committer: Henning Westerholt <hw(a)skalatan.de> Date: 2019-06-30T11:54:21+02:00 call_control: add a note that the callcontrol application expect the MI interface (cherry picked from commit 62d607f29593bcd645c7d068327e0bd4a0db0a8f) --- Modified: src/modules/call_control/doc/… [View More]

1 0

git:master:62d607f2: call_control: add a note that the callcontrol application expect the MI interface
by Henning Westerholt 30 Jun '19

30 Jun '19

Module: kamailio Branch: master Commit: 62d607f29593bcd645c7d068327e0bd4a0db0a8f URL: https://github.com/kamailio/kamailio/commit/62d607f29593bcd645c7d068327e0bd… Author: Henning Westerholt <hw(a)skalatan.de> Committer: Henning Westerholt <hw(a)skalatan.de> Date: 2019-06-30T11:51:57+02:00 call_control: add a note that the callcontrol application expect the MI interface --- Modified: src/modules/call_control/doc/call_control_admin.xml --- Diff: https://github.com/kamailio/… [View More]

1 0

← Newer
1
...
6
7
8
9
10
11
12
...
22
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev June 2019