nixsap
nixsap copied to clipboard
ip1981
Support signing backups in mysqlbackup, pgbackup, filebackup. After #14
Objective: make Jenkins able to deploy itself. This requires graceful shutdown _after_ all jobs are done. Then systemd will start Jenkins again, probably new version of it. Jenkins may expose...
Roles are messed and don't work as intended: https://github.com/ip1981/nixsap/blob/62f28d30a069135f9c48678507203958adfc334f/modules/apps/mariadb/roles.nix#L180 - [x] `nixsap` should not be there. - [ ] It should not allow anything except listed privileges (`SELECT`, `DELETE`, etc.),...
Generalize passing Java properties, e. g. for Jenkins or Cassandra. Whatever in `jre.properties` should be automatically and correctly passed to JRE. For example see MariaDB or PostgreSQL: ``` jre =...
[xinclude2nix](https://github.com/ip1981/nixsap/blob/master/modules/pkgs/xinclude2nix/xinclude2nix.hs) should fail on unavailable files.
See #19 for the idea. Postgresql supports inclusion of configuration files and reread them on signal or calling SQL function.
Changing some options without restart can be done in this way: 1. Mark dynamic options as such (from MariaDB docs). 2. Put them into separate file, link that file to...
Error 1594 ("_Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted_") can be recovered automatically: 1. Get `Relay_Master_Log_File`...
If user/role is not in nix expressions, it should be deleted from the `mysql` database (done for roles only, for users this behaviour should be optional). A role/user gets only...
Use explicit database names like `pgbackup` does. Otherwise backup can _silently_ fail if the server is not available, access denied, etc.