Re: [MSNoise] mysql on ubuntu

Follow-up; MariaDB [(none)]> SELECT User FROM mysql.user; +---------+ | User | +---------+ | msnoise | | root | +---------+ MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | msnoise | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.01 sec) so msnoise user exists (password is msnoise) and msnoise database exist.... $sudo msnoise install Launching the installer Welcome to MSNoise What database technology do you want to use? [1] sqlite [2] mysql Choice:2 Server: [127.0.0.1]: Database: [msnoise]: Username: [msnoise]: Password: [msnoise]: fails with; sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1071, 'Specified key was too long; max key length is 767 bytes') [SQL: '\nCREATE TABLE config (\n\tname VARCHAR(255) NOT NULL, \n\tvalue VARCHAR(255), \n\tPRIMARY KEY (name)\n)\n\n'] output....... Traceback (most recent call last): File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 166, in execute result = self._query(query) File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 835, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1019, in _read_query_result result.read() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1302, in read first_packet = self.connection._read_packet() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 981, in _read_packet packet.check_error() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.InternalError: (1071, 'Specified key was too long; max key length is 767 bytes') The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/local/bin/msnoise", line 9, in <module> load_entry_point('msnoise==1.4.1', 'console_scripts', 'msnoise')() File "/usr/local/lib/python3.5/dist-packages/msnoise-1.4.1- py3.5.egg/msnoise/scripts/msnoise.py", line 681, in run cli(obj={}) File "/home/ashton/.local/lib/python3.5/site-packages/click/core.py", line 716, in __call__ return self.main(*args, **kwargs) File "/home/ashton/.local/lib/python3.5/site-packages/click/core.py", line 696, in main rv = self.invoke(ctx) File "/home/ashton/.local/lib/python3.5/site-packages/click/core.py", line 1060, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/ashton/.local/lib/python3.5/site-packages/click/core.py", line 889, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/ashton/.local/lib/python3.5/site-packages/click/core.py", line 534, in invoke return callback(*args, **kwargs) File "/usr/local/lib/python3.5/dist-packages/msnoise-1.4.1- py3.5.egg/msnoise/scripts/msnoise.py", line 221, in install main() File "/usr/local/lib/python3.5/dist-packages/msnoise-1.4.1- py3.5.egg/msnoise/s000installer.py", line 90, in main Base.metadata.create_all(engine) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/schema.py", line 3748, in create_all tables=tables) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor conn._run_visitor(visitorcallable, element, **kwargs) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor **kwargs).traverse_single(element) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single return meth(obj, **kw) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata _is_metadata_operation=True) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single return meth(obj, **kw) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table include_foreign_key_constraints=include_foreign_key_constraints File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl compiled File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 185, in reraise raise value.with_traceback(tb) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/ashton/.local/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 166, in execute result = self._query(query) File "/usr/local/lib/python3.5/dist-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 835, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1019, in _read_query_result result.read() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 1302, in read first_packet = self.connection._read_packet() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 981, in _read_packet packet.check_error() File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.InternalError: (pymysql.err.InternalError) (1071, 'Specified key was too long; max key length is 767 bytes') [SQL: '\nCREATE TABLE config (\n\tname VARCHAR(255) NOT NULL, \n\tvalue VARCHAR(255), \n\tPRIMARY KEY (name)\n)\n\n'] On Thu, Feb 2, 2017 at 12:08 PM, Thomas Lecocq < Thomas.Lecocq(a)seismology.be&gt; wrote: -- Ashton F. Flinders, Ph.D U.S. Geological Survey 345 Middlefield Road Menlo Park, CA 94025 (650) 329-5050