Server Setup Guide (Complete)

[bbblack]

crc error huh? gotta have the right dbdemon name :X

 

[MuRdOc]

doesn't anybody know how to solve my problem?

 

[Thralas]

Fiber, do you realize that most of the people that try to set up a serv don't give a damn about already answered questions or a little bit of own researches? That's the way it is, look through the threads. I am willing to share my knowledge, it's not that much anyway, but not to people that do really give a damn about things like that, who need to have a 1-click-exe and the servers done. That's the reason why Spherix and Thralas often don't post answers I suppose, and I can understand.

First of all, been a while. And yes I refuse to answer questions which are too simple. If you don't have a basic understanding of Windows/DBMSs/Networking you should just not try it. Go get a book rather or try to google. I indeed don't visit Ragezone too often anymore being quite busy managing our own server/IRL, but serious questions still have quite some chance to get an answer if I happen to pass by.

I still stick to 'our' policy of not releasing anything before we are (forced to?) shutdown. However I will then even have to be careful cause I do not feel like helping out Alea too much, that's what they get for slacking at INT/MY Could still be a lady for them if they want 'us' all gone and their not-so-good 'official' server up. I'll make them work, I promise. Enough tricks left in DR, thanks to slacking eSofnet/Alea.

Murdoc: Start by verifying whether the queries are executed, I suppose not, still give the SQL Profiler a swing imo

 

[bbblack]

Thralas, the querries do get executed, but if the filename's different from standard, I think it gives out a crc error and then it can't save anymore. I had that error too, and when I just recompiled the server and just let the name as it originally was, it worked. So my hint is to rename it how it should be.. Try it as DBDemon103p_040407.exe, I don't think voicer has changed anything related to the name in the DBDemon. If it doesn't work, slap me.

 

[prdgroup]

Can I design any table to support another language ? and how too , i tried to design the table and change collation frome korea too my collation , then i connect into the game and make any char for test mind collation set , first connected i could see the name as normaly like my collation but if i re-log it's be ??????

 

[MuRdOc]

ok i've been trying to solve this "mistery" all afternoon wth other ppl and here's what i've done:

I told them to use a packet sniffer on the client when they pressed login. here's the result on the thumbnail. As you can see, they get a message from the server (85.240.160.129) saying my LAN Ip (192.168.1.2). Now, what i think this ip does is tell the client what ip to connect to in order to login. Obviously, it doesn't work for them since they are not in my network, but it works for me because i am indeed IN the network and i get properly redirected. Now, I tried changing the "Own_server_ip_for_user" in some of the INI files to my internet IP, but i get a "USER_SIDE Socket Bind Failed!!" message in all servers (and a consequent server shutdown) except for DBDemon.exe. Now, what should I do?

 

[Spherix]

Only proxyserver should have an external IP for user, make sure you setup your router correctly to it, and opened needed ports.

 

[endomilik]

Feature from our client

feature in your client....wow dude...its not even ur client..
Its been like this even on .my server its already build on original client. so dont say its feature on ur client..da fact that u dont have any modified client....

 

[MuRdOc]

Only proxyserver should have an external IP for user, make sure you setup your router correctly to it, and opened needed ports.

Router is properly set up, both TCP and UDP (I didn't now wich to open so i opened both) ports 9001 9002 9003 9004 are open and forwarding to the correct computer.

This is how my proxyserver.ini is set up:

[nation_set]
nation_name = USA
BETA_SERVER = 1

[server_set_info]
own_server_set_number = 100
default_max_user_can_login = 500
default_max_user_can_login_per_sec = 50

[server_info]
own_server_ip_for_server=192.168.1.2
own_server_port_for_server=3001
own_server_ip_for_user=192.168.1.2
own_server_port_for_user=9004
primary_proxy_server_ip=192.168.1.2
primary_proxy_server_port=3001
secondary_proxy_server_ip=192.168.1.2
secondary_proxy_server_port=3002

[server_manager]
num_of_available_manager_ip = 1
manager_ip0 = 192.168.1.3
[external_server_info]
num_of_external_servers = 103

;/////////////// agent ///////////////

;LUCIFER
external_server_ip0 = 192.168.1.2
external_server_port0 = 7001
external_server_ip_for_user0 = 192.168.1.2
external_server_port_for_user0 = 9001

;/////////////// DB ///////////////

;LUCIFER
external_server_ip1 = 192.168.1.2
external_server_port1 = 4001

;/////////////// maps ///////////////

;LUCIFER     
external_server_ip2 = 192.168.1.2
external_server_port2 = 5000
external_server_ip3 = 192.168.1.2
external_server_port3 = 5010
external_server_ip4 = 192.168.1.2
external_server_port4 = 5020
external_server_ip5 = 192.168.1.2
external_server_port5 = 5030
external_server_ip6 = 192.168.1.2
external_server_port6 = 5040
external_server_ip7 = 192.168.1.2
external_server_port7 = 5050
external_server_ip8 = 192.168.1.2
external_server_port8 = 5060
external_server_ip9 = 192.168.1.2
external_server_port9 = 5070
external_server_ip10 = 192.168.1.2
external_server_port10 = 5080
external_server_ip11 = 192.168.1.2
external_server_port11 = 5090
external_server_ip12 = 192.168.1.2
external_server_port12 = 5100
external_server_ip13 = 192.168.1.2
external_server_port13 = 5110
external_server_ip14 = 192.168.1.2
external_server_port14 = 5120
external_server_ip15 = 192.168.1.2
external_server_port15 = 5130
external_server_ip16 = 192.168.1.2
external_server_port16 = 5140
external_server_ip17 = 192.168.1.2
external_server_port17 = 5150
external_server_ip18 = 192.168.1.2
external_server_port18 = 5160
external_server_ip19 = 192.168.1.2
external_server_port19 = 5170
external_server_ip20 = 192.168.1.2
external_server_port20 = 5180
external_server_ip21 = 192.168.1.2
external_server_port21 = 5190
external_server_ip22 = 192.168.1.2
external_server_port22 = 5200
external_server_ip23 = 192.168.1.2
external_server_port23 = 5210
external_server_ip24 = 192.168.1.2
external_server_port24 = 5220
external_server_ip25 = 192.168.1.2
external_server_port25 = 5230
external_server_ip26 = 192.168.1.2
external_server_port26 = 5240
external_server_ip27 = 192.168.1.2
external_server_port27 = 5250
external_server_ip28 = 192.168.1.2
external_server_port28 = 5260
external_server_ip29 = 192.168.1.2
external_server_port29 = 5270
external_server_ip30 = 192.168.1.2
external_server_port30 = 5280
external_server_ip31 = 192.168.1.2
external_server_port31 = 5290
external_server_ip32 = 192.168.1.2
external_server_port32 = 5300
external_server_ip33 = 192.168.1.2
external_server_port33 = 5310
external_server_ip34 = 192.168.1.2
external_server_port34 = 5320
external_server_ip35 = 192.168.1.2
external_server_port35 = 5330
external_server_ip36 = 192.168.1.2
external_server_port36 = 5340
external_server_ip37 = 192.168.1.2
external_server_port37 = 5350
external_server_ip38 = 192.168.1.2
external_server_port38 = 5360
external_server_ip39 = 192.168.1.2
external_server_port39 = 5370
external_server_ip40 = 192.168.1.2
external_server_port40 = 5380
external_server_ip41 = 192.168.1.2
external_server_port41 = 5390
external_server_ip42 = 192.168.1.2
external_server_port42 = 5400
external_server_ip43 = 192.168.1.2
external_server_port43 = 5410
external_server_ip44 = 192.168.1.2
external_server_port44 = 5420
external_server_ip45 = 192.168.1.2
external_server_port45 = 5430
external_server_ip46 = 192.168.1.2
external_server_port46 = 5440
external_server_ip47 = 192.168.1.2
external_server_port47 = 5450
external_server_ip48 = 192.168.1.2
external_server_port48 = 5460
external_server_ip49 = 192.168.1.2
external_server_port49 = 5470
external_server_ip50 = 192.168.1.2
external_server_port50 = 5480
external_server_ip51 = 192.168.1.2
external_server_port51 = 5490
external_server_ip52 = 192.168.1.2
external_server_port52 = 5500
external_server_ip53 = 192.168.1.2
external_server_port53 = 5510
external_server_ip54 = 192.168.1.2
external_server_port54 = 5520
external_server_ip55 = 192.168.1.2
external_server_port55 = 5530
external_server_ip56 = 192.168.1.2
external_server_port56 = 5540
external_server_ip57 = 192.168.1.2
external_server_port57 = 5550
external_server_ip58 = 192.168.1.2
external_server_port58 = 5560
external_server_ip59 = 192.168.1.2
external_server_port59 = 5570
external_server_ip60 = 192.168.1.2
external_server_port60 = 5580
external_server_ip61 = 192.168.1.2
external_server_port61 = 5590
external_server_ip62 = 192.168.1.2
external_server_port62 = 5600
external_server_ip63 = 192.168.1.2
external_server_port63 = 5610
external_server_ip64 = 192.168.1.2
external_server_port64 = 5620
external_server_ip65 = 192.168.1.2
external_server_port65 = 5630
external_server_ip66 = 192.168.1.2
external_server_port66 = 5640
external_server_ip67 = 192.168.1.2
external_server_port67 = 5650
external_server_ip68 = 192.168.1.2
external_server_port68 = 5660
external_server_ip69 = 192.168.1.2
external_server_port69 = 5670
external_server_ip70 = 192.168.1.2
external_server_port70 = 5680
external_server_ip71 = 192.168.1.2
external_server_port71 = 5991
external_server_ip72 = 192.168.1.2
external_server_port72 = 5992
external_server_ip73 = 192.168.1.2
external_server_port73 = 5993
external_server_ip74 = 192.168.1.2
external_server_port74 = 5690
external_server_ip75 = 192.168.1.2
external_server_port75 = 5700
external_server_ip76 = 192.168.1.2
external_server_port76 = 5710
external_server_ip77 = 192.168.1.2
external_server_port77 = 5720
external_server_ip78 = 192.168.1.2
external_server_port78 = 5730
external_server_ip79 = 192.168.1.2
external_server_port79 = 5740
external_server_ip80 = 192.168.1.2
external_server_port80 = 5750
external_server_ip81 = 192.168.1.2
external_server_port81 = 5760
external_server_ip82 = 192.168.1.2
external_server_port82 = 5770
external_server_ip83 = 192.168.1.2
external_server_port83 = 5780
external_server_ip84 = 192.168.1.2
external_server_port84 = 5800
external_server_ip85 = 192.168.1.2
external_server_port85 = 5810
external_server_ip86 = 192.168.1.2
external_server_port86 = 5820
external_server_ip87 = 192.168.1.2
external_server_port87 = 5830
external_server_ip88 = 192.168.1.2
external_server_port88 = 5980
external_server_ip89 = 192.168.1.2
external_server_port89 = 5801
external_server_ip90 = 192.168.1.2
external_server_port90 = 5802
external_server_ip91 = 192.168.1.2
external_server_port91 = 5803
external_server_ip92 = 192.168.1.2
external_server_port92 = 5811
external_server_ip93 = 192.168.1.2
external_server_port93 = 5812
external_server_ip94 = 192.168.1.2
external_server_port94 = 5813
external_server_ip95 = 192.168.1.2
external_server_port95 = 5814
external_server_ip96 = 192.168.1.2
external_server_port96 = 5815
external_server_ip97 = 192.168.1.2
external_server_port97 = 5816
external_server_ip98 = 192.168.1.2
external_server_port98 = 5817
external_server_ip99 = 192.168.1.2
external_server_port99 = 5818
external_server_ip100 = 192.168.1.2
external_server_port100 = 5819
external_server_ip101 = 192.168.1.2
external_server_port101 = 5821
external_server_ip102 = 192.168.1.2
external_server_port102 = 5822

If i change own_server_ip_for_user to my ip (85.240.160.129) i get a USER_SIDE Socket Bind Failed!! and proxy shuts down.

If I change own_server_ip_for_server to my ip i get a SERVER_SIDE Socket Bind Failed!! and proxy shuts down.

 

[sleyer]

Either you may have did it wrong, or I am kind of confused as to why you did some of the things that you did. I will try to rexplain it in hopefully greater detail.

First create a new Database called testDB and restore the DragonRajaDB to that newly created TestDB. After that, delete DragonRajaDB and recreate it. Next you have to right click your new DragonRajaDB and click All Tasks, then click Import. Just follow the directions (the first or second page is the source database, choose TestDB. The second next page is the destination Database, choose DragonRajaDB[I hope that is the right order]). Once you are at the end where it shows all the tables that can be imported, right click it and choose select all, then go next and it should then begin importing and will take a few seconds.

Once the important is done open query analyser and put the query in the blank field, scroll down to DragonRajaDB and execute the script. Hope it works.

If this still does not work you can add me to MSN or AIM. Both of my instant messenger names should be in my profile. It would be easier if I can help you in a more real time situation.

sory im not understant about this.... plzz help

 

[Spherix]

feature in your client....wow dude...its not even ur client..
Its been like this even on .my server its already build on original client. so dont say its feature on ur client..da fact that u dont have any modified client....

Updating party HP (Read: the bar shows how much hp your party members have left) was never implemented, if you don't know what you are talking about, don't complain.

Same goes for party chat in the same enviornment as guild chat and normal chat are, tabbing em, wasn't ever in, since I manually created the icon that the game uses for it.

 

[Thralas]

Thralas, the querries do get executed, but if the filename's different from standard, I think it gives out a crc error and then it can't save anymore. I had that error too, and when I just recompiled the server and just let the name as it originally was, it worked. So my hint is to rename it how it should be.. Try it as DBDemon103p_040407.exe, I don't think voicer has changed anything related to the name in the DBDemon. If it doesn't work, slap me.

Hereby I'm slapping you then, the filename has nothing to do with the actual server functionality. However I think I've missed out the actual problem you're experiencing, could you describe it once more?

ok i've been trying to solve this "mistery" all afternoon wth other ppl and here's what i've done:

I told them to use a packet sniffer on the client when they pressed login. here's the result on the thumbnail. As you can see, they get a message from the server (85.240.160.129) saying my LAN Ip (192.168.1.2). Now, what i think this ip does is tell the client what ip to connect to in order to login. Obviously, it doesn't work for them since they are not in my network, but it works for me because i am indeed IN the network and i get properly redirected. Now, I tried changing the "Own_server_ip_for_user" in some of the INI files to my internet IP, but i get a "USER_SIDE Socket Bind Failed!!" message in all servers (and a consequent server shutdown) except for DBDemon.exe. Now, what should I do?

Set external_server_ip_for_user0 at the agent section in proxyserver config to your external/WAN IP, rest can be left localhost/LAN IP.

 

[demothene]

Hi all, sorry but i got a problem -_- , i try to set all the ip but a really dunno how to config it... when i run proxy server only 1 map server succefully connected, and all other failed...
dbdemon cannot connect and agent to.. my problem is only the ip..

anyone can esplain me in detail plz ?what ip needed for each place?. thx

 

[MuRdOc]

dude thx it worked ^^

 

[ivaldi]

i have error. When i start MapServer.exe .
this messeng from popup error.
*********FAILED !! 'reguital_item' QuestTable!]

 

[Thralas]

Well, it gave you alot of info didn't it?

 

[bbblack]

Thralas, when I had that problem with the user data saves, it told me that DBDemon has "crc check error". I did nothing but simply to rename it after recompiling it (no changes, I'm sure of it) and it worked. ;x

 

[sleyer]

help ler

 

[Motorola2]

Help

i have problem i can't load dbdemon ... when i open i have 2 error Item Plant and next is
'ini:Item()' Fail !

what i must do ?? how fixe this ??

and i have Item plant error in map !!

 

[Spherix]

what i must do ?? how fixe this ??

Use the search function.

Wonder when that's going to apply :shifty: