Server can read libtdsodbc.so.0

[master_unknown]

[##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[##ERROR##] DB ERROR(MSG)      : [unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so.0' : /usr/lib/libtdsodbc.so.0: cannot open shared object file: No such file or directory
[##ERROR##] DB ERROR(CODE)     : 0
[##ERROR##] DB ERROR(VAR_INFO) : 
[##ERROR##] DB ERROR(SQLSTATE) : 01000
[##ERROR##] DB ERROR(STM_TEXT) : 
[##ERROR##] Database Connect Fail (uid=sa;pwd=passwordhere;dsn=CabalGame24;APP=DBAgent_24)
[##ERROR##] check 'pDB' fail
[##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)

Hi, can someone here lend their expertise and help me in regards to this error?
When I checked on the location /usr/lib/ the file 'libtdsodbc.so.0' is there and yet the log throws this error.
I also checked the /usr/lib64/ directory and saw there was another libtdsodbc.so.0 there.

Im using Centos 5 x64 (remote vps)

The error will pop-up when I try to connect to the server (linux vps). It seems it can't see the file whilst the file is already there.

I'm a bit confused why this error occurs.
So if you have any idea, please do post it may help me solving this issue.

Thanks and good day!

Edits:
I've read this topic: http://forum.ragezone.com/f451/conne...issing-480824/
But to no avail.

[MentaL]

[cypher]

Did you try chmodding it?

[master_unknown]

Thanks for the reply.
Can please be more specific, cause I'm still learning linux and I want to know which file to chmod?

Update:
I reinstalled the VPS and freshly copied TDP 2.81 to /root/ folder and reinstalled it. (fresh install)
I selected NO when asked if I was using 4.x CentOS.
It updates the library...
Now to check:
- When searching for the libtdsodbc.so.0 from /usr/lib/ it's not there. (see screenshot)
http://i61.servimg.com/u/f61/12/01/15/44/cabal-10.png

I had manually copied the file to /usr/lib/ from /usr/lib64/ but it seems it doesn't work as it's not compatible.

Question is: Does the repack supports 64bit Os's?
I don't know what to ask really, I'm just a bit confused.

Thanks for your time

[cypher]

Ok try changing the path from odbc.ini to your lib64 folder and see what happens. Do you have libtdsodbc.so in your lib64 folder?

[LostSpirit]

u need install the freetds-unixodbc rpm

command:

rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm

ps: use a root folder.

[chumpywumpy]

The last time i tried to get it to work on 64-bit centos it just complained that the 32-bit odbc libs weren't compatible (well that isn't what it said but that is what it meant). I fiddled with compiling for a bit but i didn't get very far and it is still on my "to-do" list. You can try this though:

unixODBC error "/usr/lib/libtdsodbc.so.0: wrong ELF class: ELFCLASS32" - Stack Overflow

You will need to manually edit /etc/odbcqinst.ini to point to the correct libs though at the very least. They should be in that lib64 folder.

[master_unknown]

u need install the freetds-unixodbc rpm

command:

rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm

ps: use a root folder.

This one seems to work. Thanks.
And btw, my VPS was not configured with cpanel and it shows a default page with 'apache' logo in it when I visit the domain.
I have uploaded files to /var/www/html/ and put all the necessary php files there.
Problem is when viewing the index.php, it shows the raw code not the out put.
Any idea why this happens?

Edit:
I have not yet tried to connect to the server as I don't have an account yet.
If theres a way to make a manual account that be good also.
I tried Chumpy's GM Tool but it gives me 'duplicate' error something like that.

I have also tried using this repack by Chumpy.
http://www.mediafire.com/?fcuvzmzgq5n
Installed it on my WINDOWS vps and it says something

Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\cabal3\reg.php on line 7

[cypher]

This one seems to work. Thanks.
And btw, my VPS was not configured with cpanel and it shows a default page with 'apache' logo in it when I visit the domain.
I have uploaded files to /var/www/html/ and put all the necessary php files there.
Problem is when viewing the index.php, it shows the raw code not the out put.
Any idea why this happens?

Edit:
I have not yet tried to connect to the server as I don't have an account yet.
If theres a way to make a manual account that be good also.
I tried Chumpy's GM Tool but it gives me 'duplicate' error something like that.

I have also tried using this repack by Chumpy.
Cabal Web Destru - By LuanRox - modded by chumpy.7z
Installed it on my WINDOWS vps and it says something

Fatal error: Call to undefined function mssql_query() in C:\xampp\htdocs\cabal3\reg.php on line 7

For a starter you didn't had php installed. Then I see you managed to install it but you forgot to activate mssql extension in php.ini . Uncomment the mssql extension line and restart apache.

[master_unknown]

Yes, I did that a few minutes ago while I was reading this thread:
http://forum.ragezone.com/f459/cabal...v3-1-a-644514/

The only problem left that blocks my progress is that:
While using CabalToolz v3's registration page (front)
It says:

Validating Form 
Everything is OK. Welcome to Our server. GL HF!!!

And tried to login in client:

Account Name or password did not match.

Then I checked the MSSQL Server.
under:

MSSQL DB->ACCOUNT-dbo.cabal_auth_table

Nothing was there. The registration did not wrote any data into the database.

Edit: //using John_D
Backend is located at : domainname/cabal/
Frontend is located at : domainname/cabal2/
Both are in the MSSQL VPS (since I can't figure out yet how to in linux)

Edit 2: //using Chumpy's web repack
I have also tried using this repack by Chumpy.
http://www.mediafire.com/?fcuvzmzgq5n
- After activating the MSSQL EXTENSION in php.ini
I have encountered a weird bug/error.
The webserver can't seem to find the pages associated with 'config.php'

example: reg.php
ranking.php

The browser will return an error "cannot find page" like that.

Edit 3: //restarted the Cabal services
- generated new logs
GlobalDBAgent.log

[Mon Nov 22 2010 18:28:28.213903 3039144848]: [##ERROR##] check 'pUserDataCtx' fail
[Mon Nov 22 2010 18:28:28.213932 3039144848]: [##ERROR##] 'OnIPCConnect2Svr' fail (Proc/Connect.cpp:12)
[Mon Nov 22 2010 18:28:28.213983 3039144848]: [##ERROR##] UsrMap Fail : MainCmd(5) Ret(C:0:12) Addr(127.0.0.1)

What's this supposed to mean?

GlobalMgrSvr.log

[Mon Nov 22 2010 18:28:35.214771 3078751968]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(49,0), serverAddr(127.0.0.1:38180)

At least the libtdsodbc.so.0 has been fixed. Now with new errors.
Is this normal or no?

Shameless bump, in need of professional help.

[Yamachi]

Shameless bump, in need of professional help.

Please read the forum rules. You are not allowed to bump threads, especially your own, and especially after only 10 hours... Have some patience.

[chumpywumpy]

The "duplicate row" error in the 0.6x gm tools (and the username/pass not matching) is because xp_md5 is not installed or not working and it can't encrypt passwords.

Use this if you use SQL2005+ (32 or 64 bit)
http://forum.ragezone.com/f459/fix-l...64-dll-608699/

If you use SQL2000 then you will have to install xp_md5.dll which can be found in the db section of my mediafire page (www.mediafire.com/chumpy) along with instructions. Use the v2 gm tools in my sig to test as it has an md5 check and will tell you if it is not working.

The cabaltoolz bit i can't help with as i don't use it and gave up trying to support it ages ago. It pretty much needs a PHP dev to get it installed and working. For my web i would guess that the web root isn't set correctly in the apache config somwehere as the pages will always look in the folder they are in themselves to find the config file. Where your httpd.conf file (or equivalent) will be depends on your install but that is where i would check.

The last error is an odd one but it is failing to map a user to the worldsvr and i'm guessing it's something to do with odbc connections. I can't tell much from that alone so check for other dbagent errors or raise the log level on the dbagent server inis for more info.

[master_unknown]

Ah I see, its the xp_md5.dll (I'm currently using the default one you gave, perhaps this is for 32bit OS. My Windows Machine runs on 64bit)

Edit:
After giving it a go, I decided not to delete the previous query (from your guide and just threw out the new query for the x64 system)
Now, I created an account using your GM Tool.
See attachments.

Now, when I login in, I got authenticated successfully yet no channels we're showing up although when checked using putty, its there, online.
What's wrong in this picture?
Seen attachments #2.

[master_unknown]

Here's what I did.
Reformatted Linux.
Uploaded 2.81 repack
installed cabal
update packages...
updated rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm
started cabal_config
set up using default entries...
and this error shows:

[Wed Nov 24 2010 06:55:02.424449 3082344672]: open log file  '/var/log/cabal/WorldSvr_24_01.log'
[Wed Nov 24 2010 06:55:02.424552 3082344672]: LOG LEVEL: 3
[Wed Nov 24 2010 06:55:02.424583 3082344672]: MemPoolUnitSizeClass(5): 16384Bytes
[Wed Nov 24 2010 06:55:02.424888 3082344672]: Start WorldSvr_24_01 Server
[Wed Nov 24 2010 06:55:02.424925 3082344672]: CheckSkillCoolTimeHack (Off)
[Wed Nov 24 2010 06:55:02.424944 3082344672]: CheckShopHack (Off)
[Wed Nov 24 2010 06:55:02.424961 3082344672]: CheckWarpHack (Off)
[Wed Nov 24 2010 06:55:02.424979 3082344672]: CheckWareHouseHack (Off)
[Wed Nov 24 2010 06:55:02.424996 3082344672]: UseCheckDistanceSkillHack (Off)
[Wed Nov 24 2010 06:55:02.425013 3082344672]: MaxTimeHackingCount(2)
[Wed Nov 24 2010 06:55:02.425030 3082344672]: MaxDistanceHackingCount(2)
[Wed Nov 24 2010 06:55:02.425047 3082344672]: UseNonClientCheck (Off)
[Wed Nov 24 2010 06:55:02.425071 3082344672]: NonClientDisAdvantageRate (90)
[Wed Nov 24 2010 06:55:02.425091 3082344672]: useDropDiscount (On)
[Wed Nov 24 2010 06:55:02.425119 3082344672]: UseBlessingBeadCheck (Off)
[Wed Nov 24 2010 06:55:02.425141 3082344672]: AllowTradeChannel (Off)
[Wed Nov 24 2010 06:55:02.425158 3082344672]: UseCheckMissionIdx(Off)
[Wed Nov 24 2010 06:55:02.425176 3082344672]: UseCheckDeadStatActive(Off)
[Wed Nov 24 2010 06:55:02.425193 3082344672]: reload ActiveDeadStatCount(30)
[Wed Nov 24 2010 06:55:02.425209 3082344672]: UseHackcheckByTimeScope (Off)
[Wed Nov 24 2010 06:55:02.425226 3082344672]: CheckSkillTimeHackScope(60000)
[Wed Nov 24 2010 06:55:02.425243 3082344672]: UseMobsChaseModify (On)
[Wed Nov 24 2010 06:55:02.425260 3082344672]: UseAlzDbHackCheck (Off)
[Wed Nov 24 2010 06:55:02.425277 3082344672]: UseCutIfAlzDbHacked (Off)
[Wed Nov 24 2010 06:55:02.425294 3082344672]: useCheckUserAttack (Off)
[Wed Nov 24 2010 06:55:02.425311 3082344672]: UseHackUserDBSave (On)
[Wed Nov 24 2010 06:55:02.425327 3082344672]: UseAdminUser (On)
[Wed Nov 24 2010 06:55:02.425351 3082344672]: UseAntiOnlineGameAddictionSystem(1)
[Wed Nov 24 2010 06:55:02.425369 3082344672]: InstantPlayTimeClearIntervalMin(300)
[Wed Nov 24 2010 06:55:02.425386 3082344672]: InstantPlayTimeDbUpdateIntervalMin(5)
[Wed Nov 24 2010 06:55:02.425403 3082344672]: InstantPlayTimeNotifyIntervalMin(1)
[Wed Nov 24 2010 06:55:02.425421 3082344672]: AdvantageBoundaryTime(10800, 18000)
[Wed Nov 24 2010 06:55:02.425439 3082344672]: InstantPlayTimeDebugMultiple(1)
[Wed Nov 24 2010 06:55:02.425455 3082344672]: UseCheckBelongItem (Off)
[Wed Nov 24 2010 06:55:02.425472 3082344672]: UseCheckDMZArea (Off)
[Wed Nov 24 2010 06:55:02.425489 3082344672]: AllowCashShop(1)
[Wed Nov 24 2010 06:55:02.425506 3082344672]: AllowNetcafePoint(0)
[Wed Nov 24 2010 06:55:02.425523 3082344672]: RestrictOddCircleUseCountInDungeon (On)
[Wed Nov 24 2010 06:55:02.425543 3082344672]: UseAdditionalMissionDungeonInstanceInPremiumCH (Off)
[Wed Nov 24 2010 06:55:02.425558 3082344672]: UseAdditionalMissionDungeonInstanceInPremiumUser (Off)
[Wed Nov 24 2010 06:55:02.425573 3082344672]: AdditionalMissionDungeonInstanceCount (0)
[Wed Nov 24 2010 06:55:02.425590 3082344672]: UsePvpBetting (Off)
[Wed Nov 24 2010 06:55:02.425607 3082344672]: PShopOpenLimitCount (0)
[Wed Nov 24 2010 06:55:02.425623 3082344672]: UseTradeChannelRestriction (Off)
[Wed Nov 24 2010 06:55:02.425640 3082344672]: UseArtOfDefensePenalty (On)
[Wed Nov 24 2010 06:55:02.425661 3082344672]: IgnorePartyInviteDistance (Off)
[Wed Nov 24 2010 06:55:02.425677 3082344672]: UseWorldDrop (On)
[Wed Nov 24 2010 06:55:02.425693 3082344672]: UseInventoryHackCheck (Off)
[Wed Nov 24 2010 06:55:02.425710 3082344672]: UseRandomValueWriteLog (Off)
[Wed Nov 24 2010 06:55:02.425726 3082344672]: UseMinLevDiffValueForExpCalc (On)
[Wed Nov 24 2010 06:55:02.425743 3082344672]: UsePartyMinExpForInvalidPartyMember (On)
[Wed Nov 24 2010 06:55:02.425760 3082344672]: UseIgnoreOtherBlessBuff (Off)
[Wed Nov 24 2010 06:55:02.425775 3082344672]: Extended Alz Mode
[Wed Nov 24 2010 06:55:02.425792 3082344672]: GameGuard enabled version
[Wed Nov 24 2010 06:55:02.425809 3082344672]: GameGuard turned off
[Wed Nov 24 2010 06:55:02.425837 3082344672]: APEX enabled version
[Wed Nov 24 2010 06:55:02.425854 3082344672]: APEX turned off
[Wed Nov 24 2010 06:55:02.425869 3082344672]: XTrap disabled version
[Wed Nov 24 2010 06:55:02.425886 3082344672]: WaitUntilChannelTypeSet(Off)
[Wed Nov 24 2010 06:55:02.425903 3082344672]: UseBootUpGmsChannelType(On)
[Wed Nov 24 2010 06:55:02.426409 3082344672]: Local ip = 168.144.92.224 (from ini)
[Wed Nov 24 2010 06:55:02.426446 3082344672]: MaxAttackHackTime (300000)
[Wed Nov 24 2010 06:55:02.426465 3082344672]: SpeedHackCheckTime (10000)
[Wed Nov 24 2010 06:55:02.426910 3081952144]: CProcessLayer(0)::svc Start [3081952144]
[Wed Nov 24 2010 06:55:02.426920 3082344672]: try connect 127.0.0.1:38170, Sync
[Wed Nov 24 2010 06:55:02.427436 3082344672]: sock 5 ->LinkHandler Open
[Wed Nov 24 2010 06:55:02.427489 3082344672]: SendIPSConnect2Svr (161:24:01:00)
[Wed Nov 24 2010 06:55:02.427552 3082344672]: try connect 127.0.0.1:53424, Sync
[Wed Nov 24 2010 06:55:02.427685 3082344672]: sock 7 ->LinkHandler Open
[Wed Nov 24 2010 06:55:02.427718 3082344672]: SendIPSConnect2Svr (161:24:01:00)
[Wed Nov 24 2010 06:55:02.427761 3082344672]: try connect 127.0.0.1:38190, Sync
[Wed Nov 24 2010 06:55:02.427881 3082344672]: sock 8 ->LinkHandler Open
[Wed Nov 24 2010 06:55:02.427913 3082344672]: SendIPSConnect2Svr (161:24:01:00)
[Wed Nov 24 2010 06:55:02.427957 3082344672]: try connect 127.0.0.1:38144, Sync
[Wed Nov 24 2010 06:55:02.428081 3082344672]: sock 9 ->LinkHandler Open
[Wed Nov 24 2010 06:55:02.428125 3082344672]: SendIPSConnect2Svr (161:24:01:00)
[Wed Nov 24 2010 06:55:02.444713 3082344672]: GuildCreateFee: 10000000
[Wed Nov 24 2010 06:55:04.395099 3067599760]: CProcessLayer(1)::svc Start [3067599760]
[Wed Nov 24 2010 06:55:04.443138 3046493072]: CProcessLayer(2)::svc Start [3046493072]
[Wed Nov 24 2010 06:55:04.515618 3024456592]: CProcessLayer(3)::svc Start [3024456592]
[Wed Nov 24 2010 06:55:04.632069 2986011536]: CProcessLayer(5)::svc Start [2986011536]
[Wed Nov 24 2010 06:55:04.681440 3004636048]: CProcessLayer(4)::svc Start [3004636048]
[Wed Nov 24 2010 06:55:04.710984 2965617552]: CProcessLayer(6)::svc Start [2965617552]
[Wed Nov 24 2010 06:55:04.803011 2947083152]: CProcessLayer(7)::svc Start [2947083152]
[Wed Nov 24 2010 06:55:04.822047 2926922640]: CProcessLayer(8)::svc Start [2926922640]
[Wed Nov 24 2010 06:55:04.867034 2908810128]: CProcessLayer(9)::svc Start [2908810128]
[Wed Nov 24 2010 06:55:04.995124 2870950800]: CProcessLayer(13)::svc Start [2870950800]
[Wed Nov 24 2010 06:55:05.071002 2889771920]: CProcessLayer(10)::svc Start [2889771920]
[Wed Nov 24 2010 06:55:05.071110 2855320464]: CProcessLayer(14)::svc Start [2855320464]
[Wed Nov 24 2010 06:55:05.206971 2805451664]: CProcessLayer(24)::svc Start [2805451664]
[Wed Nov 24 2010 06:55:05.234959 2834803600]: CProcessLayer(19)::svc Start [2834803600]
[Wed Nov 24 2010 06:55:05.235050 2820352912]: CProcessLayer(23)::svc Start [2820352912]
[Wed Nov 24 2010 06:55:05.256965 2790513552]: CProcessLayer(25)::svc Start [2790513552]
[Wed Nov 24 2010 06:55:05.281968 2775759760]: CProcessLayer(26)::svc Start [2775759760]
[Wed Nov 24 2010 06:55:05.356965 2761407376]: CProcessLayer(27)::svc Start [2761407376]
[Wed Nov 24 2010 06:55:05.368993 2746669968]: CProcessLayer(28)::svc Start [2746669968]
[Wed Nov 24 2010 06:55:05.432119 2731842448]: CProcessLayer(29)::svc Start [2731842448]
[Wed Nov 24 2010 06:55:05.498780 3082344672]: try listening 38111 port
[Wed Nov 24 2010 06:55:05.596024 2716846992]: CProcessLayer(30)::svc Start [2716846992]
[Wed Nov 24 2010 06:55:06.934056 3081952144]: ChannelType changed(0 -> 1)
[Wed Nov 24 2010 06:55:07.043995 3081952144]: [##ERROR##] OnResultItems(): ItemNum(0)
ACE_ASSERT: file WorldMgr.cpp, line 371 assertion failed for '0'.Aborting...

[FastBlade]

worldsvr_o4_10 is stopped,did you make the cabal_config good?

[master_unknown]

the config 'was' auto-generated using cabal_config
needless to say, I have inputted all the necessary data correctly.
I have tried to use other WorldSvr by re-starting the cabal_config

It's just that it crash all the way.
I never touched any file by hand So the ACCERT error is clearly not my doing.

Edit:
Now I got this error:

[Wed Nov 24 2010 11:22:12.269227 3081119440]: open log file  '/var/log/cabal/DBAgent_08.log'
[Wed Nov 24 2010 11:22:12.269301 3081119440]: LOG LEVEL: 3
[Wed Nov 24 2010 11:22:12.269326 3081119440]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Nov 24 2010 11:22:12.269826 3081119440]: Start DBAgent_08 Server
[Wed Nov 24 2010 11:22:12.270203 3081119440]: UseEcryptText (Off)
[Wed Nov 24 2010 11:22:12.271111 3081116560]: CProcessLayer(0)::svc Start [3081116560]
[Wed Nov 24 2010 11:22:12.271295 3081119440]: try listening 38188 port
[Wed Nov 24 2010 11:22:12.271410 3070626704]: CProcessLayer(0)::svc Start [3070626704]
[Wed Nov 24 2010 11:22:12.271458 3060136848]: CProcessLayer(0)::svc Start [3060136848]
[Wed Nov 24 2010 11:22:12.271504 3049646992]: CProcessLayer(0)::svc Start [3049646992]
[Wed Nov 24 2010 11:22:12.271553 3039157136]: CProcessLayer(0)::svc Start [3039157136]
[Wed Nov 24 2010 11:22:12.314183 3081119440]: accept success 8(127.0.0.1:43133)
[Wed Nov 24 2010 11:22:12.314502 3081119440]: 1.open user 8 [9256FF8] (127.0.0.1)
[Wed Nov 24 2010 11:22:12.722946 3081119440]: accept success 10(127.0.0.1:43135)
[Wed Nov 24 2010 11:22:12.723033 3081119440]: 2.open user 10 [9265710] (127.0.0.1)
[Wed Nov 24 2010 11:22:13.358918 3081119440]: accept success 11(127.0.0.1:43140)
[Wed Nov 24 2010 11:22:13.359045 3081119440]: 3.open user 11 [9271948] (127.0.0.1)
[Wed Nov 24 2010 11:22:14.524689 3081119440]: accept success 12(127.0.0.1:43144)
[Wed Nov 24 2010 11:22:14.524807 3081119440]: 4.open user 12 [927DB80] (127.0.0.1)
[Wed Nov 24 2010 11:22:23.979852 3060136848]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:23.979910 3060136848]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:23.979928 3060136848]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:23.979943 3060136848]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:23.979965 3060136848]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:23.979980 3060136848]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:23.980011 3060136848]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:23.980028 3060136848]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Nov 24 2010 11:22:23.980047 3060136848]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:24.069958 3039157136]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:24.070004 3039157136]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:24.070028 3039157136]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:24.070049 3039157136]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:24.070069 3039157136]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:24.070089 3039157136]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:24.070119 3039157136]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:24.070140 3039157136]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Nov 24 2010 11:22:24.070165 3039157136]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:24.158758 3081116560]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:24.158828 3081116560]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:24.158855 3081116560]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:24.158879 3081116560]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:24.158903 3081116560]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:24.158928 3081116560]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:24.158998 3081116560]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:24.159071 3081116560]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Nov 24 2010 11:22:24.159100 3081116560]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.167168 3081116560]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.167222 3081116560]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.167239 3081116560]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.167255 3081116560]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.167270 3081116560]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.167286 3081116560]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.167304 3081116560]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.167319 3081116560]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Nov 24 2010 11:22:26.167337 3081116560]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.264994 3070626704]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.265049 3070626704]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.265066 3070626704]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.265086 3070626704]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.265116 3070626704]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.265139 3070626704]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.265157 3070626704]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.265172 3070626704]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Nov 24 2010 11:22:26.265190 3070626704]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.353486 3049646992]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.353541 3049646992]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.353559 3049646992]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.353574 3049646992]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.353589 3049646992]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.353604 3049646992]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.353621 3049646992]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.353636 3049646992]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Nov 24 2010 11:22:26.353654 3049646992]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.718187 3060136848]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.718224 3060136848]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.718241 3060136848]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.718256 3060136848]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.718272 3060136848]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.718287 3060136848]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.718304 3060136848]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.718319 3060136848]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Wed Nov 24 2010 11:22:26.718336 3060136848]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.743486 3070626704]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.743528 3070626704]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.743545 3070626704]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.743561 3070626704]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.743576 3070626704]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.743591 3070626704]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.743609 3070626704]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.743624 3070626704]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24)
[Wed Nov 24 2010 11:22:26.743642 3070626704]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:26.757750 3081116560]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:26.757784 3081116560]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:26.757801 3081116560]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:26.757817 3081116560]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:26.757832 3081116560]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:26.757847 3081116560]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:26.757864 3081116560]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:26.757879 3081116560]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9)
[Wed Nov 24 2010 11:22:26.757896 3081116560]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1)
[Wed Nov 24 2010 11:22:29.453503 3060136848]: [##ERROR##] DB ERROR(MSG)      : [unixODBC][FreeTDS][SQL Server]Cannot open database "GAMEDB" requested by the login. The login failed.
[Wed Nov 24 2010 11:22:29.453544 3060136848]: [##ERROR##] DB ERROR(CODE)     : 4060
[Wed Nov 24 2010 11:22:29.453561 3060136848]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Wed Nov 24 2010 11:22:29.453576 3060136848]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Wed Nov 24 2010 11:22:29.453592 3060136848]: [##ERROR##] DB ERROR(STM_TEXT) : 
[Wed Nov 24 2010 11:22:29.453607 3060136848]: [##ERROR##] Database Connect Fail (uid=usernamehere;pwd=passwordhere;dsn=CabalGame;APP=DBAgent_08)
[Wed Nov 24 2010 11:22:29.453624 3060136848]: [##ERROR##] check 'pDB' fail
[Wed Nov 24 2010 11:22:29.453640 3060136848]: [##ERROR##] 'OnIPCGetMyChartr' fail (Database/Character.cpp:42)
[Wed Nov 24 2010 11:22:29.453657 3060136848]: [##ERROR##] UsrMap Fail : MainCmd(32) Ret(2A:0:42) Addr(127.0.0.1)

My question is, why can't it see the Database where "its" there in mssql. And the user "usernamehere" has all the privileges / granted permissions to all cabal databases from remote mssql.
I also disabled the firewall where MSSQL was installed.