mangos zero Installdatabases.bat stuck on loading character database

[hggeren]

I recently tried to install the precompiled version of mangos zero with playerbots x64 that was posted here. I'm running windows 7 with all dependencies installed on a virtual machine. When I try to install the databases using the provided batch file (installdatabases.bat) it gets stuck on "Loading character database". I've now waited an hour and nothing has happened. I've connected to the database and checked it, no new tables have been added in the last hour. It generated the world db without problems. How do I fix this?

[madmax]

Hey,

Have you tried loading the .sql files manually? 

Should be located in DataBase\Character\Setup

[hggeren]

I don't mind trying, but I'm not entirely sure how to do that with the world db. Do I have to individually run all scripts inside the fullDB folder in addition to the loaddb.sql file? Which order do I need to run them in?

[madmax]

Hey,

I thought the issue was with the character db?

You can load mangos_full_db.sql right into a database for the world.

For the characters you can run DataBase\Character\Setup\characterLoadDB.sql on a database to get that loaded.

[hggeren]

Yeah, I suppose world was loaded successfully, so I'll leave it as is and drop/create characters again. I assume I simply run the characterLoaddb, then the updates 19, 20 and 21 in that order?

[madmax]

If you look in the database at the db_version table you can see which version it is, you just need the ones after.

[hggeren]

Fair enough, seems like the characterloaddb applies the updates as well. It says 21. Guess I won't run them, then.

[madmax]

hey,

Should be 21  - 5 - 3

You will know if anything is missing or oudated as the core will check when loading and tell you.

[hggeren]

Managed to fix the DB now. Had to insert data into the db_version table myself to make it work since the update SP wasn't present, so the core kept thinking the DB was outdated. Now I'm stuck at incompatible maps... Seems like the maps I use for the Elysium Core don't work here. I'll extract new maps using the included extractors and let you know how it went. Thanks for the help so far, though!

[madmax]

Just now, hggeren said:

Thanks for the help so far, though!

No problem, if you get issues and really stuck i do offer support over teamviewer, but see how you get on

[hggeren]

Seems like I've run into yet another DB problem... Do you know what this error message is all about? 

[madmax]

Sounds like the world database did not load correctly. No idea on that error.

[hggeren]

Fair enough, I'll drop the whole database and redo it, then. Any way to run multiple sql scripts in mysql workbench?

[madmax]

The mangos_full_db.sql contains all the world .sql files. You can also run make_full_WorldDB.sh to remake this file.

The only scripts you should be running would be updates you might be missing. Going to be heading off for the night, good luck

[hggeren]

Good night and thanks once again for the help!

 

Managed to get the core working now. Logged in and created a few test characters. Then I enabled playerbot. Now the core just keeps creating a bunch of level 1 bots indefinitely and I'm not even able to log in anymore. Says the server is down. Is this intended behavior?

[hggeren]

I'm hoping this is just some sort of first-time setup. I'll leave it on overnight and check back on it tomorrow. Good night!

[Tuker]

Looking at the aiplayerbot.conf you can find:

#AiPlayerbot.RandomBotAccountCount = 50

so at startup he setup any Character for the Account amount. For example 50 Account with an amount from Max to Min bot Amount.

#AiPlayerbot.MinRandomBots = 50
#AiPlayerbot.MaxRandomBots = 200

Server is down because it's not running before Characters are set up. 

[hggeren]

Seems like it's up and running now, but there are a lot of level 1 bots that are just standing still, doing nothing where you spawn when you log in for the first time. Is this normal? Those two entries in the conf file, yeah. Do I have to uncomment (remove the #) for them to work? Thanks in advance

[Tuker]

Not sure but, the details you found on comment are like Default data.

So when mangosd.exe starts, if aiplayerbot.conf exist he knows that Bot Players must be generated, then he try to read configuration, and if can't find custom configuration he start with default.

If you need different values from Defaults just uncomment and set values that you need.

[hggeren]

Ok, I'll try that, thanks. I'm also having issues with a friend not being able to connect to my server from a different network. I've forwarded ports 8085 and 3724 and turned firewall off completely on my server. My friend cannot connect to my server, but gets through authentication. He is stuck on realm selection. This same setup works flawlessly with the elysium core. Anything different about mangos zero?

[Tuker]

I think that could be related with realmlist table entry on your realmd database. In the 'address' field you should put the external address of computer where mangosd run.

[hggeren]

Yeah, I've forwarded those two ports to my ipv4 address on the server, which is the same as the one listed in realmlist in the realmd db.

[hggeren]

I turned playerbots off to remove the spam from my server window. It seems like the mangosd never receives any packets for some reason. He can connect to realmd.exe, but not mangoszero.exe for some reason. Anyone got this up and running for WAN use?

[Tuker]

What's the value in mangosd.exe.conf for the field "BindIP"? It should be yuor external ipaddress if you want to manage external players to connect.

[hggeren]

That didn't seem to help either, unfortunately

I really don't understand this, it works fine with the elysium core...

[Talendrys]

I got this running but it was before the add of the external/internal ip address in the DB.

I used 2 realms records, one for internal use, one for external use.

Tal'.