*** 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
Command prompt
cd to SDK install directory
cd tools
adb shell
su
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
exit
exit
(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 Database
Click Connect Database
Find settings.db
Expand Tables
Click secure
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
How do you get to the command prompt? And how do you turn debugging on?
can't help you with debugging as I don't have my captivate yet... command prompt is as easy as start >> run >> cmd >> enter, or the faster method I prefer: windows key + r >> cmd >> enter.
The Following User Says Thank You to naxir For This Useful Post:
Device(s): Blackberry Torch
Returned the Captivate...but still interested in it.
Carrier: Not Provided
Thanks: 31
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 think its because Busybox is not installed. But I can't get it to install correctly. from what I have read the cp command is not built into adb shell.
Just FYI I dunno if I messed something else up but no matter what I do I can't get out of USB Debugging mode. I unselect the box hit home key go back in and its reselected.
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..
Connect USB to phone with USB Debugging ON
Command prompt
cd to SDK install directory
cd tools
adb shell
su
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
That will fix your phone 100%.
Last edited by YellowGT0; July 19th, 2010 at 10:56 AM.
The Following User Says Thank You to YellowGT0 For This Useful Post:
I just wanted to post that I followed the instructions from the OP *with* the additions from YellowGT0 and I'm not having any problems leaving USB Debug mode.
Also for anyone trying this it's:
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
^
Needs the space between chmod and 777
* Also I used the app linked in the OP as well and had no problems installing it, so mission: accomplished I'd say
Last edited by Zilch; July 18th, 2010 at 04:30 PM.
Is there something else you need to do after the chmod 777 /dbdata/databases/com.android.providers.settings/settings.db?
Everything else worked fine, got root, installing non-market apps but still stuck in debug mode... Don't want to reset after I spent all day configuring her...
Thanks in advance!
Sorry for the confusion... Followed the steps a couple more times and it took. I look to be good to go.
Thanks to Maerlim! and to Yellow and Zilch for rounding it out...
Last edited by psolk; July 18th, 2010 at 09:08 PM.
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.