Want to play without Hamachi? be able to play with your players? you can do it now!!

[dordort]

Hello, i got something awesome that i thought about. it is working 100% and very very smart idea.

As you know the cabal server files accepting only one side of connection, or lan or wan (external ip, or lan ip) that's mean that if you set your Centos lan ip (10.0.0.2, 192.168.0.2 for example) in the server configs the server will accept only you to play (from windows lan, all the lan clients from the house will be able to play) and another players from another computers will not be able to connect the channel, and if you will set the wan ip in cabal configs so all the players can play but you cant pass the channel. so, that's the reason that you play with hamachi, and its really annoying thing. so, i will explain how to make this smart trick. ;)

1. You will need to create a new virtual machine with VMware and install windows on it. (recommended windows server 2003, if you cant just use iso image of your xp, or your cd.) *PM me for windows server 2003 download + crack.*

2. You will need to install the database server (MSSQL 2000/2005) in the virtual windows machine and use this machine lan ip for the odbc.ini connection in centos. **Its recommended to use the MSSQL 2000, because its more easy then 2005, faster installation + configuration, and less problems. Video Guide by me on install a mssql 2000, only 2.33MB file and only 20 minutes of work!** - http://forum.ragezone.com/f460/dordo...2-33mb-500461/

**Note: If you are already running a cabal server, you can simply backup the mssql databases by create a Backup Device, and save the data in to it, and then copy the files into the virtual windows and restore the databases. how to do that? go to SQL Server Enterprise Manager, Managament---->Right click on "Backup"---->New Backup Device... You will need to create a few backup devices, one backup device for every database. (ACCOUNT, GAMEDB, and CabalCash). only that three databases is needed to be backup because the another databases is never be changed and not saving data on it. if you want for make sure that all be ok you can backup all of the databases but its unneccesary =P after you have created all of the Backup Devices just go to Databases---->Right click on the database you need to backup---->All Tasks---->Backup Database... Make sure that you standing on "Database - complete" and on "Overwrite existing media", now just add the empty backup device that we created and press ok to backup. after all is Backing up, just move the Backup Devices from the MSSQL directory to the virtual windows, and create all the databases once again, Right Click---->Restore Database... Press on the "From device" option, and chose the backup file of this database name. now if the MSSQL folder is in another place, for example in your real windows it was C:/MSSQL and in the virtual machine you did install it in D:/MSSQL so go to the tab "Options" and change the "Restore As" to the place that the databases files will be placed. now press ok and all of the data with the triggers will be back. ;)

3. You will need to use software like Hotspot Shield (recommended) that is free to use, that makes a connection to a VPN server, and proxy your connection of your real windows to use the socks (and http too.. but what we need its socks) with another ip. and then, you can acces and play your server just normally. =]


Question: Why do i have to run my server over a new virtual windows? i cant just run this software over my real windows and run a server?

Answer: No, the windows can only listen to one connection and if you will run a server and then run the software that connect you to the VPN, peoples will not be able to play and all gone. the connection will lost, and it was tested by me.

Question: But its not good, because i need that the windows will start automatically when my computer start it is really impossible to do that?

Answer: Yes, it is. by simple few steps you can make the VMware power up the virtual machines when your real windows starts. **The tutorial can be founded here: http://forum.ragezone.com/f459/ready...server-499708/**

Question: Can i play with Hotspot Shield in all my computers in the house? or its just helps me to play from my computer?

Answer: Ofcurse, you can run the software and play in your server on every computer in the house.


*Note: As you see, this solution make you able to play with your players in your own server in easy, and the server is hosted in another windows and will not annoy you anymore.

*Important! you cant and you dont need to run the centos from the virtual windows, you just run 2 machines, centos, and the windows. and you just make the centos to connect the lan ip of the virtual windows (with the MSSQL..) by simply edit the odbc.ini in /etc.

After done all this, run the server normally with your wan ip. in your real windows just run the VPN software, i was tested it with Hotspot Shield, and its really good =D what you have to do is just download the software **Free to use, and small file** from the official site of Hotspot shield. http://hotspotshield.com
Then, install it in your real windows and connect to it, then you will be able to play in your own server by simply connect when the External ip (http://whatismyip.com) its configured in the client internal.txt file in the Data folder.


All the credits for the guide and the idea going to dordort,
Good luck guys. =]

[MentaL]

[Jeffijoe]

Omg.. Why dont anyone see Dordorts posts? I know that alot of ppl saw his VMware CentOS, but this guide is also awesome, and no1 sees it.. Thats sad. Well, I saw it, good work, buddy :D

[D e v i L]

i saw it and i want to ask something... if for example i get a dedicated server which is on Centos can i install VMware on it then install windows OS inside the VMware for the SQL server? will that work? :D hope you answer my question :D thanks! anyways the players connect to the centos IP am i correct?

[ServerMaker]

NICE GUIDE BRO.
2 thumb
BRO.can you please share you Windows Server 2003 that need to this guide.
PM me to this e-mail: iwillw8you@yahoo.com

THANKS BRO FOR THIS USESABLE GUIDE AND SIMPLE TO UNDERSTAND.
MORE POWER TO YOUR SERVER
THANKS RAGEZONE MMORPG DEVELOPTMENT

-=Sorry for my BAD english=-

[chumpywumpy]

Sharing a copy of windows would be illegal and therefore against forum rules.

[ServerMaker]

@chumpywumpy
OK dude sorry...!

THANKS BRO FOR THIS USESABLE GUIDE AND EASY TO UNDERSTAND.
MORE POWER TO YOUR SERVER
THANKS RAGEZONE MMORPG DEVELOPTMENT

-=Sorry for my BAD english=-

[cypher]

nice guide ^^

[Doxxxy]

can you pot some videos pls because i dont understand english wary good :s

[jonathan3137]

תודה אחי מדריך סוס! איזה השקעה =].
בכל זאת אתה סתם כלב >>
למה מחקת לי תדמות עם ההרבה סטאטים?
עזרתי לך כלכך הרבה בשרת, חבל =S
בכל מקרה בהצלחה עם השרת.

translation:
Thanks bro awesome guide!!
Looks like you spent alot of time on that guide.
Thanks.
Good luck with your server.

[Doxxxy]

can you make a video to ???? PLS xD

[crystishor]

can anyone give me windows server used by dordort please?contact me see ids at my profile(i have YM,skype,ICQ,MSN)

[Cath22]

Windows 2003 Server

[chumpywumpy]

A windows 2003 download would be reasonably large and you can't post links here as it would be an illegal copy. The windows operating system really doesn't matter that much though, Windows 2000, XP, 2003, Vista and 2008 (all 32 and 64 bit variants too) work fine. The only limitation is imposed by the mssql version you have as certain versions won't install on some operating systems, 2005 Enterprise for example won't install on XP but 2005 Express will.

[dishkols]

i dont see any use of this. its just posible to do good NAT on the router and its will work just fine, no need of any VPNs or additional software

EDIT: and tot look like its just a flame here is how to do it:

iptables -t nat -A PREROUTING -p tcp --dport 38101 -i eth0 -d EXT_IP -j DNAT --to INT_IP:38101
EXT_IP - your router real IP
INT_IP - CentOS internal IP
line above do a port forwarding for the login server, u have to do this for all channels and chatserver ports

iptables -t nat -A POSTROUTING -p tcp --dport 38101 -o eth1 -d INT_IP -j SNAT --to EXT_IP:38101
this line make sure that everything that goes to CentOS is look like comming from outside, even internal connections (dont forget that server will send EXT_IP to your local client, so all packets will be rerouted via your router)

hopes u see the picture

[hostyle]

i dont see any use of this. its just posible to do good NAT on the router and its will work just fine, no need of any VPNs or additional software

EDIT: and tot look like its just a flame here is how to do it:

iptables -t nat -A PREROUTING -p tcp --dport 38101 -i eth0 -d EXT_IP -j DNAT --to INT_IP:38101
EXT_IP - your router real IP
INT_IP - CentOS internal IP
line above do a port forwarding for the login server, u have to do this for all channels and chatserver ports

iptables -t nat -A POSTROUTING -p tcp --dport 38101 -o eth1 -d INT_IP -j SNAT --to EXT_IP:38101
this line make sure that everything that goes to CentOS is look like comming from outside, even internal connections (dont forget that server will send EXT_IP to your local client, so all packets will be rerouted via your router)

hopes u see the picture

Does anyone know if this works?

[Sarmalutza]

[Fri Dec 11 2009 04:06:41.075075 3086412704]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Fri Dec 11 2009 04:06:41.076643 3086412704]: [##ERROR##] DB ERROR(CODE) : 20009
[Fri Dec 11 2009 04:06:41.076749 3086412704]: [##ERROR##] DB ERROR(VAR_INFO) :
[Fri Dec 11 2009 04:06:41.076829 3086412704]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Fri Dec 11 2009 04:06:41.076915 3086412704]: [##ERROR##] DB ERROR(STM_TEXT) :
[Fri Dec 11 2009 04:06:41.076960 3086412704]: [##ERROR##] Database Connect Fail (uid=sa;pwd=;dsn=CabalGame24;APP=DBAgent_24)
[Fri Dec 11 2009 04:06:41.077006 3086412704]: [##ERROR##] check 'pDB' fail
[Fri Dec 11 2009 04:06:41.077046 3086412704]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Fri Dec 11 2009 04:06:41.077091 3086412704]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)

I maked all step... and dont work... so dordort can help me ^^

[cypher]

Server is unavailable or does not exist

This message should ring a bell right? hmm Guess not. Check firewalls and ips.

[Sarmalutza]

Windows server 2003 firewall?

[ihavethepower]

i did everything like u said dordot, but it didnt worked, can u help me? ODBC.INI is set to connect on VIRTUAL WINDOWS and all ok... but when i try to connect to my own server by WAN IP it doesn`t connect.

i hope u help me :P

Ps: Using the softwares u told to use (WIN2003, MSSQL 2000 and on...)

[ihavethepower]

now i can access my website with wan ip in my own pc... but not the server, now the server dont even connect on lan ip oO!

help plz.

[ChaoShady]

good guide..
but just the hot spot shield not so good

[TanGzkie]

Hot SpotShield is good cause you can use direct connection from your
WAN but the worst is if you off and also your PC the server The WAN IP
will get A new one ;/ Bad...

[azryrulez]

u mean change the internal.txt n serverlist ip to wan ip?
after moving sql to vmware~

n then config centos to use wan ip(www.whatismyip.com)?
is it?

plz teach me ~ thanx

sql 2000 - vmware 192.168.1.100
centos - vmware 192.168.101
hotspotshield - windows 192.168.1.107

is this ok?