[Guide] 2.02/2.05 Server Guide UPDATED - RaGEZONE

Legendary · 07-09-2006

2.02 Server Guide (UPDATED July 2006)

Ok.. Alot of people in ragezone are having problems setting up their servers or just can't seem to understand what the SEARCH button is for... Well this guide is for those who want to set up a A3 2.02 Server... credit goes to Akaruz for the first guide so read his before you come and ask questions

http://forum.ragezone.com/a3/a3-202-...ide-97099.html <<Akaruz Guide

First, you need the SERVER FILES : GO LOOK FOR THEM

Still can't get your server up? READ THIS GUIDE again...

First, you need Microsoft SQL 2000.. you can get it at the following links:

Microsoft SQL 2000 = http://www.microsoft.com/downloads/d...displaylang=en

Microsoft SQL update = http://download.microsoft.com/downlo...2/sql2ksp3.exe

A Hex editor = http://www.chmaas.handshake.de/delph...vi32/xvi32.htm

Note: This server is meant to work on D drive not on C:/.. if you do not have a second HDD or drive, simply create a "virtual" drive by downloading this tool : Virtual Drive Creator

Install SQL... Go read the other threads on how to install if you don't know.. your server WILL NOT WORK if you screw the MSSQL 2000 installation..

Install SP3 for MS SQL 2000 (IMPORTANT)

Download the Server file and then unzip the file to D:/ (Make sure it is D:/A3server NOT D:/A3server/A3server..)

IMPORTANT: YOU NEED BDE.. either LOOK for it using google or use it from the 1.20 files.
If you FOLLOW all the steps I have mentioned, it should work...

First click start and go to Microsoft SQL server > Service Manager
Click START server

Go to D:/A3server.. There should be 17 Folders there...

Creating the Databases

Open the SQL server Enterprise manager.. >click start and go to Microsoft SQL server > Enterprise Manager
Go and add databases, A3ItemEvent, ASD, FriendDB, HSDB, character, itemstorage and clan

Restoring the Databases

You got to restore the DBs.. BUT, instead of looking endlessly for the BAK files in the A3server dir (cos you'll never find it), SQL scripts are PROVIDED instead..

In D:/A3server/Part3SQL
There should be some .SQL and .TXT files inside..

you might need certain files to restore the character itemstorage and clan DBs.. use the 1.20 ones..

click start and go to Microsoft SQL server > Query Analyser
Connect to your SQL server.. use your username and password..
After that, Click file and open; go to D:/A3server/Part3SQL and select ASD.sql
A whole list of commands should appear in the box.. RIGHT CLICK the box and click EXECUTE... Restoration of ASD DB is complete..

Now do the same method for the 3 other DBs using the table below.. you click new/Blank query for each time..

DATABASE : FILE
ASD : ASD.sql (DONE)
HSDB : A3HSDB.txt
FriendDB : Friend24.txt
A3ItemEvent : A3itemEvent.txt

for the other 3 DBs, use the 1.20 BAK files (I hope you know how to restore DBs)

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt (MAKE SURE the DBowner is A3itemevent!!)

its all on 新数据库配置说明.txt file...

(NOW THIS IS VERY IMPORTANT, screw this and you will 100% get a DB CONNECT ERROR)

This is the ODBC reg file that Akuraz posted in his guide:

YOU DON'T GO AND JUST RUN IT!! YOU MUST MANUALLY CREATE THE ODBC ENTRIES!!

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial list]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
"DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"="(Local)"

After that, change every single IP address to your IP address (192.168.X.X for LAN or your IP address for WAN) in all the .ini and .cfg files..

After that, LOOK at all the ini/cfg for your username and password and replace them respectively..

Create:

C:\A3log
C:\Clan
C:\Zonelog
C:\A3LogBackup
C:\A3_ClanMarkData

If all goes well, you can start your server;
do in the following order:

1- 01Account = 7770 dir
2- 02Character = 8880 dir
3- 03ItemStorage = 9990 dir
4- 04LoginServer = Loginserver dir
5- 05LoginAgent = Loginagent dir
6- 06Zoneagent = Zoneagent dir
7- 07MainServer= Mainserver dir
8- 08Accountserver= Accountserver dir
9- 09Zoneserver = Zoneserver dir (If it has Game init Error, LOOK the Guide again)
10- 10Battleserver = Battleserver dir

If all goes well, your server should be running.. next you must find a suitable client to run with your server.. you can try to find the ara3 client (which I think is impossible to find) or the A3 SG's client ; www.a3.com.sg or look for Toxic's clients... the Korean client is also possible
Like what I mention in my other guide, Hex the A3client.exe to change your IPs to your server's....

Another thing I would like to point out, run the server slowly one by one.. DON'T RUN ALL AT ONCE!! YOUR ZONESERVER WILL NOT WORK PROPERLY!!

dastorm · 07-09-2006

but wht to do with the xtra Dbs????? dont we have to create entries in ODBC for those????

Legendary · 07-09-2006

you check the 8880 and 9990.. check the TDB.ini... 8880 is for character so LOOK INSIDE THE TDB.ini and the ODBC NAME IS REPEATED MANY TIMES.. 9990 is for itemstorage..

suruchi_sogano1 · 07-26-2006

What re u posted entire guide for server 2.02 except the link to server file.
Post the missing one
:P

Legendary · 07-26-2006

READ THIS:

Quote:

First, you need the SERVER FILES : GO LOOK FOR THEM

Wassbr · 09-29-2006

Hey Legendary, can you tell me what i have to write in tdb.ini's?

is it like this? (example for 7770)

Quote:

[main]
title=database_name 7770
keepalive=10

[dbconnection]
00=h3db00 database_name sa sa_pwd account 0 1
01=h3db01 database_name sa sa_pwd account 1 1
02=h3db02 database_name sa sa_pwd account 2 1
03=h3db03 database_name sa sa_pwd account 3 1
...

[socket]
port=7770

because i wrote like that and it says "[ERR] Cannot connect"

Thanks.

Legendary · 09-30-2006

03=h3db03 database_name sa sa_pwd account 3 1

firstly, 7770 is the ASD database.. so you link the ASD DB with the A3ASD ODBC point. Let's say your sa username is sa and password is 123456

03=h3db03 A3ASD sa 123456 account 3 1

David10790 · 01-07-2007

Well i got every thing working after following ur guide except Zone Server but then in the end u said to re-check the guide "if ur getting an inf error)
After re-checking i was just missing one step or rather was not able to follow it >>

Quote:

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt (MAKE SURE the DBowner is A3itemevent!!)

its all on 新数据库配置说明.txt file...

Now the DB owner in ????????.txt is already A3Itemevent
n does this mean we have to create another Windows user account ,an A3 account or sm other account.....plz elaborate n help on this if u cn
Or could the reason for Zoneserver error be ODBC entries,but i checked n re-checked all entries according to 2 guides (urs n Akaruz's) but diddn't find ne mistakes (btw r the name's of ODBC entry "Local Ser ver" n "A3RcvRes ult" correct ?)

RudyMartin · 01-07-2007

Originally Posted by David10790

Well i got every thing working after following ur guide except Zone Server but then in the end u said to re-check the guide "if ur getting an inf error)
After re-checking i was just missing one step or rather was not able to follow it >>

Now the DB owner in ????????.txt is already A3Itemevent
n does this mean we have to create another Windows user account ,an A3 account or sm other account.....plz elaborate n help on this if u cn
Or could the reason for Zoneserver error be ODBC entries,but i checked n re-checked all entries according to 2 guides (urs n Akaruz's) but diddn't find ne mistakes (btw r the name's of ODBC entry "Local Ser ver" n "A3RcvRes ult" correct ?)

franlky, I have never seen the "?????.txt" file, nor it doesnt care to me.

you need a user for the SQL and another for the game. both are created on the SQL server using the appropiate tools. as for the ODBC entries, white spaces are *wrong*. most of the errors in the server and connection problems are ODBC related. double check them each time you have a problem.

rudy.

David10790 · 01-07-2007

Originally Posted by RudyMartin

franlky, I have never seen the "?????.txt" file, nor it doesnt care to me.

you need a user for the SQL and another for the game. both are created on the SQL server using the appropiate tools. as for the ODBC entries, white spaces are *wrong*. most of the errors in the server and connection problems are ODBC related. double check them each time you have a problem.

rudy.

Well these ??? are basically empty squares made by using alt + key pad no comibination but these boxes appear as "?" in RaGEZONE forums
N i have check all my SQL entries many times n they r exactly same as the ones in this guide (except those *wrong* gaps),they r in the same order n have string values n same orders too......dunno what seems to be the prob,having probs with Zoneserver only rest all is working fine :turned:

trixter · 01-07-2007

ya zoneserver creates prblms when odbc has prblms most of time !!!

**iNs@nE** · 01-08-2007

You never clearly stated your problem. But from the broken setences, I think your problem is the A3SERIAL Login. This is how you fix it.

First, go to SQL Enterprise Manager and go to Security>Logins
There make a new id called "a3serial" by the password you mentioned above. And set your master database as A3ItemEvent.
Go to the third tab and tick the A3ItemEvent as its DB Owner and click OK. This will make the login a3serial is owner. This should fix your problem.

David10790 · 01-08-2007

Originally Posted by iNs@nE

You never clearly stated your problem. But from the broken setences, I think your problem is the A3SERIAL Login. This is how you fix it.

First, go to SQL Enterprise Manager and go to Security>Logins
There make a new id called "a3serial" by the password you mentioned above. And set your master database as A3ItemEvent.
Go to the third tab and tick the A3ItemEvent as its DB Owner and click OK. This will make the login a3serial is owner. This should fix your problem.

In Security>Logins there already existed a a3serial but with a diffrent 8-character password n when i tried to replace this pas with the one provided in the guide it reverted to the before one (8-char).....n yes this pass matches the sa pass (in characters only,so dunno if its the same)

**iNs@nE** · 01-08-2007

No. Delete the Login and make another one with this password. You SA can be the same as this one, but this one has to be the one mentioned in the guide.

rohit_jo890 · 01-14-2007

i stucked in Bde process can any 1 guide where can i get it .. 1 downloaded 1 but its not installing error message occure Need C++ 5.0 smthing ...can any 1 guide me or where can i get the right one plzplz

**iNs@nE** · 01-14-2007

Search Google for Borland's Database Engine...you will get it..!!
Try try or die..! Simple..!!

Zarz · 02-15-2007

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Friend ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3RcvRes ult ult]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\A3Serial list]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="A3ItemEvent"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\EventA3]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\FriendDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\HSDB]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="HSDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LETTERDB ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="FriendDB"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalSer ver]
"Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Login202 ]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\NEWASD]
"Driver"="C:\\WINDOWS\\System32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="ASD"
"LastUser"="sa"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LocalServer"="SQL Server"
"A3RcvResult"="SQL Server"
"A3SerialList"="SQL Server"
"FriendDB"="SQL Server"
"NEWASD"="SQL Server"
"Login202"="SQL Server"
"LETTERDB"="SQL Server"
"EventA3"="SQL Server"
"A3Friend"="SQL Server"
"HSDB"="SQL Server"

WHERE HAVE I TIO WRITE THIS text?????

**iNs@nE** · 02-15-2007

OMG! Sincere opinion. Do not make the server.

But I am here to help. So I will tell you what.
Copy them into a word pad and save the file as ODBC.reg
Then double click it and register them.
Once that is done, go verify the ODBC's in Control Panel>Administrative Tools>Data Sources>ODBC

**iNs@nE** · 02-15-2007

@ Legendary

Dude, This is one of the simplest and perfect guides possible. Maybe you just make this a sticky. Think about it.

Yag4mi2k · 02-15-2007

you InS@ne could answer to that it sees this image, that error would be this?

http://img63.imageshack.us/img63/7122/imagemnq7.th.jpg

**iNs@nE** · 02-15-2007

How brillaint! You posted the link to a thumbnail in which I cant view anything at all.

RudyMartin · 02-16-2007

http://img63.imageshack.us/img63/7122/imagemnq7.jpg

just eliminate the .th

anyway, its just another ODBC problem.

**iNs@nE** · 02-17-2007

Ah! Amazing..!!
Exactly as Rudy said. Please refer other posts. Search for ODBC on the forum and look for my post. I clearly explained there how to register the ODBC's correctly.

fort_knox · 06-05-2007

Quote:

Next, go and Create a new user login;

Create a new user,

Login = a3serial
Password = dkdlxpawprhdnpc

Set DB Owner = A3ItemEvent.txt (MAKE SURE the DBowner is A3itemevent!!)

its all on 新数据库配置说明.txt file...

can someone please help me out with this?
donno where to put it