3 Feb
2017
3 Feb
'17
6:46 p.m.
Will do Thomas!
On Thu, Feb 2, 2017 at 10:59 PM, Thomas Lecocq <Thomas.Lecocq(a)seismology.be>
wrote:
Hi Ashton
Sorry to say this, but it's not an msnoise problem. So you should check
with your sysadmins or IT specialists. I don't know MariaDB default
configurations either, so I can't help.
Good luck & please let me know what the solution was at the end,
Thomas
On 03/02/2017 02:45, Flinders, Ashton wrote:
--
Ashton F. Flinders, Ph.D
U.S. Geological Survey
345 Middlefield Road
Menlo Park, CA 94025
(650) 329-5050
ps;
sudo mysqld --innodb_large_prefix=1 --innodb_file_format=barracuda
--innodb_file_per_table=1 &
doesnt seem to make a difference....
On Thu, Feb 2, 2017 at 3:26 PM, Flinders, Ashton <aflinders(a)usgs.gov>
wrote:
Follow-up;
_______________________________________________
MSNoise mailing list
MSNoise(a)mailman-as.oma.be
http://mailman-as.oma.be/mailman/listinfo/msnoise
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> 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