Anyone running msnoise with mysql on Ubuntu? I have a working monitoring setup using sqllite, but want to take advantage of multi threading, so want to move over mysql. Whenever I try and select mysql in msnoise install it spits out; auth_packet = self._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.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'ashton'@'localhost' (using password: YES)") I've tried with sudo/root, etc. Suggestions? -ashton

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(unbuff ered=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(unbuff ered=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: Hi, > > you should: > > 1/ make sure MySQL is installed (looks OK) > > 2/ create a priviliged user > > 3/ create a msnoise database (whatever the name) > > 4/ msnoise install -> provide the good details > > > Thomas > > On 02/02/2017 20:51, Flinders, Ashton wrote: > > Anyone running msnoise with mysql on Ubuntu? I have a working >> monitoring >> setup using sqllite, but want to take advantage of multi threading, so >> want >> to move over mysql. Whenever I try and select mysql in msnoise >> install it >> spits out; >> >> auth_packet = self._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.OperationalError: (pymysql.err.OperationalError) >> (1045, >> "Access denied for user 'ashton'@'localhost' (using password: YES)") >> >> I've tried with sudo/root, etc. Suggestions? >> >> -ashton >> >> >> >> _______________________________________________ > MSNoise mailing list > MSNoise(a)mailman-as.oma.be > http://mailman-as.oma.be/mailman/listinfo/msnoise > > > -- Ashton F. Flinders, Ph.D U.S. Geological Survey 345 Middlefield Road Menlo Park, CA 94025 (650) 329-5050