<div dir="ltr"><div>Hi Henning</div><div><br></div><div>>
if you don't use the tables (and the belonging rls modules), it save to skip them.
<br></div><div><br></div><div>Yes, i do not use them. So for me does not matter. But i am 100% sure, the documentation</div><div>at: <a href="https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0">https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0</a> is wrong on this. And it should be:<br></div><div><br></div><div>ALTER TABLE rls_watchers MODIFY callid VARCHAR(255) NOT NULL;</div><div>ALTER TABLE rls_watchers MODIFY contact VARCHAR(128) NOT NULL;</div><div><br></div><div>Not:</div><div>ALTER TABLE rls_presentity MODIFY callid VARCHAR(255) NOT NULL;</div><div>ALTER TABLE rls_presentity MODIFY contact VARCHAR(128) NOT NULL;<br></div><div><br></div><div>Best<br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-05-30 7:47 GMT+02:00 Henning Westerholt <span dir="ltr"><<a href="mailto:hw@kamailio.org" target="_blank">hw@kamailio.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>
<div style="font-family:"Hack";font-size:9pt;font-weight:400;font-style:normal"><span class="gmail-">
<p style="margin:0px;text-indent:0px">Am Dienstag, 29. Mai 2018, 16:39:22 CEST schrieb Kristijan Vrban:</p>
<p style="margin:0px;text-indent:0px">> Hmm, for me it looks like it is the wrong table. Should be " rls_watchers"</p>
<p style="margin:0px;text-indent:0px">> not " rls_presentity" So it is a error on the SQ upgrade commands from</p>
<p style="margin:0px;text-indent:0px">> <a href="https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0" target="_blank">https://www.kamailio.org/wiki/<wbr>install/upgrade/3.1.x-to-3.2.0</a></p>
<p style="margin:0px;text-indent:0px"> </p>
</span><p style="margin:0px;text-indent:0px">Hello Kristijan,</p>
<p style="margin:0px;text-indent:0px"> </p>
<p style="margin:0px;text-indent:0px">if you don't use the tables (and the belonging rls modules), it save to skip them. Sometimes there were not installed, depending on your configuration of the control command. </p>
<p style="margin:0px;text-indent:0px"> </p>
<p style="margin:0px;text-indent:0px">Best regards,</p><span class="gmail-HOEnZb"><font color="#888888">
<p style="margin:0px;text-indent:0px"> </p>
<p style="margin:0px;text-indent:0px">Henning</p></font></span><span class="gmail-">
<p style="margin:0px;text-indent:0px"> </p>
<p style="margin:0px;text-indent:0px">> > i try a upgrade from old 3.0.3 Kamailio mysql db. Got stuck with update</p>
<p style="margin:0px;text-indent:0px">> > the structure :</p>
<p style="margin:0px;text-indent:0px">> > </p>
<p style="margin:0px;text-indent:0px">> > ALTER TABLE rls_presentity MODIFY callid VARCHAR(255) NOT NULL;ALTER TABLE</p>
<p style="margin:0px;text-indent:0px">> > rls_presentity MODIFY contact VARCHAR(128) NOT NULL;</p>
<p style="margin:0px;text-indent:0px">> > </p>
<p style="margin:0px;text-indent:0px">> > found on: <a href="https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0" target="_blank">https://www.kamailio.org/wiki/<wbr>install/upgrade/3.1.x-to-3.2.0</a></p>
<p style="margin:0px;text-indent:0px">> > </p>
<p style="margin:0px;text-indent:0px">> > But this two table does not exist? See also table definition at:</p>
<p style="margin:0px;text-indent:0px">> > <a href="https://kamailio.org/docs/db-tables/kamailio-db-3.1.x.html#" target="_blank">https://kamailio.org/docs/db-<wbr>tables/kamailio-db-3.1.x.html#</a></p>
<p style="margin:0px;text-indent:0px">> > GEN-DB-RLS-PRESENTITY</p>
<p style="margin:0px;text-indent:0px">> > </p>
<p style="margin:0px;text-indent:0px">> > I reckon it is safe to skip this to tables?</p>
<p style="margin:0px;text-indent:0px"> </p></span></div></blockquote></div><br></div></div>