[OpenSIPS-Users] OpenSIPS 3 - can't create database
David Villasmil
david.villasmil.work at gmail.com
Mon Jun 17 23:16:52 EDT 2019
I tried removing mariaDB and installing mysql 5.6, but when creating the db
i'm getting;
Create [a]ll tables or just the [c]urrently configured ones? (Default value
is a): a
Creating all tables ...
Running standard-create.sql...
Running cachedb_sql-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running tracer-create.sql...
Running rtpengine-create.sql...
Running rls-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running closeddial-create.sql...
Running userblacklist-create.sql...
Running rtpproxy-create.sql...
Running call_center-create.sql...
Running presence-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running alias_db-create.sql...
Running carrierroute-create.sql...
Running imc-create.sql...
Running tls_mgm-create.sql...
Running avpops-create.sql...
Running load_balancer-create.sql...
Running registrant-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running b2b_sca-create.sql...
Running clusterer-create.sql...
Running acc-create.sql...
Running usrloc-create.sql...
Running cpl-create.sql...
Running b2b-create.sql...
Running freeswitch_scripting-create.sql...
Running auth_db-create.sql...
Running emergency-create.sql...
Running dialplan-create.sql...
Running domain-create.sql...
Running speeddial-create.sql...
Running drouting-create.sql...
Running domainpolicy-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running permissions-create.sql...
Running smpp-create.sql...
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
ERROR: Error closing cursor
Traceback (most recent call last):
File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
func = getattr(self, 'do_' + cmd)
AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
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
cursor.close()
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
86, in close
while self.nextset():
File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
136, in nextset
nr = db.next_result()
MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
max key length is 767 bytes')
Running fraud_detection-create.sql...
Running dispatcher-create.sql...
Running msilo-create.sql...
Running group-create.sql...
Running dialog-create.sql...
The 'opensips' database has been successfully created!
Regards,
David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
On Mon, Jun 17, 2019 at 10:57 PM David Villasmil <
david.villasmil.work at gmail.com> wrote:
> Hello guys,
>
> When executing `create database` with opensips-cli i'm getting:
>
> root at opensip1:~# opensips-cli
> mysql://opensips:password@127.0.0.1
> Welcome to OpenSIPS Command Line Interface!
> (opensips-cli): database create
> Please provide us the URL of the database: mysql://opensips:password@
> 127.0.0.1
> Create [a]ll tables or just the [c]urrently configured ones? (Default
> value is a): a
> Creating all tables ...
> Running standard-create.sql...
> Running cachedb_sql-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running tracer-create.sql...
> Running rtpengine-create.sql...
> Running rls-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running closeddial-create.sql...
> Running userblacklist-create.sql...
> Running rtpproxy-create.sql...
> Running call_center-create.sql...
> Running presence-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running alias_db-create.sql...
> Running carrierroute-create.sql...
> Running imc-create.sql...
> Running tls_mgm-create.sql...
> Running avpops-create.sql...
> Running load_balancer-create.sql...
> Running registrant-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running b2b_sca-create.sql...
> Running clusterer-create.sql...
> Running acc-create.sql...
> Running usrloc-create.sql...
> Running cpl-create.sql...
> Running b2b-create.sql...
> Running freeswitch_scripting-create.sql...
> Running auth_db-create.sql...
> Running emergency-create.sql...
> Running dialplan-create.sql...
> Running domain-create.sql...
> Running speeddial-create.sql...
> Running drouting-create.sql...
> Running domainpolicy-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running permissions-create.sql...
> Running smpp-create.sql...
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> ERROR: Error closing cursor
> Traceback (most recent call last):
> File "/usr/lib/python3.5/cmd.py", line 214, in onecmd
> func = getattr(self, 'do_' + cmd)
> AttributeError: 'OpenSIPSCLIShell' object has no attribute 'do_database'
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> 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
> cursor.close()
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 86, in close
> while self.nextset():
> File "/usr/local/lib/python3.5/dist-packages/MySQLdb/cursors.py", line
> 136, in nextset
> nr = db.next_result()
> MySQLdb._exceptions.OperationalError: (1071, 'Specified key was too long;
> max key length is 767 bytes')
> Running fraud_detection-create.sql...
> Running dispatcher-create.sql...
> Running msilo-create.sql...
> Running group-create.sql...
> Running dialog-create.sql...
> The 'opensips' database has been successfully created!
>
>
> Regards,
>
> David Villasmil
> email: david.villasmil.work at gmail.com
> phone: +34669448337
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20190617/172222db/attachment-0001.html>
More information about the Users
mailing list