My guides + databases + server files repack -V2!

[Advocate]

From what i can see in your log it looks like libtdsodbc.so.0 is missing, i had this exact same problem, i solved it by:
1 Googling the actual file name (libtdsodbc.so.0)
2. I found a download of the rpm (freetds .64-7)
ftp://rpmfind.net/linux/fedora/relea...7.fc8.i386.rpm
3. Once the rpm downloaded i moved it to the CentOS desktop by using winSCP.
4. in the centos machine i right clicked the rpm and opened it with archive manager.
5. once the rpm opened I extracted libtdsodbc.so.0.0.0 to the desktop and renamed it to libtdsodbc.so.0.
6. once it was renamed I moveed it to /root/ep2/usr/lib.
7. I cleared my logs and restarted the cabal services.

thats what stopped the DB connect errors for me..

The getq errors in my experience are a result of the DB errors, once the server is able to connect to your DB the getq and port listen errors (if you have any) should stop, if not a service cabal restart should fix it..

also i just fixed my provider string in SQL (as my earlier post describes) what i did was
DRIVER={SQL Server};SERVER="Windows IP Here";UID=;PWD=;

not too sure how much help i can be but im a quick learner and know how i fixed my own problems at least :P

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

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

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "GAMESERVER".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.". (Microsoft SQL Server, Error: 7303)


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

adding this i can make it work
DRIVER={SQL Server};SERVER=SANITARIUMMA-PC\SQLEXPRESS;UID=;PWD=;

edited got it working also centos connects to database but now faced with this issue

[Tue Nov 4 2008 02:58:28.776640 3086224288]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Tue Nov 4 2008 02:58:28.776690 3086224288]: [##ERROR##] DB ERROR(CODE) : 32000
[Tue Nov 4 2008 02:58:28.776712 3086224288]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 0<UNKNOWN>, datatype in operator <</>>: INT
[Tue Nov 4 2008 02:58:28.776733 3086224288]: [##ERROR##] DB ERROR(SQLSTATE) :
[Tue Nov 4 2008 02:58:28.776754 3086224288]: [##ERROR##] DB ERROR(STM_TEXT) : SELECT KINDIDX, SERIALBGN, SERIALEND FROM CABAL_ITEMSERIAL_TABLE WHERE GROUPIDX = ?
[Tue Nov 4 2008 02:58:28.828017 3044264864]: Database Connect success!
[Tue Nov 4 2008 02:58:28.828592 3044264864]: [##ERROR##] DB ERROR(MSG) :
[Tue Nov 4 2008 02:58:28.828620 3044264864]: [##ERROR##] DB ERROR(CODE) : 0
[Tue Nov 4 2008 02:58:28.828641 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Nov 4 2008 02:58:28.828661 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Tue Nov 4 2008 02:58:28.828681 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Tue Nov 4 2008 02:58:28.862061 3086224288]: Database Connect success!
[Tue Nov 4 2008 02:58:28.863112 3086224288]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:132)
[Tue Nov 4 2008 02:58:28.863153 3086224288]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(84:0:132) Addr(127.0.0.1)
[Tue Nov 4 2008 02:58:28.873523 3044264864]: Database Connect success!
[Tue Nov 4 2008 02:58:28.873580 3044264864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Tue Nov 4 2008 02:58:28.873608 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Tue Nov 4 2008 02:58:28.957194 3086227136]: 4.close user 12 [8D2CF98] (127.0.0.1)
[Tue Nov 4 2008 02:58:33.129045 3044264864]: [##ERROR##] DB ERROR(MSG) :
[Tue Nov 4 2008 02:58:33.129078 3044264864]: [##ERROR##] DB ERROR(CODE) : 0
[Tue Nov 4 2008 02:58:33.129100 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Nov 4 2008 02:58:33.129120 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Tue Nov 4 2008 02:58:33.129140 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Tue Nov 4 2008 02:58:33.137039 3044264864]: Database Connect success!
[Tue Nov 4 2008 02:58:33.137080 3044264864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Tue Nov 4 2008 02:58:33.137131 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Tue Nov 4 2008 02:58:33.163041 3075734432]: Database Connect success!
[Tue Nov 4 2008 02:58:33.185792 3086224288]: [##ERROR##] DB ERROR(MSG) :
[Tue Nov 4 2008 02:58:33.185829 3086224288]: [##ERROR##] DB ERROR(CODE) : 0
[Tue Nov 4 2008 02:58:33.185851 3086224288]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Nov 4 2008 02:58:33.185871 3086224288]: [##ERROR##] DB ERROR(SQLSTATE) : 00000
[Tue Nov 4 2008 02:58:33.185892 3086224288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults}
[Tue Nov 4 2008 02:58:33.192940 3086224288]: Database Connect success!
[Tue Nov 4 2008 02:58:33.192982 3086224288]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187)
[Tue Nov 4 2008 02:58:33.193009 3086224288]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
[Tue Nov 4 2008 02:58:33.196381 3044264864]: [##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[Tue Nov 4 2008 02:58:33.196424 3044264864]: [##ERROR##] DB ERROR(CODE) : 32000
[Tue Nov 4 2008 02:58:33.196445 3044264864]: [##ERROR##] DB ERROR(VAR_INFO) : Column: 0<UNKNOWN>, datatype in operator <</>>: INT
[Tue Nov 4 2008 02:58:33.196467 3044264864]: [##ERROR##] DB ERROR(SQLSTATE) :
[Tue Nov 4 2008 02:58:33.196487 3044264864]: [##ERROR##] DB ERROR(STM_TEXT) : SELECT KINDIDX, SERIALBGN, SERIALEND FROM CABAL_ITEMSERIAL_TABLE WHERE GROUPIDX = ?
[Tue Nov 4 2008 02:58:33.203793 3044264864]: Database Connect success!
[Tue Nov 4 2008 02:58:33.203853 3044264864]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:132)
[Tue Nov 4 2008 02:58:33.203881 3044264864]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(84:0:132) Addr(127.0.0.1)
[Tue Nov 4 2008 02:58:33.233758 3086227136]: 3.close user 10 [8D14B50] (127.0.0.1)
[Tue Nov 4 2008 02:58:33.304318 3086227136]: 2.close user 11 [8D20D60] (127.0.0.1)

[ImAwesome]

I can't connect on WinSCP T_T
When I put Ping -c4 (IP ADDRESS) it says it's a command not found T_T

[chumpywumpy]

question do we need to install freetds on to linux to connect to mssql or is it already in centos?

It needs installing, but running install_cabal.sh will install it for you.

Hi chumpy and mod here how to prevent new characters from obtaining forcium automatically and automatic lv 150? Coz I think someone touched my server settings? Pls help...

Yes somebody has tinkered with the newflagdata tables. Run this on the account database:

update cabal_newflagdata_table set chardataidx=10, etcdataidx=10 where channel=25

More info on why it fixes it:
http://forum.ragezone.com/f459/how-t...es-etc-452000/

edited got it working also centos connects to database but now faced with this issue

That looks pretty bad. If you check the contents of the itemserial table in the accoutn db is there anything in there?

I can't connect on WinSCP T_T
When I put Ping -c4 (IP ADDRESS) it says it's a command not found T_T

Make sure you are running the command as root (type su - root), though it should be available to any user as far as i know.

[Advocate]

everything fix chump but when i login select the channel i get dced i looked around can't find answer to my problem spent 8 hour yestserday trying to get server running now im at last part trying to select channel without being dced.

[chumpywumpy]

Check the stiky in the help section for what to do. This could be any one of a million things and i can't tell you what is wrong just from knowing it doesn't let you log in.

[Advocate]

Check the stiky in the help section for what to do. This could be any one of a million things and i can't tell you what is wrong just from knowing it doesn't let you log in.

i did nothing pertaining to this mate. lol last two days been reading old old post trying to fix this and that seem this one is mystery to me because i have not read anything even resembles my problem

[PostOfTheYear]

I had connection problems. I could ping my IP Address but when I ping the gateway of my router it can't also websites. My CentOS is different from the guide.

[dosimple]

Hi Chummy,

I have some question relate DBAgent, if you see my log here;

[Mon Nov 3 2008 10:45:59.539192 3086444240]: EnQProcessData(): index(0) MsgCount=7000, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.539294 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.539395 3086444240]: EnQProcessData(): index(0) MsgCount=7002, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.539452 3086444240]: EnQProcessData(): index(0) MsgCount=7003, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.539502 3086444240]: EnQProcessData(): index(0) MsgCount=7004, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.539532 3086444240]: EnQProcessData(): index(0) MsgCount=7005, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(5ms))
[Mon Nov 3 2008 10:45:59.540026 3086444240]: EnQProcessData(): index(0) MsgCount=7006, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1641925(6ms))
[Mon Nov 3 2008 10:45:59.574573 3086444240]: EnQProcessData(): index(0) MsgCount=7004, mainCmd(46), last(cmd=46, uniqIdx=4, processTick=1641964(1ms))
[Mon Nov 3 2008 10:45:59.656573 3086444240]: EnQProcessData(): index(0) MsgCount=6999, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642039(8ms))
[Mon Nov 3 2008 10:45:59.669518 3086444240]: EnQProcessData(): index(0) MsgCount=7000, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642039(21ms))
[Mon Nov 3 2008 10:45:59.678872 3086444240]: EnQProcessData(): index(0) MsgCount=7000, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642062(7ms))
[Mon Nov 3 2008 10:45:59.713764 3086444240]: EnQProcessData(): index(0) MsgCount=6999, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642090(14ms))
[Mon Nov 3 2008 10:45:59.737543 3086444240]: EnQProcessData(): index(0) MsgCount=6997, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642126(2ms))
[Mon Nov 3 2008 10:45:59.746824 3086444240]: EnQProcessData(): index(0) MsgCount=6998, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642126(11ms))
[Mon Nov 3 2008 10:45:59.787914 3086444240]: EnQProcessData(): index(0) MsgCount=6993, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1642172(6ms))
[Mon Nov 3 2008 10:45:59.800928 3086444240]: EnQProcessData(): index(0) MsgCount=6994, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1642172(19ms))
[Mon Nov 3 2008 10:45:59.813234 3086444240]: EnQProcessData(): index(0) MsgCount=6994, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642200(4ms))
[Mon Nov 3 2008 10:45:59.832756 3086444240]: EnQProcessData(): index(0) MsgCount=6993, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(9ms))
[Mon Nov 3 2008 10:45:59.832894 3086444240]: EnQProcessData(): index(0) MsgCount=6994, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(9ms))
[Mon Nov 3 2008 10:45:59.832958 3086444240]: EnQProcessData(): index(0) MsgCount=6995, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(9ms))
[Mon Nov 3 2008 10:45:59.833045 3086444240]: EnQProcessData(): index(0) MsgCount=6996, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833090 3086444240]: EnQProcessData(): index(0) MsgCount=6997, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833125 3086444240]: EnQProcessData(): index(0) MsgCount=6998, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833125 3086444240]: EnQProcessData(): index(0) MsgCount=6999, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833125 3086444240]: EnQProcessData(): index(0) MsgCount=7000, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833125 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.833125 3086444240]: EnQProcessData(): index(0) MsgCount=7002, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642214(10ms))
[Mon Nov 3 2008 10:45:59.862947 3086444240]: EnQProcessData(): index(0) MsgCount=7000, mainCmd(46), last(cmd=46, uniqIdx=3, processTick=1642248(5ms))
[Mon Nov 3 2008 10:45:59.863064 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=3, processTick=1642248(6ms))
[Mon Nov 3 2008 10:45:59.882397 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642270(3ms))
[Mon Nov 3 2008 10:45:59.912481 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642280(23ms))
[Mon Nov 3 2008 10:45:59.915015 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642305(0ms))
[Mon Nov 3 2008 10:45:59.915096 3086444240]: EnQProcessData(): index(0) MsgCount=7002, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642305(1ms))
[Mon Nov 3 2008 10:45:59.958573 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=2, processTick=1642340(9ms))
[Mon Nov 3 2008 10:45:59.971241 3086444240]: EnQProcessData(): index(0) MsgCount=7001, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1642354(8ms))
[Mon Nov 3 2008 10:45:59.980357 3086444240]: EnQProcessData(): index(0) MsgCount=7002, mainCmd(46), last(cmd=46, uniqIdx=1, processTick=1642354(17ms))

something going weird and make a big size of DBAgent.log file, also it makes player is hard to login playing the game. I tried many time to restart this DBAGent but only 3 minutes and it happen again. How do fix this?.
I use VMWARE install your repack files, MSSQL2005 with 64bit platformand gp-client as my client, and the odbc setup use freetds version 8.0 (i use that version since 9.0 version won't work at this time)

Thank you

[swetmary143]

Thanks chumpy U really rock!!

One more thing I wanna add Tierra whats the command on putty chumpy coz everytime i use the command from ur guide /home/cabal/cabal_config.sh it erase my old channel? What i want is to add tiera and 1 war channel.. What methods shall I do? Thanks in adv :)

[chumpywumpy]

Hi Chummy,

I have some question relate DBAgent, if you see my log here;


something going weird and make a big size of DBAgent.log file, also it makes player is hard to login playing the game. I tried many time to restart this DBAGent but only 3 minutes and it happen again. How do fix this?.
I use VMWARE install your repack files, MSSQL2005 with 64bit platformand gp-client as my client, and the odbc setup use freetds version 8.0 (i use that version since 9.0 version won't work at this time)

Thank you

Raise the loglevel to 5 in the dbagent ini and see what cmd 46 is. I don't know offhand but raising the log level has given enough clues for a fix in the other reports i have seen.

Thanks chumpy U really rock!!

One more thing I wanna add Tierra whats the command on putty chumpy coz everytime i use the command from ur guide /home/cabal/cabal_config.sh it erase my old channel? What i want is to add tiera and 1 war channel.. What methods shall I do? Thanks in adv :)

Running cabal_config.sh will wipe the old config as that is what it is intended for. Adding a channel is not as simple as typing a command as it needs quite a few changes to the server files. I would suggest picking a config that already has a TG channel and using "service WorldSvr_05_10 start" and "service WorldSvr_05_10 stop" to switch it on or off as you need.

If you want war + TG then edit GlobalMgrSvr.cfg...

# Saturn - 2 channel setup
# Channel 1 (Novice) - Normal
# Channel 10 - Tierra Gloriosa
[Server05]
ChannelType01=0
MaxUserNum01=100
ChannelType10=16908368
MaxUserNum10=100

Change ChannelType01=0 to ChannelType01=8, save and run cabal_config.sh again. Pick Saturn as your config and you will have both channels and you can start/stop TG whever you want.

[Advocate]

how do you enable gm system seems to be disable with commands on your release chumpy

[chumpywumpy]

Actually it is SAUR0N's client synch patch that disables them and if you want them back you will need to use a different login patch.

[Advocate]

im trdting sevrer out using john client actually and his gm was using the commands so i don't think there disable in client.

[PostOfTheYear]

I had connection problems. I could ping my IP Address but when I ping the gateway of my router it can't also websites. My CentOS is different from the guide.

How about this post? How to get a premium account my server?

[Advocate]

THANKS ALOT For guide now xmas on the way a brief message xD