Error Private server Rappelz

narcodu13 · 07/07/2013, 13:58

Bonjour à tous,

Merci pour votre forum très riche!
Malheureusement je n'arrive pas à créer un serveur privé rappelz.
J'ai téléchargé le pack serveur privé.
Suivi le tutoriel de ce lien:

Mais lorsque je lance PrincessAuroraServer.exe j'ai l'erreur suivante:

AUTH DB INIT ERROR: echec de l'ouverture de session 'sa'.
Cela fait deux jours que je travaille en faisant des recherches google, et comme je suis nul en anglais j'ai beaucoup de mal à trouver la solution.
J'ai aussi lancé des recherches sur ce forum mais je n'ai toujours pas trouvé ma réponse.

Auriez vous la gentillesse de m'aider s'il vous plaît?

Désolé d'ecrire en francais mais je suis très nul en anglais.

--------------

Traduction

Hello everyone,

Thank you for your forum very rich!
Unfortunately I can not create a rappelz private server.
I downloaded the private server pack.
Follow this link to the tutorial:
But when I run PrincessAuroraServer.exe I get the following error:

AUTH DB INIT ERROR: failure of the login 'sa'.
It's been two days since I work doing google searches, and as I am no English I have a lot of trouble finding the solution.
I also initiated research on this forum but I still have not found my answer.

Would you kindly help me please?

Sorry to write in french but I'm no English.

ThunderNikk · 07/07/2013, 14:44

Make sure you have set sa as the database owners in your SQL

You also need to change the user to sa in the opt files and then use the compressor to make the eop files.

Also make sure you have used the correct ports in your .opt files before compressing them.

narcodu13 · 07/07/2013, 15:11

Quote:

Originally Posted by thndr

Make sure you have set sa as the database owners in your SQL

You also need to change the user to sa in the opt files and then use the compressor to make the eop files.

Also make sure you have used the correct ports in your .opt files before compressing them.

Merci pour votre réponse rapide. Malgré vos conseils précieux, je ne réussis toujours pas a supprimer cette erreur. Peut-être pouvez vous m'aider.
Voici le contenu de mes fichiers .opt

english translate
Thank you for your quick response. Despite your valuable advice, I still do not manage to suppress this error. Maybe you can help me.
Here are the contents of my files. Opt

Gameserver.opt

Code:

S app.name:FunEntry
S auth.server_idx:1
S auth.server_name:Tortus
S db.game.ip:127.0.0.1
S db.c._password:GKM9VVi.d0L8I (Genered by DES generator)
S db.c.account:sa S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:GKM9VVi.d0L8I (Genered by DES generator)
S db.user.account:sa
S db.user.name:Telecaster
S db.user.server:127.0.0.1
S game.iocp.active:1
S game.console.port:1433
S io.port:1433
S io.ip_address:25.205.170.118
S blank.io.port:1433
S game.server_screenshot_url:
S game.guild_icon_base_url:
S log.disable:1
S log.working:0
S game.exp_rate:1000
S game.item_drop_rate:100
S game.gold_drop_rate:100
S game.chaos_drop_rate:7
T game.use_login_logout_debug:0
T game.max_level:170
T game.use_auto_jail:0
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:1
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
N game.logout_timer:0
S memory.player_heap_size:760
T game.mem_usage_info_save_interval:0
T game.PKServer:0
N game.item_hold_time:1800
S game.cash_item_dropable:0
T game.disable_dungeon_raid_siege:0
T game.limit_dungeon_enterable_level:0
T game.max_storage_item_count:1000
T set_user_limit:1000
N game.skip_loading_attribute:1
S io.upload.ip:127.0.0.1
S io.upload.port:1433

AuthServer.opt

Code:

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:GKM9VVi.d0L8I (Genered by DES generator)
S app.name:TestServer
S log.ip:25.205.170.118
S db.auth.port:1433
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:0
N db.auth.md5_key:2011

Thank you very much

ThunderNikk · 07/07/2013, 16:00

You changed all of your ports to 1433 that is wrong.

Follow the guide for setting up the server. They give examples use the examples.

If you change the ports obviously you will not connect...

Auth

Code:

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:Nottellingyoumypass
S db.auth.port:1433
S app.name:Auth
S io.auth.port:8841
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

Game

Code:

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

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4515
S console._password:Nottellingyoumypass

S db.game.ip:127.0.0.1

S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.c.account:sa
S db.c._password:Nottellingyoumypass

S db.user.name:Telecaster
S db.user.server:127.0.0.1
S db.user.account:sa
S db.user._password:Nottellingyoumypass

S io.auth.ip:Nottellingyoumyip
S io.ip_address:Nottellingyoumyip
S io.port:4504

S io.upload.port:4617

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:1
S game.gold_drop_rate:1
S game.chaos_drop_rate:1
S game.party_drop_rate:1.25
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.monster_pathfinding:1
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:0
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:1
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

Now if you really take a good look at the guide and take a good look at my opt files you will see that I mostly used the example opt files.

The only things I change were the things I needed to change for addresses and passwords and server names.

Don't change ports because they are important. 1433 was the port set up for the SQL configuration manager. There is only one place it is used in the opt files.

narcodu13 · 07/08/2013, 16:42

Merci beaucoup pour votre aide!

J'ai bien avancé maintenant! J'ai résolu mes erreurs qui etaient dus au fait que je pensais que le hash passworld etait déja changé dans les fichiers opt.
puisqu'il en contenait déjà un mais ce n'etais pas le mien. lol.

Maintenant PrincesseAurura et Captain.exe s'executent sans soucis.

J'ai téléchargé un client 7.3 et créé un fichier Launcher.bat avec mon adresse IP
contenant ce code:

Code:

START SFRAME /auth_ip:127.0.0.1 /auth_port:1433 /locale:ASCII /country:FR /commercial_shop /cash

j'entre les identifiants que j'ai créé dans MY SQL

Code:

INSERT INTO Accounts (login_name,passord,block,withdraw_remain_time,age ,auth_ok,pcbanq,last_login_server_idx,event_code,r esult)
VALUE ('MYusername' , 'MYpassword.hashed by dm5' ,0,0,18,1,1,1,0,1)

Cette ligne n'est pas correcte j'ai corrigé les erreurs d'insert et j'ai réussi a inserer la ligne dans les tables de comptes.

Mais lorsque je lance le

Code:

 Launcher.bat

, le jeu s'ouvre j'entre les identifiants et rien ne se passe....

Avez vous des idées?

------------------------------------------------------------------------
In English

Thank you very much for your help!

I look forward now! I solved my errors were due to the fact that I thought the Passworld hash was already changed in the opt file.
since it already contained one but it was not mine. lol.

Now PrincesseAurura Captain.exe and run without problems.

I downloaded and created a file launcher.bat a 7.3 client with my IP address
containing this code:

[code] START sframe / auth_ip: 127.0.0.1 / auth_port: 1433 / locale: ASCII / country: FR / commercial_shop / cash [/ code]

I enter the password that I created in MY SQL

[code] INSERT INTO Accounts (login_name, Passord, block, withdraw_remain_time, age, auth_ok, pcbanq, last_login_server_idx, event_code, r esult)
VALUE ('myusername', 'MYpassword.hashed by dm5' 0,0,18,1,1,1,0,1) [/ code]
This line is not correct I corrected the errors and insert I managed to insert the row in the accounts table.

But when I run the [code] launcher.bat [/ code], the game opens I enter the password and nothing happens ....

Do you have any ideas?

ThunderNikk · 07/08/2013, 19:06

START SFRAME /auth_ip:127.0.0.1 /auth_port:1433 /locale:ASCII /country:FR /commercial_shop /cash

But your auth port is or should be...

S io.auth.port:8841

That's why nothing happens.

Try this one...

START SFRAME /auth_ip:127.0.0.1 /auth_port:8841 /locale:ASCII /country:FR /commercial_shop /cash

narcodu13 · 07/08/2013, 20:31

FRENCH

non malheureusement cela ne fonctionne pas.

lorsque je rentre la commande: set game.open_external 1
il ne se passe rien dans la console PrincessAurora

Le Jeu se lance mais lorsque je m'identifie et clique sur le bonton "se connecter" il ne se passe rien du tout.

ENGLISH

o unfortunately it does not work.

when I get the command: set game.open_external 1
there's nothing going on in the console PrincessAurora

Game starts but when I identify the bonton and click "connect" it nothing happens at all.

Please help me I'm almost to the success!!!

ThunderNikk · 07/08/2013, 21:37

Quote:

Originally Posted by narcodu13

when I get the command: set game.open_external 1
there's nothing going on in the console PrincessAurora

This is normal you should not see anything in the window with this command.

You only see results in the auth window with "start_service" command which you should be doing before "set game.open_external 1"

Quote:

Originally Posted by narcodu13

Game starts but when I identify the bonton and click "connect" it nothing happens at all.

Maybe you still have a port wrong in the gameserver.opt

narcodu13 · 07/09/2013, 12:18

PrincessAurora CaptainHerlockserver.exe and make no mistake.

SQL software is active and connected. The account is created in the bd account.

I do not understand help please! I struggled for three days on it ..

Thank you very much in advance.

ThunderNikk · 07/09/2013, 13:01

Maybe you still have a port wrong in the gameserver.opt

Maybe you could post your current gameserver.opt.

I can not just guess at what is wrong.

narcodu13 · 07/09/2013, 14:24

Thank you for your support!

but in the tutorial screens, you can see that in the Protocols for SQLEXPRESS parameters, there are four elements in the right window, while I have only 3 on my computer. Perhaps this had the most recent version of sql configuration manager?

For the rest it is inexplicable. I tried several combinations but nothing works ...

Gameserver.opt

Code:

S app.name:FunEntry
S auth.server_idx:1
S auth.server_name:Tortus
S db.game.ip:127.0.0.1
S db.c._password:407abd1894382d6b
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:407abd1894382d6b
S db.user.account:sa
S db.user.name:Telecaster
S db.user.server:127.0.0.1
S game.iocp.active:1
S game.console.port:4502
S io.auth.ip:127.0.0.1
S io.port:4514
S io.ip_address:25.205.170.118
S blank.io.port:4502
S game.server_screenshot_url:
S game.guild_icon_base_url:
S log.disable:1
S log.working:0
S game.exp_rate:1000
S game.item_drop_rate:25
S game.gold_drop_rate:20
S game.chaos_drop_rate:7
T game.use_login_logout_debug:0
T game.max_level:170
T game.use_auto_jail:0
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:1
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
N game.logout_timer:0
S memory.player_heap_size:760
T game.mem_usage_info_save_interval:0
T game.PKServer:0
N game.item_hold_time:1800
S game.cash_item_dropable:0
T game.disable_dungeon_raid_siege:0
T game.limit_dungeon_enterable_level:0
T game.max_storage_item_count:1000
T set_user_limit:1000
N game.skip_loading_attribute:1
S io.upload.ip:25.205.170.118
S io.upload.port:1433

authserver.opt

Code:

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:407abd1894382d6b
S app.name:TestServer
S log.ip:127.0.0.1
S db.auth.port:1433
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

Launcher.bat

Code:

START SFRAME /auth_ip:127.0.0.1 /auth_port:1433 /locale:windows-1252 /country:FR /commercial_shop /cash

ThunderNikk · 07/09/2013, 15:14

Add to your authserver.opt...

S io.auth.port:8841

Change in gameserver.opt...

S io.port:4514 to S io.port:4504

S io.upload.port:1433 to S io.upload.port:4617

Change in launcher bat...

START SFRAME /auth_ip:127.0.0.1 /auth_port:1433 /locale:ASCII /country:FR /commercial_shop /cash

to

START SFRAME /auth_ip:127.0.0.1 /auth_port:8841 /locale:ASCII /country:FR /commercial_shop /cash

I am not sure why am am even needing to tell you this, I already suggested using the examples for the .opt files and change what you need to and you still insist on using your own messed up .opt files.

No wonder the game does not work.