Questions tagged [sqlcipher]

SQLCipher is an open source extension to SQLite that provides transparent 256-bit AES encryption of database files.

-1
votes
0answers
16 views

Implementing sqlcipher encryption on my dictionary android app

I have an android app , loading of data from normal sqlite db is working fine but when i load data from my already created sqlcipher db is not working. I have looked up some articles and video ...
0
votes
0answers
12 views

Ingest data from encrypted sqlite (sqlcipher) with logstash

I want to ingest data from a sqlite file that is encrypted with sqlcipher. but there is not any option in default jdbc driver for my purpose. I found this fork of driver but it's not working either: ...
0
votes
1answer
32 views

Using sqlcipher with sqlite3 in Electron-Builder applicatiomn

Background I am trying to encrypt my sqlite database using sqlite3 and sqlcipher in an Electron application. On the sqlite3 npm page here It says to install the build like this, yarn add ...
1
vote
1answer
73 views

How to encrypt SQLite DB in an electron app?

I have an electron app which persists data in an SQLite db stored in my machine. I have all the setup for the CRUD operation and the application works fine. Now I need to encrypt the SQLite DB file. I ...
0
votes
0answers
62 views

Decrypt / Password SQLite for Query

I need to unlock a password protected SQLite file add data, then email the Password Protected file, all my Queries & email work fine until I password protect the file using DB Browser (SQLCipher), ...
2
votes
0answers
30 views

Android custom migration Sqlcipher from 3 to 4

I upgraded Sqlcipher for Android from 3.5.7 to 4.1.3 in my app. For the existing database, which has been created with Sqlcipher 3, I need a custom migration as it is based on custom parameters, as ...
0
votes
0answers
56 views

Installing libsqlcipher for Windows (requirement of pysqlcipher3)

pysqlcipher3 states that "libsqlcipher must already be installed on your system". My question is: What is that, and more importantly from where can I install it and how can I install it? Can someone ...
0
votes
0answers
113 views

Issue in installing pysqlcipher3

So even though pip install pysqlcipher3 worked returned Successfully installed pysqlcipher3, it did not. From my research, it seems that its a common issue for Windows user trying to install ...
0
votes
0answers
44 views

“Use of unresolved identifier 'sqlite3_key'”

I've been working in a module that i want to distribute as a Pod, this module depends on an external library 'SQLCipher'. In the module i have defined the podspec with the corresponding dependency, of ...
0
votes
1answer
20 views

Error: No such function: sqlcipher_export on iOS

I have installed SQLCipher via pod. but I am getting this error saying No such function: sqlcipher_export. I was using FMDB and for SQLCipher I am using the subspec of it i.e. FMDB/sqlcipher. I have ...
1
vote
0answers
43 views

GreenDAO cannot access existed database after upgrading sqlcipher from 3.5.2 to 4.0.1

I'm using GreenDAO with SQLCipher. After I upgrade SQLCipher from 3.5.2 to 4.0.1, my app cannot access the old encrypted database. I have already searched for a solution and found out that I need to ...
2
votes
1answer
87 views

Deadlock when closing sqlite database

I'm investigating occassinal ANR in my project. It happens when there are a lot of requests to database in the background, user clicks button and database is being closed as a part of logout. I'm ...
1
vote
0answers
48 views

I use sqlcipher, after updating the app its throwing the error “File is not a database”

The only thing that changed before and after updation is header file I changed from "#import sqlite3.h " to "#import SqlCipher/sqlite3.h"and it stopped recognising the older database after the ...
0
votes
0answers
17 views

how to pass pKey in sqlite3_key?

I have encrypted database using "ATTACH DATABASE" and hex key. But while decrypting using same hex-key I am getting error "file is encrypted or is not a database". is anything wrong while passing the ...
2
votes
1answer
152 views

How to Sqlite database with password access from Qt?

i made a password sqlite database file via sqlitestudio SQLSicpher, how can i access the data base from qt?, I tried QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE"); db.setDatabaseName(...
0
votes
1answer
140 views

SQLCipher and CWAC-SafeRoom doubling the size of my APK

The size of these libraries really increase the APK size. It’s almost 50% my App size, taking it to 16.3 MBs and when I analyze the APK, sqlcipher-lib alone is 48.9% of my apk size i.e 7.3MBs!!! Is ...
0
votes
0answers
51 views

How to use django with a sqlcipher encrypted sqlite database

I am trying to integrate my sqlite database, encrypted with sqlcipher, to my database and have found very little support for this online. I have set my engine to 'django.db.backends.sqlcipher.backend'...
1
vote
0answers
43 views

SQLCipher in Ionic 3

Is there any proper guideline to use SQLCipher in Ionic 3 application? I am following this method, but having little confusion on where to initialise the db object. Because the Cordova plugin getting ...
0
votes
1answer
93 views

Ruby on Rails and SQLite encrypted database

I am using Rails 5.2.2 and SQLCipher Version 3.2.0 (based on SQLite 3.8.6). I have encrypted the SQLite database using sqlcipher but I am not able to load the rails application. The message is get is ...
0
votes
0answers
58 views

Cocoapods FMDB/SQLCipher 2.7.5 can not decrypt

I've added FMDB/SQLCipher (2.7.5) to my app by cocoapods. use_frameworks! pod 'FMDB/SQLCipher' And perform the code bellow: - (void)decryptDBAtPath:(NSString *)path withKey:(NSString *)key { ...
1
vote
0answers
99 views

Error inflating class org.xwalk.core.XWalkView after changing sqlcipher version

The android app I am working on is a Cordova one. I am getting the following error when I start the app. https://pastebin.com/jzX9AqEX Here is my MainActivity public class MainActivity extends ...
0
votes
1answer
304 views

Does PRAGMA Key='SomeKey' in SQlite encrypt/decrypt whole data of database?

We are developing Xamarin.forms application and we have to encrypt our database. While googling I found something is 'PRAGMA key'. When I started using this in my code then on opening the db file via ...
0
votes
0answers
33 views

Sqlcipher Failed allocating 1638057 bytes for text/blob at 0,0

So, I have a Cordova app which uses sqlcipher to talk to the database. There is a particular insert statement where I have to insert a lot of data into the Db. So the insert fails giving me the ...
0
votes
1answer
31 views

What are the requirements for SQLCipher passphrase?

Are there any requirements for SQLCipher passphrase? For example, minimum and maximum number of symbols, invalid symbols, etc.
1
vote
1answer
240 views

SQLCipher with Room Persistence Library exception in SQLCipherUtils.getDatabaseState

I have a Room database in my Android app, and in my AppClass, I have some logic that checks the database encryption state in order to handle some potential encryption operations that might need to be ...
0
votes
1answer
48 views

Complete SQLite newbie - how to install SQLCipher for UWP app

I am working on a UWP app where we need to use SQLCipher but I have no idea how to install it and cannot find a single up to date guide or reference anywhere, inlcuding on Zetetec's site or at the ...
0
votes
1answer
24 views

How to improve sqlicifer performance?

I have a very small encrypted sqlite test database. I run a very simple select: just one record from the table which contains one record. This request takes very significant time: 0.3 sec. [email protected]
0
votes
1answer
55 views

python, sqlite, sqlcipher: very poor performance processing first request

My python service uses sqlite database encrypted with sqlcipher lib. There is a performance problem when processing very first request. Database is very small and simple, requests are trivial. But ...
0
votes
1answer
90 views

How do I use sqlite3_key()?

I built sqlcipher with mingw. I wanted to access sqlite(DB) encrypted in mfc(C++). So, sqlite3_open () was applied correctly. but, sqlite3_open() did not return a result, so I wanted to use ...
0
votes
1answer
69 views

How do I build sqlcipher.. mingw

I'm korean. I'm using a translator. So, even if the grammar is awkward, please understand. I built sqlcipher by referring to "http://www.jerryrw.com", I created an exe file.but while building, There ...
0
votes
0answers
35 views

What is REGEXP alternative ? when using SQLCipher database?

My Android dictionary project use Arabic language for doing search view between search list. run project was successful with using regex. but using of SQLCipher for encrypt caused error. when typed ...
0
votes
1answer
27 views

NativeScript: SQLCipher isn't accepting a PBKDF2 derived key as a valid string

I'm using SQLCipher on my NativeScript project and my I'm pretty sure I'm passing an encryption key in the correct format but I always get this message: JS: Invalid key type, key must be a string.\...
0
votes
2answers
201 views

Unable to open manually-encrypted SQLite database with QtCipherSqlitePlugin and vice versa

I have manually created a SQLite database (named "localDB.db") and protected it with a password, by using DB browser. If I am not mistaken, DB browser uses SQLCipher (with a default page size of 1024),...
0
votes
1answer
777 views

How to use SQLCipher in .Net

I want to use C# (winform) to read an SQLCipher database and find an open source project SQLitePCL, but I have not found examples of this use, and the documentation is not a lot. Have any friends used ...
0
votes
0answers
41 views

Getting an error, database disk image is malfored, for sqlite

I have a database that is encrypted with sqlcipher. I decrypted it with PRAGMA key = blahblahblah;. I did PRAGMA integrity_check; and I got the following error. Page 1 is never used Page 4 is never ...
0
votes
1answer
50 views

sqlcipheron MacOS HighSierra build error

I build sqlcipher from github repository on MacOS : 9429:sqlcipher administrator$ ./configure --enable-tempstore=yes CFLAGS="-DSQLITE_HAS_CODEC -DSQLITE_ENABLE_UNLOCK_NOTIFY" checking build system ...
0
votes
0answers
101 views

How can I encrypt an unencrypted Microsoft.Data.Sqlite db

I’m using Microsoft.Data.Sqlite, EntityFrameworkCore and SQLCipher in my WPF application. Database migration, encryption and changing password of encrypted database works fine. But I couldn’t find a ...
3
votes
0answers
90 views

Custom Migration - Encrypted Core Data - iOS

Does EncryptedCoreData support changing the Entity Attribute Type and thus can it successfully do custom migrations in iOS? I have installed pod EncryptedCoreData for a swift iOS project and I am ...
1
vote
2answers
325 views

Cannot resolve symbol 'database' in net.sqlcipher import in Android Studio

Any idea why I am having this cannot resolve symbol 'database' in net.sqlcipher. I simply cloned SQLCipher Android Test from GitHub and wanted to test. have also attached the screenshot for ...
1
vote
2answers
749 views

net.sqlcipher.database.SQLiteException: file is not a database: , while compiling: select count(*) from sqlite_master

Error this line : mDataBase = SQLiteDatabase.openDatabase(dbPath, "123", null, SQLiteDatabase.NO_LOCALIZED_COLLATORS); When open the database . but whats Wrong? how to open database with password? ...
0
votes
0answers
158 views

How to implement Sql Cipher in SQLite Database in android

I first create a database on sqlite db browser then set password on DB Browser > File > Set encryption. Now How to decryption on Android part. that show an error when i write this code. i got an Error ...
0
votes
0answers
47 views

SQLITE_OPEN_FILEPROTECTION_COMPLETE is only available in iOS platform?

I'm trying to integrate sqlcipher to encrypt the sqlite3 database in iOS project. But I found the sqlite3.h in iOS library is different with the official sqlite3.h. The sqlcipher is developed depends ...
0
votes
1answer
619 views

Use encrypted database in react-native

I need to create an encrypted database using SQL-cipher in react-native. To do that I found a react-native-sqlite-storage fork modified by Dryganet but there is no documentation to use it. I've ...
3
votes
2answers
967 views

How to encrypt the SQLite database in Flutter?

I am creating a database in Flutter by the following code, is there any way we can encrypt the database? Is there any library available for Flutter? initDb() async { io.Directory ...
4
votes
0answers
109 views

Sqlite Database suddenly closed on devices using MDM in Native Android app

Our android application is used by thousands of user and has been live for the past four years. The app stores hundreds of thousands of rows where on a daily basis thousands are inserted, updated and ...
1
vote
0answers
197 views

Ionic 3 Android apk size with --prod

I was trying to analyse the reasons why the apk generated by my Ionic project for Android was very large (~18.6 MB). Details of the package versions used follow: cli packages: (/usr/local/lib/...
0
votes
1answer
366 views

Storing a DB password in android keystore/ios keychain - xamarin

I am trying to store an encrypted sqlcipher database password in the keystore/keychain. I found this link - http://www.howtobuildsoftware.com/index.php/how-do/ZPR/c-android-xamarin-monodroid-...
0
votes
1answer
274 views

Using secret key with sqlcipher

I'm using sqlcipher to store data from my app and I'm having trouble firstly, generating a secret key and secondly storing in keystore. Btw, needs to be without user interaction like described in ...
0
votes
2answers
72 views

Return data from sqlcipher database on android and put in textview

Working from sqlcipher getting started page, I can't display data from the database and view in a textview. I have initialised the db and queried the db in the click event, but it's crashing during ...
0
votes
1answer
73 views

How to load data from SQLCipher Database in ListView Android

I am having some trouble displaying a table, from an SQLCipher database, into a ListView. My program, right now, only lets users add "secrets" to a database. I was able to view the data when my ...