<div dir="ltr"><div>Still getting errors:</div><div><br></div><div>root@opensip1:~# opensips-cli -x database add presence<br>Please provide us the URL of the database: mysql://opensips:password@localhost<br>ERROR: cannot import: cannot deploy /usr/share/opensips/mysql/presence-create.sql file: (MySQLdb._exceptions.IntegrityError) (1062, "Duplicate entry 'presentity' for key 't_name_idx'")</div><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_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><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jun 17, 2019 at 11:16 PM 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>I tried removing mariaDB and installing mysql 5.6, but when creating the db i'm getting;</div><div><br></div><div><span style="font-family:courier new,monospace">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><div><div dir="ltr" class="gmail-m_-2231247338715664233gmail_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><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jun 17, 2019 at 10:57 PM David Villasmil <<a href="mailto:david.villasmil.work@gmail.com" target="_blank">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_-2231247338715664233gmail-m_-3031957639631603645gmail_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>
</blockquote></div>
</blockquote></div>