Hi,
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-PRESEN...
I reckon it is safe to skip this to tables?
Kristijan
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
2018-05-29 16:19 GMT+02:00 Kristijan Vrban vrban.lkml@gmail.com:
Hi,
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?
Kristijan
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?
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@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:
GEN-DB-RLS-PRESENTITY
I reckon it is safe to skip this to tables?
Am Mittwoch, 30. Mai 2018, 10:55:07 CEST schrieb 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;
Hello Kristijan,
you should now be able to register in the wiki, if you have time it would be great if you could fix it there.
Henning