Connect database manual install leads to blank page 500 error

wrongecho

Hey!

What do you get in the error logs, usually /var/log/nginx/error_log ?

cpjet64

testadmin@testitflow:/usr/share/nginx/html/itflow$ sudo tail -f /var/log/nginx/error.log

2024/03/18 20:51:41 [error] 41722#41722: *45 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Server sent charset (0) unknown to the client. Please, report to the developers in /usr/share/nginx/html/itflow/setup.php:52

Stack trace:

#0 /usr/share/nginx/html/itflow/setup.php(52): mysqli_connect()

#1 {main}

thrown in /usr/share/nginx/html/itflow/setup.php on line 52" while reading response header from upstream, client: 10.0.1.100, server: 10.0.1.122, request: "POST /setup.php?database HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "10.0.1.122", referrer: "http://10.0.1.122/setup.php?database"

2024/03/18 20:52:01 [error] 41722#41722: *53 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Server sent charset (0) unknown to the client. Please, report to the developers in /usr/share/nginx/html/itflow/setup.php:52

Stack trace:

#0 /usr/share/nginx/html/itflow/setup.php(52): mysqli_connect()

#1 {main}

cpjet64

I didnt see any requirements for changing encoding in the install doc so i figured the default would be ok

cpjet64

Here is the nginx site conf if it helps.

server {

listen 80;

server_name 10.0.1.122;

root /usr/share/nginx/html/itflow;

index index.html index.htm index.php;

location / {

    try_files $uri $uri/ =404;

}

location \~ \\.php$ {

    include snippets/fastcgi-php.conf;

    fastcgi_pass unix:/var/run/php/php8.3-fpm.sock;

 }

location \~ /\\.ht {

    deny all;

}

}

wrongecho

setup.php:52 is the DB Connection test.

This post suggests its an issue with the MySQL client you're using, but not 100% sure.

Worth mentioning we'd recommend running MariaDB as the database backend, MySQL seems to have issues.

cpjet64

wrongecho I am using MariaDB as its so much better than MySQL xD.

mariadb -V

mariadb from 11.3.2-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using EditLine wrapper

cpjet64

wrongecho That post actually fixed the issue!

Even using the latest MariaDB you still need to append the following to your my.cnf

`[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8`

cpjet64

In my testbed I would like to avoid needing to subdomain and instead just use pagelocation but if/when i take it like it will reside on a subdomain most likely.

cpjet64

coming across a new issue now.

After going through the setup and changing the config.php to disable https only once I login i get another 500 error showing in nginx as the following but is confusing to me since I set the currency to USD in the setup wizard.

testadmin@testitflow:/usr/share/nginx/html/itflow$ sudo tail -f 100 /var/log/nginx/error.log

tail: cannot open '100' for reading: No such file or directory

==> /var/log/nginx/error.log <==

Stack trace:

#0 /usr/share/nginx/html/itflow/setup.php(52): mysqli_connect()

#1 {main}

2024/03/18 21:14:52 [error] 41722#41722: *73 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function numfmt_create() in /usr/share/nginx/html/itflow/check_login.php:62

Stack trace:

#0 /usr/share/nginx/html/itflow/inc_all.php(7): require_once()

#1 /usr/share/nginx/html/itflow/clients.php(7): require_once('...')

#2 {main}

thrown in /usr/share/nginx/html/itflow/check_login.php on line 62" while reading response header from upstream, client: 10.0.1.100, server: 10.0.1.122, request: "GET /clients.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.3-fpm.sock:", host: "10.0.1.122", referrer: "http://10.0.1.122/login.php"

2024/03/18 21:16:00 [error] 41722#41722: *73 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function numfmt_create() in /usr/share/nginx/html/itflow/check_login.php:62

Stack trace:

#0 /usr/share/nginx/html/itflow/inc_all.php(7): require_once()

#1 /usr/share/nginx/html/itflow/clients.php(7): require_once('...')

#2 {main}

wrongecho

Glad you managed to figure it out 🙂.

We haven't run into charset issues yet, I think it's related to this:

https://mariadb.com/kb/en/mariadb-11-3-2-release-notes/

wrongecho

numfmt_create() requires php-intl, do you have that installed and enabled?

cpjet64

wrongecho No I did not lol. You are a godsend. Thank you!!! This is the fastest helpdesk site I have ever used…. Is it possible to integrate it with paypal in addition to stripe by any chance?

wrongecho

Haha, thanks. I think you just got lucky I was around lol

Regarding Stripe/Paypal, we're considering other providers but it's a low priority as we have Stripe. See: https://forum.itflow.org/d/439-payment-integrations-megathread to share your thoughts 🙂

cpjet64

wrongecho Will do!! Thank you again and I think everyone in IT has their lucky days haha.