Odbc.ini

[fakkadanmogool1]

As the title show: where can i find odbc.ini
Because i don't why i can't connect the server.
And i don't know how to login my sql database.
And i don't know how to check the connection between centOS and databases.
And i don't know how to check if port 1433 is open

Hope someone can help me out.

[MentaL]

[Amaymon]

Odbc.ini is located to usr/local/etc and for the rest of your questions check the section tutorial,you`ll find wonderfull things there.

[fakkadanmogool1]

But the logs are saying that the "sql server does not exist"

[emi]

that also happens if the centos can't reach the windows

[fakkadanmogool1]

When i Ping in centos with the command ping -c4 192.168.1.7 (sql ip/ Windows) It seems to be OK

When i ping in centos with the command ping -c4 192.168.52.128 (centOS ip)
It seems to be OK

So i dont know why database isn't responding.
The ports are also not responding but i still forwarded them.

[emi]

Enabled TC/IP connection via SQL//Firewall disabled?

[fakkadanmogool1]

How to do that ?

Ok I enabled Tcp.
the porblem "cannot connect to the server".
I did forwarded the ports but when i scan it says they don't respond even when i disable every firewall/and add it to exclusions.
I also don't know how to set the centOS network type Bridged or NAT. because i have a Tele2 modem for television, internet, Telephone.
So what to do ?

[Amaymon]

Follow this mini tutorial http://forum.ragezone.com/f460/conne...lution-736658/

[fakkadanmogool1]

But i can login with Winscp and putty.

[Amaymon]

Post your LOGS!

[fakkadanmogool1]

Look at http://forum.ragezone.com/f451/anyon...roblem-742928/

[Amaymon]

type in putty those commands:
cd var/log/cabal
cat DBAgent_01.log

And post here.

[fakkadanmogool1]

[Wed Apr 13 2011 02:17:05.127420 3086882512]: open log file '/var/log/cabal/DBAgent_01.log'
[Wed Apr 13 2011 02:17:05.127549 3086882512]: LOG LEVEL: 3
[Wed Apr 13 2011 02:17:05.127580 3086882512]: MemPoolUnitSizeClass(2): 24576Bytes
[Wed Apr 13 2011 02:17:05.128527 3086882512]: Start DBAgent_01 Server
[Wed Apr 13 2011 02:17:05.129265 3086882512]: UseEcryptText (Off)
[Wed Apr 13 2011 02:17:05.143835 3086879632]: CProcessLayer(0)::svc Start [3086879632]
[Wed Apr 13 2011 02:17:05.143946 3076389776]: CProcessLayer(0)::svc Start [3076389776]
[Wed Apr 13 2011 02:17:05.144019 3065899920]: CProcessLayer(0)::svc Start [3065899920]
[Wed Apr 13 2011 02:17:05.144090 3055410064]: CProcessLayer(0)::svc Start [3055410064]
[Wed Apr 13 2011 02:17:05.144190 3086882512]: try listening 38181 port
[Wed Apr 13 2011 02:17:05.147496 3044920208]: CProcessLayer(0)::svc Start [3044920208]
[Wed Apr 13 2011 02:17:05.298410 3086882512]: accept success 8(127.0.0.1:37990)
[Wed Apr 13 2011 02:17:05.299409 3086882512]: 1.open user 8 [9198BC0] (127.0.0.1)
[Wed Apr 13 2011 02:17:05.430610 3086882512]: accept success 10(127.0.0.1:37992)
[Wed Apr 13 2011 02:17:05.430708 3086882512]: 2.open user 10 [91A7300] (127.0.0.1)

[Amaymon]

Hmm,the server connected with succesfull to database,try disable firewall.

[fakkadanmogool1]

I already did.

Maybe its the client ?

[Amaymon]

Or you didin`t setup the ip of centos in internal.txt if you are using breaklee argument (.bat) or language.enc for argument husky

[fakkadanmogool1]

I created a .bat file with the argument Breaklee.
I also filled the internal.txt in.

IP=192.168.1.16
PORT=38101
CHAT_IP=192.168.1.16
CHAT_PORT=38121

[Amaymon]

@echo on
start cabalmain.exe breaklee
exit

This should be in startcabal.bat,and are u really sure the ip of centos is good?Type ifconfig in centos to see the ip.

[fakkadanmogool1]

Here is my screenshot of terminal....

[fakkadanmogool1]

Amaymon which client do you use ?
Do you have a link ?

[Amaymon]

I can`t give you my client because it is an custom one but you can look here http://forum.ragezone.com/f451/ogpla...anilla-732555/

[fakkadanmogool1]

Anyone have a solution for the problem:
Everything is ok.

But still can't connect