Selfhosting setup failing

krukoo · January 6, 2021, 11:40pm

Hello everyone,

I’ve been trying to get the self-host of invoiceninja working for a while now. On my dedicated server I set up a ubuntu 18.04 VM on which I invoiceninja + mysql and php7.3-fpm (nginx as webserver)

However, I run into a number of problems:

Setup page is not displayed correctly, its is very minimalistic (see screenshot).
After the setup page i get the message: "error: app is already configured, backup then delete the .env file to re-run the setup"
After executing step 2 it displays: "Oops, something went wrong"
after a clean 3rd clean install it displays the loging page very minimalistic (unable to login and it
displays the IP of the vm in the browsers URL after timeout)

output of laravell-error.log

Blockquote [2021-01-06 22:56:37] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:1,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“login”}
[2021-01-06 22:56:37] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:2,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“login”}
[2021-01-06 22:56:37] production.ERROR: Illuminate\Database\QueryException [1698] : /var/www/invoice-ninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 664] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ (SQL: select count(*) as aggregate from users where users.deleted_at is null) {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:3,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“login”}
[2021-01-06 22:56:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:4,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“/”}
[2021-01-06 22:56:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:5,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“/”}
[2021-01-06 22:56:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:6,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“setup”}
[2021-01-06 22:56:42] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“GET”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:7,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“setup”}
[2021-01-06 23:11:56] production.ERROR: Doctrine\DBAL\Driver\PDOException [1698] : /var/www/invoice-ninja/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1698
error229×531 11.3 KB
] Access denied for user ‘forge’@‘localhost’ {“context”:“PHP”,“user_id”:0,“account_id”:0,“user_name”:“”,“method”:“POST”,“user_agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66”,“locale”:“en”,“ip”:“192.168.122.1”,“count”:8,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”,“url”:“setup”}

i followed this guide and tested with php 7.2 and 7.3

In the past I’ve had this working with the same guide. I dont know if there has been an update that can cause this issue

please assist on this

hillel · January 7, 2021, 5:42am

Hi,

The errors indicate you may have the wrong database credentials in the .env file

krukoo · January 7, 2021, 7:51am

Hi Hilel,

thanks for the fast reply. I have checked and adjusted the .env file. The username and password of the database are correct.
i can connect to the database with mysql -u 'username' -p 'database'.

However, this does not explain why the setup and login page is displayed in a very minimalistic way (if they are displayed). Most of the times its gives the mentioned error codes and i have done a reinstall. I even tried with ubuntu 20.04 and php 7.3 but still the same.

Has there been a update on the version of selfhost?

i thought maybe there was a php module missing. but they all seem to be present:

Blockquote
[PHP Modules]
calendar
Core
ctype
date
dom
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
json
libxml
mbstring
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib
[Zend Modules]
Zend OPcache

in the laraval log its displaying forge@localhost, but this is not my user

hillel · January 7, 2021, 8:57am

Are you using a proxy?

krukoo · January 7, 2021, 11:38am

Hi Hilel,

Yes, the VM (wich invoiceninja is installed) sits behind a reverse proxy on the dedicated server(nginx).
There is no SSL installed for now. Http traffic is passed to the vm

hillel · January 7, 2021, 12:07pm

github.com/invoiceninja/dockerfiles

using SSL with docker-compose

opened 07:48AM - 23 Aug 16 UTC

closed 08:09PM - 23 Aug 16 UTC

peterwilli

Hi there, I've made my docker-compose like this (I already have a SQL server ru…nning, hence the environment variables): ``` yml app: image: invoiceninja/invoiceninja environment: - DB_USERNAME=root - DB_PASSWORD=legaal web: image: nginx volumes: - ./nginx.conf:/etc/nginx/nginx.conf:ro links: - app volumes_from: - app ports: - 9292:80 ``` And then run another nginx instance outside docker that has the SSL configuration: ``` # HTTP server { server_name xxx; # redirect non-SSL to SSL location / { rewrite ^ https://$server_name$request_uri? permanent; } } # HTTPS server server { listen 443 ssl spdy; # we enable SPDY here server_name xxx; ssl_certificate /etc/webmin/xxx.pem; ssl_certificate_key /etc/webmin/xxx.pem; location / { proxy_pass http://127.0.0.1:9292; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto https; } } ``` The site shows up but the server still serves some resources as http, as we can see in this screenshot: ![screenshot from 2016-08-23 09-47-29](https://cloud.githubusercontent.com/assets/1212814/17884129/c8904c20-6916-11e6-81ef-e12a815aeafd.png)

krukoo · January 7, 2021, 1:40pm

Hi Hilel,

thansk for the reply. I tryed with TRUSTED_PROXIES but that didnt help.

config of rev proxy that passes the traffic to the VM:

server {
listen 80;
listen [::]:80;
server_name invoice.example.com
access_log /var/log/nginx/reverse-access.log;
error_log /var/log/nginx/reverse-error.log;
   location / {
                proxy_pass http://192.168.122.107;
}
}

config of the nginx on VM (invoiceninja)

server {
listen 80;
server_name invoice.example.com;

root /var/www/invoice-ninja/public/;
index index.php index.html index.htm;
charset utf-8;

location / {
    try_files $uri $uri/ /index.php?$query_string;
}

location = /favicon.ico { access_log off; log_not_found off; }
location = /robots.txt  { access_log off; log_not_found off; }

access_log  /var/log/nginx/invoiceninja.access.log;
error_log   /var/log/nginx/invoiceninja.error.log;

location ~ \.php$ {
    fastcgi_split_path_info ^(.+\.php)(/.+)$;
    fastcgi_pass unix:/run/php/php7.3-fpm.sock;
    fastcgi_index index.php;
    include fastcgi_params;
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    fastcgi_intercept_errors off;
    fastcgi_buffer_size 16k;
    fastcgi_buffers 4 16k;
}

location ~ /\.ht {
    deny all;
}

}

as you can see both are using http.

logging of the invoiceninja.error.log

2021/01/07 13:29:13 [error] 16189#16189: *2352 FastCGI sent in stderr: “Primary script unknown” while reading response header from upstream, client: 192.168.122.1, server:" url-of-invoice", request: “GET /vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.0”, upstream: “fastcgi://unix:/run/php/php7.3-fpm.sock:”, host: “192.168.122.107”

hillel · January 7, 2021, 1:52pm

Sorry, I don’t have any other solutions to share.

krukoo · January 7, 2021, 2:44pm

Hi Hilel,

i got it working with http. in case of reverse proxy with nginx you needed to add proxy_set_header Host $host; under location to the nginx proxy config.

Thanks for your input

nvm… getting Whoops, looks like something went wrong. when logging in. login page is being displayed normal. il keep digging

krukoo · January 7, 2021, 4:32pm

The application is working now with http traffic.
added this to rev proxy config under location.

                proxy_set_header Host $host;
                proxy_set_header X-Real-IP $remote_addr;
                proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto $scheme;
                proxy_redirect off;

and it seems like i was missing the php7.3-curl extension aswell. no need for trusted_proxies
thanks for the input.

hillel · January 7, 2021, 6:03pm

Glad to hear it’s working, thanks for sharing the solutions!

If you see any errors in the app please send the related logs from storage/logs/laravel.log