AuthServer - serverkind list?

[Mathiu]

Hi, there.
I managed to do most thing, but when running the serv I encountered serveral problems. Here is the screen. Please help me correcting the things I made wrongly.





- Mathiu Silverburg

[MentaL]

[escamilo]

like you should check in SQl server table id number

[Mathiu]

Perhaps my mistakes comes from not-fully-understanding of the way the mssql works. Where e.x. I found in the giude that kind = 0, then should I put kind = 0 (should there be any spaces?) or put just zero in this column instead? Sorry for such newbish question, but I'm mmoving in the sql world as if I was wearing a blindfold.

- Mathiu Silverbirg

[mg2005]

hi I am getting something totally different my server was working now all of a sudden this is whats happing when I run AuthServer

2004.11.15 22:00.28:LOADED Config

2004.11.15 22:00.28:BuildNumber : 40504

2004.11.15 22:00.28:sql: Select id, name, ip, inner_ip, ageLimit, pk_flag, kind, port From server Order by id

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'server'.

2004.11.15 22:00.28:Server load fail, please check server table or DB connection string

2004.11.15 22:00.28:sql: update worldstatus set status=0

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'worldstatus'.

2004.11.15 22:00.28:sql: Select Max(kind) From server With (Nolock)

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'server'.

2004.11.15 22:00.28:Load ServerKindList fail!


any info on this I am trying different things to get it to work. but having no luck

MG

[Mathiu]

I managed to get through this, mg2005, check your database is ok and if you ahve edited the tables properly.

- Mathiu Silverburg

[mg2005]

I believe I have done it all right
my ip is 192.168.10.3
so my world id=3
id name ip ext kind port
3 lineage2 192.168.10.3 192.168.10.3 0 0 0 7777

my server.ini has worldid=3
my authserver has id=3
my l2comm has id=3
so it should work but for some reason its crapping out, I had it working a few days ago and all was fine since I have reinstalled the system which is xp pro sp2 now this thing is giving me problems

[mg2005]

still a no go I have tried all kinds of things uninstalling reinstalling
changeing different databases nothing happens it still give all kinds of errors
I believe I may not have an actaul working database to use
any input would greatly help

[Mathiu]

Are you sure your id should be 3 instead of 1?

- Mathiu Silverburg

[rstrst]

mathiu: yes, his world id should be 3

[mg2005]

Hey again I was able to get rid of the cachedlog error but still have this problem

2004.11.15 22:00.28:BuildNumber : 40504

2004.11.15 22:00.28:sql: Select id, name, ip, inner_ip, ageLimit, pk_flag, kind, port From server Order by id

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'server'.

2004.11.15 22:00.28:Server load fail, please check server table or DB connection string

2004.11.15 22:00.28:sql: update worldstatus set status=0

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'worldstatus'.

2004.11.15 22:00.28:sql: Select Max(kind) From server With (Nolock)

2004.11.15 22:00.28:42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'server'.

2004.11.15 22:00.28:Load ServerKindList fail!

no matter what I do I cannot seem to get past this
any suggestions
I have double checked my ini settings and made sure they are set to world id=3
and also in the lin2db as well
and that it is using Lineage2 as worldname :chair:

[mg2005]

got it guys it works now
what is strange is by the way I have my router set to give my comp an ip of 192.168.10.3
world id should be 3 and all the other setting as well
however after no luck getting that to respond I tried going back to 1 and low and behold it registered the service so Mathui was right use 1
and make sure you change your world id to 1 as well to sync up
hope this welps and thanxs again guys for all the help

[mg2005]

thought I got it running (look at above post)
oh well couldn't get it to work so I scrapped the whole thing files and all
good luck to all getting it to work as for me it's just too much time consuming
I figured I could set up my own server to play by myself since I spent 50 for the game and played it for like 2 months and got tired of PVP killers
Going back to playing EQ2
I learned a valuable lesson leave programming and coding to people who know..................