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

[BrunoDrean]

Hi! I had the same issue.

Initially, I tried with:

• OpenSSL 3.4.0
• OpenSSL 3.3.0
  Both versions failed with the same CMake error about OPENSSL_CRYPTO_LIBRARY.

Then, I saw @JeromeGsq's message about using OpenSSL 3.1.1 with Chocolatey, and it worked! Here's my working configuration:

Environment:

• Windows 10
• Flutter 3.22.3
• CMake 3.28
• OpenSSL 3.1.1 (installed via Chocolatey)
• sqlcipher_flutter_libs: 0.6.4

Steps to make it work:

1. Install OpenSSL 3.1.1 using Chocolatey
2. Update the CMakeLists.txt in flutter/ephemeral/.plugin_symlinks/sqlcipher_flutter_libs/windows/:

set(OPENSSL_ROOT_DIR "C:/Program Files/OpenSSL-Win64")
set(OPENSSL_INCLUDE_DIR "C:/Program Files/OpenSSL-Win64/include")
set(OPENSSL_USE_STATIC_LIBS TRUE)
set(OPENSSL_MSVC_STATIC_RT TRUE)
set(OPENSSL_CRYPTO_LIBRARY "C:/Program Files/OpenSSL-Win64/lib/VC/x64/MT/libcrypto_static.lib")
set(OPENSSL_SSL_LIBRARY "C:/Program Files/OpenSSL-Win64/lib/VC/x64/MT/libssl_static.lib")

find_package(OpenSSL REQUIRED) 

3. Add this to your main windows/CMakeLists.txt to handle the DLL copy:

install(CODE "
  if(EXISTS \"${CMAKE_BINARY_DIR}/runner/$<CONFIG>/sqlite3.dll\")
    file(COPY \"${CMAKE_BINARY_DIR}/runner/$<CONFIG>/sqlite3.dll\"
         DESTINATION \"${CMAKE_INSTALL_PREFIX}\")
    file(RENAME \"${CMAKE_INSTALL_PREFIX}/sqlite3.dll\"
                \"${CMAKE_INSTALL_PREFIX}/sqlcipher.dll\")
    message(STATUS \"Copied sqlite3.dll to sqlcipher.dll\")
  else()
    message(WARNING \"sqlite3.dll not found in ${CMAKE_BINARY_DIR}/runner/$<CONFIG>/\")
  endif()
" COMPONENT Runtime)

I hope this information can help you! 👍

[nmoore-genetec]

@BrunoDrean your steps 1. and 3. were both necessary for me to get sqlcipher_flutter_libs to work in the encryption example of this project. I didn't bother with step 2.

I have a couple questions...

1. What is step 2 meant to do ? It sets a bunch of environment variables, but if it's in the ephemeral folder does that mean these commands are only needed for the build once ? I noticed that if I put changes into an ephemeral CMakeLists.txt, they would actually be cached somewhere, such that a clean (deleting that CMakeLists.txt) and then build brings them back.
2. Why is a sqlite3.dll being renamed to sqlcipher.dll ? My best guess is the sqlite3.dll here contains the sqlcipher extension, but must be named sqlite3 for an initial build step ?
3. @simolus3 Can all or part of @BrunoDrean 's wok be integrated to the sqlcipher_flutter_libs such that (asides from open-ssl) it works out-of-the-box ?