White Screen After Setup.php

redflare

Hi. getting a white screen after setup.php. I've reinstalled debian twice thinking it was an issue there. On both installs, it didn't install it to the default /var/www/html folder, it created another folder inside /var/www/ named the domain name I am using. I since copied all files from html to this new folder, and can see the setup.php wizard when going to the domain name. However, now when I put the credentials in, I just get a white screen. This has happened both times. I really want to get this installed. Last error in the logs is here:

[Wed Aug 21 20:16:41.001671 2024] [php:error] [pid 16133:tid 16133] [client XX.XX.XX.XX:XXXXX] PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'itflow'@'localhost' (using password: YES) in /var/www/html/setup.php:53\nStack trace:\n#0 /var/www/html/setup.php(53): mysqli_connect()\n#1 {main}\n thrown in /var/www/html/setup.php on line 53, referer: https://it.domain.com

Password is not incorrect, using the one given at the end of the install. Putting itflow as user and db name. Help 🙁

Bigbug

redflare [client XX.XX.XX.XX:XXXXX]

I've redacted your IP for your safety

It's not the best idea to leave the setup page open on the internet for too long

redflare

I also want to add, this is via the install script and it is not on a VM, directly on the host machine. Tia

wrongecho

Hey there @redflare

On both installs, it didn't install it to the default /var/www/html folder, it created another folder inside /var/www/ named the domain name I am using.

This is as expected for the install script (also see here). By copying the files you've probably broken the git installer as you've likely missed the hidden .git folder meaning updates won't work.

PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'itflow'@'localhost' (using password: YES)

It definitely sounds like an authentication issue with the database. This tends to happen if you run the installer multiple times as the database and user can only be created once. Try the following commands to tidy up the database, and then try using the install script again.

~$sudo mysql -u root

MariaDB>DROP DATABASE itflow;

MariaDB>DROP USER ‘itflow’@’localhost’;

You can also test the username / password the script creates with mysql -u itflow -p

redflare

wrongecho this worked! Strange it didn't work just off of the bat however, especially after the 2nd reinstall of debian I didn't try anything more than once. I'm in anyway, thanks for your help

redflare

Thanks. Will try shortly. In terms of copying the files to the html folder, should I of not done that? How would I get it to resolve to the virtual directory the script created rather than the html folder when going to my domain?

Bigbug

redflare I think you should reinstall Debian 12 fresh again and don't move any folders, follow the docs strictly step by step. if you don't want to run into issues in the future

wrongecho

I'm glad you got it working!

Make sure to read over the post install instructions.

In terms of copying the files to the html folder, should I of not done that? How would I get it to resolve to the virtual directory the script created rather than the html folder when going to my domain?

So the install script creates a virtual host and tells Apache to direct all requests to the sub domain you specify to that folder/vhost. You shouldn't need to move anything, but it's be worth checking Settings > Update to ensure moving the files didn't break anything. We use Git for updates, and this relies on a hidden .git folder.

redflare

wrongecho seems it does still work. Hitting update doesn't throw an error at least?

Alan

I used the moving of the script on this page thanks to GKW (https://forum.itflow.org/d/707-ssl-error-after-configuration), and it worked better 2nd time around (keep meaning to ask for a wiki login to add bits and pieces I find… haven't got a round tuit yet 🙂 )

wrongecho

redflare

Can you share a screenshot?

redflare

wrongecho

redflare

Looks good to me!