Register for your free account! | Forgot your password?

You last visited: Today at 09:16

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

 

DB Errors

Reply
 
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   #2


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
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   #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   #4


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
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   #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   #6
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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   #7
 
elite*gold: 0
Join Date: Apr 2011
Posts: 12
Received Thanks: 0
yeah i did that mate
liamknight24 is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2011
Posts: 275
Received Thanks: 265
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   #9
 
elite*gold: 0
Join Date: Mar 2008
Posts: 939
Received Thanks: 515
did u restart the pc after u set up sql config
wisp66 is offline  
Old   #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   #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   #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   #13
 
elite*gold: 0
Join Date: Mar 2012
Posts: 200
Received Thanks: 23
enable all in ur SQL Configs

AngelOwns is offline  
Old   #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   #15
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
If you want help, post your Crash-Log.


c1ph3r is offline  
Reply

Tags
auth db init error



« Previous Thread | Next Thread »

Similar Threads
Help with those errors plz
Anyone can help me to fix those errors i get in Threading.cs ? It is when i try to build in source 5375.
0 Replies - CO2 PServer - Discussions / Questions
Errors..?
Hey, I was wondering, is it just me, or are we getting lots of 408,502,505 etc errors?:eek:
0 Replies - DarkOrbit
[Guide] 2 Fixes on Sro-Errors (no bot-errors)
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. ...
5 Replies - SRO Guides & Templates
my bot gets errors?
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
2 Replies - Ragnarok Online
some errors
some errors http://img253.imageshack.us/img253/763/firsterrorc.th.jpg http://img253.imageshack.us/img253/9416/seconderrorf.th.jpg sx6...
20 Replies - Dekaron Private Server



All times are GMT +2. The time now is 09:16.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.