I am having trouble accessing the database while I am developing on the phone. Whenever I execute
cd /data/data/com.mycompck/databases
and then run ls
I get: "opendir failed, Permission denied"
Or whenever I type in sqlite3
I get: "sqlite3: permission denied"
What am I doing wrong?
Are there some applications that can help me getting a human view of content resolvers values and/or SQLite databases?
Check my answer from the following thread: Why do I get access denied to data folder when using adb?
Starting from API level 8 (Android 2.2), if you build the application as debuggable, you can use the shell
run-as
command to run a command or executable as a specific user/application or just switch to theUID
of your application so you can access itsdata
directory.
So basically you will need to make a debug build (which is made automatically whenever you launch the application from the Android Studio unless you request the release build) and run the following commands:
run-as com.mycompck
cd /data/data/com.mycompck/databases
ls
sqlite3 ./yourdatabase.db
However note that sqlite3
binary is not present by default on many phones. Thus you will perhaps need to download it somewhere (e.g. from SuperOneClick archives at http://shortfuse.org/), save on the SD card and make it executable (which is a little bit tricky though), for example:
run-as com.mycompck
cd /data/data/com.mycompck/
cat /sdcard/sqlite3 >./sqlite3
chmod 744 ./sqlite3
./sqlite3 ./databases/yourdatabase.db
To answer the first part of your question, check out this answer. Basically, your phone needs to have root access, and you need to run adb in root mode (using "adb root").
As for the second part, I use SQLite Database Browser to view my SQLite dbs (though that's only when the db is on my computer; don't know of any on-device browsers). I don't know of any way to get a human view of content resolvers.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With