Using CocoaPods, SQLCipher 4.0, Swift 4. Database created and encrypted(with SQLCipher 4) by DB Browser for SQLite. SQLCipher 4 works well with database without encryption, but it fails to open an encrypted database. It shows error message: Error setting key: not an error, Error retrieiving cipher_…

@jdleung [image] jdleung: pod ‘Google-Mobile-Ads-SDK’ This is the culprit. If you look at their pod spec, they are linking sqlite3. CocoaPods/Specs/blob/master/Specs/5/9/a/Google-Mobile-Ads-SDK/7.43.1/Google-Mobile-Ads-SDK.podspec.json#L26 "MessageUI", …

Hi @jdleung A few questions + suggestions: Are you including any other dependencies/pods that may be including SQLite? Can you verify that you are in fact using SQLCipher by seeing what’s returned from PRAGMA cipher_version; ? Can you provide your Podfile and/or a sample project that reproduces t…

Hi @mmoore There is no other dependencies/pods including SQLite. The cipher_version: “unknown error” on iOS 10, I have not tested on other iOS version Here is the Podfile: platform :ios, ‘10.0’ target 'Enea' do pod 'Charts' pod 'RetroProgress' pod 'Google-Mobile-Ads-SDK' …

Hello, @mmoore It works like a magic after removing Google Ads from CocoaPods. And then I added Google Ads again in Podfile, and inserted -framework SQLCipher in Project > Other Linker Flags, Both SQLCipher and Google Ads work perfect. Thank you so much!

@mmoore awesome solution! I can’t believe this subtle problem has costed hours to locate. My problem was very similar, by using Google library (again) at cocoapod. It secretly induced a sqlite library dependency which cause mislink at runtime. These kind of runtime linking issue is again very subtl…

@micyat Thanks for the recommendation. We’ve added a note below the integration options on the iOS Tutorial page here: https://www.zetetic.net/sqlcipher/ios-tutorial/ with additional details and linking to the article.

Cannot open encrypted database with SQLCipher 4

SQLCipher

mmoore May 13, 2019, 2:16pm 6

@jdleung

Glad it’s working well for you now.

Topic		Replies	Views
No callback after sqlite3_key when using CocoaPods SQLCipher	27	6080	September 27, 2016
Databases not keying properly in iOS 10? SQLCipher	30	8203	October 27, 2016
DB file is encrypted without using SQLCipher SQLCipher	3	854	May 24, 2022
SQLCipher, iOS and Swift SQLCipher	6	3761	June 30, 2016
Sql Cipher database not getting encrypted in iOS and Swift language SQLCipher	5	1319	July 31, 2018

Cannot open encrypted database with SQLCipher 4

Related topics