Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 20:51

  • Please register to post and access all features, it's quick, easy and FREE!

 

[HOW-TO] Setup 9.1

Reply
 
Old   #151
 
elite*gold: 0
Join Date: Jul 2015
Posts: 7
Received Thanks: 0
Quote:
Originally Posted by thndr View Post
What is your Arcadia database named in your object browser?

Make sure it is Arcadia however that is not the only thing that could cause the game server to crash. There could be other .opt errors that will cause the same issue.

Like...

T:game.ServiceServer:1

Should be...

T:game.ServiceServer:0

If set to 1 it caused another players game server to crash.
2015/07/30 18:41:41 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 21:21:53 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 21:23:49 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 21:31:25 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 23:32:47 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 23:38:52 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 23:39:58 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".
2015/07/31 23:41:29 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Недопустимая спецификация авторизации
2015/07/31 23:45:00 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Недопустимая спецификация авторизации
2015/07/31 23:45:13 onDeInit is called with SDS 0x00000000.
2015/07/31 23:46:57 DB COM ERROR(Thread:0, HRESULT:80040E4D, GUID:0C733A8B-2A1C-11CE-ADE5-00AA0044773D) : GameDBManager(GameDBManager::initDBConnection()) : Ошибка входа пользователя "sa".

я это нашел в game log вот так проблема
это происходит когда я включаю CaptainHerlockServer

I found the game log so that's the problem
it happens when I turn CaptainHerlockServer

:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:Revolution Official
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user.account:sa
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
N:io.port:4514
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:1
T:log.working:0
F:game.exp_rate:30
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
T:game.update.version:24
F:game.gold_drop_rate:50
F:game.item_drop_rate:20
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
N:game.local_flag:8192
T:game.min_global_chat_usable_level:80
T:game.use_auto_trap:0
T:game.use_auto_jail:0
N:CodePage:1251
T:game.ServiceServer:0
N:console.port:65528
S:console.allow_ip:127.0.0.1
S:console._password:455600000300b13015cbe8f4ea6bb5 ee979a15b993f8dc9691ed74958a6b950e69c8178b95949564 0b7d2294b7
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url|

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.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
T: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
GameServer.opt
my



simbaka1996 is offline  
Old   #152
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 960
You still have no passwords in there for c and user...

Like I said why dont you start with the example .opt files given in the guide at least then you start with the correct information.

Your .opt file is missing these lines...

S:db.c._password:
S:db.user._password:

Your auth .opt that you posted earlier is missing its password line...

S db.auth._password:

The auth emulator that is in the guide is better. The .opt files posted in the guide work better than what you are trying to use...

If you are going to choose not to follow the guide then I guess you get exactly what you are getting.

Nothing but problems.


ThunderNikk is online now  
Thanks
1 User
Old   #153
 
elite*gold: 0
Join Date: Jul 2015
Posts: 7
Received Thanks: 0
a new problem with a client help



simbaka1996 is offline  
Old   #154
 
elite*gold: 0
Join Date: Feb 2014
Posts: 20
Received Thanks: 0
помогите пожалуйсто у меня что то не получается вот при этих файлах сервер меня посылает к чёрту( тобиш в игру зайти ни как
#Database configuration
auth.db.server:25.169.142.23
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

#MD5 salt
auth.db.salt:2011
#The password is in plain text for auth.db.password if you have one
auth.db.password:e06cbfb06e241f47b2d4d57fab79e772
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:<password encrypted using Pyrok tool>

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

#Where clients will connect (this is default values)
auth.clients.ip:25.169.142.23
auth.clients.port:4500

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

#Upload configuration, use "upload" folder for guild icons
upload.dir=upload
upload.clients.ip=25.169.142.23
upload.clients.port=4617
#Use port 5000 for the guild icon mini webserver
upload.iconserver.ip=25.169.142.23
upload.iconserver.port:5000

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

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

#Configure security password query. If this query return at least one row, the security password is accepted
#sql.db_securitynocheck.query:SELECT securty_no FROM account WHERE account = ? AND securty_no = ?;
#You can also use a stored procedure
#sql.db_securitynocheck.query:{CALL smp_new_check_security(?, ?)}

#Logging level
core.log.level:debug
core.log.consolelevel:info

когда запускаю рзаут выводит это что не так
2015-08-02 17:40:49 Info Log0: Log thread started using filename auth.log
2015-08-02 17:40:49 Debug Log1: Using file log level Debug
2015-08-02 17:40:49 Debug Log1: Using console log level FATAL
2015-08-02 17:40:49 Info ConfigInfo0: Config dump:
2015-08-02 17:40:49 Info ConfigInfo0: N*admin.dump_mode:0
2015-08-02 17:40:49 Info ConfigInfo0: B*admin.telnet.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*admin.telnet.idletimeout:0
2015-08-02 17:40:49 Info ConfigInfo0: S*admin.telnet.ip:127.0.0.1
2015-08-02 17:40:49 Info ConfigInfo0: N*admin.telnet.port:4501
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.billing.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.billing.idletimeout:0
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.billing.ip:127.0.0.1
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.billing.port:4503
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.clients.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.clients.des_key:MERONG
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.clients.idletimeout:301
2015-08-02 17:40:49 Info ConfigInfo0: S auth.clients.ip:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.clients.maxpublicserveridx:30
2015-08-02 17:40:49 Info ConfigInfo0: N auth.clients.port:4500
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.clients.restrictchars:true
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.account:<hidden>
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.db.connectionstring:<hidden>
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.db.cryptedconnectionstring:<hidden>
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.cryptedpassword:<hidden>
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.db.driver:SQL Server
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.db.ignoreinitcheck:true
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.name:auth
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.password:<hidden>
2015-08-02 17:40:49 Info ConfigInfo0: N auth.db.port:1433
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.salt:2011
2015-08-02 17:40:49 Info ConfigInfo0: S auth.db.server:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.gameserver.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.gameserver.idletimeout:0
2015-08-02 17:40:49 Info ConfigInfo0: S auth.gameserver.ip:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: N*auth.gameserver.maxplayers:400
2015-08-02 17:40:49 Info ConfigInfo0: N auth.gameserver.port:4502
2015-08-02 17:40:49 Info ConfigInfo0: B*auth.gameserver.strictkick:true
2015-08-02 17:40:49 Info ConfigInfo0: S*auth.securityno.salt:2011
2015-08-02 17:40:49 Info ConfigInfo0: S*ban.ipfile:Z:\рапа 9.1\серв\загрузки/bannedip.txt
2015-08-02 17:40:49 Info ConfigInfo0: S*configfile:Z:\рапа 9.1\серв\загрузки/auth.opt
2015-08-02 17:40:49 Info ConfigInfo0: S*core.appname:rzauth
2015-08-02 17:40:49 Info ConfigInfo0: S core.log.consolelevel:info
2015-08-02 17:40:49 Info ConfigInfo0: S*core.log.dir:Z:\рапа 9.1\серв\загрузки/log
2015-08-02 17:40:49 Info ConfigInfo0: B*core.log.enable:true
2015-08-02 17:40:49 Info ConfigInfo0: S*core.log.file:auth.log
2015-08-02 17:40:49 Info ConfigInfo0: S core.log.level:debug
2015-08-02 17:40:49 Info ConfigInfo0: N*core.log.maxqueuesize:10000
2015-08-02 17:40:49 Info ConfigInfo0: B*core.usetcpnodelay:false
2015-08-02 17:40:49 Info ConfigInfo0: S*core.version:Git rev 8788904d3ba06a8844e0fb05c80edb71b9ef3e9c build on 2015-05-03T18:53:03Z
2015-08-02 17:40:49 Info ConfigInfo0: S*global.version:Git rev 4b8c1c3880bb7ea88b7be419b47c9ed1236cda44 build on 2015-05-03T18:53:21Z
2015-08-02 17:40:49 Info ConfigInfo0: B*logclient.enable:true
2015-08-02 17:40:49 Info ConfigInfo0: S*logclient.ip:127.0.0.1
2015-08-02 17:40:49 Info ConfigInfo0: N*logclient.port:4516
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.accountid:account_id
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.age:age
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.authok:auth_ok
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.block:block
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.eventcode:event_code
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.lastserveridx:last_login_s erver_idx
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.passwordassword
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.pcbangcbang
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_account.column.serveridxoffset:server_idx _offset
2015-08-02 17:40:49 Info ConfigInfo0: B*sql.db_account.enable:true
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_account.param.account:1
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_account.param.ip:-1
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_account.param.password:2
2015-08-02 17:40:49 Info ConfigInfo0: S sql.db_account.query:SELECT * FROM account WITH(NOLOCK) WHERE account = ? AND password = ?;
2015-08-02 17:40:49 Info ConfigInfo0: B*sql.db_securitynocheck.enable:true
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_securitynocheck.param.account:1
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_securitynocheck.param.securityno:2
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_securitynocheck.query:SELECT account FROM account WHERE account = ? AND password = ?
2015-08-02 17:40:49 Info ConfigInfo0: B*sql.db_updatelastserveridx.enable:true
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_updatelastserveridx.param.accountid:2
2015-08-02 17:40:49 Info ConfigInfo0: N*sql.db_updatelastserveridx.param.serveridx:1
2015-08-02 17:40:49 Info ConfigInfo0: S*sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;
2015-08-02 17:40:49 Info ConfigInfo0: N stats.connections:0
2015-08-02 17:40:49 Info ConfigInfo0: N stats.disconnections:0
2015-08-02 17:40:49 Info ConfigInfo0: S*trafficdump.consolelevel:fatal
2015-08-02 17:40:49 Info ConfigInfo0: S*trafficdump.dir:Z:\рапа 9.1\серв\загрузки/traffic_log
2015-08-02 17:40:49 Info ConfigInfo0: B*trafficdump.enable:false
2015-08-02 17:40:49 Info ConfigInfo0: S*trafficdump.file:auth.log
2015-08-02 17:40:49 Info ConfigInfo0: S*trafficdump.level:debug
2015-08-02 17:40:49 Info ConfigInfo0: B*upload.clients.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*upload.clients.idletimeout:61
2015-08-02 17:40:49 Info ConfigInfo0: S upload.clients.ip:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: N upload.clients.port:4617
2015-08-02 17:40:49 Info ConfigInfo0: S upload.dir:Z:\рапа 9.1\серв\загрузки/upload
2015-08-02 17:40:49 Info ConfigInfo0: B*upload.gameserver.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*upload.gameserver.idletimeout:0
2015-08-02 17:40:49 Info ConfigInfo0: S upload.gameserver.ip:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: N upload.gameserver.port:4616
2015-08-02 17:40:49 Info ConfigInfo0: B*upload.iconserver.autostart:true
2015-08-02 17:40:49 Info ConfigInfo0: N*upload.iconserver.idletimeout:31
2015-08-02 17:40:49 Info ConfigInfo0: S upload.iconserver.ip:25.169.142.23
2015-08-02 17:40:49 Info ConfigInfo0: N upload.iconserver.port:5000
2015-08-02 17:40:49 Info DbConnectionPool0: Checking connection to database
2015-08-02 17:40:49 Debug DbConnectionPool0: Connecting to database
2015-08-02 17:40:49 ERROR ODBC: SQLDriverConnect: error:
2015-08-02 17:40:49 ERROR ODBC: 28000:1:18456:[Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка входа пользователя "sa".
2015-08-02 17:40:49 ERROR DbConnectionPool0: Failed to connect to driver=SQL Server;Server=25.169.142.23,1433;Database=auth;UID =sa;PWD=ґ[о„Уу0ЌЬјcf/2М
2015-08-02 17:40:49 ERROR DbConnectionPool0: Could not retrieve a DB connection from pool to "driver=SQL Server;Server=25.169.142.23,1433;Database=auth;UID =sa;PWD=ґ[о„Уу0ЌЬјcf/2М"
2015-08-02 17:40:49 Info SessionServer<AuthServer::ClientSession>: Starting server auth.clients on 25.169.142.23:4500
2015-08-02 17:40:49 Debug BanManager0: No ban ip file: "Z:\рапа 9.1\серв\загрузки/bannedip.txt"
2015-08-02 17:40:49 Info SessionServer<AuthServer::BillingInterface>: Starting server auth.billing on 127.0.0.1:4503
2015-08-02 17:40:49 Info SessionServer<AuthServer::GameServerSession>: Starting server auth.gameserver on 25.169.142.23:4502
2015-08-02 17:40:49 Info SessionServer<UploadServer::GameServerSession>: Starting server upload.gameserver on 25.169.142.23:4616
2015-08-02 17:40:49 Info SessionServer<UploadServer::ClientSession>: Starting server upload.clients on 25.169.142.23:4617
2015-08-02 17:40:49 Debug BanManager0: No ban ip file: "Z:\рапа 9.1\серв\загрузки/bannedip.txt"
2015-08-02 17:40:49 Info SessionServer<UploadServer::IconServerSession>: Starting server upload.iconserver on 25.169.142.23:5000
2015-08-02 17:40:49 Debug BanManager0: No ban ip file: "Z:\рапа 9.1\серв\загрузки/bannedip.txt"
2015-08-02 17:40:49 Info SessionServer<AdminServer::AdminInterface>: Starting server admin.telnet on 127.0.0.1:4501
2015-08-02 17:40:50 ERROR Socket[:0 <> 127.0.0.1:4516]: onConnected: connection refused
2015-08-02 17:40:50 Info SocketSession0: Disconnected from Log server 127.0.0.1:4516
2015-08-02 17:40:55 Info SessionServer<AuthServer::ClientSession>: Stopping server auth.clients
2015-08-02 17:40:55 Info SessionServer<AuthServer::BillingInterface>: Stopping server auth.billing
2015-08-02 17:40:55 Info SessionServer<AuthServer::GameServerSession>: Stopping server auth.gameserver
2015-08-02 17:40:55 Info SessionServer<UploadServer::GameServerSession>: Stopping server upload.gameserver
2015-08-02 17:40:55 Info SessionServer<UploadServer::ClientSession>: Stopping server upload.clients
2015-08-02 17:40:55 Info SessionServer<UploadServer::IconServerSession>: Stopping server upload.iconserver
2015-08-02 17:40:55 Info SessionServer<AdminServer::AdminInterface>: Stopping server admin.telnet
2015-08-02 17:40:55 Info Log0: Log thread stopped










S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:Revo
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:25.169.142.23
S:db.user.account:sa
S:db.user.server:25.169.142.23
S:db.user.name:telecaster
N:io.port:4514
S:io.auth.ip:25.169.142.23
S:io.ip_address:25.169.142.23
S:log.chat.ip:25.169.142.23
S:log.ip:25.169.142.23
T:log.chat.working:1
T:log.working:0
F:game.exp_rate:42
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
T:game.update.version:24
F:game.gold_drop_rate:50
F:game.item_drop_rate:20
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
N:game.local_flag:256
T:game.min_global_chat_usable_level:80
T:game.use_auto_trap:0
T:game.use_auto_jail:0
N:CodePage:1256
T:game.ServiceServer:1
N:console.port:65528
S:console.allow_ip:25.169.142.23
S:console._password:455600000300b13015cbe8f4ea6bb5 ee979a15b993f8dc9691ed74958a6b950e69c8178b95949564 0b7d2294b7
S:io.upload.ip:25.169.142.23
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url|

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.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
T: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


dervish7 is offline  
Old   #155
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 960
@ simbaka1996

Maybe because your auth port is not in your .bat launcher?

@ dervish7 this is a German / English forum please use one of them...

check your dbo.character for auto_used and set it to 0.

get rid of this line in your gameserver.opt...

N:CodePage:1256

or change it to what it should be for Russia...

N:CodePage:1251
ThunderNikk is online now  
Old   #156
 
elite*gold: 0
Join Date: Feb 2014
Posts: 20
Received Thanks: 0
maybe someone will make a video how to do the server)
dervish7 is offline  
Old   #157
 
elite*gold: 0
Join Date: Apr 2012
Posts: 99
Received Thanks: 34
Hy dervish7 , i think an video tutorial is not neaded , Ismokedrow tuto is full and clear.

your sql server, auth server and game server is on the same pc ?

if yes, i don't know why you put your external ip for all settings ip , most of them nead the local host ip.

you have an error in auth.opt :

this is false :
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:<passwordcrypted using Pyrok tool>

you nead to add # before rows not used :
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
#auth.db.cryptedpassword:<passwordcrypted using Pyrok tool>

and in your game.opt , these passwords are missing :

S:db.c._password:
S:db.user._password:
nimoht is offline  
Old   #158
 
elite*gold: 0
Join Date: Feb 2014
Posts: 20
Received Thanks: 0
nimont thanks for the tips but obviously I still can blunt poke me in my error
I understand what you are trying to get the man himself thought but if there is no proper example of it is a very long time to penetrate myself( please awesome to deal with auth.opt ) sorry of course that English was taught poorly because the interpreter is not entirely accurate and sometimes you have to choose the best translation

#Database configuration
auth.db.server:25.169.142.23
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

#MD5 salt
auth.db.salt:2011
#The password is in plain text for auth.db.password if you have one
auth.db.password:e06cbfb06e241f47b2d4d57fab79e772
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:455600000300be47ce8dd1628a 77897575a5f5f1f5f5f5f3044d0cf5

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

#Where clients will connect (this is default values)
auth.clients.ip:25.169.142.23
auth.clients.port:4500

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

#Upload configuration, use "upload" folder for guild icons
upload.dir=upload
upload.clients.ip=25.169.142.23
upload.clients.port=4617
#Use port 5000 for the guild icon mini webserver
upload.iconserver.ip=25.169.142.23
upload.iconserver.port:5000

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

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

#Configure security password query. If this query return at least one row, the security password is accepted
#sql.db_securitynocheck.query:SELECT securty_no FROM account WHERE account = ? AND securty_no = ?;
#You can also use a stored procedure
#sql.db_securitynocheck.query:{CALL smp_new_check_security(?, ?)}

#Logging level
core.log.level:debug
core.log.consolelevel:info

I hope that you understand me correctly and will help to deal with this problem
dervish7 is offline  
Old   #159
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 960
#The password is in plain text for auth.db.password if you have one
auth.db.password:e06cbfb06e241f47b2d4d57fab79e772

Is...

e06cbfb06e241f47b2d4d57fab79e772

really your plain text password?

Then this is that password des encrypted...

455600000300be47ce8dd1628a77897575a5f5f1f5f5f5f304 4d0cf5

And you are telling the database to use them both because neither is #ed out to comment it out.

Follow the examples...

auth.db.server:127.0.0.1
auth.clients.ip:0.0.0.0
auth.gameserver.ip:127.0.0.1
upload.clients.ip=0.0.0.0
upload.iconserver.ip=127.0.0.1
upload.gameserver.ip:127.0.0.1

There is a guide for a reason...because you choose to do what you want and say there should be a video is not a good reason.

Follow the guide.

You can pretty much take the authserver.opt given as an example and use it...aside from the password part...

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

#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:REPLACE.ME.WITH.YOUR.AUTH.DB.USER.PASSWORD.IN.PLAIN.TEXT
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:REPLACE.ME.WITH.YOUR.AUTH.DB.USER.PASSWORD Encrypted By Pyroks Tool
auth.db.salt:2011
#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:0.0.0.0
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=0.0.0.0
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 = ?;
ThunderNikk is online now  
Old   #160
 
elite*gold: 0
Join Date: Jan 2012
Posts: 98
Received Thanks: 0
You must register and activate your account in order to view images.

Any help /i'm stuck at this part

You must register and activate your account in order to view images.

how i can did this part ! :
You must register and activate your account in order to view images.

----------------
-+------------
------------
how !

You must register and activate your account in order to view images.
kubed is offline  
Old   #161
 
elite*gold: 0
Join Date: Oct 2014
Posts: 3
Received Thanks: 0
Есть русский которые помогут установить сервер? А то мой анг эта что то)))
Pushkin90 is offline  
Old   #162
 
elite*gold: 0
Join Date: Feb 2014
Posts: 20
Received Thanks: 0
and still, explain to me why I can not start the server I am suffering in pain and can not understand here is my auth :


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

#MD5 salt
auth.db.salt:5dd23
#The password is in plain text for auth.db.password if you have one
auth.db.password:
#Use auth.db.cryptedpassword instead of auth.db.password to use an encrypted password
auth.db.cryptedpassword:45560000030003ef2a13d8ed6a 1093f8bb4bef17ef6f6f6f6805200f6f

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

#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:4500

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

#Upload configuration, use "upload" folder for guild icons
upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=4617
#Use port 5000 for the guild icon mini webserver
upload.iconserver.ip=0.0.0.0
upload.iconserver.port: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 account WITH(NOLOCK) WHERE account = ? AND password = ?;

#Configure security password query. If this query return at least one row, the security password is accepted
#sql.db_securitynocheck.query:SELECT securty_no FROM account WHERE account = ? AND securty_no = ?;
#You can also use a stored procedure
#sql.db_securitynocheck.query:{CALL smp_new_check_security(?, ?)}

#Logging level
core.log.level:debug
core.log.consolelevel:info

and issues in the log such information here
2015-08-09 16:41:40 Info Log0: Log thread started using filename auth.log
2015-08-09 16:41:40 Debug Log1: Using file log level Debug
2015-08-09 16:41:40 Debug Log1: Using console log level FATAL
2015-08-09 16:41:40 Info ConfigInfo0: Config dump:
2015-08-09 16:41:40 Info ConfigInfo0: N*admin.dump_mode:0
2015-08-09 16:41:40 Info ConfigInfo0: B*admin.telnet.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*admin.telnet.idletimeout:0
2015-08-09 16:41:40 Info ConfigInfo0: S*admin.telnet.ip:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: N*admin.telnet.port:4501
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.billing.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.billing.idletimeout:0
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.billing.ip:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.billing.port:4503
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.clients.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.clients.des_key:MERONG
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.clients.idletimeout:301
2015-08-09 16:41:40 Info ConfigInfo0: S auth.clients.ip:0.0.0.0
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.clients.maxpublicserveridx:30
2015-08-09 16:41:40 Info ConfigInfo0: N auth.clients.port:4500
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.clients.restrictchars:true
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.account:<hidden>
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.db.connectionstring:<hidden>
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.db.cryptedconnectionstring:<hidden>
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.cryptedpassword:<hidden>
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.db.driver:SQL Server
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.db.ignoreinitcheck:true
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.name:Auth
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.password:<hidden>
2015-08-09 16:41:40 Info ConfigInfo0: N auth.db.port:1433
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.salt:5dd23
2015-08-09 16:41:40 Info ConfigInfo0: S auth.db.server:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.gameserver.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.gameserver.idletimeout:0
2015-08-09 16:41:40 Info ConfigInfo0: S auth.gameserver.ip:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: N*auth.gameserver.maxplayers:400
2015-08-09 16:41:40 Info ConfigInfo0: N auth.gameserver.port:4502
2015-08-09 16:41:40 Info ConfigInfo0: B*auth.gameserver.strictkick:true
2015-08-09 16:41:40 Info ConfigInfo0: S*auth.securityno.salt:5dd23
2015-08-09 16:41:40 Info ConfigInfo0: S*ban.ipfile:C:\Games\Cервер 91\Auth_bin/bannedip.txt
2015-08-09 16:41:40 Info ConfigInfo0: S*configfile:C:\Games\Cервер 91\Auth_bin/auth.opt
2015-08-09 16:41:40 Info ConfigInfo0: S*core.appname:rzauth
2015-08-09 16:41:40 Info ConfigInfo0: S core.log.consolelevel:info
2015-08-09 16:41:40 Info ConfigInfo0: S*core.log.dir:C:\Games\Cервер 91\Auth_bin/log
2015-08-09 16:41:40 Info ConfigInfo0: B*core.log.enable:true
2015-08-09 16:41:40 Info ConfigInfo0: S*core.log.file:auth.log
2015-08-09 16:41:40 Info ConfigInfo0: S core.log.level:debug
2015-08-09 16:41:40 Info ConfigInfo0: N*core.log.maxqueuesize:10000
2015-08-09 16:41:40 Info ConfigInfo0: B*core.usetcpnodelay:false
2015-08-09 16:41:40 Info ConfigInfo0: S*core.version:Git rev 8788904d3ba06a8844e0fb05c80edb71b9ef3e9c build on 2015-05-03T18:53:03Z
2015-08-09 16:41:40 Info ConfigInfo0: S*global.version:Git rev 4b8c1c3880bb7ea88b7be419b47c9ed1236cda44 build on 2015-05-03T18:53:21Z
2015-08-09 16:41:40 Info ConfigInfo0: B*logclient.enable:true
2015-08-09 16:41:40 Info ConfigInfo0: S*logclient.ip:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: N*logclient.port:4516
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.accountid:account_id
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.age:age
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.authok:auth_ok
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.block:block
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.eventcode:event_code
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.lastserveridx:last_login_s erver_idx
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.passwordassword
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.pcbangcbang
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_account.column.serveridxoffset:server_idx _offset
2015-08-09 16:41:40 Info ConfigInfo0: B*sql.db_account.enable:true
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_account.param.account:1
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_account.param.ip:-1
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_account.param.password:2
2015-08-09 16:41:40 Info ConfigInfo0: S sql.db_account.query:SELECT * FROM account WITH(NOLOCK) WHERE account = ? AND password = ?;
2015-08-09 16:41:40 Info ConfigInfo0: B*sql.db_securitynocheck.enable:true
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_securitynocheck.param.account:1
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_securitynocheck.param.securityno:2
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_securitynocheck.query:SELECT account FROM account WHERE account = ? AND password = ?
2015-08-09 16:41:40 Info ConfigInfo0: B*sql.db_updatelastserveridx.enable:true
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_updatelastserveridx.param.accountid:2
2015-08-09 16:41:40 Info ConfigInfo0: N*sql.db_updatelastserveridx.param.serveridx:1
2015-08-09 16:41:40 Info ConfigInfo0: S*sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;
2015-08-09 16:41:40 Info ConfigInfo0: N stats.connections:0
2015-08-09 16:41:40 Info ConfigInfo0: N stats.disconnections:0
2015-08-09 16:41:40 Info ConfigInfo0: S*trafficdump.consolelevel:fatal
2015-08-09 16:41:40 Info ConfigInfo0: S*trafficdump.dir:C:\Games\Cервер 91\Auth_bin/traffic_log
2015-08-09 16:41:40 Info ConfigInfo0: B*trafficdump.enable:false
2015-08-09 16:41:40 Info ConfigInfo0: S*trafficdump.file:auth.log
2015-08-09 16:41:40 Info ConfigInfo0: S*trafficdump.level:debug
2015-08-09 16:41:40 Info ConfigInfo0: B*upload.clients.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*upload.clients.idletimeout:61
2015-08-09 16:41:40 Info ConfigInfo0: S upload.clients.ip:0.0.0.0
2015-08-09 16:41:40 Info ConfigInfo0: N upload.clients.port:4617
2015-08-09 16:41:40 Info ConfigInfo0: S upload.dir:C:\Games\Cервер 91\Auth_bin/upload
2015-08-09 16:41:40 Info ConfigInfo0: B*upload.gameserver.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*upload.gameserver.idletimeout:0
2015-08-09 16:41:40 Info ConfigInfo0: S upload.gameserver.ip:127.0.0.1
2015-08-09 16:41:40 Info ConfigInfo0: N upload.gameserver.port:4616
2015-08-09 16:41:40 Info ConfigInfo0: B*upload.iconserver.autostart:true
2015-08-09 16:41:40 Info ConfigInfo0: N*upload.iconserver.idletimeout:31
2015-08-09 16:41:40 Info ConfigInfo0: S upload.iconserver.ip:0.0.0.0
2015-08-09 16:41:40 Info ConfigInfo0: N upload.iconserver.port:5000
2015-08-09 16:41:40 Info DbConnectionPool0: Checking connection to database
2015-08-09 16:41:40 Debug DbConnectionPool0: Connecting to database
2015-08-09 16:41:40 ERROR ODBC: SQLDriverConnect: error:
2015-08-09 16:41:40 ERROR ODBC: 28000:1:18456:[Microsoft][ODBC SQL Server Driver][SQL Server]Ошибка входа пользователя "sa".
2015-08-09 16:41:40 ERROR DbConnectionPool0: Failed to connect to driver=SQL Server;Server=127.0.0.1,1433;Database=Auth;UID=sa; PWD=2908081;
2015-08-09 16:41:40 ERROR DbConnectionPool0: Could not retrieve a DB connection from pool to "driver=SQL Server;Server=127.0.0.1,1433;Database=Auth;UID=sa; PWD=2908081;"
2015-08-09 16:41:40 Info SessionServer<AuthServer::ClientSession>: Starting server auth.clients on 0.0.0.0:4500
2015-08-09 16:41:40 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-09 16:41:40 Info SessionServer<AuthServer::BillingInterface>: Starting server auth.billing on 127.0.0.1:4503
2015-08-09 16:41:40 Info SessionServer<AuthServer::GameServerSession>: Starting server auth.gameserver on 127.0.0.1:4502
2015-08-09 16:41:40 Info SessionServer<UploadServer::GameServerSession>: Starting server upload.gameserver on 127.0.0.1:4616
2015-08-09 16:41:40 Info SessionServer<UploadServer::ClientSession>: Starting server upload.clients on 0.0.0.0:4617
2015-08-09 16:41:40 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-09 16:41:40 Info SessionServer<UploadServer::IconServerSession>: Starting server upload.iconserver on 0.0.0.0:5000
2015-08-09 16:41:40 Debug BanManager0: No ban ip file: "C:\Games\Cервер 91\Auth_bin/bannedip.txt"
2015-08-09 16:41:40 Info SessionServer<AdminServer::AdminInterface>: Starting server admin.telnet on 127.0.0.1:4501
2015-08-09 16:41:41 ERROR Socket[:0 <> 127.0.0.1:4516]: onConnected: connection refused
2015-08-09 16:41:41 Info SocketSession0: Disconnected from Log server 127.0.0.1:4516
2015-08-09 16:41:44 Info SessionServer<AuthServer::ClientSession>: Stopping server auth.clients
2015-08-09 16:41:44 Info SessionServer<AuthServer::BillingInterface>: Stopping server auth.billing
2015-08-09 16:41:44 Info SessionServer<AuthServer::GameServerSession>: Stopping server auth.gameserver
2015-08-09 16:41:44 Info SessionServer<UploadServer::GameServerSession>: Stopping server upload.gameserver
2015-08-09 16:41:44 Info SessionServer<UploadServer::ClientSession>: Stopping server upload.clients
2015-08-09 16:41:44 Info SessionServer<UploadServer::IconServerSession>: Stopping server upload.iconserver
2015-08-09 16:41:44 Info SessionServer<AdminServer::AdminInterface>: Stopping server admin.telnet
2015-08-09 16:41:44 Info Log0: Log thread stopped


explain why constantly displays the login failed for user sa
dervish7 is offline  
Old   #163
 
elite*gold: 0
Join Date: Apr 2012
Posts: 448
Received Thanks: 768
"2908081" is your DB password ?
glandu2 is offline  
Old   #164
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 960
If you are not going to use a line like this...

auth.db.password:

Then you should comment it out like this...

#auth.db.password:

Just leaving it blank is not correct.

And as glandu2 has posted I am pretty sure you just keep getting the wrong password encryption or you forgot to configure your SQL instance for port 1433.
ThunderNikk is online now  
Old   #165
 
elite*gold: 0
Join Date: Feb 2014
Posts: 20
Received Thanks: 0
yes

Quote:
Originally Posted by glandu2 View Post
"2908081" is your DB password ?
yes


dervish7 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Microsoft .NET Framework 3.5 Setup - Setup Fehler
ich will netframe instahlieren wo er fertig ist kommt nurnoch das http://s14.directupload.net/images/130722/vedlkevr.png Kann wer helfen?
10 Replies - Technical Support
Microsoft .NET Framework 3.5 Setup - Setup Fehler
bitte close doppelpost
3 Replies - Technical Support
setup Net microsoft net Framework sp 3.5 sp1 log all setup Net microsoft net Framewo
setup Net microsoft net Framework sp 3.5 sp1 log all setup Net microsoft net Framework sp 3.5 sp1 log all some proplem this ): here ...........
0 Replies - Rappelz
What VirtualPC download is better? -32 BIT/setup.exe30.4MB 64 BIT/setup.exe30.5MB
32 BIT/setup.exe30.4MB Download 64 BIT/setup.exe30.5MB Download TELL ME !
1 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 20:51.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.