Android Question Problem Using SQLCipher

[jotajota52]

Hi!
I'm trying to open an sqlite database that has been encrypted using SQLCipher 4, and I can open it using the correct passphrase using DB Browser (SQLCipher version)
But in B4A is not working
This is an example of what I'm doing, using SQLCipher library version 1.60

Sub Process_Globals
Private sql As SQLCipher
End Sub

Later on, having chosen de database file:

sql.Initialize(File.DirInternal,mydatabase,False,"12345","")

and this errors out as:

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

Is there any way to config the SQLCipher lib to open it using SQLCipher 4 defaults?

George.

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

B4A SQLCipher v1.60 is based on SQLCipher v4.00. Try to to the opposite and see if it works. Create a new database in your app and copy it to the desktop.

 

[jotajota52]

Thank you Erel,
While doing more testing I found out that using an alphanumeric password, such as "Abc1234" is the problem here
If the database has a numeric password (all numbers) the B4A SQLCipher v1.60 works just fine.

This works:
(mydatabase1 has been encrypted with a numeric password. I can open it in my desktop)

Dim passw As String ="1234567"
 sql.Initialize(File.DirInternal,mydatabase1,False,passw,"")

This throws an error:
(mydatabase2 has been encrypted with a alphanumeric password. Again, I can open it in my desktop.)

Dim passw As String ="Abc1234567"
 sql.Initialize(File.DirInternal,mydatabase2,False,passw,"")

What would be the correct way to pass it an alphanumeric password to the sql.initialize ??
George.

 

[Erel]

The B4A wrapper just passes the string value to the underlying engine.

My guess, is that your desktop tool doesn't use the default encryption settings.
There are all kinds of settings that can be configured using PRAGMA commands: https://www.zetetic.net/sqlcipher/sqlcipher-api/#Key_Options

 

[Alex_197]

Thank you Erel,
While doing more testing I found out that using an alphanumeric password, such as "Abc1234" is the problem here
If the database has a numeric password (all numbers) the B4A SQLCipher v1.60 works just fine.

This works:
(mydatabase1 has been encrypted with a numeric password. I can open it in my desktop)

Dim passw As String ="1234567"
sql.Initialize(File.DirInternal,mydatabase1,False,passw,"")

This throws an error:
(mydatabase2 has been encrypted with a alphanumeric password. Again, I can open it in my desktop.)

Dim passw As String ="Abc1234567"
sql.Initialize(File.DirInternal,mydatabase2,False,passw,"")

What would be the correct way to pass it an alphanumeric password to the sql.initialize ??
George.

I am using B4A SQLCipher with a password Abc_1234 and it works fine.
What you can do is create a new DB with an alphanumeric password and check if it works for you.

 

[Apip Bayok]

Use SQLCipher with V1.60 lib, dependsOn android-database-sqlcipher-4.1.2.aar and it's works fine with alphanumeric password.

Sub Process_Globals
    Dim SQLC As SQLCipher
    Private RP As RuntimePermissions
    Private SafeDirectory As String
End Sub

Sub OpenDBF
    SafeDirectory = RP.GetSafeDirDefaultExternal("")
    SQLC.Initialize(SafeDirectory, "gg.db", True, "jogang8310", "")
End Sub

in XML file

<dependsOn>android-database-sqlcipher-4.1.2.aar</dependsOn>

 

[jotajota52]

Thank you again Erel and Alex. I think the problem then might be my desktop app when I cipher
I use my connection object to establish the defaults and the key

sCnn.CodecType = CODEC_TYPE_SQLCIPHER
sCnn.Execute "PRAGMA legacy=4;"
sCnn.Execute "PRAGMA key='" & "Abc1234" & "';"

Note that the key is a string and I pass it with single quotes to make sure it goes as string.
I can then use any app (such as DB Browser for SQLite) to open the database with that passphrase
I'll be doing some more testing.