596 questions
0
votes
1
answer
112
views
Connect to SQLCipher encrypted SQLite database with Rider's built-in plugin
I'm trying to connect to my database through Rider but it doesn't work since I encrypted my database with SQLCipher. Tutorials say I should add these fields in the "Advanced" tab but that ...
1
vote
1
answer
98
views
sqlcipher_page_cipher aftre sqlite3_key()... with includet sqlite3 sqlcipher
I integrated sqlite to my project with help library #include <sqlite3.h>... Open and Connect work correct... next example my code:
#include <sqlite3.h>
int callback(void *notUsed, int ...
- 33
0
votes
0
answers
93
views
Open DB browser For SQLCipher by command line
We use SQLite and, more recently, the encrypted version with SQLCipher.
It works well with our software, but I'm having a small problem using DB Browser for SQLCipher. This software works well, but it ...
- 1
0
votes
1
answer
109
views
Entity Framework Core and SQLite: 'attempt to write a readonly database'
I am migrating a Xamarin app to MAUI and I had issue with the database.
I have two database plaintext and encrypted, if add password to my app plaintext transform to encrypted and if I remove password ...
- 31
0
votes
0
answers
22
views
TypeORM SQLCipher support in react-native apps
I was wondering if anyone knew whether TypeORM supports sqlcipher in react-native apps?
I've seen in TypeORM's changelog that such support exists but could not find any documentation backing that.
0
votes
0
answers
125
views
android.database.sqlite.SQLiteException: file is not a database: , while compiling: select count(*) from sqlite_master;
I am working with SQLCipher to encrypt my database in my Android app, but I am facing an issue where I cannot open the database using the correct passphrase. When I attempt to query the database, I ...
0
votes
1
answer
130
views
Two identical SQLiteExceprion in one line
I have two identical errors in one line using SQLCipher.
I am checking the password for correctness. If the parameter is entered incorrectly, two exceptions occur.
I looked at this page to see if the ...
- 11
1
vote
1
answer
785
views
I have a problem with sqlcipher.bundle (Multiple commands produce) in my flutter iOS app
So I have a flutter app and when I debug it on my iPhone it works perfectly but when I try to build an ipa file it shows me this error:
Which indicates that there are multiple commands which are ...
1
vote
0
answers
239
views
Crash while migrating from net.zetetic:android-database-sqlcipher:3.5.9 to 4.5.4
I am migrating from net.zetetic:android-database-sqlcipher:3.5.9 to 4.5.4 on my Android project.
Here is the given code before update:-
public class DatabaseHelper extends SQLiteOpenHelper {
...
1
vote
1
answer
66
views
SQLCipher C++ API version
I need SQLCipher version 4.x for my C++ project. I do have SQLCipher 4.6.0 Community in my Ubuntu, but it shows 3.4.1 in my C++ program. I have tried to compile and use SQLCipher 4.6.0 and 4.6.1 for ...
- 11
0
votes
1
answer
129
views
Using singleton DbContext causes connection issues in multithreaded environment
I am using SQLCipher for sqlite DB encryption in WPF application. As per knowledge they recommend to use Singleton pattern for my DbContext class ensure a single instance is used throughout my ...
- 49
0
votes
0
answers
282
views
SQLCipher "file is not a database" Error After Updating iOS App
I'm encountering an issue with SQLCipher in my iOS app after updating to a new version, which involves different workspaces of my app. The app uses SQLCipher(version: 3.1) to manage an encrypted ...
- 331
0
votes
0
answers
50
views
how can i connect to the sqlcipher file like 'D:/db.db3' in java，not android
I have a sqlcipher file locally, which is encrypted. How can I connect to it and dosomthing using java code? like execute sql,I tried a lot, but all failed.
I try this， but failed
<dependency>
...
0
votes
0
answers
214
views
Compiling and linking SQLCipher (SQLite) properly with ICU extension enabled
I'm trying to build SQLCipher from source and link it to another project as a static library.
The configuration I use (mostly according to this topic). I obtain all necessary flags by executing "...
- 66
0
votes
0
answers
360
views
Unable to Open SQLCipher-Encrypted SQLite Database in DB Browser for SQLite
I'm working on a C# application that encrypts an SQLite database using SQLCipher. I'm able to encrypt the database and access it in my application using the correct password. However, when I try to ...
- 1
0
votes
0
answers
102
views
Facing problem in implementation of SQLCipher
This are my project files
AndroidManifest.xml
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
...
0
votes
1
answer
295
views
iOS Project with SQLCipher and SQLite Dependency
How can an iOS project be configured so that it can use the SQLCipher pod and also install 3rd party pods (like the Adobe Mobile SDKs) which use SQLite3?
SQLCipher has a disclaimer that usage with ...
- 835
1
vote
0
answers
119
views
Unable to find dialect at @journeyapps/sqlcipher
I’m trying to connect to already encypted local Sqlite3 DB with @journeyapps/sqlcipher in an Electron App. i used db browser to encrypt the db with password. i got following error when try to connect ...
- 21
0
votes
0
answers
376
views
Could not create DB Connection due to SQL-Cipher issue when migrating from Xamarin to .net Maui
I can create a DB Connection in Xamarin using the following code:
var options = new SQLiteConnectionString(dbPath, true, dbPassword, postKeyAction: c =>
{
c.Execute("PRAGMA ...
- 421
4
votes
2
answers
1k
views
How do you safely pass values to SQLite PRAGMA statements in Python?
I'm currently writing an application in Python that stores its data in a SQLite database. I want the database file to be stored encrypted on disk, and I found the most common solution for doing this ...
- 409
0
votes
1
answer
321
views
in swift how to access to database to GRDB.swft/SQLCipher on signal app fork?
I'm currently working on a fork from signal messaging app, here the original 5.22 version my app is coming from. please take a look at the repo. I'm not the original developer of this fork, and have ...
- 1,971
0
votes
1
answer
366
views
I have fail error: ‘sqlite3_key’ was not declared in this scope
I have a simple code:
#include <sqlite3.h>
#include <sqlite.h.in>
#include <cstring>
int main() {
sqlite3 *db = nullptr;
const char *dbName = "en.db";
const ...
- 99
3
votes
0
answers
389
views
Android SQLite "no such table: room_table_modification_log" after restore
I am trying to implement SQLite database based on SQLCipher (https://github.com/sqlcipher/android-database-sqlcipher) but after I restore the database and try to perform any actions on it I get the ...
- 1,089
-1
votes
1
answer
92
views
How to detect open/close connection change in SQLite Android?
is there a way to detect when SQLite connection closes? I am trying to integrate SQLCipher and this is the initialization method:
fun initialize(passphrase: String): Boolean {
this.passphrase = ...
- 1,089
0
votes
0
answers
80
views
How do I apply SQLCipher to my Login database?
I am creating a Login application that can be reused for any other application with a little tweaking to the UI and features. The user inputs their username and password into the text boxes, and ...
3
votes
0
answers
96
views
Load ICU Extension on Android sqlite to resolve LIKE lowercase issue
I have an Android app that is also used by Greek users, but I'm having an issue with some queries I'm making.
Essentially, the "like" functionality only works if I write Greek letters in ...
- 1,084
0
votes
0
answers
415
views
How to use SQLcipher on c#
I realised a program in order to save login and password in Winform c#.
I used sqlite to save the data but with DB Browser for SQLite I can view all my data :\
I read with sqlcipher I can set a ...
- 1
2
votes
2
answers
2k
views
Android Studio SQLCipher: Error resolving method 'loadLibs' in 'SQLiteDatabase'(SQLiteDatabase.loadLibs();)
Error resolving method 'loadLibs' in 'SQLiteDatabase'(SQLiteDatabase.loadLibs();)
I am trying to use SQLCipher for android studio, although I have added library to dependencies I get this error.
(...
1
vote
1
answer
334
views
Integrating SQLCipher latest version v4.5.4 with android kotlin project
I could find a lot of integration samples for old versions of SQLCipher with android and it also works. But I need to integrate latest version of SQLCipher like v4.5.4 because it mentioned that that ...
0
votes
0
answers
500
views
Need to exclude TLSv1.0 and TLSv1.1 ssl ciphers postgresql.conf
Currently my ssl_ciphers string looks like this:
ssl_ciphers='ALL:!ADH:!LOW:!EXP:!MD5:!aNULL:!eNULL:!NULL:!3DES:!RC4:!SSLV2:@STRENGTH'
I want to exclude TLSv1.0 and TLSv1.1 ciphers along with ...
- 11
0
votes
0
answers
128
views
RSA decryption suddenly went wrong, which was normal before
Before using this code for rsa decryption, running on the server everything is fine, but suddenly an error, and stopped running.
Security.addProvider(new org.bouncycastle.jce.provider....
- 53
0
votes
0
answers
734
views
Entity Framework Core with SQLite SQLCipher and thread-safe
I want to use
SQLite with SQLCipher
Entity Framework Core 3.1
Multiple Threads that call the Db (thread-safe)
The EF DbContext is not thread-safe natively.
My approach was using a new DbContext for ...
- 73
0
votes
1
answer
1k
views
Opening Sqlite DB encrypted using SQLite Encryption Extension with DB Browser with SqlCipher
I have a database I encrypted using SQLite Encryption Extension being used with MobileServiceSQLiteStore.
Is there anyway to use DB Browser with SqlCipher to view the database. I have the key that was ...
- 143
0
votes
1
answer
156
views
Take long time for first access Cipher Room Database
I Cipher Room database with code bellow.
final byte[] passphrase = SQLiteDatabase.getBytes(DatabaseHelper.KEY.toCharArray());
final SupportFactory factory = new SupportFactory(passphrase);
mInstance = ...
- 11
0
votes
0
answers
189
views
Cordova electron and SQLCipher integration
I am trying to run my Cordova React app on Mac using cordova-electron Cordova Electron and journeyapps/node-sqlcipher.
I am using these versions:
"cordova-electron": "^3.1.0",
&...
- 97
1
vote
0
answers
845
views
SQLCipher cocoapods multiple redefinition errors
While integrating SQLCipher with cocoapods I’m getting multiple redefinition errors.
Version: 4.5.2
<module-includes>:2:9: note: in file included from <module-includes>:2:
#import "...
- 2,922
0
votes
1
answer
2k
views
Transform SQLite database to SQLCipher database
My Python program uses the standard Python SQLite database (import sqlite3). All works, I want to cypher the database. I opened it with DB Browser (sqlitebrowser.org) that uses SQLCipher 3/4 and I ...
- 53
0
votes
1
answer
203
views
Can't decrypt DB with SQLCipher but works with SQLBrowser
I'm able to open a DB using custom parameters set to HMAC = SHA1, KDF = SHA1 and providing the raw key in SQL browser but when using this commands in the SQLCipher CLI I can't decrypt the database.
...
- 69
1
vote
1
answer
271
views
Python sqlcipher3 INSERTS don't persist [duplicate]
I'm exploring sqlcipher3 with python, and I find that after inserting some rows, then closing and re-opening the database, my table is empty. This problem doesn't appear when I use the sqlcipher ...
- 30.6k
0
votes
0
answers
254
views
translating SQLcipher GUI to CLI (or pyhton)
The question is simple
How can i turn this
SQLciper GUI
Into lines of code either in SQLciper CLI or using a python module ?
Here's what i've tried (FAILED ATTEMPTS)
attempt on python using a module
c....
- 23
2
votes
1
answer
9k
views
How to use Command Line to access an encrypted SQLite db file instead of DB Browser interface
Currently I can use DB Browser for SQLite to open an encrypted DB file with password on Mac.
The options as per image:
Raw key (start with 0x...)
SQLCipher 3 defaults
I would like to open this file ...
- 311
0
votes
1
answer
234
views
Microsoft.Data.Sqlite issue with apostrophe characters in password
I'm using EF Core 6 with the MS SQLite driver and the SQLitePCLRaw.bundle_e_sqlcipher so the database is being encrypted by SqlCipher. if I pass a apostrophe character in the password then the ...
- 407
1
vote
1
answer
1k
views
Setting up sqlcipher in an electron app using electron-forge and webpack
I am trying to open a sqlite3 database encrypted with sqlcipher. I have the password and I could open it successfully using sqlitebrowser.
I started my project using this template. It is based on the ...
- 204
1
vote
0
answers
844
views
How to get sqlite database path from sql.DB instance
I want to get the path or even the connection string of a sql.DB instance. The package I'm writing doesn't know what the database path is and the application may have multiple database files. However ...
- 2,741
1
vote
1
answer
3k
views
SQL - SQLiteDatabaseCorruptException - file is not a database while compiling: PRAGMA journal_mode
I have been working on migrating our DB on a Kotlin Multiplatform project to be encrypted from unencrypted. It's all done on Android, however the iOS part is proving tricky.
Finally I got it somewhat ...
- 5,189
0
votes
1
answer
308
views
How to build a .a file correctly (KMM)
We need to include SQLCipher in our KMM project without using Cocoapods. This involves building a libSQLCipher.a.
I was able to this in terminal with these commands:
./configure --enable-tempstore=yes ...
- 5,189
0
votes
1
answer
1k
views
How to check if data in room database is encrypted?
I'm building an app that uses room database and I use SQLCipher to encrypt it. How can I check if the data is really encrypted because it's my first time to use encryption and I don't know if I did it ...
- 81
3
votes
1
answer
1k
views
How to store hardcoded encryption master key in android?
I'm building an app that uses Room and I want to encrypt the db using SQLCipher which needs a master key to encrypt/decrypt the db. I don't want to get the master key from the user, I want to use 1 ...
- 31
0
votes
1
answer
412
views
How to use cordova-sqlcipher-adapter with ionic 3?
I have used the SQLite plugin listed on ionic 3 packages here. But now I want to store the data in an encrypted format. For that , I am trying to implement cordova-sqlcipher-adapter plugin but I am ...
- 427
0
votes
0
answers
802
views
SQLCipher with custom options
I’m using sqlcipher to encrypt sqlite db using custom parameters such as,
PRAGMA cipher_page_size = 1024;
PRAGMA kdf_iter = 16000;
PRAGMA cipher_hmac_algorithm = HMAC_SHA512;
PRAGMA ...
- 11