V5.5.74 setup loop

Self-Hosted | v5
1

Hello, I’m trying to install InvoiceNinja 5.5.74 on Ubuntu 22.04, Apache and PHP8.1 with MySQL8 running on it’s own server. Seems I have everything good so far but when I get to the setup page, everything tests okay and writes to the .env file but upon completion it just loops me right back to the /setup page to start the process over. No errors to the screen.

If i remove /setup from the URL I get a weird page with a large logo and at the bottom says 500 — Server Error.

In the logs, the only think I see is in the larval.log file stating:

Error Output:
sh: 1: mysql: not found

[2023-02-24 15:26:43] production.INFO: The command “mysql --user=”${:LARAVEL_LOAD_USER}" --password=“${:LARAVEL_LOAD_PASSWORD}” --host=“${:LARAVEL_LOAD_HOST}” --port=“${:LARAVEL_LOAD_PORT}” --database=“${:LARAVEL_LOAD_DATABASE}” < “${:LARAVEL_LOAD_PATH}”" failed.

Exit Code: 127(Command not found)

Working directory: /var/www/invoiceninja/public

Output:

Error Output:
sh: 1: mysql: not found

The apache conf looks like this:
<VirtualHost *:80>
<Directory /var/www/invoiceninja>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted

ServerAdmin webmaster@localhost
ServerName
ServerAlias
DocumentRoot /var/www/invoiceninja/public
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined

Any ideas or guidance would be appreciated.

2

Update…Found that even though i’m using a remote MYSQL server, I still had to install mysql locally for some reason then setup let me proceed. Now my issue is the page doesn’t load at all. I get connection timed out but it did write the database tables. InvoiceNinja has one of the strangest installs I’ve come across in a while. Any ideas why the page won’t load? I tried configuring for 443 and 80 but no matter which it won’t load.

3

The issue for mysql would have been mysql-client not being installed.

Are there any errors in the logs at all in storage/logs/laravel.log

It sounds like there is a problem with the webserver talking to the php server.

4

End of the log shows:

Error Output:

sh: 1: mysql: not found

[2023-02-24 15:53:02] production.INFO: account table not found
[2023-02-24 15:57:32] production.INFO: account table not found
[2023-02-24 16:02:27] production.INFO: account table not found
[2023-02-24 16:02:54] production.INFO: account table not found
Error: command not found

================: command not found
Command ‘sh:’ not found, did you mean:
command ‘shc’ from deb shc (4.0.3-1)
command ‘sh’ from deb dash (0.5.11+git20210903+057cd650a4ed-3build1)
Try: sudo apt install
-bash: “mysql --user=”${:LARAVEL_LOAD_USER}" --password=“${:LARAVEL_LOAD_PASSWORD}” --host=“${:LARAVEL_LOAD_HOST}” --port=“${:LARAVEL_LOAD_PORT}” --database=“${:LARAVEL_LOAD_DATABASE}” < “${:L
ARAVEL_LOAD_PATH}”": bad substitution
-bash: syntax error near unexpected token `(’
Working: command not found
Output:: command not found
================: command not found
Error: command not found
================: command not found
Command ‘sh:’ not found, did you mean:
command ‘sh’ from deb dash (0.5.11+git20210903+057cd650a4ed-3build1)
command ‘shc’ from deb shc (4.0.3-1)
Try: sudo apt install
[2023-02-24: command not found
[2023-02-24: command not found
[2023-02-24: command not found
[2023-02-24: command not found