[OpenSIPS-Users] OpenSIPS 3.1 - DB version table error

[Mark Allen]

[SOLVED]

Scratch that. I answered my own question. I realised that I had missed the
document
https://github.com/OpenSIPS/opensips-cli/blob/master/docs/modules/database.md

I ran the command...

    opensips-cli -o database_schema_path=~/src/opensips-3.1/scripts \
             -x database migrate 3.0_to_3.1 opensips opensips_mig_3_1

...which seems to have upgraded to the correct version

On Tue, 28 Jul 2020 at 09:00, Mark Allen <mark at allenclan.co.uk> wrote:

> Presumably, there's somewhere that I should be telling opensips-cli that I
> want it to use the 3.1 schema?
>
> On Tue, 28 Jul 2020 at 08:54, Mark Allen <mark at allenclan.co.uk> wrote:
>
>> Getting version table errors on startup after move to 3.1...
>>
>>     ERROR:core:db_check_table_version: invalid version 10 for table
>> dialog found, expected 11
>>
>> Version 3.1 is built from 3.1 branch on GitHub. I think I've followed the
>> documentation correctly but OpenSIPS 3.1 is not starting and I'm seeing
>> this error. On our test setup I've tried both...
>>
>>     opensips-cli -x database migrate 3.0_to_3.1 opensips opensips_3_1
>>
>> and
>>
>>     opensips-cli -x database create opensips-3_1
>>
>>
>> Using DB opensips-3_1, a 'SELECT * FROM version;' gives the following...
>>
>> after database migration:
>> +------------------+---------------+
>> | table_name       | table_version |
>> +------------------+---------------+
>> | acc              |             7 |
>> | address          |             5 |
>> | clusterer        |             4 |
>> | dbaliases        |             2 |
>> | dialog           |            10 |
>> | dialplan         |             5 |
>> | dispatcher       |             8 |
>> | domain           |             3 |
>> | dr_carriers      |             2 |
>> | dr_gateways      |             6 |
>> | dr_groups        |             2 |
>> | dr_partitions    |             1 |
>> | dr_rules         |             3 |
>> | grp              |             3 |
>> | load_balancer    |             2 |
>> | location         |          1013 |
>> | missed_calls     |             5 |
>> | re_grp           |             2 |
>> | rtpengine        |             1 |
>> | rtpproxy_sockets |             0 |
>> | silo             |             6 |
>> | speed_dial       |             3 |
>> | subscriber       |             7 |
>> | tls_mgm          |             3 |
>> | uri              |             2 |
>> | usr_preferences  |             3 |
>> +------------------+---------------+
>>
>> after database creation:
>> +------------------+---------------+
>> | table_name       | table_version |
>> +------------------+---------------+
>> | acc              |             7 |
>> | address          |             5 |
>> | clusterer        |             4 |
>> | dbaliases        |             2 |
>> | dialog           |            10 |
>> | dialplan         |             5 |
>> | dispatcher       |             8 |
>> | domain           |             3 |
>> | dr_carriers      |             2 |
>> | dr_gateways      |             6 |
>> | dr_groups        |             2 |
>> | dr_partitions    |             1 |
>> | dr_rules         |             3 |
>> | grp              |             3 |
>> | load_balancer    |             2 |
>> | location         |          1013 |
>> | missed_calls     |             5 |
>> | re_grp           |             2 |
>> | rtpengine        |             1 |
>> | rtpproxy_sockets |             0 |
>> | silo             |             6 |
>> | speed_dial       |             3 |
>> | subscriber       |             7 |
>> | tls_mgm          |             3 |
>> | uri              |             2 |
>> | usr_preferences  |             3 |
>> +------------------+---------------+
>>
>> What am I missing????
>>
>> Documentation used:
>> https://github.com/OpenSIPS/opensips/blob/master/INSTALL
>> https://www.opensips.org/Documentation/Migration-3-0-0-to-3-1-0
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200728/f5a2d06b/attachment.html>