[SR-Users] Upgrade issue with old Kamailio 3.0.3 in table rls_presentity

[Kristijan Vrban]

Hi Henning

> if you don't use the tables (and the belonging rls modules), it save to
skip them.

Yes, i do not use them. So for me does not matter. But i am 100% sure, the
documentation
at: https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0 is wrong
on this. And it should be:

ALTER TABLE rls_watchers MODIFY callid VARCHAR(255) NOT NULL;
ALTER TABLE rls_watchers MODIFY contact VARCHAR(128) NOT NULL;

Not:
ALTER TABLE rls_presentity MODIFY callid VARCHAR(255) NOT NULL;
ALTER TABLE rls_presentity MODIFY contact VARCHAR(128) NOT NULL;

Best

2018-05-30 7:47 GMT+02:00 Henning Westerholt <hw at kamailio.org>:

> Am Dienstag, 29. Mai 2018, 16:39:22 CEST schrieb Kristijan Vrban:
>
> > Hmm, for me it looks like it is the wrong table. Should be "
> rls_watchers"
>
> > not " rls_presentity" So it is a error on the SQ upgrade commands from
>
> > https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0
>
>
>
> Hello Kristijan,
>
>
>
> 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.
>
>
>
> Best regards,
>
>
>
> Henning
>
> > > i try a upgrade from old 3.0.3 Kamailio mysql db. Got stuck with update
>
> > > the structure :
>
> > >
>
> > > ALTER TABLE rls_presentity MODIFY callid VARCHAR(255) NOT NULL;ALTER
> TABLE
>
> > > rls_presentity MODIFY contact VARCHAR(128) NOT NULL;
>
> > >
>
> > > found on: https://www.kamailio.org/wiki/install/upgrade/3.1.x-to-3.2.0
>
> > >
>
> > > But this two table does not exist? See also table definition at:
>
> > > https://kamailio.org/docs/db-tables/kamailio-db-3.1.x.html#
>
> > > GEN-DB-RLS-PRESENTITY
>
> > >
>
> > > I reckon it is safe to skip this to tables?
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180530/181d567e/attachment.html>