soam Posted April 12, 2020 Share Posted April 12, 2020 (edited) I have been using UnRaid for 15 days now and playing with docker for the same amount of time so I am very green to setting these up. Background: Unraid Server = 10.10.69.12 Workstation Client = 10.10.69.11 MariaDB is setup and accepting connections. phpmyadmin confirmed monicadb database and user access is functional. Monica config: Where im struggling: The webgui is available at http://10.10.69.12:8088/register not https://10.10.69.12:8088/register like it tries to go to when using the "WebUI" button. The first thing I see is that it doesnt look visually the same as the screen shots ive seen: Checking the page source shows that the CSS is being requested via HTTPS so a secure connection is baked in? Checking netstat in the monica container shows only port 80 actively listening: /var/www/monica # netstat -tulpn Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 41/httpd /var/www/monica # Theres nothing showing up in the Apache access.log or error.log. Docker logs show this when trying to access the https connection: 10.10.69.11 - - [12/Apr/2020:21:40:24 +0000] "GET / HTTP/1.1" 302 378 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36" 10.10.69.11 - - [12/Apr/2020:21:40:24 +0000] "\x16\x03\x01\x02" 400 296 "-" "-" The same log file shows this when accessing the http connection: 10.10.69.11 - - [12/Apr/2020:21:40:32 +0000] "GET /register HTTP/1.1" 200 14978 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.163 Safari/537.36" 10.10.69.11 - - [12/Apr/2020:21:40:33 +0000] "\x16\x03\x01\x02" 400 296 "-" "-" 10.10.69.11 - - [12/Apr/2020:21:40:33 +0000] "\x16\x03\x01\x02" 400 296 "-" "-" 10.10.69.11 - - [12/Apr/2020:21:40:33 +0000] "\x16\x03\x01\x02" 400 296 "-" "-" My question is, is this as simple as enabling the https VirtualHost in Apache in the docker container or what I am missing? Edited May 4, 2020 by soam Quote Link to comment
A75G Posted April 13, 2020 Share Posted April 13, 2020 Not %100 sure but i think ur APP_URL is wrong try http://10.10.69.12:8088 Quote Link to comment
soam Posted April 13, 2020 Author Share Posted April 13, 2020 (edited) Thank you for your suggestion, I updated the APP_URL as stated, but ended up with the same results. Right under the text box for APP_UR it states: Quote Container Variable: APP_URL REQUIRES SSL! Read Description! So im making an assumption HTTPS is required. Edited April 13, 2020 by soam Quote Link to comment
soam Posted May 4, 2020 Author Share Posted May 4, 2020 TLDR: Change the APP_ENV variable from "production" to "local". I spun up Ubuntu servers with mariadb databases and followed several different install docs. I ended up documenting this after the 20-25th go around and figured out that using local instead of production in the APP_ENV was the only way to get the web interface to fully load and allow me to register a monica crm username/password. I then replicated this back to the docker container and it started working. https://computingforgeeks.com/install-monica-crm-on-ubuntu-debian/ https://github.com/monicahq/monica/blob/master/docs/installation/faq.md ### ROOT USER ### apt update && apt -y upgrade && apt install -y git php php-intl php-json php-cli php-fpm php-mysql php-zip php-gd php-mbstring php-curl php-xml php-pear php-bcmath php-redis php-gmp && apt install -y composer && apt install -y software-properties-common && apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 && add-apt-repository "deb [arch=amd64,arm64,ppc64el] http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu $(lsb_release -cs) main" && apt update && apt -y install mariadb-server mariadb-client mysql_secure_installation mysql -u root -p ## CREATE USER 'monicaUser' IDENTIFIED by '<PASSWORD>'; CREATE DATABASE IF NOT EXISTS monicahq CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci; GRANT ALL PRIVILEGES ON monicahq.* TO 'monicaUser' IDENTIFIED BY '<PASSWORD>'; FLUSH PRIVILEGES; ## ### NON ROOT ### cd /srv git clone https://github.com/monicahq/monica.git cd monica cp .env.example .env vim .env ## APP_URL=http://IP DB_DATABASE=monicahq DB_USERNAME=monicaUser DB_PASSWORD=<PASSWORD> APP_DISABLE_SIGNUP=false ## composer install --no-interaction --no-suggest --no-dev php artisan key:generate php artisan setup:production php artisan passport:install php artisan schedule:run echo "* * * * * www-data /usr/bin/php /var/www/html/monica/artisan schedule:run" | sudo tee /etc/cron.d/monica ### ROOT ### apt install apache2 libapache2-mod-php a2enmod rewrite systemctl restart apache2 vim /etc/apache2/sites-enabled/monica.conf ## <VirtualHost *:80> ServerName IP ServerAdmin [email protected] DocumentRoot /srv/monica/public <Directory /srv/monica/public> Options Indexes FollowSymLinks AllowOverride All Require all granted </Directory> ErrorLog /var/log/apache2/monica_error.log CustomLog /var/log/apache2/monica_access.log combined </VirtualHost> ## chown -R www-data:www-data /srv/monica chmod -R 775 /srv/monica/storage apachectl -t systemctl restart apache2 1 Quote Link to comment
Haell Posted September 14, 2021 Share Posted September 14, 2021 For people struggling with the above, DO NOT FORGET TO DROP YOUR DATABASE TABLE !! Struggled with this for over an hour, Soam "local" env is the way to go if you want to use NPM for example but you have to create a new database or you will keep running in to errors... Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.