No subject


Wed Jun 24 00:39:36 CEST 2009


memory.(corect me if I'm wrong). I'm starting kamailio with private
memory 256 and shared memory 2048.<br>
  <br>
I also did and some fine tuning in mysql server(local):<br>
  <br>
query_cache_type = 1<br>
query_cache_limit = 1024M<br>
query_cache_size = 1024M<br>
key_buffer = 64M<br>
table_cache&nbsp; = 1024<br>
sort_buffer=4M<br>
read_buffer_size=1M<br>
max_allowed_packet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 1536M<br>
thread_stack&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 128K<br>
thread_cache_size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = 8<br>
And i cached the table by running to the server the command SELECT
SQL_CACHE&nbsp; * from htable;<br>
  <br>
After this fine tuning I don't get any error when I run kamailio BUT
when I try to receive any vaule from the htable I get NULL back.(this
configuration work's when i have a few values only in the htable)<br>
  <br>
Now the question is does private memory is involve in this? Is an
memory issue or something else?<br>
</blockquote>
<br>
Private memory is involved only when data is loaded from mysql, after
that is moved in shared memory.<br>
<br>
There is an MI command that can dump the content of a hash table (you
can use kamctl for that) to check if there are some values in it.<br>
<br>
Since you have a lot of records, make sure the size of htable is big
(14 is max and recommended).<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
<blockquote
 cite="mid:88b5e74c0912290620k5012f61dhed4a63906c7aac82 at mail.gmail.com"
 type="cite"><br>
Thank you for your help<br>
Best wishes<br>
  <br>
Peace!<br>
Alex<br>
  <br>
  <br>
  <br>
  <br>
  <div class="gmail_quote">On Thu, Dec 24, 2009 at 7:31 PM,
Daniel-Constantin Mierla <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:miconda at gmail.com">miconda at gmail.com</a>&gt;</span> wrote:<br>
  <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
    <div text="#000000" bgcolor="#ffffff">
Hi Alex,
    <div class="im"><br>
    <br>
On 12/24/09 6:18 PM, alex pappas wrote:
    <blockquote type="cite">Daniel,<br>
      <br>
The reason that I was NOT understanding how to implement the htable is
that even I read the all internet ;-) I did not see the already setup
table Htable in my mysql server which was already made from the
installation and&nbsp; that's why the value type&nbsp; and key types did not make
sense!! now i fill a bit stupid :-(<br>
      <br>
I apologize for stilling you time.<br>
    </blockquote>
    </div>
no need for that! If I have no time I do not answer. Sometime even
obvious things are not seen, happens to me, this is life ...<br>
    <br>
Merry Christmas!<br>
    <font color="#888888">Daniel<br>
    </font><br>
PS. or do you celebrate Christmas in January, using the old calendar
date?
    <div>
    <div class="h5"><br>
    <br>
    <blockquote type="cite"><br>
Cheers<br>
Alex<br>
      <br>
      <br>
      <br>
      <div class="gmail_quote">On Thu, Dec 24, 2009 at 4:36 PM, alex
pappas <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:rebel.pappas at gmail.com" target="_blank">rebel.pappas at gmail.com</a>&gt;</span>
wrote:<br>
      <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thank
you
Daniel,<br>
        <br>
Cheers<br>
        <font color="#888888">Alex</font>
        <div>
        <div><br>
        <br>
        <div class="gmail_quote">On Thu, Dec 24, 2009 at 4:05 PM,
Daniel-Constantin Mierla <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:miconda at gmail.com" target="_blank">miconda at gmail.com</a>&gt;</span>
wrote:<br>
        <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
          <div text="#000000" bgcolor="#ffffff">Hi Alex,<br>
          <br>
the default table structure for htable is defined by sql:<br>
          <br>
CREATE TABLE htable (<br>
&nbsp;&nbsp;&nbsp; id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,<br>
&nbsp;&nbsp;&nbsp; key_name VARCHAR(64) DEFAULT '' NOT NULL,<br>
&nbsp;&nbsp;&nbsp; key_type INT DEFAULT 0 NOT NULL,<br>
&nbsp;&nbsp;&nbsp; value_type INT DEFAULT 0 NOT NULL,<br>
&nbsp;&nbsp;&nbsp; key_value VARCHAR(128) DEFAULT '' NOT NULL<br>
) ENGINE=MyISAM;<br>
          <br>
If you map over another table, then you must have at least four columns
there (id is for generic purpose). See here descriptions of the columns:<br>
          <a moz-do-not-send="true"
 href="http://kamailio.org/docs/modules/3.0.x/modules_k/htable.html#id2529061"
 target="_blank">http://kamailio.org/docs/modules/3.0.x/modules_k/htable.html#id2529061</a><br>
          <br>
Cheers,<br>
          <font color="#888888">Daniel</font>
          <div>
          <div><br>
          <br>
On 12/23/09 6:13 PM, alex pappas wrote:
          <blockquote type="cite">Hi Daniel,<br>
            <br>
My problem is how to define the hash table in Kamailio.cfg. Especially
I don't understand how to define :<br>
            <h3><code>key_name_column: here I
understand that is the name of the key = fist col (phonenumber)<br>
            </code></h3>
            <h3><code>key_type_column == string ?<br>
            </code></h3>
            <h3><code>value_type_column == string ?<br>
            </code></h3>
            <h3><code>key_value_column == second
col(prefix)?<br>
            </code></h3>
&nbsp;<br>
            <br>
I get the following errors:<br>
            <br>
ERROR:db_mysql:db_mysql_submit_query: driver error on query: Unknown
column 'key_type' in 'field list'<br>
ERROR:core:db_do_query: error while submitting query<br>
ERROR:htable:ht_db_load_table: Error while querying db<br>
ERROR:core:init_mod: failed to initialize module htable<br>
ERROR:core:main: error while initializing modules<br>
            <br>
Thank you <br>
            <br>
Alex<br>
            <br>
            <br>
            <br>
            <div class="gmail_quote">On Wed, Dec 23, 2009 at 6:43 PM,
Daniel-Constantin Mierla <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:miconda at gmail.com" target="_blank">miconda at gmail.com</a>&gt;</span>
wrote:<br>
            <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
              <div text="#000000" bgcolor="#ffffff">Hello,
              <div><br>
              <br>
On 12/23/09 4:28 PM, alex pappas wrote: </div>
              <blockquote type="cite">Hi all,<br>
                <br>
                <div>It is possible to have some help in defining the
hash table?<br>
                <br>
I'm giving some parameters but some of them i don't really understand
them. my configuration is:<br>
                <br>
# --------- Htable ---------<br>
modparam("htable", "htable", "a=&gt;dbtable=ported1;")<br>
modparam("htable", "db_url",
"mysql://pskoul:pskoul123@localhost/openser")<br>
modparam("htable", "key_name_column", "phonenumber")<br>
modparam("htable", "key_value", "prefix")<br>
modparam("htable", "fetch_rows", 1000)<br>
                <br>
The table I want to htable is a 2 cols table (phonenumber,prefix) In
mysql they are defined as varchar(10). All the phonenumber values are
unique so the key in htable is phonenumber with value in prefix.<br>
                </div>
              </blockquote>
              <br>
what don't you understand? I do not know what to explain. Is there any
error you get? At least the parameter key_value is wrong, should be
key_value_column.<br>
              <br>
Cheers,<br>
              <font color="#888888">Daniel</font>
              <div>
              <div><br>
              <br>
              <blockquote type="cite"><br>
Thanks All,<br>
                <br>
Alex<br>
                <br>
                <br>
                <br>
                <div class="gmail_quote">On Wed, Dec 23, 2009 at 1:04
PM,
alex
pappas <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:rebel.pappas at gmail.com" target="_blank">rebel.pappas at gmail.com</a>&gt;</span>
wrote:<br>
                <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thank
you
Daniel,<br>
                  <br>
I will try first oracle db and then htable which is also very
interesting. When I'm done I will get back with the results.<br>
                  <br>
Cheers<br>
                  <font color="#888888">Alex</font>
                  <div>
                  <div><br>
                  <br>
                  <br>
                  <br>
                  <div class="gmail_quote">On Wed, Dec 23, 2009 at
11:44
AM,
Daniel-Constantin Mierla <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:miconda at gmail.com" target="_blank">miconda at gmail.com</a>&gt;</span>
wrote:<br>
                  <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
                    <div text="#000000" bgcolor="#ffffff">Hello,
                    <div><br>
                    <br>
On 12/22/09 1:25 PM, alex pappas wrote:
                    <blockquote type="cite">Hi all,<br>
                      <br>
Concerning portability again :-)<br>
                      <br>
Is there any way I can add in the memory all the numbers with
portability? (2.000.000 rows)?<br>
And also reload these data a few times a day and access this data from
the&nbsp; Kamailio script?<br>
                    </blockquote>
                    <br>
                    </div>
while I advise usage of sqlops/sql_query() instead of
avpops/avp_db_query(), if you want to load such data in memory should
be in shared memory. For that look at htable or maybe you can re-use
pdt.<br>
                    <br>
Cheers,<br>
Daniel<br>
                    <br>
                    <blockquote type="cite">
                      <div>
                      <div><br>
&nbsp;Cheers<br>
Alex<br>
                      <br>
                      <br>
                      <br>
                      <div class="gmail_quote">On Tue, Dec 22, 2009 at
12:56 AM,
Henning
Westerholt <span dir="ltr">&lt;<a moz-do-not-send="true"
 href="mailto:henning.westerholt at 1und1.de" target="_blank">henning.westerholt at 1und1.de</a>&gt;</span>
wrote:<br>
                      <blockquote class="gmail_quote"
 style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On
Mon,
December
21,
2009
9:50 pm, Alex Balashov wrote:<br>
&gt; [..]<br>
                        <div>&gt; Having said that, AVPs are still very
useful
and necessary because they<br>
&gt; persist across the lifetime of a transaction, so you can access
them in<br>
&gt; subsequent reply and failure routes. &nbsp;This is not true of user<br>
&gt; pseudovariables ($var(...)), nor, as far as I know, of any other
class<br>
&gt; of pseudovariable at this point except special
transaction-persistent<br>
&gt; ones exported by modules.<br>
&gt;<br>
&gt; As a result, it is often necessary for me to take data from $dbr<br>
&gt; (sqlops) and load it into arrays of AVPs, such as for example when
doing<br>
&gt; custom fail-over in failure_route that uses logic for which
dispatcher<br>
&gt; is not suitable. &nbsp;I store a set of gateways in an AVP array along
with<br>
&gt; another AVP value indicating the current array index and iterate
over<br>
&gt; them in failure_route, and so on.<br>
&gt;<br>
&gt; Daniel taught me how to use AVP arrays once, although I noticed
this is<br>
&gt; not mentioned anywhere in the avpops documentation. &nbsp;It should be<br>
&gt; published somewhere, as it is one of the most useful programmatic<br>
&gt; features of Kamailio.<br>
&gt;<br>
&gt; Henning/Daniel, does Kamailio 3/SR offer any kind of better
substitute<br>
&gt; for what I am doing with AVPs as described above? &nbsp;In other words,
are<br>
&gt; there any transaction-persistent pseudovariables and/or namespace<br>
&gt; containers that are easier to deal with syntactically, and provide
more<br>
&gt; advanced data structure primitives like arrays? &nbsp;I am aware of
htable,<br>
&gt; but I need something local to a transaction, not global.<br>
                        <br>
                        </div>
There are the $var PVs you already mentioned, and then also the $shv
that<br>
are shared variables. But they are (process) global, and not<br>
transactional. Daniel proposed and developed the new xavp type for sr<br>
which are basically extended AVPs. More informations can be found here:<br>
                        <a moz-do-not-send="true"
 href="http://sip-router.org/wiki/devel/xavp" target="_blank">http://sip-router.org/wiki/devel/xavp</a><br>
                        <br>
Regards,<br>
                        <font color="#888888"><br>
Henning<br>
                        <br>
                        </font></blockquote>
                      </div>
                      <br>
                      </div>
                      </div>
                      <pre><fieldset></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<div><a moz-do-not-send="true" href="mailto:Users at lists.kamailio.org"
 target="_blank">Users at lists.kamailio.org</a>
<a moz-do-not-send="true"
 href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
<a moz-do-not-send="true"
 href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></div></pre>
                    </blockquote>
                    <br>
                    <div>
                    <pre cols="72">-- 
Daniel-Constantin Mierla
* <a moz-do-not-send="true" href="http://www.asipto.com/"
 target="_blank">http://www.asipto.com/</a>
      </pre>
                    </div>
                    </div>
                  </blockquote>
                  </div>
                  <br>
                  </div>
                  </div>
                </blockquote>
                </div>
                <br>
                <pre><fieldset></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<a moz-do-not-send="true" href="mailto:Users at lists.kamailio.org"
 target="_blank">Users at lists.kamailio.org</a>
<a moz-do-not-send="true"
 href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
<a moz-do-not-send="true"
 href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></pre>
              </blockquote>
              <br>
              <pre cols="72">-- 
Daniel-Constantin Mierla
* <a moz-do-not-send="true" href="http://www.asipto.com/"
 target="_blank">http://www.asipto.com/</a>
    </pre>
              </div>
              </div>
              </div>
            </blockquote>
            </div>
            <br>
            <input type="hidden"><input type="hidden">
            <pre><fieldset></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<a moz-do-not-send="true" href="mailto:Users at lists.kamailio.org"
 target="_blank">Users at lists.kamailio.org</a>
<a moz-do-not-send="true"
 href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
<a moz-do-not-send="true"
 href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users"
 target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></pre>
          </blockquote>
          <br>
          <pre cols="72">-- 
Daniel-Constantin Mierla
* <a moz-do-not-send="true" href="http://www.asipto.com/"
 target="_blank">http://www.asipto.com/</a>
      </pre>
          </div>
          </div>
          </div>
        </blockquote>
        </div>
        <br>
        </div>
        </div>
      </blockquote>
      </div>
      <br>
    </blockquote>
    <br>
    <pre cols="72">-- 
Daniel-Constantin Mierla
* <a moz-do-not-send="true" href="http://www.asipto.com/"
 target="_blank">http://www.asipto.com/</a>
    </pre>
    </div>
    </div>
    </div>
  </blockquote>
  </div>
  <br>
  <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Kamailio (OpenSER) - Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users at lists.kamailio.org">Users at lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
<a class="moz-txt-link-freetext" href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla
* <a class="moz-txt-link-freetext" href="http://www.asipto.com/">http://www.asipto.com/</a>
</pre>
</body>
</html>

--------------000703060107050701080007--



More information about the Users mailing list