[Help Thread] Please post your questions here.

johnnyphraze · 08/30/2018, 09:42

Ok thanks ,I ll do when I go home.I ll try up better photos.

maybe this pics help you

thefear511 · 08/31/2018, 01:31

Quote:

Originally Posted by johnnyphraze

Ok thanks ,I ll do when I go home.I ll try up better photos.

maybe this pics help you

you'll need to restore dbs again, or change your sql version.
may i ask which repack is this and what version ?

Dark Blaze · 08/31/2018, 02:54

Quote:

Originally Posted by thefear511

you'll need to restore dbs again, or change your sql version.
may i ask which repack is this and what version ?

No need to do that, it seems like a permission issue, make sure the user you create has the proper permissions to access the database.

ThunderNikk · 08/31/2018, 12:47

You may not have enabled sa's log in in the security of the MSSQL

NH4NO3+Fuel Oil · 08/31/2018, 18:10

Hello everyone, my humble congratulations for the incredible work you've done and you're still doing. I've played Rappelz on official servers some years ago and really enjoyed this game. I would like to set up a private server in order to play with few friends over Hamachi. My first objective however, is to set up a local server, and then move to a Hamachi one.

I've followed the guide, restored the databases. I'm facing up with some issues with the .opt files. I would like you to explain me what each line requires, because it's not clear to me... I've marked the lines with *****************
The remaining lines should be quite self-explanatory.
Hope I'm not asking for anything too expensive in terms of time.
Thank you for any help you may be willing to provide. I strongly believe this may help many others.

Bye

Authserver.opt

S:app.name:***********************
S:auth.allowed_special_char:@.
N:auth.check_adult_server:0
N:auth.max_client_per_ip:9999
N:auth.max_daily_client_per_ip:9999999
N:auth.user_rate_mod:20
N:auth.version:201507080
S:io.ip_address:**********************
S:db.auth._password:
S:db.auth.account:sa
S:db.auth.md5_key:2011
S:db.auth.name:**********************
S:db.auth.server:****************
N:io.auth.port:9881
S:db.billing.account:sa
S:db.billing.name:BILLING
S:db.billing.server:**********************
N:db.auth.use_md5:1
N:db.auth.use_md5_for_security_no:1
N:game.user_limit_server_001:400
S:log.ip:*************************
N:billing.allow_login_without_billing:0
N:billing.check_server_keep_alive_timeout:0
N:billing.server_keep_alive_interval:6000
N:billing.server_keep_alive_timeout:3000
N:billing.use:0
N:billing.user_keep_alive_interval:60000
N:billing.user_keep_alive_timeout:3000

Gameserver.opt

S:app.name:********************
N:auth.server_idx:1
S:auth.server_name:******************
S:db.c.name:Arcadia
S:db.c._password:
S:db.c.account:sa
S:db.c.server:******************
S:db.user._password:
S:db.user.account:sa
S:db.user.name:Telecaster
S:db.user.server:*******************

ThunderNikk · 08/31/2018, 19:17

Authserver

S:app.name:*********************** Title listed on the application window. (Can be Fluffy Unicorns if that's the application name you want, most would put Auth Server or Princess Aurora.

S:io.ip_address:**********************127.0.0.1 (Hamachi here later)

S:db.auth.name:**********************(The name of your Auth database usually auth

S:db.auth.server:****************127.0.0.1 (Address of your auth server database can stay local host cause your just directing the app here)

S:db.billing.server:**********************127.0.0. 1 (Address of your billimg server database can stay local host cause your just directing the app here)

S:log.ip:*************************127.0.0.1 (Where you want the Fluffy Unicorn app to save your log file)

Gameserver

S:app.name:******************** Title listed on the application window. (Can be Fluffy Bunnies if that's the application name you want, most would put Game Server or Captain Herlock .

S:auth.server_name:****************** What you want your server called on the selection screen

S:db.c.server:******************127.0.0.1 address of the Arcadia Database

S:db.user.server:******************* 127.0.0.1 address of the Telecaster Database

There is a lot more to the gameserver.opt you don't have here.

There are also examples in the guide that you can use that will run your server local host.

NH4NO3+Fuel Oil · 08/31/2018, 19:27

Thank you very much, trying now, I'll give feeeback
Concerning gameserver.opt, I know, I have omitted the remaining lines

mmm, captainherlock is crashing with this dmp:

Spoiler

ThunderNikk · 09/01/2018, 01:33

Whats your Arcadia database named?

thefear511 · 09/01/2018, 03:49

Quote:

Originally Posted by Dark Blaze

No need to do that, it seems like a permission issue, make sure the user you create has the proper permissions to access the database.

uh the only time i encountered that issue was because i had a non match sql version and my dbs were mostly corrupted.

NH4NO3+Fuel Oil · 09/01/2018, 09:10

Quote:

Originally Posted by ThunderNikk

Whats your Arcadia database named?

Yup, I read some thread page regarding misnaming of Arcadia db resulting in CptHerlock crashes.

Unfortunately my Arcadia db is named... Arcadia
I have a second Arcadia named ArcadiaInfo

However, just to provide some more info, I'm trying to use this release:

I've spotted a potential mistake, but it is related to Billing db (it's still Billing94, I forgot to rename it), so I don't know if it is relevant to CptHerlock crash.

Dark Blaze · 09/01/2018, 13:52

Quote:

Originally Posted by thefear511

uh the only time i encountered that issue was because i had a non match sql version and my dbs were mostly corrupted.

SQL Server doesn't let you restore a backup that was done on a higher version so the SQL version mistmatch is ruled out, the SQL error he posted clearly states that he isn't authorized to access the database.

ThunderNikk · 09/01/2018, 15:19

Quote:

Originally Posted by NH4NO3+Fuel Oil

Yup, I read some thread page regarding misnaming of Arcadia db resulting in CptHerlock crashes.

Unfortunately my Arcadia db is named... Arcadia
I have a second Arcadia named ArcadiaInfo

However, just to provide some more info, I'm trying to use this release:

I've spotted a potential mistake, but it is related to Billing db (it's still Billing94, I forgot to rename it), so I don't know if it is relevant to CptHerlock crash.

You should rename billing.

You should also start with the example .opts in the guide which will allow you to run a local server. Get the server up and running first then you can add or change stuff in the .opts later knowing what you changed or added before something stops working can help you fix things. They provide those things in the guide for your benefit.

thefear511 · 09/01/2018, 16:46

Quote:

Originally Posted by Dark Blaze

SQL Server doesn't let you restore a backup that was done on a higher version so the SQL version mistmatch is ruled out, the SQL error he posted clearly states that he isn't authorized to access the database.

i know that part, but the version i had was cracked and all that stuff xd

NH4NO3+Fuel Oil · 09/01/2018, 17:44

Ok, I made it, server running. Now I'm having some troubles with gameguard (err code 150) when I launch the Sframe. I checked gameserver.opt, but N:game.use_security: is already set to 0... Any idea ?

Ok, sorted out. One last doubt... is language localization on client or on server side ?

ThunderNikk · 09/01/2018, 20:23

Both

Server side needs to use the right string resource and depending on the language using the US client may prove to be more difficult than using a EU client or the KTS client. Arabic languages really need to use the Arabic sframe.

Then it is driven by your launch arguments in the .bat launcher.