[Znote AAC v2 w/ Uniserver] PHP Fatal Error on Viewing Website (No SQL instructions)

[NoOneImportant]

Hello All. I'm trying to set up a TFS 1.4 server using UniServer for the database and Znote AAC v2 for the website.
Znote's instructions mention how upon typing in localhost, you should see a mySQL connection error with further instructions to follow, but when I type in my localhost, I am greeted with this little number

Checking the error logs in Apache gives more info, saying my machine actively refused the request

[Thu May 09 22:51:18.737953 2024] [mpm_winnt:notice] [pid 15132:tid 424] AH00455: Apache/2.4.58 (Win64) PHP/8.3.0 configured -- resuming normal operations
[Thu May 09 22:51:18.737953 2024] [mpm_winnt:notice] [pid 15132:tid 424] AH00456: Apache Lounge VS17 Server built: Oct 18 2023 13:03:18
[Thu May 09 22:51:18.737953 2024] [core:notice] [pid 15132:tid 424] AH00094: Command line: 'C:\\UniServer\\UniServerZ\\core\\apache2\\bin\\httpd_z.exe -d C:/UniServer/UniServerZ/core/apache2 -f C:\\UniServer\\UniServerZ\\core\\apache2\\conf\\httpd.conf -d C:\\UniServer\\UniServerZ\\core\\apache2'
[Thu May 09 22:51:18.737953 2024] [mpm_winnt:notice] [pid 15132:tid 424] AH00418: Parent: Created child process 21348
[Thu May 09 22:51:19.632099 2024] [mpm_winnt:notice] [pid 21348:tid 448] AH00354: Child: Starting 150 worker threads.
[Thu May 09 22:51:21.661584 2024] [php:error] [pid 21348:tid 1800] [client ::1:49448] PHP Fatal error: Uncaught mysqli_sql_exception: No connection could be made because the target machine actively refused it in C:\\UniServer\\UniServerZ\\www\\engine\\database\\connect.php:35\nStack trace:\n#0 C:\\UniServer\\UniServerZ\\www\\engine\\database\\connect.php(35): mysqli->__construct()\n#1 C:\\UniServer\\UniServerZ\\www\\engine\\init.php(40): require_once('...')\n#2 C:\\UniServer\\UniServerZ\\www\\index.php(2): require_once('...')\n#3 {main}\n thrown in C:\\UniServer\\UniServerZ\\www\\engine\\database\\connect.php on line 35

Unblocking access to apache2's httpd_z.exe in my firewall didn't yield any results, and I got the same issue with the stable version of Znote.
Apache's Server Port is set to 80 by default

If more information is needed, I'm happy to investigate towards where you need me, but I'm at a loss.
Proper thank-yous are in advance

 

[ralke]

Go to your firewall and set entry and exit rules for port 80.
I searched for:

No connection could be made because the target machine actively refused it in

And that says that the connection to the port wasn't reached

No connection could be made because the target machine actively refused it?

Sometimes I get the following error while I was doing HttpWebRequest to a WebService. I copied my code below too. System.Net.WebException: Unable to connect to the remote server ---> System.Net.So...

stackoverflow.com

Here's another good read about that error

How to fix No connection could be made because the target machine actively refused it 127.0.0.1:64527

I have an MVC application which depends on a web API application, I hosted the two on a shared hosting environment. API on the subdomain and MVC on the main domain the API is api.mydomain.com and t...

stackoverflow.com

Check on both links for the most rated replies. Hope you can fix it, regards!

 

[slaw]

It's about mysql, it cannot connect to mysql server.

May be a dumb question - but did you started your mysql server and set the correct IP into Znote's config.php?

 

[NoOneImportant]

It's about mysql, it cannot connect to mysql server.

May be a dumb question - but did you started your mysql server and set the correct IP into Znote's config.php?

At this rate, there's hardly such a thing as a 'dumb question'

From what I understand, $config['sqlHost'] should equal 127.0.0.1 (i.e. localhost) in config.php.

Would the instructions from the error page be generic enough to be able to fill them out just by looking at the config and setting what needs adjusted, or do those instructions vary by machine?

 

[NoOneImportant]

Sorry for being lazy about notifying, but I got the website and the server to run

I went into the config.php file in Uniserver/www/ folder and set the server path to the location of the TFS files. That got the site up, but with a notification error about APCu not being installed. I disabled that feature and was good to go.

As for the server, I had a caching_sha2_password plugin error which was solved through using the MySQL command prompt in the Uniserver tool and changing the authentication policy to default_native_password.