sqlcipher_flutter_libs windows build issue

[jason-outlier]

thanks for the great plugin!

while i am using drift for my flutter application on windows,
i have tried to integrate sqlcipher_libs for the password bit to my db.sql

while trying to add encryption to the file
whenever i build windows i get

CMake Error at C:/Program Files (x86)/Microsoft Visual Studio/2022/BuildTools/Common7/IDE/CommonExtensions/Microsoft/CMake/CMake/share/cmake-3.28/Modules/FindPackageHandleStandardArgs.cmake:230 (message):       
  Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the
  system variable OPENSSL_ROOT_DIR (missing: OPENSSL_CRYPTO_LIBRARY) (found
  version "3.4.0")
Call Stack (most recent call first):
  C:/Program Files (x86)/Microsoft Visual Studio/2022/BuildTools/Common7/IDE/CommonExtensions/Microsoft/CMake/CMake/share/cmake-3.28/Modules/FindPackageHandleStandardArgs.cmake:600 (_FPHSA_FAILURE_MESSAGE)      
  C:/Program Files (x86)/Microsoft Visual Studio/2022/BuildTools/Common7/IDE/CommonExtensions/Microsoft/CMake/CMake/share/cmake-3.28/Modules/FindOpenSSL.cmake:668 (find_package_handle_standard_args)
  flutter/ephemeral/.plugin_symlinks/sqlcipher_flutter_libs/windows/CMakeLists.txt:32 (find_package)

all the system variables are looking right and i have tried to manually set the variables on the CMakeList as well
even the example code in the drift repo has returned the same error i get above
any suggestions on where i can debug this issue?

cmake version : 3.31.3
openssl : 3.4.0 (tried 1.1.1, 3.0, 3.0.15)
sqlcipher_flutter_libs : 0.6.4 (tried 0.6.0 to 0.6.4)

thanks for reading

[JeromeGsq]

Same issue here. I use choco to install openssl on windows.

@jason-outlier you should try to install this: choco install openssl --version 3.1.1 -y