Register for your free account! | Forgot your password?


You last visited: Today at 00:01

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



DB Errors

Discussion on DB Errors within the Rappelz Private Server forum part of the Rappelz category.

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
Exclamation DB Errors

Hey everyone im new here and i have tried using the search and there is nothing about it here, Don't be ignorant and tell me to use the search because i have!

Anyway the error is when i start princessauroraserver.exe and i get this error:

AUTH DB INIT ERROR: [DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access denied, Here is my authserver.opt and gameserver.opt, The details in there are correct and the SQL is set up correctly.

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:
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:0
N db.auth.md5_key:2011
gameserver.opt :

Code:
S app.name:game001
S auth.server_idx:1
S auth.server_name:FWCentral-Rappelz
S db.game.ip:127.0.0.1
S db.c.password:
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:
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.port:4514
S io.ip_address:127.0.0.1
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:10
S game.item_drop_rate:10
S game.gold_drop_rate:10
S game.chaos_drop_rate:10
S game.party_drop_rate:10
T game.use_login_logout_debug:0
T game.max_level:170
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:60
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:400
T set_user_limit:1000
N game.skip_loading_attribute:1
S io.upload.ip:127.0..1
S io.upload.port:4616
Thanks in advance for any help on this issue.
liamknight24 is offline  
Old 04/03/2012, 22:08   #2


 
elite*gold: 0
Join Date: May 2011
Posts: 5,083
Received Thanks: 3,443
Those settings looks right for me (I just looked at the DB-Part, also I didn't even read the topic. ^^).

It seems that you have some issues with your SQL Server, means it isn't set up correctly.

Take a look in JW988's Guide, there you can find the right setup for it.
Xijezu is offline  
Old 04/03/2012, 22:12   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
Hey thanks for the reply mate, I am using SQL 2012 i followed JW988's guide and did everything like he said, I can connect to it using SQL manager using user sa and removed the password, im using windows 7 64bit if that helps :P
liamknight24 is offline  
Old 04/03/2012, 22:20   #4


 
elite*gold: 0
Join Date: May 2011
Posts: 5,083
Received Thanks: 3,443
Quote:
Originally Posted by liamknight24 View Post
Hey thanks for the reply mate, I am using SQL 2012 i followed JW988's guide and did everything like he said, I can connect to it using SQL manager using user sa and removed the password, im using windows 7 64bit if that helps :P
I personally would say use SQL 2008 R2 instead of 2012. :/ 2012 is still in Beta if I remember right.

Well, nvm.

When you are able to login with (local)/localhost/127.0.0.1/etc. instead of telling him the specified instance, then the connection with the Gameserver should work, too.
Xijezu is offline  
Old 04/03/2012, 22:29   #5
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
Hmm ill remove 2012 and put 2008 and get back to you thanks
liamknight24 is offline  
Old 04/03/2012, 22:31   #6
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,601
Received Thanks: 1,204
Check if you enabled the TCP/IP protocol for the instance in the Configuration Manager. It's disabled by default.
c1ph3r is offline  
Thanks
1 User
Old 04/03/2012, 22:39   #7
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
yeah i did that mate
liamknight24 is offline  
Old 04/03/2012, 23:37   #8
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 266
The issue is from the MSSQL Server that you got; I'm sure it got corrupted while installation just either contact Microsoft support or re-install the MSSQL
→Striker← is offline  
Old 04/04/2012, 00:31   #9
 
elite*gold: 0
Join Date: Mar 2008
Posts: 939
Received Thanks: 516
did u restart the pc after u set up sql config
wisp66 is offline  
Old 04/04/2012, 02:41   #10
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
yeah i restarted the pc before, and i removed SQL 2012 and installed 2008 R2 and now i have another problem, Im on windows XP and when i try to add the database i get an error saying i haven't got enough space but i have 28gb free on the computer so im not sure what is wrong
liamknight24 is offline  
Old 04/04/2012, 02:57   #11
 
elite*gold: 0
Join Date: Oct 2011
Posts: 9
Received Thanks: 1
as far as I know you'll need at least 35-40gb of free hdd space. Also watch out for dump files, those can take out space also. I belive extension for those files is .dmp
oxymnya is offline  
Old 04/04/2012, 06:54   #12
 
elite*gold: 0
Join Date: Mar 2012
Posts: 13
Received Thanks: 2
Quote:
Originally Posted by liamknight24 View Post
Hey everyone im new here and i have tried using the search and there is nothing about it here, Don't be ignorant and tell me to use the search because i have!

Anyway the error is when i start princessauroraserver.exe and i get this error:

AUTH DB INIT ERROR: [DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access denied, Here is my authserver.opt and gameserver.opt, The details in there are correct and the SQL is set up correctly.

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:
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:0
N db.auth.md5_key:2011
gameserver.opt :

Code:
S app.name:game001
S auth.server_idx:1
S auth.server_name:FWCentral-Rappelz
S db.game.ip:127.0.0.1
S db.c.password:
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:
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.port:4514
S io.ip_address:127.0.0.1
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:10
S game.item_drop_rate:10
S game.gold_drop_rate:10
S game.chaos_drop_rate:10
S game.party_drop_rate:10
T game.use_login_logout_debug:0
T game.max_level:170
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:60
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:400
T set_user_limit:1000
N game.skip_loading_attribute:1
S io.upload.ip:127.0..1
S io.upload.port:4616
Thanks in advance for any help on this issue.


pm Skype ProdDevStar .. i can install server to you =)
ProdStar is offline  
Thanks
1 User
Old 04/04/2012, 10:48   #13
 
elite*gold: 0
Join Date: Mar 2012
Posts: 201
Received Thanks: 23
enable all in ur SQL Configs

AngelOwns is offline  
Old 04/04/2012, 14:14   #14
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
Ok all the SQL is working fine now thanks but whenever i start the game server it just crashes, Im using Windows XP if that helps and added you ProdStar
liamknight24 is offline  
Old 04/04/2012, 14:17   #15
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,601
Received Thanks: 1,204
If you want help, post your Crash-Log.
c1ph3r is offline  
Closed Thread

Tags
auth db init error


Similar Threads Similar Threads
Help with those errors plz
11/25/2011 - CO2 Private Server - 0 Replies
Anyone can help me to fix those errors i get in Threading.cs ? It is when i try to build in source 5375.
Errors..?
11/23/2011 - DarkOrbit - 0 Replies
Hey, I was wondering, is it just me, or are we getting lots of 408,502,505 etc errors?:eek:
[Guide] 2 Fixes on Sro-Errors (no bot-errors)
03/04/2011 - SRO Guides & Templates - 5 Replies
Hey guys, here are 2 fixes for silkroad-errors (not bot-errors!). I know they dont appear for many people but some guys have problems with it. 1st Fix: "Server is undergoing inspection..." Why does this error appear? Because Joymax has some problems with the Login-Servers. Fix: Step1): Click on "Start" then on "Run"
my bot gets errors?
06/14/2010 - Ragnarok Online - 2 Replies
i have a auto buffer and it pulls up players as #unknown3453453 and it says cant find player ip 67.202.104.229 port 6900 version 24
some errors
04/29/2009 - Dekaron Private Server - 20 Replies
some errors http://img253.imageshack.us/img253/763/firsterror c.th.jpg http://img253.imageshack.us/img253/9416/seconderr orf.th.jpg sx6 my errors are diferent --'



All times are GMT +2. The time now is 00:01.


Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2021 elitepvpers All Rights Reserved.