Feature #3003

add MSSQL support in nethserver-unixODBC

Added by Stefano Fancello almost 5 years ago. Updated almost 5 years ago.

Status:CLOSEDStart date:
Priority:NormalDue date:
Assignee:-% Done:

100%

Category:nethserver-unixODBC
Target version:v6.5
Resolution: NEEDINFO:No

Description

Right now, nethserver-unixODBC support MySQL and PostgreSQL.
MSSQL support can be added FreeTDS dependency and a template to nethserver-unixODBC that add driver configuration.

Associated revisions

Revision d8f8e076
Added by Stefano Fancello almost 5 years ago

added MSSQL support. Refs #3003

Revision 4ef262a1
Added by Giacomo Sanchietti almost 5 years ago

Merge remote, fix missing push. Refs #3003

Conflicts:
nethserver-unixODBC.spec.in

History

#1 Updated by Stefano Fancello almost 5 years ago

  • Status changed from NEW to TRIAGED
  • % Done changed from 0 to 20

#2 Updated by Stefano Fancello almost 5 years ago

  • Status changed from TRIAGED to ON_DEV
  • % Done changed from 20 to 30

#3 Updated by Stefano Fancello almost 5 years ago

  • Status changed from ON_DEV to TRIAGED
  • % Done changed from 30 to 20

FreeTDS comes from epel

#4 Updated by Giacomo Sanchietti almost 5 years ago

  • Assignee deleted (Stefano Fancello)

#5 Updated by Stefano Fancello almost 5 years ago

  • Status changed from TRIAGED to MODIFIED
  • % Done changed from 20 to 60

commit d8f8e0766792663c56bcddb96d2c28e46f9c0444

#6 Updated by Stefano Fancello almost 5 years ago

  • Status changed from MODIFIED to ON_QA
  • Assignee set to Andrea Marchionni
  • % Done changed from 60 to 70
Package in nethserver-testing:
  • nethserver-unixODBC-0.0.6-2.0git4ef262a1.ns6.noarch.rpm
  • freetds-0.91-2.el6.x86_64.rpm

Test case:
install/update nethserver-unixODBC and configure it with those commands using correct DB_NAME, DB_PORT, DB_IP, DB_USERNAME and DB_PASSWORD

 # yum --enablerepo=nethserver-testing install nethserver-unixodbc
 # config set odbc-mssql-test odbc Database DB_NAME Description "MSSQL test entry" Driver MSSQL Port DB_PORT Server DB_IP
 # signal-event nethserver-unixODBC-update
 # isql odbc-mssql-test DB_USERNAME DB_PASSWORD
SQL>  select TABLE_NAME from INFORMATION_SCHEMA.TABLES

#7 Updated by Andrea Marchionni almost 5 years ago

  • Status changed from ON_QA to VERIFIED
  • Assignee deleted (Andrea Marchionni)
  • % Done changed from 70 to 90

#8 Updated by Giacomo Sanchietti almost 5 years ago

  • Assignee set to Giacomo Sanchietti

#9 Updated by Giacomo Sanchietti almost 5 years ago

  • Status changed from VERIFIED to CLOSED
  • Assignee deleted (Giacomo Sanchietti)
  • % Done changed from 90 to 100
Released in nethserver-updates:
  • nethserver-unixODBC-0.0.7-1.ns6.noarch.rpm

Also available in: Atom PDF