<h3>Description</h3>

<p>When trying to use a htable with column names different than globally configured, Kamailio won't start.</p>
<h3>Troubleshooting</h3>
<h4>Reproduction</h4>

<ul>
<li>
<p>Take Kamailio with a sample configuration.</p>
</li>
<li>
<p>Enable htable and db_mysql module.</p>
</li>
<li>
<p>In your Kamailio database, execute the following statements:<br>
<code>create table htable_different like htable;</code><br>
<code>alter table htable_different change key_name foo_name varchar(64) not null default '';</code></p>
</li>
<li>
<p>Now you have a table looking almost as the sample htable table, but with a changed column name for the key name column.</p>
</li>
<li>
<p>Add the following configuration parameters:<br>
<code>modparam("htable", "db_url", "mysql://user:password@127.0.0.1/ser")</code><br>
<code>modparam("htable", "htable", 'foo=>size=4;dbtable=htable_different;cols="foo_name,key_value";')</code></p>
</li>
<li>
<p>Try starting Kamailio. It will fail with the following error:<br>
<code>ERROR: db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query: Unknown column 'key_name' in 'order clause' (1054)</code></p>
</li>
</ul>
<h4>Debugging Data</h4>
<p>When running an an ngrep trace while starting Kamailio, you can see the following statement:</p>
<pre><code>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'
</code></pre>
<p>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.</p>
<h3>Additional Information</h3>
<ul>
<li><strong>Kamailio Version</strong> - output of <code>kamailio -v</code></li>
</ul>
<pre><code>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
</code></pre>
<ul>
<li><strong>Operating System</strong>:</li>
</ul>

<pre><code>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
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/948">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZVsXmv9qqJmsH5zIzLQmtDLZ_0Nwks5rVnyogaJpZM4Ls36m">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZWuUxZFxGhUl9qGlJtYYGt9O08kYks5rVnyogaJpZM4Ls36m.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/kamailio/kamailio/issues/948"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"htable with per-table column names won't let kamailio start (#948)"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/948"}}}</script>