[OpenSIPS-Users] OpenSIPS 3 - can't create database

[David Villasmil]

Still getting errors:

root at opensip1:~# opensips-cli -x database add presence
Please provide us the URL of the database:
mysql://opensips:password@localhost
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'")

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337


On Mon, Jun 17, 2019 at 11:16 PM David Villasmil <
david.villasmil.work at gmail.com> wrote:

> 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/20190618/6c77e9e2/attachment-0001.html>