<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,</p>
<p>thanks for reminder, actually I missed that email, not reading it
so far.</p>
<p>I just pushed a patch in master that should handle the blob/text
columns:</p>
<p> -
<a class="moz-txt-link-freetext" href="https://github.com/kamailio/kamailio/commit/24e729698017b5d898a92cdf7acb024e44252b84">https://github.com/kamailio/kamailio/commit/24e729698017b5d898a92cdf7acb024e44252b84</a></p>
<p>Can you test it? If all ok, then I will backport.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<br>
<div class="moz-cite-prefix">On 03.04.17 13:58, Ginhoux, Patrick
wrote:<br>
</div>
<blockquote
cite="mid:CO2PR07MB2519734EF46D36FAB8523906B6080@CO2PR07MB2519.namprd07.prod.outlook.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">Hi Daniel,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">Do you look at this error with the item type of
‘text’ in a mysql table?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Cordialement<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
Ginhoux, Patrick <br>
<b>Envoyé :</b> vendredi 24 mars 2017 10:44<br>
<b>À :</b> 'Kamailio (SER) - Users Mailing List'
<a class="moz-txt-link-rfc2396E" href="mailto:sr-users@lists.sip-router.org"><sr-users@lists.sip-router.org></a><br>
<b>Objet :</b> RE: [SR-Users] ht_db_load_table(): key
type must be string (type=6)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi
Daniel,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">I think that this key type problem has to do
with the type of ‘text’used for some fields in my myqsl db.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">By changing the type from ‘text’ to
varchar(256), the problem goes away.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">It is for sure just a workaround, that is ok
for me for the moment, but in the case people would need to
have text, we can get this problem back.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">I hope this help.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Cordialement<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
Ginhoux, Patrick <br>
<b>Envoyé :</b> mardi 21 mars 2017 13:29<br>
<b>À :</b> Kamailio (SER) - Users Mailing List <<a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><br>
<b>Objet :</b> RE: [SR-Users] ht_db_load_table(): key
type must be string (type=6)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">Below the structure of the properties table :<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">mysql> show create table properties;<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">| Table | Create
Table
|<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">| properties | CREATE TABLE `properties` (<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> `id` int(6) unsigned NOT NULL AUTO_INCREMENT
COMMENT 'UniqueID',<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> `key_name` text NOT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> `key_value` text NOT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> `value_type` int(1) NOT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> `key_type` int(1) NOT NULL,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"> PRIMARY KEY (`id`)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT
CHARSET=latin1 |<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US">1 row in set (0.02 sec)<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"
lang="EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Cordialement<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">De :</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
sr-users [<a moz-do-not-send="true"
href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>]
<b>De la part de</b> Daniel-Constantin Mierla<br>
<b>Envoyé :</b> mardi 21 mars 2017 13:25<br>
<b>À :</b> Kamailio (SER) - Users Mailing List <<a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>><br>
<b>Objet :</b> Re: [SR-Users] ht_db_load_table(): key
type must be string (type=6)<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Hello,<br>
<br>
can you give the structure of the table properties (show
create table ...)?<br>
<br>
Cheers,<o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Daniel<br>
<br>
March 21, 2017 11:30 AM, "Ginhoux, Patrick" <<a
moz-do-not-send="true"
href="mailto:%22Ginhoux,%20Patrick%22%20%3cpatrick.ginhoux@fr.unisys.com%3e"
target="_blank">patrick.ginhoux@fr.unisys.com</a>>
wrote:<o:p></o:p></span></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Hi,</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">A second update for people who
started to look at this issue.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">I have identified the real cause of
the problem by looking more in the kamailio log
with the debug traces. I discover that it is
related to the load of the properties table in the
htable.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">I have the following entries in my
mysql db :</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">+-------+----------------+---------------------------------------------------------+------------+----------+</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| id |
key_name | key_value | value_type | key_type |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">+-------+----------------+---------------------------------------------------------+------------+----------+</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 0 | VERSION |
120104-1734 | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 1 | mmm-retry |
408=Y;502=Y;503=Y | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 2 | mgcf-retry |
408=Y;502=Y;503=Y | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 3 | max-mmm-retry | 2 |
0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 4 | max-mgcf-retry | 2
| 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D">| 5 | target-uri |
mgcf=10.10.10.10;mmm-legacy=20.20.20.10;mmm=20.20.20.20
| 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| 6 |
pike-status | 503 Service Overload | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| 7 |
mgcf-path | 99 | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| 16 |
mmm-nodeid | OPMMMS1VSE01=1;OPMMMS1VSE02=2 | 0 | 0
|</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| 17 |
mmm-node-path | 1=1;2=2 | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">+-------+----------------+---------------------------------------------------------+------------+----------+</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-right:337.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">In the kamailio.cfg, the <<
modparam("htable", "htable",
"propertiesHash=>size=4;dbtable=properties;")
>> command causes the load of the above
table in the htable.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-right:337.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">In the log we can see, that the load
is done in the alphabetic order of the key_name
and it fails to load the last entry “VERSION” :</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:25:28 localhost
/usr/sbin/kamailio[5784]: DEBUG: <core>
[db_val.c:169]: db_str2val(): converting BLOB
[VERSION]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:25:28 localhost
/usr/sbin/kamailio[5784]: DEBUG: <core>
[db_val.c:74]: db_str2val(): converting INT [0]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:25:28 localhost
/usr/sbin/kamailio[5784]: DEBUG: <core>
[db_val.c:74]: db_str2val(): converting INT [0]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:25:28 localhost
/usr/sbin/kamailio[5784]: DEBUG: <core>
[db_val.c:169]: db_str2val(): converting BLOB
[120104-1734]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:25:28 localhost
/usr/sbin/kamailio[5784]: ERROR: htable
[ht_db.c:276]: ht_db_load_table(): key type must
be string (type=6)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">If I add a new entry named “WWWWW”,
then the failure occurs on this entry that is the
last alphabetic entry :</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Courier
New";color:#1F497D" lang="EN-US">| 10000 |
WWWWW | toto | 0 | 0 |</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:28:45 localhost
/usr/sbin/kamailio[5817]: DEBUG: <core>
[db_val.c:169]: db_str2val(): converting BLOB
[WWWWW]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:28:45 localhost
/usr/sbin/kamailio[5817]: DEBUG: <core>
[db_val.c:74]: db_str2val(): converting INT [0]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:28:45 localhost
/usr/sbin/kamailio[5817]: DEBUG: <core>
[db_val.c:74]: db_str2val(): converting INT [0]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:28:45 localhost
/usr/sbin/kamailio[5817]: DEBUG: <core>
[db_val.c:169]: db_str2val(): converting BLOB
[toto]</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Mar 21 10:28:45 localhost
/usr/sbin/kamailio[5817]: ERROR: htable
[ht_db.c:276]: ht_db_load_table(): key type must
be string (type=6)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Attached the kamailio log for each
test.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">I hope this help.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Have anyone an idea of this problem ?</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Cordialement</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">De
:</span></b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">
Ginhoux, Patrick<br>
<b>Envoyé :</b> mardi 21 mars 2017 09:41<br>
<b>À :</b> Kamailio users (<a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank">sr-users@lists.sip-router.org</a>)
<<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank">sr-users@lists.sip-router.org</a>><br>
<b>Objet :</b> RE: ht_db_load_table(): key
type must be string (type=6)<o:p></o:p></span></p>
</div>
</div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Hi,</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">There was a mistake in the file
attached ; the short kamailio.cfg file (that makes
kamailio to start) was not the correct one;
attached the correct one.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Have anyone an idea of this problem ?</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Cordialement</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">De
:</span></b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">
Ginhoux, Patrick<br>
<b>Envoyé :</b> lundi 20 mars 2017 17:58<br>
<b>À :</b> Kamailio users (<a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank"><span style="color:#0563C1">sr-users@lists.sip-router.org</span></a>)
<<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank"><span style="color:#0563C1">sr-users@lists.sip-router.org</span></a>><br>
<b>Objet :</b> RE: ht_db_load_table(): key
type must be string (type=6)<o:p></o:p></span></p>
</div>
</div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Hi,</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">To figure out what causes this issue,
I work to shorten my kamailio.cfg to contains
loadmodule/modparam instructions for the htable
module only.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">My first attempt (see
kamailio.cfg.ok) shows that the problem doesn’t
occur.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-right:337.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">In the second attempt (see
kamailio.cfg.ko) I add instructions previously
removed from the original .cfg file. I have
determined that, depending on the instructions
that follows the “</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">modparam("htable", "fetch_rows",
1000)<span style="color:#1F497D">” line, the “key
type must be string (type=6)” error occurs or
not.</span></span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-right:337.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">In this ko file, if I comment out the
following sequence, the error occurs : </span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">modparam("htable", "fetch_rows",
1000)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#!!ifdef FIXED_ROUTING</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#modparam("htable", "htable",
"mbxrangeHash=>size=4;dbtable=mbxrange;")</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#!!else</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#modparam("htable", "htable",
"abpqHash=>size=12;dbtable=abpq;")</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#modparam("htable", "htable",
"zabpqHash=>size=12;dbtable=zabpq;")</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow"
lang="EN-US">#!!endif</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">modparam("htable", "htable",
"propertiesHash=>size=4;dbtable=properties;")</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">I hope my explanation is clearn and
there are people who can help me on this problem
that causes kamailio to not start.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Cordialement</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p><b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">De :</span></b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US"> Ginhoux, Patrick<br>
<b>Envoyé :</b> vendredi 17 mars 2017 15:46<br>
<b>À :</b> Kamailio users (</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank"><span style="color:#0563C1"
lang="EN-US">sr-users@lists.sip-router.org</span></a></span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">) <</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><a
moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org"
target="_blank"><span style="color:#0563C1"
lang="EN-US">sr-users@lists.sip-router.org</span></a></span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">><br>
<b>Objet :</b> ht_db_load_table(): key type
must be string (type=6)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
</div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif">Hi,<o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Now the kamailio installation is
completed, I try to start kamailio but got an
error on a modparam line.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">By looking at the kamailio.cfg (with
debug mode) it looks like the instruction is not
correct :</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">modparam("htable", "fetch_rows", <span
style="background:yellow;mso-highlight:yellow">1000</span>)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">[root@vm-vse02-siprouter1 ~]#
systemctl status kamailio.service -l</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">kamailio.service - SYSV: Kamailio is
a fast, reliable and flexible SIP Server.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Loaded: loaded
(/etc/rc.d/init.d/kamailio)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Active: failed (Result: exit-code)
since Fri 2017-03-17 15:38:13 CET; 17s ago</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Process: 1526
ExecStart=/etc/rc.d/init.d/kamailio start
(code=exited, status=1/FAILURE)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: INFO: pike [pike.c:99]:
pike_init(): PIKE - initializing</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: INFO: pike
[ip_tree.c:81]: init_lock_set(): probing 256 set
size</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: INFO: cfgutils
[cfgutils.c:767]: mod_init(): no hash_file given,
disable hash functionality</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif;background:yellow;mso-highlight:yellow"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: ERROR: htable
[ht_db.c:276]: ht_db_load_table(): key type must
be string (type=6) </span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: ERROR: <core>
[core/sr_module.c:968]: init_mod(): Error while
initializing module htable
(/usr/lib64/kamailio/modules/htable.so)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
/usr/sbin/kamailio[1539]: INFO: <core>
[core/sctp_core.c:53]: sctp_core_destroy(): SCTP
API not initialized</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
kamailio[1526]: Starting kamailio:</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
systemd[1]: kamailio.service: control process
exited, code=exited status=1</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
systemd[1]: Failed to start SYSV: Kamailio is a
fast, reliable and flexible SIP Server..</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:38:13 vm-vse02-siprouter1
systemd[1]: Unit kamailio.service entered failed
state.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">[root@vm-vse02-siprouter1 ~]#</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:35.4pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">modparam("htable", "fetch_rows", <span
style="background:yellow;mso-highlight:yellow">“1000”</span>)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">[root@vm-vse02-siprouter1 ~]#
systemctl status kamailio.service -l</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">kamailio.service - SYSV: Kamailio is
a fast, reliable and flexible SIP Server.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Loaded: loaded
(/etc/rc.d/init.d/kamailio)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Active: failed (Result: exit-code)
since Fri 2017-03-17 15:26:21 CET; 3s ago</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Process: 1452
ExecStart=/etc/rc.d/init.d/kamailio start
(code=exited, status=1/FAILURE)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:20 vm-vse02-siprouter1
systemd[1]: Starting SYSV: Kamailio is a fast,
reliable and flexible SIP Server....</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: Not starting : invalid
configuration file!</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: 0(1460) ERROR: <core>
[core/modparam.c:141]: <span
style="background:yellow;mso-highlight:yellow">set_mod_param_regex():
parameter <fetch_rows> of type <1>
not found in module <htable></span></span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: 0(1460) CRITICAL: <core>
[core/cfg.y:3404]: yyerror_at(): parse error in
config file //etc/kamailio/kamailio.cfg, line 308,
column 41: Can't set module parameter</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: 0(1460) WARNING: <core>
[core/cfg.y:3378]: warn_at(): warning in config
file //etc/kamailio/kamailio.cfg, line 971, column
6-13: constant value in if(...)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: ERROR: bad config file (1 errors)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
kamailio[1452]: 0(1460) INFO: <core>
[core/sctp_core.c:53]: sctp_core_destroy(): SCTP
API not initialized</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
systemd[1]: kamailio.service: control process
exited, code=exited status=1</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
systemd[1]: Failed to start SYSV: Kamailio is a
fast, reliable and flexible SIP Server..</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Mar 17 15:26:21 vm-vse02-siprouter1
systemd[1]: Unit kamailio.service entered failed
state.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p style="margin-left:70.8pt"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">[root@vm-vse02-siprouter1 ~]#</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">The documentation shows that
fetch_rows is an integer :</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<div style="border:solid silver 1.0pt;padding:0cm 0cm
0cm 4.0pt">
<p
style="mso-margin-top-alt:5.0pt;margin-right:37.5pt;margin-bottom:5.0pt;margin-left:37.5pt;background:#F2F2F2"><b><i><span
style="font-size:10.0pt;font-family:"Courier New";color:black"
lang="EN-US">fetch_rows</span></i></b><b><i><span
style="font-family:"Helvetica",sans-serif;color:black"
lang="EN-US"> (integer)</span></i></b><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<p
style="mso-margin-top-alt:5.0pt;margin-right:37.5pt;margin-bottom:5.0pt;margin-left:37.5pt;text-align:justify"><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"
lang="EN-US">How many rows to fetch at once from
database. </span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:5.0pt;margin-right:37.5pt;margin-bottom:5.0pt;margin-left:37.5pt;text-align:justify"><i><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"
lang="EN-US">Default value is 100. </span></i><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:5.0pt;margin-right:37.5pt;margin-bottom:5.0pt;margin-left:37.5pt;text-align:justify;background:#EFF8F8"><b><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"
lang="EN-US">Example 1.12. Set </span></b><b><span
style="font-size:10.0pt;font-family:"Courier New";color:black"
lang="EN-US">fetch_rows</span></b><b><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"
lang="EN-US"> parameter</span></b><span
style="font-size:9.0pt;font-family:"Helvetica",sans-serif;color:black"
lang="EN-US"> </span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<div style="border:solid #99CCCC 1.0pt;padding:0cm 0cm
0cm 15.0pt">
<p
style="mso-margin-top-alt:0cm;margin-right:37.5pt;margin-bottom:0cm;margin-left:37.5pt;margin-bottom:.0001pt;background:#FCFFFC"><span
style="font-size:10.0pt;font-family:"Courier New";color:black">...</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p
style="mso-margin-top-alt:0cm;margin-right:37.5pt;margin-bottom:0cm;margin-left:37.5pt;margin-bottom:.0001pt;background:#FCFFFC"><span
style="font-size:10.0pt;font-family:"Courier New";color:black">modparam("htable",
"fetch_rows", 1000)</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">So how to explain the first error.</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Have you any thoughts on this case ?</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Cordialement</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"
lang="EN-US">Patrick GINHOUX</span><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
</div>
</div>
</blockquote>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
<br>
--<br>
Daniel-Constantin Mierla<br>
<a moz-do-not-send="true" href="http://www.kamailio.org">www.kamailio.org</a>
-- <a moz-do-not-send="true" href="http://www.asipto.com">www.asipto.com</a>
<o:p></o:p></span></p>
</div>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training - May 22-24 (USA) - <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
Kamailio World Conference - May 8-10, 2017 - <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a></pre>
</body>
</html>