CODEWITHSUNDEEP
androidsqlite
Sephy
Sephy

Reputation: 50392

sqlite3 permission denied android

I'm trying to access the database of the application I'm developping directly on my Nexus, but I get a "permission denied" when I tried to execute the "sqlite3" command. I also tried to start the adb in root mod, but again, permission denied on the device... I guess I will have to do that with the emulator but I have a lot of data to load and it would have been 10 times faster with the phone on Wifi than the emulator... Unless someone has any idea? thanks

Upvotes: 12

Views: 16328

Answers (4)

eggbert
eggbert

Reputation: 3233

I struggled with this for a while, so here's my solution, which works on an unrooted device:

#!/bin/sh

# fill these values in
PACKAGE=com.example.android
DB=something.db 

# copy db to sdcard using package permission (using cat because no cp    command)
adb shell "run-as $PACKAGE cat /data/data/$PACKAGE/databases/$DB >   /sdcard/$DB"

# pull file from sd card
adb pull /sdcard/$DB

# do something with it (need to install sqlitebrowser obviously)
sqlitebrowser $DB

Upvotes: 8

Piotr Buda
Piotr Buda

Reputation: 353

I had a similar problem. I pulled sqlite3 from emulator and pushed in on my device and couldn't run it - permission denied.

Apparently sqlite3 binary didn't have execute permission (-rw-rw-rw-) so chmod +x sqlite3 solved the issue.

Upvotes: 0

Brad Hein
Brad Hein

Reputation: 11057

Typical.

I worked around this annoyance by adding a feature to my app that backs up (copies) the DB to the SD card. adb pull works against any sdcard files.

EDIT: fixed "adb" misspelling (was "sdp".

Upvotes: 3

Alexander Stolz
Alexander Stolz

Reputation: 7544

The files are read protected, you need to root your phone or use the emulator.

Upvotes: 4

Related Questions