Jump to content
  • 0

Noobie looking for help

teddybairs1

Asked by teddybairs1,

Question

teddybairs1 Advanced Member

teddybairs1

Posted
Posted

I am running Debian Stretch/Sid. I just got mangoszero-server-master to compile using a script I found online. I've been trying to figure out how to extract the data files from the Warcraft 1.12 folder (also found online) in order to get it to run (as well as direct the configuration files in the right direction). Looking online, there seems to be several references to binaries or scripts for extracting the data and maps from the Warcraft Data folder, but I can't seem to find them in folders created after compilation.

I'm not sure of the mangoszero version, it was just called mangoszero-server online. According to the change-log it is 0.19 (2014-07-09) - Ludas Legacy. I have another version in another tarball which I downloaded from this site as well: MangosZero_Rel20_Release_x32_March2015

The script is just called "mangos-installer".

Should I use the script to compile this one instead? The script is the only way I've been able to get it to compile. I'm not really a coder (I've only learned a little C++ and BASIC, but I'm really rusty in both). I've only been able to get a few things to successfully compile on my own by following good instructions for noobies.

I would really like to get this running. I recently discovered WoW, but I don't like that I have to be online to play it.

I realize I'm just a noob, and these questions are probably very easily answered, but if you could just direct me to those answers I'd appreciate it. Thank you.

Link to comment
Share on other sites
  • Answers 53
  • Created
  • Last Reply

53 answers to this question

Recommended Posts

Ravieh Member

Ravieh

Posted
Posted

Small thingy

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_01_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150412_warden_db_log

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_02_auth_realmlist.sql

Status DB is on Version

* UPDATE FAILED * required_20150412_warden_db_log

mangos@Beryllium:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150420_warden_db_log

second one fails, no biggie as far as I can tell, it works anyway, just thought I'd mention it.

Link to comment
Share on other sites
teddybairs1 Advanced Member

teddybairs1

Posted
  • Author
Posted

So... Did I give the wrong answer? Other than what I said previously, I'm really not sure what you're asking for. I downloaded the version of mangos that you said to clone on page three of this thread. This was the one that I got stuck on in 21000_13. As far as I know, it's release 21. I'm not sure how else to identify which version it is? It's for Linux, if that's what you mean.

Link to comment
Share on other sites
Foereaper Advanced Member

Foereaper

Posted
Posted

Hey, sorry, I was busy working on a revised database system, so I didn't have the chance to get a database set up for you :) What I was wondering was what version your core is expecting when you start it up. It should show you which version of the database you have, and what version your core is expecting.

Here you go, DL link to a world DB fully updated to 21000_13_Backports

https://mega.co.nz/#!A19U2DgQ!n4TWvi1h7JyuLaZ5trKQ4g0N8XGprcSUgfDs4NT6csk

Link to comment
Share on other sites
Foereaper Advanced Member

Foereaper

Posted
Posted

Hey there,

The current development is running on the branch develop21, which is what I'd recommend using for now.

Server files: "git clone https://github.com/mangoszero/server -b develop21 --recursive"

Database files: "git clone https://github.com/mangoszero/database -b develop21 --recursive"

Then follow this guide to compile and set up your server:

https://getmangos.eu/wiki/Installation%20Guides/Linux/Debianinstall.md

Link to comment
Share on other sites
teddybairs1 Advanced Member

teddybairs1

Posted
  • Author
Posted

Okay, I've gotten to point 6. on the Debian Install, Importing the Mysql Database. I've tried entering the command line sequence for number one and it keeps telling me that the database for realmd doesn't exist. "ERROR 1049 (42000): Unknown database 'realmd'"

All I'm doing is copying and pasting the command and changing the home folder to the installation home folder like it said to.

Link to comment
Share on other sites
Ravieh Member

Ravieh

Posted
Posted

Just remembered I had the same.

Try it like this.

mysql -u root -p < /home/mangos/database/Realm/Setup/realmdCreateDB.sql

mysql -u root -p realmd < /home/mangos/database/Realm/Setup/realmdLoadDB.sql

mysql -u root -p < /home/mangos/database/Character/Setup/characterCreateDB.sql

mysql -u root -p characters < /home/mangos/database/Character/Setup/characterLoadDB.sql

mysql -u root -p < /home/mangos/database/World/Setup/mangosdCreateDB.sql

mysql -u root -p mangos < /home/mangos/database/World/Setup/mangosdLoadDB.sql

Link to comment
Share on other sites
teddybairs1 Advanced Member

teddybairs1

Posted
  • Author
Posted

Okay, so here's my output so far. I'd appreciate it if someone can tell me where I've gone wrong.

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Realm/Setup/realmdCreateDB.sql

Enter password:

allen@allen-3541:~$ mysql -u root -p realmd < /home/allen/database/Realm/Setup/realmdLoadDB.sql

Enter password:

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Character/Setup/characterCreateDB.sql

Enter password:

ERROR 1396 (HY000) at line 3: Operation CREATE USER failed for 'mangos'@'localhost'

allen@allen-3541:~$ mysql -u root -p < /home/allen/database/Character/Setup/characterCreateDB.sql

Enter password:

ERROR 1007 (HY000) at line 1: Can't create database 'characters'; database exists

allen@allen-3541:~$ cd database

allen@allen-3541:~/database$ ls

Character InstallDatabases.bat make_full_WorldDB.sh Realm World

icons LICENSE.md README.md Tools

allen@allen-3541:~/database$ cd Tools

allen@allen-3541:~/database/Tools$ ls

backupDB.cmd make_full_db.bat mysql.exe

cleanup make_full_db.sh postgre_compatibility_addon.sql

drop_mysql.sql mangos_spell_check.sql updateRealm.sql

dump_tables.sh mysqldump.exe

allen@allen-3541:~/database/Tools$ mysql -u root -p characters < /home/allen/database/Character/Setup/characterLoadDB.sql

Enter password:

allen@allen-3541:~/database/Tools$ mysql -u root -p < /home/allen/database/World/Setup/mangosdCreateDB.sql

Enter password:

ERROR 1007 (HY000) at line 3: Can't create database 'characters'; database exists

allen@allen-3541:~/database/Tools$ mysql -u root -p mangos < /home/allen/database/World/Setup/mangosdLoadDB.sql

Enter password:

allen@allen-3541:~/database/Tools$ cat /home/mangos/database/World/Update/Rel21/*.sql >> /home/mangos/all.sql

bash: /home/mangos/all.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Update/Rel21/*.sql >> /home/mangos/all.sql

bash: /home/mangos/all.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Update/Rel21/*.sql >> /home/allen/all.sql

cat: /home/allen/database/World/Update/Rel21/*.sql: No such file or directory

allen@allen-3541:~/database/Tools$ cat /home/allen/database/World/Updates/Rel21/*.sql >> /home/allen/all.sql

allen@allen-3541:~/database/Tools$ mysql -u root -p mangos < /home/allen/all.sqlEnter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20007_20_Hotfix_Corrections_to_RegenerateStatsrequired_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_01_Release21_initial required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

ERROR 1054 (42S22) at line 6305: Unknown column 'required_21000_05_Script_refactoring' in 'db_version'

allen@allen-3541:~/database/Tools$ cd ..

allen@allen-3541:~/database$ bash make_full_WorldDB.sh

allen@allen-3541:~/database$ mysql -u root -p mangos < full_db.sql

Enter password:

allen@allen-3541:~/database$ cd ..

allen@allen-3541:~$ cd zero

allen@allen-3541:~/zero$ cd bin

allen@allen-3541:~/zero/bin$ ls

lua_scripts mangosd realmd tools

allen@allen-3541:~/zero/bin$ ./realmd

Could not find configuration file ../etc/realmd.conf.

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

allen@allen-3541:~/zero/bin$ cat /home/allen/database/World/Updates/Rel21/*.sql >> /home/allen/all.sql

allen@allen-3541:~/zero/bin$ cat /home/allen/database/World/Updates/Rel20/*.sql >> /home/allen/all.sql

allen@allen-3541:~/zero/bin$ mysql -u root -p mangos < /home/allen/all.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20007_20_Hotfix_Corrections_to_RegenerateStatsrequired_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_01_Release21_initial required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_02_Waypoint_update required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

Status Required Version Found Version

* UPDATE SKIPPED * required_21000_05_Script_refactoring required_20007_01_Rel20_Release_Prep

ERROR 1054 (42S22) at line 6305: Unknown column 'required_21000_05_Script_refactoring' in 'db_version'

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

Link to comment
Share on other sites
Ravieh Member

Ravieh

Posted
Posted

You are on the exact same point I am now.

If I understand correctly you need to do exactly what it says.

[A] You have: --> `20150409_Playerbot_and_Warden.sql`

You need: --> `20150420_warden_db_log.sql`

In realmd/Updates/Rel21/ you have:

20150409_Playerbot_and_Warden.sql

20150412_01_warden_db_log.sql

20150412_02_auth_realmlist.sql

20150420_03_warden_db_log.sql

so first run: mysql -u root -p realmd < 20150412_01_warden_db_log.sql

after that you would think it needs the next one, but nooo, that gives an error

mysql -u root -p realmd < 20150412_02_auth_realmlist.sql

Status Required Version Found Version

* UPDATE SKIPPED * required_20150412_warden_db_log required_20150412_auth_realmlist

so I guess that already went in with the first one.

next:

mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Status DB is now on Version

* UPDATE COMPLETE * required_20150420_warden_db_log

Now realmd should run

Link to comment
Share on other sites
teddybairs1 Advanced Member

teddybairs1

Posted
  • Author
Posted

Okay, I did this, and got this:

allen@allen-3541:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150412_01_warden_db_log.sql

Enter password:

Status DB is now on Version

* UPDATE COMPLETE * required_20150412_warden_db_log

allen@allen-3541:~/database/Realm/Updates/Rel21$ cd ..

allen@allen-3541:~/database/Realm/Updates$ cd /home/allen/zero/bin

allen@allen-3541:~/zero/bin$ ls

lua_scripts mangosd realmd realm-list.log tools

allen@allen-3541:~/zero/bin$ ./realmd

21000 [realm-daemon]

<Ctrl-C> to stop.

Using configuration file ../etc/realmd.conf.

Login Database total connections: 2

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

MySQL client library: 5.5.43

MySQL server ver: 5.5.42-1

SQL: SELECT required_20150420_warden_db_log FROM realmd_db_version LIMIT 1

query ERROR: Unknown column 'required_20150420_warden_db_log' in 'field list'

The table `realmd_db_version` in your [REALMD] database indicates that this database is out of date!

[A] You have: --> `20150412_warden_db_log.sql`

You need: --> `20150420_warden_db_log.sql`

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

allen@allen-3541:~/zero/bin$ cd /home/allen/database/Realm/Updates/Rel21

allen@allen-3541:~/database/Realm/Updates/Rel21$ ls

20150409_Playerbot_and_Warden.sql 20150412_02_auth_realmlist.sql

20150412_01_warden_db_log.sql 20150420_03_warden_db_log.sql

allen@allen-3541:~/database/Realm/Updates/Rel21$ mysql -u root -p realmd < 20150420_03_warden_db_log.sql

Enter password:

Status Required Version Found Version

* UPDATE SKIPPED * required_20150412_auth_realmlist required_20150412_warden_db_log

allen@allen-3541:~/database/Realm/Updates/Rel21$

I appreciate the time you're taking here, btw.

Link to comment
Share on other sites
teddybairs1 Advanced Member

teddybairs1

Posted
  • Author
Posted

Okay, realmd is working, now this is the output I'm getting from mangosd

allen@allen-3541:~$ ./mangosd

bash: ./mangosd: No such file or directory

allen@allen-3541:~$ cd /home/allen/zero/bin

allen@allen-3541:~/zero/bin$ ./mangosd

21000 [world-daemon]

<Ctrl-C> to stop.

__ __ _ _ ___ ___ ___

| \/ |__ _| \| |/ __|/ _ \/ __| We Love

| |\/| / _` | .` | (_ | (_) \__ \ Vanilla Wow

|_| |_\__,_|_|\_|\___|\___/|___/

____

For help and support please visit: /_ /___ _ _ ___

Website: https://getmangos.eu / // -_) '_/ _ \

Wiki: MaNGOS Wiki · GitHub /___\___|_| \___/

Using configuration file ../etc/mangosd.conf.

OpenSSL 1.0.2a 19 Mar 2015 (Library: OpenSSL 1.0.2a 19 Mar 2015)

Using ACE: 6.3.0

World Database total connections: 2

Could not connect to MySQL database at 127.0.0.1: Access denied for user 'mangos'@'localhost' to database 'mangos'

Can not connect to world database 127.0.0.1;3306;mangos;mangos;mangos

allen@allen-3541:~/zero/bin$

Link to comment
Share on other sites
Ravieh Member

Ravieh

Posted
Posted

I can't help you any further right now because I';m still stuck at updating the mangos db... (last time I did it it went more smooth lol, that's the fun with dev versions I guess)

[A] You have: --> `20007_01_Rel20_Release_Prep.sql`

You need: --> `21000_13_Backports.sql`

Hope a dev can chime in.

Rutger

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to question listing

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use