From 9e95d508e86fbe35b215f8d0c34c21cde0be0a58 Mon Sep 17 00:00:00 2001 From: Vincent Vanwaelscappel Date: Fri, 14 Feb 2025 14:44:28 +0100 Subject: [PATCH] wip #7257 @0.75 --- .docker/config/composer/.htaccess | 1 + .docker/config/composer/auth.json | 5 + .docker/config/cron/crontab | 1 + .docker/config/cron/host | 1 + .docker/config/httpd/httpd.conf | 562 ++++++++++++++++++ .docker/config/imagemagick/policy.xml | 96 +++ .docker/config/mariadb/charset.cnf | 4 + .docker/config/mariadb/connections.cnf | 2 + .docker/config/mariadb/finetuning.cnf | 16 + .docker/config/mariadb/json.cnf | 3 + .docker/config/mariadb/logs.cnf | 8 + .docker/config/mariadb/sql_mode.cnf | 2 + .docker/config/passwords | 1 + .docker/config/php.ini | 7 + .docker/config/rsyslog/50-default.conf | 48 ++ .docker/config/rsyslog/init.d | 137 +++++ .docker/config/rsyslog/rsyslog.conf | 60 ++ .docker/config/ssh/root/authorized_keys2 | 2 + .docker/config/ssh/server/moduli | 0 .docker/config/ssh/server/ssh_config | 0 .docker/config/ssh/server/ssh_host_dsa_key | 21 + .../config/ssh/server/ssh_host_dsa_key.pub | 1 + .docker/config/ssh/server/ssh_host_ecdsa_key | 9 + .../config/ssh/server/ssh_host_ecdsa_key.pub | 1 + .../config/ssh/server/ssh_host_ed25519_key | 7 + .../ssh/server/ssh_host_ed25519_key.pub | 1 + .docker/config/ssh/server/ssh_host_rsa_key | 38 ++ .../config/ssh/server/ssh_host_rsa_key.pub | 1 + .docker/config/ssh/server/sshd_config | 115 ++++ .docker/config/ssh/user/authorized_keys2 | 2 + .docker/config/sudoers | 1 + .docker/dev/build | 3 + .docker/dev/docker-compose.yml | 101 ++++ .docker/dev/update | 14 + .docker/images/httpd/Dockerfile | 3 + .docker/images/php-fpm/Dockerfile | 84 +++ .docker/images/php-fpm/overrides.conf | 37 ++ .docker/images/php-fpm/startup | 33 + .docker/production/build | 3 + .docker/production/docker-compose.yml | 109 ++++ .docker/production/update | 14 + .idea/dataSources.local.xml | 2 +- .idea/deployment.xml | 3 +- .idea/workspace.xml | 125 ++-- framework/application/configs/application.ini | 4 +- framework/library/Zend/Registry.php | 6 +- 46 files changed, 1645 insertions(+), 49 deletions(-) create mode 100644 .docker/config/composer/.htaccess create mode 100644 .docker/config/composer/auth.json create mode 100644 .docker/config/cron/crontab create mode 100644 .docker/config/cron/host create mode 100644 .docker/config/httpd/httpd.conf create mode 100644 .docker/config/imagemagick/policy.xml create mode 100644 .docker/config/mariadb/charset.cnf create mode 100644 .docker/config/mariadb/connections.cnf create mode 100644 .docker/config/mariadb/finetuning.cnf create mode 100644 .docker/config/mariadb/json.cnf create mode 100644 .docker/config/mariadb/logs.cnf create mode 100644 .docker/config/mariadb/sql_mode.cnf create mode 100644 .docker/config/passwords create mode 100644 .docker/config/php.ini create mode 100644 .docker/config/rsyslog/50-default.conf create mode 100644 .docker/config/rsyslog/init.d create mode 100644 .docker/config/rsyslog/rsyslog.conf create mode 100644 .docker/config/ssh/root/authorized_keys2 create mode 100644 .docker/config/ssh/server/moduli create mode 100644 .docker/config/ssh/server/ssh_config create mode 100644 .docker/config/ssh/server/ssh_host_dsa_key create mode 100644 .docker/config/ssh/server/ssh_host_dsa_key.pub create mode 100644 .docker/config/ssh/server/ssh_host_ecdsa_key create mode 100644 .docker/config/ssh/server/ssh_host_ecdsa_key.pub create mode 100644 .docker/config/ssh/server/ssh_host_ed25519_key create mode 100644 .docker/config/ssh/server/ssh_host_ed25519_key.pub create mode 100644 .docker/config/ssh/server/ssh_host_rsa_key create mode 100644 .docker/config/ssh/server/ssh_host_rsa_key.pub create mode 100644 .docker/config/ssh/server/sshd_config create mode 100644 .docker/config/ssh/user/authorized_keys2 create mode 100644 .docker/config/sudoers create mode 100644 .docker/dev/build create mode 100644 .docker/dev/docker-compose.yml create mode 100644 .docker/dev/update create mode 100644 .docker/images/httpd/Dockerfile create mode 100644 .docker/images/php-fpm/Dockerfile create mode 100644 .docker/images/php-fpm/overrides.conf create mode 100644 .docker/images/php-fpm/startup create mode 100644 .docker/production/build create mode 100644 .docker/production/docker-compose.yml create mode 100644 .docker/production/update diff --git a/.docker/config/composer/.htaccess b/.docker/config/composer/.htaccess new file mode 100644 index 0000000..14249c5 --- /dev/null +++ b/.docker/config/composer/.htaccess @@ -0,0 +1 @@ +Deny from all \ No newline at end of file diff --git a/.docker/config/composer/auth.json b/.docker/config/composer/auth.json new file mode 100644 index 0000000..6b9274a --- /dev/null +++ b/.docker/config/composer/auth.json @@ -0,0 +1,5 @@ +{ + "github-oauth": { + "github.com": "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" + } +} diff --git a/.docker/config/cron/crontab b/.docker/config/cron/crontab new file mode 100644 index 0000000..fa74ee3 --- /dev/null +++ b/.docker/config/cron/crontab @@ -0,0 +1 @@ +*/30 0-6 * * * /usr/bin/lynx --dump https://www.fluidbook.com/maintenance/importReferences > /proc/1/fd/1 2>/proc/1/fd/2 diff --git a/.docker/config/cron/host b/.docker/config/cron/host new file mode 100644 index 0000000..c1abb76 --- /dev/null +++ b/.docker/config/cron/host @@ -0,0 +1 @@ +3 4 * * * root /docker/fluidbook-v3/build >/dev/null 2>/dev/null diff --git a/.docker/config/httpd/httpd.conf b/.docker/config/httpd/httpd.conf new file mode 100644 index 0000000..99b540d --- /dev/null +++ b/.docker/config/httpd/httpd.conf @@ -0,0 +1,562 @@ +# +# This is the main Apache HTTP server configuration file. It contains the +# configuration directives that give the server its instructions. +# See for detailed information. +# In particular, see +# +# for a discussion of each configuration directive. +# +# Do NOT simply read the instructions in here without understanding +# what they do. They're here only as hints or reminders. If you are unsure +# consult the online docs. You have been warned. +# +# Configuration and logfile names: If the filenames you specify for many +# of the server's control files begin with "/" (or "drive:/" for Win32), the +# server will use that explicit path. If the filenames do *not* begin +# with "/", the value of ServerRoot is prepended -- so "logs/access_log" +# with ServerRoot set to "/usr/local/apache2" will be interpreted by the +# server as "/usr/local/apache2/logs/access_log", whereas "/logs/access_log" +# will be interpreted as '/logs/access_log'. + +# +# ServerRoot: The top of the directory tree under which the server's +# configuration, error, and log files are kept. +# +# Do not add a slash at the end of the directory path. If you point +# ServerRoot at a non-local disk, be sure to specify a local disk on the +# Mutex directive, if file-based mutexes are used. If you wish to share the +# same ServerRoot for multiple httpd daemons, you will need to change at +# least PidFile. +# +ServerRoot "/usr/local/apache2" + +# +# Mutex: Allows you to set the mutex mechanism and mutex file directory +# for individual mutexes, or change the global defaults +# +# Uncomment and change the directory if mutexes are file-based and the default +# mutex file directory is not on a local disk or is not appropriate for some +# other reason. +# +# Mutex default:logs + +# +# Listen: Allows you to bind Apache to specific IP addresses and/or +# ports, instead of the default. See also the +# directive. +# +# Change this to Listen on specific IP addresses as shown below to +# prevent Apache from glomming onto all bound IP addresses. +# +#Listen 12.34.56.78:80 +Listen 80 + +# +# Dynamic Shared Object (DSO) Support +# +# To be able to use the functionality of a module which was built as a DSO you +# have to place corresponding `LoadModule' lines at this location so the +# directives contained in it are actually available _before_ they are used. +# Statically compiled modules (those listed by `httpd -l') do not need +# to be loaded here. +# +# Example: +# LoadModule foo_module modules/mod_foo.so +# +LoadModule mpm_event_module modules/mod_mpm_event.so +#LoadModule mpm_prefork_module modules/mod_mpm_prefork.so +#LoadModule mpm_worker_module modules/mod_mpm_worker.so +LoadModule authn_file_module modules/mod_authn_file.so +#LoadModule authn_dbm_module modules/mod_authn_dbm.so +#LoadModule authn_anon_module modules/mod_authn_anon.so +#LoadModule authn_dbd_module modules/mod_authn_dbd.so +#LoadModule authn_socache_module modules/mod_authn_socache.so +LoadModule authn_core_module modules/mod_authn_core.so +LoadModule authz_host_module modules/mod_authz_host.so +LoadModule authz_groupfile_module modules/mod_authz_groupfile.so +LoadModule authz_user_module modules/mod_authz_user.so +#LoadModule authz_dbm_module modules/mod_authz_dbm.so +#LoadModule authz_owner_module modules/mod_authz_owner.so +#LoadModule authz_dbd_module modules/mod_authz_dbd.so +LoadModule authz_core_module modules/mod_authz_core.so +#LoadModule authnz_ldap_module modules/mod_authnz_ldap.so +#LoadModule authnz_fcgi_module modules/mod_authnz_fcgi.so +LoadModule access_compat_module modules/mod_access_compat.so +LoadModule auth_basic_module modules/mod_auth_basic.so +#LoadModule auth_form_module modules/mod_auth_form.so +#LoadModule auth_digest_module modules/mod_auth_digest.so +#LoadModule allowmethods_module modules/mod_allowmethods.so +#LoadModule isapi_module modules/mod_isapi.so +#LoadModule file_cache_module modules/mod_file_cache.so +#LoadModule cache_module modules/mod_cache.so +#LoadModule cache_disk_module modules/mod_cache_disk.so +#LoadModule cache_socache_module modules/mod_cache_socache.so +#LoadModule socache_shmcb_module modules/mod_socache_shmcb.so +#LoadModule socache_dbm_module modules/mod_socache_dbm.so +#LoadModule socache_memcache_module modules/mod_socache_memcache.so +#LoadModule socache_redis_module modules/mod_socache_redis.so +#LoadModule watchdog_module modules/mod_watchdog.so +#LoadModule macro_module modules/mod_macro.so +#LoadModule dbd_module modules/mod_dbd.so +#LoadModule bucketeer_module modules/mod_bucketeer.so +#LoadModule dumpio_module modules/mod_dumpio.so +#LoadModule echo_module modules/mod_echo.so +#LoadModule example_hooks_module modules/mod_example_hooks.so +#LoadModule case_filter_module modules/mod_case_filter.so +#LoadModule case_filter_in_module modules/mod_case_filter_in.so +#LoadModule example_ipc_module modules/mod_example_ipc.so +#LoadModule buffer_module modules/mod_buffer.so +#LoadModule data_module modules/mod_data.so +#LoadModule ratelimit_module modules/mod_ratelimit.so +LoadModule reqtimeout_module modules/mod_reqtimeout.so +#LoadModule ext_filter_module modules/mod_ext_filter.so +#LoadModule request_module modules/mod_request.so +#LoadModule include_module modules/mod_include.so +LoadModule filter_module modules/mod_filter.so +#LoadModule reflector_module modules/mod_reflector.so +#LoadModule substitute_module modules/mod_substitute.so +#LoadModule sed_module modules/mod_sed.so +#LoadModule charset_lite_module modules/mod_charset_lite.so +#LoadModule deflate_module modules/mod_deflate.so +#LoadModule xml2enc_module modules/mod_xml2enc.so +#LoadModule proxy_html_module modules/mod_proxy_html.so +#LoadModule brotli_module modules/mod_brotli.so +LoadModule mime_module modules/mod_mime.so +#LoadModule ldap_module modules/mod_ldap.so +LoadModule log_config_module modules/mod_log_config.so +#LoadModule log_debug_module modules/mod_log_debug.so +#LoadModule log_forensic_module modules/mod_log_forensic.so +#LoadModule logio_module modules/mod_logio.so +#LoadModule lua_module modules/mod_lua.so +LoadModule env_module modules/mod_env.so +#LoadModule mime_magic_module modules/mod_mime_magic.so +#LoadModule cern_meta_module modules/mod_cern_meta.so +#LoadModule expires_module modules/mod_expires.so +LoadModule headers_module modules/mod_headers.so +#LoadModule ident_module modules/mod_ident.so +#LoadModule usertrack_module modules/mod_usertrack.so +#LoadModule unique_id_module modules/mod_unique_id.so +LoadModule setenvif_module modules/mod_setenvif.so +LoadModule version_module modules/mod_version.so +LoadModule remoteip_module modules/mod_remoteip.so +LoadModule proxy_module modules/mod_proxy.so +#LoadModule proxy_connect_module modules/mod_proxy_connect.so +#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so +#LoadModule proxy_http_module modules/mod_proxy_http.so +LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so +#LoadModule proxy_scgi_module modules/mod_proxy_scgi.so +#LoadModule proxy_uwsgi_module modules/mod_proxy_uwsgi.so +#LoadModule proxy_fdpass_module modules/mod_proxy_fdpass.so +#LoadModule proxy_wstunnel_module modules/mod_proxy_wstunnel.so +#LoadModule proxy_ajp_module modules/mod_proxy_ajp.so +#LoadModule proxy_balancer_module modules/mod_proxy_balancer.so +#LoadModule proxy_express_module modules/mod_proxy_express.so +#LoadModule proxy_hcheck_module modules/mod_proxy_hcheck.so +#LoadModule session_module modules/mod_session.so +#LoadModule session_cookie_module modules/mod_session_cookie.so +#LoadModule session_crypto_module modules/mod_session_crypto.so +#LoadModule session_dbd_module modules/mod_session_dbd.so +#LoadModule slotmem_shm_module modules/mod_slotmem_shm.so +#LoadModule slotmem_plain_module modules/mod_slotmem_plain.so +#LoadModule ssl_module modules/mod_ssl.so +#LoadModule optional_hook_export_module modules/mod_optional_hook_export.so +#LoadModule optional_hook_import_module modules/mod_optional_hook_import.so +#LoadModule optional_fn_import_module modules/mod_optional_fn_import.so +#LoadModule optional_fn_export_module modules/mod_optional_fn_export.so +#LoadModule dialup_module modules/mod_dialup.so +#LoadModule http2_module modules/mod_http2.so +#LoadModule proxy_http2_module modules/mod_proxy_http2.so +#LoadModule md_module modules/mod_md.so +#LoadModule lbmethod_byrequests_module modules/mod_lbmethod_byrequests.so +#LoadModule lbmethod_bytraffic_module modules/mod_lbmethod_bytraffic.so +#LoadModule lbmethod_bybusyness_module modules/mod_lbmethod_bybusyness.so +#LoadModule lbmethod_heartbeat_module modules/mod_lbmethod_heartbeat.so +LoadModule unixd_module modules/mod_unixd.so +#LoadModule heartbeat_module modules/mod_heartbeat.so +#LoadModule heartmonitor_module modules/mod_heartmonitor.so +#LoadModule dav_module modules/mod_dav.so +LoadModule status_module modules/mod_status.so +LoadModule autoindex_module modules/mod_autoindex.so +#LoadModule asis_module modules/mod_asis.so +#LoadModule info_module modules/mod_info.so +#LoadModule suexec_module modules/mod_suexec.so + + #LoadModule cgid_module modules/mod_cgid.so + + + #LoadModule cgi_module modules/mod_cgi.so + +#LoadModule dav_fs_module modules/mod_dav_fs.so +#LoadModule dav_lock_module modules/mod_dav_lock.so +#LoadModule vhost_alias_module modules/mod_vhost_alias.so +#LoadModule negotiation_module modules/mod_negotiation.so +LoadModule dir_module modules/mod_dir.so +#LoadModule imagemap_module modules/mod_imagemap.so +#LoadModule actions_module modules/mod_actions.so +#LoadModule speling_module modules/mod_speling.so +#LoadModule userdir_module modules/mod_userdir.so +LoadModule alias_module modules/mod_alias.so +LoadModule rewrite_module modules/mod_rewrite.so + +LoadModule xsendfile_module /usr/lib/apache2/modules/mod_xsendfile.so + + +# +# If you wish httpd to run as a different user or group, you must run +# httpd as root initially and it will switch. +# +# User/Group: The name (or #number) of the user/group to run httpd as. +# It is usually good practice to create a dedicated user and group for +# running httpd, as with most system services. +# +User www-data +Group www-data + + + +# 'Main' server configuration +# +# The directives in this section set up the values used by the 'main' +# server, which responds to any requests that aren't handled by a +# definition. These values also provide defaults for +# any containers you may define later in the file. +# +# All of these directives may appear inside containers, +# in which case these default settings will be overridden for the +# virtual host being defined. +# + +# +# ServerAdmin: Your address, where problems with the server should be +# e-mailed. This address appears on some server-generated pages, such +# as error documents. e.g. admin@your-domain.com +# +ServerAdmin you@example.com + +# +# ServerName gives the name and port that the server uses to identify itself. +# This can often be determined automatically, but we recommend you specify +# it explicitly to prevent problems during startup. +# +# If your host doesn't have a registered DNS name, enter its IP address here. +# +#ServerName www.example.com:80 + +# +# Deny access to the entirety of your server's filesystem. You must +# explicitly permit access to web content directories in other +# blocks below. +# + + AllowOverride none + Require all denied + + +# +# Note that from this point forward you must specifically allow +# particular features to be enabled - so if something's not working as +# you might expect, make sure that you have specifically enabled it +# below. +# + +# +# DocumentRoot: The directory out of which you will serve your +# documents. By default, all requests are taken from this directory, but +# symbolic links and aliases may be used to point to other locations. +# +DocumentRoot "/application/" + + # + # Possible values for the Options directive are "None", "All", + # or any combination of: + # Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews + # + # Note that "MultiViews" must be named *explicitly* --- "Options All" + # doesn't give it to you. + # + # The Options directive is both complicated and important. Please see + # http://httpd.apache.org/docs/2.4/mod/core.html#options + # for more information. + # + Options Indexes FollowSymLinks + + # + # AllowOverride controls what directives may be placed in .htaccess files. + # It can be "All", "None", or any combination of the keywords: + # AllowOverride FileInfo AuthConfig Limit + # + AllowOverride All + + # + # Controls who can get stuff from this server. + # + Require all granted + + +ProxyPassMatch ^/(.*\.php(/.*)?)$ "fcgi://fluidbook-v3:9000/application//$1" timeout=1800 + +XSendFile on +XSendFilePath /application + + +# +# DirectoryIndex: sets the file that Apache will serve if a directory +# is requested. +# + + DirectoryIndex index.html index.php + + +# +# The following lines prevent .htaccess and .htpasswd files from being +# viewed by Web clients. +# + + Require all denied + + +# +# ErrorLog: The location of the error log file. +# If you do not specify an ErrorLog directive within a +# container, error messages relating to that virtual host will be +# logged here. If you *do* define an error logfile for a +# container, that host's errors will be logged there and not here. +# +ErrorLog /proc/self/fd/2 + +# +# LogLevel: Control the number of messages logged to the error_log. +# Possible values include: debug, info, notice, warn, error, crit, +# alert, emerg. +# +LogLevel warn + + + # + # The following directives define some format nicknames for use with + # a CustomLog directive (see below). + # + LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined + LogFormat "%h %l %u %t \"%r\" %>s %b" common + + + # You need to enable mod_logio.c to use %I and %O + LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio + + + # + # The location and format of the access logfile (Common Logfile Format). + # If you do not define any access logfiles within a + # container, they will be logged here. Contrariwise, if you *do* + # define per- access logfiles, transactions will be + # logged therein and *not* in this file. + # + CustomLog /proc/self/fd/1 common + + # + # If you prefer a logfile with access, agent, and referer information + # (Combined Logfile Format) you can use the following directive. + # + #CustomLog "logs/access_log" combined + + + + # + # Redirect: Allows you to tell clients about documents that used to + # exist in your server's namespace, but do not anymore. The client + # will make a new request for the document at its new location. + # Example: + # Redirect permanent /foo http://www.example.com/bar + + # + # Alias: Maps web paths into filesystem paths and is used to + # access content that does not live under the DocumentRoot. + # Example: + # Alias /webpath /full/filesystem/path + # + # If you include a trailing / on /webpath then the server will + # require it to be present in the URL. You will also likely + # need to provide a section to allow access to + # the filesystem path. + + # + # ScriptAlias: This controls which directories contain server scripts. + # ScriptAliases are essentially the same as Aliases, except that + # documents in the target directory are treated as applications and + # run by the server when requested rather than as documents sent to the + # client. The same rules about trailing "/" apply to ScriptAlias + # directives as to Alias. + # + ScriptAlias /cgi-bin/ "/usr/local/apache2/cgi-bin/" + + + + + # + # ScriptSock: On threaded servers, designate the path to the UNIX + # socket used to communicate with the CGI daemon of mod_cgid. + # + #Scriptsock cgisock + + +# +# "/usr/local/apache2/cgi-bin" should be changed to whatever your ScriptAliased +# CGI directory exists, if you have that configured. +# + + AllowOverride None + Options None + Require all granted + + + + # + # Avoid passing HTTP_PROXY environment to CGI's on this or any proxied + # backend servers which have lingering "httpoxy" defects. + # 'Proxy' request header is undefined by the IETF, not listed by IANA + # + RequestHeader unset Proxy early + + + + # + # TypesConfig points to the file containing the list of mappings from + # filename extension to MIME-type. + # + TypesConfig conf/mime.types + + # + # AddType allows you to add to or override the MIME configuration + # file specified in TypesConfig for specific file types. + # + #AddType application/x-gzip .tgz + # + # AddEncoding allows you to have certain browsers uncompress + # information on the fly. Note: Not all browsers support this. + # + #AddEncoding x-compress .Z + #AddEncoding x-gzip .gz .tgz + # + # If the AddEncoding directives above are commented-out, then you + # probably should define those extensions to indicate media types: + # + AddType application/x-compress .Z + AddType application/x-gzip .gz .tgz + + # + # AddHandler allows you to map certain file extensions to "handlers": + # actions unrelated to filetype. These can be either built into the server + # or added with the Action directive (see below) + # + # To use CGI scripts outside of ScriptAliased directories: + # (You will also need to add "ExecCGI" to the "Options" directive.) + # + #AddHandler cgi-script .cgi + + # For type maps (negotiated resources): + #AddHandler type-map var + + # + # Filters allow you to process content before it is sent to the client. + # + # To parse .shtml files for server-side includes (SSI): + # (You will also need to add "Includes" to the "Options" directive.) + # + #AddType text/html .shtml + #AddOutputFilter INCLUDES .shtml + + +# +# The mod_mime_magic module allows the server to use various hints from the +# contents of the file itself to determine its type. The MIMEMagicFile +# directive tells the module where the hint definitions are located. +# +#MIMEMagicFile conf/magic + +# +# Customizable error responses come in three flavors: +# 1) plain text 2) local redirects 3) external redirects +# +# Some examples: +#ErrorDocument 500 "The server made a boo boo." +#ErrorDocument 404 /missing.html +#ErrorDocument 404 "/cgi-bin/missing_handler.pl" +#ErrorDocument 402 http://www.example.com/subscription_info.html +# + +# +# MaxRanges: Maximum number of Ranges in a request before +# returning the entire resource, or one of the special +# values 'default', 'none' or 'unlimited'. +# Default setting is to accept 200 Ranges. +#MaxRanges unlimited + +# +# EnableMMAP and EnableSendfile: On systems that support it, +# memory-mapping or the sendfile syscall may be used to deliver +# files. This usually improves server performance, but must +# be turned off when serving from networked-mounted +# filesystems or if support for these functions is otherwise +# broken on your system. +# Defaults: EnableMMAP On, EnableSendfile Off +# +#EnableMMAP off +#EnableSendfile on + +# Supplemental configuration +# +# The configuration files in the conf/extra/ directory can be +# included to add extra features or to modify the default configuration of +# the server, or you may simply copy their contents here and change as +# necessary. + +# Server-pool management (MPM specific) +#Include conf/extra/httpd-mpm.conf + +# Multi-language error messages +#Include conf/extra/httpd-multilang-errordoc.conf + +# Fancy directory listings +#Include conf/extra/httpd-autoindex.conf + +# Language settings +#Include conf/extra/httpd-languages.conf + +# User home directories +#Include conf/extra/httpd-userdir.conf + +# Real-time info on requests and configuration +#Include conf/extra/httpd-info.conf + +# Virtual hosts +#Include conf/extra/httpd-vhosts.conf + +# Local access to the Apache HTTP Server Manual +#Include conf/extra/httpd-manual.conf + +# Distributed authoring and versioning (WebDAV) +#Include conf/extra/httpd-dav.conf + +# Various default settings +#Include conf/extra/httpd-default.conf + +# Configure mod_proxy_html to understand HTML4/XHTML1 + +Include conf/extra/proxy-html.conf + + +# Secure (SSL/TLS) connections +#Include conf/extra/httpd-ssl.conf +# +# Note: The following must must be present to support +# starting without SSL on platforms with no /dev/random equivalent +# but a statically compiled-in mod_ssl. +# + +SSLRandomSeed startup builtin +SSLRandomSeed connect builtin + + + +RemoteIPHeader X-Forwarded-For + diff --git a/.docker/config/imagemagick/policy.xml b/.docker/config/imagemagick/policy.xml new file mode 100644 index 0000000..cf31ee6 --- /dev/null +++ b/.docker/config/imagemagick/policy.xml @@ -0,0 +1,96 @@ + + + + + + ]> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/.docker/config/mariadb/charset.cnf b/.docker/config/mariadb/charset.cnf new file mode 100644 index 0000000..a624a11 --- /dev/null +++ b/.docker/config/mariadb/charset.cnf @@ -0,0 +1,4 @@ +[mariadb] +collation-server = utf8mb4_unicode_ci +init-connect='SET NAMES utf8mb4' +character-set-server = utf8mb4 diff --git a/.docker/config/mariadb/connections.cnf b/.docker/config/mariadb/connections.cnf new file mode 100644 index 0000000..f623ae6 --- /dev/null +++ b/.docker/config/mariadb/connections.cnf @@ -0,0 +1,2 @@ +[mariadb] +max_connections = 1024 diff --git a/.docker/config/mariadb/finetuning.cnf b/.docker/config/mariadb/finetuning.cnf new file mode 100644 index 0000000..ea97623 --- /dev/null +++ b/.docker/config/mariadb/finetuning.cnf @@ -0,0 +1,16 @@ +[mariadb] + +skip-name-resolve + +key_buffer_size = 128M +max_allowed_packet = 512M +max_heap_table_size = 512M +tmp_table_size = 256M + +innodb_buffer_pool_size = 4G + +join_buffer_size = 32M +join_buffer_space_limit = 256M +join_cache_level = 12 + +query_cache_size = 256M diff --git a/.docker/config/mariadb/json.cnf b/.docker/config/mariadb/json.cnf new file mode 100644 index 0000000..a452aff --- /dev/null +++ b/.docker/config/mariadb/json.cnf @@ -0,0 +1,3 @@ +[mariadb] +plugin-maturity=alpha +plugin-load-add=type_mysql_json diff --git a/.docker/config/mariadb/logs.cnf b/.docker/config/mariadb/logs.cnf new file mode 100644 index 0000000..2a54d17 --- /dev/null +++ b/.docker/config/mariadb/logs.cnf @@ -0,0 +1,8 @@ +[mariadb] +skip-log-error + +general_log = 0 +general_log_file = /var/log/mysql/queries.log + +slow_query_log = 0 +slow_query_log_file = /var/log/mysql/slow_queries.log diff --git a/.docker/config/mariadb/sql_mode.cnf b/.docker/config/mariadb/sql_mode.cnf new file mode 100644 index 0000000..6063953 --- /dev/null +++ b/.docker/config/mariadb/sql_mode.cnf @@ -0,0 +1,2 @@ +[mariadb] +sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION diff --git a/.docker/config/passwords b/.docker/config/passwords new file mode 100644 index 0000000..63e02c8 --- /dev/null +++ b/.docker/config/passwords @@ -0,0 +1 @@ +fluidbook-v3:yKgGYcPKnigzgaSG diff --git a/.docker/config/php.ini b/.docker/config/php.ini new file mode 100644 index 0000000..dba8bcf --- /dev/null +++ b/.docker/config/php.ini @@ -0,0 +1,7 @@ +upload_max_filesize = 8G +post_max_size = 8G +max_file_uploads = 1000 +error_log = /proc/self/fd/2 +log_errors = 1 +memory_limit = 12G +max_input_vars = 1000000 diff --git a/.docker/config/rsyslog/50-default.conf b/.docker/config/rsyslog/50-default.conf new file mode 100644 index 0000000..f939a48 --- /dev/null +++ b/.docker/config/rsyslog/50-default.conf @@ -0,0 +1,48 @@ +# Default rules for rsyslog. +# +# For more information see rsyslog.conf(5) and /etc/rsyslog.conf + +# +# First some standard log files. Log by facility. +# +auth,authpriv.* /var/log/auth.log +*.*;auth,authpriv.none -/var/log/syslog +#cron.* /var/log/cron.log +#daemon.* -/var/log/daemon.log +kern.* -/var/log/kern.log +#lpr.* -/var/log/lpr.log +mail.* -/var/log/mail.log +#user.* -/var/log/user.log + +# +# Logging for the mail system. Split it up so that +# it is easy to write scripts to parse these files. +# +#mail.info -/var/log/mail.info +#mail.warn -/var/log/mail.warn +mail.err /var/log/mail.err + +# +# Some "catch-all" log files. +# +#*.=debug;\ +# auth,authpriv.none;\ +# news.none;mail.none -/var/log/debug +#*.=info;*.=notice;*.=warn;\ +# auth,authpriv.none;\ +# cron,daemon.none;\ +# mail,news.none -/var/log/messages + +# +# Emergencies are sent to everybody logged in. +# +*.emerg :omusrmsg:* + +# +# I like to have messages displayed on the console, but only on a virtual +# console I usually leave idle. +# +#daemon,mail.*;\ +# news.=crit;news.=err;news.=notice;\ +# *.=debug;*.=info;\ +# *.=notice;*.=warn /dev/tty8 diff --git a/.docker/config/rsyslog/init.d b/.docker/config/rsyslog/init.d new file mode 100644 index 0000000..96ddd14 --- /dev/null +++ b/.docker/config/rsyslog/init.d @@ -0,0 +1,137 @@ +#! /bin/sh +### BEGIN INIT INFO +# Provides: rsyslog +# Required-Start: $remote_fs $time +# Required-Stop: umountnfs $time +# X-Stop-After: sendsigs +# Default-Start: 2 3 4 5 +# Default-Stop: 0 1 6 +# Short-Description: enhanced syslogd +# Description: Rsyslog is an enhanced multi-threaded syslogd. +# It is quite compatible to stock sysklogd and can be +# used as a drop-in replacement. +### END INIT INFO + +# +# Author: Michael Biebl +# + +# PATH should only include /usr/* if it runs after the mountnfs.sh script +PATH=/sbin:/usr/sbin:/bin:/usr/bin +DESC="enhanced syslogd" +NAME=rsyslog + +RSYSLOGD=rsyslogd +RSYSLOGD_BIN=/usr/sbin/rsyslogd +RSYSLOGD_OPTIONS="-c5" +RSYSLOGD_PIDFILE=/var/run/rsyslogd.pid + +SCRIPTNAME=/etc/init.d/$NAME + +# Exit if the package is not installed +[ -x "$RSYSLOGD_BIN" ] || exit 0 + +# Read configuration variable file if it is present +[ -r /etc/default/$NAME ] && . /etc/default/$NAME + +# Define LSB log_* functions. +. /lib/lsb/init-functions + +do_start() +{ + DAEMON="$RSYSLOGD_BIN" + DAEMON_ARGS="$RSYSLOGD_OPTIONS" + PIDFILE="$RSYSLOGD_PIDFILE" + + # Return + # 0 if daemon has been started + # 1 if daemon was already running + # other if daemon could not be started or a failure occured + start-stop-daemon --start --quiet --pidfile $PIDFILE --exec $DAEMON -- $DAEMON_ARGS +} + +do_stop() +{ + DAEMON="$RSYSLOGD_BIN" + PIDFILE="$RSYSLOGD_PIDFILE" + + # Return + # 0 if daemon has been stopped + # 1 if daemon was already stopped + # other if daemon could not be stopped or a failure occurred + start-stop-daemon --stop --quiet --retry=TERM/30/KILL/5 --pidfile $PIDFILE --exec $DAEMON +} + +# +# Tell rsyslogd to close all open files +# +do_rotate() { + DAEMON="$RSYSLOGD_BIN" + PIDFILE="$RSYSLOGD_PIDFILE" + + start-stop-daemon --stop --signal HUP --quiet --pidfile $PIDFILE --exec $DAEMON +} + +create_xconsole() { + XCONSOLE=/dev/xconsole + if [ "$(uname -s)" != "Linux" ]; then + XCONSOLE=/run/xconsole + ln -sf $XCONSOLE /dev/xconsole + fi + if [ ! -e $XCONSOLE ]; then + mknod -m 640 $XCONSOLE p + chown root:adm $XCONSOLE + [ -x /sbin/restorecon ] && /sbin/restorecon $XCONSOLE + fi +} + +sendsigs_omit() { + OMITDIR=/run/sendsigs.omit.d + mkdir -p $OMITDIR + ln -sf $RSYSLOGD_PIDFILE $OMITDIR/rsyslog +} + +case "$1" in + start) + log_daemon_msg "Starting $DESC" "$RSYSLOGD" + create_xconsole + do_start + case "$?" in + 0) sendsigs_omit + log_end_msg 0 ;; + 1) log_progress_msg "already started" + log_end_msg 0 ;; + *) log_end_msg 1 ;; + esac + + ;; + stop) + log_daemon_msg "Stopping $DESC" "$RSYSLOGD" + do_stop + case "$?" in + 0) log_end_msg 0 ;; + 1) log_progress_msg "already stopped" + log_end_msg 0 ;; + *) log_end_msg 1 ;; + esac + + ;; + rotate) + log_daemon_msg "Closing open files" "$RSYSLOGD" + do_rotate + log_end_msg $? + ;; + restart|force-reload) + $0 stop + $0 start + ;; + status) + status_of_proc -p $RSYSLOGD_PIDFILE $RSYSLOGD_BIN $RSYSLOGD && exit 0 || exit $? + ;; + *) + echo "Usage: $SCRIPTNAME {start|stop|rotate|restart|force-reload|status}" >&2 + exit 3 + ;; +esac + +: \ No newline at end of file diff --git a/.docker/config/rsyslog/rsyslog.conf b/.docker/config/rsyslog/rsyslog.conf new file mode 100644 index 0000000..94bc18f --- /dev/null +++ b/.docker/config/rsyslog/rsyslog.conf @@ -0,0 +1,60 @@ +# /etc/rsyslog.conf configuration file for rsyslog +# +# For more information install rsyslog-doc and see +# /usr/share/doc/rsyslog-doc/html/configuration/index.html +# +# Default logging rules can be found in /etc/rsyslog.d/50-default.conf + + +################# +#### MODULES #### +################# + +module(load="imuxsock") # provides support for local system logging +#module(load="immark") # provides --MARK-- message capability + +# provides UDP syslog reception +#module(load="imudp") +#input(type="imudp" port="514") + +# provides TCP syslog reception +#module(load="imtcp") +#input(type="imtcp" port="514") + +# provides kernel logging support and enable non-kernel klog messages +# module(load="imklog" permitnonkernelfacility="on") + + +########################### +#### GLOBAL DIRECTIVES #### +########################### + +# +# Use traditional timestamp format. +# To enable high precision timestamps, comment out the following line. +# +$ActionFileDefaultTemplate RSYSLOG_TraditionalFileFormat + +# Filter duplicated messages +$RepeatedMsgReduction on + +# +# Set the default permissions for all log files. +# +$FileOwner syslog +$FileGroup adm +$FileCreateMode 0640 +$DirCreateMode 0755 +$Umask 0022 +$PrivDropToUser syslog +$PrivDropToGroup syslog + +# +# Where to place spool and state files +# +$WorkDirectory /var/spool/rsyslog + +# +# Include all config files in /etc/rsyslog.d/ +# +$IncludeConfig /etc/rsyslog.d/*.conf \ No newline at end of file diff --git a/.docker/config/ssh/root/authorized_keys2 b/.docker/config/ssh/root/authorized_keys2 new file mode 100644 index 0000000..c5de45b --- /dev/null +++ b/.docker/config/ssh/root/authorized_keys2 @@ -0,0 +1,2 @@ +ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQEAtabxRZZMjtmq+r8uXsBmfLgAtkxqwigGpx0e6Mx066ukIWIafFsguity6aV5QNI4UfxXnX3QXROcWeIiyLBV4yDGxuq7ah4r0X1CjqHUvHoGpXwJ2DIWPeaa8XyXnavmj0SNtKn0f1T+oJS0fcryUTLyxY7eOgNsr+pp1fVmgca9Efj0BKUXV/SUIjp8JX3x0/E/3PAqG81zus2SxzuOO1b0FKXDq43Gx6Ov3Ok7+Pje4G4pB56rJiiXlPxrBlY0e8Pz/7+kFF8izCiztJLtZig32Dx0HbLYGtSvIPJKYxK8DDD/RWWpL3mgNPYZ2PE3wHf4c7CTlxLCDP+NeRS1yQ== vincent+2021@cubedesigners.com +ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQDYAQ/tdQpfweVSyxgvF7hFtl4ax+0g8uI102LeH4NmZtzh85DmD3ccoN5UvAf3SOU6nTGLBN2i/YGRruYmm3PDDYBwyKmq3d1ZqUd8ItNfmTlVbRQme0qE6uOVfHgiejDqm9SS0kbI0lYi/BHp7sWK0UM18iE6NbsSgxw468FwBhtSiR78dw1yEhZQdtQDxusD6LbsGDsj37bV9YHFPVslzc6Bkf4fg9igm5YStCdmcYG86t0RUZDfHw6YGuIxXWkDRh1fpC6yj3Wv+n4+Zho5Bjlryg+YRhxFzno2VxgIeScIAernhUq3yy2whZU3jrWfXKfxutPmpCowl17ydcMXUr8Zt44RaYSVJI6V2lbw/B3HWW8BjkVmHlzDhulw4sJzWYoQOhiDLrUFprdF49CtYFrfsuVOx1IwETfnKKI0w5JqID+sa1iYCtgP9BdfO/H04iW3pFeaNhKW89c7GNZHhNuAS9x5wmcDpYiu2DH/ZIZIQ2wGKcyiZ0sMXQqBS4U= 33610@AYOR diff --git a/.docker/config/ssh/server/moduli b/.docker/config/ssh/server/moduli new file mode 100644 index 0000000..e69de29 diff --git a/.docker/config/ssh/server/ssh_config b/.docker/config/ssh/server/ssh_config new file mode 100644 index 0000000..e69de29 diff --git a/.docker/config/ssh/server/ssh_host_dsa_key b/.docker/config/ssh/server/ssh_host_dsa_key new file mode 100644 index 0000000..10052e0 --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_dsa_key @@ -0,0 +1,21 @@ +-----BEGIN OPENSSH PRIVATE KEY----- +b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAABsgAAAAdzc2gtZH +NzAAAAgQDHg5eV6h3fVMyYQKnqTeLmm5TAK9NWbX/Ui0AEk2Yp7Y8+9kfCsv4v3KudU53F +HK9UrUDa2uMd7Tv8fHPabvER24LLayl8mm5MtK1Oxhjjoh2ShtHfyzpw0xLWbNYQZ8Ekn/ +2yqGYfUu4i5BQZLlJSo96ewmQDgjCXGly/Emy7nwAAABUA7xNWMk2l1TsUzooBYiBaEMvs +cM8AAACBAJybrnPyoE7+Z9ZRE4Miy1Bcxlo5Aon56vUZeIguuoUGzphCTAa/Or9HDXedo/ +3CAHpQreN2hgSviCQxRkTGA1uaYhN3+hG42H3kX0qFKrtNNHQVedkvrIyBUJmvUIA9gkWv +dVXoKemo/2V4+90trF7Lkoi2HtR1s6sFW0pzVpjFAAAAgBa8BsxUoRwNJd5TS+ql+vAq61 +a5t9xVjZcwCLE5UkxAcuT0tRAZg5/aykpdpUKyWBj/eL2oedQf7bC+/iiZ16nwLvC/dWxe +5XquSLII6vNIm2MKrKnDi3ktgRPIwkrg+i6KJMMKDKexIn+p18l48NHYSJrTG83mSnLDn7 +NSHCPHAAAB6Fkb1DJZG9QyAAAAB3NzaC1kc3MAAACBAMeDl5XqHd9UzJhAqepN4uablMAr +01Ztf9SLQASTZintjz72R8Ky/i/cq51TncUcr1StQNra4x3tO/x8c9pu8RHbgstrKXyabk +y0rU7GGOOiHZKG0d/LOnDTEtZs1hBnwSSf/bKoZh9S7iLkFBkuUlKj3p7CZAOCMJcaXL8S +bLufAAAAFQDvE1YyTaXVOxTOigFiIFoQy+xwzwAAAIEAnJuuc/KgTv5n1lETgyLLUFzGWj +kCifnq9Rl4iC66hQbOmEJMBr86v0cNd52j/cIAelCt43aGBK+IJDFGRMYDW5piE3f6EbjY +feRfSoUqu000dBV52S+sjIFQma9QgD2CRa91Vegp6aj/ZXj73S2sXsuSiLYe1HWzqwVbSn +NWmMUAAACAFrwGzFShHA0l3lNL6qX68CrrVrm33FWNlzAIsTlSTEBy5PS1EBmDn9rKSl2l +QrJYGP94vah51B/tsL7+KJnXqfAu8L91bF7leq5Isgjq80ibYwqsqcOLeS2BE8jCSuD6Lo +okwwoMp7Eif6nXyXjw0dhImtMbzeZKcsOfs1IcI8cAAAAUb0sOgM6D/lZkavaKqqW8ZarH +wfkAAAARcm9vdEBmbHVpZGJvb2stdjMB +-----END OPENSSH PRIVATE KEY----- diff --git a/.docker/config/ssh/server/ssh_host_dsa_key.pub b/.docker/config/ssh/server/ssh_host_dsa_key.pub new file mode 100644 index 0000000..c70a22b --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_dsa_key.pub @@ -0,0 +1 @@ +ssh-dss AAAAB3NzaC1kc3MAAACBAMeDl5XqHd9UzJhAqepN4uablMAr01Ztf9SLQASTZintjz72R8Ky/i/cq51TncUcr1StQNra4x3tO/x8c9pu8RHbgstrKXyabky0rU7GGOOiHZKG0d/LOnDTEtZs1hBnwSSf/bKoZh9S7iLkFBkuUlKj3p7CZAOCMJcaXL8SbLufAAAAFQDvE1YyTaXVOxTOigFiIFoQy+xwzwAAAIEAnJuuc/KgTv5n1lETgyLLUFzGWjkCifnq9Rl4iC66hQbOmEJMBr86v0cNd52j/cIAelCt43aGBK+IJDFGRMYDW5piE3f6EbjYfeRfSoUqu000dBV52S+sjIFQma9QgD2CRa91Vegp6aj/ZXj73S2sXsuSiLYe1HWzqwVbSnNWmMUAAACAFrwGzFShHA0l3lNL6qX68CrrVrm33FWNlzAIsTlSTEBy5PS1EBmDn9rKSl2lQrJYGP94vah51B/tsL7+KJnXqfAu8L91bF7leq5Isgjq80ibYwqsqcOLeS2BE8jCSuD6LookwwoMp7Eif6nXyXjw0dhImtMbzeZKcsOfs1IcI8c= root@fluidbook-v3 diff --git a/.docker/config/ssh/server/ssh_host_ecdsa_key b/.docker/config/ssh/server/ssh_host_ecdsa_key new file mode 100644 index 0000000..ca59c79 --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_ecdsa_key @@ -0,0 +1,9 @@ +-----BEGIN OPENSSH PRIVATE KEY----- +b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAaAAAABNlY2RzYS +1zaGEyLW5pc3RwMjU2AAAACG5pc3RwMjU2AAAAQQSe1IqIJhuz3MYJhWMyWw+q7wmJNI/H +2XaR9DbqIgshfKKKhw7kiHMNS/g7ftNJlqDFE/lTip8g4cNbg490aPpoAAAAsAH3wf8B98 +H/AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBJ7UiogmG7PcxgmF +YzJbD6rvCYk0j8fZdpH0NuoiCyF8ooqHDuSIcw1L+Dt+00mWoMUT+VOKnyDhw1uDj3Ro+m +gAAAAhANNJBhxhDfyFNOAUM6QG3PSNSBfG3QjD7xEExi/uzyskAAAAEXJvb3RAZmx1aWRi +b29rLXYzAQIDBAUG +-----END OPENSSH PRIVATE KEY----- diff --git a/.docker/config/ssh/server/ssh_host_ecdsa_key.pub b/.docker/config/ssh/server/ssh_host_ecdsa_key.pub new file mode 100644 index 0000000..995094a --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_ecdsa_key.pub @@ -0,0 +1 @@ +ecdsa-sha2-nistp256 AAAAE2VjZHNhLXNoYTItbmlzdHAyNTYAAAAIbmlzdHAyNTYAAABBBJ7UiogmG7PcxgmFYzJbD6rvCYk0j8fZdpH0NuoiCyF8ooqHDuSIcw1L+Dt+00mWoMUT+VOKnyDhw1uDj3Ro+mg= root@fluidbook-v3 diff --git a/.docker/config/ssh/server/ssh_host_ed25519_key b/.docker/config/ssh/server/ssh_host_ed25519_key new file mode 100644 index 0000000..29257e5 --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_ed25519_key @@ -0,0 +1,7 @@ +-----BEGIN OPENSSH PRIVATE KEY----- +b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAAAMwAAAAtzc2gtZW +QyNTUxOQAAACAoxxx6ORBC6Wh/HZF/K3k5V2FXK8Or1LeE+pJkSOg8GQAAAJgK8hB6CvIQ +egAAAAtzc2gtZWQyNTUxOQAAACAoxxx6ORBC6Wh/HZF/K3k5V2FXK8Or1LeE+pJkSOg8GQ +AAAEAVbumhlzJfN+n3PaXYi2C47T1a/d7jnavswmcyJr6VwSjHHHo5EELpaH8dkX8reTlX +YVcrw6vUt4T6kmRI6DwZAAAAEXJvb3RAZmx1aWRib29rLXYzAQIDBA== +-----END OPENSSH PRIVATE KEY----- diff --git a/.docker/config/ssh/server/ssh_host_ed25519_key.pub b/.docker/config/ssh/server/ssh_host_ed25519_key.pub new file mode 100644 index 0000000..3564a38 --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_ed25519_key.pub @@ -0,0 +1 @@ +ssh-ed25519 AAAAC3NzaC1lZDI1NTE5AAAAICjHHHo5EELpaH8dkX8reTlXYVcrw6vUt4T6kmRI6DwZ root@fluidbook-v3 diff --git a/.docker/config/ssh/server/ssh_host_rsa_key b/.docker/config/ssh/server/ssh_host_rsa_key new file mode 100644 index 0000000..6895b66 --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_rsa_key @@ -0,0 +1,38 @@ +-----BEGIN OPENSSH PRIVATE KEY----- +b3BlbnNzaC1rZXktdjEAAAAABG5vbmUAAAAEbm9uZQAAAAAAAAABAAABlwAAAAdzc2gtcn +NhAAAAAwEAAQAAAYEAr8C7yfCmWSPjt1F7Al2FABPQJemqfWWxAau8WUOGeo5NiJNrMC3l +Vy2VAwPVi7ZDzsPbsc77vtcUQ2zSMTXjGEv7Uf1w70ANwZBe3NKHZEAPWU9odoaAnGdlce +gWnYbacRhWWMtlIypAke0zyfQcLb5Q+WARmxmMuYaIJRxJS75mUrER6VQeWcJUNaMbstiU +pdn1n9OwEwxfoDp3jBfZT0kDKUaxya0MkeHTWBb80k3LhEy8otsM1OAEFuBdkynCkrUWjc +0jyJTkAfuO/MuESvwjVTFUE5bkzDTVnpvgo/5K3iPtgOOPSl/nNOMRIkV4Y1yINmJ51/1m +HQT8iD3bKTYpv1GJsDybNZB0jpyim35k1MgMvyALXREI06un0JZ3mwPfeC+FT/9D1PHzcR +3XKX3+9VxPRRBNP28QJzAx6R1KphRxOQVHV2UI/uO2zQBNTFk/hbpDVEPRh38ZiOWtOmca +nvMSMzaQxIXueEpT7wgmuIrniGEyycL82jsW2yMTAAAFiPfT6TL30+kyAAAAB3NzaC1yc2 +EAAAGBAK/Au8nwplkj47dRewJdhQAT0CXpqn1lsQGrvFlDhnqOTYiTazAt5VctlQMD1Yu2 +Q87D27HO+77XFENs0jE14xhL+1H9cO9ADcGQXtzSh2RAD1lPaHaGgJxnZXHoFp2G2nEYVl +jLZSMqQJHtM8n0HC2+UPlgEZsZjLmGiCUcSUu+ZlKxEelUHlnCVDWjG7LYlKXZ9Z/TsBMM +X6A6d4wX2U9JAylGscmtDJHh01gW/NJNy4RMvKLbDNTgBBbgXZMpwpK1Fo3NI8iU5AH7jv +zLhEr8I1UxVBOW5Mw01Z6b4KP+St4j7YDjj0pf5zTjESJFeGNciDZiedf9Zh0E/Ig92yk2 +Kb9RibA8mzWQdI6copt+ZNTIDL8gC10RCNOrp9CWd5sD33gvhU//Q9Tx83Ed1yl9/vVcT0 +UQTT9vECcwMekdSqYUcTkFR1dlCP7jts0ATUxZP4W6Q1RD0Yd/GYjlrTpnGp7zEjM2kMSF +7nhKU+8IJriK54hhMsnC/No7FtsjEwAAAAMBAAEAAAGALxnEWfC76/zBzMGx6Sbd+3DT4i +02iyejIdMABZ4inpqfbcAwRDewlEX7ftTauHgOwQ1dRdA2SGVEoXM6+4Q5CaxnPIhi6UNt +zFegDKcBMN04H9O3p7gRJJlTJw0vbmUTCqcekOplfuCWcGU08WUR3jJ4afSUk0/sFlZXCz +cC76Els/iPV8w63AxH3B4L0MjZQX9ho8UsFVbGE99HZYyIqQZkqf2vrOBLE5eFN8DlXYkK +xzh3f1+cFzq37deQTF2uu/Tqg0mNMVvAP5hL+glLWcWObANEuIRr96VoG+EHZzLoioCKrD +aWH0q8TwjVa0MGIOmdZsEmmDDlVHQL5+KUP/sFeUuPVmDRmGqpEq2ucm/kxmHIg/Jpz1wg +DAN+XPlX0eYUBAV0fLVzixxW5v2n8527hDEZxXpxG4g4UHqzoKTFFn171Mnyz1CyQO/I7C +rQwhLA6rEHEHiIK3whJ9hNXgHA5V9VcVuTnrvhijkOjmj4ypWPOBUsfCDTSddCe4QFAAAA +wCoo1amPNMT2cFYoHggOuckxdM0b0K3bLKnhQKW6mPPpHS3b1xB+u4eVJmUirUujN3OGL8 +NYJZAXyM56rjy/NRQV4t/a5nurqvtJvhji3pRcOVB1ugVPtknwcI9Yo8vVquDlIFkEITDm +pQpDYWxGK+AJtnjaHtfJoNprjVnIQWin3xqNX1DSFnT5JCPOzDGvagki8cr+MGtdvc1Rnk +xnBXxP9pgeS7Z5a9dmnyM0LiHs/oJoWzmOaS3j6L7Ok3A2pgAAAMEAthtZ6EGqbr+y+Ho4 +uCWqlUd7qEetSehfDcOqPSeMGcd/+AEOBZIie7shf6xXnHYkNWPqu2BTBcn76jHGOhZr+P +HL9bZAj0atpjKv+FsX48cverb/IUMW8+M9+iOXlvsdKLQBGpBK6CoERKB7DgCewAvWi4jC +m8BvcmiujjfKaBcBUp6bjjozH0MwZbSeQ7+6m1Ve+o7Soa6FViOZUcNZsBoR608G6JK3k1 +zezTE2yCtUaDCL1uCvtgOBDx19tNNnAAAAwQD3EVpJeCPBq7cDAtdD794NaK8HIiaXLMb4 +Fzn7OdG/vRqfOW0hu23YBnFGN8Za7dZbHaPd1oscg91xgJWq7bDYBZyGIMKyuPVRce77j4 +M9FAQW23eZsgwmkabYhJTi1bXGNC0SrJvGq6rgVUn1dAE7T6t8fwD1qAL4ILMq3YouitHa +RusJ1lR46esOeVMWXP1I+UffFwmvGSPRYwM29bUCt1X663mVPPOilL/ooMBIiDEzZKxf/x +B8azGQeDt/M3UAAAARcm9vdEBmbHVpZGJvb2stdjMBAg== +-----END OPENSSH PRIVATE KEY----- diff --git a/.docker/config/ssh/server/ssh_host_rsa_key.pub b/.docker/config/ssh/server/ssh_host_rsa_key.pub new file mode 100644 index 0000000..80c9fea --- /dev/null +++ b/.docker/config/ssh/server/ssh_host_rsa_key.pub @@ -0,0 +1 @@ +ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQCvwLvJ8KZZI+O3UXsCXYUAE9Al6ap9ZbEBq7xZQ4Z6jk2Ik2swLeVXLZUDA9WLtkPOw9uxzvu+1xRDbNIxNeMYS/tR/XDvQA3BkF7c0odkQA9ZT2h2hoCcZ2Vx6BadhtpxGFZYy2UjKkCR7TPJ9BwtvlD5YBGbGYy5hoglHElLvmZSsRHpVB5ZwlQ1oxuy2JSl2fWf07ATDF+gOneMF9lPSQMpRrHJrQyR4dNYFvzSTcuETLyi2wzU4AQW4F2TKcKStRaNzSPIlOQB+478y4RK/CNVMVQTluTMNNWem+Cj/kreI+2A449KX+c04xEiRXhjXIg2YnnX/WYdBPyIPdspNim/UYmwPJs1kHSOnKKbfmTUyAy/IAtdEQjTq6fQlnebA994L4VP/0PU8fNxHdcpff71XE9FEE0/bxAnMDHpHUqmFHE5BUdXZQj+47bNAE1MWT+FukNUQ9GHfxmI5a06Zxqe8xIzNpDEhe54SlPvCCa4iueIYTLJwvzaOxbbIxM= root@fluidbook-v3 diff --git a/.docker/config/ssh/server/sshd_config b/.docker/config/ssh/server/sshd_config new file mode 100644 index 0000000..f9386d2 --- /dev/null +++ b/.docker/config/ssh/server/sshd_config @@ -0,0 +1,115 @@ + +# This is the sshd server system-wide configuration file. See +# sshd_config(5) for more information. + +# This sshd was compiled with PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games + +# The strategy used for options in the default sshd_config shipped with +# OpenSSH is to specify options with their default value where +# possible, but leave them commented. Uncommented options override the +# default value. + +Include /etc/ssh/sshd_config.d/*.conf + +#Port 22 +#AddressFamily any +#ListenAddress 0.0.0.0 +#ListenAddress :: + +#HostKey /etc/ssh/ssh_host_rsa_key +#HostKey /etc/ssh/ssh_host_ecdsa_key +#HostKey /etc/ssh/ssh_host_ed25519_key + +# Ciphers and keying +#RekeyLimit default none + +# Logging +#SyslogFacility AUTH +#LogLevel INFO + +# Authentication: + +#LoginGraceTime 2m +#PermitRootLogin prohibit-password +#StrictModes yes +#MaxAuthTries 6 +#MaxSessions 10 + +#PubkeyAuthentication yes + +# Expect .ssh/authorized_keys2 to be disregarded by default in future. +#AuthorizedKeysFile .ssh/authorized_keys .ssh/authorized_keys2 + +#AuthorizedPrincipalsFile none + +#AuthorizedKeysCommand none +#AuthorizedKeysCommandUser nobody + +# For this to work you will also need host keys in /etc/ssh/ssh_known_hosts +#HostbasedAuthentication no +# Change to yes if you don't trust ~/.ssh/known_hosts for +# HostbasedAuthentication +#IgnoreUserKnownHosts no +# Don't read the user's ~/.rhosts and ~/.shosts files +#IgnoreRhosts yes + +# To disable tunneled clear text passwords, change to no here! +#PasswordAuthentication yes +#PermitEmptyPasswords no + +# Change to yes to enable challenge-response passwords (beware issues with +# some PAM modules and threads) +KbdInteractiveAuthentication no + +# Kerberos options +#KerberosAuthentication no +#KerberosOrLocalPasswd yes +#KerberosTicketCleanup yes +#KerberosGetAFSToken no + +# GSSAPI options +#GSSAPIAuthentication no +#GSSAPICleanupCredentials yes +#GSSAPIStrictAcceptorCheck yes +#GSSAPIKeyExchange no + +# Set this to 'yes' to enable PAM authentication, account processing, +# and session processing. If this is enabled, PAM authentication will +# be allowed through the KbdInteractiveAuthentication and +# PasswordAuthentication. Depending on your PAM configuration, +# PAM authentication via KbdInteractiveAuthentication may bypass +# the setting of "PermitRootLogin without-password". +# If you just want the PAM account and session checks to run without +# PAM authentication, then enable this but set PasswordAuthentication +# and KbdInteractiveAuthentication to 'no'. +UsePAM yes + +#AllowAgentForwarding yes +#AllowTcpForwarding yes +#GatewayPorts no +X11Forwarding yes +#X11DisplayOffset 10 +#X11UseLocalhost yes +#PermitTTY yes +PrintMotd no +#PrintLastLog yes +#TCPKeepAlive yes +#PermitUserEnvironment no +#Compression delayed +#ClientAliveInterval 0 +#ClientAliveCountMax 3 +#UseDNS no +#PidFile /run/sshd.pid +#MaxStartups 10:30:100 +#PermitTunnel no +#ChrootDirectory none +#VersionAddendum none + +# no default banner path +#Banner none + +# Allow client to pass locale environment variables +AcceptEnv LANG LC_* + +# override default of no subsystems +Subsystem sftp /usr/lib/openssh/sftp-server diff --git a/.docker/config/ssh/user/authorized_keys2 b/.docker/config/ssh/user/authorized_keys2 new file mode 100644 index 0000000..c5de45b --- /dev/null +++ b/.docker/config/ssh/user/authorized_keys2 @@ -0,0 +1,2 @@ +ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQEAtabxRZZMjtmq+r8uXsBmfLgAtkxqwigGpx0e6Mx066ukIWIafFsguity6aV5QNI4UfxXnX3QXROcWeIiyLBV4yDGxuq7ah4r0X1CjqHUvHoGpXwJ2DIWPeaa8XyXnavmj0SNtKn0f1T+oJS0fcryUTLyxY7eOgNsr+pp1fVmgca9Efj0BKUXV/SUIjp8JX3x0/E/3PAqG81zus2SxzuOO1b0FKXDq43Gx6Ov3Ok7+Pje4G4pB56rJiiXlPxrBlY0e8Pz/7+kFF8izCiztJLtZig32Dx0HbLYGtSvIPJKYxK8DDD/RWWpL3mgNPYZ2PE3wHf4c7CTlxLCDP+NeRS1yQ== vincent+2021@cubedesigners.com +ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQDYAQ/tdQpfweVSyxgvF7hFtl4ax+0g8uI102LeH4NmZtzh85DmD3ccoN5UvAf3SOU6nTGLBN2i/YGRruYmm3PDDYBwyKmq3d1ZqUd8ItNfmTlVbRQme0qE6uOVfHgiejDqm9SS0kbI0lYi/BHp7sWK0UM18iE6NbsSgxw468FwBhtSiR78dw1yEhZQdtQDxusD6LbsGDsj37bV9YHFPVslzc6Bkf4fg9igm5YStCdmcYG86t0RUZDfHw6YGuIxXWkDRh1fpC6yj3Wv+n4+Zho5Bjlryg+YRhxFzno2VxgIeScIAernhUq3yy2whZU3jrWfXKfxutPmpCowl17ydcMXUr8Zt44RaYSVJI6V2lbw/B3HWW8BjkVmHlzDhulw4sJzWYoQOhiDLrUFprdF49CtYFrfsuVOx1IwETfnKKI0w5JqID+sa1iYCtgP9BdfO/H04iW3pFeaNhKW89c7GNZHhNuAS9x5wmcDpYiu2DH/ZIZIQ2wGKcyiZ0sMXQqBS4U= 33610@AYOR diff --git a/.docker/config/sudoers b/.docker/config/sudoers new file mode 100644 index 0000000..bcefe01 --- /dev/null +++ b/.docker/config/sudoers @@ -0,0 +1 @@ +fluidbook-v3 ALL=(ALL) NOPASSWD:ALL diff --git a/.docker/dev/build b/.docker/dev/build new file mode 100644 index 0000000..379f415 --- /dev/null +++ b/.docker/dev/build @@ -0,0 +1,3 @@ +#!/bin/sh +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose pull +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose build diff --git a/.docker/dev/docker-compose.yml b/.docker/dev/docker-compose.yml new file mode 100644 index 0000000..91ca8ea --- /dev/null +++ b/.docker/dev/docker-compose.yml @@ -0,0 +1,101 @@ +version: '3.1' +services: + webserver: + container_name: fluidbook-v3-dev-httpd + build: './images/httpd' + working_dir: /application + volumes: + - './wwww/:/usr/local/apache2/htdocs/' + - './wwww/:/application/' + - './config/httpd/httpd.conf:/usr/local/apache2/conf/httpd.conf' + environment: + VIRTUAL_HOST: dev.fluidbook.com,en.dev.fluidbook.com + LETSENCRYPT_HOST: dev.fluidbook.com,en.dev.fluidbook.com + networks: + - fluidbook-v3-dev + restart: unless-stopped + php-fpm: + container_name: fluidbook-v3-dev + hostname: fluidbook-v3-dev + build: './images/php-fpm' + working_dir: /application + volumes: + # SSH + - './config/ssh/root/:/root/.ssh/' + - './config/ssh/user/:/application/.ssh/' + - './config/ssh/server/:/etc/ssh/' + # Rsyslog + - './config/rsyslog/rsyslog.conf:/etc/rsyslog.conf' + - './config/rsyslog/50-default.conf:/etc/rsyslog.d/50-default.conf' + # Composer + - './config/composer/:/root/.config/composer/' + - './config/composer/:/application/.config/composer/' + # Sudoers + - './config/sudoers:/etc/sudoers.d/fluidbook-v3-dev' + # ImageMagick + - './config/imagemagick/policy.xml:/etc/ImageMagick-6/policy.xml' + # Passwords + - './config/passwords:/root/passwords' + # Cron + - './config/cron/crontab:/etc/crontab' + # PHP + - './config/php.ini:/etc/php/7.4/fpm/conf.d/99-overrides.ini' + # Web path + - './wwww/:/application/' + ports: + - '53371:22' + networks: + - fluidbook-v3-dev + restart: unless-stopped + + adminer: + image: 'adminer:latest' + container_name: fluidbook-v3-dev-adminer + restart: unless-stopped + environment: + ADMINER_DEFAULT_SERVER: fluidbook-v3-dev-mariadb + VIRTUAL_HOST: adminer.dev.fluidbook.com + LETSENCRYPT_HOST: adminer.dev.fluidbook.com + networks: + - fluidbook-v3-dev + + mariadb: + container_name: fluidbook-v3-dev-mariadb + image: 'mariadb:latest' + restart: unless-stopped + environment: + MARIADB_ROOT_PASSWORD: ryruth0YzzuUn7Eq + MARIADB_DATABASE: fluidbook-v3-dev + MARIADB_AUTO_UPGRADE: 1 + volumes: + - "./database/dump.sql:/docker-entrypoint-initdb.d/dump.sql" + - "./database/scripts/:/usr/local/bin/scripts/" + - "./database/data:/var/lib/mysql" + - './config/mariadb:/etc/mysql/conf.d:z' + networks: + - fluidbook-v3-dev + logging: + driver: json-file + options: + max-size: 10M + max-file: 10 + + mysqlbackup: + image: selim13/automysqlbackup + container_name: fluidbook-v3-dev-automysqlbackup + volumes: + - "./database/backup:/backup" + environment: + USERNAME: root + PASSWORD: ryruth0YzzuUn7Eq + DBHOST: fluidbook-v3-dev-mariadb + DBEXCLUDE: "performance_schema information_schema" + CRON_SCHEDULE: "0 0 * * *" + EXTRA_OPTS: "--single-transaction" + networks: + - fluidbook-v3-dev + +networks: + fluidbook-v3-dev: + external: + name: fluidbook-v3-dev diff --git a/.docker/dev/update b/.docker/dev/update new file mode 100644 index 0000000..5c4a18a --- /dev/null +++ b/.docker/dev/update @@ -0,0 +1,14 @@ +#!/bin/sh +cd /docker/fluidbook-v3-dev +docker network create fluidbook-v3-dev + +chown 0:0 ./config/cron/crontab +chown -R 999:999 ./database/data + +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose pull +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose build + +docker compose down -v +docker compose up -d + +ufw-docker allow fluidbook-v3-dev \ No newline at end of file diff --git a/.docker/images/httpd/Dockerfile b/.docker/images/httpd/Dockerfile new file mode 100644 index 0000000..aab8bc2 --- /dev/null +++ b/.docker/images/httpd/Dockerfile @@ -0,0 +1,3 @@ +FROM httpd +RUN apt-get update && apt-get install -y --no-install-recommends nano less bash libapache2-mod-xsendfile +RUN apt-get clean && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/* /usr/share/doc/* diff --git a/.docker/images/php-fpm/Dockerfile b/.docker/images/php-fpm/Dockerfile new file mode 100644 index 0000000..65bbdfc --- /dev/null +++ b/.docker/images/php-fpm/Dockerfile @@ -0,0 +1,84 @@ +############################################ +# PHPDocker.io PHP 8.3 / CLI and FPM image # +############################################ + +FROM ubuntu:jammy AS cli + +WORKDIR "/application" + +# Fixes some weird terminal issues such as broken clear / CTRL+L +ENV TERM=linux + +# Ensure apt doesn't ask questions when installing stuff +ENV DEBIAN_FRONTEND=noninteractive + +# Add Ondrej PHP repository +RUN apt update \ + && apt install -y --no-install-recommends ca-certificates gnupg bash curl \ + && echo "deb http://ppa.launchpad.net/ondrej/php/ubuntu jammy main" > /etc/apt/sources.list.d/ondrej-php.list \ + && apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 4F4EA0AAE5267A6C + +# Add Nodejs Repository +RUN curl -fsSL https://deb.nodesource.com/gpgkey/nodesource-repo.gpg.key | gpg --dearmor -o /etc/apt/keyrings/nodesource.gpg +RUN echo "deb [signed-by=/etc/apt/keyrings/nodesource.gpg] https://deb.nodesource.com/node_20.x nodistro main" | tee /etc/apt/sources.list.d/nodesource.list + +RUN apt update +RUN apt update + +RUN apt -y --no-install-recommends install \ + zip unzip \ + git \ + php8.3-apcu \ + php8.3-cli \ + php8.3-curl \ + php8.3-mbstring \ + php8.3-opcache \ + php8.3-readline \ + php8.3-xml \ + php8.3-zip \ + php8.3-bz2 \ + php8.3-gd \ + php8.3-igbinary \ + php8.3-imap \ + php8.3-imagick \ + php8.3-intl \ + php8.3-memcached \ + php8.3-mysql \ + php8.3-redis \ + php8.3-soap \ + php8.3-ssh2 \ + php8.3-tidy \ + php8.3-xsl \ + php8.3-curl \ + php8.3-mcrypt \ + php8.3-fpm \ + less nano wget nodejs + +RUN apt -y --no-install-recommends install nodejs sudo openssh-server rsyslog cron mariadb-client imagemagick + +RUN apt -y --no-install-recommends install locales +RUN sed -i '/fr_FR.UTF-8/s/^# //g' /etc/locale.gen && \ + locale-gen +ENV LANG fr_FR.UTF-8 +ENV LANGUAGE fr_FR:$localshort +ENV LC_ALL fr_FR.UTF-8 + +COPY --from=composer:2 /usr/bin/composer /usr/bin/composer + +# IF you need some npm globally installed packages +RUN npm install --unsafe-perm --global yarn + +CMD ["php", "-a"] + +STOPSIGNAL SIGQUIT + +RUN groupadd sudo;useradd -d /application -g 33 -G sudo -s /bin/bash -u 1001 fluidbook-v3 + +# PHP-FPM packages need a nudge to make them docker-friendly +COPY overrides.conf /etc/php/8.3/fpm/pool.d/z-overrides.conf + +COPY --chmod=755 startup /usr/bin/startup +CMD exec /usr/bin/startup + +# Open up fcgi port +EXPOSE 9000 diff --git a/.docker/images/php-fpm/overrides.conf b/.docker/images/php-fpm/overrides.conf new file mode 100644 index 0000000..b799bf1 --- /dev/null +++ b/.docker/images/php-fpm/overrides.conf @@ -0,0 +1,37 @@ +[global] +; Override default pid file +pid = /run/php-fpm.pid + +; Avoid logs being sent to syslog +error_log = /proc/self/fd/2 + +; Set this to php default's max_execution_time to allow children to stop gracefully when fpm is commanded to stop +; This helps avoiding 502's +process_control_timeout = 30 + +; Do not daemonize (eg send process to the background) +daemonize = no + +[www] +; Access from webserver container is via network, not socket file +listen = [::]:9000 + +; Redirect logs to stdout - FPM closes /dev/std* on startup +access.log = /proc/self/fd/1 +catch_workers_output = yes + +; Remove "pool www" decoration from log output (older phpdocker.io containers for php use sed for this) +decorate_workers_output = no + +; Required to allow config-by-environment +clear_env = no + +user = 1001 +group = 33 + +pm = dynamic +pm.max_children = 16 +pm.start_servers = 4 +pm.min_spare_servers = 4 +pm.max_spare_servers = 8 +pm.max_requests = 500 diff --git a/.docker/images/php-fpm/startup b/.docker/images/php-fpm/startup new file mode 100644 index 0000000..93c34d8 --- /dev/null +++ b/.docker/images/php-fpm/startup @@ -0,0 +1,33 @@ +#!/bin/sh + +# Set file rights +umask 0000 +chmod -R 777 /tmp + +chown -R root:root /etc/sudoers.d +chown -R fluidbook-v3:www-data /application + +# Rsyslog +start-stop-daemon --start -b -x /usr/sbin/rsyslogd -- -n + +# SSH Server +ssh-keygen -A +chmod 755 /etc/ssh/*.d +chmod 600 /etc/ssh/*_key +chmod 750 /application +#chmod 600 /application/.ssh/id_rsa +chmod 700 /application/.ssh/ +chmod 600 /application/.ssh/authorized_keys2 +#chmod 600 /root/.ssh/id_rsa +chmod 700 /root/.ssh/ +chmod 600 /root/.ssh/authorized_keys2 +/usr/sbin/service ssh start + +# Cron +chmod 0644 /etc/crontab && crontab -u root /etc/crontab && /usr/sbin/service cron start + +# Set user password +chpasswd < /root/passwords + +# Launch PHP +/usr/sbin/php-fpm8.3 -O diff --git a/.docker/production/build b/.docker/production/build new file mode 100644 index 0000000..379f415 --- /dev/null +++ b/.docker/production/build @@ -0,0 +1,3 @@ +#!/bin/sh +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose pull +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose build diff --git a/.docker/production/docker-compose.yml b/.docker/production/docker-compose.yml new file mode 100644 index 0000000..d277fc2 --- /dev/null +++ b/.docker/production/docker-compose.yml @@ -0,0 +1,109 @@ +version: '3.1' +services: + fluidbook-v3-httpd: + container_name: fluidbook-v3-httpd + build: './images/httpd' + working_dir: /application + volumes: + - './www/:/usr/local/apache2/htdocs' + - './www/:/application/' + - './config/httpd/httpd.conf:/usr/local/apache2/conf/httpd.conf' + environment: + VIRTUAL_HOST: www.fluidbook.com,en.fluidbook.com,fluidbook.com,elearning.fluidbook.com,fr.elearning.fluidbook.com + LETSENCRYPT_HOST: www.fluidbook.com,en.fluidbook.com,fluidbook.com,elearning.fluidbook.com,fr.elearning.fluidbook.com + restart: unless-stopped + networks: + - nginxproxy + - fluidbook-v3 + + fluidbook-v3: + container_name: fluidbook-v3 + hostname: fluidbook-v3 + build: './images/php-fpm' + working_dir: /application + volumes: + # SSH + - './config/ssh/root/:/root/.ssh/' + - './config/ssh/user/:/application/.ssh/' + - './config/ssh/server/:/etc/ssh/' + # Rsyslog + - './config/rsyslog/rsyslog.conf:/etc/rsyslog.conf' + - './config/rsyslog/50-default.conf:/etc/rsyslog.d/50-default.conf' + # Composer + - './config/composer/:/root/.config/composer/' + - './config/composer/:/application/.config/composer/' + # Sudoers + - './config/sudoers:/etc/sudoers.d/fluidbook-v3' + # ImageMagick + - './config/imagemagick/policy.xml:/etc/ImageMagick-6/policy.xml' + # Passwords + - './config/passwords:/root/passwords' + # Cron + - './config/cron/crontab:/etc/crontab' + # PHP + - './config/php.ini:/etc/php/8.3/fpm/conf.d/99-overrides.ini' + # Web path + - './www:/application' + tmpfs: + - /home/tmp + - /application/framework/data/temp + ports: + - '38840:22' + restart: unless-stopped + networks: + - fluidbook-v3 + + adminer: + image: 'adminer:latest' + container_name: fluidbook-v3-adminer + restart: unless-stopped + environment: + ADMINER_DEFAULT_SERVER: fluidbook-v3-mariadb + VIRTUAL_HOST: adminer.fluidbook.com + LETSENCRYPT_HOST: adminer.fluidbook. + networks: + - fluidbook-v3 + + fluidbook-v3-mariadb: + container_name: fluidbook-v3-mariadb + image: 'mariadb:latest' + restart: unless-stopped + environment: + MARIADB_ROOT_PASSWORD: FB8qVD7R0jqsXYNR + MARIADB_DATABASE: fluidbook-v3 + MARIADB_AUTO_UPGRADE: 1 + volumes: + - "./database/dump.sql:/docker-entrypoint-initdb.d/dump.sql" + - "./database/scripts/:/usr/local/bin/scripts/" + - "./database/data:/var/lib/mysql" + - './config/mariadb:/etc/mysql/conf.d:z' + logging: + driver: json-file + options: + max-size: 10M + max-file: 10 + networks: + - fluidbook-v3 + + mysqlbackup: + image: selim13/automysqlbackup + container_name: fluidbook-v3-automysqlbackup + volumes: + - "./database/backup:/backup" + environment: + USERNAME: root + PASSWORD: FB8qVD7R0jqsXYNR + DBHOST: fluidbook-v3-mariadb + DBEXCLUDE: "performance_schema information_schema" + CRON_SCHEDULE: "0 0 * * *" + EXTRA_OPTS: "--single-transaction" + networks: + - fluidbook-v3 + +networks: + nginxproxy: + external: + name: nginxproxy + fluidbook-v3: + external: + name: fluidbook-v3 diff --git a/.docker/production/update b/.docker/production/update new file mode 100644 index 0000000..a413e51 --- /dev/null +++ b/.docker/production/update @@ -0,0 +1,14 @@ +#!/bin/sh +cd /docker/fluidbook-v3 +docker network create fluidbook-v3 + +chown 0:0 ./config/cron/crontab +chown -R 999:999 ./database/data + +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose pull +COMPOSE_DOCKER_CLI_BUILD=1 DOCKER_BUILDKIT=1 docker compose build + +docker compose down -v +docker compose up -d + +ufw-docker allow fluidbook-v3 \ No newline at end of file diff --git a/.idea/dataSources.local.xml b/.idea/dataSources.local.xml index 554f421..0e0b9b6 100644 --- a/.idea/dataSources.local.xml +++ b/.idea/dataSources.local.xml @@ -1,6 +1,6 @@ - + #@ diff --git a/.idea/deployment.xml b/.idea/deployment.xml index e17b72b..13baf0a 100644 --- a/.idea/deployment.xml +++ b/.idea/deployment.xml @@ -1,6 +1,7 @@ - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - - + - { - "keyToString": { - "RunOnceActivity.OpenProjectViewOnStart": "true", - "RunOnceActivity.git.unshallow": "true", - "WebServerToolWindowFactoryState": "true", - "WebServerToolWindowPanel.toolwindow.highlight.mappings": "true", - "WebServerToolWindowPanel.toolwindow.highlight.symlinks": "true", - "WebServerToolWindowPanel.toolwindow.show.date": "false", - "WebServerToolWindowPanel.toolwindow.show.permissions": "false", - "WebServerToolWindowPanel.toolwindow.show.size": "false", - "git-widget-placeholder": "master", - "ignore.virus.scanning.warn.message": "true", - "kotlin-language-version-configured": "true", - "last_opened_file_path": "D:/Works/spinepro", - "node.js.detected.package.eslint": "true", - "node.js.detected.package.tslint": "true", - "node.js.selected.package.eslint": "(autodetect)", - "node.js.selected.package.tslint": "(autodetect)", - "nodejs_package_manager_path": "npm", - "project.structure.last.edited": "Project", - "project.structure.proportion": "0.0", - "project.structure.side.proportion": "0.2", - "ruby.rails.projectView.checked": "true", - "settings.editor.selected.configurable": "project.propVCSSupport.DirectoryMappings", - "vue.rearranger.settings.migration": "true" + +}]]> + + + + + + + - - - - - - @@ -602,8 +642,8 @@ - @@ -808,7 +848,8 @@ - + + 1494411210038 @@ -1153,7 +1194,7 @@ -