FW: linux - php - mssql
Novy David
david_novy na lion.cz
Pátek Březen 21 13:34:24 CET 2003
hned to jdu vyzkoušet, . ještě se zeptam proč jste nepoužil --enable-mssql,
ale pouze jenom --enable-sybase?
PHPko i FreeTDS jsem kompiloval sam. U tds jsem použil standardni
nastavení u phpka takhle:
'./configure' '--prefix=/usr' '--disable-static'
'--with-apxs=/usr/sbin/apxs' '--enable-discard-path'
'--with-config-file-path=/etc/apache' '--enable-safe-mode'
'--with-openssl' '--enable-bcmath' '--with-bz2' '--enable-pic'
'--enable-calendar' '--enable-ctype' '--with-gdbm' '--with-db2'
'--with-db3' '--enable-dbase' '--enable-ftp' '--enable-gd-imgstrttf'
'--with-gd=/tmp/gd-1.8.4' '--with-jpeg-dir=/tmp/gd-1.8.4'
'--with-png-dir=/tmp/gd-1.8.4' '--with-gmp' '--with-mysql=/usr'
'--with-xml=shared' '--with-mm=/usr' '--enable-trans-sid'
'--enable-shmop' '--enable-sockets' '--with-regex=php'
'--enable-sysvsem' '--enable-sysvshm' '--enable-yp'
'--enable-memory-limit' '--with-tsrm-pthreads' '--enable-shared'
'--disable-debug' '--with-zlib=/usr' '--with-sybase=/usr/local/freetds'
'--with-ldap'
Potom do /etc/profile jsem vložil tenhle radek
export SYBASE=/usr/local/freetds
A nakonec jsem upravik takto /usr/local/freetds/freetds.conf
[global]
# TDS protocol version
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
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
; nt domain = WORKGROUP
# If the server responds with different domain try that one?
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;
# A typical Microsoft SQL Server 7.0 configuration
[cpq01]
host = 192.168.10.102
port = 1433
tds version = 7.0
;client charset = WINDOWS-1250
Vse na slacku 8.1, takze musite vzit v uvahu distribuci, kterou
pouzivate.
Další informace o konferenci Linux