Ok, so i uninstalled mysql 5.6 and installed 5.7 and all built properly. Thanks everyone!
Regards, David Villasmil email: david.villasmil.w...@gmail.com phone: +34669448337 On Tue, Jun 18, 2019 at 8:29 AM David Villasmil < david.villasmil.w...@gmail.com> wrote: > Thanks for replying guys, > > Yeah this also happens on K, but in K’s case I get. Prompt to provide a > collation... > > I’ll try your suggestion, thanks!! > > David > > On Tue, 18 Jun 2019 at 03:39, Liviu Chircu <li...@opensips.org> wrote: > >> Good spot, that is exactly the problem! This issue seems to be more >> prevalent with MariaDB, >> where the default database charset is "utf8mb4", and not "latin1" as in >> the MySQL packages. >> >> This answer[1] also includes some MariaDB server settings which should >> allow the creation >> of keys on VARCHAR(255) columns even if using the utf8mb4 charset. >> [1]: https://stackoverflow.com/a/36405914/2054305 >> >> Liviu Chircu >> OpenSIPS Developerhttp://www.opensips-solutions.com >> >> On 18.06.2019 10:31, Callum Guy wrote: >> >> Hi David, >> >> This seems to be a database collation issue - did you create the database >> manually and do you have the option to change the charset? >> >> >> https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes >> >> Not sure what the correct options would be for you however I am sure you >> can work that out :) >> >> Good luck! >> >> On Tue, 18 Jun 2019 at 03:59, David Villasmil < >> david.villasmil.w...@gmail.com> wrote: >> >>> Hello guys, >>> >>> When executing `create database` with opensips-cli i'm getting: >>> >>> root@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') >>> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > -- > Regards, > > David Villasmil > email: david.villasmil.w...@gmail.com > phone: +34669448337 >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users