RESOLVED: MonicaHQ CRM Setup Help?

[soam]

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

[A75G]

Not %100 sure but i think ur APP_URL is wrong try http://10.10.69.12:8088

[soam]

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

[soam]

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

 

[Haell]

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...