[HOW-TO] Setup 9.1

08/31/2015 20:57 swtib91#196
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 [Only registered and activated users can see links. Click Here To Register...]
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:
# [Only registered and activated users can see links. Click Here To Register...] (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.
08/31/2015 21:02 Delwig#197
u went to [Only registered and activated users can see links. Click Here To Register...]
and did salt +ur pw?

example
5dd23password
08/31/2015 21:08 swtib91#198
Yup
I put admin so it converted it as 21232f297a57a5a743894a0e4a801fc3
and i put this code on the password colons on auth database
08/31/2015 21:32 Delwig#199
put this in

ec114776ae3e950aae571538ef0b280b


it has to be like this 5dd23admin in the hash generator
09/01/2015 09:42 swtib91#200
Quote:
Originally Posted by Delwig View Post
put this in

ec114776ae3e950aae571538ef0b280b


it has to be like this 5dd23admin in the hash generator
Omg I love you dude ! :D
09/28/2015 17:54 lmfeiyu#201
Thank you,ismokedrow.
10/26/2015 20:39 Nooobee4#202
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

common.opt

gameserver.opt

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)
10/26/2015 21:10 ThunderNikk#203
S:io.auth.ip:127.0.0.1
S:io.ip_address:25.91.130.165

Only local host can find your auth.
10/26/2015 21:28 Jumper205#204
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?
10/26/2015 21:48 InkDevil#205
Quote:
Originally Posted by Jumper205 View Post
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
Code:
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.
10/26/2015 23:11 Jumper205#206
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...
10/26/2015 23:24 InkDevil#207
Then you should make a post [Only registered and activated users can see links. Click Here To Register...] with your auth.opt-/gameserver.opt-settings.
Even if auth.opt should be fine now when you can already enter the serverlist.
11/09/2015 10:40 Dima34#208
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.
11/12/2015 16:33 eliteplayer100#209
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.
11/12/2015 18:41 ThunderNikk#210
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.