FreeTDS

Printable View

19-09-10
iSpooky

FreeTDS

Ok i gotz a question:
I installed everything fine.
than i gotz 1 error about the unixODBC.
He cant find libtdsodbc.so.0 at usr/lib.
i saw on this forum i had to install FreeTDS.
So i installed freeTDS.
But he still cant find libtdsodbc.so.0 at usr/lib.
i checked usr/lib but there isnt a libtdsodbc.so.0
So my question is: What do i have to do now :)
Right now i cant get in my winscp idk why 5 mins ago i could get in.
so i cant upload any log files :(
or i can find the log files somewhere else than i can.

EDIT: gotz another error like 1 hour ago i could ping my windows to centos and centos to windows but now none off them pings.

EDIT: i can ping again to both off them but still i have no idea have to install FreeTDS

EDIT: Logfile ADDED

Greetz iSpooky

Code:

[Sun Sep 19 2010 23:16:47.733949 4160161488]: open log file '/var/log/cabal/DBAgent_24.log' [Sun Sep 19 2010 23:16:47.734051 4160161488]: LOG LEVEL: 3 [Sun Sep 19 2010 23:16:47.734071 4160161488]: MemPoolUnitSizeClass(2): 24576Bytes [Sun Sep 19 2010 23:16:47.734501 4160161488]: Start DBAgent_24 Server [Sun Sep 19 2010 23:16:47.734929 4160161488]: UseEcryptText (Off) [Sun Sep 19 2010 23:16:47.739974 4160161488]: try listening 53424 port [Sun Sep 19 2010 23:16:47.740144 4160158608]: CProcessLayer(0)::svc Start [4160158608] [Sun Sep 19 2010 23:16:47.740203 4149668752]: CProcessLayer(0)::svc Start [4149668752] [Sun Sep 19 2010 23:16:47.740260 4139178896]: CProcessLayer(0)::svc Start [4139178896] [Sun Sep 19 2010 23:16:47.740312 4128689040]: CProcessLayer(0)::svc Start [4128689040] [Sun Sep 19 2010 23:16:47.740391 4118199184]: CProcessLayer(0)::svc Start [4118199184] [Sun Sep 19 2010 23:16:48.436845 4160161488]: accept success 8(127.0.0.1:60453) [Sun Sep 19 2010 23:16:48.437837 4160161488]: 1.open user 8 [9864F90] (127.0.0.1) [Sun Sep 19 2010 23:16:49.002529 4160161488]: accept success 10(127.0.0.1:60455) [Sun Sep 19 2010 23:16:49.002643 4160161488]: 2.open user 10 [98736B0] (127.0.0.1) [Sun Sep 19 2010 23:18:26.189595 4149668752]: [##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 [Sun Sep 19 2010 23:18:26.189877 4139178896]: [##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 [Sun Sep 19 2010 23:18:28.640041 4139178896]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:18:28.640347 4139178896]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:18:28.640362 4139178896]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:18:28.640374 4139178896]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:18:28.640386 4139178896]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:18:28.220457 4128689040]: [##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 [Sun Sep 19 2010 23:18:28.641692 4128689040]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:18:28.641720 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:18:28.641731 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:18:28.641743 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:18:28.641754 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=*******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:18:28.228112 4118199184]: [##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 [Sun Sep 19 2010 23:18:28.641788 4118199184]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:18:28.641802 4118199184]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:18:28.641813 4118199184]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:18:28.641824 4118199184]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:18:28.641835 4118199184]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:18:28.641860 4118199184]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:18:28.641872 4118199184]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:18:28.642193 4149668752]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:18:28.642208 4149668752]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:18:28.642219 4149668752]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:18:28.642231 4149668752]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:18:28.642242 4149668752]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:18:28.854290 4128689040]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:18:28.909400 4128689040]: [##ERROR##] 'OnIPCCensusNation' fail (Database/Nation.cpp:9) [Sun Sep 19 2010 23:18:28.854379 4139178896]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:18:28.909889 4139178896]: [##ERROR##] 'OnIPCItemSerial0' fail (Database/ItemSerial.cpp:24) [Sun Sep 19 2010 23:18:28.910303 4149668752]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:18:28.910319 4149668752]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:18:28.642141 4118199184]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:18:28.909860 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(57) Ret(9:0:9) Addr(127.0.0.1) [Sun Sep 19 2010 23:18:28.910333 4149668752]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:18:29.179489 4139178896]: [##ERROR##] UsrMap Fail : MainCmd(50) Ret(18:0:24) Addr(127.0.0.1) [Sun Sep 19 2010 23:19:54.661768 4139178896]: [##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 [Sun Sep 19 2010 23:19:56.827729 4139178896]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:19:56.827811 4139178896]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:19:56.827824 4139178896]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:19:56.827836 4139178896]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:19:56.827848 4139178896]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:19:57.130918 4139178896]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:19:57.131022 4139178896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:19:57.416981 4139178896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:20:36.079163 4128689040]: [##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 [Sun Sep 19 2010 23:20:37.350095 4128689040]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:20:37.350200 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:20:37.350214 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:20:37.350225 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:20:37.350241 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:20:37.847682 4128689040]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:20:37.847749 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:20:38.445839 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:21:01.982482 4128689040]: [##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 [Sun Sep 19 2010 23:21:02.289089 4128689040]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:21:02.289164 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:21:02.289177 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:21:02.289188 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:21:02.289203 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:21:02.289258 4128689040]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:21:02.289273 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:21:02.437166 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:21:49.027011 4128689040]: [##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 [Sun Sep 19 2010 23:21:49.031670 4128689040]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:21:49.031706 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:21:49.031719 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:21:49.031731 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:21:49.031742 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:21:49.031763 4128689040]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:21:49.031776 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:21:49.031793 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:22:49.017061 4128689040]: [##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 [Sun Sep 19 2010 23:22:49.017115 4128689040]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:22:49.017128 4128689040]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:22:49.017140 4128689040]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:22:49.017151 4128689040]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:22:49.017163 4128689040]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:22:49.017176 4128689040]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:22:49.017188 4128689040]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:22:49.017202 4128689040]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:23:49.110950 4160158608]: [##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 [Sun Sep 19 2010 23:23:49.111076 4160158608]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:23:49.111090 4160158608]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:23:49.111101 4160158608]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:23:49.111113 4160158608]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:23:49.111124 4160158608]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:23:49.111139 4160158608]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:23:49.111150 4160158608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:23:49.111164 4160158608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:24:49.085185 4118199184]: [##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 [Sun Sep 19 2010 23:24:49.086550 4118199184]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:24:49.086572 4118199184]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:24:49.086584 4118199184]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:24:49.086596 4118199184]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:24:49.086607 4118199184]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:24:49.086622 4118199184]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:24:49.086634 4118199184]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:24:49.086648 4118199184]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1) [Sun Sep 19 2010 23:25:49.049567 4149668752]: [##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 [Sun Sep 19 2010 23:25:49.049652 4149668752]: [##ERROR##] DB ERROR(CODE) : 0 [Sun Sep 19 2010 23:25:49.049837 4149668752]: [##ERROR##] DB ERROR(VAR_INFO) : [Sun Sep 19 2010 23:25:49.049852 4149668752]: [##ERROR##] DB ERROR(SQLSTATE) : 01000 [Sun Sep 19 2010 23:25:49.049864 4149668752]: [##ERROR##] DB ERROR(STM_TEXT) : [Sun Sep 19 2010 23:25:49.049875 4149668752]: [##ERROR##] Database Connect Fail (uid=iSpooky;pwd=******;dsn=CabalGame;APP=DBAgent_24) [Sun Sep 19 2010 23:25:49.049889 4149668752]: [##ERROR##] check 'pDB' fail [Sun Sep 19 2010 23:25:49.049900 4149668752]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140) [Sun Sep 19 2010 23:25:49.049914 4149668752]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
20-09-10
iSpooky

Re: FreeTDS

*Buuuuuuuuump*
20-09-10
Yamachi

Re: FreeTDS

1. Please don't double-post.
2. Please don't bump your own threads.
3. Always use Google before posting here. The answer to your problem can be found there.
20-09-10
iSpooky

Re: FreeTDS

1. sorry
2. sorry
3. i use google already for like 40 billion time without any succes they all say the same stuff and it dont work.
20-09-10
chumpywumpy

Re: FreeTDS

Are you using centos 4 or 5? Does the file exist?

If using centos 4 the following commands should cure it:

rpm -Uvh /root/unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh /root/unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh /root/unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm

For centos 5 use:

yum install unixODBC
yum install unixODBC-devel
yum install unixODBC-kde

I suspect you are trying to install the wrong version of the libs by selecting the wrong mode when installing. If in doubt use the centos 5 method above and it should install the correct version.

As for bumping the general rule at RZ is 2 weeks but if it has left the 1st page and has not been answered then i would let that go. If it's on the first page and has not yet been answered it means i haven't been here yet since it was posted ;)
21-09-10
iSpooky

Re: FreeTDS

The file doesnt exist
im useing centos 5
and when i use those commands i get the message that they are already installed and the lastest version for all 3 off them.
And sorry about bumping my thread :(
23-09-10
chumpywumpy

Re: FreeTDS

Weird, that is where mine are. Run a search on the files and then edit /etc/odbcinst.ini to correct the paths to the files.
25-09-10
iSpooky

Re: FreeTDS

Oki i found that file
and chanced it to the right directory but now i get the error
[unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0' : /usr/lib64/libtdsodbc.so.0: wrong ELF class: ELFCLASS64

if you need whole my log tell me :)

i hope you can help me
Thanks in advance :)
25-09-10
chumpywumpy

Re: FreeTDS

Ah this explains it. I take it you are running 64-bit Centos? I have never tested this and it looks like parts of my repack are not compatible with 64-bit, though i'm sure i have seen posts where people have done this. At a guess i would say you will need to find the 64-bit versions of the following:

rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh freetds-unixodbc-0.64RC3-1.i386.rpm

Go to Index of /centos.org (or another local Centos mirror) and into the folder for the centos 5.x version you have. Go into os/SRPMS/ and grab the files, then use:

rpm -Uvh <rpm name>

I will have to test this and modify cabal_install.sh to support 64-bit. I'm grabbing the ISO now.
25-09-10
iSpooky

Re: FreeTDS

Hmm i was seeking for:
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
freetds-unixodbc-0.64RC3-1.i386.rpm
at the link you gaved me
But those files arent there
26-09-10
chumpywumpy

Re: FreeTDS

The names will be slightly diferent as they won't have RHEL4.i386 at the end.

Hang on for a bit as i will be testing with Centos 5.5 x64 in a few minutes.
26-09-10
iSpooky

Re: FreeTDS

Tell me if you have any succes :)
26-09-10
chumpywumpy

Re: FreeTDS

My last answer was stupid, of course the 64-bit installer YUMs the right files. I don't even know why i suggested that but i'm definitely rusty after my little vacation :/

The server is compiled against 32-bit odbc and it doesn't like the 64-bit version at all. I have been trying to force-compile a 32-bit version on an x64 centos and it isn't working out. I have a few more things to try but the easiest fix is probably to use a 32-bit centos install until i figure it out as my install scripts are definitely going to need changing for 64-bit support.

You can get away with just centos CD1 when installing 32-bit. When installing and it asks about packages to install select "customize now" and un-tick everything in every section except the "base" package (that says it is good for routers). After the centos installation run cabal_install normally, say you are NOT upgrading a server and NOT installing on centos 4 and it will download everything it needs. That will get you working for now as i don't think this is going to be an easy problem to solve.
27-09-10
iSpooky

Re: FreeTDS

Ok so i just have to install a centos 32 bit? i can do that on the 64 bit so it overwrite or do i have to make another VM ?

Greets iSpooky
27-09-10
chumpywumpy

Re: FreeTDS

I would make another VM, or boot the centos CD and overwrite that way. 32-bit will work fine on a 64-bit machine/windows as i have Win7 x64 and all but 1 of my VMs are 32-bit.
28-09-10
iSpooky

Re: FreeTDS

Ok i installed the 32 bit the error is gone but i gained a new error

Code:

[Tue Sep 28 2010 15:47:48.751606 3086825168]: open log file '/var/log/cabal/DBAgent_24.log' [Tue Sep 28 2010 15:47:48.751719 3086825168]: LOG LEVEL: 3 [Tue Sep 28 2010 15:47:48.751745 3086825168]: MemPoolUnitSizeClass(2): 24576Bytes [Tue Sep 28 2010 15:47:48.752323 3086825168]: Start DBAgent_24 Server [Tue Sep 28 2010 15:47:48.752743 3086825168]: UseEcryptText (Off) [Tue Sep 28 2010 15:47:48.753154 3086825168]: try listening 53424 port [Tue Sep 28 2010 15:47:48.865961 3086822288]: CProcessLayer(0)::svc Start [3086822288] [Tue Sep 28 2010 15:47:48.866044 3076332432]: CProcessLayer(0)::svc Start [3076332432] [Tue Sep 28 2010 15:47:48.866121 3065842576]: CProcessLayer(0)::svc Start [3065842576] [Tue Sep 28 2010 15:47:48.866191 3055352720]: CProcessLayer(0)::svc Start [3055352720] [Tue Sep 28 2010 15:47:48.866257 3044862864]: CProcessLayer(0)::svc Start [3044862864] [Tue Sep 28 2010 15:47:48.876270 3086825168]: accept success 8(127.0.0.1:44268) [Tue Sep 28 2010 15:47:48.902139 3086825168]: 1.open user 8 [935EF80] (127.0.0.1) [Tue Sep 28 2010 15:47:48.953137 3086825168]: accept success 10(127.0.0.1:44270) [Tue Sep 28 2010 15:47:48.953220 3086825168]: 2.open user 10 [936D678] (127.0.0.1) [Tue Sep 28 2010 15:48:38.120554 3044862864]: Database Connect success! [Tue Sep 28 2010 15:48:38.121552 3086822288]: Database Connect success! [Tue Sep 28 2010 15:48:38.127108 3055352720]: Database Connect success! [Tue Sep 28 2010 15:50:12.453646 3086822288]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed. [Tue Sep 28 2010 15:50:12.453898 3086822288]: [##ERROR##] DB ERROR(CODE) : 20004 [Tue Sep 28 2010 15:50:12.453916 3086822288]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 15:50:12.453931 3086822288]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 15:50:12.453945 3086822288]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 15:50:12.473889 3086822288]: Database Connect success! [Tue Sep 28 2010 15:50:12.473940 3086822288]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 15:50:12.473990 3086822288]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 15:50:48.961373 3055352720]: [##ERROR##] DB ERROR(MSG) : [Tue Sep 28 2010 15:50:48.962056 3055352720]: [##ERROR##] DB ERROR(CODE) : 0 [Tue Sep 28 2010 15:50:48.962073 3055352720]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 15:50:48.962088 3055352720]: [##ERROR##] DB ERROR(SQLSTATE) : 00000 [Tue Sep 28 2010 15:50:48.962102 3055352720]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 15:50:48.979277 3055352720]: Database Connect success! [Tue Sep 28 2010 15:50:48.979327 3055352720]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 15:50:48.979349 3055352720]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 15:52:48.960052 3044862864]: [##ERROR##] DB ERROR(MSG) : [Tue Sep 28 2010 15:52:48.960744 3044862864]: [##ERROR##] DB ERROR(CODE) : 0 [Tue Sep 28 2010 15:52:48.960762 3044862864]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 15:52:48.960777 3044862864]: [##ERROR##] DB ERROR(SQLSTATE) : 00000 [Tue Sep 28 2010 15:52:48.960792 3044862864]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 15:52:48.976603 3044862864]: Database Connect success! [Tue Sep 28 2010 15:52:48.976730 3044862864]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 15:52:48.976753 3044862864]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 15:53:49.007049 3076332432]: Database Connect success! [Tue Sep 28 2010 15:55:48.978381 3065842576]: Database Connect success!
28-09-10
chumpywumpy

Re: FreeTDS

Ah, that one you can ignore. At this stage you have empty databases and no war results for the server to read which is why there is an error. There is plenty of "Database Connect success!" which means it is now getting through.

All you need to do is run a TG channel once and that error will go away.
28-09-10
iSpooky

Re: FreeTDS

i get this error now
DBagent_24

Code:

[Tue Sep 28 2010 16:36:48.309046 3086747344]: open log file '/var/log/cabal/DBAgent_24.log' [Tue Sep 28 2010 16:36:48.309251 3086747344]: LOG LEVEL: 3 [Tue Sep 28 2010 16:36:48.309278 3086747344]: MemPoolUnitSizeClass(2): 24576Bytes [Tue Sep 28 2010 16:36:48.309971 3086747344]: Start DBAgent_24 Server [Tue Sep 28 2010 16:36:48.310538 3086747344]: UseEcryptText (Off) [Tue Sep 28 2010 16:36:48.416511 3086744464]: CProcessLayer(0)::svc Start [3086744464] [Tue Sep 28 2010 16:36:48.416600 3076254608]: CProcessLayer(0)::svc Start [3076254608] [Tue Sep 28 2010 16:36:48.422271 3086747344]: try listening 53424 port [Tue Sep 28 2010 16:36:48.422709 3065764752]: CProcessLayer(0)::svc Start [3065764752] [Tue Sep 28 2010 16:36:48.422767 3055274896]: CProcessLayer(0)::svc Start [3055274896] [Tue Sep 28 2010 16:36:48.422888 3044785040]: CProcessLayer(0)::svc Start [3044785040] [Tue Sep 28 2010 16:36:48.745387 3086747344]: accept success 8(127.0.0.1:36187) [Tue Sep 28 2010 16:36:48.746077 3086747344]: 1.open user 8 [927FF78] (127.0.0.1) [Tue Sep 28 2010 16:36:49.055267 3086747344]: accept success 10(127.0.0.1:36189) [Tue Sep 28 2010 16:36:49.055753 3086747344]: 2.open user 10 [928E6A0] (127.0.0.1) [Tue Sep 28 2010 16:37:37.669832 3044785040]: Database Connect success! [Tue Sep 28 2010 16:37:37.699774 3076254608]: Database Connect success! [Tue Sep 28 2010 16:37:37.706141 3086744464]: Database Connect success! [Tue Sep 28 2010 16:37:46.315274 3086744464]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072 [Tue Sep 28 2010 16:40:09.281235 3076254608]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed. [Tue Sep 28 2010 16:40:09.281402 3076254608]: [##ERROR##] DB ERROR(CODE) : 20004 [Tue Sep 28 2010 16:40:09.281420 3076254608]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:40:09.281434 3076254608]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:40:09.281448 3076254608]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:40:12.800529 3076254608]: Database Connect success! [Tue Sep 28 2010 16:40:12.800570 3076254608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:40:12.800614 3076254608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 16:40:49.105257 3065764752]: Database Connect success! [Tue Sep 28 2010 16:46:49.098881 3055274896]: Database Connect success! [Tue Sep 28 2010 16:48:08.945958 3055274896]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed. [Tue Sep 28 2010 16:48:08.946046 3055274896]: [##ERROR##] DB ERROR(CODE) : 20004 [Tue Sep 28 2010 16:48:08.946062 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:08.946076 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:08.946089 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:48:11.972408 3055274896]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Sep 28 2010 16:48:11.973054 3055274896]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Sep 28 2010 16:48:11.973070 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:11.973084 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:11.973097 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Sep 28 2010 16:48:11.973111 3055274896]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24) [Tue Sep 28 2010 16:48:11.973127 3055274896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:48:11.973295 3055274896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 16:48:49.056743 3086744464]: [##ERROR##] DB ERROR(MSG) : [Tue Sep 28 2010 16:48:49.057146 3086744464]: [##ERROR##] DB ERROR(CODE) : 0 [Tue Sep 28 2010 16:48:49.057162 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:49.057208 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 00000 [Tue Sep 28 2010 16:48:49.057223 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:48:52.071146 3086744464]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Sep 28 2010 16:48:52.071388 3086744464]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Sep 28 2010 16:48:52.071403 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:52.071417 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:52.071431 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Sep 28 2010 16:48:52.071445 3086744464]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24) [Tue Sep 28 2010 16:48:52.071460 3086744464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:48:52.071477 3086744464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
28-09-10
chumpywumpy

Re: FreeTDS

Post a full set of logs and that will tell me why. Usually it's a mis-configuration somewhere but the first place to check is the loginsvr log to see if it has your connection attempts listed. From there it is usually down to the gamesevrer IP set in cabal_config not matching internal.txt or port forwarding problems.
28-09-10
iSpooky

Re: FreeTDS

this the only error i get right now.
DBagent_24

Code:

[Tue Sep 28 2010 16:36:48.309046 3086747344]: open log file '/var/log/cabal/DBAgent_24.log' [Tue Sep 28 2010 16:36:48.309251 3086747344]: LOG LEVEL: 3 [Tue Sep 28 2010 16:36:48.309278 3086747344]: MemPoolUnitSizeClass(2): 24576Bytes [Tue Sep 28 2010 16:36:48.309971 3086747344]: Start DBAgent_24 Server [Tue Sep 28 2010 16:36:48.310538 3086747344]: UseEcryptText (Off) [Tue Sep 28 2010 16:36:48.416511 3086744464]: CProcessLayer(0)::svc Start [3086744464] [Tue Sep 28 2010 16:36:48.416600 3076254608]: CProcessLayer(0)::svc Start [3076254608] [Tue Sep 28 2010 16:36:48.422271 3086747344]: try listening 53424 port [Tue Sep 28 2010 16:36:48.422709 3065764752]: CProcessLayer(0)::svc Start [3065764752] [Tue Sep 28 2010 16:36:48.422767 3055274896]: CProcessLayer(0)::svc Start [3055274896] [Tue Sep 28 2010 16:36:48.422888 3044785040]: CProcessLayer(0)::svc Start [3044785040] [Tue Sep 28 2010 16:36:48.745387 3086747344]: accept success 8(127.0.0.1:36187) [Tue Sep 28 2010 16:36:48.746077 3086747344]: 1.open user 8 [927FF78] (127.0.0.1) [Tue Sep 28 2010 16:36:49.055267 3086747344]: accept success 10(127.0.0.1:36189) [Tue Sep 28 2010 16:36:49.055753 3086747344]: 2.open user 10 [928E6A0] (127.0.0.1) [Tue Sep 28 2010 16:37:37.669832 3044785040]: Database Connect success! [Tue Sep 28 2010 16:37:37.699774 3076254608]: Database Connect success! [Tue Sep 28 2010 16:37:37.706141 3086744464]: Database Connect success! [Tue Sep 28 2010 16:37:46.315274 3086744464]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072 [Tue Sep 28 2010 16:40:09.281235 3076254608]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed. [Tue Sep 28 2010 16:40:09.281402 3076254608]: [##ERROR##] DB ERROR(CODE) : 20004 [Tue Sep 28 2010 16:40:09.281420 3076254608]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:40:09.281434 3076254608]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:40:09.281448 3076254608]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:40:12.800529 3076254608]: Database Connect success! [Tue Sep 28 2010 16:40:12.800570 3076254608]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:40:12.800614 3076254608]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 16:40:49.105257 3065764752]: Database Connect success! [Tue Sep 28 2010 16:46:49.098881 3055274896]: Database Connect success! [Tue Sep 28 2010 16:48:08.945958 3055274896]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed. [Tue Sep 28 2010 16:48:08.946046 3055274896]: [##ERROR##] DB ERROR(CODE) : 20004 [Tue Sep 28 2010 16:48:08.946062 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:08.946076 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:08.946089 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:48:11.972408 3055274896]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Sep 28 2010 16:48:11.973054 3055274896]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Sep 28 2010 16:48:11.973070 3055274896]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:11.973084 3055274896]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:11.973097 3055274896]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Sep 28 2010 16:48:11.973111 3055274896]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24) [Tue Sep 28 2010 16:48:11.973127 3055274896]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:48:11.973295 3055274896]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1) [Tue Sep 28 2010 16:48:49.056743 3086744464]: [##ERROR##] DB ERROR(MSG) : [Tue Sep 28 2010 16:48:49.057146 3086744464]: [##ERROR##] DB ERROR(CODE) : 0 [Tue Sep 28 2010 16:48:49.057162 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:49.057208 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 00000 [Tue Sep 28 2010 16:48:49.057223 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_InstantWar_GetCurrentNationRewardWarResults} [Tue Sep 28 2010 16:48:52.071146 3086744464]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist. [Tue Sep 28 2010 16:48:52.071388 3086744464]: [##ERROR##] DB ERROR(CODE) : 20009 [Tue Sep 28 2010 16:48:52.071403 3086744464]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Sep 28 2010 16:48:52.071417 3086744464]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01 [Tue Sep 28 2010 16:48:52.071431 3086744464]: [##ERROR##] DB ERROR(STM_TEXT) : [Tue Sep 28 2010 16:48:52.071445 3086744464]: [##ERROR##] Database Connect Fail (uid=sa;pwd=*****;dsn=CabalGame;APP=DBAgent_24) [Tue Sep 28 2010 16:48:52.071460 3086744464]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:187) [Tue Sep 28 2010 16:48:52.071477 3086744464]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(BB:0:187) Addr(127.0.0.1)
02-10-10
iSpooky

Re: FreeTDS

After some research i still didnt find a solution
03-10-10
chumpywumpy

Re: FreeTDS

That error will happen as you have no nationwar results yet. There is some "database connect success!" though which means it is now connecting ok.

Where is it failing now, is it getting past the user/pass screen? Does the loginsvr log show your connection attempts?
03-10-10
iSpooky

Re: FreeTDS

nope i cant get past the user/pass screen

This is my loginsvr_01

Code:

[Tue Sep 28 2010 16:36:49.464343 3086698992]: open log file '/var/log/cabal/LoginSvr_01.log' [Tue Sep 28 2010 16:36:49.464480 3086698992]: LOG LEVEL: 3 [Tue Sep 28 2010 16:36:49.464567 3086698992]: MemPoolUnitSizeClass(0): 14336Bytes [Tue Sep 28 2010 16:36:49.465861 3086698992]: Start LoginSvr_01 Server [Tue Sep 28 2010 16:36:49.466002 3086698992]: SITE_CHN, GAMEGUARD_V25, APEX_V10 [Tue Sep 28 2010 16:36:49.466030 3086698992]: TestChannelGroupIdxStartPoint=50 [Tue Sep 28 2010 16:36:49.466092 3086698992]: affiliatedCorpIP=121.170.135.; [Tue Sep 28 2010 16:36:49.466158 3086698992]: AdminIP=121.170.135.; [Tue Sep 28 2010 16:36:49.466184 3086698992]: client_version=22 [Tue Sep 28 2010 16:36:49.466200 3086698992]: IgnoreClientVersion(1) [Tue Sep 28 2010 16:36:49.466220 3086698992]: UseAntiOnlineGameAddictionSystem(1) [Tue Sep 28 2010 16:36:49.466235 3086698992]: AdultAge(18) [Tue Sep 28 2010 16:36:49.466250 3086698992]: DefaultAgeAdult(1) [Tue Sep 28 2010 16:36:49.466266 3086698992]: UsePSS(0) [Tue Sep 28 2010 16:36:49.466300 3086698992]: CachedPSS(0) [Tue Sep 28 2010 16:36:49.466314 3086698992]: PssCacheDurationMin(1440) [Tue Sep 28 2010 16:36:49.466330 3086698992]: CutIfPssUserNotFound(0) [Tue Sep 28 2010 16:36:49.466345 3086698992]: PssLogLevel(0) [Tue Sep 28 2010 16:36:49.466359 3086698992]: InstantPlayTimeClearIntervalMin(300) [Tue Sep 28 2010 16:36:49.466374 3086698992]: IDC(1) [Tue Sep 28 2010 16:36:49.466388 3086698992]: SharedPssPersonId(0) [Tue Sep 28 2010 16:36:49.466404 3086698992]: NormalClientMagicKey(1168110) [Tue Sep 28 2010 16:36:49.466420 3086698992]: UseImageAuth(0) [Tue Sep 28 2010 16:36:49.466494 3086698992]: ImageAuthDataPath(./ImageAuth/) [Tue Sep 28 2010 16:36:49.466510 3086698992]: ImageAuthMaxTryCount(5) [Tue Sep 28 2010 16:36:49.466525 3086698992]: ImageAuthWaitTime(120000) [Tue Sep 28 2010 16:36:49.466540 3086698992]: BlockIfImageAuthFail(0) [Tue Sep 28 2010 16:36:49.466607 3086698992]: UseServerListManualOrder(0) [Tue Sep 28 2010 16:36:49.466623 3086698992]: 00:00 => 0 [Tue Sep 28 2010 16:36:49.466636 3086698992]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0 [Tue Sep 28 2010 16:36:49.466651 3086698992]: ImageAuthDataMgr Init Begin [Tue Sep 28 2010 16:37:50.572204 3086698992]: ImageAuthDataMgr Init End(Count:1995) [Tue Sep 28 2010 16:37:50.696448 3078396816]: CProcessLayer(0)::svc Start [3078396816] [Tue Sep 28 2010 16:37:50.713396 3086698992]: try connect 127.0.0.1:38170, Sync [Tue Sep 28 2010 16:37:50.822197 3086698992]: sock 7 ->LinkHandler Open [Tue Sep 28 2010 16:37:50.822296 3086698992]: SendIPSConnect2Svr (195:128:01:00) [Tue Sep 28 2010 16:37:50.822372 3086698992]: try connect 127.0.0.1:38180, Sync [Tue Sep 28 2010 16:37:50.822504 3086698992]: sock 9 ->LinkHandler Open [Tue Sep 28 2010 16:37:50.822532 3086698992]: SendIPSConnect2Svr (195:128:01:00) [Tue Sep 28 2010 16:37:50.822573 3086698992]: try listening 38101 port [Tue Sep 28 2010 16:37:50.823531 3078396816]: ServerState changed(0 -> 0) [Sun Oct 3 2010 14:17:53.530173 3086039536]: open log file '/var/log/cabal/LoginSvr_01.log' [Sun Oct 3 2010 14:17:53.685817 3086039536]: LOG LEVEL: 3 [Sun Oct 3 2010 14:17:53.686502 3086039536]: MemPoolUnitSizeClass(0): 14336Bytes [Sun Oct 3 2010 14:17:53.689730 3086039536]: Start LoginSvr_01 Server [Sun Oct 3 2010 14:17:53.689799 3086039536]: SITE_CHN, GAMEGUARD_V25, APEX_V10 [Sun Oct 3 2010 14:17:53.689824 3086039536]: TestChannelGroupIdxStartPoint=50 [Sun Oct 3 2010 14:17:53.689884 3086039536]: affiliatedCorpIP=121.170.135.; [Sun Oct 3 2010 14:17:53.689904 3086039536]: AdminIP=121.170.135.; [Sun Oct 3 2010 14:17:53.689943 3086039536]: client_version=22 [Sun Oct 3 2010 14:17:53.689961 3086039536]: IgnoreClientVersion(1) [Sun Oct 3 2010 14:17:53.689982 3086039536]: UseAntiOnlineGameAddictionSystem(1) [Sun Oct 3 2010 14:17:53.690000 3086039536]: AdultAge(18) [Sun Oct 3 2010 14:17:53.690498 3086039536]: DefaultAgeAdult(1) [Sun Oct 3 2010 14:17:53.690514 3086039536]: UsePSS(0) [Sun Oct 3 2010 14:17:53.690567 3086039536]: CachedPSS(0) [Sun Oct 3 2010 14:17:53.690584 3086039536]: PssCacheDurationMin(1440) [Sun Oct 3 2010 14:17:53.716631 3086039536]: CutIfPssUserNotFound(0) [Sun Oct 3 2010 14:17:53.716672 3086039536]: PssLogLevel(0) [Sun Oct 3 2010 14:17:53.716691 3086039536]: InstantPlayTimeClearIntervalMin(300) [Sun Oct 3 2010 14:17:53.716707 3086039536]: IDC(1) [Sun Oct 3 2010 14:17:53.716723 3086039536]: SharedPssPersonId(0) [Sun Oct 3 2010 14:17:53.716739 3086039536]: NormalClientMagicKey(1168110) [Sun Oct 3 2010 14:17:53.716755 3086039536]: UseImageAuth(0) [Sun Oct 3 2010 14:17:53.716772 3086039536]: ImageAuthDataPath(./ImageAuth/) [Sun Oct 3 2010 14:17:53.716788 3086039536]: ImageAuthMaxTryCount(5) [Sun Oct 3 2010 14:17:53.716804 3086039536]: ImageAuthWaitTime(120000) [Sun Oct 3 2010 14:17:53.716819 3086039536]: BlockIfImageAuthFail(0) [Sun Oct 3 2010 14:17:53.716855 3086039536]: UseServerListManualOrder(0) [Sun Oct 3 2010 14:17:53.716869 3086039536]: 00:00 => 0 [Sun Oct 3 2010 14:17:53.716883 3086039536]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0 [Sun Oct 3 2010 14:17:53.716900 3086039536]: ImageAuthDataMgr Init Begin [Sun Oct 3 2010 14:19:23.841888 3086039536]: ImageAuthDataMgr Init End(Count:1995) [Sun Oct 3 2010 14:19:24.136270 3086039536]: try connect 127.0.0.1:38170, Sync [Sun Oct 3 2010 14:19:24.141636 3077737360]: CProcessLayer(0)::svc Start [3077737360] [Sun Oct 3 2010 14:19:24.305791 3086039536]: sock 7 ->LinkHandler Open [Sun Oct 3 2010 14:19:24.305871 3086039536]: SendIPSConnect2Svr (195:128:01:00) [Sun Oct 3 2010 14:19:24.305941 3086039536]: try connect 127.0.0.1:38180, Sync [Sun Oct 3 2010 14:19:24.306897 3086039536]: sock 9 ->LinkHandler Open [Sun Oct 3 2010 14:19:24.306927 3086039536]: SendIPSConnect2Svr (195:128:01:00) [Sun Oct 3 2010 14:19:24.306972 3086039536]: try listening 38101 port [Sun Oct 3 2010 14:19:24.369913 3077737360]: ServerState changed(0 -> 0)
03-10-10
chumpywumpy

Re: FreeTDS

The loginsvr is coming up ok so it must be networking somewhere.

If you have a router make sure your WAN IP (What Is My IP Address - Shows Your IP Address) is in your internal.txt (unless testing locally) and that you have forwarded ports on your router. VMWare networking should be set to "Bridged".

If you don't have a router (i.e. your main windows IP doesn't start 192.x or 10.x) then VMWare should be set to "NAT" and the port forwarding done on the vmware NAT interface.

Try running cabal_config and using the local ip for the gameserver and the same in internal.txt. With a local config port forwarding and router issues don't affect it. You might have one of the router types that won't let people inside the LAN log in using the WAN IP address but a local setup shoud always work if configured correctly.
03-10-10
iSpooky

Re: FreeTDS

Ok i think i found the problem at vmware it was at custom not at bridged but if i put it on bridged centos cant ping to windows and windows cant ping to centos

Edit: ok i found out too that my ports werent open yet opened them but still they both cant ping eachother :(
03-10-10
chumpywumpy

Re: FreeTDS

So you have a router yes?

Check "ipconfig" on windows and "ifconfig" on centos via command line. Both should have a vmware IP in the same subnet like 192.168.0.x. The first 3 numbers between the . (octets) will usually be the same with just the last number being different.

Post screenies after blanking bits if you want and i can probably tell what is wrong.
03-10-10
iSpooky

Re: FreeTDS

Yess i use a router
i can ping from windows to centos but not from centos to windows now

http://i55.tinypic.com/2meqqte.png
03-10-10
chumpywumpy

Re: FreeTDS

Try setting up locally using the 192.168.1.x addresses for both internal.txt and the server config IP. I need to see if that works first.

I don't even want to know why 1 network adaptor seems to have 3 IP addresses :/
03-10-10
iSpooky

Re: FreeTDS

Where can i find intertal.txt ? and if i found that what i have to do than ?
ok i really did nothing but windows can ping to centos and centos to windows :O a miracle happend :)
so im gonna test now if i can get ingame :)
Still cant get ingame logs dont give any errors :(
03-10-10
cypher

Re: FreeTDS

Quote:

Originally Posted by chumpywumpy

Try setting up locally using the 192.168.1.x addresses for both internal.txt and the server config IP. I need to see if that works first.

I don't even want to know why 1 network adaptor seems to have 3 IP addresses :/

Maybe he works in 3 different subnets at the same time?
03-10-10
iSpooky

Re: FreeTDS

What do you mean with 3 diffrent subnets?
04-10-10
chumpywumpy

Re: FreeTDS

Quote:

Originally Posted by cypher

Maybe he works in 3 different subnets at the same time?

Check the ipconfig screenie. The second network adaptor seems to have 3 WAN IP addresses. I have never seen that before :ehh:
04-10-10
iSpooky

Re: FreeTDS

Hmmm this the first time i see it before.
but do you have any idea why i still cant connect to my server?
all logs are normal without errors
04-10-10
cypher

Re: FreeTDS

Quote:

Originally Posted by chumpywumpy

Check the ipconfig screenie. The second network adaptor seems to have 3 WAN IP addresses. I have never seen that before :ehh:

I thought it was about lan. I've never seen one adapter to have 3 WAN ip's either. Maybe he clicked the advanced tab of his ipv4 settings and he added 2 more ips.

@User: is your internet working on that machine, also please double check your host and guest network linking. Check pings from your host to your guest machine.
05-10-10
iSpooky

Re: FreeTDS

i cant ping from windows to centos and from centos to windows anymore :S
but yesterday i could
05-10-10
chumpywumpy

Re: FreeTDS

IP addresses have changed by the sound of it. Check ipconfig/ifconfig and make sure you have at least 1 adaptor with the same subnet. Type "setup" in centos and use the network wizard to change it to dhcp (auto) and it will figure out the correct settings itself.
05-10-10
iSpooky

Re: FreeTDS

Ok this happens now
First windows can ping twice too centos than after that it get a timeout
centos never can ping to windows
and i cant choose between dhcp auto or something else
07-10-10
chumpywumpy

Re: FreeTDS

Hmmm. If the database connections from centos can get through and not pings i would guess there is a firewall which is blocking pings but letting sql connections through.

In Setup go to Network configuration->Run Tool

Highlight "Edit a device params" and press Enter. Press Enter again on the eth0 adaptor.

Highlight "Use DHCP" and press spacebar to select it. Everything below it should go grey.

http://i344.photobucket.com/albums/p...2/devernet.jpg
08-10-10
iSpooky

Re: FreeTDS

i did what you said but still the same problem :S i even putted my windows firewall off and my centos firewall is always off
08-10-10
chumpywumpy

Re: FreeTDS

Let me know what hours (GMT) you are available as i think we might need to use IRC for this one. I won't be around much tonight but i will be for most of tomrrow.
08-10-10
iSpooky

Re: FreeTDS

i use UTC+1 no idea what gmt that is :S

And thanks chumpy for helping me alot :D
ill thank Cypher too for helping but idk why i cant thank you with that thank button
And i thank Yamachi too for warning me that i not gotta double post or bump my own thread :D

i just had to do that ;p
09-10-10
cypher

Re: FreeTDS

No need to help me, Chumpy did the whole job. UTC+1 = GMT+1
13-10-10
iSpooky

Re: FreeTDS

Soo chumpy when are you on IRC ?

PS: What ports have to be open and on with ip address? the centos or the windows one ?
15-10-10
chumpywumpy

Re: FreeTDS

Sorry, i have been busy and partially crippled by a pulled muscle this week so i didn't get this done. I will be on IRC around 12:00 (lunchtime) your time tomorrow unless you have a better time ( i won't be here for the rest of tonight).

Ports are 38101-38190 and it should be your WAN address (whatismyip.com) pointed to the centos LAN one ("ifconfig" and choose the 192.x one). Most routers just want the IP to point to which is the centos one.
17-10-10
iSpooky

1 Attachment(s)

Re: FreeTDS

i can ping windows to centos and centos to windows now

but still cant login

Here are my logs :)
19-10-10
chumpywumpy

Re: FreeTDS

There are no login attempts shown in the loginsvr log so make sure 192.168.1.126 is the IP address in internal.txt.

I suspect there is something not right with the SQL setup too. Run the query below on any database and it will do a config check. Post the results and it will let me know if anything is wrong at that end.

Quote:

Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
set @insname='MSSQLSERVER'
else
set @insname=convert(varchar(25),serverproperty('instancename'))
select @insname as 'Instance',
serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
serverproperty('edition') as 'Edition'
if @insname<>'MSSQLSERVER'
begin
select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
end

begin
Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
@value_name=@insname,
@value=@inspath OUTPUT
set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg,
@value_name='Enabled',
@value=@tcpremote OUTPUT
select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
if @tcpremote='0'
begin
EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
@key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
select 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
end
else
begin
select 'This is good! I have nothing to do :(' as 'Remote connections checker'
end
select account.dbo.fn_md5('test') as 'xp_md5.dll check'
end
19-10-10
iSpooky

Re: FreeTDS

Where can i find internal.txt ?

This does mssql says

Code:

MSSQLSERVER 9.00.4053.00 SP3 Express Edition MSSQL.2 1 This is good! I have nothing to do :( 098f6bcd4621d373cade4e832627b4f6
19-10-10
chumpywumpy

Re: FreeTDS

Those results look ok. The errors do indicate an mssql problem though so we may need to check the firewall.

http;//mrmagoo.psiblade.net/sqltest.7z

Extract that and copy both files to /root/ on centos. Now to a "chmod 0777 <filename" on both files and finally type /root/test_sql.sh. It will ask for your db user/pass and then try connecting to the database using Cabal's datasource details. It should show 1 result (098f6bcd4621d373cade4e832627b4f6, the md5 test) if it works.

Internal.txt should be in the /data/ folder of you client. If not then use my patch below, edit internal.txt with the IP from my last post and run the start-cabal batch file to launch the client.
v2.81 patchdata by Lost-Spirit.7z
19-10-10
iSpooky

Re: FreeTDS

btw Chumpy can you get on IRC?

EDIT: The script you gaved me worked

Code:

+---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> +---------------------------------+ | | +---------------------------------+ | 098f6bcd4621d373cade4e832627b4f6| +---------------------------------+ SQLRowCount returns 1 1 rows fetched

Ok i can login now but now i cant make a char this the error i get in dbagent

Code:

[##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 40) [Tue Oct 19 2010 21:53:08.597909 3086711696]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Login failed for user ''. [Tue Oct 19 2010 21:53:08.597924 3086711696]: [##ERROR##] DB ERROR(CODE) : 18456 [Tue Oct 19 2010 21:53:08.597936 3086711696]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Oct 19 2010 21:53:08.597945 3086711696]: [##ERROR##] DB ERROR(SQLSTATE) : 28000 [Tue Oct 19 2010 21:53:08.597951 3086711696]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )} [Tue Oct 19 2010 21:53:08.601983 3086711696]: Database Connect success! [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx: 40) [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Login failed for user ''. [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] DB ERROR(CODE) : 18456 [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] DB ERROR(VAR_INFO) : [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] DB ERROR(SQLSTATE) : 28000 [Tue Oct 19 2010 21:53:09.361533 3086711696]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ? , ? , ? , ? )} [Tue Oct 19 2010 21:53:09.363796 3086711696]: Database Connect success!
20-10-10
chumpywumpy

Re: FreeTDS

Sorry, i missed it last night and i'm at work atm. The sql test means it is connecting to the db ok. I wasn't completely sure as one error was expected and one is but only sometimes.

The error looks like a bad linked server setting. Look in my sig and there is a guide on removing the need for a linked server. It is just 2 queries to run to modify 2 stored procedures.

I'll be around from 19:00 GMT tonight so PM me if you want me to jump on IRC. I don't do that on request very often but if it helps fix this one i don't mind.
20-10-10
iSpooky

Re: FreeTDS

Thanks Chumpy :D im online now :D

Thanks alot :D!!

Greetz iSpooky
20-10-10
benng

Re: FreeTDS

hi ispooky,

I had the same problem too. Have u manage to solve this issue?
20-10-10
chumpywumpy

Re: FreeTDS

Quote:

Originally Posted by iSpooky

Thanks Chumpy :D im online now :D

Thanks alot :D!!

Greetz iSpooky

Sorry, i think i missed you. I ended up having to do an emergency rebuild on a friends computer (he runs his business from it). Lets try again tomorrow at 19:00 GMT as i definitely have nothing to get in the way this time XD

Quote:

Originally Posted by benng

hi ispooky,

I had the same problem too. Have u manage to solve this issue?

It could easily be a different issue. It is best to start by posting a set of logs in a new topic so i can take a look and guide you from there.
21-10-10
iSpooky

Re: FreeTDS

Alright Chumpy ill be on IRC since i have some diff probelems now :)