504 error | CtrlPanel.gg | Page 1

granite sail Apr 15, 2024, 12:55 PM

#

Hey, i cant delete this message.

#

can someone help me to fix this?

near shale Apr 15, 2024, 1:14 PM

#

Read error message

granite sail Apr 15, 2024, 1:22 PM

#

i read

#

near shale Apr 15, 2024, 3:35 PM

#

Ok, then

Go to /admin/overview/sync page
Send logs

bright geyserBOT Apr 15, 2024, 3:35 PM

#

Can you please fetch the error logs, so we can assist you better regarding this error.
tail -n 100 /var/www/controlpanel/storage/logs/laravel.log | nc pteropaste.com 99

granite sail Apr 15, 2024, 8:36 PM

#

https://pteropaste.com/no3g3jorj2qm

near shale Apr 15, 2024, 8:37 PM

#

Do u use any addons?

granite sail Apr 15, 2024, 8:38 PM

#

ptero or ctrl

near shale Apr 15, 2024, 9:11 PM

#

ctrlpanel

granite sail Apr 16, 2024, 2:52 PM

#

no

near shale Apr 16, 2024, 6:02 PM

#

Hm, check your smtp configuration

granite sail Apr 20, 2024, 3:05 PM

#

near shale Hm, check your smtp configuration

Hello MrWeez, can i somehow backup the ctrlpanel and restore it on new VPS?

near shale Apr 20, 2024, 3:16 PM

#

Read the docs

#

It is written there

granite sail Apr 25, 2024, 1:12 PM

#

near shale It is written there

Hey, can u please help me?

#

near shale Apr 25, 2024, 1:12 PM

#

Send nginx logs

#

tail -n 100 /var/log/nginx/error.log | nc pteropaste.com 99

granite sail Apr 25, 2024, 1:12 PM

#

https://pteropaste.com/8zhh

granite sail Apr 25, 2024, 1:13 PM

#

near shale `tail -n 100 /var/log/nginx/error.log | nc pteropaste.com 99`

https://pteropaste.com/oi4x

#

?

#

https://pteropaste.com/upi5

#

hm

near shale Apr 25, 2024, 1:26 PM

#

SQLSTATE[HY000] [2002] Connection timed out

bright geyserBOT Apr 25, 2024, 1:27 PM

#

Your database is refusing the dashboard's attempts to connect to it. This can be for a number of different reasons so I'll let a human double check, but here are some ideas.

Is your MySQL instance running? systemctl status mysql
Is the user you're trying to connect with authorized to access the given database from this IP address?
Did you correctly give that user permission to even access that database?
Do you have a Firewall that is blocking connections?
Is your MySQL instance bound to 127.0.0.1 or localhost and you're trying to connect from outside the server?
Does the user have GRANT permissions if you're trying to use them to create a new database for a server?
Have special characters in your password? Make sure DB_PASSWORD in your .env file is enclosed in double quotes

Here is some additional documentation to help you out: https://CtrlPanel.gg/docs/Installation/getting-started#database-setup

——————————-
credits to pterodactyl team for making this good message

Getting started | Ctrlpanel.gg

It is recommended that you have some sort of Linux and MariaDB experience before installing this.

granite sail Apr 25, 2024, 1:36 PM

#

what i need to make if i changed the IP address of the server

granite sail Apr 25, 2024, 3:26 PM

#

?

near shale Apr 25, 2024, 3:27 PM

#

granite sail what i need to make if i changed the IP address of the server

I would recommend restarting the server

#

And don't forget to change ip in the A or AAA records

granite sail Apr 25, 2024, 3:55 PM

#

near shale And don't forget to change ip in the A or AAA records

i did

granite sail Apr 25, 2024, 3:55 PM

#

near shale I would recommend restarting the server

i did

#

#

but i have this error

#

https://pteropaste.com/ozek

#

504 error

near shale Apr 25, 2024, 4:02 PM

#

Check your database connection

bright geyserBOT Apr 25, 2024, 4:02 PM

#

Your database is refusing the dashboard's attempts to connect to it. This can be for a number of different reasons so I'll let a human double check, but here are some ideas.

Is your MySQL instance running? systemctl status mysql
Is the user you're trying to connect with authorized to access the given database from this IP address?
Did you correctly give that user permission to even access that database?
Do you have a Firewall that is blocking connections?
Is your MySQL instance bound to 127.0.0.1 or localhost and you're trying to connect from outside the server?
Does the user have GRANT permissions if you're trying to use them to create a new database for a server?
Have special characters in your password? Make sure DB_PASSWORD in your .env file is enclosed in double quotes

Here is some additional documentation to help you out: https://CtrlPanel.gg/docs/Installation/getting-started#database-setup

——————————-
credits to pterodactyl team for making this good message

Getting started | Ctrlpanel.gg

It is recommended that you have some sort of Linux and MariaDB experience before installing this.

granite sail Apr 25, 2024, 4:38 PM

#

granite sail Apr 25, 2024, 7:54 PM

#

hm?

granite sail Apr 26, 2024, 5:10 AM

#

can u help me please

fading void Apr 26, 2024, 5:16 AM

#

hi

granite sail Apr 26, 2024, 5:16 AM

#

hi

#

fading void Apr 26, 2024, 5:17 AM

#

lets see hmm

granite sail Apr 26, 2024, 5:17 AM

#

you know how can i fix this?

fading void Apr 26, 2024, 5:17 AM

#

yes I think i do

granite sail Apr 26, 2024, 5:17 AM

#

lets go

fading void Apr 26, 2024, 5:17 AM

#

run systemctl status php8.1-fpm

granite sail Apr 26, 2024, 5:17 AM

#

k 1 sec

#

fading void Apr 26, 2024, 5:18 AM

#

huh

#

what does your latest nginx logs show

granite sail Apr 26, 2024, 5:19 AM

#

this

#

https://pteropaste.com/913s

bright geyserBOT Apr 26, 2024, 5:19 AM

#

granite sail https://pteropaste.com/913s

Our installation guide can be found at: https://CtrlPanel.gg

Ctrlpanel.gg | Ctrlpanel.gg

ControlPanel's Dashboard is a free and open-source management panel for pterodactyl with credit based billing and lots of customization.

fading void Apr 26, 2024, 5:20 AM

#

oh, systemctl status mysql

#

what's the status of this

granite sail Apr 26, 2024, 5:20 AM

#

fading void Apr 26, 2024, 5:21 AM

#

that's really strange hmmmmmm

#

send your nginx config for cpgg as well

granite sail Apr 26, 2024, 5:22 AM

#

#

this?

fading void Apr 26, 2024, 5:23 AM

#

yep yep

#

and run this command and send output tail -n 100 /var/log/nginx/error.log

granite sail Apr 26, 2024, 5:24 AM

#

fading void Apr 26, 2024, 5:25 AM

#

okay

#

what's the resource using on this machine? like current RAM and CPU usage

#

it might be happening because of full resource usage, php-fpm not getting to process the request

granite sail Apr 26, 2024, 5:31 AM

#

fading void what's the resource using on this machine? like current RAM and CPU usage

ram is 2.5gb/8gb and cpu is 4Cores

#

cpu usage is 1%

fading void Apr 26, 2024, 5:35 AM

#

hm then I don't know what could be the issue

#

try restarting nginx and php8.1-fpm

granite sail Apr 26, 2024, 5:36 AM

#

restarted

#

and still same error

kind girder Apr 26, 2024, 8:26 AM

#

@granite sail do you want to try reinstall the panel? the database can stay there but the panel reinstallation might prove usefil

granite sail Apr 26, 2024, 8:55 AM

#

i will do anything that cant delete servers, users etc

#

@kind girder

kind girder Apr 26, 2024, 8:55 AM

#

it just reinstallaton of the panel files

#

the database are kept seperate, tho im not sure if it will force to reinstall the database

#

so idk

near shale Apr 26, 2024, 8:57 AM

#

Reinstalling the files will not help.

#

Send laravel logs

kind girder Apr 26, 2024, 9:04 AM

#

oh it usually does for me so

#

and it did for me

#

but yh do that first

granite sail Apr 26, 2024, 5:12 PM

#

near shale Send laravel logs

here

#

https://pteropaste.com/57k8

near shale Apr 26, 2024, 5:13 PM

#

SQLSTATE[HY000] [2002] Connection timed out (SQL: select column_name as `column_name` from information_schema.columns where table_schema = controlpanel and table_name = useful_links) ```
Check your database connection. This problem is not related to cpgg.

granite sail Apr 26, 2024, 5:15 PM

#

i changed IP of the server

#

is it bad?

granite sail Apr 26, 2024, 5:15 PM

#

near shale ``` SQLSTATE[HY000] [2002] Connection timed out (SQL: select column_name as `col...

how

near shale Apr 26, 2024, 5:16 PM

#

granite sail how

Use Google, ChatGPT or contact mariadb support.

granite sail Apr 26, 2024, 5:16 PM

#

what if i reinstall database?

near shale Apr 26, 2024, 5:17 PM

#

granite sail is it bad?

Idk, I'm not your system administrator, and I don't know if you did everything right.

near shale Apr 26, 2024, 5:17 PM

#

granite sail what if i reinstall database?

¯_(ツ)_/¯

#

This error indicates that your database connection timed out while trying to execute the SQL query. Here are a few steps you can take to troubleshoot and fix this issue:

Check Database Connection Settings: Ensure that your database connection settings in your application configuration are correct. Double-check the host, port, username, password, and database name.
Verify Database Availability: Make sure that your database server is up and running and can accept connections from your application. You can try connecting to the database using a database client or command-line tool.
Check Firewall and Network Settings: Ensure that there are no firewall rules or network configurations blocking the connection between your application server and the database server. Check if the port used for database connections is open and accessible.
Increase Connection Timeout: If the connection timeout is too short, consider increasing it in your database configuration or application settings. This can help prevent timeouts during long-running queries or periods of high traffic.
Optimize SQL Queries: If the issue persists, optimize your SQL queries to reduce the time it takes to execute them. This can include adding indexes to columns used in WHERE clauses, optimizing JOINs, and reducing the amount of data fetched.
Check Server Logs: Look into the server logs for both your application and database server to see if there are any error messages or warnings that can provide more insight into the cause of the timeout.

By following these steps and identifying the root cause of the timeout, you should be able to resolve the SQLSTATE[HY000] [2002] Connection timed out error.

granite sail Apr 26, 2024, 5:39 PM

#

how i can change ip in database ubuntu

near shale Apr 26, 2024, 5:40 PM

#

We are not mariadb support.

granite sail Apr 26, 2024, 9:50 PM

#

near shale We are not mariadb support.

Hey, can u help me with this?

#

#

When i want create server then it show this

near shale Apr 26, 2024, 9:51 PM

#

Wings is not running

granite sail Apr 26, 2024, 9:51 PM

#

bright geyserBOT Apr 26, 2024, 9:51 PM

#

Can you please fetch the error logs, so we can assist you better regarding this error.
tail -n 100 /var/www/controlpanel/storage/logs/laravel.log | nc pteropaste.com 99

granite sail Apr 26, 2024, 9:52 PM

#

near shale Apr 26, 2024, 9:52 PM

#

granite sail

Contact ptero support

granite sail Apr 27, 2024, 5:03 PM

#

near shale Contact ptero support

Done

#

Hello, why when someone create server then it add port 25565 on IP 92.118.207.48 and not 185.172.175.25 with port what is on the node?

near shale Apr 27, 2024, 5:05 PM

#

cpgg uses the ports that you have created in the node settings in pterodactyl

#

So this is due to the fact that you have specified the wrong ip for allocations in pterodactyl

granite sail Apr 27, 2024, 5:06 PM

#

I have set good port with good IP

#504 error