#ptero panel not working
1 messages · Page 1 of 1 (latest)
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.1orlocalhostand you're trying to connect from outside the server? - Does the user have
GRANTpermissions if you're trying to use them to create a new database for a server? - Have special characters in your password? Make sure
DB_PASSWORDin your.envfile 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
It is recommended that you have some sort of Linux and MariaDB experience before installing this.
× mariadb.service - MariaDB 11.2.2 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Thu 2024-01-04 21:06:36 UTC; 1min 16s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3291 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3292 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3294 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery; [ $? -eq 0 ] && >
Process: 3323 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 3323 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
CPU: 147ms
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic er>
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [Note] InnoDB: Starting shutdown...
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [Note] Plugin 'FEEDBACK' is disabled.
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [Note] Plugin 'wsrep-provider' is disabled.
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 mariadbd[3323]: 2024-01-04 21:06:36 0 [ERROR] Aborting
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jan 04 21:06:36 ubuntu-s-1vcpu-512mb-10gb-nyc1-01 systemd[1]: Failed to start MariaDB 11.2.2 database server.
How systemd is configured on MariaDB packages and how to alter its configuration.