Database Users

I'm rooted but

I still cant install blocked sources. I keep getting that message "install blocked", and I changed the install_non_market_apps field as well. I cant install apps from my sd card or from websites still. Is there a custom rom I can flash that would include "unknown resources" so you can select it.

SysAdmNj said:
I still cant install blocked sources. I keep getting that message "install blocked", and I changed the install_non_market_apps field as well. I cant install apps from my sd card or from websites still. Is there a custom rom I can flash that would include "unknown resources" so you can select it.
Click to expand...
Click to collapse
How did you change the field?
On a properly rooted ROM,
Start android, enable usb debugging. Stay in Android.
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
reboot
there will be no toggle, but you will be able to sideload with Astro of another equivelent file manager.

attn1 said:
How did you change the field?
On a properly rooted ROM,
Start android, enable usb debugging. Stay in Android.
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
reboot
there will be no toggle, but you will be able to sideload with Astro of another equivelent file manager.
Click to expand...
Click to collapse
I tried that method you just posted, and just tried again. Waiting for reboot, and you meant adb reboot?
I also used droid explorer and ran sql commands to update the file, it seemed to have taken that way but when I tried to install an app from the sd card using app installer it failed.
Ok I used astro and now it installs. Can I install from a website?
Thanks.

SysAdmNj said:
I tried that method you just posted, and just tried again. Waiting for reboot, and you meant adb reboot?
I also used droid explorer and ran sql commands to update the file, it seemed to have taken that way but when I tried to install an app from the sd card using app installer it failed.
Ok I used astro and now it installs. Can I install from a website?
Thanks.
Click to expand...
Click to collapse
You can install any way any other Android can now.
note: if you do a wipe, you'll need to do this step again with these AT&T roms.

confirmed this working on attn1 liberated beta, my brother is super extatic now heheh no droid explorer anything needed just download apk and install bam!

just cant get it to work
i have tried this method a few time but i always get an error:
error: incomplete SQL: update secure set value = 1 where name = `install_market_apps';

try this, save a whatevername.cmd file into the sdk folder, in my case \android\tools
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

just cant get it to work
i may sound dumb here but how do u make .cmd file...
also the error message only appears after i type in this command:
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
heres wat i see: " error: incomplete sql: update secure set value = 1 where name = `install_non_market_apps'; "
your help is appreciated

open notepad (start,run,notepad)
type the commands (copy paste) and save the file into \android\tools (provided that is where you have the SDK)
name the file whateveryouwantocallit.cmd (give it any name you want)

thnx xdafly makin tat cmd file worked perfectly....

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?

Aria, Rooting, Ubuntu Live Method, Problems?

So I tried rooting my Aria using shad0wfox's Ubuntu live method.
http://forum.xda-developers.com/showpost.php?p=7449486&postcount=1
Everything went really smooth.
Booted up Ubuntu.
Downloaded the recovery.
Followed Recovery instructions.
USB debugging was ON.
Plugged in phone and selection was on CHARGE ONLY.
Recovery restarted my phone.
Left me in the Clockwork with like 7 options. I chose Reboot phone now.
Rebooted successfully, but I still cannot sideload apps/live wallpapers. I get the "Third party apps have been blocked for your security" message.
Things that went differently from shad0wfox's method.
1. Recovery automatically started up. I didn't have the option to open as Root, and it also automatically unzipped itself.
2. I'm pretty sure my phone only rebooted once, when it says it supposed to twice.
3. When I plugged up my phone, I didn't even have time to press charge only, it just automatically started the process.
Anyone else have this problem? Did I do something wrong? Is there an easier method of Rooting? Thanks in advance.

I'm not sure if you're still having this issue, but if you are revisit shad0wf0x's thread as there are now directions in there for enabling 3rd party apps. One thing to note is that you'll need to install the apps with a program like Astro File Manager.
I just went to his thread and copied the directions for enabling 3rd party apps. Note that you need to be in the tools sub-folder in the Android SDK folder. Make sure USB Debugging is on and you're set to charge only.
Code:
sudo su
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
adb reboot

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

[Q] Can't Side Load Apps on Root NST Glow

I recently rooted my Nook Simple Touch Glow and when I try to side load apps through dropbox I get an error "Install Blocked; For security reasons you phone is set to block installation of applications not sourced in the Android Market."
I've read up and there should be a check box in the applications menu that allows unknown sources. The trouble is there is no applications menu.
Any idea on how to fix this?
Thanks in advance!

If you have sqlite3 on your desktop or your Nook, you can just do:
Code:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
sqlite3 settings.db
update secure set value=1 where name='install_non_market_apps';
.q
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

Sqlite
I haven't used Sqlite before. I downloaded it. Do I just run the text you posted in the dos box?
Also, do I need to have the nook attached through usb?

Well, you have to have ADB working however you use ADB.
That's either WiFi or USB.
The quoted code is normally what you enter.

check in dos box that you have sqlite3 command available. Also you need working android debug bridge (adb) working, through wifi or usb, in your case it would probably be through wifi. I do not recommend you to continoe unless you learn something about adb and make it work. (search forum or use google)
the rest is piece of cake. first (adb) command from #2 downloads one database from nook. Another 3 commands opens that database locally, changes the security setings that enables installation of non-market application and quits sqlite3 client.
last command uploads the changed database back to nook.

ADB?
Thanks for getting back to me. Unfortunately, I really don't know what ADB is.
I haven't used any of these tools. Can you give me a little more detail? I'd hate to make a mistake and screw something up.
Thanks again!
Mark

Sqlite
Thanks for the instructions. I was able to turn on the ADB bridge using adbWireless and connect the device.
I'm confused about the command line in SQLite3. I entered everything as listed, but nothing happens. I don't want to copy over the settings.db until I know it has been changed.
What should SQLite say if I have entered in the command properly?
Thanks again

Code:
sqlite3 settings.db
update secure set value=1 where name='install_non_market_apps';
select value from secure where name='install_non_market_apps';
.q
As you can see I have added one 'select' command into sql section. If your database has been updated properly, select command should print new value 1 (before zero).
I have written this command right now, don't have a chance to test it but it should work.. at least it cannot screw up anything.

Sqlite
I'm entering everything as is and either I get
...> with nothing after it
or
Error: near "sqlite3": syntax error.
In either case, the select command does not tell me if it is updated.
Again, sorry for asking so many times. I'm close!!

Sqlite
I figured out what I was doing. I opened the SqLite window separately when it should have all be in the one cmd window.
So what exactly did this do? I keep getting the same error message that it can't install non market apps. Is there a menu setting I should change?
Thanks again

Got it
Just rebooted and now it's working. Thanks!!

A simpler way to do this, assuming you've used something like GlowNooter and is to go into Nook Color Tools and uncheck and recheck the Non-Market Installs. This will allow you to sideload.