[HOW-TO] Setup 9.1

[magierhauck]

guys
which edition of sql server 2014?
Express-Edition?

or which edition u use

need help

[magierhauck]

i need help guys

kann mir jemand helfen?

[PetTrainer]

Originally Posted by magierhauck

i need help guys

kann mir jemand helfen?

hast du ein Passwort in deinem SQL eingestellt ? wenn ja , hasst du dies auch als md5 hash in die .opt's eingetragen ?

[magierhauck]

PetTrainer

schau in dein Postfach nach

[lrd12345]

First i want to say big thx to all of whom are helping for the great guide and reply's. I hope this topic is still active. Spend the entire night last night reading trough all the reply's and they have helped alot. Sadly to say as of now i still can not with serveral 9.1 clients(meaning I've tryed multiply clients to connect) to my server. The server itself has no apperent issues. I do not wish to go public, i only want it to be on my lan. Both client and server are running from disk0partition0 (c:\).

Here is my info, and the way iv'e set it up.

pc info : win10 x64, mysql 2014 evaluation 180 days (full)[meaning I've selected all boxes at install]

Hardware: 3.4ghz i3, 8gb ram.

Setup info:

Ports:
Auth port same as mysql port (in my case 1433)
Auth client port : 58422

Passwords:
I left all pws blank (both in mysql and in opt. sa is blank too)
I have commented out auth.db.salt (in common.opt)

Accounts:
I made all the accounts on mysql as instructed in the guide.

Network:
i have disabled my firewall, i have configurated mysql to have port 1433.

Opt files:

Auth:

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:sa
auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_mask

#include config in common.opt
%include:common.opt

Common:

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
#auth.db.salt:5dd23
#You can make auth.dbo.Accounts.[password] by visiting: 
# http://www.miraclesalad.com/webtools/md5.php (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

GameServer:

 Spoiler

S:app.name:GameServer
T:auth.server_idx:1
S:auth.server_name:MyVeryOwn91Server
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:sa
S:db.c._password:
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:sa
S:db.user._password:
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_damage:.30
F:game.base_ethereal_durability_consumption_on_skill_attack:.40
F:game.base_ethereal_durability_consumption_on_normal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1000000
S game.gold_drop_rate:2000000
S game.chaos_drop_rate:2000000
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:999
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:http://127.0.0.1/guild/
S:game.url_list:guild.url|http://127.0.0.1/login.aspx|guild_test_download.url|guild/|web_download|5.196.124.242|web_download_port|0|shop.url|http://shop.rappelz.co|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|5.196.124.242|guild_icon_upload.port|4617

S:game.server_screenshot_url:http://rappelz.co/launcher/server.html
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

RapprelzAuthServer.exe log:

 Spoiler

2016-01-09 16:24:42 Info  ConfigInfo0: N stats.connections:0
2016-01-09 16:24:42 Info  ConfigInfo0: N stats.disconnections:0
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.consolelevel:fatal
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.dir:E:\server_bin\Auth_bin/traffic_log
2016-01-09 16:24:42 Info  ConfigInfo0: B*trafficdump.enable:false
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.file:auth.log
2016-01-09 16:24:42 Info  ConfigInfo0: S*trafficdump.level:debug
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.clients.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.clients.idletimeout:61
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.clients.ip:127.0.0.1
2016-01-09 16:24:42 Info  ConfigInfo0: N upload.clients.port:32214
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.dir:E:\server_bin\Auth_bin/upload
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.gameserver.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.gameserver.idletimeout:0
2016-01-09 16:24:42 Info  ConfigInfo0: S upload.gameserver.ip:127.0.0.1
2016-01-09 16:24:42 Info  ConfigInfo0: N upload.gameserver.port:4616
2016-01-09 16:24:42 Info  ConfigInfo0: B*upload.iconserver.autostart:true
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.iconserver.idletimeout:31
2016-01-09 16:24:42 Info  ConfigInfo0: S*upload.iconserver.ip:0.0.0.0
2016-01-09 16:24:42 Info  ConfigInfo0: N*upload.iconserver.port:80
2016-01-09 16:24:42 Info  DbConnectionPool0: Checking connection to "driver=SQL Server;Server=127.0.0.1,1433;Database=Auth;UID=sa;PWD=;"
2016-01-09 16:24:42 Info  ODBC: SQLDriverConnect: additional info:
2016-01-09 16:24:42 Info  ODBC: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Auth'.
2016-01-09 16:24:42 Info  ODBC: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
2016-01-09 16:24:42 Info  DbConnectionPool0: Connection ok
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.clients on 127.0.0.1:58422
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.billing on 127.0.0.1:4503
2016-01-09 16:24:42 Info  ServersManager0: Starting server auth.gameserver on 127.0.0.1:4502
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.gameserver on 127.0.0.1:4616
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.clients on 127.0.0.1:32214
2016-01-09 16:24:42 Info  ServersManager0: Starting server upload.iconserver on 0.0.0.0:80
2016-01-09 16:24:42 Info  ServersManager0: Starting server admin.telnet on 127.0.0.1:4501
2016-01-09 16:28:49 Info  ServerInfo[]: Server Login: MyVeryOwn91Server[1] at 127.0.0.1:15574
2016-01-09 16:28:51 Info  GameServerSession[]: Server Login: GameServer from 127.0.0.1:53015

CaptainHerlockServer.exe log:

 Spoiler

Summary:
The client works, the launcher works, but when I try to log in with my auth.db.account, there is no error and I can not log in. Regardless of what password type I use (e.g. md5 hash, plain text, blank)

[Edit]if this post is not active, please remove[/Edit]
[Edit]FIXED BY SAPPHIRE TEAM[/Edit]

[Deltajoey14]

Can anyone help me ?
If i wanna Start "Server.exe" (my CaptainHerlockServer), my Corsor show me that he load anythink. After 4 minutes still nothing open.

[ThunderNikk]

Are you getting arcadia.dmp files in the captainherlock folder?

If so it could be name misdirection causing captainherlock to be unable to find the arcadia database or some change to the arcadia database information may have caused it to be unstable.

This is all assuming you have a good enough computer to run the server and you are running it from an administrative account or with administrative rights on the computer.

[Deltajoey14]

No i dont have arcadia.dmp in my "Game_bin" folder if u mean that (the folder whit Gameserver.opt) and yeah i have a good pc and full Adminrights. its very crazy because befor i create a account in "SQL>dbo.Accounts" i can start the Server.exe whitout any problems or Errors. btw do you can speak german ? ^^

[ThunderNikk]

No I don't speak german.

Your account table is called dbo.accounts and not dbo.account?

If you are using the auth emulator written by glandu2 you may need to take a look at the SQL queries in the auth.opt and make sure they are written for the correct table name.

Other than that you may need to look into how you created the account and if all of the account fields were filled in correctly.

Some examples from the original auth emulator opt file...

#If the table name is "account":
sql.db_account.query:SELECT * FROM account WHERE account = ? AND password = ?;
sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

#If the table name is "accounts" (just change the sql query):
#sql.db_account.query:SELECT * FROM accounts WHERE account = ? AND password = ?;
#sql.db_updatelastserveridx.query:UPDATE accounts SET last_login_server_idx = ? WHERE account_id = ?;

[Deltajoey14]

okay i change all to "account" but it still not working. the Server.exe do not want to open.

[ThunderNikk]

You can't change your database

You need to change the SQL in the auth.opt

Use the correct one for accounts...comment the wrong ones out.

[Game_0verrr]

I have set up the server yesterday and everything is working fine. It should not be noted but the tutorial does not EXPLICITLY states that the OPT files needs to be adjusted with the right credentials in it, also, i don't know where it was used exactly, but in some file i needed to put in the PYROK password. These where the only two things that went wrong with me actually. Thank you so much for a nice tutorial that is easy to follow.

[xion0374]

Hey, when I try to unzip the 9.1 files with the password both from the main section, im getting a warning/notion of saying im only getting partial files.

So how do I fix this. or get all the files.

[CHlNAMAN]

Redownload the files. Most likely you live in Somalia or a relative country with a bad interwebz.

[Hirohito1000]

Please help