[Help] DBServerT It closes automatically.

adriannx · 04/18/2017, 07:45

Hello to all the community Elitepvpers, especially the Rohan section.
First, I'm sorry to bother creating a topic like this.

I'm setting up a rohan private server for the first time, but in the process I hit a wall and I can not go forward, look at google and unfortunately I did not get good answers.

Rohan's private server is mounting it on my dedicated server.

Details of the Dedicated Server
System Operating: Windows Server 2016 64 Bits
RAM: 16
Processor: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz
Hard Disk: HDD 4TB
Port Connection: 1GB/s Duplex

I'm using Files from RitoYuuki:

Attempt to start 'DBServerT' after 10 seconds closes automatically. What could be causing this problem?

My settings
- I have everything well configured, following the instructions shown in this video:

- I have enabled and configured Registry_ROHAN 64 bit and 32Bits

- I have also configured the 'DBConfig' file by adding the IP 46.4.74.70, the file is located at: C:\RoHan\RoHan\Fairy\DBServer

IP Configutation
Everything I have configured with this IP: 46.4.74.70
Capture:

SQL Server Network Configuration TCP/IP
I have 'TCP / IP' enabled but the problem still persists. I was told to disable the firewall (I have not tried it yet), but if I do, how can I connect to the server?

Error Log
This is the error that is displayed in the LOG file:
(The file 'LOG' is located at:C:\RoHan\RoHan\Log )

20170418-000017 dbm0-2

Code:

00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). 0x00000000
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 5 
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 4 
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 3 
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 2 
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 1 
00:00:34 004df0a8 [LoginDBM] Destroy WORK THREAD 0

Would someone please be so kind as to guide me on the right path?

Best Regards!
Adrian

hokori219 · 04/18/2017, 08:46

oziel235 · 04/18/2017, 09:00

Check IP in Registry_ROHAN and try with other database.

adriannx · 04/18/2017, 09:28

Quote:

Originally Posted by oziel235

Check IP in Registry_ROHAN and try with other database.

Hello, thanks for answering.

I have carefully reviewed the 'Registry_ROHAN' file 64bit and 32bit; everything is correct. Try to turn on the server with the same database and again I get the same problem "DBServerT It closes automatically".

When you say "with other database", it means that should I download a database published by another user in the forum?

This is my configuration Registry_ROHAN 64Bits:

Spoiler

Code:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet]
"Nation"="TH"
"ServerDir"="C:\\RoHan\\RoHan"
"LogDir"="C:\\RoHan\\RoHan\\Log"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\AI]
"ConnMap"="1-0|1-1|1-2|1-3|1-4|5-0|5-1|5-3|5-4|5-5|3-0|3-1"
"DBServer"="46.4.74.70:22500"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.AI.ROHAN_4_1"
"ServerClassMap"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4"
"ThreadSleep"=dword:0000005f
"Module"="C:\\RoHan\\RoHan\\Fairy\\AIServer.exe"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\DB]
"ServerClass"="FAIRY.ROHAN_4.DB.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\DBServer\\DBServerT.exe"
"LoginDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanUser"
"GameDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanGame"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\Interrupt]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\LOG]
"DBServer"="46.4.74.70:22500"
"ServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\LogServer\\LogServer.exe"
"LogDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=rohanstat"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\LogCopy]
"LogFTP_IP"="46.4.74.70"
"LogFTP_ID"="rohan-dev"
"LogFTP_PW"="dlsehvotm!@#$"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\MAP]
"Title"="Map TH"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClassAI"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.MAP.ROHAN_4"
"DBServer"="46.4.74.70:22500"
"Module"="C:\\RoHan\\RoHan\\Fairy\\MapID\\MapID.exe"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\Monitor]
"CodeDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanCode;"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\RelayCom]
"ConfigPath"="D:\\Fairy\\RelayCom\\RelayCom.config"
"LogPath"="d:\\Log\\RelayCom"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\RelayCom\Consign]
"config"="D:\\Fairy\\RelayCom\\Consign.config"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\RelayCom\Login]
"ip"="46.4.74.70"
"port"=dword:000071ac
"poolsize"=dword:0000001e

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Gamenet\RohanCom]
"ConfigPath"="C:\\sslcer\\Fairy\\RohanCom\\RohanCom.config"
"LogPath"="C:\\sslcer\\Fairy\\Log\\RohanCom"
"LanguageID"="KRKSC"

Registry_ROHAN 32Bits

Spoiler

Code:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind]

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet]
"Nation"="TH"
"ServerDir"="C:\\RoHan\\RoHan"
"LogDir"="C:\\RoHan\\RoHan\\Log"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\AI]
"ConnMap"="1-0|1-1|1-2|1-3|1-4|5-0|5-1|5-3|5-4|5-5|3-0|3-1"
"DBServer"="46.4.74.70:22500"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.AI.ROHAN_4_1"
"ServerClassMap"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4"
"ThreadSleep"=dword:0000005f
"Module"="C:\\RoHan\\RoHan\\Fairy\\AIServer.exe"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\DB]
"ServerClass"="FAIRY.ROHAN_4.DB.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\DBServer\\DBServerT.exe"
"LoginDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanUser"
"GameDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanGame"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\Interrupt]

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\LOG]
"DBServer"="46.4.74.70:22500"
"ServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\LogServer\\LogServer.exe"
"LogDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=rohanstat"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\LogCopy]
"LogFTP_IP"="46.4.74.70"
"LogFTP_ID"="rohan-dev"
"LogFTP_PW"="dlsehvotm!@#$"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\MAP]
"Title"="Map TH"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClassAI"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.MAP.ROHAN_4"
"DBServer"="46.4.74.70:22500"
"Module"="C:\\RoHan\\RoHan\\Fairy\\MapID\\MapID.exe"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\Monitor]
"CodeDB"="DRIVER={SQL Server};SERVER=WIN-1LQ7KVAVV8G;UID=sa;PWD=Ondres12;DATABASE=RohanCode;"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\RelayCom]
"ConfigPath"="D:\\Fairy\\RelayCom\\RelayCom.config"
"LogPath"="d:\\Log\\RelayCom"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\RelayCom\Consign]
"config"="D:\\Fairy\\RelayCom\\Consign.config"

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\RelayCom\Login]
"ip"="46.4.74.70"
"port"=dword:000071ac
"poolsize"=dword:0000001e

[HKEY_LOCAL_MACHINE\SOFTWARE\Geomind\Gamenet\RohanCom]
"ConfigPath"="C:\\sslcer\\Fairy\\RohanCom\\RohanCom.config"
"LogPath"="C:\\sslcer\\Fairy\\Log\\RohanCom"
"LanguageID"="KRKSC"

Best Regards!
Adrian

kristian4 · 04/18/2017, 16:57

Tried with US nation and 127.0.0.1 IP?

hokori219 · 04/18/2017, 17:09

These instructions are deceptive this is not OK, rohan cannot run or do not play.

adriannx · 04/18/2017, 17:25

Hello guys!

UPDATE
It's like Oziel said, I just had to verify the name of the database. I had not noticed some very important, the name of my Mysql was very big that it was very difficult for the 'Registry_ROHAN' to recognize it at the time of executing it.

Anyway thanks for replying: Oziel, hokori219, kristian4.

Hokori219, The video you shared made me realize my mistake. Thank you! hehe

My new doubt.
Now that I have taken a new step, I have a doubt. Because I am mounting the server rohan to my dedicated server, how do I connect from my PC on home? For this the game must be open publicly? If so, what should I configure to do it public?

Best Regards!
Adrian

oziel235 · 04/18/2017, 17:47

Quote:

Originally Posted by adriannx

Hello guys!

UPDATE
It's like Oziel said, I just had to verify the name of the database. I had not noticed some very important, the name of my Mysql was very big that it was very difficult for the 'Registry_ROHAN' to recognize it at the time of executing it.

Anyway thanks for replying: Oziel, hokori219, kristian4.

Hokori219, The video you shared made me realize my mistake. Thank you! hehe

My new doubt.
Now that I have taken a new step, I have a doubt. Because I am mounting the server rohan to my dedicated server, how do I connect from my PC on home? For this the game must be open publicly? If so, what should I configure to do it public?

Best Regards!
Adrian

Create rule in firewall open this ports: 80, 22100

First test - open browser with this link

- check if show its:

PHP Code:



YourNameServer|46.4.74.70|22100|3|3|1|0|0|0|YourName|

IF no show check modules mssql / sql_server Enabled in xampp.

IF show try connect your game.
File bat:

PHP Code:



@echooff
start rohanclient.exe "http://46.4.74.70&1&US"

adriannx · 04/18/2017, 20:28

Quote:

Originally Posted by oziel235

Create rule in firewall open this ports: 80, 22100

First test - open browser with this link - check if show its:

PHP Code:

YourNameServer|46.4.74.70|22100|3|3|1|0|0|0|YourName|

IF no show check modules mssql / sql_server Enabled in xampp.

IF show try connect your game.
File bat:

PHP Code:

@echooff start rohanclient.exe "http://46.4.74.70&1&US"

Hello Oziel, thanks for reply.

I followed your instructions but I have not yet been able to connect to the game from my home computer.

Note: The server rohan is working properly and I have a connection from my computer to:

These are my configurations

My server is from germany, so set it 'rungame.bat' like this:

Code:

@echo off
start rohanclient.exe "http://46.4.74.70&1&DE"

Also try it as you said it:

Code:

@echo off
start rohanclient.exe "http://46.4.74.70&1&US"

Ports added in this way:

I'm using client Epic rohan with mini patch from Yolo Rohan.
The only thing I edited was the file 'rungame.bat' to change the IP.

What am I doing wrong?

Best Regards!
Adrian

~~RitoYuuki~~ · 04/18/2017, 20:40

Use Windows Server 2008 R2 SP1 64 Bit.
I never had Problems with that.

adriannx · 04/18/2017, 20:52

Quote:

Originally Posted by RitoYuuki

Use Windows Server 2008 R2 SP1 64 Bit.
I never had Problems with that.

Hello, RitoYuuki!

Can't change my server for other Q.Q

Anyway, I do not think that's the problem. The only problem I am presenting at the moment is the fact that I can not connect to the game, I get an error 'HTTP_SERVER_STATUS_ERROR'

The server rohan files mounted on my dedicated is running perfectly.

Regards!

oziel235 · 04/19/2017, 00:58

Quote:

Originally Posted by adriannx

Hello, RitoYuuki!

Can't change my server for other Q.Q

Anyway, I do not think that's the problem. The only problem I am presenting at the moment is the fact that I can not connect to the game, I get an error 'HTTP_SERVER_STATUS_ERROR'

The server rohan files mounted on my dedicated is running perfectly.

Regards!

Check database Nation and Regedit 32/64bits
Try with other rohanclient.exe ... client of Epic rohan no work.

adriannx · 04/19/2017, 02:08

Hello Oziel, thanks for reply.

About database Nation, I can not find detailed information on how to change the nationality code on database. Could you help me with this? and
I have also read, that regedit 64/32 bits must have the same nationality code of the database?

Regards!

hokori219 · 04/19/2017, 03:40

I need it
Where can I download the client Epic Rohan tell me?

Check your registry, "country" should be = US is not "TH"
Second, go to your SQL TDownFlag> RohanUser> to "US"
RohanUser> TServerGroup> "US",

RohanUser> TDownFlag

RohanUser> TServerGroup

adriannx · 04/19/2017, 06:40

Quote:

Originally Posted by hokori219

I need it
Where can I download the client Epic Rohan tell me?

Check your registry, "country" should be = US is not "TH"
Second, go to your SQL TDownFlag> RohanUser> to "US"
RohanUser> TServerGroup> "US",

RohanUser> TDownFlag

RohanUser> TServerGroup

Hello!
Thanks for reply.

I have set up just like you said, but I still can not connect to the game from my home computer.

My rohan database is this version: 1,0,4,904
So far I have not managed to get a client with the same version.

New question
How do I change the IP of 'Launcher Client'? I have searched the forum and the only way I found it is using 'Hex Editor'. I've been testing it, but I have not been able to locate the IP to change it.

Any suggestion?

Best Regards!
Adrian

Quote:

Originally Posted by oziel235

Check database Nation and Regedit 32/64bits
Try with other rohanclient.exe ... client of Epic rohan no work.

Hello again Oziel
I finally change the country code. But I still do not connect to the game. Should I change the IP of 'LauncherClient.exe' right?

Because I do not see it's working by editing the file 'rungame.bat'

Best Regards!
Adrian