mysql connection for windows server on linux

 freetds

/usr/local/etc/freetds.conf

/usr/local/etc

[root@mid etc]# cat freetds.conf 

#

#

#   $Id: freetds.conf,v 1.9 2003/12/04 22:26:55 freddy77 Exp $

#

# The freetds.conf file is a replacement for the original interfaces

# file developed by Sybase.  You may use either this or the interfaces

# file, but not both.

#

# FreeTDS will search for a conf file in the following order:

#

#     1) check if a file was set programatically via dbsetifile() and

#        is in .conf format, if so use that,

#

#     2) otherwise, if env variable FREETDSCONF specifies a properly 

#        formatted config file, use it,

#

#     3) otherwise, look in ~/.freetds.conf,

#

#     4) otherwise, look in @sysconfdir@/freetds.conf

#

# If FreeTDS has found no suitable conf file it will then search for

# an interfaces file in the following order:

#

#     1) check if a file was set programatically via dbsetifile() and 

#        is in interfaces format, if so use that,

#

#     2) look in ~/.interfaces

#

#     3) look in $SYBASE/interfaces (where $SYBASE is an environment

#        variable)

#

# Only hostname, port number, and protocol version can be specified

# using the interfaces format.

#

# The conf file format follows a modified Samba style layout.  There

# is a [global] section which will affect all database servers and

# basic program behaviour, and a section headed with the database

# server's name which will have settings which override the global

# ones.

#

# Note that environment variables TDSVER, TDSDUMP, TDSPORT, TDSQUERY, 

# and TDSHOST will override values set by a .conf or .interfaces file.

#

# To review the processing of the above, set env variable TDSDUMPCONFIG

# to a file name to log configuration processing.

#

# Global settings, any value here may be overridden by a database

# server specific section

[global]

        # TDS protocol version

tds version = 4.2

; initial block size = 512

# uses some fixes required for some bugged MSSQL 7.0 server that

# return invalid data to big endian clients

# NOTE TDS version 7.0 or 8.0 should be used instead

; swap broken dates = no

; swap broken money = no

# Database server login method, if both server and domain

# logins are enabled, domain login is tried first if a domain

# is specified, and if that fails the server login will be used.

# OBSOLETE

; try server login = yes

; try domain login = no

# The default authentication domain, can be overridden by

# specifying a username with a domain prefix, e.g. DOMAIN\username

# OBSOLETE use DOMAIN\username as username

; nt domain = WORKGROUP

# If the server responds with different domain try that one?

# OBSOLETE never been used

; cross domain login = no

# Whether to write a TDSDUMP file for diagnostic purposes

# (setting this to /tmp is insecure on a multi-user system)

; dump file = /tmp/freetds.log

; debug level = 10

# Command and connection timeouts

; timeout = 10

; connect timeout = 10

# If you get out of memory errors, it may mean that your client

# is trying to allocate a huge buffer for a TEXT field.  

# (Microsoft servers sometimes pretend TEXT columns are

# 4 GB wide!)   If you have this problem, try setting 

# 'text size' to a more reasonable limit 

text size = 64512

# This is a Sybase hosted database server, if you are directly on the

# net you can use it to test.

[JDBC]

host = 192.138.151.39

port = 4444

tds version = 5.0

# The same server, using TDS 4.2.  Used in configuration examples for the

# pool server, since the pool server supports only TDS 4.2.

[JDBC_42]

host = 192.138.151.39

port = 4444

tds version = 4.2

# The client connecting to the pool server will use this to find its

# listening socket.  This entry assumes that the client is on the same

# system as the pool server.

[mypool]

host = 127.0.0.1

port = 5000

tds version = 4.2

# A typical Microsoft SQL Server 7.0 configuration

;[MyServer70]

; host = ntmachine.domain.com

; port = 1433

; tds version = 7.0

# A typical Microsoft SQL Server 2000 configuration

;[MyServer2k]

; host = ntmachine.domain.com

; port = 1433

; tds version = 8.0

# A typical Microsoft SQL Server 6.x configuration

;[MyServer65]

; host = ntmachine.domain.com

; port = 1433

; tds version = 4.2

[myserver]

        host = 115.112.240.105

        # host = ntmachine.domain.com

        port = 1433

        tds version = 7.0

[myserver3]

        host = 209.133.202.2

        port = 1433

        tds version = 7.0

[myserver2]

        host = 192.227.65.65

        port = 1433

        tds version = 7.0

[myserver1]

        host = 192.227.117.41

        port = 1433

        tds version = 7.0

vi /usr/local/freetds/etc/freetds.conf

[myserver]

        host = 115.112.240.105

        # host = ntmachine.domain.com

        port = 1433

        tds version = 7.0

[myserver3]

        host = 192.227.108.64

        port = 1433

        tds version = 7.0

[myserver2]

        host = 192.227.65.65

        port = 1433

        tds version = 7.0

[myserver1]

        host = 154.27.75.96

        port = 1433

        tds version = 7.0

      'host' => 'localhost',

      'user' => 'rcautomat_in',

      'password' => 'automation',

      'database' => 'rcautomat_in',

      'port' => 3306,