Commit graph

51 commits

Author SHA1 Message Date
noelmcloughlin
043007677e doc(example): update pillar.example for strict ansi 2020-11-30 16:49:02 +00:00
Yoda-BZH
8eccd5a68c
feat(socket_authentication): allow unix_socket authentication
Co-authored-by: Tristan Charbonneau <tcharbonneau@oceanet-technology.com>
2020-07-10 16:12:24 +01:00
Imran Iqbal
9f739fa8b4
feat(yamllint): include for this repo and apply rules throughout
* Semi-automated using `ssf-formula` (v0.5.0)
* Fix (or ignore) errors shown below:

```bash
mysql-formula$ $(grep "\- yamllint" .travis.yml | sed -e "s:^\s\+-\s\(.*\):\1:")
./mysql/osfamilymap.yaml
  4:1       warning  missing document start "---"  (document-start)
  5:6       error    syntax error: found character '%' that cannot start any token
  94:17     error    trailing spaces  (trailing-spaces)
  191:89    error    line too long (90 > 88 characters)  (line-length)

./mysql/defaults.yaml
  3:1       warning  missing document start "---"  (document-start)
  7:4       error    syntax error: found character '%' that cannot start any token
  44:89     error    line too long (93 > 88 characters)  (line-length)
  51:89     error    line too long (111 > 88 characters)  (line-length)
  58:89     error    line too long (104 > 88 characters)  (line-length)
  65:89     error    line too long (103 > 88 characters)  (line-length)
  71:89     error    line too long (95 > 88 characters)  (line-length)
  77:89     error    line too long (102 > 88 characters)  (line-length)
  83:89     error    line too long (101 > 88 characters)  (line-length)
  86:89     error    line too long (95 > 88 characters)  (line-length)
  90:89     error    line too long (95 > 88 characters)  (line-length)

./mysql/supported_sections.yaml
  2:2       error    syntax error: found character '%' that cannot start any token

./mysql/osmap.yaml
  4:4       error    syntax error: found character '%' that cannot start any token
  7:89      error    line too long (96 > 88 characters)  (line-length)
  8:89      error    line too long (97 > 88 characters)  (line-length)

pillar.example
  1:1       warning  missing document start "---"  (document-start)
  36:8      error    wrong indentation: expected 8 but found 7  (indentation)
  77:16     warning  truthy value should be one of [false, true]  (truthy)
  80:13     warning  truthy value should be one of [false, true]  (truthy)
  83:13     warning  truthy value should be one of [false, true]  (truthy)
  85:13     warning  truthy value should be one of [false, true]  (truthy)
  89:13     warning  truthy value should be one of [false, true]  (truthy)
  96:13     warning  truthy value should be one of [false, true]  (truthy)
  112:19    warning  truthy value should be one of [false, true]  (truthy)
  117:17    warning  too few spaces before comment  (comments)
  118:12    warning  truthy value should be one of [false, true]  (truthy)
  119:17    warning  truthy value should be one of [false, true]  (truthy)
  130:25    warning  truthy value should be one of [false, true]  (truthy)
  131:19    warning  truthy value should be one of [false, true]  (truthy)
  153:16    warning  truthy value should be one of [false, true]  (truthy)
  166:14    warning  truthy value should be one of [false, true]  (truthy)
  171:18    warning  truthy value should be one of [false, true]  (truthy)
  172:89    error    line too long (93 > 88 characters)  (line-length)
  175:18    warning  truthy value should be one of [false, true]  (truthy)
  176:89    error    line too long (111 > 88 characters)  (line-length)
  179:18    warning  truthy value should be one of [false, true]  (truthy)
  179:26    warning  missing starting space in comment  (comments)
  180:89    error    line too long (104 > 88 characters)  (line-length)
  183:18    warning  truthy value should be one of [false, true]  (truthy)
  183:26    warning  missing starting space in comment  (comments)
  184:89    error    line too long (103 > 88 characters)  (line-length)
  187:18    warning  truthy value should be one of [false, true]  (truthy)
  187:26    warning  missing starting space in comment  (comments)
  188:89    error    line too long (95 > 88 characters)  (line-length)
  191:18    warning  truthy value should be one of [false, true]  (truthy)
  191:26    warning  missing starting space in comment  (comments)
  192:89    error    line too long (102 > 88 characters)  (line-length)
  195:18    warning  truthy value should be one of [false, true]  (truthy)
  195:26    warning  missing starting space in comment  (comments)
  196:89    error    line too long (101 > 88 characters)  (line-length)
  199:18    warning  truthy value should be one of [false, true]  (truthy)
  199:26    warning  missing starting space in comment  (comments)
  200:89    error    line too long (95 > 88 characters)  (line-length)
  203:18    warning  truthy value should be one of [false, true]  (truthy)
  203:26    warning  missing starting space in comment  (comments)
  204:89    error    line too long (95 > 88 characters)  (line-length)
  207:18    warning  truthy value should be one of [false, true]  (truthy)
  207:26    warning  missing starting space in comment  (comments)
  211:18    warning  truthy value should be one of [false, true]  (truthy)
  211:26    warning  missing starting space in comment  (comments)
  214:1     error    too many blank lines (1 > 0)  (empty-lines)

test/salt/pillar/mysql.sls
  1:1       warning  missing document start "---"  (document-start)
  36:8      error    wrong indentation: expected 8 but found 7  (indentation)
  77:16     warning  truthy value should be one of [false, true]  (truthy)
  80:13     warning  truthy value should be one of [false, true]  (truthy)
  82:13     warning  truthy value should be one of [false, true]  (truthy)
  84:13     warning  truthy value should be one of [false, true]  (truthy)
  88:13     warning  truthy value should be one of [false, true]  (truthy)
  95:13     warning  truthy value should be one of [false, true]  (truthy)
  111:19    warning  truthy value should be one of [false, true]  (truthy)
  152:16    warning  truthy value should be one of [false, true]  (truthy)
  165:14    warning  truthy value should be one of [false, true]  (truthy)
  170:18    warning  truthy value should be one of [false, true]  (truthy)
  171:89    error    line too long (93 > 88 characters)  (line-length)
  174:18    warning  truthy value should be one of [false, true]  (truthy)
  175:89    error    line too long (111 > 88 characters)  (line-length)
  178:18    warning  truthy value should be one of [false, true]  (truthy)
  178:26    warning  missing starting space in comment  (comments)
  179:89    error    line too long (104 > 88 characters)  (line-length)
  182:18    warning  truthy value should be one of [false, true]  (truthy)
  182:26    warning  missing starting space in comment  (comments)
  183:89    error    line too long (103 > 88 characters)  (line-length)
  186:18    warning  truthy value should be one of [false, true]  (truthy)
  186:26    warning  missing starting space in comment  (comments)
  187:89    error    line too long (95 > 88 characters)  (line-length)
  190:18    warning  truthy value should be one of [false, true]  (truthy)
  190:26    warning  missing starting space in comment  (comments)
  191:89    error    line too long (102 > 88 characters)  (line-length)
  194:18    warning  truthy value should be one of [false, true]  (truthy)
  194:26    warning  missing starting space in comment  (comments)
  195:89    error    line too long (101 > 88 characters)  (line-length)
  198:18    warning  truthy value should be one of [false, true]  (truthy)
  198:26    warning  missing starting space in comment  (comments)
  199:89    error    line too long (95 > 88 characters)  (line-length)
  202:18    warning  truthy value should be one of [false, true]  (truthy)
  202:26    warning  missing starting space in comment  (comments)
  203:89    error    line too long (95 > 88 characters)  (line-length)
  206:18    warning  truthy value should be one of [false, true]  (truthy)
  206:26    warning  missing starting space in comment  (comments)
  210:18    warning  truthy value should be one of [false, true]  (truthy)
  210:26    warning  missing starting space in comment  (comments)
  213:1     error    too many blank lines (1 > 0)  (empty-lines)
```
2019-08-17 00:41:39 +01:00
Imran Iqbal
bdee94aaed
fix(connector): fix typos (connnector) and missing enabled 2019-08-08 15:36:34 +01:00
Alexander Weidinger
3633a6ec84 Allow to remove DB 2019-04-09 23:59:44 +02:00
Alexander Weidinger
d1de0fdfc6 Allow to remove DB user 2019-04-09 23:40:18 +02:00
james@getsurreal.com
e156ddaf6e Include pillar example for granting permissions to user on Any host 2019-01-18 21:27:24 -06:00
N
8f2e6ad770
Merge pull request #168 from nesteves/master
Allow the use of wildcards on a user's database/table names when defining grants.
2018-12-18 22:59:39 +00:00
Nuno Esteves
e540589cb0 Include an example of using a wildcard with a reference to salt/saltstack#41178. Thanks to @scambra for the fix. 2018-12-18 22:35:51 +00:00
N
a7145a59da
Add config section to pillar example 2018-12-12 22:27:12 +00:00
Shannon Little
eba57badd3 Updated example pillar name overrides to match new keys 2018-11-01 16:19:46 -06:00
N
4cdc21bc92
Add install/remove states for MacOS (downloads.mysql.com) 2018-10-02 09:33:02 +01:00
Marius Kotsbak
4a8a9bf69a Make formula relative to actual directory by using 'tpldir' 2018-05-18 19:58:35 +02:00
Alexander Weidinger
239a2aae05 Fix lookup docs in pillar.example 2018-03-14 21:55:24 +01:00
Eduardo Speroni
71c12e4a27 Added charset and collate support, ensuring backwards compatibility 2018-02-02 11:51:32 -02:00
Nuno Esteves
7a386578b7 Allow the use of wildcards on a user's database/table names when defining grants. 2017-08-15 23:06:12 +01:00
Andres Montalban
e29b770f20 Initial configuration of automated tests 2016-10-29 10:41:23 -03:00
Glenn E. Bailey III
f56f39b113 Made datadir dynamic 2016-10-09 18:25:43 +00:00
Mikhail Lesyk
2ca2e8b04d add ability to specify repating keys
example:
binlog-ignore-db:
 - mysql
 - sys
 - information_schema
 - performance_schema
2016-10-02 13:43:22 +03:00
Matthew X. Economou
0611f52616
Add two examples of using the template context 2016-09-11 06:27:51 -04:00
Christoffer Stokbaek
0afbd11a21 Added pillar data for SSL option 2016-08-16 14:19:53 +02:00
Heinz Wiesinger
22d08ec1f3 Add support for fetching user hosts from salt mine. 2016-04-06 12:15:42 +02:00
Arthur Lutz
a4c87ee46e typo in comment 2016-01-28 12:53:26 +01:00
Nitin Madhok
8a59137dc4 Merge pull request #96 from M2Mobi/master
Add better support for a config directory with split config files.
2015-11-24 02:12:56 -05:00
Heinz Wiesinger
e72c1c12d3 Add states for optional dedicated salt user instead of root. 2015-10-08 17:40:04 +02:00
Heinz Wiesinger
0febad19c1 Add better support for a config directory with split config files.
This adds optional support for having split configuration files
within a config directory, most commonly /etc/my.cnf.d.
2015-10-05 21:50:19 +02:00
Heinz Wiesinger
d15e431468 Fix trailing whitespaces. 2015-10-05 21:44:20 +02:00
C John Klehm
425b5e54e3 Update root_password example to use ''
The value of False does not work for me on Ubuntu Vivid. Using '' everything works as expected.
2015-06-24 13:18:30 -04:00
zhujinhe
d7f363a1e1 fix typo
replace tabs to 2 spaces, tabs eads yaml syntax error on line 73,74
2015-06-02 10:50:38 +08:00
Matthew X. Economou
026c5cea4a Add example 'mysql:server:root_user' key-value pair. 2015-05-18 10:49:17 -04:00
Tobias Alex-Petersen
462c2f4034 Add possibility of using another host (for db and user management) 2015-04-15 19:40:39 +02:00
Ross Perkins
55728f028b Added pillar.example of templated schema file 2015-03-18 12:45:24 -07:00
Alex Hayes
e3adb37df1 Ensured newline at end of pillar.example as per request of upstream. 2015-03-10 07:40:19 +11:00
Alex Hayes
5546542b19 Merge branch 'master' of https://github.com/saltstack-formulas/mysql-formula into feature/mysql-dev
Conflicts:
	README.rst
2015-03-10 07:38:55 +11:00
root
f03d88a759 1) Supported params list deleted, because it's hard to keep it fresh (there was cool parser by davidjb, but it does not take care of underscores and hiphen in options names). Now all parameters considering supported, and all hiphen will be replaced with underscore when salt creates my.cnf. Thats why all default parameters changed to underscore type.
2) Fixed bug with empty config append parameter
3) Fixed bug with empty root password applying
2014-12-12 10:05:39 +08:00
Alex Hayes
34515c7b50 Add state 'mysql.dev' that provides support for installing MySQL development libraries and header files. 2014-12-12 09:20:09 +11:00
Sonia Hamilton
2a81e0a499 Correct examples for replication. 2014-11-27 10:45:35 +00:00
Scott Reeves
686dcf293f Use a dict instead of a list for users 2014-11-02 00:57:27 -04:00
root
c55c2a4c46 Add support table param for mysql.user state (by default table is *)
Add support of changing/adding any attribute in my.cnf. NB!!! It breaks backward compatibility for mysql.server state.
Delete mysql_size param support (now you can customiza all my.cnf parameters in pillar)
Add script import_users.py that create user pillar for existent server
Add support root@localhost mysql user without password (root_password = False)
Add support of grant_option
2014-09-29 00:08:11 +09:00
tiger-seo
a3784bd124 allow to add users without password 2014-08-07 19:47:48 +03:00
Brandon Matthews
ef312bc5e5 clever way to load DB schemas in 2014.1 2014-07-26 23:48:56 -07:00
Nate Houk
3a6b8bd067 Fix typo 2014-06-19 22:48:59 +02:00
Clayton Kramer
d81c6341e9 Added support for MySQL hashed user password. Also added some improved YAML quoting around passwords. 2014-05-15 16:40:02 -04:00
Clayton Kramer
35be06db0c Create and manage MySQL database users with definable GRANT privileges. 2014-05-12 12:24:16 -04:00
Clayton Kramer
88f80b06a6 Create and manage MySQL databases on the server 2014-05-12 11:47:51 -04:00
Clayton Kramer
101f7ffb59 Updated pillar example and README for new debconf mysql root password feature 2014-05-12 11:10:51 -04:00
Seth House
9f3678bbe2 Renamed package-map.jinja to map.jinja; is used for more than package names 2013-09-03 13:34:10 -06:00
Seth House
bbcfb3c7d6 Moved the mysql-python package names into package-map.jinja 2013-08-22 16:13:37 -06:00
Seth House
4956d7d669 Added pillar example of overriding names via pillar 2013-08-22 15:51:52 -06:00
Kenneth Wilke
4d940f9ecf Started work on mysqld config templates 2013-08-19 10:03:59 -05:00