New mangostwo server finalization

[Lithiria]

Hey all! Ok, I decided to make a new server, but a ton of things have changed. I have a few questions:

question 1 - from the mangoszero wiki (for 18.1 build) the database is built by running mangosdb_installer.bat. I did that and tested the world and it works! However, I have an SD2Errors log file

that says "unable to open configuration file" "configuration file doesnt match expected version" and on and on. I didn't load scriptdev sql files because I thought they were incorporated into the

mangosdb_installer.bat installation. >>Do I still need to create a scriptdev2 sql table and import scriptdev2_script_full.sql?

question 2a - is ACID incorporated into the current mangos database?

question 2b - Does it matter if I script ACID into my tables or will the game work without it?

question 3 - regarding updates, I see many files from the git that are in the server\sql\update folder. However, when running the mangosdb_installer.bat, none of the sql files in the _full_db folder

are numbered. I can't figure out which sql updates in the update folder to run. I tried running the earliest update, but it said the table hadn't been updated with the previous update. This leads me

to believe the tables aren't numbered anymore once they are incorporated into the _full_db files. Do I need to run any of the updates at all? If so, which ones?

question 4 - As you read in my question 1, I haven't even created a scriptdev2 table, so I don't believe I have incorporated scriptev2 into my server. If I do need to do that, then there are updates

in an update folder for scriptdev2 as well. Just like I was asking in question 3, which scriptdev2 updates do I run?

question 5 - still regarding updates, the mangoszero wiki (for 18.1 build) says that after I run the mangosdb_installer.bat, I need to go to the "_develop" folder and run the corepatch update. My

problem is that the example in the wiki shows the corepatch update as 201_corepatch_mangos, but the files in my folder are 101_corepatch_mangos. I've never seen a corepatch version be earlier

than the wiki, because usually the numbers get higher as the wiki gets older. I did not run the 101_corepatch file I have and the game still works. Do I need to figure out how to run this file?

I really love learning this stuff, so I thank you for your help! Hope to hear from yall soon!

-lith

[antz]

Hi Lithiria,

I'll attempt to answer all your questions..

Question 1:

SD2 is currently not part of the wiki instructions as in the original plan it was going to be replaced by the Eluna (LUA) engine shortly after 18.1 was released. This has taken longer than planned.

Following the older guides instructions for loading the database should still work ok.

Question 2a:

TBH..... i'm not 100% sure, but can be added manually if needed

Question 2b:

ACID will work as it always did

Question 3:

The UPDATES folder is for people updating their existing database to the current version. mangosdb_installer.bat is a fresh full install of the database.

- If you run mangosd.exe and realmd.exe, these will tell you if the databases are not the correct version.

Question 4:

SD2 is much the same as the answer for question 3, if it is wrong, it will tell you.

Question 5:

corepatch no error may be a mistake on my part (I wrote that guide)

- to load up the patch, this normally this involves load a MySQL admin tool (like mysqlyog phpadmin etc.) and executing the file against the mangos database.

Hope this helps !

[Lithiria]

Thank you so much for your reply, Antz! Great guide, too! So what I read was, if my scripts are not the right version, then mangosd and realmd will tell me so. I guess that is good news

because both work fine! I will try to script scriptdev2 into my tables and see if I have any problems. I'm going to run ACID into my mangos table, too, just because that is how I have

always done it. I hope I don't mess it up!

Ok, my LAST problem is this: I am trying to make the mangos server and WoW work across a few computers in my house. Obviously, I will terminate my internet connection to prevent

accidental updating of the WoW client (personal use for practice and all that), but the local network should still be able to handle it. Here's my question:

I have used websites to determine my IP address. I coded that into my realmd table using "update realmlist set address = 'my.ip.add.here';" and I changed all of the appropriate entries in

the realmd.conf and mangosd.conf files, but it didnt work. They said they couldn't connect to mysql server. I then opened my network properties and saw tons of different numbers in things

like the IPv4 address, the subnet mask, and the DHCP and DNS server addresses. I don't know which one to use. Which IP address should I use to have the other computers connect to my

mangos server?

OH! Quick note, I tried connecting to the IP address from the same computer itself (meaning, changing the computer that would be localhost to sniff the IP address of itself instead. That is

what didn't work. Should I try it on another computer? I don't think I will see different results. Oh, and the mysql port is still 3306, should I open a different port? I thought port 8085 was

involved somehow. I really suck at firewall management, I let symantec take care of that for me, so I don't know too much about changing firewall settings.

-lith

[antz]

the quickest way I find the ip address in windows is to do this:

Right click on the network system tray icon and select 'Open Network and Sharing Center'

click on 'Change Adaptor Settings'

then right click on the Ethernet card and select 'Status'

on the resulting screen, click the details button and it will show you your ipV4-address:

This is the address you set in the realm db and also the address you would place in the other pc's realmlist.wtf files.

have you tried 127.0.0.1 rather than localhost - some versions of the client are a bit funny with anything other than an ip address.

As a final check, start with the firewall switched off for everything and attempt to connect, then slowly switch on the protection bit by bit so that you can configure things for it to passthrough and work.

[antz]

Did you get your issue resolved ?

[Lithiria]

Antz, kinda yes? I guess I figured it out. I knew the whole right-clicking and status thing you wrote, but I couldn't figure out which computer's IP to use. In the end, I figured it out. Thanks!