amoeba opened a new issue, #49686:
URL: https://github.com/apache/arrow/issues/49686

   As discussed in https://github.com/apache/arrow/issues/49404 and 
https://github.com/apache/arrow/pull/49603, we need a script to pair with the 
release CI jobs in https://github.com/apache/arrow/pull/49603 to handle signing 
release artifacts on the release manager's machine. My understanding is that we 
need this manual/local step because the builds of the FlightSQL ODBC driver DLL 
and MSI aren't yet reproducible.
   
   Create a new release script, called something like 
`07-flightsqlodbc-upload.sh` with content like,
   
   ```sh
   # download unsigned DLL
   gh release download $tag --pattern arrow_flight_sql_odbc_unsigned.dll
   
   # sign ODBC DLL and upload to GitHub release
   jsign arrow_flight_sql_odbc_unsigned.dll ...
   mv arrow_flight_sql_odbc_unsigned.dll arrow_flight_sql_odbc.dll
   gh release upload $tag --clobber arrow_flight_sql_odbc.dll
   
   # trigger CI B
   gh workflow run cpp_extra.yml --ref $tag -f odbc_upload=msi
   
   # download unsigned MSI
   gh release download $tag --pattern Apache-Arrow-Flight-SQL-ODBC-*-win64.msi
   
   # sign ODBC MSI and upload to GitHub release
   jsign Apache-Arrow-Flight-SQL-ODBC-*-win64.msi ...
   gh release upload $tag --clobber Apache-Arrow-Flight-SQL-ODBC-*-win64.msi
   
   # remove ODBC DLLs from GitHub release
   gh release delete-asset $tag arrow_flight_sql_odbc_unsigned.dll --yes
   gh release delete-asset $tag arrow_flight_sql_odbc.dll --yes
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to