diff options
| author | Cullum Smith <cullum@sacredheartsc.com> | 2025-03-27 21:51:45 -0400 |
|---|---|---|
| committer | Cullum Smith <cullum@sacredheartsc.com> | 2025-03-27 21:51:45 -0400 |
| commit | d0f053485d6635d0128b815b422b421bbb836514 (patch) | |
| tree | 6c53f4ed24fb061f5442128ef825c226ebf99a3f /files | |
| parent | 8df13bd9e4d8f922d0593c84b77674f907afc437 (diff) | |
| download | infrastructure-d0f053485d6635d0128b815b422b421bbb836514.tar.gz | |
add mysql
Diffstat (limited to 'files')
4 files changed, 27 insertions, 1 deletions
diff --git a/files/etc/pam.d/mysql.mysql_server b/files/etc/pam.d/mysql.mysql_server new file mode 100644 index 0000000..6c9014c --- /dev/null +++ b/files/etc/pam.d/mysql.mysql_server @@ -0,0 +1,2 @@ +auth required /usr/local/lib/security/pam_krb5.so try_first_pass no_ccache ignore_k5login keytab=${mysql_keytab} +account required pam_permit.so diff --git a/files/usr/local/etc/mysql/conf.d/server.cnf.mysql_server b/files/usr/local/etc/mysql/conf.d/server.cnf.mysql_server new file mode 100644 index 0000000..93a6975 --- /dev/null +++ b/files/usr/local/etc/mysql/conf.d/server.cnf.mysql_server @@ -0,0 +1,21 @@ +[mysqld] +user = ${mysql_user} +bind-address = 0.0.0.0 +basedir = /usr/local +net_retry_count = 16384 +log_error = ${mysql_log_dir}/mysqld.err +datadir = ${mysql_home}/data +innodb_log_group_home_dir = ${mysql_home}/log +log_bin = ${mysql_home}/log/mysql-bin +relay_log = ${mysql_home}/log/relay-log +innodb_doublewrite = 0 +innodb_flush_method = O_DSYNC +plugin_load_add = auth_gssapi +# The new sandboxed auth_pam does not seem to work. +plugin_load_add = auth_pam_v1 +gssapi_keytab_path = ${mysql_keytab} +pam_use_cleartext_plugin +ssl_ca = ${site_cacert_path} +ssl_cert = ${mysql_tls_cert} +ssl_key = ${mysql_tls_key} +require_secure_transport diff --git a/files/usr/local/etc/poudriere.d/make.conf.pkg_repository b/files/usr/local/etc/poudriere.d/make.conf.pkg_repository index dafd290..5d16ed4 100644 --- a/files/usr/local/etc/poudriere.d/make.conf.pkg_repository +++ b/files/usr/local/etc/poudriere.d/make.conf.pkg_repository @@ -15,6 +15,7 @@ databases_akonadi_SET=MYSQL databases_luadbi_SET=PGSQL databases_postgresql${postgresql_version}-client_SET=PAM LDAP databases_postgresql${postgresql_version}-server_SET=PAM LDAP +databases_mariadb${mariadb_version}-server_UNSET=AWS_KEY_MGMT HASHIPCORP_VAULT CONNECT_EXTRA WSREP devel_apr1_SET=LDAP devel_gitolite_SET=GITUSER devel_kio-extras_UNSET=AFC @@ -31,7 +32,6 @@ editors_vim_SET=CTAGS_EXUBERANT XTERM_SAVE editors_vim_UNSET=CTAGS_BASE emulators_wine_SET=CUPS finance_gnucash_UNSET=AQBANKING -graphics_digikam_SET=AUTOTAGS FACEDETECT graphics_vips_UNSET=MATIO irc_znc_SET=CYRUS lang_lua53_SET=LIBEDIT_DL diff --git a/files/usr/local/etc/poudriere.d/pkglist.pkg_repository b/files/usr/local/etc/poudriere.d/pkglist.pkg_repository index b32fc95..3a52177 100644 --- a/files/usr/local/etc/poudriere.d/pkglist.pkg_repository +++ b/files/usr/local/etc/poudriere.d/pkglist.pkg_repository @@ -14,6 +14,8 @@ audio/virtual_oss converters/php${php_version}-iconv converters/php${php_version}-mbstring databases/luadbi +databases/mariadb$(echo "${mariadb_version}" | tr -d '.')-client +databases/mariadb$(echo "${mariadb_version}" | tr -d '.')-server databases/p5-DBD-Pg databases/p5-DBI databases/php${php_version}-pdo_pgsql @@ -162,6 +164,7 @@ textproc/php${php_version}-xmlwriter textproc/py-docutils textproc/py-markdown textproc/py-pygments +www/authelia www/chromium www/element-web www/fcgiwrap |