Public DB host name is working but private URL is not

# Use the Alpine Linux base image
FROM php:8-fpm-alpine
RUN apk --no-cache add nginx php php-fpm php-xml php-curl php-mysqli curl php-session php-simplexml rsync unzip zip openrc php-gettext

# RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

ARG SENDY_LICENSE_KEY
ARG MYSQLHOST
ARG MYSQLUSER
ARG MYSQLPASSWORD
ARG MYSQL_DATABASE
ARG CONFIG_FILE
ARG RAILWAY_PUBLIC_DOMAIN



ENV MYSQLHOST=${MYSQLHOST}
ENV MYSQLUSER=${MYSQLUSER}
ENV MYSQLPASSWORD=${MYSQLPASSWORD}
ENV MYSQL_DATABASE=${MYSQL_DATABASE}
ENV RAILWAY_PUBLIC_DOMAIN=${RAILWAY_PUBLIC_DOMAIN}



# Install Nginx and PHP

COPY sendy.conf /etc/nginx/http.d/${RAILWAY_PUBLIC_DOMAIN}.conf

# Expose ports
EXPOSE 8000


# Start both Nginx and PHP-FPM in the foreground when the container starts
RUN echo "Downloading https://sendy.co/download/?license=${SENDY_LICENSE_KEY}" \
    && curl -L -o sendy.zip https://sendy.co/download/?license=${SENDY_LICENSE_KEY} \
    && unzip sendy.zip -d /tmp \
    && rm -rf /tmp/sendy/uploads \
    && rsync -av /tmp/sendy/ /var/www/html/ \
    && rm sendy.zip \
    && rm -rf /tmp/sendy \
    && chown -R www-data:www-data /var/www/html \
    && chmod -R 755 /var/www/html \
    || echo "🚨 Something went wrong with the sendy download, if this is the first time you start this docker stack, this means sendy will not work. If this is not the first time, this means sendy did not auto-update. Please check if the link is live: https://sendy.co/download/?license=${SENDY_LICENSE_KEY}"

#RUN echo "$CONFIG_FILE" > /var/www/html/includes/config.php

COPY config.php /var/www/html/includes/config.php

CMD php-fpm82 -D; nginx -g "daemon off;"

# Use the Alpine Linux base image
FROM php:8-fpm-alpine
RUN apk --no-cache add nginx php php-fpm php-xml php-curl php-mysqli curl php-session php-simplexml rsync unzip zip openrc php-gettext

# RUN docker-php-ext-install mysqli && docker-php-ext-enable mysqli

ARG SENDY_LICENSE_KEY
ARG MYSQLHOST
ARG MYSQLUSER
ARG MYSQLPASSWORD
ARG MYSQL_DATABASE
ARG CONFIG_FILE
ARG RAILWAY_PUBLIC_DOMAIN



ENV MYSQLHOST=${MYSQLHOST}
ENV MYSQLUSER=${MYSQLUSER}
ENV MYSQLPASSWORD=${MYSQLPASSWORD}
ENV MYSQL_DATABASE=${MYSQL_DATABASE}
ENV RAILWAY_PUBLIC_DOMAIN=${RAILWAY_PUBLIC_DOMAIN}



# Install Nginx and PHP

COPY sendy.conf /etc/nginx/http.d/${RAILWAY_PUBLIC_DOMAIN}.conf

# Expose ports
EXPOSE 8000


# Start both Nginx and PHP-FPM in the foreground when the container starts
RUN echo "Downloading https://sendy.co/download/?license=${SENDY_LICENSE_KEY}" \
    && curl -L -o sendy.zip https://sendy.co/download/?license=${SENDY_LICENSE_KEY} \
    && unzip sendy.zip -d /tmp \
    && rm -rf /tmp/sendy/uploads \
    && rsync -av /tmp/sendy/ /var/www/html/ \
    && rm sendy.zip \
    && rm -rf /tmp/sendy \
    && chown -R www-data:www-data /var/www/html \
    && chmod -R 755 /var/www/html \
    || echo "🚨 Something went wrong with the sendy download, if this is the first time you start this docker stack, this means sendy will not work. If this is not the first time, this means sendy did not auto-update. Please check if the link is live: https://sendy.co/download/?license=${SENDY_LICENSE_KEY}"

#RUN echo "$CONFIG_FILE" > /var/www/html/includes/config.php

COPY config.php /var/www/html/includes/config.php

CMD php-fpm82 -D; nginx -g "daemon off;"

    define('APP_PATH', 'https://'.getenv('RAILWAY_PUBLIC_DOMAIN'));

    echo getenv('MYSQLHOST');

    /*  MySQL database connection credentials (please place values between the apostrophes) */
    $dbHost = getenv('MYSQLHOST'); //MySQL Hostname
    $dbUser = getenv('MYSQLUSER'); //MySQL Username
    $dbPass = getenv('MYSQLPASSWORD'); //MySQL Password
    $dbName = getenv('MYSQL_DATABASE'); //MySQL Database Name
    //----------------------------------------------------------------------------------//
    //                                  OPTIONAL SETTINGS
    //----------------------------------------------------------------------------------//

    /*
        Change the database character set to something that supports the language you'll
        be using. Example, set this to utf16 if you use Chinese or Vietnamese characters
    */
    $charset = 'utf8mb4';

    /*  Set this if you use a non standard MySQL port.  */
    $dbPort = getenv('MYSQLPORT');

    /*  Domain of cookie (99.99% chance you don't need to edit this at all)  */
    define('COOKIE_DOMAIN', '');

    define('APP_PATH', 'https://'.getenv('RAILWAY_PUBLIC_DOMAIN'));

    echo getenv('MYSQLHOST');

    /*  MySQL database connection credentials (please place values between the apostrophes) */
    $dbHost = getenv('MYSQLHOST'); //MySQL Hostname
    $dbUser = getenv('MYSQLUSER'); //MySQL Username
    $dbPass = getenv('MYSQLPASSWORD'); //MySQL Password
    $dbName = getenv('MYSQL_DATABASE'); //MySQL Database Name
    //----------------------------------------------------------------------------------//
    //                                  OPTIONAL SETTINGS
    //----------------------------------------------------------------------------------//

    /*
        Change the database character set to something that supports the language you'll
        be using. Example, set this to utf16 if you use Chinese or Vietnamese characters
    */
    $charset = 'utf8mb4';

    /*  Set this if you use a non standard MySQL port.  */
    $dbPort = getenv('MYSQLPORT');

    /*  Domain of cookie (99.99% chance you don't need to edit this at all)  */
    define('COOKIE_DOMAIN', '');