[MSNoise] mysql on ubuntu

[Thomas Lecocq]

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
>
>