techmik67
Newbie
riginally Posted by maerlim
*** 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
adb shell
su
cp /sdcard/settings.db /dbdata/databases/com.android.providers.settings
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
reboot
Disconnect USB from phone. Your phone should be rebooting.
Done! I tested this and was able to install siriusxm.apk from siriusxm.com/android.
*** USB DEBUGGING FIX ***
adb shell
su
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
reboot
I did all that, with a few tweaks here and there, and
Quote:
Originally Posted by techmik67
Ok here it is........... In windows vista ikept getting either two identical non working devicea shown or none in the cmd window. No external sd card in and internal memory set to mounted like usual and debugging on. FINALLY got recognized in cmd by next clicking tray icon to safely remove hardware. Chose to remove the two representing phone and ignored the four representing removable drives. When it said stopped and safe to remove the two icons disappeared in the my computer window. In the cmd window i used adb kill-server and then adb devices and there it was!!! I still had to do it a few x cause adb kept sticking on (2 or more instances running in task manager and the last wont stop) but at last got it done. And after all that i hit reboot and then unplugged the phone. Downloaded a non market app and when i tried to install today it said no non market apps allowed to be installed. Now what?
So after all that i still cant get non market apps and yet when i check the settings.db file in /sdcard, it DOES show a 1 (allow non market). The prob seems to be my adb. It opens multiple times in task manager and freezes. when you unfreeze, it stops 1 instance and goes back to b4 you pressed adb ENTER. and shows device offline now. cant get back online and final instance of adb cannot even be forced closed in task manager. Must hard reboot to fix.
When i use Sideload Wonder Machine, it freezes, but when i force close all but last instance, it works with no errors. If I could just somehow get the settings.db file from /sdcard to /dbdata/databases/com.android.providers.com/ and then i could rn the chmod 777 part i'd be done. Any advice?

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
adb shell
su
cp /sdcard/settings.db /dbdata/databases/com.android.providers.settings
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
reboot
Disconnect USB from phone. Your phone should be rebooting.
Done! I tested this and was able to install siriusxm.apk from siriusxm.com/android.
*** USB DEBUGGING FIX ***
adb shell
su
chmod 777 /dbdata/databases/com.android.providers.settings/settings.db
reboot
I did all that, with a few tweaks here and there, and
Quote:
Originally Posted by techmik67

Ok here it is........... In windows vista ikept getting either two identical non working devicea shown or none in the cmd window. No external sd card in and internal memory set to mounted like usual and debugging on. FINALLY got recognized in cmd by next clicking tray icon to safely remove hardware. Chose to remove the two representing phone and ignored the four representing removable drives. When it said stopped and safe to remove the two icons disappeared in the my computer window. In the cmd window i used adb kill-server and then adb devices and there it was!!! I still had to do it a few x cause adb kept sticking on (2 or more instances running in task manager and the last wont stop) but at last got it done. And after all that i hit reboot and then unplugged the phone. Downloaded a non market app and when i tried to install today it said no non market apps allowed to be installed. Now what?
So after all that i still cant get non market apps and yet when i check the settings.db file in /sdcard, it DOES show a 1 (allow non market). The prob seems to be my adb. It opens multiple times in task manager and freezes. when you unfreeze, it stops 1 instance and goes back to b4 you pressed adb ENTER. and shows device offline now. cant get back online and final instance of adb cannot even be forced closed in task manager. Must hard reboot to fix.
When i use Sideload Wonder Machine, it freezes, but when i force close all but last instance, it works with no errors. If I could just somehow get the settings.db file from /sdcard to /dbdata/databases/com.android.providers.com/ and then i could rn the chmod 777 part i'd be done. Any advice?