*** Standard Disclaimer: I AM NOT RESPONSIBLE FOR ANY DAMAGE TO YOUR PHONE IF SOMETHING GOES WRONG WITH THIS PROCEDURE.
THE PROBLEM WITH USB DEBUGGING HAS BEEN FIXED. THIS PROCEDURE SEEMS PRETTY SAFE NOW. ONLY FURTHER TESTING WILL TELL FOR SURE.
IF YOU PERFORMED THIS PROCEDURE PREVIOUSLY AND YOU HAVE USB DEBUGGING STUCK ON, SKIP TO WHERE YOU SEE *** USB DEBUGGING FIX ***. ***
You'll need the Android SDK (guide to download and install is here)
You'll need the USB drivers (Stickied post in this forum)
You'll need root access (look for the Captivate Root thread by chaoscentral)
You'll need Busybox (available on the market after you root the phone)
Connect USB to phone with USB Debugging ON
cd to SDK install directory
cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db
cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db.backup
(This should bring you back to your windows command prompt.)
adb pull /sdcard/settings.db %userprofile%\desktop
(This should copy the settings.db to your desktop in Windows. Keep your cmd window open, you'll need it again.)
Install SQLite Manager Plugin for Firefox
Open SQLite Manager Plugin within Firefox (Tools->SQLite Manager)
Click Connect Database
Scroll down to ID 6, "install_non_market_apps". Double-click.
Change value ( TEXT ) from 0 to 1
Close SQLite Manager
(Back to that cmd window)
adb push %userprofile%\desktop\settings.db /sdcard
Device(s): Blackberry Torch
Returned the Captivate...but still interested in it.
Carrier: Not Provided
Thanked 16 Times in 13 Posts
I get cp not found also. and yes i did adb shell first.
You might want to add that when you type SU, it prompted me on my phone to grant unknown app super user access. But I can't get past the cp unknown
OHHH CMD on windows... I thought it was like console on the phone or something DUH lol
This is what I get when I try to install the SDK
Failed to fetch URL https://dl-ssl.google.com/android/repository/repository.xml, reason: HTTPS SSL error. You might want to force download through HTTP in the settings
If you get the same error go to settings and select force HTTP :-)
Last edited by YellowGT0; July 17th, 2010 at 07:28 PM.
I've updated the original post. It looks like that USB Debugging problem is a byproduct of this procedure. A factory reset will repair the problem. (Settings->Privacy->Factory data reset) I hope to have a fixed procedure up sometime tonight.
You know at first I thought I was stuck in debug, I couldn't bring up settings at all, I was about to hit the factory reset and thenwent into settings and it was all there. Turned off USB debug seems to be fine.
And after I rebooted again, my phone is freezing on the Galaxy S bootup screen, and then shutting off. When I try to hold down the volume button down, and the power button to do a hard restore, it doesn't work..
I have a feeling one of my problems was changing USB debugging on and off so much in the original procedure, which got the settings.db confused while it was being copied and edited. I'm going to try to simplify and see what happens.
Edit: The chmod 777 was the trick. I'm updating the original post. Thanks YellowGT0!
Last edited by maerlim; July 18th, 2010 at 10:14 PM.
I have a feeling my problem was changing USB debugging on and off so much in the original procedure, which got the settings.db confused while it was being copied and edited. I'm going to try to simplify and see what happens.
Simpler way is to use Root Explorer and just edit the file on PC and transfer it back.
Even though after I did that, I can't get my phone to power on now... Lovely.
Yeah I've run into this issue before. I think it has to do with windows when you copy a file it puts permissions as read only. Only works for some files though. Database files might be one of them. Im using Windows7 anyone with XP or before have this issue?
Yeah, how's that Root Explorer method working for ya?
I used root explorer and followed the method listed on xda-developers and it worked perfectly fine for me. Took less than a minute.
I used root explorer to copy the settings.db file from the original folder to the sdcard. Then plugged phone into computer via usb. Mounted the sdcard. Used sqlitestudio to modify the one value. Unmounted and disconnected the phone from the computer. Used root explorer to copy or move that modified settings.db file from the sdcard back in to its original folder. Root explorer asked if I wanted to overwrite the existing file, said yes. Done. Rebooted phone and it worked. Tested by downloading some cheesy free game .apk from slideme.org. It installed and played perfectly.
Stuck at "cp: not found". Downloaded busy box from the marketplace, opened it. It said "Status: Waiting...", so I hit install. Now it says "Status: Done!" Below that it says "Your phone is rooted. Busybox was found here: /system/xbin". Seems like it's installed? But still getting "cp: not found"
Edit: Uninstalled busybox, redownloaded it, opened it and hit install again, and "cp" was working fine, not sure what the problem was the first time. Got it all working and sideloading with ease.
Last edited by mjgunn; July 19th, 2010 at 11:49 PM.
Nope, well kinda. Most Android devices have an option in settings to allow or disallow non-market apps. I have non-market apps working and installable, but I'm just wondering if there is a way to get the setting to show up.