Changes

From SME Server
Jump to navigationJump to search
174 bytes added ,  07:23, 19 June 2009
m
Included original config files
Line 106: Line 106:     
====freetds.conf====
 
====freetds.conf====
This file contains the settings that tell freetds about each server it will connect to. Ip can (should) be replaced with FQDN. The original file contain examples.
+
This file contains the settings that tell freetds about each server it will connect to. Ip can (should) be replaced with FQDN.
Make directory to hold template fragment to be included in the original file: /etc/freetds.conf
+
Make directory to hold template fragments to be included in the original path: /etc/freetds.conf
 
  mkdir -p /etc/e-smith/templates-custom/etc/freetds.conf
 
  mkdir -p /etc/e-smith/templates-custom/etc/freetds.conf
   −
Make and edit template fragment, "10xp3c" is my example and can be modified:  
+
Copy the original file to be included as a template fragment when we regenerate the file:
  pico /etc/e-smith/templates-custom/etc/freetds.conf/10xp3c
+
cp /etc/freetds.conf /etc/e-smith/templates-custom/etc/freetds.conf/10original
 +
 
 +
Make additional fragment for your foreign server, "20xp3c" is my example name and can be modified:  
 +
  pico /etc/e-smith/templates-custom/etc/freetds.conf/20xp3c
    
Add text about your foreign database server (modify to suit your conditions):
 
Add text about your foreign database server (modify to suit your conditions):
 
  # Microsoft SQL Server 2005 Express on a Win XP machine
 
  # Microsoft SQL Server 2005 Express on a Win XP machine
 
  [xp3c]
 
  [xp3c]
        host = 192.168.0.112
+
host = 192.168.0.112
        port = 1433
+
port = 1433
        tds version = 8.0   
+
tds version = 8.0   
        instance = db_kalle
+
instance = db_kalle
Exit with ctrl-x, save with y and enter. Insert your template fragment into the original file:
+
Exit with ctrl-x, save with y and enter. Regenerate the complete file:
    
  expand-template /etc/freetds.conf
 
  expand-template /etc/freetds.conf
    
====odbcinst.ini====
 
====odbcinst.ini====
This file tells unixODBC about the FreeTDS driver. Its kind of like an Alias, e.g.
+
This file tells unixODBC about the FreeTDS driver.
    
  mkdir -p /etc/e-smith/templates-custom/etc/odbcinst.ini
 
  mkdir -p /etc/e-smith/templates-custom/etc/odbcinst.ini
 +
 +
cp /etc/odbcinst.ini /etc/e-smith/templates-custom/etc/odbcinst.ini/10original
    
  pico /etc/e-smith/templates-custom/etc/odbcinst.ini/20sqlserver
 
  pico /etc/e-smith/templates-custom/etc/odbcinst.ini/20sqlserver
Line 144: Line 149:  
  mkdir -p /etc/e-smith/templates-custom/etc/odbc.ini
 
  mkdir -p /etc/e-smith/templates-custom/etc/odbc.ini
   −
  pico /etc/e-smith/templates-custom/etc/odbc.ini/20sqlserver
+
cp /etc/odbc.ini /etc/e-smith/templates-custom/etc/odbc.ini/10original
 +
 
 +
  pico /etc/e-smith/templates-custom/etc/odbc.ini/20xp3c
    
Add text (modify to suit your conditions):
 
Add text (modify to suit your conditions):
    
  [xp3c]
 
  [xp3c]
        Driver = FreeTDS
+
Driver = FreeTDS
        Description = Connection to DB_KALLE on server xp3c
+
Description = Connection to DB_KALLE on server xp3c
        Trace = No
+
Trace = No
        Server = 192.168.0.112
+
Server = 192.168.0.112
        Database = db_kalle
+
Database = db_kalle
        Port = 1433
+
Port = 1433
        TDS_Version = 8.0
+
TDS_Version = 8.0
    
  expand-template /etc/odbc.ini
 
  expand-template /etc/odbc.ini
206

edits

Navigation menu