DB Errors

Page 2 of 2

04/04/2012 15:41 liamknight24#16

Heres the log:

Code:

2012-04-04 08:40:01 Network initialize...   ok

2012-04-04 08:40:01 IOCP initialize...  ok

2012-04-04 08:40:01 Starting IOCP thread pool...  ok

2012-04-04 08:40:01 LUA initialize...   ok

2012-04-04 08:40:05 Launching ARCADIA...   ok

2012-04-04 08:40:05 Start loading...


2012-04-04 08:40:05 Loading max Item index...  (8)  ok


2012-04-04 08:40:05 Loading Complete.


2012-04-04 08:40:08 Total 229165 String loaded...

2012-04-04 08:40:08 Total 119 String(local) info loaded...

2012-04-04 08:40:08 Total 38/38 AuctionCategoryResource loaded.

2012-04-04 08:40:08 Total 9 SetItemEffect loaded...

2012-04-04 08:40:09 Total 4023 Monster info loaded...

2012-04-04 08:40:09 Total 136 Summon info loaded...

2012-04-04 08:40:09 Total 87 Summon Level Bonus info loaded...

2012-04-04 08:40:09 Total 1481 DropGroup info loaded...

2012-04-04 08:40:09 Total 0 DropGroup(local) info loaded...

2012-04-04 08:40:09 Total 119 Summon Default Name loaded...

2012-04-04 08:40:09 Total 0 Summon Unique Name loaded...

2012-04-04 08:40:09 Total 7810 Item loaded...

2012-04-04 08:40:09 Total 0 Item(local) info loaded...

2012-04-04 08:40:09 Loading Script : M000_000.nfs

2012-04-04 08:40:09 Loading Script : M005_000.nfs

2012-04-04 08:40:09 Loading Script : M007_000.nfs

2012-04-04 08:40:09 Loading Script : M009_000.nfs

2012-04-04 08:40:09 Loading Script : M010_000.nfs

2012-04-04 08:40:09 Loading Script : M011_000.nfs

2012-04-04 08:40:09 Loading Script : M012_000.nfs

2012-04-04 08:40:09 Loading Script : M013_000.nfs

2012-04-04 08:40:09 Loading Script : M000_001.nfs

2012-04-04 08:40:09 Loading Script : M001_001.nfs

2012-04-04 08:40:09 Loading Script : M007_001.nfs

2012-04-04 08:40:09 Loading Script : M008_001.nfs

2012-04-04 08:40:09 Loading Script : M009_001.nfs

2012-04-04 08:40:09 Loading Script : M010_001.nfs

2012-04-04 08:40:09 Loading Script : M011_001.nfs

2012-04-04 08:40:09 Loading Script : M012_001.nfs

2012-04-04 08:40:09 Loading Script : M013_001.nfs

2012-04-04 08:40:09 Loading Script : M009_002.nfs

2012-04-04 08:40:09 Loading Script : M010_002.nfs

2012-04-04 08:40:09 Loading Script : M011_002.nfs

2012-04-04 08:40:09 Loading Script : M012_002.nfs

2012-04-04 08:40:09 Loading Script : M013_002.nfs

2012-04-04 08:40:09 Loading Script : M006_003.nfs

2012-04-04 08:40:09 Loading Script : M007_003.nfs

2012-04-04 08:40:09 Total 0/0 AutoAuctionResource loaded.

2012-04-04 08:40:09 Loading Script : M008_003.nfs

2012-04-04 08:40:09 Loading Script : M009_003.nfs

2012-04-04 08:40:09 Loading Script : M010_003.nfs

2012-04-04 08:40:09 Loading Script : M011_003.nfs

2012-04-04 08:40:09 Loading Script : M012_003.nfs

2012-04-04 08:40:09 Loading Script : M013_003.nfs

2012-04-04 08:40:09 Loading Script : M006_004.nfs

2012-04-04 08:40:09 Loading Script : M007_004.nfs

2012-04-04 08:40:09 Loading Script : M008_004.nfs

2012-04-04 08:40:09 Loading Script : M009_004.nfs

2012-04-04 08:40:09 Loading Script : M010_004.nfs

2012-04-04 08:40:09 Loading Script : M011_004.nfs

2012-04-04 08:40:09 Loading Script : M012_004.nfs

2012-04-04 08:40:09 Loading Script : M013_004.nfs

2012-04-04 08:40:09 Loading Script : M005_005.nfs

2012-04-04 08:40:09 Loading Script : M006_005.nfs

2012-04-04 08:40:09 Loading Script : M007_005.nfs

2012-04-04 08:40:09 Loading Script : M008_005.nfs

2012-04-04 08:40:09 Loading Script : M009_005.nfs

2012-04-04 08:40:09 Loading Script : M010_005.nfs

2012-04-04 08:40:09 Loading Script : M012_005.nfs

2012-04-04 08:40:09 Loading Script : M013_005.nfs

2012-04-04 08:40:09 Loading Script : M005_006.nfs

2012-04-04 08:40:09 Loading Script : M006_006.nfs

2012-04-04 08:40:09 Loading Script : M007_006.nfs

2012-04-04 08:40:09 Loading Script : M008_006.nfs

2012-04-04 08:40:09 Loading Script : M009_006.nfs

2012-04-04 08:40:09 Loading Script : M010_006.nfs

2012-04-04 08:40:09 Loading Script : M011_006.nfs

2012-04-04 08:40:09 Loading Script : M012_006.nfs

2012-04-04 08:40:09 Loading Script : M013_006.nfs

2012-04-04 08:40:09 Loading Script : M005_007.nfs

2012-04-04 08:40:09 Loading Script : M006_007.nfs

2012-04-04 08:40:09 Loading Script : M007_007.nfs

2012-04-04 08:40:09 Loading Script : M008_007.nfs

2012-04-04 08:40:09 Loading Script : M009_007.nfs

2012-04-04 08:40:09 Loading Script : M010_007.nfs

2012-04-04 08:40:09 Loading Script : M011_007.nfs

2012-04-04 08:40:09 Loading Script : M012_007.nfs

2012-04-04 08:40:09 Loading Script : M013_007.nfs

2012-04-04 08:40:09 Loading Script : M005_008.nfs

2012-04-04 08:40:09 Loading Script : M006_008.nfs

2012-04-04 08:40:09 Loading Script : M007_008.nfs

2012-04-04 08:40:09 Loading Script : M008_008.nfs

2012-04-04 08:40:09 Loading Script : M009_008.nfs

2012-04-04 08:40:10 Loading Script : M010_008.nfs

2012-04-04 08:40:10 Loading Script : M011_008.nfs

2012-04-04 08:40:10 Loading Script : M012_008.nfs

2012-04-04 08:40:10 Loading Script : M013_008.nfs

2012-04-04 08:40:10 Loading Script : M007_009.nfs

2012-04-04 08:40:10 Loading Script : M008_009.nfs

2012-04-04 08:40:10 Loading Script : M009_009.nfs

2012-04-04 08:40:10 Loading Script : M010_009.nfs

2012-04-04 08:40:10 Loading Script : M011_009.nfs

2012-04-04 08:40:10 Loading Script : M012_009.nfs

2012-04-04 08:40:10 Loading Script : M013_009.nfs

2012-04-04 08:40:10 Loading Script : M012_010.nfs

2012-04-04 08:40:10 Map Loading Complete..

2012-04-04 08:40:10 Total 1211 Skill info loaded...

2012-04-04 08:40:10 Total 890 Skill Job Point table loaded...

2012-04-04 08:40:10 Total 4016 Skill Tree table loaded...

2012-04-04 08:40:10 Total 384 Quest info loaded...

2012-04-04 08:40:10 Total 462 QuestLink info loaded...

2012-04-04 08:40:10 ���� �������� ��������! code[703001]

2012-04-04 08:40:10 ���� �������� ��������! code[703001]

2012-04-04 08:40:10 ���� �������� ��������! code[704001]

2012-04-04 08:40:10 ���� �������� ��������! code[704001]

2012-04-04 08:40:10 Total 0 RandomPool info loaded...

2012-04-04 08:40:10 Total 2695 Market info loaded...

2012-04-04 08:40:10 Total 300 LevelUpTable info loaded...

2012-04-04 08:40:10 Total 0/0 AutoAuctionRegistrationInfo loaded...

2012-04-04 08:40:10 Total 300 SummonLevelUpTable info loaded...

2012-04-04 08:40:10 Total 3328 Location info loaded...

2012-04-04 08:40:10 Total 874 Stat info loaded...

2012-04-04 08:40:10 Total 42 Job info loaded...

2012-04-04 08:40:10 Total 668 State info loaded...

2012-04-04 08:40:10 Total 0 BannedWord info loaded...

2012-04-04 08:40:10 Total 221 Enhance info loaded...

2012-04-04 08:40:10 Total 0 Auto account loaded...

2012-04-04 08:40:10 Total 0 GlobalVariable loaded...

2012-04-04 08:40:10 Channel info loading complete...

2012-04-04 08:40:10 Total 0 Alliance loaded.

2012-04-04 08:40:10 Total 0 Guild loaded.

2012-04-04 08:40:10 Total 1052 Mix info loaded...

2012-04-04 08:40:10 Dungeon info loading complete...

2012-04-04 08:40:10 Dungeon Tactical Position info loading complete...

2012-04-04 08:40:10 Total 0/6 Field Prop Switching loaded...

2012-04-04 08:40:10 Total 25/25 RoamingResource, 95/95 RoamingPointResource loaded.

2012-04-04 08:40:10 Total 0/0 AuctionInfo loaded...

2012-04-04 08:40:10 Total 463 Field Prop loaded...

2012-04-04 08:40:10 Total 0/0 ItemKeepingInfo loaded...

2012-04-04 08:40:10 FieldPropData Loading Complete..

2012-04-04 08:40:10 Total 0 Party loaded.

2012-04-04 08:40:10 Total 0/0 ScheduledCommand loaded...

2012-04-04 08:40:10 Total 22 AllowedCommandsForPermission info loaded...

2012-04-04 08:40:10 Total 40 Pet info loaded...

2012-04-04 08:40:10 Total 4 RankingInfo, 0 RankingScore loaded...

2012-04-04 08:40:10 Total 554 NPC loaded...

Also i cant run captainherlockserver do i need this?

04/04/2012 19:16 testing12#17

please, nobody spoonfeed the answer to this issue, its easily found. just look at the text closely and its an easily spotted mistake.

took me 2 seconds to spot it.

there is 1 incorrect line that is preventing the game server from connecting to the database, once you have fixed the error the problem should go away. observation is the key to success in a lot of situations.

sorry if i seem blunt but people never learn if they are spoonfed answers.

Spoiler

04/04/2012 20:57 liamknight24#18

yeah i got that a while ago testing12 thanks, I still get the same issue after changing the 127.0..1 now it just loads then dissapears, heres the log:

Code:

2012-04-04 14:10:40 Network initialize...   ok
2012-04-04 14:10:40 IOCP initialize...  ok
2012-04-04 14:10:40 Starting IOCP thread pool...  ok
2012-04-04 14:10:40 LUA initialize...   ok
2012-04-04 14:10:41 Launching ARCADIA...   ok
2012-04-04 14:10:41 Start loading...

2012-04-04 14:10:42 Loading max Item index...  (8)  ok

2012-04-04 14:10:42 Loading Complete.

2012-04-04 14:10:45 Total 229165 String loaded...
2012-04-04 14:10:45 Total 119 String(local) info loaded...
2012-04-04 14:10:45 Total 24 SetItemEffect loaded...
2012-04-04 14:10:45 Total 38/38 AuctionCategoryResource loaded.
2012-04-04 14:10:45 Total 4023 Monster info loaded...
2012-04-04 14:10:45 Total 141 Summon info loaded...
2012-04-04 14:10:45 Total 87 Summon Level Bonus info loaded...
2012-04-04 14:10:46 Total 1481 DropGroup info loaded...
2012-04-04 14:10:46 Total 0 DropGroup(local) info loaded...
2012-04-04 14:10:46 Total 119 Summon Default Name loaded...
2012-04-04 14:10:46 Total 0 Summon Unique Name loaded...
2012-04-04 14:10:46 Total 7810 Item loaded...
2012-04-04 14:10:46 Total 0 Item(local) info loaded...
2012-04-04 14:10:46 Total 0/0 AutoAuctionResource loaded.
2012-04-04 14:10:46 Loading Script : M000_000.nfs
2012-04-04 14:10:46 Loading Script : M005_000.nfs
2012-04-04 14:10:46 Loading Script : M007_000.nfs
2012-04-04 14:10:46 Total 2041 Skill info loaded...
2012-04-04 14:10:46 Loading Script : M009_000.nfs
2012-04-04 14:10:46 Loading Script : M010_000.nfs
2012-04-04 14:10:46 Loading Script : M011_000.nfs
2012-04-04 14:10:46 Loading Script : M012_000.nfs
2012-04-04 14:10:46 Total 890 Skill Job Point table loaded...
2012-04-04 14:10:46 Loading Script : M013_000.nfs
2012-04-04 14:10:46 Loading Script : M000_001.nfs
2012-04-04 14:10:46 Loading Script : M001_001.nfs
2012-04-04 14:10:46 Loading Script : M007_001.nfs
2012-04-04 14:10:46 Loading Script : M008_001.nfs
2012-04-04 14:10:46 Loading Script : M009_001.nfs
2012-04-04 14:10:46 Loading Script : M010_001.nfs
2012-04-04 14:10:46 Loading Script : M011_001.nfs
2012-04-04 14:10:46 Loading Script : M012_001.nfs
2012-04-04 14:10:46 Loading Script : M013_001.nfs
2012-04-04 14:10:46 Loading Script : M009_002.nfs
2012-04-04 14:10:46 Loading Script : M010_002.nfs
2012-04-04 14:10:46 Loading Script : M011_002.nfs
2012-04-04 14:10:46 Loading Script : M012_002.nfs
2012-04-04 14:10:46 Loading Script : M013_002.nfs
2012-04-04 14:10:46 Total 6463 Skill Tree table loaded...
2012-04-04 14:10:46 Loading Script : M006_003.nfs
2012-04-04 14:10:46 Loading Script : M007_003.nfs
2012-04-04 14:10:46 Loading Script : M008_003.nfs
2012-04-04 14:10:46 Loading Script : M009_003.nfs
2012-04-04 14:10:46 Loading Script : M010_003.nfs
2012-04-04 14:10:46 Loading Script : M011_003.nfs
2012-04-04 14:10:46 Loading Script : M012_003.nfs
2012-04-04 14:10:46 Loading Script : M013_003.nfs
2012-04-04 14:10:46 Loading Script : M006_004.nfs
2012-04-04 14:10:46 Loading Script : M007_004.nfs
2012-04-04 14:10:46 Loading Script : M008_004.nfs
2012-04-04 14:10:46 Loading Script : M009_004.nfs
2012-04-04 14:10:46 Loading Script : M010_004.nfs
2012-04-04 14:10:46 Loading Script : M011_004.nfs
2012-04-04 14:10:46 Loading Script : M012_004.nfs
2012-04-04 14:10:46 Loading Script : M013_004.nfs
2012-04-04 14:10:46 Loading Script : M005_005.nfs
2012-04-04 14:10:46 Loading Script : M006_005.nfs
2012-04-04 14:10:46 Loading Script : M007_005.nfs
2012-04-04 14:10:46 Loading Script : M008_005.nfs
2012-04-04 14:10:47 Loading Script : M009_005.nfs
2012-04-04 14:10:47 Loading Script : M010_005.nfs
2012-04-04 14:10:47 Loading Script : M012_005.nfs
2012-04-04 14:10:47 Loading Script : M013_005.nfs
2012-04-04 14:10:47 Loading Script : M005_006.nfs
2012-04-04 14:10:47 Loading Script : M006_006.nfs
2012-04-04 14:10:47 Loading Script : M007_006.nfs
2012-04-04 14:10:47 Loading Script : M008_006.nfs
2012-04-04 14:10:47 Loading Script : M009_006.nfs
2012-04-04 14:10:47 Loading Script : M010_006.nfs
2012-04-04 14:10:47 Loading Script : M011_006.nfs
2012-04-04 14:10:47 Loading Script : M012_006.nfs
2012-04-04 14:10:47 Loading Script : M013_006.nfs
2012-04-04 14:10:47 Loading Script : M005_007.nfs
2012-04-04 14:10:47 Loading Script : M006_007.nfs
2012-04-04 14:10:47 Loading Script : M007_007.nfs
2012-04-04 14:10:47 Loading Script : M008_007.nfs
2012-04-04 14:10:47 Loading Script : M009_007.nfs
2012-04-04 14:10:47 Loading Script : M010_007.nfs
2012-04-04 14:10:47 Loading Script : M011_007.nfs
2012-04-04 14:10:47 Loading Script : M012_007.nfs
2012-04-04 14:10:47 Loading Script : M013_007.nfs
2012-04-04 14:10:47 Loading Script : M005_008.nfs
2012-04-04 14:10:47 Loading Script : M006_008.nfs
2012-04-04 14:10:47 Loading Script : M007_008.nfs
2012-04-04 14:10:47 Loading Script : M008_008.nfs
2012-04-04 14:10:47 Loading Script : M009_008.nfs
2012-04-04 14:10:47 Loading Script : M010_008.nfs
2012-04-04 14:10:47 Loading Script : M011_008.nfs
2012-04-04 14:10:47 Loading Script : M012_008.nfs
2012-04-04 14:10:47 Loading Script : M013_008.nfs
2012-04-04 14:10:47 Loading Script : M007_009.nfs
2012-04-04 14:10:47 Loading Script : M008_009.nfs
2012-04-04 14:10:47 Loading Script : M009_009.nfs
2012-04-04 14:10:47 Loading Script : M010_009.nfs
2012-04-04 14:10:47 Loading Script : M011_009.nfs
2012-04-04 14:10:47 Loading Script : M012_009.nfs
2012-04-04 14:10:47 Loading Script : M013_009.nfs
2012-04-04 14:10:47 Loading Script : M012_010.nfs
2012-04-04 14:10:47 Map Loading Complete..
2012-04-04 14:10:47 ���� �������� ��������! code[703001]
2012-04-04 14:10:47 ���� �������� ��������! code[703001]
2012-04-04 14:10:47 ���� �������� ��������! code[704001]
2012-04-04 14:10:47 ���� �������� ��������! code[704001]
2012-04-04 14:10:47 Total 2695 Market info loaded...
2012-04-04 14:10:47 Total 384 Quest info loaded...
2012-04-04 14:10:47 Total 300 LevelUpTable info loaded...
2012-04-04 14:10:47 Total 462 QuestLink info loaded...
2012-04-04 14:10:47 Total 170 SummonLevelUpTable info loaded...
2012-04-04 14:10:47 Total 0 RandomPool info loaded...
2012-04-04 14:10:47 Total 881 Stat info loaded...
2012-04-04 14:10:47 Total 0/0 AutoAuctionRegistrationInfo loaded...
2012-04-04 14:10:47 Total 3328 Location info loaded...
2012-04-04 14:10:47 Total 42 Job info loaded...
2012-04-04 14:10:48 Total 1436 State info loaded...
2012-04-04 14:10:48 Total 0 BannedWord info loaded...
2012-04-04 14:10:48 Total 221 Enhance info loaded...
2012-04-04 14:10:48 Total 0 Auto account loaded...
2012-04-04 14:10:48 Total 0 GlobalVariable loaded...
2012-04-04 14:10:48 Channel info loading complete...
2012-04-04 14:10:48 Total 0 Alliance loaded.
2012-04-04 14:10:48 Total 0 Guild loaded.
2012-04-04 14:10:48 Dungeon info loading complete...
2012-04-04 14:10:48 Dungeon Tactical Position info loading complete...
2012-04-04 14:10:48 Total 3794 Mix info loaded...
2012-04-04 14:10:48 Total 0/6 Field Prop Switching loaded...
2012-04-04 14:10:48 Total 624 Field Prop loaded...
2012-04-04 14:10:48 Total 25/25 RoamingResource, 95/95 RoamingPointResource loaded.
2012-04-04 14:10:48 Total 0/0 AuctionInfo loaded...
2012-04-04 14:10:48 Total 0/0 ItemKeepingInfo loaded...
2012-04-04 14:10:48 Total 22 AllowedCommandsForPermission info loaded...
2012-04-04 14:10:48 Total 0 Party loaded.
2012-04-04 14:10:48 Total 0/0 ScheduledCommand loaded...
2012-04-04 14:10:49 FieldPropData Loading Complete..
2012-04-04 14:10:49 Total 40 Pet info loaded...
2012-04-04 14:10:49 Total 4 RankingInfo, 0 RankingScore loaded...
2012-04-04 14:10:49 Total 1023 NPC loaded...

03/19/2013 00:22 bigfoot129012#19

@testing12
im haveing the same prom. can you plzz help me thanks this is the error

auth db init error dbnetlib][connectionopen (connect()).]sql server does not exist or access denied how can i fix this

03/19/2013 01:02 ThunderNikk#20

Why find all the old threads for answers?

There is a help thread for posting questions like this...

[Only registered and activated users can see links. Click Here To Register...]

But while we are here,

1. Did you follow the instructions in the guides?

2. Did you configure your DB access in "SQL server configuration manager"

3. Did you set the owners and owner passwords of the Data Bases (sa or another owner of your choice but it must be configured and set)?

4. Did you configure your .opt files in the server files and compress them into the .eop files?

03/19/2013 01:57 bigfoot129012#21

answer

1. i followed them to the T everything
2.yes i changed it all
3.yes i can log in to the db with the sa i can see everything in the sql
4. and i conpressed the .opt file and it turns in to the .eop file right or do i have to compressed both?

is there anything eles i can do to fix it i load up the uploadserver and it all say's ok then i click on the princessaurora server and then thats when i get the errore saying

auth db init error dbnetlib][connectionopen (connect()).]sql server does not exist or access denied and now im lost lol

03/19/2013 03:19 ThunderNikk#22

You only need upload if you are going to end up doing Guild Icons and running full server services.

Other than that, yes you need to configure and compress uploadserver.opt, authserver.opt and gameserver.opt until you have all 3 .eop files respectively in thier folders.

Then you need to start Auth and Upload servers before you start PrincessAurora game server, if auth is not running before the game server the game server will not connect to auth.

That or use the configuration manager to make sure all of your services are running.

Are you sure you read the guide?

05/11/2021 22:50 carlisle711#23

Quote:

Originally Posted by ProdStar

pm Skype ProdDevStar .. i can install server to you =)

i have same error. Can u pm Discord add me= Aphev#4416

05/12/2021 00:27 ilyaslord36#24

contact me in my discord

05/12/2021 01:54 ThunderNikk#25

Please pay some attention to post dates before posting.

Thank you

Page 2 of 2