search

TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
542 stars 115 forks source link

Add bcp -u option for SQL Server to trust the server certificate #653

Closed sm-shaw closed 6 months ago

sm-shaw commented 6 months ago

Adds -u option to bcp based builds when running on Linux with ODBC driver 18 and trust server certificate is checked to avoid certificate verify failed:self signed certificate error. Tests on Windows showed bcp used ODBC 17 so change has not been added to Windows but may need to be in future.

Noting that the long-term solution is to extend the ODBC interface that HammerDB uses to include bcp based commands https://github.com/TPC-Council/HammerDB/issues/594 as issues such as this are a direct result of calling the external tools i.e. we have already logged in and trusted the server certificate, however using the bcp executable means we need to do this again.

abondvt89 commented 6 months ago

Merging after reviews and approval of the three members of the code maintenance team.