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:
Code:
#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:
Code:
#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:
Code:
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:
Code:
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:
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 THX TO SAPPHIRE TEAM[/EDIT]