[HOW-TO] Setup 9.1

[swtib91]

Sorry guys but I followed step by step the method but when i try to connect, it all time say me that my password isn't correct ... I tried many account, many password after adding it into auth database but doesn't work .. Please help me?

And when i try to start with PrincessAurora I clairly see
So i guess it's because it's doesn't really connect to Auth Database and that's why the game do not found my account. I tried by edited my autherserver.opt like that S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:Auth Server
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

and commun opt like that
#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:
# (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 = ?;

But I still unable to connect ..

I really need help cause I don't understand where can be the problem ..
Thanks as advance.

[Delwig]

u went to
and did salt +ur pw?

example
5dd23password

[swtib91]

Yup
I put admin so it converted it as 21232f297a57a5a743894a0e4a801fc3
and i put this code on the password colons on auth database

[Delwig]

put this in

ec114776ae3e950aae571538ef0b280b


it has to be like this 5dd23admin in the hash generator

[swtib91]

Originally Posted by Delwig

put this in

ec114776ae3e950aae571538ef0b280b


it has to be like this 5dd23admin in the hash generator

Omg I love you dude !

[lmfeiyu]

Thank you,ismokedrow.

[Nooobee4]

Hey guys. Normally I get everything working perfectly due to your amazing guides. However, I cannot get my server instance to work through Hamachi with my mates.

auth.opt

 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.opt

 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:
# (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 = ?;

gameserver.opt

 Spoiler

S:app.name:RappelzPVT
T:auth.server_idx:1
S:auth.server_name:Euphorion
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:25.91.130.165
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_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_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:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
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:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:0
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:
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
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

The servers run without running into any errors, but when I try to log in, I get an error as such: Cannot connect to login server (10060)

[ThunderNikk]

S:io.auth.ip:127.0.0.1
S:io.ip_address:25.91.130.165

Only local host can find your auth.

[Jumper205]

Hey Guys,

i have a Problem with my AuthEmu.

It runs on 64bit Windows Server 2012 r2.

When i connect with the 9.1 client it say "Cannot connect to Server".

In my AuthEmu console i see following:

See attachment.

I have try any connection strings.

Anyone answers?

[InkDevil]

Originally Posted by Jumper205

Hey Guys,

i have a Problem with my AuthEmu.

It runs on 64bit Windows Server 2012 r2.

When i connect with the 9.1 client it say "Cannot connect to Server".

In my AuthEmu console i see following:

See attachment.

I have try any connection strings.

Anyone answers?

Go to your auth.opt and change the speedup selects with NOLOCK
to

sql.db_account.query:SELECT * FROM accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

Or generally open SQL, open the auth-database and look if you can find "dbo.account" in there (with that error, i bet you won't).
Then change in your auth.opt in that sql-query "account" in what you've found in your db

Ah and btw, you may get problems running 9.1 on SQL2012.

[Jumper205]

Thank you ,
i have do everythin what you say.

but......

The same error.

I can connect and see my Server in List ,than "Cannot connect to Server".

I use SQL Server 2014.

The SQL querry looks like good for me. or? i don´t know.

I'am affraid...

[InkDevil]

Then you should make a post with your auth.opt-/gameserver.opt-settings.
Even if auth.opt should be fine now when you can already enter the serverlist.

[Dima34]

Lots of people are having problems because the guide is soo bad.

When I first did it, I followed this guide and it didn't work.. I got it right after someone explained it to me in Russian, and I'm not a very good Russian speaker.

[eliteplayer100]

Apologyzes, the question is already in debate in other topic.I will search there.

Hello, i am having the same issue that Jumper 205. When i click on server, the game stalls and gives an error, "cannot connect to the server".

I also use SQL 2014 and 64bits system.

[ThunderNikk]

You may have missed some steps in the guide.

Configuring SQL port 1433

Your user connection configurations and your .opt file set up.

Without seeing those it is hard to help you with what your connection issue is.

You haven't even mention if you are using the auth emulator or not. So again with you providing so little information it is hard to say why you are getting a connection error.