[HOW-TO] Setup 9.1

12/26/2015 10:46 magierhauck#211
guys
which edition of sql server 2014?
Express-Edition?

or which edition u use

need help

[Only registered and activated users can see links. Click Here To Register...]
12/27/2015 12:23 magierhauck#212
i need help guys

kann mir jemand helfen?

[Only registered and activated users can see links. Click Here To Register...]
12/27/2015 14:54 PetTrainer#213
Quote:
Originally Posted by magierhauck View Post
i need help guys

kann mir jemand helfen?

[Only registered and activated users can see links. Click Here To Register...]
hast du ein Passwort in deinem SQL eingestellt ? wenn ja , hasst du dies auch als md5 hash in die .opt's eingetragen ?
12/27/2015 16:05 magierhauck#214
PetTrainer

schau in dein Postfach nach
01/09/2016 18:04 lrd12345#215
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:

Common:

GameServer:

RapprelzAuthServer.exe log:

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 BY SAPPHIRE TEAM[/Edit]
01/10/2016 14:47 Deltajoey14#216
Can anyone help me ?
If i wanna Start "Server.exe" (my CaptainHerlockServer), my Corsor show me that he load anythink. After 4 minutes still nothing open.
01/10/2016 15:39 ThunderNikk#217
Are you getting arcadia.dmp files in the captainherlock folder?

If so it could be name misdirection causing captainherlock to be unable to find the arcadia database or some change to the arcadia database information may have caused it to be unstable.

This is all assuming you have a good enough computer to run the server and you are running it from an administrative account or with administrative rights on the computer.
01/10/2016 15:48 Deltajoey14#218
No i dont have arcadia.dmp in my "Game_bin" folder if u mean that (the folder whit Gameserver.opt) and yeah i have a good pc and full Adminrights. its very crazy because befor i create a account in "SQL>dbo.Accounts" i can start the Server.exe whitout any problems or Errors. btw do you can speak german ? ^^
01/10/2016 16:34 ThunderNikk#219
No I don't speak german.

Your account table is called dbo.accounts and not dbo.account?

If you are using the auth emulator written by glandu2 you may need to take a look at the SQL queries in the auth.opt and make sure they are written for the correct table name.

Other than that you may need to look into how you created the account and if all of the account fields were filled in correctly.

Some examples from the original auth emulator opt file...

Code:
#If the table name is "account":
sql.db_account.query:SELECT * FROM account WHERE account = ? AND password = ?;
sql.db_updatelastserveridx.query:UPDATE account SET last_login_server_idx = ? WHERE account_id = ?;

#If the table name is "accounts" (just change the sql query):
#sql.db_account.query:SELECT * FROM accounts WHERE account = ? AND password = ?;
#sql.db_updatelastserveridx.query:UPDATE accounts SET last_login_server_idx = ? WHERE account_id = ?;
01/10/2016 17:02 Deltajoey14#220
okay i change all to "account" but it still not working. the Server.exe do not want to open.
01/10/2016 18:56 ThunderNikk#221
You can't change your database

You need to change the SQL in the auth.opt

Use the correct one for accounts...comment the wrong ones out.
01/11/2016 09:38 Game_0verrr#222
I have set up the server yesterday and everything is working fine. It should not be noted but the tutorial does not EXPLICITLY states that the OPT files needs to be adjusted with the right credentials in it, also, i don't know where it was used exactly, but in some file i needed to put in the PYROK password. These where the only two things that went wrong with me actually. Thank you so much for a nice tutorial that is easy to follow.
01/19/2016 02:03 xion0374#223
Hey, when I try to unzip the 9.1 files with the password both from the main section, im getting a warning/notion of saying im only getting partial files.

So how do I fix this. or get all the files.
01/19/2016 07:38 CHlNAMAN#224
Redownload the files. Most likely you live in Somalia or a relative country with a bad interwebz.
01/25/2016 13:30 Hirohito1000#225
Please help


[Only registered and activated users can see links. Click Here To Register...]