[OpenSIPS-Users] OpenSIPS 3 - can't create database
David Villasmil
david.villasmil.work at gmail.com
Mon Jun 17 22:57:51 EDT 2019
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/6f0fe414/attachment-0001.html>
More information about the Users
mailing list