<div dir="ltr">Hi David,<br><div><br></div><div>This seems to be a database collation issue - did you create the database manually and do you have the option to change the charset?</div><div><br></div><div><a href="https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes">https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes</a><br></div><div><br></div><div>Not sure what the correct options would be for you however I am sure you can work that out :)</div><div><br></div><div>Good luck!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 18 Jun 2019 at 03:59, David Villasmil <<a href="mailto:david.villasmil.work@gmail.com">david.villasmil.work@gmail.com</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"><div>Hello guys,</div><div><br></div><div>When executing `create database` with opensips-cli i'm getting:</div><div><br></div><div><span style="font-family:"courier new",monospace">root@opensip1:~# opensips-cli</span></div><div><span style="font-family:"courier new",monospace">mysql://opensips:<span style="font-family:"courier new",monospace">password</span>@<a href="http://127.0.0.1" target="_blank">127.0.0.1</a><br>Welcome to OpenSIPS Command Line Interface!<br>(opensips-cli): database create<br>Please provide us the URL of the database: mysql://opensips:<span style="font-family:"courier new",monospace">password</span>@<a href="http://127.0.0.1" target="_blank">127.0.0.1</a><br>Create [a]ll tables or just the [c]urrently configured ones? (Default value is a): a<br>Creating all tables ...<br>Running standard-create.sql...<br>Running cachedb_sql-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running tracer-create.sql...<br>Running rtpengine-create.sql...<br>Running rls-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running closeddial-create.sql...<br>Running userblacklist-create.sql...<br>Running rtpproxy-create.sql...<br>Running call_center-create.sql...<br>Running presence-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running alias_db-create.sql...<br>Running carrierroute-create.sql...<br>Running imc-create.sql...<br>Running tls_mgm-create.sql...<br>Running avpops-create.sql...<br>Running load_balancer-create.sql...<br>Running registrant-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running b2b_sca-create.sql...<br>Running clusterer-create.sql...<br>Running acc-create.sql...<br>Running usrloc-create.sql...<br>Running cpl-create.sql...<br>Running b2b-create.sql...<br>Running freeswitch_scripting-create.sql...<br>Running auth_db-create.sql...<br>Running emergency-create.sql...<br>Running dialplan-create.sql...<br>Running domain-create.sql...<br>Running speeddial-create.sql...<br>Running drouting-create.sql...<br>Running domainpolicy-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running permissions-create.sql...<br>Running smpp-create.sql...<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>ERROR: Error closing cursor<br>Traceback (most recent call last):<br> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd<br> func = getattr(self, 'do_' + cmd)<br>AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'<br><br>During handling of the above exception, another exception occurred:<br><br>Traceback (most recent call last):<br> 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<br> cursor.close()<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 86, in close<br> while self.nextset():<br> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line 136, in nextset<br> nr = db.next_result()<br>MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')<br>Running fraud_detection-create.sql...<br>Running dispatcher-create.sql...<br>Running msilo-create.sql...<br>Running group-create.sql...<br>Running dialog-create.sql...<br>The 'opensips' database has been successfully created!</span></div><div><br></div><div><br></div><div><div><div dir="ltr" class="gmail-m_4278107843918694248gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>David Villasmil<div>email: <a href="mailto:david.villasmil.work@gmail.com" target="_blank">david.villasmil.work@gmail.com</a></div><div>phone: +34669448337</div></div></div></div></div></div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div>
<br>
<p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;text-align:justify"><font size="3" face="Verdana"><span style="font-size:8px;color:rgb(0,0,0);background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline"></span></font></p><div><img src="https://www.x-on.co.uk/email/footer/banner-surgeryconnect-jun-sep-19.jpg"></div><div><br></div><div><div><div><font size="4"><b><sup><font face="Verdana">0333 332 0000 | <a href="http://www.x-on.co.uk" target="_blank">www.x-on.co.uk</a> | <sub> </sub></font></sup></b></font><font size="4"><b><sub><sup><font face="Verdana"><a href="https://www.linkedin.com/company/x-on" target="_blank"><img src="http://www.x-on.co.uk//images/icon/linkedin.png" width="24" height="24"></a> <a href="https://www.facebook.com/XonTel" target="_blank"><img src="http://www.x-on.co.uk//images/icon/facebook.png" width="24" height="24"></a> <a href="https://twitter.com/xonuk" target="_blank"><img src="http://www.x-on.co.uk//images/icon/twitter.png" width="24" height="24"></a></font></sup></sub> </b></font><br><p><span style="font-size:6.0pt;font-family:Verdana;color:black">X-on
is a trading name of Storacall Technology Ltd a limited company registered in
England and Wales.<br>
Registered Office : Avaland House, 110 London Road, Apsley, Hemel Hempstead,
Herts, HP3 9SD. Company Registration No. 2578478.<br>
The information in this e-mail is confidential and for use by the addressee(s)
only. If you are not the intended recipient, please notify X-on immediately on <span>+44(0)333 332 0000</span> and delete the<br>message from your computer. If you are not a named addressee you must not use,
disclose, disseminate, distribute, copy, print or reply to this email. </span><span style="font-size:6.0pt;font-family:Verdana;color:black">Views
or opinions expressed by an individual<br>within this email may not necessarily
reflect the views of X-on or its associated companies. Although X-on routinely
screens for viruses, addressees should scan this email and any attachments<br>for
viruses. X-on makes no representation or warranty as to the absence of viruses
in this email or any attachments.</span></p>
<p><span style="font-size:6.0pt;font-family:Verdana;color:black"></span><font size="2"><span style="font-size:6.0pt;font-family:Verdana;color:black"></span></font></p></div></div></div>