adamzammit / limesurvey-docker Goto Github PK

Step 7/16 : RUN set -x;     curl -SL "$DOWNLOAD_URL" -o /tmp/lime.zip;     echo "$DOWNLOAD_SHA256 /tmp/lime.zip" | sha256sum -c - || exit 1;     unzip /tmp/lime.zip -d /tmp;     mv /tmp/lime*/* /var/www/html/;     mv /tmp/lime*/.[a-zA-Z]* /var/www/html/;     rm /tmp/lime.zip;     rmdir /tmp/lime*;     chown -R www-data:www-data /var/www/html;     mkdir -p /var/lime/application/config;     mkdir -p /var/lime/upload;     mkdir -p /var/lime/plugins;     mkdir -p /var/lime/sessions;     chown -R www-data:www-data /var/lime/sessions;     cp -dpR /var/www/html/application/config/* /var/lime/application/config;     cp -dpR /var/www/html/upload/* /var/lime/upload;     cp -dpR /var/www/html/plugins/* /var/lime/plugins
 ---> Running in 57696ec6de2f
+ curl -SL https://download.limesurvey.org/latest-master/limesurvey6.1.4+230620.zip -o /tmp/lime.zip
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   162  100   162    0     0     27      0  0:00:06  0:00:05  0:00:01    35
+ echo 64ddd7a7b0c854295882989e51564ca042f6b43ccfe164342688bf3f691e39d7 /tmp/lime.zip
+ sha256sum -c -
/tmp/lime.zip: FAILED
sha256sum: WARNING: 1 computed checksum did NOT match
+ exit 1

`version: "3.0"
services:
  mpulse_6.5:
    build:
      context: .
      dockerfile: dockerfile
    volumes:
      - /tmp/runtime:/var/www/html/tmp/runtime:rw # PHP Main Runtime
    #   - /tmp/assets:/var/www/html/tmp/assets:rw
      - limesurvey-uploads:/var/www/html/upload # Uploaded user survey templates
      - ./plugins:/var/www/html/plugins
      - ./upload:/var/www/html/upload
      - ./config:/var/www/html/application/config
      - ./sessions:/var/lime/sessions
    ports:
      - "8080:80"
    environment:
      - DB_NAME=limesurvey
      - DB_HOST=host.docker.internal
      - DB_PORT=3307
      - DB_USERNAME=secret
      - DB_PASSWORD=secret
      - ADMIN_PASSWORD=password
      - DB_MYSQL_ENGINE=InnoDB
      - "DB_TABLE_PREFIX= "
      - [email protected]
      - LISTEN_PORT=80
      - DEBUG=0
      - DEBUG_SQL=0
      # - PUBLIC_URL=localhost
      - REDIS_HOSTNAME=host.docker.internal
      - REDIS_PORT=6380
      # - REDIS_PASS=A3U163BLemY4!&mvUYL
      # - REDIS_DB=0
    depends_on:
      - redis

  redis:                                                                          
    image: redis
    container_name: redis
    ports:
      - "6380:6379"
    # command: redis-server --requirepass 'A3U163BLemY4!&mvUYL'

volumes:
 limesurvey-uploads:`

`FROM php:8.1-apache
LABEL maintainer="[email protected]"


RUN set -ex; \
        apt-get update; \
        apt-get install -y --no-install-recommends \
                netcat-openbsd \
                libldap-common \
                libsasl2-modules \
                redis-server \
        ; \
        \
        apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; \
        rm -rf /var/lib/apt/lists/*

RUN set -ex; \
        \
        savedAptMark="$(apt-mark showmanual)"; \
        \
        apt-get update; \
        apt-get install -y --no-install-recommends \
                libldap2-dev \
                libfreetype6-dev \
                libjpeg-dev \
                libonig-dev \
                zlib1g-dev \
                libc-client-dev \
                libkrb5-dev \
                libpng-dev \
                libpq-dev \
                libzip-dev \
                libtidy-dev \
                libsodium-dev \
                unzip \
                libmcrypt-dev \
        ; \
        \
        debMultiarch="$(dpkg-architecture --query DEB_BUILD_MULTIARCH)"; \
        docker-php-ext-configure gd --with-freetype --with-jpeg; \
        docker-php-ext-configure imap --with-kerberos --with-imap-ssl; \
        docker-php-ext-configure ldap --with-libdir="lib/$debMultiarch"; \
        docker-php-ext-install -j "$(nproc)" \
                exif \
                gd \
                imap \
                ldap \
                mbstring \
                pdo \
                pdo_mysql \
                pdo_pgsql \
                pgsql \
                sodium \
                tidy \
                zip \
                mysqli \
                opcache \
                iconv \
        ; \
        pecl install mcrypt-1.0.6; \
        docker-php-ext-enable mcrypt; \
        \
        apt-mark auto '.*' > /dev/null; \
        apt-mark manual $savedAptMark; \
        ldd "$(php -r 'echo ini_get("extension_dir");')"/*.so \
                | awk '/=>/ { print $3 }' \
                | sort -u \
                | xargs -r dpkg-query -S \
                | cut -d: -f1 \
                | sort -u \
                | xargs -rt apt-mark manual; \
        ldd "$(php -r 'echo ini_get("extension_dir");')"/*.so \
                | awk '$3 ~ /^\/lib/ { print "/usr"$3 }' \
                | sort -u \
                | xargs -r dpkg-query -S \
                | cut -d: -f1 \
                | sort -u \
                | xargs -rt apt-mark manual; \
        \
        apt-get purge -y --auto-remove -o APT::AutoRemove::RecommendsImportant=false; \
        rm -rf /var/lib/apt/lists/*

RUN mkdir -p /etc/apache2/ssl

RUN a2enmod ssl && a2enmod rewrite

RUN a2enmod rewrite headers


RUN { \
        echo 'opcache.memory_consumption=128'; \
        echo 'opcache.interned_strings_buffer=8'; \
        echo 'opcache.max_accelerated_files=4000'; \
        echo 'opcache.revalidate_freq=2'; \
        echo 'opcache.fast_shutdown=1'; \
        echo 'opcache.enable_cli=1'; \
    } > /usr/local/etc/php/conf.d/opcache-recommended.ini

RUN set -x; \
        chown -R www-data:www-data /var/www/html; \
        chmod -R ug=rx /var/www/html; \
        mkdir -p /var/lime/application/config; \
        mkdir -p /var/lime/upload; \
        mkdir -p /var/lime/plugins; \
        mkdir -p /var/lime/sessions; \
        chown -R www-data:www-data /var/lime/sessions; \
        cp -dpR /var/www/html/application/config/* /var/lime/application/config; \
        cp -dpR /var/www/html/upload/* /var/lime/upload; \
        cp -dpR /var/www/html/plugins/* /var/lime/plugins; \
        chown -R www-data:www-data /var/lime/application; \
        chown -R www-data:www-data /var/lime/plugins; \
        chown -R www-data:www-data /var/lime/upload

RUN mv "$PHP_INI_DIR/php.ini-production" "$PHP_INI_DIR/php.ini"

RUN { \
        echo 'memory_limit=256M'; \
        echo 'upload_max_filesize=128M'; \
        echo 'post_max_size=128M'; \
        echo 'max_execution_time=120'; \
        echo 'max_input_vars=10000'; \
        echo 'date.timezone=UTC'; \
        echo 'session.gc_maxlifetime=86400'; \
        echo 'session.save_path="/var/lime/sessions"'; \
    } > /usr/local/etc/php/conf.d/limesurvey.ini



ARG version="6.5.0+240319"
ARG sha256_checksum="d95a0e3bb114917d536d4d18a2a502799f7c80e81e2dfa3bf5461931563bb31c"
ARG archive_url="https://github.com/LimeSurvey/LimeSurvey/archive/refs/tags/${version}.tar.gz"
ARG USER=root
ARG LISTEN_PORT=80
ENV LIMESURVEY_VERSION=$version

EXPOSE $LISTEN_PORT

WORKDIR /var/www/html
COPY . /var/www/html
COPY entrypoint.sh /usr/local/bin/entrypoint.sh
RUN chmod 777 /usr/local/bin/entrypoint.sh
RUN chmod -R 777 /var/www/html/tmp
RUN chmod -R 777 /var/www/html/upload
RUN chmod -R 777 /var/www/html/themes
RUN chmod -R 777 /var/www/html/application/config
VOLUME ["/var/www/html/plugins"]
VOLUME ["/var/www/html/upload"]
VOLUME ["/var/lime/sessions"]
ensure that the config is persisted especially for security.php
VOLUME ["/var/www/html/application/config"]
COPY vhosts-access-log.conf /etc/apache2/conf-enabled/other-vhosts-access-log.conf
USER $USER
ENTRYPOINT ["/usr/local/bin/entrypoint.sh"]
CMD ["redis-server"]
CMD ["apache2-foreground"]`

/usr/local/bin/docker-entrypoint.sh: line 118: LIMESURVEY_USE_DB_SESSIONS: unbound variable

mysql_1       | 2022-07-02  7:31:26 14 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
mysql_1       | 2022-07-02  7:31:26 14 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

ProxyPass /survey http://127.0.0.1:9355/
ProxyPassReverse /survey http://127.0.0.1:9355/

limesurvey_1  | No config file in /var/www/html Copying default config file...
mysql_1       | 2021-01-15 10:03:51+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.
mysql_1       | 2021-01-15 10:03:52+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
limesurvey_1  | Downloading BaltimoreCyberTrustroot.crt.pem
mysql_1       | 2021-01-15 10:03:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.5.8+maria~focal started.
mysql_1       | 2021-01-15 10:03:52+00:00 [Note] [Entrypoint]: Initializing database files
mail_1        | MailDev webapp running at http://0.0.0.0:80
mail_1        | MailDev SMTP Server running at 0.0.0.0:25
mysql_1       | 
mysql_1       | 
mysql_1       | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
mysql_1       | To do so, start the server, then issue the following commands:
mysql_1       | 
mysql_1       | '/usr/bin/mysqladmin' -u root password 'new-password'
mysql_1       | '/usr/bin/mysqladmin' -u root -h  password 'new-password'
mysql_1       | 
mysql_1       | Alternatively you can run:
mysql_1       | '/usr/bin/mysql_secure_installation'
mysql_1       | 
mysql_1       | which will also give you the option of removing the test
mysql_1       | databases and anonymous user created by default.  This is
mysql_1       | strongly recommended for production servers.
mysql_1       | 
mysql_1       | See the MariaDB Knowledgebase at https://mariadb.com/kb or the
mysql_1       | MySQL manual for more instructions.
mysql_1       | 
mysql_1       | Please report any problems at https://mariadb.org/jira
mysql_1       | 
mysql_1       | The latest information about MariaDB is available at https://mariadb.org/.
mysql_1       | You can find additional information about the MySQL part at:
mysql_1       | https://dev.mysql.com
mysql_1       | Consider joining MariaDB's strong and vibrant community:
mysql_1       | https://mariadb.org/get-involved/
mysql_1       | 
mysql_1       | 2021-01-15 10:03:54+00:00 [Note] [Entrypoint]: Database files initialized
mysql_1       | 2021-01-15 10:03:54+00:00 [Note] [Entrypoint]: Starting temporary server
mysql_1       | 2021-01-15 10:03:54+00:00 [Note] [Entrypoint]: Waiting for server startup
mysql_1       | 2021-01-15 10:03:54 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 104 ...
mysql_1       | 2021-01-15 10:03:54 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
mysql_1       | 2021-01-15 10:03:54 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Using Linux native AIO
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Uses event mutexes
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Number of pools: 1
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql_1       | 2021-01-15 10:03:54 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: 128 rollback segments are active.
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: 10.5.8 started; log sequence number 45118; transaction id 20
mysql_1       | 2021-01-15 10:03:54 0 [Note] Plugin 'FEEDBACK' is disabled.
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1       | 2021-01-15 10:03:54 0 [Note] InnoDB: Buffer pool(s) load completed at 210115 10:03:54
mysql_1       | 2021-01-15 10:03:54 0 [Warning] 'user' entry 'root@d65a4da63683' ignored in --skip-name-resolve mode.
mysql_1       | 2021-01-15 10:03:54 0 [Warning] 'proxies_priv' entry '@% root@d65a4da63683' ignored in --skip-name-resolve mode.
mysql_1       | 2021-01-15 10:03:54 0 [Note] Reading of all Master_info entries succeeded
mysql_1       | 2021-01-15 10:03:54 0 [Note] Added new Master_info '' to hash table
mysql_1       | 2021-01-15 10:03:54 0 [Note] mysqld: ready for connections.
mysql_1       | Version: '10.5.8-MariaDB-1:10.5.8+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
mysql_1       | 2021-01-15 10:03:55+00:00 [Note] [Entrypoint]: Temporary server started.
mysql_1       | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
mysql_1       | Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
mysql_1       | Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
mysql_1       | 2021-01-15 10:03:59 5 [Warning] 'proxies_priv' entry '@% root@d65a4da63683' ignored in --skip-name-resolve mode.
mysql_1       | 
mysql_1       | 2021-01-15 10:03:59+00:00 [Note] [Entrypoint]: Stopping temporary server
mysql_1       | 2021-01-15 10:03:59 0 [Note] mysqld (initiated by: root[root] @ localhost []): Normal shutdown
mysql_1       | 2021-01-15 10:03:59 0 [Note] Event Scheduler: Purging the queue. 0 events
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: FTS optimize thread exiting.
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: Starting shutdown...
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: Buffer pool(s) dump completed at 210115 10:03:59
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: Shutdown completed; log sequence number 45130; transaction id 21
mysql_1       | 2021-01-15 10:03:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
mysql_1       | 2021-01-15 10:03:59 0 [Note] mysqld: Shutdown complete
mysql_1       | 
mysql_1       | 2021-01-15 10:04:00+00:00 [Note] [Entrypoint]: Temporary server stopped
mysql_1       | 
mysql_1       | 2021-01-15 10:04:00+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
mysql_1       | 
mysql_1       | 2021-01-15 10:04:00 0 [Note] mysqld (mysqld 10.5.8-MariaDB-1:10.5.8+maria~focal) starting as process 1 ...
mysql_1       | 2021-01-15 10:04:00 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
mysql_1       | 2021-01-15 10:04:00 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Using Linux native AIO
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Uses event mutexes
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Number of pools: 1
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mysql_1       | 2021-01-15 10:04:00 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: 128 rollback segments are active.
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: 10.5.8 started; log sequence number 45130; transaction id 20
mysql_1       | 2021-01-15 10:04:00 0 [Note] Plugin 'FEEDBACK' is disabled.
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1       | 2021-01-15 10:04:00 0 [Note] InnoDB: Buffer pool(s) load completed at 210115 10:04:00
mysql_1       | 2021-01-15 10:04:00 0 [Note] Server socket created on IP: '::'.
mysql_1       | 2021-01-15 10:04:00 0 [Warning] 'proxies_priv' entry '@% root@d65a4da63683' ignored in --skip-name-resolve mode.
mysql_1       | 2021-01-15 10:04:00 0 [Note] Reading of all Master_info entries succeeded
mysql_1       | 2021-01-15 10:04:00 0 [Note] Added new Master_info '' to hash table
mysql_1       | 2021-01-15 10:04:00 0 [Note] mysqld: ready for connections.
mysql_1       | Version: '10.5.8-MariaDB-1:10.5.8+maria~focal'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
limesurvey_1  | Failed to download certificate - continuing anyway
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_1  | 
limesurvey_1  | MySQL Connection Error: () 
limesurvey_limesurvey_1 exited with code 1

limesurvey-1  | Copying default container default config files into config volume...
limesurvey-1  | cp: cannot create regular file 'application/config/config-defaults.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/config-sample-dblib.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/config-sample-mysql.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/config-sample-pgsql.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/config-sample-sqlsrv.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/console.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/email.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/fonts.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/index.html': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/internal.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/ldap.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/packages.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/questiontypes.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/rest/v1/example/survey-patch-all.json': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/rest/v1/session.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/rest/v1/survey.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/rest/v1.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/rest.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/routes.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/tcpdf.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/updater_version.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/vendor.php': Permission denied
limesurvey-1  | cp: cannot create regular file 'application/config/version.php': Permission denied

500: Internal Server Error
imagecolorallocate(): Argument #2 ($red) must be between 0 and 255 (inclusive)

Parse error: syntax error, unexpected identifier "iE209", expecting ")" in /var/www/html/application/config/config.php on line 32

sed: -e expression #1, char 48: unknown option to `s'

DROP TABLE IF EXISTS `lime_users`;
CREATE TABLE `lime_users` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `users_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` blob NOT NULL,
  `full_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` int(11) NOT NULL,
  `lang` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
  `htmleditormode` varchar(7) COLLATE utf8_unicode_ci DEFAULT 'default',
  `templateeditormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `questionselectormode` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `one_time_pw` blob,
  `dateformat` int(11) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `users_name` (`users_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `lime_users`
--

INSERT INTO `lime_users` (`uid`,`users_name`,`password`,`full_name`,`parent_id`,`lang`,`email`,`htmleditormode`,`templateeditormode`,`questionselectormode`,`one_time_pw`,`dateformat`,`created`,`modified`) VALUES
('1', 'admin', 'password', 'Admin', '0', 'en', 'email_address', 'default', 'default', 'default', NULL, '1', '2023-05-23 18:45:00', NULL);

services:    
    limesurvey:
        image: acspri/limesurvey
        container_name: limesurvey
        depends_on:
            - limedb
        ports:
            - 8082:80
        environment:
            - LIMESURVEY_DB_HOST=limedb
            - LIMESURVEY_DB_PASSWORD=${LIMEDB_PW}
            - LIMESURVEY_ADMIN_USER="admin"
            - LIMESURVEY_ADMIN_PASSWORD="password"
            - LIMESURVEY_ADMIN_NAME="Admin"
            - LIMESURVEY_ADMIN_EMAIL=${EMAIL}
        volumes:
            - /docker/limesurvey/plugins:/var/www/html/plugins
            - /docker/limesurvey/upload:/var/www/html/upload
            - /docker/limesurvey/config:/var/www/html/application/config
    limedb:
        image: linuxserver/mariadb:latest
        container_name: limedb
        environment:
            - PUID=1000
            - PGID=1000
            - MYSQL_ROOT_PASSWORD=${LIMEDB_PW}
            - TZ=${TIMEZONE}
        volumes:
            - /docker/limedb:/config```

if [ -n "$MYSQL_SSL_CA" ]; then
    set_config 'attributes' "array(PDO::MYSQL_ATTR_SSL_CA => '\/var\/www\/html\/$MYSQL_SSL_CA', PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false)"
fi

nginx:
   container_name: limesurvey_proxy
   restart: always
   image: nginx
   volumes:
   - /etc/containers/limesurvey/nginx.conf:/etc/nginx/nginx.conf:ro
   - /etc/containers/limesurvey/limesite.conf:/etc/nginx/conf.d/default.conf:ro
   - /etc/containers/limesurvey/certs:/etc/nginx/certs
   - /opt/limesurvey/nginx-logs:/var/log/nginx
   ports:
   - 443:443
   links:
   - limesurvey
   networks:
     limenetwork_compose:
   command: /bin/bash -c "nginx -g 'daemon off;'"

server {
    listen       443 ssl http2;
    server_name <FQDN>;

        ssl_certificate     /etc/nginx/certs/crt.pem;
        ssl_certificate_key /etc/nginx/certs/key.pem;

        ssl_protocols TLSv1.2 TLSv1.3;
        ssl_session_cache shared:SSL:10m;
        ssl_session_tickets off;
        ssl_stapling off;
        ssl_stapling_verify off;

    location / {
    proxy_pass http://limesurvey:80/;
    proxy_buffering off;
    proxy_http_version 1.1;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $http_connection;
    access_log off;
    client_max_body_size 4096m;
}

Copying default container default config files into config volume...
No index.html file upload dir in /var/www/html Copying defaults...
Updating password for admin user
Password for user admin was set.
Flushing assets in /var/www/html/tmp
[Tue Oct 05 14:45:54.233787 2021] [:crit] [pid 1] (38)Function not implemented: AH00141: Could not initialize random number generator

  limesurvey5:
    image: acspri/limesurvey:5.1.14
    container_name: limesurvey_lime5
    ports:
      - "8082:80"
    environment:
      - "LIMESURVEY_DB_HOST=*****************************.rds.amazonaws.com"
      - "LIMESURVEY_DB_NAME=limesurvey5"
      - "LIMESURVEY_DB_USER=*********"
      - "LIMESURVEY_DB_PASSWORD=***********************"
      - "LIMESURVEY_TABLE_PREFIX=lime_"
      - "LIMESURVEY_ADMIN_USER=********"
      - "LIMESURVEY_ADMIN_PASSWORD=*************************"
      - "[email protected]"
      - "LIMESURVEY_ADMIN_NAME=Admin User"
      - "LIMESURVEY_DEBUG=2"
    restart: always
    volumes:
      - ./plugins:/var/www/html/plugins
      - ./upload:/var/www/html/upload
      - ./config:/var/www/html/application/config