SQLCipher under Android 4.0.3

[Alexander-Campbell]

Hello,

I am writing an Android APP using SQLite, I looked at using SQLCipher but this crashes, on first DB commands, I have since sorted library loading issues and got the icu46.zip patch, still crashes.

I then downloaded NoteCipher to see if this worked and it did not.

Does this mean the SQLCipher will not work in my Android enviroment ?

I have looked at some other forum questions and some developers are re-building the SQLCipher from source themselves. If you want I can provide traces from logcat but it appears to be a similar issue as reported in issues #34 and #36.

Any suggestions ?

[developernotes]

Hi Alexander-Campbell,

We have had support for Android 2.1 - 4.0.3 since the 1.1 release. Could you share some additional information that will help us debug what issue you are seeing. What Android platform version are you using? What version of the SQLCipher for Android libraries are you using? Could you provide us a stacktrace of the error you are getting? Thanks!

[Alexander-Campbell]

Hello,
This is good news that you support Android, I was almost giving up on this.

Android  version 4.0.3
SQLCipher
    Assest Zip file : icudt46l.zip
    for the libaries I started with 1.1.0, I then got a patch file called icu46.zip from the forums.

Find enclosed three logcat traces
   1 : the call to the load libaries is before the getWritableDatabase call
   2 : in the SQLiteOpenHelper constructor
   3 just after the getWritableDatabase call

there appears to be some issues on loading then a crash on first DB commands.

Any help would be more than welcome, if not do you have a test App, like NoteCipher that works under Android 4.0.3, the one I got from Google play crashes.

Thank you
Alexander

---

De : Nick Parker reply@reply.github.com
À : Alexander-Campbell clan_campbell@yahoo.fr
Envoyé le : Vendredi 20 avril 2012 23h52
Objet : Re: [android-database-sqlcipher] SQLCipher under Android 4.0.3 (#53)

Hi Alexander-Campbell,

We have had support for Android 2.1 - 4.0.3 since the 1.1 release.  Could you share some additional information that will help us debug what issue you are seeing.  What Android platform version are you using?  What version of the SQLCipher for Android libraries are you using?  Could you provide us a stacktrace of the error you are getting?  Thanks!

---

Reply to this email directly or view it on GitHub:
#53 (comment)
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.HOME] flg=0x10200000 cmp=com.android.launcher/com.android.launcher2
.Launcher} from pid 168
D/dalvikvm( 276): GC_CONCURRENT freed 543K, 56% free 9219K/20679K, paused 3ms+5
ms
I/dalvikvm( 276): Jit: resizing JitTable from 4096 to 8192
W/ResourceType( 168): Invalid package identifier when getting bag for resource
number 0x7f0c0008
D/OpenGLRenderer( 276): Flushing caches (mode 0)
I/TextType( 409): TextType = 0x0
W/InputManagerService( 168): Window already focused, ignoring focus gain of: co
m.android.internal.view.IInputMethodClient$Stub$Proxy@4156c970
^C
D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/main
D/dalvikvm( 1019): GC_CONCURRENT freed 393K, 9% free 6687K/7303K, paused 3ms+2ms

D/dalvikvm( 276): GC_CONCURRENT freed 543K, 54% free 9564K/20679K, paused 1ms+3
ms
V/ ( 168): void cb_onMotion(uint16_t)
--------- beginning of /dev/log/system
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.LAUNCHER] flg=0x10104000 cmp=vgp.pad.app/.VGPadActivity} from pid 2
76
D/dalvikvm( 2337): Late-enabling CheckJNI
I/ActivityManager( 168): Start proc vgp.pad.app for activity vgp.pad.app/.VGPad
Activity: pid=2337 uid=10001 gids={1015}
I/dalvikvm( 2337): Turning on JNI app bug workarounds for target SDK version 13.
..
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
D/dalvikvm( 2337): Debugger has detached; object registry had 1 entries
D/OpenGLRenderer( 437): Flushing caches (mode 1)
D/OpenGLRenderer( 437): Flushing caches (mode 0)
D/dalvikvm( 2337): GC_CONCURRENT freed 161K, 4% free 6887K/7111K, paused 3ms+4ms

D/dalvikvm( 2337): GC_FOR_ALLOC freed 13K, 4% free 6932K/7175K, paused 25ms
I/dalvikvm-heap( 2337): Grow heap (frag case) to 10.645MB for 4000016-byte alloc
ation
D/dalvikvm( 2337): GC_CONCURRENT freed <1K, 3% free 10838K/11143K, paused 1ms+3m
s
D/OpenGLRenderer( 276): Flushing caches (mode 0)
D/TextView( 2337): Constructor - Got Res id for appearance for textColorPrimaryI
nverse
W/ResourceType( 2337): Skipping entry 0x106006a in package table 0 because it is
not complex!
D/TextView( 2337): Constructor - Got appearance for textColorPrimaryInverse
D/TextView( 2337): Constructor -- Got mEditTextBackgroundColor
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libstlport_shar
ed.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libstlport_shared
.so 0x410b0c10
D/dalvikvm( 2337): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libstlport_
shared.so 0x410b0c10, skipping init
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libsqlcipher_an
droid.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libsqlcipher_andr
oid.so 0x410b0c10
D/dalvikvm( 2337): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libsqlciphe
r_android.so 0x410b0c10, skipping init
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libdatabase_sql
cipher.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libdatabase_sqlci
pher.so 0x410b0c10
I/Database( 2337): JNI_OnLoad called
I/Database( 2337): JNI_OnLoad register methods
I/Database( 2337): sqlite returned: error code = 21, msg = API called with NULL
prepared statement
I/Database( 2337): sqlite returned: error code = 21, msg = misuse at line 58727
of [42537b6056]
E/Database( 2337): Failure 0 (not an error) on 0x1a14840 when executing '

E/Database( 2337):

E/Database( 2337):
E/Database( 2337): '
I/Database( 2337): sqlite returned: error code = 11, msg = database corruption a
t line 46614 of [42537b6056]
I/Database( 2337): sqlite returned: error code = 11, msg = database corruption a
t line 46652 of [42537b6056]
D/AndroidRuntime( 2337): Shutting down VM
W/dalvikvm( 2337): threadid=1: thread exiting with uncaught exception (group=0x4
0a411f8)
E/AndroidRuntime( 2337): FATAL EXCEPTION: main
E/AndroidRuntime( 2337): java.lang.RuntimeException: Unable to start activity Co
mponentInfo{vgp.pad.app/vgp.pad.app.VGPadActivity}: info.guardianproject.databas
e.sqlcipher.SQLiteException: not an error:
E/AndroidRuntime( 2337):

E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1956)
E/AndroidRuntime( 2337): at android.app.ActivityThread.handleLaunchActivi
ty(ActivityThread.java:1981)
E/AndroidRuntime( 2337): at android.app.ActivityThread.access$600(Activit
yThread.java:123)
E/AndroidRuntime( 2337): at android.app.ActivityThread$H.handleMessage(Ac
tivityThread.java:1147)
E/AndroidRuntime( 2337): at android.os.Handler.dispatchMessage(Handler.ja
va:99)
E/AndroidRuntime( 2337): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 2337): at android.app.ActivityThread.main(ActivityThrea
d.java:4424)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2337): at dalvik.system.NativeStart.main(Native Method)

E/AndroidRuntime( 2337): Caused by: info.guardianproject.database.sqlcipher.SQLi
teException: not an error:
E/AndroidRuntime( 2337):

E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.native_execSQL(Native Method)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.execSQL(SQLiteDatabase.java:1785)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase$VGPDBHelper.onCreate(
VGPDatabase.java:82)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:121)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2337): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2337): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2337): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2337): ... 11 more
W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{410c6760 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
^C
D:\dev\Android\android-sdk\platform-tools>
D:\dev\Android\android-sdk\platform-tools>
D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/main
V/ ( 168): void cb_onMotion(uint16_t)
--------- beginning of /dev/log/system
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.LAUNCHER] flg=0x10104000 cmp=vgp.pad.app/.VGPadActivity} from pid 2
76
D/dalvikvm( 168): GC_FOR_ALLOC freed 840K, 25% free 12568K/16647K, paused 53ms
D/dalvikvm( 2461): Late-enabling CheckJNI
I/ActivityManager( 168): Start proc vgp.pad.app for activity vgp.pad.app/.VGPad
Activity: pid=2461 uid=10001 gids={1015}
I/dalvikvm( 2461): Turning on JNI app bug workarounds for target SDK version 13.
..
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
D/OpenGLRenderer( 437): Flushing caches (mode 1)
D/dalvikvm( 168): GC_EXPLICIT freed 62K, 25% free 12645K/16647K, paused 5ms+7ms

D/OpenGLRenderer( 437): Flushing caches (mode 0)
D/dalvikvm( 2461): GC_CONCURRENT freed 168K, 4% free 6880K/7111K, paused 2ms+2ms

D/OpenGLRenderer( 276): Flushing caches (mode 0)
D/dalvikvm( 2461): GC_FOR_ALLOC freed 16K, 4% free 6933K/7175K, paused 21ms
I/dalvikvm-heap( 2461): Grow heap (frag case) to 10.645MB for 4000016-byte alloc
ation
D/dalvikvm( 2461): GC_CONCURRENT freed 1K, 3% free 10838K/11143K, paused 2ms+2ms

D/TextView( 2461): Constructor - Got Res id for appearance for textColorPrimaryI
nverse
W/ResourceType( 2461): Skipping entry 0x106006a in package table 0 because it is
not complex!
D/TextView( 2461): Constructor - Got appearance for textColorPrimaryInverse
D/TextView( 2461): Constructor -- Got mEditTextBackgroundColor
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libstlport_shar
ed.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libstlport_shared
.so 0x410b39a0
D/dalvikvm( 2461): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libstlport_
shared.so 0x410b39a0, skipping init
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libsqlcipher_an
droid.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libsqlcipher_andr
oid.so 0x410b39a0
D/dalvikvm( 2461): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libsqlciphe
r_android.so 0x410b39a0, skipping init
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libdatabase_sql
cipher.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libdatabase_sqlci
pher.so 0x410b39a0
I/Database( 2461): JNI_OnLoad called
I/Database( 2461): JNI_OnLoad register methods
I/Database( 2461): sqlite returned: error code = 21, msg = API called with NULL
prepared statement
I/Database( 2461): sqlite returned: error code = 21, msg = misuse at line 58727
of [42537b6056]
E/Database( 2461): Failure 0 (not an error) on 0x1a14840 when executing '

E/Database( 2461):

E/Database( 2461):
E/Database( 2461): '
I/Database( 2461): sqlite returned: error code = 11, msg = database corruption a
t line 46614 of [42537b6056]
I/Database( 2461): sqlite returned: error code = 11, msg = database corruption a
t line 46652 of [42537b6056]
D/AndroidRuntime( 2461): Shutting down VM
W/dalvikvm( 2461): threadid=1: thread exiting with uncaught exception (group=0x4
0a411f8)
E/AndroidRuntime( 2461): FATAL EXCEPTION: main
E/AndroidRuntime( 2461): java.lang.RuntimeException: Unable to start activity Co
mponentInfo{vgp.pad.app/vgp.pad.app.VGPadActivity}: info.guardianproject.databas
e.sqlcipher.SQLiteException: not an error:
E/AndroidRuntime( 2461):

E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1956)
E/AndroidRuntime( 2461): at android.app.ActivityThread.handleLaunchActivi
ty(ActivityThread.java:1981)
E/AndroidRuntime( 2461): at android.app.ActivityThread.access$600(Activit
yThread.java:123)
E/AndroidRuntime( 2461): at android.app.ActivityThread$H.handleMessage(Ac
tivityThread.java:1147)
E/AndroidRuntime( 2461): at android.os.Handler.dispatchMessage(Handler.ja
va:99)
E/AndroidRuntime( 2461): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 2461): at android.app.ActivityThread.main(ActivityThrea
d.java:4424)
E/AndroidRuntime( 2461): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2461): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2461): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2461): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2461): at dalvik.system.NativeStart.main(Native Method)

E/AndroidRuntime( 2461): Caused by: info.guardianproject.database.sqlcipher.SQLi
teException: not an error:
E/AndroidRuntime( 2461):

E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.native_execSQL(Native Method)
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.execSQL(SQLiteDatabase.java:1785)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPDatabase$VGPDBHelper.onCreate(
VGPDatabase.java:82)
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:121)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2461): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2461): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2461): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2461): ... 11 more
W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{4150f3e8 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
I/ActivityManager( 168): No longer want com.google.android.apps.maps:FriendServ
ice (pid 2111): hidden #16
I/Process ( 2461): Sending signal. PID: 2461 SIG: 9
I/ActivityManager( 168): Process vgp.pad.app (pid 2461) has died.
W/InputManagerService( 168): Window already focused, ignoring focus gain of: co
m.android.internal.view.IInputMethodClient$Stub$Proxy@410f2c08
^C
D:\dev\Android\android-sdk\platform-tools>
d.java:4424)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2337): at dalvik.system.NativeStart.main(Native Method)

E/AndroidRuntime( 2337): Caused by: info.guardianproject.database.sqlcipher.SQLi
teException: not an error:
E/AndroidRuntime( 2337):

E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.native_execSQL(Native Method)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.execSQL(SQLiteDatabase.java:1785)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase$VGPDBHelper.onCreate(
VGPDatabase.java:82)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:121)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2337): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2337): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2337): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2337): ... 11 more
W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{410c6760 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
^C
D:\dev\Android\android-sdk\platform-tools>
D:\dev\Android\android-sdk\platform-tools>
D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/main
V/ ( 168): void cb_onMotion(uint16_t)
--------- beginning of /dev/log/system
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.LAUNCHER] flg=0x10104000 cmp=vgp.pad.app/.VGPadActivity} from pid 2
76
D/dalvikvm( 168): GC_FOR_ALLOC freed 840K, 25% free 12568K/16647K, paused 53ms
D/dalvikvm( 2461): Late-enabling CheckJNI
I/ActivityManager( 168): Start proc vgp.pad.app for activity vgp.pad.app/.VGPad
Activity: pid=2461 uid=10001 gids={1015}
I/dalvikvm( 2461): Turning on JNI app bug workarounds for target SDK version 13.
..
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
D/OpenGLRenderer( 437): Flushing caches (mode 1)
D/dalvikvm( 168): GC_EXPLICIT freed 62K, 25% free 12645K/16647K, paused 5ms+7ms

D/OpenGLRenderer( 437): Flushing caches (mode 0)
D/dalvikvm( 2461): GC_CONCURRENT freed 168K, 4% free 6880K/7111K, paused 2ms+2ms

D/OpenGLRenderer( 276): Flushing caches (mode 0)
D/dalvikvm( 2461): GC_FOR_ALLOC freed 16K, 4% free 6933K/7175K, paused 21ms
I/dalvikvm-heap( 2461): Grow heap (frag case) to 10.645MB for 4000016-byte alloc
ation
D/dalvikvm( 2461): GC_CONCURRENT freed 1K, 3% free 10838K/11143K, paused 2ms+2ms

D/TextView( 2461): Constructor - Got Res id for appearance for textColorPrimaryI
nverse
W/ResourceType( 2461): Skipping entry 0x106006a in package table 0 because it is
not complex!
D/TextView( 2461): Constructor - Got appearance for textColorPrimaryInverse
D/TextView( 2461): Constructor -- Got mEditTextBackgroundColor
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libstlport_shar
ed.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libstlport_shared
.so 0x410b39a0
D/dalvikvm( 2461): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libstlport_
shared.so 0x410b39a0, skipping init
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libsqlcipher_an
droid.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libsqlcipher_andr
oid.so 0x410b39a0
D/dalvikvm( 2461): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libsqlciphe
r_android.so 0x410b39a0, skipping init
D/dalvikvm( 2461): Trying to load lib /data/data/vgp.pad.app/lib/libdatabase_sql
cipher.so 0x410b39a0
D/dalvikvm( 2461): Added shared lib /data/data/vgp.pad.app/lib/libdatabase_sqlci
pher.so 0x410b39a0
I/Database( 2461): JNI_OnLoad called
I/Database( 2461): JNI_OnLoad register methods
I/Database( 2461): sqlite returned: error code = 21, msg = API called with NULL
prepared statement
I/Database( 2461): sqlite returned: error code = 21, msg = misuse at line 58727
of [42537b6056]
E/Database( 2461): Failure 0 (not an error) on 0x1a14840 when executing '

E/Database( 2461):

E/Database( 2461):
E/Database( 2461): '
I/Database( 2461): sqlite returned: error code = 11, msg = database corruption a
t line 46614 of [42537b6056]
I/Database( 2461): sqlite returned: error code = 11, msg = database corruption a
t line 46652 of [42537b6056]
D/AndroidRuntime( 2461): Shutting down VM
W/dalvikvm( 2461): threadid=1: thread exiting with uncaught exception (group=0x4
0a411f8)
E/AndroidRuntime( 2461): FATAL EXCEPTION: main
E/AndroidRuntime( 2461): java.lang.RuntimeException: Unable to start activity Co
mponentInfo{vgp.pad.app/vgp.pad.app.VGPadActivity}: info.guardianproject.databas
e.sqlcipher.SQLiteException: not an error:
E/AndroidRuntime( 2461):

E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1956)
E/AndroidRuntime( 2461): at android.app.ActivityThread.handleLaunchActivi
ty(ActivityThread.java:1981)
E/AndroidRuntime( 2461): at android.app.ActivityThread.access$600(Activit
yThread.java:123)
E/AndroidRuntime( 2461): at android.app.ActivityThread$H.handleMessage(Ac
tivityThread.java:1147)
E/AndroidRuntime( 2461): at android.os.Handler.dispatchMessage(Handler.ja
va:99)
E/AndroidRuntime( 2461): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 2461): at android.app.ActivityThread.main(ActivityThrea
d.java:4424)
E/AndroidRuntime( 2461): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2461): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2461): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2461): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2461): at dalvik.system.NativeStart.main(Native Method)

E/AndroidRuntime( 2461): Caused by: info.guardianproject.database.sqlcipher.SQLi
teException: not an error:
E/AndroidRuntime( 2461):

E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461):
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.native_execSQL(Native Method)
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.execSQL(SQLiteDatabase.java:1785)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPDatabase$VGPDBHelper.onCreate(
VGPDatabase.java:82)
E/AndroidRuntime( 2461): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:121)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2461): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2461): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2461): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2461): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2461): ... 11 more
W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{4150f3e8 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
I/ActivityManager( 168): No longer want com.google.android.apps.maps:FriendServ
ice (pid 2111): hidden #16
I/Process ( 2461): Sending signal. PID: 2461 SIG: 9
I/ActivityManager( 168): Process vgp.pad.app (pid 2461) has died.
W/InputManagerService( 168): Window already focused, ignoring focus gain of: co
m.android.internal.view.IInputMethodClient$Stub$Proxy@410f2c08
^C
D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/system
W/ActivityManager( 168): Activity destroy timeout for ActivityRecord{4193f5f8 v
gp.pad.app/.VGPadActivity}
D/AlarmManager( 168): Triggered Alarm 418b2640 RTC_WAKEUP IntentSender{410da408
: PendingIntentRecord{41943bf0 com.android.vending startService}}
--------- beginning of /dev/log/main
D/dalvikvm( 2023): GC_CONCURRENT freed 463K, 7% free 7214K/7751K, paused 1ms+2ms

D/Finsky ( 2023): [1] 5.onFinished: Installation state replication succeeded.
D/TaskWidgetDataUtils( 1019): In trigger refresh list utils
D/TaskWidgetDataUtils( 1019): getWidgetData()
D/dalvikvm( 1019): GC_CONCURRENT freed 480K, 9% free 6713K/7367K, paused 1ms+2ms

I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.LAUNCHER] flg=0x10104000 cmp=vgp.pad.app/.VGPadActivity} from pid 2
76
D/dalvikvm( 168): GC_FOR_ALLOC freed 500K, 25% free 12626K/16647K, paused 45ms
D/dalvikvm( 2536): Late-enabling CheckJNI
I/ActivityManager( 168): Start proc vgp.pad.app for activity vgp.pad.app/.VGPad
Activity: pid=2536 uid=10001 gids={1015}
I/dalvikvm( 2536): Turning on JNI app bug workarounds for target SDK version 13.
..
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
D/OpenGLRenderer( 437): Flushing caches (mode 1)
D/OpenGLRenderer( 437): Flushing caches (mode 0)
D/dalvikvm( 2536): GC_CONCURRENT freed 173K, 4% free 6875K/7111K, paused 4ms+2ms

D/dalvikvm( 2536): GC_FOR_ALLOC freed 18K, 3% free 6933K/7111K, paused 27ms
I/dalvikvm-heap( 2536): Grow heap (frag case) to 10.646MB for 4000016-byte alloc
ation
D/dalvikvm( 2536): GC_CONCURRENT freed 1K, 3% free 10838K/11079K, paused 1ms+2ms

D/OpenGLRenderer( 276): Flushing caches (mode 0)
D/TextView( 2536): Constructor - Got Res id for appearance for textColorPrimaryI
nverse
W/ResourceType( 2536): Skipping entry 0x106006a in package table 0 because it is
not complex!
D/TextView( 2536): Constructor - Got appearance for textColorPrimaryInverse
D/TextView( 2536): Constructor -- Got mEditTextBackgroundColor
W/dalvikvm( 2536): No implementation found for native Linfo/guardianproject/data
base/sqlcipher/SQLiteDatabase;.dbopen (Ljava/lang/String;I)V
D/AndroidRuntime( 2536): Shutting down VM
W/dalvikvm( 2536): threadid=1: thread exiting with uncaught exception (group=0x4
0a411f8)
E/AndroidRuntime( 2536): FATAL EXCEPTION: main
E/AndroidRuntime( 2536): java.lang.UnsatisfiedLinkError: dbopen
E/AndroidRuntime( 2536): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.dbopen(Native Method)
E/AndroidRuntime( 2536): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.(SQLiteDatabase.java:1872)
E/AndroidRuntime( 2536): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.openDatabase(SQLiteDatabase.java:864)
E/AndroidRuntime( 2536): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.openOrCreateDatabase(SQLiteDatabase.java:898)
E/AndroidRuntime( 2536): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:107)
E/AndroidRuntime( 2536): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2536): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2536): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2536): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2536): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2536): at android.app.ActivityThread.handleLaunchActivi
ty(ActivityThread.java:1981)
E/AndroidRuntime( 2536): at android.app.ActivityThread.access$600(Activit
yThread.java:123)
E/AndroidRuntime( 2536): at android.app.ActivityThread$H.handleMessage(Ac
tivityThread.java:1147)
E/AndroidRuntime( 2536): at android.os.Handler.dispatchMessage(Handler.ja
va:99)
E/AndroidRuntime( 2536): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 2536): at android.app.ActivityThread.main(ActivityThrea
d.java:4424)
E/AndroidRuntime( 2536): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2536): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2536): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2536): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2536): at dalvik.system.NativeStart.main(Native Method)

W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
D/dalvikvm( 168): GC_FOR_ALLOC freed 171K, 25% free 12610K/16647K, paused 44ms
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{4137a328 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
I/Process ( 2536): Sending signal. PID: 2536 SIG: 9
I/ActivityManager( 168): Process vgp.pad.app (pid 2536) has died.
W/InputManagerService( 168): Window already focused, ignoring focus gain of: co
m.android.internal.view.IInputMethodClient$Stub$Proxy@4156db30
^C
D:\dev\Android\android-sdk\platform-tools>

Microsoft Windows [version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.

D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/main
I/Process ( 2306): Sending signal. PID: 2306 SIG: 9
--------- beginning of /dev/log/system
I/ActivityManager( 168): Process vgp.pad.app (pid 2306) has died.
I/TextType( 409): TextType = 0x0
D/dalvikvm( 409): GC_CONCURRENT freed 480K, 28% free 7063K/9735K, paused 3ms+3m
s
I/TextType( 409): TextType = 0x0
D/dalvikvm( 437): GC_FOR_ALLOC freed 524K, 12% free 10177K/11463K, paused 23ms
I/dalvikvm-heap( 437): Grow heap (frag case) to 10.141MB for 147472-byte alloca
tion
D/dalvikvm( 437): GC_FOR_ALLOC freed 29K, 12% free 10292K/11655K, paused 22ms
D/dalvikvm( 437): GC_FOR_ALLOC freed 158K, 13% free 10244K/11655K, paused 21ms
D/dalvikvm( 437): GC_FOR_ALLOC freed 62K, 13% free 10245K/11655K, paused 22ms
D/dalvikvm( 437): GC_FOR_ALLOC freed 111K, 12% free 10306K/11655K, paused 21ms
I/dalvikvm-heap( 437): Grow heap (frag case) to 11.995MB for 1958648-byte alloc
ation
D/dalvikvm( 437): GC_CONCURRENT freed 1K, 11% free 12218K/13575K, paused 1ms+4m
s
D/dalvikvm( 437): GC_FOR_ALLOC freed 333K, 12% free 12327K/13895K, paused 23ms
I/dalvikvm-heap( 437): Grow heap (frag case) to 13.328MB for 1286224-byte alloc
ation
D/dalvikvm( 437): GC_FOR_ALLOC freed 1K, 11% free 13582K/15175K, paused 34ms
D/dalvikvm( 437): GC_FOR_ALLOC freed 2314K, 23% free 12130K/15687K, paused 25ms

D/dalvikvm( 437): GC_CONCURRENT freed 2343K, 26% free 11611K/15687K, paused 2ms
+3ms
D/dalvikvm( 437): GC_CONCURRENT freed 437K, 19% free 12767K/15687K, paused 2ms+
4ms
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.HOME] flg=0x10200000 cmp=com.android.launcher/com.android.launcher2
.Launcher} from pid 168
D/dalvikvm( 276): GC_CONCURRENT freed 543K, 56% free 9219K/20679K, paused 3ms+5
ms
I/dalvikvm( 276): Jit: resizing JitTable from 4096 to 8192
W/ResourceType( 168): Invalid package identifier when getting bag for resource
number 0x7f0c0008
D/OpenGLRenderer( 276): Flushing caches (mode 0)
I/TextType( 409): TextType = 0x0
W/InputManagerService( 168): Window already focused, ignoring focus gain of: co
m.android.internal.view.IInputMethodClient$Stub$Proxy@4156c970
^C
D:\dev\Android\android-sdk\platform-tools>adb logcat -c

D:\dev\Android\android-sdk\platform-tools>adb logcat
--------- beginning of /dev/log/main
D/dalvikvm( 1019): GC_CONCURRENT freed 393K, 9% free 6687K/7303K, paused 3ms+2ms

D/dalvikvm( 276): GC_CONCURRENT freed 543K, 54% free 9564K/20679K, paused 1ms+3
ms
V/ ( 168): void cb_onMotion(uint16_t)
--------- beginning of /dev/log/system
I/ActivityManager( 168): START {act=android.intent.action.MAIN cat=[android.int
ent.category.LAUNCHER] flg=0x10104000 cmp=vgp.pad.app/.VGPadActivity} from pid 2
76
D/dalvikvm( 2337): Late-enabling CheckJNI
I/ActivityManager( 168): Start proc vgp.pad.app for activity vgp.pad.app/.VGPad
Activity: pid=2337 uid=10001 gids={1015}
I/dalvikvm( 2337): Turning on JNI app bug workarounds for target SDK version 13.
..
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
D/dalvikvm( 2337): Debugger has detached; object registry had 1 entries
D/OpenGLRenderer( 437): Flushing caches (mode 1)
D/OpenGLRenderer( 437): Flushing caches (mode 0)
D/dalvikvm( 2337): GC_CONCURRENT freed 161K, 4% free 6887K/7111K, paused 3ms+4ms

D/dalvikvm( 2337): GC_FOR_ALLOC freed 13K, 4% free 6932K/7175K, paused 25ms
I/dalvikvm-heap( 2337): Grow heap (frag case) to 10.645MB for 4000016-byte alloc
ation
D/dalvikvm( 2337): GC_CONCURRENT freed <1K, 3% free 10838K/11143K, paused 1ms+3m
s
D/OpenGLRenderer( 276): Flushing caches (mode 0)
D/TextView( 2337): Constructor - Got Res id for appearance for textColorPrimaryI
nverse
W/ResourceType( 2337): Skipping entry 0x106006a in package table 0 because it is
not complex!
D/TextView( 2337): Constructor - Got appearance for textColorPrimaryInverse
D/TextView( 2337): Constructor -- Got mEditTextBackgroundColor
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libstlport_shar
ed.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libstlport_shared
.so 0x410b0c10
D/dalvikvm( 2337): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libstlport_
shared.so 0x410b0c10, skipping init
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libsqlcipher_an
droid.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libsqlcipher_andr
oid.so 0x410b0c10
D/dalvikvm( 2337): No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libsqlciphe
r_android.so 0x410b0c10, skipping init
D/dalvikvm( 2337): Trying to load lib /data/data/vgp.pad.app/lib/libdatabase_sql
cipher.so 0x410b0c10
D/dalvikvm( 2337): Added shared lib /data/data/vgp.pad.app/lib/libdatabase_sqlci
pher.so 0x410b0c10
I/Database( 2337): JNI_OnLoad called
I/Database( 2337): JNI_OnLoad register methods
I/Database( 2337): sqlite returned: error code = 21, msg = API called with NULL
prepared statement
I/Database( 2337): sqlite returned: error code = 21, msg = misuse at line 58727
of [42537b6056]
E/Database( 2337): Failure 0 (not an error) on 0x1a14840 when executing '

E/Database( 2337):

E/Database( 2337):
E/Database( 2337): '
I/Database( 2337): sqlite returned: error code = 11, msg = database corruption a
t line 46614 of [42537b6056]
I/Database( 2337): sqlite returned: error code = 11, msg = database corruption a
t line 46652 of [42537b6056]
D/AndroidRuntime( 2337): Shutting down VM
W/dalvikvm( 2337): threadid=1: thread exiting with uncaught exception (group=0x4
0a411f8)
E/AndroidRuntime( 2337): FATAL EXCEPTION: main
E/AndroidRuntime( 2337): java.lang.RuntimeException: Unable to start activity Co
mponentInfo{vgp.pad.app/vgp.pad.app.VGPadActivity}: info.guardianproject.databas
e.sqlcipher.SQLiteException: not an error:
E/AndroidRuntime( 2337):

E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1956)
E/AndroidRuntime( 2337): at android.app.ActivityThread.handleLaunchActivi
ty(ActivityThread.java:1981)
E/AndroidRuntime( 2337): at android.app.ActivityThread.access$600(Activit
yThread.java:123)
E/AndroidRuntime( 2337): at android.app.ActivityThread$H.handleMessage(Ac
tivityThread.java:1147)
E/AndroidRuntime( 2337): at android.os.Handler.dispatchMessage(Handler.ja
va:99)
E/AndroidRuntime( 2337): at android.os.Looper.loop(Looper.java:137)
E/AndroidRuntime( 2337): at android.app.ActivityThread.main(ActivityThrea
d.java:4424)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invokeNative(Native
Method)
E/AndroidRuntime( 2337): at java.lang.reflect.Method.invoke(Method.java:5
11)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit$MethodAndA
rgsCaller.run(ZygoteInit.java:784)
E/AndroidRuntime( 2337): at com.android.internal.os.ZygoteInit.main(Zygot
eInit.java:551)
E/AndroidRuntime( 2337): at dalvik.system.NativeStart.main(Native Method)

E/AndroidRuntime( 2337): Caused by: info.guardianproject.database.sqlcipher.SQLi
teException: not an error:
E/AndroidRuntime( 2337):

E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337):
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.native_execSQL(Native Method)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eDatabase.execSQL(SQLiteDatabase.java:1785)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase$VGPDBHelper.onCreate(
VGPDatabase.java:82)
E/AndroidRuntime( 2337): at info.guardianproject.database.sqlcipher.SQLit
eOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:121)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPDatabase.open(VGPDatabase.java
:155)
E/AndroidRuntime( 2337): at vgp.pad.app.VGPadActivity.onCreate(VGPadActiv
ity.java:65)
E/AndroidRuntime( 2337): at android.app.Activity.performCreate(Activity.j
ava:4465)
E/AndroidRuntime( 2337): at android.app.Instrumentation.callActivityOnCre
ate(Instrumentation.java:1049)
E/AndroidRuntime( 2337): at android.app.ActivityThread.performLaunchActiv
ity(ActivityThread.java:1920)
E/AndroidRuntime( 2337): ... 11 more
W/ActivityManager( 168): Force finishing activity vgp.pad.app/.VGPadActivity
W/ActivityManager( 168): Activity pause timeout for ActivityRecord{410c6760 vgp
.pad.app/.VGPadActivity}
D/WindowManager( 168): readLidState, sw:1
D/WindowManager( 168): adjustConfigurationLw, config:{1.0 0mcc0mnc (no locale)
layoutdir=0 sw800dp w1280dp h752dp xlrg land ?uimode ?night finger qwerty/v/v -n
av/v} mLidOpen:1 mHasDockFeature:true mHasHallSensorFeature:true config.hardKeyb
oardHidden:1
^C
D:\dev\Android\android-sdk\platform-tools>

[developernotes]

Hi Alexander-Campbell,

We publish build packages that contain all resources needed for proper integration. The 'not an error' error could be the cause of a different icu dat file being used. Could you attempt to recreate it with all the files provided in the 1.1 build release. This will include the icu zip file found in the assets directory in our distribution. You will want to leave the icudt46l.zip as is within your assets directory, SQLCipher will manage the extraction.

https://github.com/downloads/sqlcipher/android-database-sqlcipher/SQLCipher%20for%20Android%201.1.0.zip

Also, if you'd like a small sample that shows the 1.1 libraries integrated with an Android application, I've publish one you can view here:

https://github.com/developernotes/sqlcipher-demo

Please let us know your results. Thanks!

[Alexander-Campbell]

Hello,

Firstly the test app you provided works, phew !!!   The 1.1 libraries you send are the same as the initial libraries I started with, I replaced these anyway, including assets zip file. I am getting the same error as before, can I ask you some questions about trace ...

No JNI_OnLoad found in /data/data/vgp.pad.app/lib/libstlport_shared.so 0x410bd228, skipping init 

is this normal ?

sqlite returned: error code = 21, msg = API called with NULL prepared statement
and
sqlite returned: error code = 11, msg = database corruption at line 46614 of [42537b6056]

What does error code 21 and 11 mean ?

My gut feeling is that I calling the loadLibs in the wrong place, I am using SQLiteDatabase as a class with a sub class for the SQLiteOpenHelper, if you want I can send the an extract of the code.

thanks again
Alexander

---

De : Nick Parker reply@reply.github.com
À : Alexander-Campbell clan_campbell@yahoo.fr
Envoyé le : Lundi 23 avril 2012 15h10
Objet : Re: [android-database-sqlcipher] SQLCipher under Android 4.0.3 (#53)

Hi Alexander-Campbell,

We publish build packages that contain all resources needed for proper integration.  The 'not an error' error could be the cause of a different icu dat file being used.  Could you attempt to recreate it with all the files provided in the 1.1 build release.  This will include the icu zip file found in the assets directory in our distribution.  You will want to leave the icudt46l.zip as is within your assets directory, SQLCipher will manage the extraction.

https://github.com/downloads/sqlcipher/android-database-sqlcipher/SQLCipher%20for%20Android%201.1.0.zip

Also, if you'd like a small sample that shows the 1.1 libraries integrated with an Android application, I've publish one you can view here:

https://github.com/developernotes/sqlcipher-demo

Please let us know your results.  Thanks!

---

Reply to this email directly or view it on GitHub:
#53 (comment)

[developernotes]

Hello Alexander,

The log line "No JNI_OnLoad found ... skipping init" is normal. We would need to see how you are using the code to generate error code 21. In regards to error code 11, are you attempting to use an existing database, or is it new? If it is an existing database, is it a standard sqlite database or an existing sqlcipher database? You need to call SQLiteDatabase.loadLibs before you call any other database operation. Could you provide us with a code example that demonstrates the problem you are seeing via Gist [1]?

1. https://gist.github.com/

[Alexander-Campbell]

Hello,
So I have uploaded my sample code to github, I call this class using the following code

          VGPDatabase vgpdb;

          vgpdb = new VGPDatabase (context);
          vgpdb.open();
           :
            other DB calls
           :
          vgpdb.close();

With normal SQLLite this works fine, If I run this in DB mode it crashes in the vgpdb.open call.

As ever
Alex

---

De : Nick Parker reply@reply.github.com
À : Alexander-Campbell clan_campbell@yahoo.fr
Envoyé le : Lundi 23 avril 2012 17h13
Objet : Re: [android-database-sqlcipher] SQLCipher under Android 4.0.3 (#53)

Hello Alexander,

The log line "No JNI_OnLoad found ... skipping init" is normal.  We would need to see how you are using the code to generate error code 21.  In regards to error code 11, are you attempting to use an existing database, or is it new?  If it is an existing database, is it a standard sqlite database or an existing sqlcipher database?  You need to call SQLiteDatabase.loadLibs before you call any other database operation.  Could you provide us with a code example that demonstrates the problem you are seeing via Gist [1]?

1. https://gist.github.com/

---

Reply to this email directly or view it on GitHub:
#53 (comment)

[developernotes]

Hi Alex,

Is there a link to the code you pushed to Github? I don't see anything listed on https://github.com/Alexander-Campbell. Could you please provide an example that demonstrates the error you are getting? Thanks!

[Alexander-Campbell]

Hello,
I though I saved this earlier but must have hit the wrong button, I have loaded thishttps://gist.github.com/59fd47dbb9a71b242c72
BTW in my previous mail when I debug the app, I get the scratch on the vgpdb.open command.

---

De : Nick Parker reply@reply.github.com
À : Alexander-Campbell clan_campbell@yahoo.fr
Envoyé le : Mardi 24 avril 2012 16h49
Objet : Re: [android-database-sqlcipher] SQLCipher under Android 4.0.3 (#53)

Hi Alex,

Is there a link to the code you pushed to Github?  I don't see anything listed on https://github.com/Alexander-Campbell.  Could you please provide an example that demonstrates the error you are getting?  Thanks!

---

Reply to this email directly or view it on GitHub:
#53 (comment)

[developernotes]

Hello Alexander,

Did you try replacing all of the libraries and the icudt46l.zip in your assets directory with those found in the link I provided above? Could you try that and share your results? Thanks!

[Alexander-Campbell]

Hello,
I have relaced the libraries I started tracing this again and in fact I sent an empty query, in normal SQLite this doesn't create an exception, but in SQLCipher yes. I cleaned up my SQL batch file and now this works.So for my the issues is closed.

thanks for the help.
Alexander

---

De : Nick Parker reply@reply.github.com
À : Alexander-Campbell clan_campbell@yahoo.fr
Envoyé le : Mardi 24 avril 2012 17h38
Objet : Re: [android-database-sqlcipher] SQLCipher under Android 4.0.3 (#53)

Hello Alexander,

Did you try replacing all of the libraries and the icudt46l.zip in your assets directory with those found in the link I provided above?  Could you try that and share your results?  Thanks!

---

Reply to this email directly or view it on GitHub:
#53 (comment)

[developernotes]

Alexander,

Thanks for getting back to us, glad to hear you resolved your issues.