Hello, does someone could help me build my server on win 7? I downloaded various database and I know the error not is the database. I installed windows xp and was able to create but not in windows 7 I use the starter win 7 bit 32 someone can help me urgently to fix this error ? Error is in Command cat DBAgent_xx.log
I have install other version of windows 7 ?
1. Post your logs (use pastebin.com)
2. Check your firewall on both Windows and CentOS (selinux and iptables)
3. Make sure you're using the correct IP, username and password
4. If you're using VMWare, check to make sure that CentOS has access to your network and internet.
1 -Originally Posted by Yamachi
2 - how ?[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:12:01.752464 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:15:10.741719 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] Database Connect Fail (uid=sa;pwd=test123;dsn=CabalGame01;APP=DBAgent_01)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] check 'pDB' fail
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] 'OnIPCIWarGetLastNationRewardWarResults' fail (Database/InstantWar.cpp:140)
[Thu Sep 2 2010 19:18:19.723544 3044400032]: [##ERROR##] UsrMap Fail : MainCmd(600) Ret(8C:0:140) Addr(127.0.0.1)
[Thu Sep 2 2010 19:21:07.095189 3086362304]: SIGTERM
3 - I use the correct password and login first
4 - how ?
Thanks for fast Reply
1. Server is unavailable or does not exist.
Network is bad. Try pinging the centos machine to the mssql machine.
2. echo 0 >/selinux/enforce
iptables -F
4. ping -c4 google.com
4 -And what is the error ? :S[root@localhost ~]# ping -c4 google.com
PING google.com (64.233.163.104) 56(84) bytes of data.
64 bytes from bs-in-f104.1e100.net (64.233.163.104): icmp_seq=0 ttl=128 time=24.0 ms
64 bytes from bs-in-f104.1e100.net (64.233.163.104): icmp_seq=1 ttl=128 time=45.7 ms
64 bytes from bs-in-f104.1e100.net (64.233.163.104): icmp_seq=2 ttl=128 time=56.8 ms
64 bytes from bs-in-f104.1e100.net (64.233.163.104): icmp_seq=3 ttl=128 time=36.6 ms
--- google.com ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3010ms
rtt min/avg/max/mdev = 24.083/40.818/56.846/12.029 ms, pipe 2
That means that you have internet connectivity in the virtual machine.
If I have the connectivity , that is my connection error with the db?
In win XP my server run .. more in win 7 ( all versions ) have the error with the db
This sounds very much like the windows firewall is stopping the connection. The Win7 firewall has multiple profiles so it's easy to think it should allow connections when it doesn't. Try switching it off altogether.
Ok, I'll install the full files again and try to create the server then I turn off the firewall and I say if you can, thanks chumpy Love you :D
Reply With Quote
