stuck at handshaking

Sorry if this problem has been posted before I cant understand many topics that I find so I'll explain my situation best I can and hope for some aid.

I currently have World of Warcraft client 2.0.12 (6546) latest since I last logged in in April

I have followed this guide to create a mango's server since I had not come across this forum until now

When running realmd.exe and mangosd.exe there are no visible problems as seen in this screenshot

However upon using the WoW client to log in (username: administrator, pass: administrator) It will simply stay at handshaking status

Neither Warcraft, nor mangos crashes or exits the login sequence simply stops there

Any help would be greatly appreciated

Oh and as a final note I'm only wanting to use this as a single player server, perhaps to see some areas in GM 'god-mode' that I would never see otherwise (Naxx, etc)

If that screenshot is what it looks like after you have tried to log in, your client never logs into realmd.exe

So open your World of Warcraft directory and make sure that your realmlist.wtf file says:

set realmlist 127.0.0.1

if it does, try going into your realmd database and edit the table realmlist.

Change the "Address" column to match your IP address.

Though the Address column shouldn't be the problem here, you can try it. other things to look at. Make sure the realmd.conf file has the realmserver port at 3724 and that in mangosd.conf the worldserver port is 8085.

Found your error. You patched to 2.0.12

The guide is for 2.0.2

My sig has the 2.0.12 servers. Download:
Server 3542_SD2 revision 38 + SDB 0.6.4 (Latest SDB Revision)

basically use that tut to install everything. The only thing you should need to change is the mangos DB. You should be able to leave the realmd database alone.

Ok thank you so far. I downloaded the Server 3542_SD2 revision 38 + SDB 0.6.4 (Latest SDB Revision) and overwrote my current mangos files with it

However I wasnt sure where "SDB_0.6.4_FULL.sql" was to go so I just put it in the mangos main folder

mangosd.exe now closes immediately on opening and looking at the log it seems my .map files are outdated.

Using the link in this topic I downloaded ad.exe and executed it in my WoW folder but have now come upon a problem

ad.exe cannot find "terrain.mpq" or "DBC.mpq" and a search in my WoW folder seems to suggest that these 2 files don't exist.

Is it missing files in my WoW client or am I just using ad.exe wrong?

edit: ah didnt notice the .map files were available from the topic where I got ad.exe, downloading them to try i

edit again: nevermind the archive on that topic is corrupt so still need a way of getting the correct .map files into mangos

Final edit: Ok looked about and found a different ad.exe in this topic which didnt seem to require the two MPQ files

However it cannot create the map files, I took a screenshot

----------------------------------------------

Ok after a lot of tinkering and thanks to the guide in your sig I have extracted the DBC and maps and that seems to have fixed that problem.

The next problem seems to be SQL based with which I have no experience so here's part of the server.log file to see if you can make any sense of it

Quote:

---

2007-05-03 14:15:27 Realm running as realm ID 1
2007-05-03 14:15:27 Using DataDir ./
2007-05-03 14:15:27 Initialize data stores...
2007-05-03 14:15:28
2007-05-03 14:15:28 >> Loaded 31 data stores
2007-05-03 14:15:28
2007-05-03 14:15:28 Cleaning up instances...
2007-05-03 14:15:28 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `creature_respawn` WHERE `instance` <> 0
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.creature_respawn' doesn't exist
2007-05-03 14:15:28 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `gameobject_respawn` WHERE `instance` <> 0
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.gameobject_respawn' doesn't exist
2007-05-03 14:15:28 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance`
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-05-03 14:15:28 ERROR:SQL: SELECT `id` FROM `instance`
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-03 14:15:28 ERROR:SQL: SELECT DISTINCT(`instance`.`id`) AS `id` FROM `instance` LEFT JOIN `character_instance` ON (`character_instance`.`instance` = `instance`.`id`) WHERE (`instance`.`id` = `character_instance`.`instance`) AND (`instance`.`resettime` > 1178198128)
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.instance' doesn't exist
2007-05-03 14:15:28
2007-05-03 14:15:28 >> Initialized 0 instances, deleted 0 old instances
2007-05-03 14:15:28 Packing instances...
2007-05-03 14:15:28 ERROR:SQL: SELECT DISTINCT(`instance`) FROM `character_instance` WHERE `instance` <> 0
2007-05-03 14:15:28 ERROR:query ERROR: Table 'mangos.character_instance' doesn't exist
2007-05-03 14:15:28
2007-05-03 14:15:28 >> Instance numbers remapped, next instance id is 1
2007-05-03 14:15:28 Loading Game Object Templates...
2007-05-03 14:15:29 ERROR:Error in `gameobject_template` table, probably sql file format was updated (there should be 18 fields in sql).

---

apologies for the double post but I would like at least one answer before i let this topic die

Quote:

---

Originally Posted by limbo87

Ok thank you so far. I downloaded the Server 3542_SD2 revision 38 + SDB 0.6.4 (Latest SDB Revision) and overwrote my current mangos files with it

However I wasnt sure where "SDB_0.6.4_FULL.sql" was to go so I just put it in the mangos main folder

mangosd.exe now closes immediately on opening and looking at the log it seems my .map files are outdated.

Using the link in this topic I downloaded ad.exe and executed it in my WoW folder but have now come upon a problem

ad.exe cannot find "terrain.mpq" or "DBC.mpq" and a search in my WoW folder seems to suggest that these 2 files don't exist.

Is it missing files in my WoW client or am I just using ad.exe wrong?

edit: ah didnt notice the .map files were available from the topic where I got ad.exe, downloading them to try i

edit again: nevermind the archive on that topic is corrupt so still need a way of getting the correct .map files into mangos

Final edit: Ok looked about and found a different ad.exe in this topic which didnt seem to require the two MPQ files

However it cannot create the map files, I took a screenshot

----------------------------------------------

Ok after a lot of tinkering and thanks to the guide in your sig I have extracted the DBC and maps and that seems to have fixed that problem.

The next problem seems to be SQL based with which I have no experience so here's part of the server.log file to see if you can make any sense of it

---

You need to install MySQL Server and then execute the "SDB_0.6.4_FULL.sql" dump you got with a program such as Navicat or SQLyog, after you create 2 databases with the names mangosd and realmd. All your problems are DB related.

PS1: You might also need to execute this dump :
(Just rename it from realmd.txt to realmd.sql and you are set.)

Here you go, the AD.exe you downloaded from that ragezone post is OLD. This is the newest one.

https://svn.sourceforge.net/svnroot/...tractor/ad.exe

comes directly from MaNGOS's sourceforge site.

When you run that file in the WoW directory, don't forget to create a folder called maps. You'll get a ton of errors if you don't

ah nevermind... I think you got that working. lol. Yea, do a dump of your mangos DB using navicat (I think thats the program you're using) and then import the 0.6.4 SDB.sql file just like you did with the original database you imported.

This is copied from your guide you used

Quote:

---

) Open Navicat
Now click:
-File, then
-New Connection, then
-Connection Name: *Anything*
-Host Name/IP Address: localhost
-Password: The same one from MySQL
2) Now right click *Anything* and select New Database and name it mangos.
3) Right click *Anything* again and select New Database and name it realmd.
4) Right click realmd and click Execute Batch File and browse to ……\mangos\sql\realmd.sql and execute. It will alert you when finished.
5) Now right click on mangos and Execute Batch File…mangos\sql\mangos.sql this may take a while to execute, but it will alert you when finished.

---

do it this way instead
Delete the current Mangos DB that you have in Navicat.
leave the realmd one be, its good to go.

Quote:

---

1) Open Navicat
Now click:
-File, then
-New Connection, then
-Connection Name: *Anything*
-Host Name/IP Address: localhost
-Password: The same one from MySQL
2) Now right click *Anything* and select New Database and name it mangos.
3) Now right click on mangos and Execute Batch File… SDB_0.6.4_FULL.sql this may take a while to execute, but it will alert you when finished.

---

You will not have to create the "New Connection" but you get the general idea.

It's getting there. Slowly but surely :)

creating a new mangos database has fixed the SQL errors and mangosd.exe now signals it is ready with a beep

Now for the next and hopefully last problem. logging in as administrator I can select my server from the otherwise empty realm list

However its status sticks on connected. Here's the WoW screen and mangos and realm windows

Seems its missing a column called 'v', how and where would I add it?

*saving from page 3