[BUG] accounts can't login

[RafaelRBizachi]

some accounts are no longer able to log in after restarting the server, it takes a while to load on the character selection screen and then it displays request time out and even updating the version or restarting the server again the problem continues and players have to create another account

[RafaelRBizachi]

this is an account that had 2 characters and after the error none appear, and if you try to create a new one, the error appears again

[insthync]

Did you use any addons

[RafaelRBizachi]

no, I'm using the default login system

[insthync]

No I saw it can login, but seems like it is having problems with your character data, so I asked because I want to know that did you use any addons for character data?

[RafaelRBizachi]

no, i'm not using any addon all i have is the kit itself, the only things i have outside the mmorpg kit are 3d models and an AI system for some NPCs to walk but all this is done by the client and it always worked normally and i didn't do any change in character data too

[RafaelRBizachi]

This only happens with some accounts and it's usually after I restart the server.

[insthync]

I want to see all server logging messages.

[RafaelRBizachi]

sorry for the delay, in my country it was already late at night. Which of these log files do I need to send?

[insthync]

All

[RafaelRBizachi]

ok, I'll send you a folder with all the logs because it's a little big, just a minute

[RafaelRBizachi]

Is there a website you prefer that I upload the log folder to? for some reason the log folder exceeded 3gb, or if you prefer, I can use anydesk for you to take a look, I already have the server with filezilla and the database open on the pc

[insthync]

Try send only files with its name contians "Database"

[RafaelRBizachi]

I uploaded it to google drive because one of the files exceeded 70mb https://drive.google.com/drive/folders/13N8tB8773MaU9a_NLAXZ14HCF2i5IfNa?usp=sharing

[RafaelRBizachi]

another problem that may have something to do with this is that after an average of 2 days with the server on, it starts to cause lag and disk usage goes to 1.2gb 100% usage and only resolves by restarting and using nohup again, and sometimes after restarting some account it stops working.

[insthync]

Which version are you using?, I found the duplicating summonbuffs's ID in the log file, but this one was fixed.

Another problem is MySQL password, as I saw the error message "Authentication method 'caching_sha2_password'"

[insthync]

You may try change mysql connection string codes in MySqlDatabase.cs -> function GetConnectionString()

        public string GetConnectionString()
        {
            string connectionString = "Server=" + address + ";" +
                "Port=" + port + ";" +
                "Uid=" + username + ";" +
                (string.IsNullOrEmpty(password) ? "" : "Pwd=\"" + password + "\";") +
                "Database=" + dbName + ";" +
                "SSL Mode=Required;AllowPublicKeyRetrieval=true;";
            return connectionString;
        }

Then rebuild/upload server files More detail: https://mysqlconnector.net/troubleshooting/retrieval-public-key/

[RafaelRBizachi]

from Unity is version 2020.3.31f1 and from kit was using version 1.80d until last week, and from this week version 1.81h but the error continues. I also never deleted the log folder since the beginning of the server. The authentication method is using the Admin user and the digital ocean password, because with the root user it was causing authentication problems. I will try to change these lines of code that you presented above to test

[insthync]

Then you should try delete all data from summonbuffs table, it will remove all buffs that applied to monsters, so you may not worry about it, you can delete log files then try again so you will be able to find an error easily.

[RafaelRBizachi]

I tried changing the code line, deleted the SummonBuffs and did the server rebuild but the locked accounts are still unable to recover character information :(

[RafaelRBizachi]

[RafaelRBizachi]

https://drive.google.com/drive/folders/1BkUmPO7lXFGlDkEg89yURiutFE-Kbfe-?usp=sharing link with new log errors

[RafaelRBizachi]

[insthync]

Send me your AnyDesk address to my email: ittipon.bay@gmail.com, I will check it.

[RafaelRBizachi]

ok just a minute I'm changing the version of the kit and I'll send you the anydesk IP

[RafaelRBizachi]

I already sent the anydesk ip, the server and the digital ocean are open, feel free

[RafaelRBizachi]

I sent one of the accounts that are locked for you to test

[RafaelRBizachi]

Thanks for the support