[Guide] Setting up a Dragonica 0.15.12 Server

[TGfeu001]

Hi,

Setting up a Dragonica server in only 30 little steps, it must long and hard
No, easy as hell, the only hard thing was to think about everything of memory in this guide

(You must have installed .net framework 4 and visual studio C++)

Creating a Dragonica Server is easy, I didn't even needed a guide for the 0.14.10 and 0.15.12 files but I make a guide anyway for peoples.

So let's go !

~~~Setting Up the Database~~~

1.Once you have the Database and Serverfiles, go to the Database, copy all, and paste all to :
"C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackup"

2.Launch MSSQL, then, In MSSQL 2008R2, connect to your account, then Right Click on "Databases" and select "Restore Database..."

3.Click on "From Device" and select the Browse button ( [...] )

4.Make sure that "Backup media" is set on "File" and click on Add.

5.Now, select the .bak file you want to restore (DR2_Def) and click "Ok"

6.Then, a new window must pop-up. In front of "To database", you'll write the name of the database you're restoring. And check the box on the "Restore" tab.

7.Click on Options (on the left), check "Overwrite the existing database (WITH REPLACE)" and click on "Leave the database ready to use by..." (I'm lazy to write the rest)

8.And click on "OK" !!!

9.Now you know how to restare a database, do it for all the .bak files.

/!At the step 6, make sure to write well the databases names/!

Databases names :

DR2_Def
DR2_GM
DR2_Local
DR2_Log
DR2_Member
DR2_SiteConfig
DR2_User

10.You should have restored all the .bak files, well done !

11.Open the Database DR2_SiteConfig inside MSSQL and right click on "dbo.TB_Realm_1" and select "Edit all Rows"

/!If you do not have the "Edit All Rows" option, then click on "Tools>Options", Click in SQL Server Object Explorer and than in the "Table and View Options" change the value 200 to 0/!

12.Replace all the fields with written "YOUR IP" or "127.0.0.1" (I don't exactly remember) by your IP. (127.0.0.1 if you wish to make your server on local)

13.Do the same for dbo.TB_SiteServer !

/!Don't put your IP everywhere you see "NULL"/!

~~~Options for the Database !!!~~~

-To translate the CashShop categorie tab names, then expand "DR2_Local", expand "Tables", then Right click on "dbo.TB_Common_CashItemCategory", select the option "Edit all Rows" and edit the values you want to translate.

14.Verify that in MSSQL :
Expand "Security" and "Logins", right click on "sa" -> "Proprieties"
On the left, click on the "User Mapping" tab and make sure that "db_owner " is checked for all the databases. Then "Ok"

/!If you do not do this, your character's items IG won't be saved./!

15.You're done with the Database !!!

~~~Setting Up the Serverfiles~~~
16.Now, the borring part...

17.Go inside your serverfiles folder, then "GC" and edit all the .ini files with your settings.

Exemple :

ADDR = PUT YOUR IP OR SQL ADRESS,1433 Never change the Port
NAME = DR2_SiteConfig Never change the name of the Database
ID = sa
PW = PW

18.In MMC.ini and the end, just put 1 as ID and PW

Exemple :

[USER_INFO_1]
ID = 1
PW = 1
IP = 127.0.0.1
GRADE = 10

It is the ID and PW that you'll need to enter to log in the ServerControl.

19.And in Local.ini, change the values according to this :

[LOCAL_INFO]
NATION_CODE = SINGAPORE
SERVICE_REGION = SINGAPORE
LANGUAGE = ENGLISH
SERVICE_TYPE = 2

20.Now, move to "DragonicaServer files 0.15.12Patchconfig" and edit all the .ini files with your settings.

21.For the Local.ini file, change the values according to this :

[LOCAL_INFO]
NATION_CODE = SINGAPORE
SERVICE_REGION = SINGAPORE
LANGUAGE = ENGLISH
SERVICE_TYPE = 2

22.If you wanna stay in local, skip this step. Go back in your main server files folder and edit "2.bat" and change "127.0.0.1" by your IP.

23.Done with the config !!!

~~~Start the Server~~~

24.Start in the order 1.bat, 2.bat and then 3.bat

If ServerControl (3.bat) doesn't start, try first to launch it manualy by going inside the GC folder and start it with "Run as Admin" (Right click)
If it still doesn't work download all the Microsoft Visual C++ librarys you can find.

Lazy hmm ? Yeh I understand, it took several days to find the good one... So here's my package (run all of them)

M.VC.rar

Alright, now you've start the ServerControl once MMC and SMC finished initialized, you'll login with the ID and PW you've set in the MMC.ini file (It's ID : 1 and PW : 1 if you've set the values according to my exemple)

25.Inside ServerControl, Click on Immigration and on left, down from the "Refresh" Button, click on "On" then "Ok".

26.Then start everything in the order you want. (Becarfull, it takes a lot of RAM)

27.Play ! Create a .bat if the values :

start .releaseDRAGONICA.EXE /NoGsm /LaunchByLauncher /ServerAddr:""127.0.0.1"" /ServerPort:""11201"" /SiteName:""""
exit

28.Replace the "127.0.0.1" by your IP server if you're not in local.

29.To stop the server, don't shut down all the windows, just select everything in the ServerControl and click on "Off"

30.That's it, you have your own Dragonica server !


How to create an account ?

Use the stored precedure called :
dbo.up_CreateMemberAccount

Here :
DR2_Member > Probality > Stored Procedures > dbo.up_CreateMemberAccount (R) > Execute stored procedure.

And you put inside :
UID = 0 (allways)
ID = username
PW = password
Gender = 0/1 , 0 male / 1 female
Birthday =" whatever you want date* like this = 2011-07-10 16:25:45.670
And then hit "Ok" !


Errors :

If you get your MMC closed 1 or 2 sec after having launched (+ dump error in the MMC folder) then, juste remove the port adress in all the .ini configs. Exemple : something like "ADDR = PCNAME\SQLEXPRESS" or "ADDR = IP"(without port ! ex. : ,1433)
Some people have this error on some kind of computer when they try to make the server run on local.

Credit to Unintended for having searched the fix of this unknown error ^^

Got an other problem ?

Re-run the guide from start, read all the discusion, search answers on google and if you don't find anything, post a comment, I'll probably help you

Please, to thank me for all my work, read the ReadMe.txt file inside the .rar file or in the Attached files and do what it asks (Subscribing to my Youtube Channel, that would please me so much.)



My other threads :
http://forum.ragezone.com/f733/share...5-12-a-871065/
http://forum.ragezone.com/f733/reala...0/#post7194629
http://forum.ragezone.com/f733/share...5-12-a-871317/

[MentaL]

[yoganeh]

NICE tutorial ! now my server is running
btw can you recommended me what is the important map to run ?
I run all of the map take 8gb ram lol
i have no idea what the map is most important ( I just try dragonica today )
and btw why is my npc name chinese ? can we translate it ? if yes how ? thanks :D

you're the man

[TGfeu001]

Hmmm.. I would recommend the 9 first map, the 2 last maps. And not the copy maps and nether the pvp.

[cybernight]

I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!

[Evol]

Help me plz Server Start done, login ok and etc. but when char is relogin all item's disappear (in inventory), problem is on Contents server it all the time give me err-102 when char is gathering\purchases loot

[mon3181402]

LAN don't work

i changed all ip follow your guide (192.168.10.10 my lan ip)

but don't work

client said "Cannont Connect to Server"

how to fix ?

[yoganeh]

I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!

are you already set the data base ?
make owner_db for all database ?
cek the ip setting on folder

[cybernight]

I set all my ip's to 127.0.0.1 and left all the ports as they were. and my databases all have db_owner rights. but when i start the second bat i get failed to connect to mmc, then something pops up. it says MMC_release.exe - no disk, then it says, There is no disk in the drive. please insert a disk into drive\Device\Harddisk\DR3. and then there are 3 buttons cancel, try again, and continue.

[kzenopro]

[/url]
help me, please

[Darky]

[/url]
help me, please

Image too small, And check db configs @ config folder.

[yoganeh]

why i cant login anymore ?
how to add account
server are run perfectly
but always please check your id -_-a
how to solve ?

[Luminares]

Image too small, And check db configs @ config folder.

That error there is the one cybernight was talking about and i have the same problem also. Everything is set up to the bone but whenever i run bat 1 and then bat 2. Bat to fails to connect and bat 1 gets that error shown and closes. Any ideas?

[yoganeh]

install micorosft net framework 2

[jenose]

what the problem i got?

LV-07,22:50:02,==================== Server Initialize Start ====================

LV-07,22:50:02,Product Version : 0.9.29.6
LV-07,22:50:02,File Version : 0,1,1,0
LV-07,22:50:02,Protocol Version : 10.04.05.1
LV-00,22:50:02,[CEL::CDBConnection::OpenDB]-[112] Open=Provider = SQLOLEDB.1; D
ata Source=.\SQLEXPRESS; Initial Catalog=DR2_SiteConfig; User Id=sa; Password=**************; Packet Size = 16384; Use Procedure for Prepare = 1; Auto Translate =
True Failed=0x80040E4D
LV-01,22:50:02,-=-=-=-=-=- ASSERT_LOG -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LV-01,22:50:02,[OnRegist]-[17] OnRegist Failed Type = 3
LV-01,22:50:02,-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=
*==============LV-01,22:50:02,-=-=-=-=-=- ASSERT_LOG -=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-==
======LV-01,22:50:02,[OnRegist]-[17] OnRegist Failed Type = 3=
=======LV-01,22:50:02,-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-==
==============================*
Unhandled excetpion triggerd!
Date / Time : [08/27/12 22:50:02]
ProcessID / ThreadID : [0x000004C8] / [0x00000150]
ExceptionCode : [0x80000003]
CommandLine : MMC_Release.exe /SERVER_NO=900 /RUN_MODE=INI
Writing Dump....
*============================================================*

[TGfeu001]

I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!

You must launch first MMC, then when its initialized properly, launch SMC and then ServerControl and then Immigration.
If done and doesn't solved, just check out if all your config is right.

Help me plz Server Start done, login ok and etc. but when char is relogin all item's disappear (in inventory), problem is on Contents server it all the time give me err-102 when char is gathering\purchases loot

You've just forgotten to set the rights on your "sa" user.
Step 14 ! Verify that in MSSQL :
Expand "Security" and "Logins", right click on "sa" -> "Proprieties"
On the left, click on the "User Mapping" tab and make sure that "db_owner " is checked for all the databases. Then "Ok" (do not uncheck the already checked box(s) !!)

LAN don't work

i changed all ip follow your guide (192.168.10.10 my lan ip)

but don't work

client said "Cannont Connect to Server"

how to fix ?

LAN Ip is ONLY 127.0.0.1

I set all my ip's to 127.0.0.1 and left all the ports as they were. and my databases all have db_owner rights. but when i start the second bat i get failed to connect to mmc, then something pops up. it says MMC_release.exe - no disk, then it says, There is no disk in the drive. please insert a disk into drive\Device\Harddisk\DR3. and then there are 3 buttons cancel, try again, and continue.

Can you explain better please ?
Before that, make sure all the configs and db in set right.
Maybe if you using a VM (Virtual Machine) this one isn't set right.
Try to see with "compmgmt.msc" if something is wrong with your hard drive.

[/url]
help me, please

If thing you havn't set well everything.. Try to follow my guide precisly again and only do what it is asked for. My guide is 100% complete.

why i cant login anymore ?
how to add account
server are run perfectly
but always please check your id -_-a
how to solve ?

How to create an account ?

Use the stored precedure called :
dbo.up_CreateMemberAccount

Here :
DR2_Member > Probality > Stored Procedures > dbo.up_CreateMemberAccount (R) > Execute stored procedure.

And you put inside :
UID = 0 (allways)
ID = username
PW = password
Gender = 0/1 , 0 male / 1 female
Birthday =" whatever you want date* like this = 2011-07-10 16:25:45.670
And then hit "Ok" !






Alright ! That's it !
Sorry, I was gone for a while ^^