Unable to connect MySQL Database

[Glucy-2]

Question

Unable to connect MySQL Database
plan ver: 5.4 build 1628 (velocity & fabric)

Additional context

log(fabric):

[01:50:32] [Plan Reload Thread/INFO]: [Plan] Processing complete.
[01:50:32] [Plan Reload Thread/INFO]: [Plan] Player Analytics Disabled.
[01:50:32] [Plan Reload Thread/INFO]: [Plan] 
[01:50:32] [Plan Reload Thread/INFO]: [Plan]            ██▌
[01:50:32] [Plan Reload Thread/INFO]: [Plan]      ██▌   ██▌
[01:50:32] [Plan Reload Thread/INFO]: [Plan]   ██▌██▌██▌██▌  Player Analytics
[01:50:32] [Plan Reload Thread/INFO]: [Plan]   ██▌██▌██▌██▌  v5.4 build 1628
[01:50:32] [Plan Reload Thread/INFO]: [Plan] 
[01:50:32] [Plan Reload Thread/INFO]: [Plan] Locale: 'English' by AuroraLS3
[01:50:32] [Plan Reload Thread/INFO]: [Plan] Downloading MySQL Driver, this may take a while...
[01:50:33] [Plan Reload Thread/ERROR]: [Plan] ----------------------------------------
[01:50:33] [Plan Reload Thread/ERROR]: [Plan] Error: MySQL init failure: Failed to initialize pool: Could not create connection to database server.
[01:50:33] [Plan Reload Thread/ERROR]: [Plan] ----------------------------------------
[01:50:33] [Plan Reload Thread/ERROR]: [Plan] Plugin failed to initialize correctly. If this issue is caused by config settings you can use /plan reload
[01:50:33] [Plan Reload Thread/INFO]: [Plan] Processing complete.
[01:50:33] [Plan Reload Thread/INFO]: [Plan] Waiting for unfinished transactions to avoid data loss..
[01:50:33] [Plan Reload Thread/INFO]: [Plan] Transaction queue closed.
[01:50:33] [Plan Reload Thread/INFO]: [Plan] Player Analytics Disabled.

log(velocity):

[02:25:03] [Plan Reload Thread/INFO]: Processing complete.
[02:25:03] [Plan Reload Thread/INFO]: Player Analytics Disabled.
[02:25:03] [Plan Reload Thread/INFO]: 
[02:25:03] [Plan Reload Thread/INFO]:            ██▌
[02:25:03] [Plan Reload Thread/INFO]:      ██▌   ██▌
[02:25:03] [Plan Reload Thread/INFO]:   ██▌██▌██▌██▌  Player Analytics
[02:25:03] [Plan Reload Thread/INFO]:   ██▌██▌██▌██▌  v5.4 build 1628
[02:25:03] [Plan Reload Thread/INFO]: 
[02:25:03] [Plan Reload Thread/INFO]: Locale: 'English' by AuroraLS3
[02:25:03] [Plan Reload Thread/INFO]: Downloading MySQL Driver, this may take a while...
[02:25:04] [Plan Reload Thread/ERROR]: ----------------------------------------
[02:25:04] [Plan Reload Thread/ERROR]: Error: MySQL init failure: Failed to initialize pool: Could not create connection to database server.
[02:25:04] [Plan Reload Thread/ERROR]: ----------------------------------------
[02:25:04] [Plan Reload Thread/ERROR]: Plugin Failed to Initialize Correctly. If this issue is caused by config settings you can use /planvelocity reload
[02:25:04] [Plan Reload Thread/INFO]: Processing complete.
[02:25:04] [Plan Reload Thread/INFO]: Waiting for unfinished transactions to avoid data loss..
[02:25:04] [Plan Reload Thread/INFO]: Transaction queue closed.
[02:25:04] [Plan Reload Thread/INFO]: Player Analytics Disabled.

plugin mysql config:

Database:
    MySQL:
        Host: q**************************************.mysql.*********.com
        Port: 3306
        User: Plan
        Password: ***********************6+**************basdf
        Database: plan
        # Launch options to append after mysql driver address
        Launch_options: "?rewriteBatchedStatements=true&useSSL=true&serverTimezone=UTC+8"
        Max_connections: 8

[AuroraLS3]

Did you create a database called plan?

[Glucy-2]

yes and i can connect it on my pc

[AuroraLS3]

Does the /plugins/Plan/libraries folder have the MySQL driver jar inside it or did it fail to download for some reason? 🤔

[Glucy-2]

yes there is

[AuroraLS3]

It could be the +8 in the Launch_options - you don't need to change the server time zone there (Plan expects UTC for the connection)

[Glucy-2]

there would be more errors if i delete +8

[Glucy-2]

the db was there before, I updated the plugin (1583->1628) then it cannot connect the db

[AuroraLS3]

Ah yep it was the +8 - The errors happen because there is a missing row in the database and schema update patches are failing.

I'll send you some SQL to find and correct the incorrect data

[AuroraLS3]

SELECT u.uuid, g.uuid FROM temp_geoinformation g 
LEFT JOIN plan_users u on u.uuid=g.uuid
WHERE u.uuid IS NULL;

Then run this with the UUIDs that the first query returns

INSERT into plan_users (uuid, registered, name, times_kicked) VALUES ('uuid here', 1650023218067, 'delete_me_later', 0);

After that /plan reload and things should work (Unless there are more missing rows - in that case, please send the new errors)

[Glucy-2]

Sorry i don't know much about sql, i don't know what is means
on heidisql:

on mysql:

[AuroraLS3]

Paste the first into the thing you have open I. HeidiSQL and press the blue play button

Then copy the results that show up

Then put the 2nd query in the box, and replace uuid here with one result you copied. Then press the blue play button. Repeat if necessary

Then reload Plan

[AuroraLS3]

I'll write some code to fix databases in this state automatically since this seems to be more common than I thought.

[AuroraLS3]

Please update to https://github.com/plan-player-analytics/Plan/releases/tag/5.4.1633 to have your issue fixed automatically