Problem with webserver installation

[gaunt cave]

I'm downloading the web server detached from the plugin because I need to create it on a second vps, this is the guide I'm following: https://github.com/webbukkit/dynmap/wiki/[Tutorial]-Setting-up-a-standalone-web-server-with-MySQL-SQLite/#configurating-the-mysqlmariadb-database

I'm having problems with the database not connecting to the plugin. This is the error that comes out:
[14:05:18 ERROR]: [dynmap] SQLException: Error creating tables [14:05:18 ERROR]: [dynmap] ErrorCode: 0, SQLState=08001 [14:05:18 ERROR]: [dynmap] Message: Could not create connection to database server. Attempted reconnect 3 times. Giving up. [14:05:18 ERROR]: [dynmap] ConnectionString: jdbc:mysql://123.123.123.123:3306/dynmap_db?allowReconnect=true&autoReconnect=true [14:05:18 ERROR]: [dynmap] CausedBy: null, message from server: "Host '172.18.0.2' is not allowed to connect to this MySQL server" [14:05:18 ERROR]: [dynmap] Map storage initialization failure

[oblique summit]

Before we get started, please tell us a bit about your server setup:

Before we get started, please tell us a bit about your server setup:

[acoustic crow]

the line before last states the error, it is out of dynmap's support domain as your mysql database has wrong permissions, google is your friend on this

[gaunt cave]

I have now finished configuring everything, following the guide in detail. This is the error that comes out when I try to connect to the site that is on the different vps from the minecraft server. I think I have understood where the problem lies, because if I open the configuration file present in the web folder it is only written that that configuration has now been moved to another file. Thinking about it though, if I deactivate the internal webserver, dynmap should have saved the configuration to that file, which as already mentioned is empty...

Obviously I ran dynmap after changing those values ​​but the file remains the same empty

[acoustic crow]

check the error.log in your webserver

[gaunt cave]

`2023/11/17 16:15:53 [crit] 2621398#2621398: *7 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://server-address/"
2023/11/17 16:16:01 [crit] 2621397#2621397: *6 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://server-address/"
2023/11/17 16:17:43 [crit] 2621397#2621397: *14 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://server-address/"
2023/11/17 16:24:34 [crit] 2621397#2621397: *20 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://server-address/"
2023/11/17 21:47:26 [crit] 2621397#2621397: *2534 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://server-address/"

[acoustic crow]

you need to install and configure php, and set its version in the config of your site, as stated in the guide

[gaunt cave]

I checked and everything is installed, the only thing is that I'm using version 8.2.3 of php because I also have another site that uses it. Is it a problem?

this is the error:
2023/11/18 09:57:24 [crit] 2658570#2658570: *1 connect() to unix:/var/run/php/php7.2-fpm.sock failed (2: No such file or directory) while connecting to upstream, client: client-ip, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://pixeltime.it/"

[acoustic crow]

then you didn't do the second part of my message.

[gaunt cave]

now i have this error:
2023/11/18 10:42:02 [error] 4229#4229: *17 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /var/www/dynmap/standalone/MySQL_funcs.php:31 Stack trace: #0 /var/www/dynmap/standalone/MySQL_funcs.php(42): initDbIfNeeded() #1 /var/www/dynmap/standalone/MySQL_funcs.php(67): getStandaloneFileByServerId('dynmap_config.j...', 0) #2 /var/www/dynmap/standalone/MySQL_configuration.php(22): getStandaloneFile('dynmap_config.j...') #3 {main} thrown in /var/www/dynmap/standalone/MySQL_funcs.php on line 31" while reading response header from upstream, client: client-id, server: pixeltime.it, request: "GET /standalone/MySQL_configuration.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "pixeltime.it", referrer: "http://pixeltime.it/"

I have already checked that everything was installed and I manually activated the mysqli extension in the php.ini file. but nothing, this error comes out

Could it be because the site is on port 500? I cleared it of errors just for safety reasons

[acoustic crow]

you have to also install php-mysqli, also stated on the guide

[gaunt cave]

.

[acoustic crow]

did you install it for the right version?

php doesn't recognize it

[gaunt cave]

Installing the specific version of php mysql solved the problem, thanks for the help!

[acoustic crow]

np