Having issues with MySQL databases in Pterodactyl.

I bought a dedicated server from PebbleHost and I'm making databases to connect my plugins to however none of the plugins will connect despite trying all different combinations of hosts and such. I'm almost certain everything is right.

I was checking the database.php in Pterodactyl and saw this

 /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Here are each of the database connections setup for your application.
    | Of course, examples of configuring each database platform that is
    | supported by Laravel is shown below to make development simple.
    |
    |
    | All database work in Laravel is done through the PHP PDO facilities
    | so make sure you have the driver for your particular database of
    | choice installed on your machine before you begin development.
    |
    */

    'connections' => [
        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'panel'),
            'username' => env('DB_USERNAME', 'pterodactyl'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => env('DB_PREFIX', ''),
            'prefix_indexes' => true,
            'strict' => env('DB_STRICT_MODE', false),
            'timezone' => env('DB_TIMEZONE', Time::getMySQLTimezoneOffset(env('APP_TIMEZONE', 'UTC'))),
            'sslmode' => env('DB_SSLMODE', 'prefer'),
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                PDO::MYSQL_ATTR_SSL_CERT => env('MYSQL_ATTR_SSL_CERT'),
                PDO::MYSQL_ATTR_SSL_KEY => env('MYSQL_ATTR_SSL_KEY'),
                PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => env('MYSQL_ATTR_SSL_VERIFY_SERVER_CERT', true),
            ]) : [],
        ],
    ],

 /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Here are each of the database connections setup for your application.
    | Of course, examples of configuring each database platform that is
    | supported by Laravel is shown below to make development simple.
    |
    |
    | All database work in Laravel is done through the PHP PDO facilities
    | so make sure you have the driver for your particular database of
    | choice installed on your machine before you begin development.
    |
    */

    'connections' => [
        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'panel'),
            'username' => env('DB_USERNAME', 'pterodactyl'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => env('DB_PREFIX', ''),
            'prefix_indexes' => true,
            'strict' => env('DB_STRICT_MODE', false),
            'timezone' => env('DB_TIMEZONE', Time::getMySQLTimezoneOffset(env('APP_TIMEZONE', 'UTC'))),
            'sslmode' => env('DB_SSLMODE', 'prefer'),
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
                PDO::MYSQL_ATTR_SSL_CERT => env('MYSQL_ATTR_SSL_CERT'),
                PDO::MYSQL_ATTR_SSL_KEY => env('MYSQL_ATTR_SSL_KEY'),
                PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => env('MYSQL_ATTR_SSL_VERIFY_SERVER_CERT', true),
            ]) : [],
        ],
    ],

Should this not be filled in?

Admincraft Meta•8/3/24, 5:32 PM

Thanks for asking your question!

Make sure to provide as much helpful information as possible such as logs/what you tried and what your exact issue is

Make sure to mark solved when issue is solved!!!

/close
!close
!solved
!answered

Requested by nunyabizbro#0

•

8/3/24, 5:31 PM

Torrent•8/3/24, 5:42 PM

Did you follow this guide?

TTorrent Did you follow this [guide](https://pterodactyl.io/tutorials/mysql_setup.html)?

DrewITOP•8/3/24, 5:49 PM

I did not, it's a pre-installed OS image from PebbleHost

DDrewIT I bought a dedicated server from PebbleHost and I'm making databases to connect ...

SilentBot•8/3/24, 6:01 PM

No, pulls from environment variables, which can typically be found in the file

SilentBot•8/3/24, 6:03 PM

You shouldn't also be using these credentials for plugins / apps either, you should be using the panel to create a new database from the admin side of things, e.g.

SilentBot•8/3/24, 6:04 PM

You can then go back to the server once it has been created, and access the credentials you should be using by clicking the eye on the right:

SSilentBot You shouldn't also be using these credentials for plugins / apps either, you sho...

DrewITOP•8/3/24, 6:04 PM

Yeah I've been trying those however they're not working.

DrewITOP•8/3/24, 6:05 PM

DrewITOP•8/3/24, 6:05 PM

I've tried allowing all connections, changing passwords etc.

SilentBot•8/3/24, 6:06 PM

So for the top one, you're clicking the eye, copying the IP address/port + username&password it gives you, and you're using this in the plugin?

SilentBot•8/3/24, 6:06 PM

The 2nd one likely won't work, as your game server isn't at 127.0.0.1 due to docker

SSilentBot So for the top one, you're clicking the eye, copying the IP address/port + usern...

DrewITOP•8/3/24, 6:07 PM

Correct. I've also tried putting the host in the plugin file 0.0.0.0, localhost, the actual ip to my server and 127.0.0.1

DrewITOP•8/3/24, 6:07 PM

Let me make a dummy database and try to connect it, I'll show you what happens.

SilentBot•8/3/24, 6:08 PM

And just to sanity check, do those four things you've mentioned include the IP given from when you've clicked the eye? (I assume it's just your external IP, so yes?)

SSilentBot And just to sanity check, do those four things you've mentioned include the IP g...

DrewITOP•8/3/24, 6:08 PM

Correct.

DrewITOP•8/3/24, 6:08 PM

So here are the settings

DrewITOP•8/3/24, 6:08 PM