Jimdobbswow

Yeah part of the issue here is, for CentOS7, it's running an older server, but then the DB is up to date. I'm "piece mailing" through the database, trying to get it to the point of whatever the older server wants. I already had Cent on the box and it's been running several services for about 8 months, so didn't feel like wiping it out lol. I should have used Debian or Ubuntu but, ohwell. Yeah, I have gone through bringing in the installer scripts. One bailed because it shouldn't find anything in Rel21 or Rel22, which meant unzipping them all and putting them back in. Then it complained that it couldn't find maps, vmaps etc, but they were in bin instead of etc. So, right now, it's barking about the language packs not being installed. (This being the mangos server) The realm server appears to be past the point of updates, it now wants the tables configured for realm, etc. I'll get that setup today. Its just that good old trying to match the db to the server thing... which is why I was hoping there was a more updated installer that would support centos. I'm happy to do everything manually, but wasn't sure if these distro's would work on cent or not. Thanks for the help!

Hey All, First, I've installed a few Mangos servers over the years, but all on Windows. I'm running a BMS out of a Data Center Now that's running CentOS7. I followed this guide line by line: But I'm stuck on the database. The script is supposed to handle all that, but it could be that I'm running something slightly newer and not sure what the next step is. If I try to fire up realmd as a service I see: ● realmd.service - Realmd service Loaded: loaded (/etc/systemd/system/realmd.service; disabled; vendor preset: disabled) Active: failed (Result: exit-code) since Tue 2021-08-03 14:28:04 PDT; 14s ago Process: 3078 ExecStart=/home/mangos/two/bin/realmd -c /home/mangos/two/etc/realmd.conf (code=exited, status=1/FAILURE) Main PID: 3078 (code=exited, status=1/FAILURE) If I try to start realmd directly I see: Using configuration file ../etc/realmd.conf. Login Database total connections: 2 MySQL client library: 5.5.68-MariaDB MySQL server ver: 5.5.68-MariaDB MySQL client library: 5.5.68-MariaDB MySQL server ver: 5.5.68-MariaDB SQL: SELECT `version`, `structure`, `content`, `description` FROM `db_version` ORDER BY `version` DESC, `structure` DESC, `content` DESC LIMIT 1 query ERROR: Table 'two_realm.db_version' doesn't exist The table `db_version` in your [Realmd] database is missing or corrupt. [A] You have database Version: MaNGOS can not verify your database version or its existence! [B] The core needs database Version: 22 Structure: 1 Content: 1 Description: Release 22 Please verify your database location or your database integrity. Looking at MariaDB I can see that it created two_characters |two_realm |two_world I then did a show full tables from two_realm, and it's empty. So the script created the databases, but never populated them with anything. I grabbed the two db off github https://github.com/mangostwo/server/releases/tag/v22.01.63 and went ahead and let it create the realmd db (vs two_realm) but then I tried mysql -u root -p realmd < realmdLoadDB.sql And I get this error: ERROR 1293 (HY000) at line 52: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause This seems to be an issue with the realm sql dump file for loading the db. Characters worked fine. So how do I fix this for realm? I did of course try installdatabases.sh first... and that gives errors too which: no mariadb in (/sbin:/bin:/usr/sbin:/usr/bin) MySQL found. What is your MySQL host name ? [localhost]: What is your MySQL user name ? [mangos]: What is your MySQL port ? [3306]: ./InstallDatabases.sh: line 393: mysql_config_editor: command not found What is your Character database name ? [character2]: Applying update World/Updates/Rel21/*.sql ./InstallDatabases.sh: line 201: World/Updates/Rel21/*.sql: No such file or directory File World/Updates/Rel21/*.sql imported Applying update World/Updates/Rel22/*.sql ./InstallDatabases.sh: line 208: World/Updates/Rel22/*.sql: No such file or directory So, I'm totally stuck on what's going on here.If ya have any ideas, I am all ears! lol. Thanks again!