[HOW-TO] Setup 9.1

08/10/2015 01:12 ThunderNikk#166
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;"

So you tell us then why it can not connect to your SQL server...

Did you forget to configure the SQL server port 1433 step or what?
08/11/2015 08:04 simpbro#167
i think i have messed up somewhere, im getting this error when i start capton herlock

also where do i put my password. i got the random passwords but i dont know where. and then when i put the password in do i need to add to a opt file or something?
Quote:
#Database Information:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Auth ----------------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Arcadia -------------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
Telecaster ----------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:
-----------------------------------------------------
-----------------------------------------------------
-----------------------------------------------------
i added passwords in opt but i dont know what console password is. i tried my auth and i still got the same message
######################################
Edit:
########################################
okay i got past that point, now when i login it says wrong password error 18. i used a md5 password and its not working. any sudjestion?


################################################## ##
Edit
################################################## #
hers what i see
[Only registered and activated users can see links. Click Here To Register...]
08/11/2015 12:35 ThunderNikk#168
Did you MD5 your password with the MD5 key???

If Key = 2011

And If Password = password

Then MD5 2011password

Put the result in your account table.
08/11/2015 13:01 simpbro#169
i believe it is just md5 i used page one as the guide. is used Miracle Salad MD5 as my password gen. i will try both 2011 and normal. ill screen shot what my account table looks like after. also how do i tell if mine is md5 or md52011?
################################################## ##
Edit
################################################## ##
dont worry it was having that problem because my server auth.exe said cannot connect to user sa. i added a password to my sa and it connects now. but now my gameserver.opt is messing up my sherlok it now says that it can nonot connect to user sa.

i am having a sleep and i hope this makes sence in the morning.

this is all my opt files opt files . if there is a mistake please let me know



is it possible to make everything the same password? does it need to be MD5? and what is console password is it my auth password?

if you had one that i could coppy exactly and all i needed to do is change my passwords for auth,telecaster and arcadia in sqp that would be so good.

oh and this is my passwords i have put on my DBs
08/11/2015 16:03 ThunderNikk#170
auth.db.salt:5dd23

So it is MD5 the salt plus the password for user accounts just like it says in the .opt file example...

# [Only registered and activated users can see links. Click Here To Register...] (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]

So if you want your user account password when you log into the game to be password then you MD5...

5dd23password

So the password you have for Auth says it is your telecaster password in your table...

auth.db.password:rgTnwlh0oXdBwEOTjjrxl4

Telecaster ----------------------------------------
-----------------------------------------------------
Table Name:
User Name:
User Password:rgTnwlh0oXdBwEOTjjrxl4

So I am not sure where to tell you to go for those passwords.

You have it entered correctly for the auth.opt in plain text...(version 4.0 allows Pyroks DES encryption)

The other passwords for whatever databases they are for in the gameserver.opt will be encrypted with Pyroks DES encryption...

S:db.c._password:qopZypDHLRipGWeE9UsoSt
S:db.user._password:rgTnwlh0oXdBwEOTjjrxl4 (this is the same as your auth password???)

Those are both unencrypted and will not work.

So you have chosen not to follow the guide and you are using user "sa" then you come here and ask everyone else to solve your problems because you have not followed the guide.
08/11/2015 23:15 simpbro#171
I copped everything from this guide. I did not mean to put it as user sa. infact i dont even know how to change the user. I dont expect people to solve my problem, i only wanted guidance. im sorry if i came across that way
08/12/2015 00:29 ThunderNikk#172
Well I hope I gave you enough guidance, because I really only re wrote what some of the guide has already guided.
08/12/2015 08:04 simpbro#173
actually it did help. i fixed my problems, works fine. i guess having a break made it better.

i am having another problem, and i have searched and cant find a clear answer on the forum, i only want to play lan with my friends. so i changed my server .opt ip to my ipv4 in stead of 17.0.0.1 (or something like that). but what does my friend need to do to their computer to let them connect? i just though i add i have red the begining where it says if you want people to connect change your ip... but what does my friend need to do?

is there something my friend is doing wrong or is it in my opt files?

Auth.opt

game server.opt

friends launcher.bat
08/12/2015 12:52 ThunderNikk#174
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1

The only one I see that you have changed is the log IP which doesn't matter which way it is.
08/12/2015 19:11 dervish7#175
and if the report server is not ustanavlivayutsya this could be the problem?

but if the service report server are not put in this could be the problem?

the fact that I can't start the server
08/12/2015 20:10 ThunderNikk#176
Out of all the times I have seen your .opt files posted they are never right.

You refuse to start with the example .opt files posted in the guide and continue to use your own incorrect ones.

I am pretty sure that is why you cant start the server.

You never answered me last time...

Did you configure port 1433 for your SQL server or not?

The following step...

TCP/IP Enabled (In SQL Configuration Manager under protocols) enabled

Caution: It is advised to not only firewall lock 1433 but if you MUST have external use to use a custom port and change it often couple with strict permission based database accounts.
08/12/2015 23:33 Sharezzz#177
NULLED
08/13/2015 02:11 simpbro#178
I changed my
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1

to

S:io.auth.ip:192.168.1.9
S:io.ip_address:192.168.1.9

and my capton Herlock says


I tried changing my ports/ip adresses in my auth.opt but i really dont know what to do.
08/13/2015 02:54 SilentWisdom#179
You leave the S:io_auth.ip as 127.0.0.1, no reason for the gs to connect to as externally. Only change the S:io.ip_address
08/13/2015 04:06 ThunderNikk#180
Guess I just post that one because my game server ports are open for it to connect on my lan even running on the same computer it connects on my lan.