Skip to content

Instantly share code, notes, and snippets.

/error.txt Secret

Created March 13, 2017 20:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/02c5fca15ef87b2aebb5b26d8dae53b4 to your computer and use it in GitHub Desktop.
Save anonymous/02c5fca15ef87b2aebb5b26d8dae53b4 to your computer and use it in GitHub Desktop.
----------
ID: mysqlInstall
Function: pkg.installed
Result: True
Comment: 3 targeted packages were installed/updated.
Started: 14:53:22.473558
Duration: 29369.308 ms
Changes:
----------
libaio1:
----------
new:
0.3.110-2
old:
libcgi-fast-perl:
----------
new:
1:2.10-1
old:
libcgi-pm-perl:
----------
new:
4.26-1
old:
libencode-locale-perl:
----------
new:
1.05-1
old:
libevent-core-2.0-5:
----------
new:
2.0.21-stable-2ubuntu0.16.04.1
old:
libfcgi-perl:
----------
new:
0.77-1build1
old:
libhtml-parser-perl:
----------
new:
3.72-1
old:
libhtml-tagset-perl:
----------
new:
3.20-2
old:
libhtml-template-perl:
----------
new:
2.95-2
old:
libhttp-date-perl:
----------
new:
6.02-1
old:
libhttp-message-perl:
----------
new:
6.11-1
old:
libio-html-perl:
----------
new:
1.001-1
old:
liblwp-mediatypes-perl:
----------
new:
6.02-1
old:
libmysqlclient-dev:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
libmysqlclient20:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
libtimedate-perl:
----------
new:
2.3000-2
old:
liburi-perl:
----------
new:
1.71-1
old:
mysql-client-5.7:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
mysql-client-core-5.7:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
mysql-common:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
mysql-common-5.6:
----------
new:
1
old:
mysql-server:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
mysql-server-5.7:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
mysql-server-core-5.7:
----------
new:
5.7.17-0ubuntu0.16.04.1
old:
python-mysqldb:
----------
new:
1.3.7-1build2
old:
python2.7-mysqldb:
----------
new:
1
old:
timedate:
----------
new:
1
old:
virtual-mysql-client:
----------
new:
1
old:
virtual-mysql-client-core:
----------
new:
1
old:
virtual-mysql-server:
----------
new:
1
old:
virtual-mysql-server-core:
----------
new:
1
old:
----------
ID: root
Function: mysql_user.present
Result: False
Comment: An exception occurred in this state: Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/salt/state.py", line 1626, in call
**cdata['kwargs'])
File "/usr/lib/python2.7/dist-packages/salt/loader.py", line 1492, in wrapper
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/salt/states/mysql_user.py", line 141, in present
**connection_args):
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 1042, in user_exists
dbc = _connect(**connection_args)
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 303, in _connect
dbc = MySQLdb.connect(**connargs)
File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
self.connect()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect
self._request_authentication()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication
auth_packet = self._read_packet()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
packet.check_error()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
raise InternalError(errno, errorvalue)
InternalError: (1698, u"Access denied for user 'root'@'localhost'")
Started: 14:53:51.845431
Duration: 4.465 ms
Changes:
----------
ID: mysql-base
Function: mysql_database.present
Name: test_default
Result: False
Comment: An exception occurred in this state: Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/salt/state.py", line 1626, in call
**cdata['kwargs'])
File "/usr/lib/python2.7/dist-packages/salt/loader.py", line 1492, in wrapper
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/salt/states/mysql_database.py", line 51, in present
if __salt__['mysql.db_exists'](name, **connection_args):
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 875, in db_exists
dbc = _connect(**connection_args)
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 303, in _connect
dbc = MySQLdb.connect(**connargs)
File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
self.connect()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect
self._request_authentication()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication
auth_packet = self._read_packet()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
packet.check_error()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
raise InternalError(errno, errorvalue)
InternalError: (1698, u"Access denied for user 'root'@'localhost'")
Started: 14:53:51.850230
Duration: 3.344 ms
Changes:
----------
ID: mysql-base
Function: mysql_user.present
Name: test
Result: False
Comment: An exception occurred in this state: Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/salt/state.py", line 1626, in call
**cdata['kwargs'])
File "/usr/lib/python2.7/dist-packages/salt/loader.py", line 1492, in wrapper
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/salt/states/mysql_user.py", line 141, in present
**connection_args):
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 1042, in user_exists
dbc = _connect(**connection_args)
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 303, in _connect
dbc = MySQLdb.connect(**connargs)
File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
self.connect()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect
self._request_authentication()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication
auth_packet = self._read_packet()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
packet.check_error()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
raise InternalError(errno, errorvalue)
InternalError: (1698, u"Access denied for user 'root'@'localhost'")
Started: 14:53:51.853704
Duration: 4.027 ms
Changes:
----------
ID: testDB_Grants
Function: mysql_grants.present
Result: False
Comment: An exception occurred in this state: Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/salt/state.py", line 1626, in call
**cdata['kwargs'])
File "/usr/lib/python2.7/dist-packages/salt/loader.py", line 1492, in wrapper
return f(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/salt/states/mysql_grants.py", line 150, in present
grant, database, user, host, grant_option, escape, **connection_args
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 1612, in grant_exists
grants = user_grants(user, host, **connection_args)
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 1556, in user_grants
if not user_exists(user, host, **connection_args):
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 1042, in user_exists
dbc = _connect(**connection_args)
File "/usr/lib/python2.7/dist-packages/salt/modules/mysql.py", line 303, in _connect
dbc = MySQLdb.connect(**connargs)
File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 679, in __init__
self.connect()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 891, in connect
self._request_authentication()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1097, in _request_authentication
auth_packet = self._read_packet()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet
packet.check_error()
File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
raise InternalError(errno, errorvalue)
InternalError: (1698, u"Access denied for user 'root'@'localhost'")
Started: 14:53:51.858554
Duration: 5.687 ms
Changes:
Summary
------------
Succeeded: 1 (changed=1)
Failed: 4
------------
Total states run: 5
mysqlInstall:
pkg.installed:
- pkgs:
- python-mysqldb
- mysql-server
- libmysqlclient-dev
root:
mysql_user.present:
- host: localhost
- password: "myPassword"
mysql-base:
mysql_database.present:
- name: test_default
- connection_user: root
- connection_pass: "myPassword"
mysql_user.present:
- name: test
- host: localhost
- password: "password"
- connection_user: root
- connection_pass: "myPassword"
testDB_Grants:
mysql_grants.present:
- grant: all privileges
- database: test.*
- user: test
- host: localhost
- connection_user: root
- connection_pass: "myPassword"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment