<div dir="ltr">[SOLVED]<div><br></div><div>Scratch that. I answered my own question. I realised that I had missed the document <a href="https://github.com/OpenSIPS/opensips-cli/blob/master/docs/modules/database.md">https://github.com/OpenSIPS/opensips-cli/blob/master/docs/modules/database.md</a></div><div><br></div><div>I ran the command...</div><div><br></div>    opensips-cli -o database_schema_path=~/src/opensips-3.1/scripts \<br><div>             -x database migrate 3.0_to_3.1 opensips opensips_mig_3_1    </div><div><br></div><div>...which seems to have upgraded to the correct version</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 28 Jul 2020 at 09:00, Mark Allen <<a href="mailto:mark@allenclan.co.uk">mark@allenclan.co.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Presumably, there's somewhere that I should be telling opensips-cli that I want it to use the 3.1 schema?</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 28 Jul 2020 at 08:54, Mark Allen <<a href="mailto:mark@allenclan.co.uk" target="_blank">mark@allenclan.co.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Getting version table errors on startup after move to 3.1...<div><br></div><div>    ERROR:core:db_check_table_version: invalid version 10 for table dialog found, expected 11<br><div><br></div><div>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...</div><div><br></div><div>    opensips-cli -x database migrate 3.0_to_3.1 opensips opensips_3_1<br></div><div><br></div><div>and </div><div><br></div><div>    opensips-cli -x database create opensips-3_1</div><div><br></div><div><br></div><div>Using DB opensips-3_1, a 'SELECT * FROM version;' gives the following...</div></div><div><br></div><div>after database migration:</div><div><font face="monospace">+------------------+---------------+<br>| table_name       | table_version |<br>+------------------+---------------+<br>| acc              |             7 |<br>| address          |             5 |<br>| clusterer        |             4 |<br>| dbaliases        |             2 |<br>| dialog           |            10 |<br>| dialplan         |             5 |<br>| dispatcher       |             8 |<br>| domain           |             3 |<br>| dr_carriers      |             2 |<br>| dr_gateways      |             6 |<br>| dr_groups        |             2 |<br>| dr_partitions    |             1 |<br>| dr_rules         |             3 |<br>| grp              |             3 |<br>| load_balancer    |             2 |<br>| location         |          1013 |<br>| missed_calls     |             5 |<br>| re_grp           |             2 |<br>| rtpengine        |             1 |<br>| rtpproxy_sockets |             0 |<br>| silo             |             6 |<br>| speed_dial       |             3 |<br>| subscriber       |             7 |<br>| tls_mgm          |             3 |<br>| uri              |             2 |<br>| usr_preferences  |             3 |<br>+------------------+---------------+</font><br></div><div><br></div><div>after database creation:</div><div><font face="monospace">+------------------+---------------+<br>| table_name       | table_version |<br>+------------------+---------------+<br>| acc              |             7 |<br>| address          |             5 |<br>| clusterer        |             4 |<br>| dbaliases        |             2 |<br>| dialog           |            10 |<br>| dialplan         |             5 |<br>| dispatcher       |             8 |<br>| domain           |             3 |<br>| dr_carriers      |             2 |<br>| dr_gateways      |             6 |<br>| dr_groups        |             2 |<br>| dr_partitions    |             1 |<br>| dr_rules         |             3 |<br>| grp              |             3 |<br>| load_balancer    |             2 |<br>| location         |          1013 |<br>| missed_calls     |             5 |<br>| re_grp           |             2 |<br>| rtpengine        |             1 |<br>| rtpproxy_sockets |             0 |<br>| silo             |             6 |<br>| speed_dial       |             3 |<br>| subscriber       |             7 |<br>| tls_mgm          |             3 |<br>| uri              |             2 |<br>| usr_preferences  |             3 |<br>+------------------+---------------+</font><br></div><div><font face="monospace"><br></font></div><div><font face="arial, sans-serif">What am I missing????</font></div><div><font face="arial, sans-serif"><br></font></div><div><font face="arial, sans-serif">Documentation used:</font></div><div><a href="https://github.com/OpenSIPS/opensips/blob/master/INSTALL" target="_blank">https://github.com/OpenSIPS/opensips/blob/master/INSTALL</a><br></div><div><a href="https://www.opensips.org/Documentation/Migration-3-0-0-to-3-1-0" target="_blank">https://www.opensips.org/Documentation/Migration-3-0-0-to-3-1-0</a><br></div><div><br></div></div>
</blockquote></div>
</blockquote></div>