Rappelz server files

demonroro · 04/07/2011, 23:05

Quote:

Originally Posted by Gangxtar1

its looking for Auth.mdf , but i dont have this one mssql cant find the path.

added the error msg pic to last post

Try to change the target folder when you restore.

Gangxtar1 · 04/07/2011, 23:08

its the same error again.

cant find Auth.mdf

im off for today gn

demonroro · 04/07/2011, 23:12

@Gangxtar1 try to create an empty db first before restore.
Anyway GN

Gangxtar1 · 04/07/2011, 23:20

created empty db then tried to restore.

its an other error but its still an error

Gn

Link404 · 04/07/2011, 23:23

Quote:

Originally Posted by Gangxtar1

created empty db then tried to restore.

its an other error but its still an error

Gn

Take a look at the options when restoring.

demonroro · 04/07/2011, 23:46

Game server still crashing

Log file :

Spoiler

jw988 · 04/08/2011, 00:19

i got the crash to stop by using the normal game sever not the local host one,
added "127.0.0.1 cadb.nflavor.com" to my windows host file and cleaned
my gameserver.opt file before made it a eop file:

this is all my gameserver.eop file has

Spoiler

also try using only the scripts in the 2009-04-30_Epic6 folder onwards the changed
from lua to ela then and wiped the old script file.

i did notice to if you turn off web auth in the authserver.opt file the game client
tries to access a store procedure in the auth database called smp_account.

demonroro · 04/08/2011, 00:34

Quote:

Originally Posted by jw988

i got the crash to stop by using the normal game sever not the local host one,
added "127.0.0.1 cadb.nflavor.com" to my windows host file and cleaned
my gameserver.opt file before made it a eop file:

this is all my gameserver.eop file has

Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:TestServer

also try using only the scripts in the 2009-04-30_Epic6 folder onwards the changed
from lua to ela then and wiped the old script file.

i did notice to if you turn off web auth in the authserver.opt file the game client
tries to access a store procedure in the auth database called smp_account.

Did you looked at my log file ?

jw988 · 04/08/2011, 01:19

For anyone having trouble here are my game_bin and db backups (from sql 2008 Server):

there on a megaupload account that runs out in 8 days so get them
while you can

small guide:

Spoiler

other things i notice when game server loads it uses 192.168.0.84 ip

to get the client to sort of login to game server list I used Pyroks rl.php file
from this thread in the root of my webserver and told authserver.opt the ip
of it.

you will need to put these command in to auth server window to beable to
connect with client:
start_service
set game.open_external 1

then made bat for client with this in it:

Spoiler

note the game closes when you click on game server in the list thats as far as i have gotten.

jw988 · 04/08/2011, 01:40

i had no luck with 2005 so i changed to my server that has 2008 and all seemed to work for me

jw988 · 04/08/2011, 01:56

Hmm, well I do not know if it helps but I am using windows 7 Ultimate x64
with all the IIS options installed in "control panel", "programs and Features" , "turn windows features on or off" and SQL Server 2008 Enterprise x64 DVD, i did put all 3 data base in ODBC

Pyrok · 04/08/2011, 02:45

Quote:

Originally Posted by jw988

For anyone having trouble here are my game_bin and db backups (from sql 2008 Server):

there on a megaupload account that runs out in 8 days so get them
while you can

small guide:

Spoiler

1. unrar the files
2. make 3 databases in the sql server 2008
Auth
Arcadia
Telecaster
3. Restore using the bak files to each database
make sure you are restoring to the right folders (look under options)
Sql 2008 32bit is under C:\Program Files (x86)\Microsoft SQL Server\
Sql 2008 64bit is under C:\Program Files\Microsoft SQL Server\ (my backups default to this one)
also make sure you have the "overwrite existing database" is ticked
4. in host file add "127.0.0.1 cadb.nflavor.com"
found in win 7 under C:\Windows\System32\drivers\etc

5. run auth server from game_bin
6. run game server from game_bin

other things i notice when game server loads it uses 192.168.0.84 ip

to get the client to sort of login to game server list I used Pyroks rl.php file
from this thread in the root of my webserver and told authserver.opt the ip
of it.

you will need to put these command in to auth server window to beable to
connect with client:
start_service
set game.open_external 1

then made bat for client with this in it:

Spoiler

Start SFrame.exe /auth_ip:192.168.0.20 /locale:ASCII /country:US /cash /commercial_shop

note the game closes when you click on game server in the list thats as far as i have gotten.

Nice work!

I finally broke down and unpacked sframe so I could try to move forward. It looks like it is comparing IP addresses to make sure that the auth and game servers, as well as the client are being run from different ip addresses. I didn't spend much time looking at it, just hex edited the test out instead since I only have 2 pcs to work with. Now I'm getting a disconnected from server message in the background and it just closes when clicking on confirm. I can't see the whole message but at least it's progress.

edit: Man, I can't believe I missed it. It couldn't connect because the game server was listening on port 0, had nothing to do with IP addresses. Add this to gameserver.opt: S io.port:4514

Now I'm at the character creation screen but it just says "You may not create this character."

Tarzandan · 04/08/2011, 05:36

Quote:

Originally Posted by Pyrok

Now I'm at the character creation screen but it just says "You may not create this character."

Screenshots please?

jw988 · 04/08/2011, 05:40

Here you go

Tarzandan · 04/08/2011, 05:43

Seems like your setting for account creation is set to 0 or something.

"Debugged by NCarbon Dev Team

Config File Option :

game.use_login_logout_debug
game.allowed_special_char
game.restrict_special_char

Commands :

clear_auto_account
set_auto_account"

Would any of those help?

Edit: Just realized Pyrok didn't make that last post.