Annexes:FreeTds : Différence entre versions

De WikiFr_dbSQWare
Aller à : navigation, rechercher
(Page créée avec « Téléchargez les sources et mettez-les dans /tmp : <pre> [root@vmsqwarebox tmp]# su - mssql $ cd /applis/mssql $ tar zxvf /tmp/freetds-patched.tar.gz freetds-0.95.69/incl... »)
 
 
(8 révisions intermédiaires par le même utilisateur non affichées)
Ligne 1 : Ligne 1 :
 
Téléchargez les sources et mettez-les dans /tmp :
 
Téléchargez les sources et mettez-les dans /tmp :
 
<pre>
 
<pre>
−
[root@vmsqwarebox tmp]# su - mssql
+
# https://www.freetds.org/
−
$ cd /applis/mssql
+
# ftp://ftp.freetds.org/pub/freetds/stable/
−
$ tar zxvf /tmp/freetds-patched.tar.gz
+
# https://www.freetds.org/files/stable/freetds-1.4.17.tar.gz
−
freetds-0.95.69/include/replacements/readpassphrase.h
+
 
−
freetds-0.95.69/include/bkpublic.h
+
[root@vmsqwarebox ~]# su - mssql
−
...
+
mssql@vmsqwarebox:/home/mssql () $ cd /applis/mssql/
 +
mssql@vmsqwarebox:/applis/mssql () $ tar zxvf /tmp/freetds-1.4.17.tar.gz
 
</pre>
 
</pre>
 
<br>
 
<br>
  
−
Compilation :
+
Compilation (avec openssl, "yum install openssl-devel openssl" ou "dnf install openssl-devel openssl" pour l'installer) :
 
<pre>
 
<pre>
−
$ cd /applis/mssql/freetds-0.95.69
+
mssql@vmsqwarebox:/applis/mssql () $ cd /applis/mssql/freetds-1.4.17
−
$ ./configure --prefix=/applis/mssql/freetds
+
 
 +
#Commande pour CentOS 7
 +
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/openssl/engines
 +
 
 +
#Commande pour Rocky Linux 8
 +
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/engines-1.1
 +
 
 +
#Commande pour Rocky Linux 9
 +
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/engines-3
 +
 
 +
 
 
checking for a BSD-compatible install... /usr/bin/install -c
 
checking for a BSD-compatible install... /usr/bin/install -c
 
checking whether build environment is sane... yes
 
checking whether build environment is sane... yes
 +
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
 
checking for gawk... gawk
 
checking for gawk... gawk
 
checking whether make sets $(MAKE)... yes
 
checking whether make sets $(MAKE)... yes
 
...
 
...
  
−
$ make
+
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ make
 
Making all in include
 
Making all in include
−
make[1]: Entering directory `/applis/mssql/freetds-0.95.69/include'
+
make[1]: Entering directory `/applis/mssql/freetds-1.4.17/include'
 
make  all-recursive
 
make  all-recursive
−
make[2]: Entering directory `/applis/mssql/freetds-0.95.69/include'
+
make[2]: Entering directory `/applis/mssql/freetds-1.4.17/include'
 +
Making all in freetds
 +
make[3]: Entering directory `/applis/mssql/freetds-1.4.17/include/freetds'
 +
 
 
...
 
...
  
−
$ make install
+
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ make install
 
Making install in include
 
Making install in include
−
make[1]: Entering directory `/applis/mssql/freetds-0.95.69/include'
+
make[1]: Entering directory `/applis/mssql/freetds-1.4.17/include'
 +
Making install in freetds
 +
make[2]: Entering directory `/applis/mssql/freetds-1.4.17/include/freetds'
 +
 
 
...
 
...
 
</pre>
 
</pre>
Ligne 35 : Ligne 53 :
 
Ménage :
 
Ménage :
 
<pre>
 
<pre>
−
$ rm -rf /applis/mssql/freetds-0.95.69
+
$ rm -rf /applis/mssql/freetds-1.4.17
−
$ rm -f /tmp/freetds-patched.tar.gz
+
$ rm -f /tmp/freetds-1.4.17.tar.gz
 
</pre>
 
</pre>
 
<br>
 
<br>
Ligne 47 : Ligne 65 :
 
drwxr-xr-x 2 mssql dba 4096 Nov 23 09:38 lib
 
drwxr-xr-x 2 mssql dba 4096 Nov 23 09:38 lib
 
lrwxrwxrwx 1 mssql dba    3 Nov 23 09:41 lib64 -> lib
 
lrwxrwxrwx 1 mssql dba    3 Nov 23 09:41 lib64 -> lib
 +
</pre>
 +
 +
Lien vers le freetds.conf généré automatiquement :
 +
<pre>
 +
cd /applis/mssql/freetds/etc
 +
mv freetds.conf freetds.conf.org
 +
ln -s /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/freetds_dbsqware.conf freetds.conf
 +
</pre>
 +
<br>
 +
 +
Dans le ~mssql/.bash_profile
 +
<pre>
 +
# env FreeTDS (pour connexion MsSql)
 +
export PATH=/applis/mssql/freetds/bin:$PATH
 +
export LD_LIBRARY_PATH=/applis/mssql/freetds/lib:$LD_LIBRARY_PATH
 +
 +
lvsqw_InstanceParam=$(echo "$1"|tr [a-z] [A-Z])
 +
 +
# env dbSQWare pour mssql, must stay at end of .bash_profile
 +
export gvsqw_Env='PRD'
 +
export gvsqw_MsqBin=$HOME/SQWareProduction/mssql/bin
 +
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
 +
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MsqBin/../etc/.profile_confort ]
 +
then
 +
. $gvsqw_MsqBin/../etc/.profile_confort
 +
fi
 
</pre>
 
</pre>
 
<br>
 
<br>

Version actuelle datée du 12 juin 2024 à 07:26

Téléchargez les sources et mettez-les dans /tmp : 

# https://www.freetds.org/
# ftp://ftp.freetds.org/pub/freetds/stable/
# https://www.freetds.org/files/stable/freetds-1.4.17.tar.gz

[root@vmsqwarebox ~]# su - mssql
mssql@vmsqwarebox:/home/mssql () $ cd /applis/mssql/
mssql@vmsqwarebox:/applis/mssql () $ tar zxvf /tmp/freetds-1.4.17.tar.gz


Compilation (avec openssl, "yum install openssl-devel openssl" ou "dnf install openssl-devel openssl" pour l'installer) : 

mssql@vmsqwarebox:/applis/mssql () $ cd /applis/mssql/freetds-1.4.17

#Commande pour CentOS 7
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/openssl/engines

#Commande pour Rocky Linux 8
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/engines-1.1

#Commande pour Rocky Linux 9
mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ ./configure --prefix=/applis/mssql/freetds --with-openssl=/usr/lib64/engines-3


checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
...

mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ make
Making all in include
make[1]: Entering directory `/applis/mssql/freetds-1.4.17/include'
make  all-recursive
make[2]: Entering directory `/applis/mssql/freetds-1.4.17/include'
Making all in freetds
make[3]: Entering directory `/applis/mssql/freetds-1.4.17/include/freetds'

...

mssql@vmsqwarebox:/applis/mssql/freetds-1.4.17 () $ make install
Making install in include
make[1]: Entering directory `/applis/mssql/freetds-1.4.17/include'
Making install in freetds
make[2]: Entering directory `/applis/mssql/freetds-1.4.17/include/freetds'

...


Ménage : 

$ rm -rf /applis/mssql/freetds-1.4.17
$ rm -f /tmp/freetds-1.4.17.tar.gz


Lien lib 64bits : 

$ cd /applis/mssql/freetds
$ ln -s lib lib64
$ ls -l |grep lib
drwxr-xr-x 2 mssql dba 4096 Nov 23 09:38 lib
lrwxrwxrwx 1 mssql dba    3 Nov 23 09:41 lib64 -> lib

Lien vers le freetds.conf généré automatiquement : 

cd /applis/mssql/freetds/etc
mv freetds.conf freetds.conf.org
ln -s /home/dbsqware/dbSQWare/SQWareCentral/etc_cust/freetds_dbsqware.conf freetds.conf


Dans le ~mssql/.bash_profile 

# env FreeTDS (pour connexion MsSql)
export PATH=/applis/mssql/freetds/bin:$PATH
export LD_LIBRARY_PATH=/applis/mssql/freetds/lib:$LD_LIBRARY_PATH

lvsqw_InstanceParam=$(echo "$1"|tr [a-z] [A-Z])

# env dbSQWare pour mssql, must stay at end of .bash_profile
export gvsqw_Env='PRD'
export gvsqw_MsqBin=$HOME/SQWareProduction/mssql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MsqBin/../etc/.profile_confort ]
then
. $gvsqw_MsqBin/../etc/.profile_confort
fi


Récupérée de « https://wikifr.dbsqware.com/index.php?title=Annexes:FreeTds&oldid=17659 »