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