<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Courier New \;color\:\#1F497D";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;
color:black;}
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;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New",serif;
color:black;}
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;
color:black;}
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;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:Consolas;
color:black;}
span.EmailStyle24
{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]--></head><body bgcolor=white lang=FR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I have not myself the knowledge to get this patch included in my installation (without a rpm) and then test it; and for the moment I don’t have anybody available that could help me.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I’ll keep you posted if I can get people around me.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Cordialement<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>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;color:windowtext'>De :</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext'> Daniel-Constantin Mierla [mailto:miconda@gmail.com] <br><b>Envoyé :</b> lundi 3 avril 2017 14:29<br><b>À :</b> Ginhoux, Patrick <patrick.ginhoux@fr.unisys.com><br><b>Cc :</b> Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org><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>Hello,<o:p></o:p></p><p>thanks for reminder, actually I missed that email, not reading it so far.<o:p></o:p></p><p>I just pushed a patch in master that should handle the blob/text columns:<o:p></o:p></p><p> - <a href="https://github.com/kamailio/kamailio/commit/24e729698017b5d898a92cdf7acb024e44252b84">https://github.com/kamailio/kamailio/commit/24e729698017b5d898a92cdf7acb024e44252b84</a><o:p></o:p></p><p>Can you test it? If all ok, then I will backport.<o:p></o:p></p><p>Cheers,<br>Daniel<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 03.04.17 13:58, Ginhoux, Patrick wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi Daniel,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Do you look at this error with the item type of ‘text’ in a mysql table?</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></p></div><p class=MsoNormal><span style='mso-fareast-language:EN-US'> </span><o:p></o:p></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 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)</span><o:p></o:p></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,</span><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'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language: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.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>By changing the type from ‘text’ to varchar(256), the problem goes away.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language: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.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>I hope this help.</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></p></div><p class=MsoNormal><span lang=EN-US style='mso-fareast-language:EN-US'> </span><o:p></o:p></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 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)</span><o:p></o:p></p></div></div><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hi,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Below the structure of the properties table :</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>mysql> show create table properties;</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>| Table | Create Table |</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>| properties | CREATE TABLE `properties` (</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> `id` int(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'UniqueID',</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> `key_name` text NOT NULL,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> `key_value` text NOT NULL,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> `value_type` int(1) NOT NULL,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> `key_type` int(1) NOT NULL,</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> PRIMARY KEY (`id`)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1 |</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>1 row in set (0.02 sec)</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'> </span><o:p></o:p></p><div><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></p></div><p class=MsoNormal><span style='mso-fareast-language:EN-US'> </span><o:p></o:p></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 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 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)</span><o:p></o:p></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,</span><o:p></o:p></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 href="mailto:%22Ginhoux,%20Patrick%22%20%3cpatrick.ginhoux@fr.unisys.com%3e" target="_blank">patrick.ginhoux@fr.unisys.com</a>> wrote:</span><o:p></o:p></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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>A second update for people who started to look at this issue.</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>I have the following entries in my mysql db :</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>+-------+----------------+---------------------------------------------------------+------------+----------+</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| id | key_name | key_value | value_type | key_type |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>+-------+----------------+---------------------------------------------------------+------------+----------+</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 0 | VERSION | 120104-1734 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 1 | mmm-retry | 408=Y;502=Y;503=Y | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 2 | mgcf-retry | 408=Y;502=Y;503=Y | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 3 | max-mmm-retry | 2 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 4 | max-mgcf-retry | 2 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 5 | target-uri | mgcf=10.10.10.10;mmm-legacy=20.20.20.10;mmm=20.20.20.20 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 6 | pike-status | 503 Service Overload | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 7 | mgcf-path | 99 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 16 | mmm-nodeid | OPMMMS1VSE01=1;OPMMMS1VSE02=2 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 17 | mmm-node-path | 1=1;2=2 | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>+-------+----------------+---------------------------------------------------------+------------+----------+</span><o:p></o:p></p><p style='margin-right:337.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p style='margin-right:337.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:25:28 localhost /usr/sbin/kamailio[5784]: DEBUG: <core> [db_val.c:169]: db_str2val(): converting BLOB [VERSION]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:25:28 localhost /usr/sbin/kamailio[5784]: DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [0]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:25:28 localhost /usr/sbin/kamailio[5784]: DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [0]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:25:28 localhost /usr/sbin/kamailio[5784]: DEBUG: <core> [db_val.c:169]: db_str2val(): converting BLOB [120104-1734]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>If I add a new entry named “WWWWW”, then the failure occurs on this entry that is the last alphabetic entry :</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New ;color:#1F497D",serif'>| 10000 | WWWWW | toto | 0 | 0 |</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:28:45 localhost /usr/sbin/kamailio[5817]: DEBUG: <core> [db_val.c:169]: db_str2val(): converting BLOB [WWWWW]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:28:45 localhost /usr/sbin/kamailio[5817]: DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [0]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:28:45 localhost /usr/sbin/kamailio[5817]: DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [0]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Mar 21 10:28:45 localhost /usr/sbin/kamailio[5817]: DEBUG: <core> [db_val.c:169]: db_str2val(): converting BLOB [toto]</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Attached the kamailio log for each test.</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>I hope this help.</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Have anyone an idea of this problem ?</span><o:p></o:p></p><div><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></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 href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>) <<a 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)</span><o:p></o:p></p></div></div><p><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Hi,</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Have anyone an idea of this problem ?</span><o:p></o:p></p><div><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></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 href="mailto:sr-users@lists.sip-router.org" target="_blank"><span style='color:#0563C1'>sr-users@lists.sip-router.org</span></a>) <<a 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)</span><o:p></o:p></p></div></div><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Hi,</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>My first attempt (see kamailio.cfg.ok) shows that the problem doesn’t occur.</span><o:p></o:p></p><p style='margin-right:337.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>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 lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>modparam("htable", "fetch_rows", 1000)</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>” line, the “key type must be string (type=6)” error occurs or not.</span><o:p></o:p></p><p style='margin-right:337.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>In this ko file, if I comment out the following sequence, the error occurs : </span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>modparam("htable", "fetch_rows", 1000)</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#!!ifdef FIXED_ROUTING</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#modparam("htable", "htable", "mbxrangeHash=>size=4;dbtable=mbxrange;")</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#!!else</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#modparam("htable", "htable", "abpqHash=>size=12;dbtable=abpq;")</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#modparam("htable", "htable", "zabpqHash=>size=12;dbtable=zabpq;")</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;background:yellow;mso-highlight:yellow'>#!!endif</span><o:p></o:p></p><p style='mso-margin-top-alt:0cm;margin-right:337.8pt;margin-bottom:0cm;margin-left:35.4pt;margin-bottom:.0001pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>modparam("htable", "htable", "propertiesHash=>size=4;dbtable=properties;")</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>I hope my explanation is clearn and there are people who can help me on this problem that causes kamailio to not start.</span><o:p></o:p></p><div><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Cordialement</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D'>Patrick GINHOUX</span><o:p></o:p></p></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p><b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>De :</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'> 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 href="mailto:sr-users@lists.sip-router.org" target="_blank"><span lang=EN-US style='color:#0563C1'>sr-users@lists.sip-router.org</span></a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>) <</span><span style='font-size:10.0pt;font-family:"Arial",sans-serif'><a href="mailto:sr-users@lists.sip-router.org" target="_blank"><span lang=EN-US style='color:#0563C1'>sr-users@lists.sip-router.org</span></a></span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>><br><b>Objet :</b> ht_db_load_table(): key type must be string (type=6)</span><o:p></o:p></p></div></div><p><span style='font-size:10.0pt;font-family:"Arial",sans-serif'>Hi,</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Now the kamailio installation is completed, I try to start kamailio but got an error on a modparam line.</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>By looking at the kamailio.cfg (with debug mode) it looks like the instruction is not correct :</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>modparam("htable", "fetch_rows", <span style='background:yellow;mso-highlight:yellow'>1000</span>)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>[root@vm-vse02-siprouter1 ~]# systemctl status kamailio.service -l</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>kamailio.service - SYSV: Kamailio is a fast, reliable and flexible SIP Server.</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Loaded: loaded (/etc/rc.d/init.d/kamailio)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Active: failed (Result: exit-code) since Fri 2017-03-17 15:38:13 CET; 17s ago</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Process: 1526 ExecStart=/etc/rc.d/init.d/kamailio start (code=exited, status=1/FAILURE)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:38:13 vm-vse02-siprouter1 /usr/sbin/kamailio[1539]: INFO: pike [pike.c:99]: pike_init(): PIKE - initializing</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif;background:yellow;mso-highlight:yellow'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:38:13 vm-vse02-siprouter1 kamailio[1526]: Starting kamailio:</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:38:13 vm-vse02-siprouter1 systemd[1]: kamailio.service: control process exited, code=exited status=1</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:38:13 vm-vse02-siprouter1 systemd[1]: Failed to start SYSV: Kamailio is a fast, reliable and flexible SIP Server..</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:38:13 vm-vse02-siprouter1 systemd[1]: Unit kamailio.service entered failed state.</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>[root@vm-vse02-siprouter1 ~]#</span><o:p></o:p></p><p style='margin-left:35.4pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>modparam("htable", "fetch_rows", <span style='background:yellow;mso-highlight:yellow'>“1000”</span>)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>[root@vm-vse02-siprouter1 ~]# systemctl status kamailio.service -l</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>kamailio.service - SYSV: Kamailio is a fast, reliable and flexible SIP Server.</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Loaded: loaded (/etc/rc.d/init.d/kamailio)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Active: failed (Result: exit-code) since Fri 2017-03-17 15:26:21 CET; 3s ago</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Process: 1452 ExecStart=/etc/rc.d/init.d/kamailio start (code=exited, status=1/FAILURE)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:20 vm-vse02-siprouter1 systemd[1]: Starting SYSV: Kamailio is a fast, reliable and flexible SIP Server....</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:21 vm-vse02-siprouter1 kamailio[1452]: Not starting : invalid configuration file!</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:21 vm-vse02-siprouter1 kamailio[1452]: ERROR: bad config file (1 errors)</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>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><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:21 vm-vse02-siprouter1 systemd[1]: kamailio.service: control process exited, code=exited status=1</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:21 vm-vse02-siprouter1 systemd[1]: Failed to start SYSV: Kamailio is a fast, reliable and flexible SIP Server..</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Mar 17 15:26:21 vm-vse02-siprouter1 systemd[1]: Unit kamailio.service entered failed state.</span><o:p></o:p></p><p style='margin-left:70.8pt'><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>[root@vm-vse02-siprouter1 ~]#</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>The documentation shows that fetch_rows is an integer :</span><o:p></o:p></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 lang=EN-US style='font-size:10.0pt;font-family:"Courier New",serif'>fetch_rows</span></i></b><b><i><span lang=EN-US style='font-family:"Helvetica",sans-serif'> (integer)</span></i></b><o:p></o:p></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 lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>How many rows to fetch at once from database. </span><o:p></o:p></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 lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>Default value is 100. </span></i><o:p></o:p></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 lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'>Example 1.12. Set </span></b><b><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New",serif'>fetch_rows</span></b><b><span lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'> parameter</span></b><span lang=EN-US style='font-size:9.0pt;font-family:"Helvetica",sans-serif'> </span><o:p></o:p></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",serif'>...</span><o:p></o:p></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",serif'>modparam("htable", "fetch_rows", 1000)</span><o:p></o:p></p></div><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>So how to explain the first error.</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Have you any thoughts on this case ?</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Cordialement</span><o:p></o:p></p><p><span lang=EN-US style='font-size:10.0pt;font-family:"Arial",sans-serif'>Patrick GINHOUX</span><o:p></o:p></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 href="http://www.kamailio.org">www.kamailio.org</a> -- <a href="http://www.asipto.com">www.asipto.com</a> </span><o:p></o:p></p></div></blockquote><p class=MsoNormal><br><br><o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Daniel-Constantin Mierla<o:p></o:p></pre><pre><a href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio Advanced Training - May 22-24 (USA) - <a href="http://www.asipto.com">www.asipto.com</a><o:p></o:p></pre><pre>Kamailio World Conference - May 8-10, 2017 - <a href="http://www.kamailioworld.com">www.kamailioworld.com</a><o:p></o:p></pre></div></body></html>