Handshaking Issued

12 posts

1. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   Greetings,

   Would appreciate any help that folks can provide.

   I followed the tutorial and everything worked great.

   However, the game crashed out (trying to abandon a hunter pet (first one) while doing the new hunter pet training quest).

   When I tried to log back in, I'm getting the "Handshaking Error"

   I've searched, poked prodded, rebooted, everything I can think of doing with my limited skills.

   I've been unable to find anything posted regarding a resolution to the issue. I've seen a few comments, or questions by others, but no responses.

   Would someone be so kind and to enlighten me with a way to fix this?

   WoW version is 2.3.3

   Reaper Mangos 5472

   No issues with mysql.

   No issues with either mangosd.exe and it's .conf file.

   No issues with realmd.exe and its .conf file.

   As I previously indicated it worked the first time. Just not the second time.

   When I enter the "gm" account, I stick at handshaking.
   It does recognize when I try to enter an account that isn't available.

   Thank you for your assistance.

   Posted 1 year ago » Permalink

2. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   Lol, and I mistyped "Issue" and got "Issued". Please excuse me. Couldn't find a way to edit.

   Posted 1 year ago » Permalink

3. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   Updated information (hate when few come back and update information) , so here goes.

   I decided to create another account just to see if that one could get in.
   Yes, I was able to get in and try a character.

   The first account still stops at "handshaking" however.

   Still would love to see some input/response from all of you who are more than computer idiots such as myself.

   Thank

   Posted 1 year ago » Permalink

4. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   GAH!

   Not sure what's going on here.

   Now, after getting back in, the character crashes when I try to enter my character window!!!

   Posted 1 year ago » Permalink

5. daggo
   
   Regular
   Joined: May '08
   Posts: 157

   A "Handshake" is whenever your computer tries to establish a TCP connection with a server. In your case, your client is trying to connect to your server but unable to establish this connection. This could be caused primarily by a firewall on your computer/server, or perhaps some ports are shut down. For troubleshooting purposes, you can try to change the ports within your realmlist.conf and mangos.conf files to see what happens.
   I would also like to know how you have your IP tables set up. Are your clients directing to your private lan server 192.168.x.x/ 10.10.x.x? Or are they directed to your external ip address and forwarded through your router? What version of SQL are you using?

   Posted 1 year ago » Permalink

6. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   daggo,

   Thank you for your quick response and informative missive.

   However, I didn't feel it necessary to provide that information considering it had worked the first time, and I hadn't changed anything.

   I am still unable to connect with the original account set up during installation.
   I have since created a new/additional account, and have been able to access with that.

   I will however, provide the information you've requested.

   Firewall information: Not running a firewall, though using a router. I've been able to repeatedly connect with a second account, and have changed no settings. Therefore I am not certain if that's the issue.

   IP Tables: Using a router with DHCP. I'm connecting with the same computer the server is set up on. My LAN does yse the 192.168 scheme.

   My SQL is the 5.0 version as instructed through the "Fresh Install" method. Again I'll reitterate that it is working, just not with that original account.

   As for IP's within the "server" it's all the 127.0.0.1 stuff as instructed/directed by the Reaper installation instructions. Again, I'll state that it is working. But on a second account that I added through mangosd.exe.

   Please note: I'm not trying to make a public server, nor am I wanting anyone in my "LAN" to connect. If they want to play wow, they can go pay Blizard $15 per month, just like I've been doing/have done for the past 3 years. I just wanted to explore areas I'll likely never be able to see.

   Again, thank you for your prompt response. I'll be delighted to read anything else you wish to provide.

   Be well.

   Posted 1 year ago » Permalink

7. daggo
   
   Regular
   Joined: May '08
   Posts: 157

   Ah I see now. Sorry, thought it was another networking issue at first.(I need to L2read more carefully)

   I had a similar issue once with a character. He died, glitched, and wouldnt let me login with that account anymore. What may have happened is that the action may have corrupted your db info on that character. What you may have to do is fiddle around in your database using SQLyog or any other database editing program and see what you can find.
   You can also try to use gm commands from the console to try to .revive or .tele your gm character to another location, or possibly remove quests to try to debug your character.

   You probably hit a small bug within the database itself. Maybe while installing the database, a .pet table or .quest table came out strange and is messing things up. Maybe backing up your characters, and reinstalling may do the trick to fix the db info.
   Experiment around, see what you can find and if you do find a solution, please share with us.

   Posted 1 year ago » Permalink

8. outofmemory
   
   Member
   Joined: Jun '08
   Posts: 17

   Sorry daggo Wish I was more computer proficient for what you're requesting.

   I'm happy that this is working now.

   But I will offer my sincerest apologies for doing another thing I hate.

   That's not giving some thanks where due.

   Thank you very MUCH Reaper X for all your hard work!
   Not only was your installation instructions almost idiot proof (I'd give it a 98%, because there were a few times I had to scratch my head), but it was successful! That's the most important part! I tried other methods unsuccessfully.

   I do have another question, and wish to retract my previous comment of not wanting to "lan" this. But my son (7 years old) was devestated when I cancelled his account. He just wasn't playing enough. And I've satisfied most of his WoW needs through the use of my account. But he's always missed playing with dad.

   I'd like to set this up.

   I set up his computer, and started it up.
   WoW successfully logged into the server, but is hanging up on the realm select screen.
   It lists the reaper server in the realmlist but won't let him select it.

   I've set his wow login to 192.168.15.100 (the IP of my lan computer), this is correct, right?

   And before you ask, he's on 2.3.3 just like me, and the server.

   Any suggestions on this?

   Posted 1 year ago » Permalink

9. daggo
   
   Regular
   Joined: May '08
   Posts: 157

   The first thing you would try to do is to run the Reaper-x-mangos tool you used to install with. I cannot remember what option number it was to set up your lan server. Run through the lan setup option and use your IP [192.168.15.100] of your lan server. That should set it up properly.

   The realmlist on your computers should have

   set realmlist 192.168.15.100
   set patchlist 192.168.15.100

   If you are using 2.3.3 I highly recommend leaving the 'set patchlist' pointed to your server ip (or any other null ip) in your realmlist to prevent it from automatically updating from blizzards servers.

   Good luck and have fun! Any other questions, ask away!

   Posted 1 year ago » Permalink

10. outofmemory
    
    Member
    Joined: Jun '08
    Posts: 17

    Ok, I've been fiddling.

    I read other threads and tried the "option 5" from reaper-x-mangos.exe tool.

    That all seemed to work just fine.

    Problem appears to be with realmd connecting with the sql database.

    Could not connect to MySQL database at 192.168.15.100: Hots 'Fast is not allowed to connect to this MySQL server.

    Cannot connect to the database.

    So I did a little more searching and discovered a possible fix (possible because it didn't work).
    Tried the run cmd.exe
    update sql
    UPDATE realmlist SET address = '192.168.3.3' WHERE id =1;

    Everything appeared to apply properly, that is, of course, if you assume I understand what I'm reading .

    So, how do I get Host "fast" (which is the name of the computer to be allowed to connect to the sql database?

    And daggo, thanks for hanging in here with me for so long! *tips hat at daggo* I appreciate your help.

    Posted 1 year ago » Permalink

11. Petie
    
    Member
    Joined: Jun '08
    Posts: 13

    Edit:
    It seems as though you got this working on your own but posted your reply in a different thread. If so, feel free to ignore this.
    -------------------------------
    Is "fast" the server computer itself or your son's computer? I'm also a little confused about your IP choices here. You have the realmlist attempting to connect on 192.168.15.100 but you're setting your server's IP address to 192.168.3.3 (that's what that SQL command did). I may just be tired and missing something here (it is almost 3 AM after all so I'm sorry if that's the case) but if you could possibly post the following, it would be helpful.

    Your computer's IP address (the one you play from)
    Your son's computer's IP address (I'm assuming this is different than yours since the goal is for the two of you to be able to play together)
    Your server's IP address (I'm also assuming this is different from your IP address though this may not be the case)

    You can post the names of the computers as well though that would just help to clear up which computers are trying to connect to the database so it isn't entirely necessary.

    Just as a little bit of reference info, I'll give you two scenarios here. First, you are connecting from the server computer and your son is connecting from another computer. For the sake of simplicity, I'll call the server (and you in this case) 192.168.0.1 and your son 192.168.0.2. This scenario implies that you have two computers on the network.

    Your realmd table should have 192.168.0.1 as it's IP address (to change it in this case, you'd use the command UPDATE realmlist SET address = '192.168.0.1' WHERE id = 1; once you have the proper database selected which you can do by typing USE realmd; if you're doing this all on the command line). Your realmlist.wtf file should read:
    set realmlist localhost
    set patchlist localhost (though this line can be left out and doing so is another way to prevent the client from updating)
    Also, where I have localhost, 192.168.0.1 may also work in if you're connecting from the server computer.

    Your son's realmlist.wtf file should read:
    set realmlist 192.168.0.1
    set patchlist 192.168.0.1 (again, this line can be left out)

    Now, for scenario two, we're going to assume that your server is a dedicated machine and that you have three computers on the network. To keep things simple, we'll still call the server 192.168.0.1 and your son's computer 192.168.0.2 and we'll add a third computer, yours, as 192.168.0.3.

    Your realmlist on the server should still be set to 192.168.0.1 and both yours and your son's realmlist.wtf file should read:
    set realmlist 192.168.0.1
    set patchlist 192.168.0.1 (again, this line can be left out)

    Remember that I made all of these IPs up though so don't use them. I can customize these scenarios more once I have the correct number of computers and their IPs. Let me know if you need anything better explained. I'm sure between me and daggo (who also really seems to know what he's talking about), we can get this working for you.

    Posted 1 year ago » Permalink

12. bingle
    
    New Member
    Joined: Jun '08
    Posts: 1

    Handshaking problem arises because of many possibilities. One remedy for this is to reformat your computer because there might be some programs that are not having a connections or not responding because there is a problem with the server.

    ____________
    bingle

    There are a lot of sites out there showing book video. BookVideoTV, BookTelevision and of course CSPAN, but I like how BN.com and Reader's Entertainment TV have specific genre channels and original shows. There's just more to see and I can be specific in what genre I'm interested in. Anyone else watch online tv?
    http://www.readersentertainment.tv

    Posted 1 year ago » Permalink

RSS feed for this topic

Reply

You must log in to post.