SR_GameServer ini

12/03/2023 15:09 libiibi#1
Hello guys,

I have problems with my private server…
I want to start the GameServer but it doesn’t connect to database, to what I should change the gameserver ini file to get a connection to DB ?

Can some one help me with a result ?

The server is on a VM
12/03/2023 15:35 Judgelemental#2
Quote:
Originally Posted by libiibi View Post
Hello guys,

I have problems with my private server…
I want to start the GameServer but it doesn’t connect to database, to what I should change the gameserver ini file to get a connection to DB ?

Can some one help me with a result ?

The server is on a VM
Hello.
It's probably the .ini files inside the certification folder. We can't know for sure unless you post it here.

Also, there are many tutorials you can follow:

12/03/2023 15:50 libiibi#3
Quote:
Originally Posted by Judgelemental View Post
Hello.
It's probably the .ini files inside the certification folder. We can't know for sure unless you post it here.

Also, there are many tutorials you can follow:

Thanks for the quick answer,
I just made it like in the tutorial but there is a wrong line i can post the lines from gameserver ini in a minute

Here are the lines


Sql]

; SQL Server address or name
HOST=SILK\SQLEXPRESS

; SQL Server port
PORT=1433

; Username credential
USER=sa

; Password credential
PASS=1234

; Name used for the specified silkroad database
DB_SHARD=SRO_VT_SHARD

; Table name used to execute actions
DB_SHARD_FETCH_TABLE=_ExeGameServer

; Name used for the specified silkroad database
DB_LOG=SRO_VT_SHARD


[Server]

; Maximum level that can be reached on server
LEVEL_MAX=110

; Maximum price that can be stalled
STALL_PRICE_LIMIT=500000000000

; Minimum level to create a party group
PARTY_LEVEL_MIN=5

; Party members required to find monsters party type
PARTY_MOB_MEMBERS_REQUIRED=2

; % Probability for party mob spawns
PARTY_MOB_SPAWN_PROBABILITY=30

; Level required to kill other player
PK_LEVEL_REQUIRED=20

; Minimum level to apply drop penalty
PENALTY_DROP_LEVEL_MIN=10

; % Probability to drop an item when a player dies
PENALTY_DROP_PROBABILITY=1

; Maximum level for resurrect at the same map position
RESURRECT_SAME_POINT_LEVEL_MAX=10

; Maximum level for using "Return to last dead point" from NPC Guide
NPC_RETURN_DEAD_LEVEL_MAX=20

; Maximum level to show the beginner mark
BEGINNER_MARK_LEVEL_MAX=10

; % Probability to drop items with blue options
DROP_ITEM_MAGIC_PROBABILITY=30


[Job]

; Maximum level that can be reached on job suit
LEVEL_MAX=7

; Disable Thief/Hunter monster spawn while trading
DISABLE_MOB_SPAWN=false

; Minimum level to enter the Temple Area
TEMPLE_LEVEL=105


[Race]

; Masteries amount Chinese will obtain
CH_TOTAL_MASTERIES=330

[Guild]

; Guild members capacity at level 1
MEMBERS_LIMIT_LEVEL1=15

; Guild members capacity at level 2
MEMBERS_LIMIT_LEVEL2=20

; Guild members capacity at level 3
MEMBERS_LIMIT_LEVEL3=25

; Guild members capacity at level 4
MEMBERS_LIMIT_LEVEL4=35

; Guild members capacity at level 5
MEMBERS_LIMIT_LEVEL5=50

; Storage slots at first level
STORAGE_SLOTS_MIN=30

; Storage slots increased per level
STORAGE_SLOTS_INCREASE=30

; Union participants limit
UNION_LIMIT=4

; Union chat participants allowed by guild
UNION_CHAT_PARTICIPANTS=25


[Academy]

; Penalty time (seconds) to create again the group
DISBAND_PENALTY_TIME=604800


[Alchemy]

; Waiting delay (seconds) after fusing alchemy elements
FUSING_DELAY=3

; Value from astral stones used to stop and prevent +0
STONE_ASTRAL_VALUE=5


[Event]

; Item reward from winning Capture The Flag
CTF_ITEM_WIN_REWARD=ITEM_ETC_E080723_ICETROPHY

; Amount to obtain by winning
CTF_ITEM_WIN_REWARD_AMOUNT=1

; Item reward from killing at Capture The Flag
CTF_ITEM_KILL_REWARD=ITEM_ETC_E080723_ICETROPHY

; Amount to obtain by kill
CTF_ITEM_KILL_REWARD_AMOUNT=1

; Item reward from Battle Arena
BA_ITEM_REWARD=ITEM_ETC_ARENA_COIN

; Amount to obtain winning on Guild/Job mode
BA_ITEM_REWARD_GJ_W_AMOUNT=7

; Amount to obtain loosing
BA_ITEM_REWARD_GJ_L_AMOUNT=2

; Amount to obtain winning on Party/Random mode
BA_ITEM_REWARD_PR_W_AMOUNT=5

; Amount to obtain loosing
BA_ITEM_REWARD_PR_L_AMOUNT=1


[Fix]

; Set capacity supported by the connected agent server
AGENT_SERVER_CAPACITY=1000

; Fix rates (ExpRatio/1000) to use higher values than 2500
HIGH_RATES_CONFIG=true

; Log unique spawn/killed into _AddLogChar as EventID = 32/33
UNIQUE_LOGS=true

; Disable buff with the green book
DISABLE_GREEN_BOOK=true

; Disable messages about "register silk/gold price."
DISABLE_MSGBOX_SILK_GOLD_PRICE=true

; Remove attack cancel when player exchanges
EXCHANGE_ATTACK_CANCEL=true

; Cancel exploit sent from client (0x70A7)
EXPLOIT_INVISIBLE_INVINCIBLE=true

; Prevents negative values on guild points
GUILD_POINTS=true


[App]

; Attach debug console
DEBUG_CONSOLE=true


how i cant connect to DB ?

what should i do can u help me ?

best Regard
12/03/2023 15:57 Judgelemental#4
Quote:
Originally Posted by libiibi View Post
Thanks for the quick answer,
I just made it like in the tutorial but there is a wrong line i can post the lines from gameserver ini in a minute

Here are the lines


Sql]

; SQL Server address or name
HOST=SILK\SQLEXPRESS

; SQL Server port
PORT=1433

; Username credential
USER=sa

; Password credential
PASS=1234

; Name used for the specified silkroad database
DB_SHARD=SRO_VT_SHARD

; Table name used to execute actions
DB_SHARD_FETCH_TABLE=_ExeGameServer

; Name used for the specified silkroad database
DB_LOG=SRO_VT_SHARD


[Server]

; Maximum level that can be reached on server
LEVEL_MAX=110

; Maximum price that can be stalled
STALL_PRICE_LIMIT=500000000000

; Minimum level to create a party group
PARTY_LEVEL_MIN=5

; Party members required to find monsters party type
PARTY_MOB_MEMBERS_REQUIRED=2

; % Probability for party mob spawns
PARTY_MOB_SPAWN_PROBABILITY=30

; Level required to kill other player
PK_LEVEL_REQUIRED=20

; Minimum level to apply drop penalty
PENALTY_DROP_LEVEL_MIN=10

; % Probability to drop an item when a player dies
PENALTY_DROP_PROBABILITY=1

; Maximum level for resurrect at the same map position
RESURRECT_SAME_POINT_LEVEL_MAX=10

; Maximum level for using "Return to last dead point" from NPC Guide
NPC_RETURN_DEAD_LEVEL_MAX=20

; Maximum level to show the beginner mark
BEGINNER_MARK_LEVEL_MAX=10

; % Probability to drop items with blue options
DROP_ITEM_MAGIC_PROBABILITY=30


[Job]

; Maximum level that can be reached on job suit
LEVEL_MAX=7

; Disable Thief/Hunter monster spawn while trading
DISABLE_MOB_SPAWN=false

; Minimum level to enter the Temple Area
TEMPLE_LEVEL=105


[Race]

; Masteries amount Chinese will obtain
CH_TOTAL_MASTERIES=330

[Guild]

; Guild members capacity at level 1
MEMBERS_LIMIT_LEVEL1=15

; Guild members capacity at level 2
MEMBERS_LIMIT_LEVEL2=20

; Guild members capacity at level 3
MEMBERS_LIMIT_LEVEL3=25

; Guild members capacity at level 4
MEMBERS_LIMIT_LEVEL4=35

; Guild members capacity at level 5
MEMBERS_LIMIT_LEVEL5=50

; Storage slots at first level
STORAGE_SLOTS_MIN=30

; Storage slots increased per level
STORAGE_SLOTS_INCREASE=30

; Union participants limit
UNION_LIMIT=4

; Union chat participants allowed by guild
UNION_CHAT_PARTICIPANTS=25


[Academy]

; Penalty time (seconds) to create again the group
DISBAND_PENALTY_TIME=604800


[Alchemy]

; Waiting delay (seconds) after fusing alchemy elements
FUSING_DELAY=3

; Value from astral stones used to stop and prevent +0
STONE_ASTRAL_VALUE=5


[Event]

; Item reward from winning Capture The Flag
CTF_ITEM_WIN_REWARD=ITEM_ETC_E080723_ICETROPHY

; Amount to obtain by winning
CTF_ITEM_WIN_REWARD_AMOUNT=1

; Item reward from killing at Capture The Flag
CTF_ITEM_KILL_REWARD=ITEM_ETC_E080723_ICETROPHY

; Amount to obtain by kill
CTF_ITEM_KILL_REWARD_AMOUNT=1

; Item reward from Battle Arena
BA_ITEM_REWARD=ITEM_ETC_ARENA_COIN

; Amount to obtain winning on Guild/Job mode
BA_ITEM_REWARD_GJ_W_AMOUNT=7

; Amount to obtain loosing
BA_ITEM_REWARD_GJ_L_AMOUNT=2

; Amount to obtain winning on Party/Random mode
BA_ITEM_REWARD_PR_W_AMOUNT=5

; Amount to obtain loosing
BA_ITEM_REWARD_PR_L_AMOUNT=1


[Fix]

; Set capacity supported by the connected agent server
AGENT_SERVER_CAPACITY=1000

; Fix rates (ExpRatio/1000) to use higher values than 2500
HIGH_RATES_CONFIG=true

; Log unique spawn/killed into _AddLogChar as EventID = 32/33
UNIQUE_LOGS=true

; Disable buff with the green book
DISABLE_GREEN_BOOK=true

; Disable messages about "register silk/gold price."
DISABLE_MSGBOX_SILK_GOLD_PRICE=true

; Remove attack cancel when player exchanges
EXCHANGE_ATTACK_CANCEL=true

; Cancel exploit sent from client (0x70A7)
EXPLOIT_INVISIBLE_INVINCIBLE=true

; Prevents negative values on guild points
GUILD_POINTS=true


[App]

; Attach debug console
DEBUG_CONSOLE=true


how i cant connect to DB ?

what should i do can u help me ?

best Regard

Have you tried to run the server without any addons and see if it works?
12/03/2023 16:06 libiibi#5
Quote:
Originally Posted by Judgelemental View Post
Have you tried to run the server without any addons and see if it works?
What do you mean with any Addons ?
12/03/2023 16:15 Judgelemental#6
Quote:
Originally Posted by libiibi View Post
What do you mean with any Addons ?
The gameserver addon you're using.

Also, check DBConnect.asp ,srGlobal.ini, ODBC
12/03/2023 16:57 libiibi#7
Quote:
Originally Posted by Judgelemental View Post
The gameserver addon you're using.

Also, check DBConnect.asp ,srGlobal.ini, ODBC

Thank u I just try it and check it when I’m on the pc and in the VM

Quote:
Originally Posted by Judgelemental View Post
The gameserver addon you're using.

Also, check DBConnect.asp ,srGlobal.ini, ODBC
where i can find DBConnect.asp and ODBC ?
12/03/2023 20:31 Judgelemental#8
Quote:
Originally Posted by libiibi View Post
Thank u I just try it and check it when I’m on the pc and in the VM



where i can find DBConnect.asp and ODBC ?
Follow the videos I've sent you.
12/03/2023 21:34 libiibi#9
Quote:
Originally Posted by Judgelemental View Post
Follow the videos I've sent you.
i just follow one video but i dont have the wwwroot folder that i need in server files would u help me to find it :D
12/03/2023 21:40 Judgelemental#10
Quote:
Originally Posted by libiibi View Post
i just follow one video but i dont have the wwwroot folder that i need in server files would u help me to find it :D
It's in the video, follow the videos, please.
Enabling features in IIS will enable the wwwroot folder.
12/03/2023 22:52 libiibi#11
Quote:
Originally Posted by Judgelemental View Post
It's in the video, follow the videos, please.
Enabling features in IIS will enable the wwwroot folder.
i just done the tut on video correctly but Gameserver dont connect with DB and Shardmanager too not -.-"

Quote:
Originally Posted by Judgelemental View Post
It's in the video, follow the videos, please.
Enabling features in IIS will enable the wwwroot folder.
bro the server starts but if i want to use character and click start game they say Server ist not online please try again later then i get a DC any Solutin for this ?

Everything Working Ty for your Help