Issue with database mismatch structure

[KillRIde]

Hi guys,

I'm new here and I tried to run my first server.

Here is the issue I have.

The table `db_version` indicates that your [Character] database does not match the expected structure!

  [A] You have database Version: 22
                      Structure: 2
                        Content: 1
                    Description: Add_field_comments

  [B] The core needs database Version: 22
                            Structure: 4
                              Content: 1
                          Description: Add_Quest_Tracker_Table

You must apply all updates after [A] to [B] to use MaNGOS with this database.
These updates are included in the database/Character/Updates folder.
 

Thanks for the help

[Fyre]

1 hour ago, KillRIde said:

Hi guys,

I'm new here and I tried to run my first server.

Here is the issue I have.

The table `db_version` indicates that your [Character] database does not match the expected structure!

  [A] You have database Version: 22
                      Structure: 2
                        Content: 1
                    Description: Add_field_comments

  [B] The core needs database Version: 22
                            Structure: 4
                              Content: 1
                          Description: Add_Quest_Tracker_Table

You must apply all updates after [A] to [B] to use MaNGOS with this database.
These updates are included in the database/Character/Updates folder.
 

Thanks for the help

Hey!

This is saying that you need to update your databases.
When you do the initial setup/install of the databases, it does not always include the latest updates that have been created.
If you use the InstallDatabases.bat (Windows) or InstallDatabases.sh (Linux), you will see an option "N" that can be used to do database updates.

If you would prefer to manual updates, then you can find them in the "Characters" folder, "Updates", "Rel22" and you'll find all of the ones that you need to update.

Hope that helps!

[KillRIde]

 

Ok I did this step again. but still have the same issue after it.

 

I'm following this guide 

Do you have some commands that I should check?

 

thanks

 

 

 

[KillRIde]

Actually I can log into the game but the server is offline.

[Fyre]

4 minutes ago, KillRIde said:

Actually I can log into the game but the server is offline.

Alright - so then that means that you have properly updated database if it proceeded.
If you can login, but get stuck at "Connected". that likely means that you built the mangosd with OpenSSL 3.0 instead of 1.1.

 

We just had another member with similar issues yesterday.
Take a look at: 

Meltie walks through how to change to OpenSSL 1.1, and then there are some comments below for how to upgrade gcc IF necessary.

[KillRIde]

I can log into the game but the realm is offline

[KillRIde]

And I still have this

 

I also checked to manually update it but I have re121 and 122 not 22

 

[KillRIde]

I guess I'm close to the issue.

 

How can I apply this?

[Fyre]

2 minutes ago, KillRIde said:

And I still have this

 

I also checked to manually update it but I have re121 and 122 not 22

 

That is an L, not a 1.

So you do have Rel22.

But in the first picture it is showing your CHARACTER database as out of date, you're in your world database folder.

When you go into the Updates/Rel22 folder, you can merge the SQL files to one and then run a command to manually import into your database.

cat *.sql > updateall.sql

mariadb -d character0 < updateall.sql

You may need to change the character0 to whatever you called your database.

I'm also doing this from memory on my phone, so there may be syntax errors or missing parameters.

[Fyre]

1 minute ago, KillRIde said:

I guess I'm close to the issue.

 

How can I apply this?

Yeah you're close but you have to do them in order, you can't just apply the latest one.

See my solution above about merging them into one file, then you can apply that at once.

[KillRIde]

[Fyre]

Did you pull the database from GitHub? Or from the getmangos website?

[KillRIde]

from github 

git clone https://github.com/mangoszero/database.git --recursive

[KillRIde]

[KillRIde]

Ok I've got some good news. It works now after deleted and reinstall the database.

wmonitor shows me a lot of info

 

But when I connect using "player" account, I'm directly disconnected and wmonitor stops.

Then I can reconnect but I have a loop on the realmlist. I select my realm and it disconnect and come back to the realmlist

I can add that mangos crash but realm is still running. I don't know where to find logs about this.

Edited August 13, 2023 by KillRIde

[Fyre]

4 hours ago, KillRIde said:

Ok I've got some good news. It works now after deleted and reinstall the database.

wmonitor shows me a lot of info

 

But when I connect using "player" account, I'm directly disconnected and wmonitor stops.

Then I can reconnect but I have a loop on the realmlist. I select my realm and it disconnect and come back to the realmlist

I can add that mangos crash but realm is still running. I don't know where to find logs about this.

Glad that it has progressed!

Are you setting up a locally hosted server or public facing?

If public facing, double check your realmlist table entry in the realmd/auth database to ensure that you've correctly assigned the address. Sometimes users (especially those using heidisql as a GUI) week edit the default value instead of the data value.

[KillRIde]

I've put 172.22.22.86 in localAddress too but no success.

Mangosd crash when I log into the game but I have no logs of the crash

Edited August 14, 2023 by KillRIde

[Meltie]

11 hours ago, KillRIde said:

I've put 172.22.22.86 in localAddress too but no success.

Mangosd crash when I log into the game but I have no logs of the crash

Which version of OpenSSL are you using currently on your machine? OpenSSL 3.x will cause login issues do to it not being supported yet.

[KillRIde]

I have openssl 3.0.2

Which one I need and how to downgrade it please?

[Meltie]

@KillRIde
First off you'll have to remove the initial install of OpenSSL by using this command.

sudo apt remove openssl libssl-dev

Then download these packages from Ubuntu repository archive and install the packages.

# Download OpenSSL 1.1.1f packages
wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/openssl_1.1.1f-1ubuntu2.19_amd64.deb
wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl-dev_1.1.1f-1ubuntu2.19_amd64.deb
wget http://archive.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.1f-1ubuntu2.19_amd64.deb

# Install required packages
sudo dpkg -i libssl1.1_1.1.1f-1ubuntu2.19_amd64.deb
sudo dpkg -i openssl_1.1.1f-1ubuntu2.19_amd64.deb
sudo dpkg -i libssl-dev_1.1.1f-1ubuntu2.19_amd64.deb

To ensure when updates are available for install, to hold back the new version of OpenSSL 3.x libraries with these commands.

sudo apt-mark hold openssl
sudo apt-mark hold libssl-dev

 

[KillRIde]

ok done,

 

Now I need to reinstall everything? or not

[Meltie]

You'll need to recompile your source, then you should be ready to go.

[KillRIde]

I'm now trying to redownload the database and reinstall it but I have this when using git clone

Cloning into 'database'...
fatal: unable to access 'https://github.com/mangoszero/database.git/': server certificate verification failed. CAfile: none CRLfile: none
 

Probably linked to the switch of OpenSSL version

[Meltie]

@KillRIde I am still able to download the database repository just fine with OpenSSL 1.1.1f. Double check to make sure your host is connected to the internet.
Sometimes the connection to GitHub server can be a problem at times.