[sr-dev] [kamailio/kamailio] htable with per-table column names won't let kamailio start (#948)

[Sebastian Damm]

### Description
<!--
Explain what you did, what you expected to happen, and what actually happened.
-->

When trying to use a htable with column names different than globally configured, Kamailio won't start.

### Troubleshooting

#### Reproduction

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

* Take Kamailio with a sample configuration.
* Enable htable and db_mysql module.
* In your Kamailio database, execute the following statements:
`create table htable_different like htable;`
` alter table htable_different change key_name foo_name varchar(64) not null default '';`
* Now you have a table looking almost as the sample htable table, but with a changed column name for the key name column.

* Add the following configuration parameters:
`modparam("htable", "db_url", "mysql://user:password@127.0.0.1/ser")`
`modparam("htable", "htable", 'foo=>size=4;dbtable=htable_different;cols="foo_name,key_value";')`
* Try starting Kamailio. It will fail with the following error:
` ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'key_name' in 'order clause' (1054)`
#### Debugging Data

When running an an ngrep trace while starting Kamailio, you can see the following statement:
```
T 2017/01/24 22:29:58.603428 127.0.0.1:53843 -> 127.0.0.1:3306 [AP]
I....select `foo_name`,`key_value` from `htable_different`  order by key_name

T 2017/01/24 22:29:58.603555 127.0.0.1:3306 -> 127.0.0.1:53843 [AP]
4......#42S22Unknown column 'key_name' in 'order clause'
```

So when trying to read from the database, it correctly uses the changed column name in the select part, but uses the default column name in the order by part of the query.

### Additional Information

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

```
version: kamailio 4.4.5 (x86_64/linux) 
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: unknown 
compiled with gcc 4.9.2
```

* **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 8.6
Linux osboxes 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) 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/948
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20170124/df9eac33/attachment-0001.html>