Feature #3003
add MSSQL support in nethserver-unixODBC
Status: | CLOSED | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due 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
added MSSQL support. Refs #3003
Merge remote, fix missing push. Refs #3003
Conflicts:
nethserver-unixODBC.spec.in
History
#1 Updated by Stefano Fancello over 6 years ago
- Status changed from NEW to TRIAGED
- % Done changed from 0 to 20
#2 Updated by Stefano Fancello over 6 years ago
- Status changed from TRIAGED to ON_DEV
- % Done changed from 20 to 30
#3 Updated by Stefano Fancello over 6 years ago
- Status changed from ON_DEV to TRIAGED
- % Done changed from 30 to 20
FreeTDS comes from epel
#4 Updated by Giacomo Sanchietti over 6 years ago
- Assignee deleted (
Stefano Fancello)
#5 Updated by Stefano Fancello over 6 years ago
- Status changed from TRIAGED to MODIFIED
- % Done changed from 20 to 60
commit d8f8e0766792663c56bcddb96d2c28e46f9c0444
#6 Updated by Stefano Fancello over 6 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 over 6 years ago
- Status changed from ON_QA to VERIFIED
- Assignee deleted (
Andrea Marchionni) - % Done changed from 70 to 90
#8 Updated by Giacomo Sanchietti over 6 years ago
- Assignee set to Giacomo Sanchietti
#9 Updated by Giacomo Sanchietti over 6 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