<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <tt>Hi Adrian,<br>
      <br>
      How did you install the OpenSIPS 3.0 ? from sources or from
      packages ?<br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  <a class="moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS Summit 2019
  <a class="moz-txt-link-freetext" href="https://www.opensips.org/events/Summit-2019Amsterdam/">https://www.opensips.org/events/Summit-2019Amsterdam/</a>
</pre>
    <div class="moz-cite-prefix">On 8/28/19 10:50 PM, Adrian Fretwell
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1567021847.1866.71.camel@topgreen.co.uk">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div>Hello All,</div>
      <div>Just migrating to Opensips 3.0 and I am using opensip-cli for
        the first time.</div>
      <div><br>
      </div>
      <div>When I issue a opensips-cli -x database create command some
        of the operations fail with:</div>
      <div>Error: (1709, 'Index column size too large. The maximum
        column size is 767 bytes.')</div>
      <div><br>
      </div>
      <div>I will paste the full error below. I am aware of this
        limitation with 10.1.38-MariaDB-0+deb9u1 but have added the
        following to my mysql config file:</div>
      <div>innodb_file_format=barracuda</div>
      <div>innodb_file_format_max=barracuda</div>
      <div>innodb_file_per_table=on</div>
      <div>innodb_large_prefix=on</div>
      <div><br>
      </div>
      <div>I believe the last part of the work around is to specify the
        row format as DYNAMIC thus enabling the index key prefix length
        limit to be raised to 3072 bytes for InnoDB tables with this
        format.</div>
      <div><br>
      </div>
      <div>The problem is that I can't work out how to specify the row
        format DYNAMIC to the opensips-cli program, can anyone help?</div>
      <div><br>
      </div>
      <div>Kind regards,</div>
      <div>Adrian Fretwell</div>
      <div><br>
      </div>
      <div><br>
      </div>
      <div>Full error printout for one table operation:</div>
      <div><br>
      </div>
      <div><a href="mailto:root@sip4-master" moz-do-not-send="true">root@sip4-master</a>:~#
        opensips-cli -x database create</div>
      <div>SQLAlchemy version:  1.3.3</div>
      <div>Please provide the URL of the SQL database:
        mysql://root@localhost</div>
      <div>Create [a]ll tables or just the [c]urrently configured ones?
        (Default value is a): </div>
      <div>Creating all tables ...</div>
      <div>Running standard-create.sql...</div>
      <div>Running group-create.sql...</div>
      <div>Running b2b-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running acc-create.sql...</div>
      <div>Running clusterer-create.sql...</div>
      <div>Running tracer-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running closeddial-create.sql...</div>
      <div>Running registrant-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running call_center-create.sql...</div>
      <div>Running dialog-create.sql...</div>
      <div>Running load_balancer-create.sql...</div>
      <div>Running tls_mgm-create.sql...</div>
      <div>Running domain-create.sql...</div>
      <div>Running msilo-create.sql...</div>
      <div>Running avpops-create.sql...</div>
      <div>Running dispatcher-create.sql...</div>
      <div>Running rtpengine-create.sql...</div>
      <div>Running usrloc-create.sql...</div>
      <div>Running fraud_detection-create.sql...</div>
      <div>Running emergency-create.sql...</div>
      <div>Running rls-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running auth_db-create.sql...</div>
      <div>Running presence-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running cpl-create.sql...</div>
      <div>Running dialplan-create.sql...</div>
      <div>Running freeswitch_scripting-create.sql...</div>
      <div>Running rtpproxy-create.sql...</div>
      <div>Running permissions-create.sql...</div>
      <div>Running b2b_sca-create.sql...</div>
      <div>Running drouting-create.sql...</div>
      <div>Running alias_db-create.sql...</div>
      <div>Running cachedb_sql-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running domainpolicy-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>Running speeddial-create.sql...</div>
      <div>Running userblacklist-create.sql...</div>
      <div>Running imc-create.sql...</div>
      <div>Running carrierroute-create.sql...</div>
      <div>Running smpp-create.sql...</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div>ERROR: Error closing cursor</div>
      <div>Traceback (most recent call last):</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/SQLAlchemy-1.3.3-py3.5-linux-x86_64.egg/sqlalchemy/engine/base.py",
        line 1333, in _safe_close_cursor</div>
      <div>    cursor.close()</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 85, in close</div>
      <div>    while self.nextset():</div>
      <div>  File
"/usr/local/lib/python3.5/dist-packages/mysqlclient-1.3.14-py3.5-linux-x86_64.egg/MySQLdb/cursors.py",
        line 173, in nextset</div>
      <div>    nr = db.next_result()</div>
      <div>_mysql_exceptions.OperationalError: (1709, 'Index column size
        too large. The maximum column size is 767 bytes.')</div>
      <div><a href="mailto:root@sip4-master" moz-do-not-send="true">root@sip4-master</a>:~#</div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>