Database Users

Rooted, can I now sideload?

I am rooted with the Liberated ROM and using unrevoked tool. I tried sideloading an app I downloaded from my phone's browser and it said the phone was still locked outside of the marketplace apps. Am I doing something wrong?
Thanks

if windows and assuming you have installed the Android SDK, rename the SDK folder to simply c:\android
then run this little batch file (save it via notepad as whateveryouwant.bat), alternatively execute line by line the commands below
cd\android\tools
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
pause 1
adb reboot

You need to enable sideloading separately. Refer to this post, specifically the section entitled "Also, enable installation of non-Market (untrusted) apps (sideloading)."
http://forum.xda-developers.com/showpost.php?p=6906288&postcount=2

kaschenberg said:
I am rooted with the Liberated ROM and using unrevoked tool. I tried sideloading an app I downloaded from my phone's browser and it said the phone was still locked outside of the marketplace apps. Am I doing something wrong?
Thanks
Click to expand...
Click to collapse
NOTES:
You MUST have root access on the phone in order for this to work
You must have the tools directory from the Android SDK installed.
sqlite3 is included in the Android SDK tools, so this would be the best way:
Windows:
Enable USB debugging (settings > applications > development > USB Debugging)
From the command prompt, change to the sdk/tools directory.
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo select value from secure where name = 'install_non_market_apps';|sqlite3 settings.db
If the last command returns 1, then your change is successful.
Linux/OS X
Enable USB debugging (settings > applications > development > USB Debugging)
From a superuser command prompt, change to the /sdk/tools directory
./adb remount
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
./adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "select value from secure where name = 'install_non_market_apps';"|./sqlite3 settings.db
If the last command returns 1, then your change is successful.
Reboot phone and sideloading works. (thanks fluffyarmada)

xdafly said:
if windows and assuming you have installed the Android SDK, rename the SDK folder to simply c:\android
then run this little batch file (save it via notepad as whateveryouwant.bat), alternatively execute line by line the commands below
cd\android\tools
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
pause 1
adb reboot
Click to expand...
Click to collapse
worked perfectly! thanks for that! i just ran line for line in cmd prompt and i can now sideload just fine on the phone. now, just need to find apps to sideload!!! already installed swype and tried the wifi tether thing, but after that, i dont know what else to load up! i guess its back to more forum searching. but thanks so much!

sorry for the noobish question...
is sideloading the same as installing and running apps from the SD card? and, i have also heard that if you run anything from the SD card, you should go with a Class 6 SD.
im holding off on the root for now... but these are some of the few questions i had in regards to it

jbizz said:
sorry for the noobish question...
is sideloading the same as installing and running apps from the SD card? and, i have also heard that if you run anything from the SD card, you should go with a Class 6 SD.
im holding off on the root for now... but these are some of the few questions i had in regards to it
Click to expand...
Click to collapse
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.

attn1 said:
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.
Click to expand...
Click to collapse
cool deal, wasnt for sure or not. i have a Patriot 8gb Class 4. so in any case, im still good. looking forward to rooting my phone in a week or 2.

attn1 said:
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.
Click to expand...
Click to collapse
In anticipation of this I just purchased a 16gig sd card sound...can't wait...
Sent from my HTC Aria using XDA App

attn1 said:
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
COMMON
Enable USB debugging (settings > applications > development > USB Debugging)
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Reboot phone and sideloading works. (thanks fluffyarmada)
Click to expand...
Click to collapse
I have an HTC Aria, rooted with Clockwork, an 003 rom version installed.
The annoying AT&T startup was replaced as stated elsewhere, yet I see the AT&T files it was suppose to delete are still present.
(Debugging in Settings is on, and signature verification is off in Clockwork)
I'm unclear why the AT&T files still remain after running the 003 rom, or how to manually remove them.
More importantly...
I'm confused on what the step by step means are to get my Aria to accept unapproved apps.
Exactly how do I make the modifications you posted to allow non-Market apps to be installed on my Aria?
After installing Adroid SDK, ran Sqlite3.exe, and typed in this on my Windows Vista pc -
sqlite> adb remount (enter)
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db (enter)
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db (enter)
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db (enter)
I then x'ed out of Sqlite and rebooted the Aria.
I obviously missed something, because after downloading a non-Market app to the Aria successfully, when I clicked to install it, I'm still getting the same message that it's not allowed.
What do I need to correctly make the code work???

Best solution I could find for installing non market apps. http://forum.androidcentral.com/showthread.php?p=236589#post236589

I've worked on this a few hrs now. I got Clockwork Recovery to work. Figured out HTC Sync was reverting the phone to stock recovery somehow. Removed that though...
Have rerun Unrevoked, and I can get into clockwork. I'm not interested in changing to different ROM now, just removing ATT crap.
When I try sideloading instructions/alternate method for removing ATT stuff, I get an error in cmd:
C:\android\tools>adb remount
remount failed: Operation not permitted
adb devices returns:
List of devices attached:
<myserial#> device
Any ideas? Have I not completed the root access procedure? I thought it was part of the Unrevoked process.

attn1 said:
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
COMMON
Enable USB debugging (settings > applications > development > USB Debugging)
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Reboot phone and sideloading works. (thanks fluffyarmada)
Click to expand...
Click to collapse
Remember to run all this from within the android-sdk-linux_86/tools directory. For users that have modified their path, adb can be run from anywhere, but these commands won't work properly.
Thanks for the guide! Seems to have worked properly.

Great! The problem was the drive. I had to cd to the device drive (h: in my case) to get it to find the files. Thanks again.
I got the Swype apk, installed it, and it's working perfectly!

Quick question. Does the phone have to be operating in a boot mode via Clockwork OR on and operating normally when you do this. Once connected via USB does it have to be set for Charge only, Sync, or Disk drive when this is done. I know it should be set for USB debugging. My phone is rooted but still has the original ROM. I am getting a permission denied error when I run the adb remount command.

attn1 said:
NOTES:
You MUST have root access in order for this to work
You must have the tools directory from the Android SDK installed.
sqlite3 is included in the Android SDK tools, so this would be the best way:
Windows:
Enable USB debugging (settings > applications > development > USB Debugging)
From the command prompt, change to the sdk/tools directory.
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo select value from secure where name = 'install_non_market_apps';|sqlite3 settings.db
If the last command returns 1, then your change is successful.
Linux/OS X
Enable USB debugging (settings > applications > development > USB Debugging)
From a superuser command prompt, change to the /sdk/tools directory
./adb remount
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases settings.db
Optional test for success:
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "select value from secure where name = 'install_non_market_apps';"|./sqlite3 settings.db
If the last command returns 1, then your change is successful.
Reboot phone and sideloading works. (thanks fluffyarmada)
[/list]
Click to expand...
Click to collapse
anybody could translated in to normal language for people who is not in familiar with computer??

can't push settings.db
I've got a problem! I'm able to pull settings.db and make the change. But when I try pushing it back onto the phone, all it does is print the help screen. I've got an htc aria and am using ubuntu. Thanks!

ctoacsn said:
I've got a problem! I'm able to pull settings.db and make the change. But when I try pushing it back onto the phone, all it does is print the help screen. I've got an htc aria and am using ubuntu. Thanks!
Click to expand...
Click to collapse
I figured out my problem. The instructions for linux say
Code:
adb push settings.db /data/data/com.android.providers.settings/databases settings.db
when it should be
Code:
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
There was a space, instead of / between databases and settings.db

http://de.codeplex.com/

getting error:
adb remount
remount failed: Operation not permitted
when trying to set the sideloading as mentioned by attn1.
inWindows Vista, after rooting using unrevoked process.
Note that I have both the SU app showing up in All apps on phone and the ClockworkMod and ran adb from the \tools directory.
Anyone know what the problem is?

Installed Liberated ROM still can't sideload

Hello All,
I just managed to Root (via unrevoked3) and Flashed my ROM (liberated_aria_b005_signed.zip) using ROM manager and I am still unable to side load apps. Under Applications > "Allow installation of Non-Market Applications"
Any ideas? Perhaps I did something wrong in the process.
All the bloatware is gone, the splash screen from AT&T is no longer there and all my settings were intact.

shibed said:
Hello All,
I just managed to Root (via unrevoked3) and Flashed my ROM (liberated_aria_b005_signed.zip) using ROM manager and I am still unable to side load apps. Under Applications > "Allow installation of Non-Market Applications"
Any ideas? Perhaps I did something wrong in the process.
All the bloatware is gone, the splash screen from AT&T is no longer there and all my settings were intact.
Click to expand...
Click to collapse
Just flashing the ROM does not enable sideloading. The instructions to enable this are here in one of the Aria threads.

assuming Android SDK is downloaded and the android-sdk-tools folder is renamed to simply android
save the following into a small batch file and open a cmd window and run it
...
cd\android\tools
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
pause 1
adb reboot

download and instal R012, you can enable the sideloading through settings>application

Install 3rd party apps on stock, rooted Aria

Since it took me over an hour to finally get this to work, I figured I would make a new post. (That's a long time to just change a 0 to a 1)
If you want to use your stock Rom but are rooted then this is the easiest way to be able to install non-market apps. I take no credit for this as it is from a post from Attn1 (thanks!).
HTC Sync does not have a choice to add apps in the latest version that I have, I don't know if did before, but I could not get it working. We can all thank AT&T
for this!
Put your phone into Recovery mode.
Goto advanced>mount system and mount data.
Make sure your phone is recognized by adb devices in
your Terminal program.
If not you can use adb kill-server then adb start-server
If you're using linux then you need to precede the adb command
with ./adb
Follow the directions below and you will installing non-market apps
in no time.
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
* COMMON
* Enable USB debugging (settings > applications > development > USB Debugging)
* adb remount
* adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
* echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
* echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
* adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
* Reboot phone and sideloading works. (thanks fluffyarmada)

Yes!!! Thank you, this worked! Rooted, stock HTC Aria 2.2.2.
The only problem I had was that sqlite3 was in the "tools" folders, so I had to copy it into "platform-tools."

Side load wonder machine
Sent from my SAMSUNG-SGH-I897 using XDA App

thankz dude..it's work
my thumb is for u

How to prevent update/block update

I've been reading a couple of threads on preventing OTA updates and can't seem to figure it out. I'm more interested in the sqlite & ADB method from this thread (http://forum.xda-developers.com/showthread.php?t=933291). I read this thread about 10 times over and over but can't seem to get it to work. Can someone that's knowledgeable please put instructions that an idiot like me can follow?
I have a rooted NC with firmware 1.2.
1. I've downloaded sqlite3 and nookcolor-easyADB to my PC.
2. I've extracted nookcolor-easyADB and install the install.vbs file.
3. Connected my NC to my PC via USB cable
4. My PC recognizes my NC and the microSD card as a different drive.
i followed the following steps from the thread and nothing works:
***************************************************************
Attached is a working sqlite3 binary.
Copy it to /system/bin
(I transfered it to my SD, then used rootexplorer (mount R/W) to copy into /system/bin))
you will now be able to edit sqlite databases on the nook itself.
--------------------------------------------------------------------------------
Attached Files sqlite3.7z (11.9 KB, 56 views)
--------------------------------------------------------------------------------
In your terminal:
$ adb pull /data/data/com.bn.devicemanager/databases/devicemanager.db devicemanager.db
$ sqlite3 devicemanager.db
sqlite> update registry set value='manual' where name='com.bn.device.fota.mode';
sqlite> .q
$ adb push devicemanager.db /data/data/com.bn.devicemanager/databases/devicemanager.db
$ adb reboot
Congrats Your NC is now permanently blocked from any future BN OTA auto updates.
No more build.prop spoof hacks for each release (sideload only),,,,,, yada yada
***************************************************************
Questions:
should I create a directory in my PC (C:/windows/system/bin) and copy sqlite3 to the /bin folder or copy sqlite3 to my microSD card and insert it into my NC?
Please be very elementary in your answers (as you were explaining it to your 6 year old). Thanks in advance.

There is a free version of SQLite with graphic user interface that allows you to change the fota field from "auto" to "manual". Do a search of title only for "block" and you should find it.

crazyasian2 said:
I've been reading a couple of threads on preventing OTA updates and can't seem to figure it out. I'm more interested in the sqlite & ADB method from this thread (http://forum.xda-developers.com/showthread.php?t=933291). I read this thread about 10 times over and over but can't seem to get it to work. Can someone that's knowledgeable please put instructions that an idiot like me can follow?
I have a rooted NC with firmware 1.2.
1. I've downloaded sqlite3 and nookcolor-easyADB to my PC.
2. I've extracted nookcolor-easyADB and install the install.vbs file.
3. Connected my NC to my PC via USB cable
4. My PC recognizes my NC and the microSD card as a different drive.
i followed the following steps from the thread and nothing works:
***************************************************************
Attached is a working sqlite3 binary.
Copy it to /system/bin
(I transfered it to my SD, then used rootexplorer (mount R/W) to copy into /system/bin))
you will now be able to edit sqlite databases on the nook itself.
--------------------------------------------------------------------------------
Attached Files sqlite3.7z (11.9 KB, 56 views)
--------------------------------------------------------------------------------
In your terminal:
$ adb pull /data/data/com.bn.devicemanager/databases/devicemanager.db devicemanager.db
$ sqlite3 devicemanager.db
sqlite> update registry set value='manual' where name='com.bn.device.fota.mode';
sqlite> .q
$ adb push devicemanager.db /data/data/com.bn.devicemanager/databases/devicemanager.db
$ adb reboot
Congrats Your NC is now permanently blocked from any future BN OTA auto updates.
No more build.prop spoof hacks for each release (sideload only),,,,,, yada yada
***************************************************************
Questions:
should I create a directory in my PC (C:/windows/system/bin) and copy sqlite3 to the /bin folder or copy sqlite3 to my microSD card and insert it into my NC?
Please be very elementary in your answers (as you were explaining it to your 6 year old). Thanks in advance.
Click to expand...
Click to collapse
1. Go here and get the sqllite browser and throw it in a directory on your pc.
2. Use adb and pull the database file from your nook to your pc (like the instructions you quoted).
3. Use the sqllite browser and make the changes and save them.
4. Use adb and push the file back to your nook.
5. Reboot your nook
6. Enjoy being free from updates.

Here's the idiot's guide that worked for me:
1. Go download the following 2 files:
nookcolor-easyADB.zip
sqlitebrowser_200_b1_win.zip
2. Extract “nookcolor-easyADB.zip
this will create a file “.android” in the following directory C:/Users/your_user_account
extract “sqlitebrowser_200_b1_win.zip” anywhere
3. Connect your NC to your PC via USB port.
4. Open the command prompt (it’s in your program, accessories directory)
You should have a prompt that looks like this – C:\Users\your_user_name>
5. Type the following command:
adb pull /data/data/com.bn.devicemanager/databases/devicemanager.db devicemanager.db
This command will go grab the file “devicemanager.db” from your NC and place it in the following location: C:/Users/your_user_account on your PC.
6. Now go to the directory where you extracted “sqlitebrowser_200_b1_win.zip” and double click on the file “SQLite Database Browser 2.0 b1.exe”. This will run the browser that will allow you to open the file “devicemanager.db” and edit it.
7. In the browser click file/open database. It should automatically take you to where the file “devicemanager.db” is located. Select that file.
8. Click on the “Browse Data” tab.
9. Click on the “Table:” pull down menu and click on “registry’.
10. If you look at line 7, all the way to the right is the “value” column it should say “auto”.
11. Double click on “auto” and another window will pop up.
12. Change the word “auto” to “manual”.
13. Click on “Apply changes” and close the window.
14. Click on “save” button on the top left and close the browser.
15. Go back to the command prompt and type the following:
adb push devicemanager.db /data/data/com.bn.devicemanager/databases/devicemanager.db
This command will push the file “devicemanager.db” from your PC back to your NC with the updated file.
16. Type the following command to reboot your NC:
adb reboot
DONE!

I would think the simplest method, using materials you should be halfway familiar with from rooting, is to install ClockworkMod Recovery to your NC. I know it will stop the update from installing, but I'm not sure if the update would quit trying to install.
The simplest ways to get CWM on your NC are:
1) get the ROM Manager app and "Flash ClockworkMod Recovery"
2) if you have a CM7 sdcard, it probably already has ROM Manager, and flashing from there will also install CWM to your internal recovery.

Taosaur said:
I would think the simplest method, using materials you should be halfway familiar with from rooting, is to install ClockworkMod Recovery to your NC. I know it will stop the update from installing, but I'm not sure if the update would quit trying to install.
The simplest ways to get CWM on your NC are:
1) get the ROM Manager app and "Flash ClockworkMod Recovery"
2) if you have a CM7 sdcard, it probably already has ROM Manager, and flashing from there will also install CWM to your internal recovery.
Click to expand...
Click to collapse
This is my thinking as well. B&N tried pushing the update to me and a coworker yesterday. CWR blocked it as expected. Rebooted and all is well. As you mentioned, time will tell if B&N will continue to try to push v1.3 to me. If it becomes obnoxious, I may go this route.

Can't find GoKeyboard.apk anywhere on nook

I have browsed my nook's file system for a while now and I can't seem to find anything related to go keyboard. I reinstalled it a few times, and it runs, but to enable it the apk must be in /system/app. Go keyboard tells me to go to settings->language and keyboard, then enable go keyboard, but that doesn't exist.
Please help? The only fix I can find for the broken android keyboard is installing another one, but it just doesn't work.

Different tools may enable settings for IME selection.
If you want to do it manually, you can use the method below.
I don't know what the package is for Go Keyboard, so I list my NullKbd package.
Code:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
sqlite3 settings.db
update secure set value='com.android.inputmethod.latin/.LatinIME:com.temblast.nullkbd/.NullKeyboard' where name='enabled_input_methods';
update secure set value='com.temblast.nullkbd/.NullKeyboard' where name='default_input_method';
.q
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

Thanks!
I checked the package name when it was running, and it was com.jp.gokeyboard. Should I replace null with that?

After installing, you should find the installed .apk under /data/app. Just move that to /system/app and reboot. You should then be able to set it as your default using NookTouch Tools.
I had Go Keyboard installed in this manner, but have since replaced it. Sorry, but I don't recall the full .apk name.

Thanks for your help. I will look around in /data/app for the apk.
Question: What file browser do you use? I can't seem to browse /data with mine.

Root Explorer or ES file manager (in ES in the settings you have to tick to make system rewritable)
Sent from my MB526 using xda premium

brendan10211 said:
I checked the package name when it was running, and it was com.jp.gokeyboard.
Click to expand...
Click to collapse
You did? It's actually jb. To be exact, com.jb.gokeyboard/.GoKeyboard
Code:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
sqlite3 settings.db
update secure set value='com.android.inputmethod.latin/.LatinIME:com.jb.gokeyboard/.GoKeyboard' where name='enabled_input_methods';
update secure set value='com.jb.gokeyboard/.GoKeyboard' where name='default_input_method';
.q
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

Renate NST said:
You did? It's actually jb. To be exact, com.jb.gokeyboard/.GoKeyboard
Code:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
sqlite3 settings.db
update secure set value='com.android.inputmethod.latin/.LatinIME:com.jb.gokeyboard/.GoKeyboard' where name='enabled_input_methods';
update secure set value='com.jb.gokeyboard/.GoKeyboard' where name='default_input_method';
.q
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Click to expand...
Click to collapse
Glad I didn't actually do anything yet! thanks

Sorry for double post..
But obviously I got it working. Thanks guys! Now to search for hackers keyboard.
Edit: can't seem to search market. How does one do searchmarket?
Sent from my NOOK

*poke*
Wait why do I ... crap i just.. never mind
i suck at this