yashsingh1/xdaforums huggingface dataset:
[Nook Color Android Development] Novaglarion:
just use

sqlite3 settings.db ".dump"

and then scroll down and look for INSERT INTO "secure" VALUES(4,'install_non_market_apps','1'); you want a 1 there at the end.

look in your tools folder for the settings.db file and check the modified by time and make sure the change you are making is made.

To clarify if there's a misunderstanding the path info and text before the > in the commands is just what you would see in your command prompt. the actual commands are after the >. These are the actual commands.

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

What command did you have to alter?

also, maybe try

adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

to push... I didn't have any problem with the other command and both appear to work for me.
[Nook Color Android Development] barrosd12:
Oh none, your commands worked awesomely, I just had to yank the folder designations that were there, which you've now done for everyone, so thanks!

I think it might be a problem somewhere else, I'm re-doing everything right now, I'll let everyone know
[Nook Color Android Development] lovelacer:
Ran these commands again with the additional adb push and still no dice. I checked to see that the db entry had been updated and it correctly has the install non market apps set to 1. I'm using root explorer as well I'll try estrongs as you have. Thanks for the help.
[Nook Color Android Development] barrosd12:
Confirmed now that SlideMe is not the issue - the settings are all correct on the PC, I can't confirm these settings for the NC. I tried re-adb-pushing and still no cigar here either. I'm getting app rejections from any source, downloaded on the NC and the SD card. Any idea what could be wrong?
[Nook Color Android Development] barrosd12:
Ok, definitely isolated the problem now.

I pull the settings from the NC, modify them, and everything works great, then it refuses to push it back, but says it succeeds, or something to this effect, because whenever I pull the file back from the NC, it says value=0
[Nook Color Android Development] Novaglarion:
Not sure, I've got it working using this method on 3 different NCs myself. The only thing i can think of is that i had already installed estrongs file manager and a few other games before doing it. Maybe try using adb to install estrongs or astro and see if it will let you then.

estrongs i'm using: www mediafire com ?sxw6adfzvyp250m

astro: www mediafire com ?05scsbrnx2wfw4v
[Nook Color Android Development] barrosd12:
Thanks for the file links - I'll give them a try, I really think the problem though is that the NC keeps resetting the value I push back for the non-market apps. I have no idea why it's doing this...:confused:
[Nook Color Android Development] Novaglarion:
try pulling it back right after pushing the modified one, before rebooting, and see if it's even pushing correctly at all. If it is then being reset on reboot i don't know what the issue is.
[Nook Color Android Development] boret:
Novaglarion, I am not able to do it either.

When you say "reboot", is that the same as power off and on?
[Nook Color Android Development] Novaglarion:
yes, the same.
[Nook Color Android Development] bular211:
make sure you're pushing the modified db file to /data/data/com.android.providers.settings/databases not to /data/data/com.android.providers.settings

it needs to be in the databases folder so it overwrites the original
[Nook Color Android Development] Novaglarion:
DAMN YOU!!!! such a simple thing and i missed it! You are correct. I'll update the original commands. Thanks for the good catch there.
[Nook Color Android Development] barrosd12:
Ok, this was definitely the problem. Thanks a lot, you guys!
[Nook Color Android Development] boret:
Yeah! That worked!

Thanks guys!
[Nook Color Android Development] HotShotAzn:
Was there a settings.db file at /data/data/com.android.providers.settings? I accidentally pushed there the first time (I think).
[Nook Color Android Development] essgeewhy:
Worked like a champ.... Thanks so much.
[Nook Color Android Development] sudermatt:
C:\android-sdk-windows\tools>adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db

C:\android-sdk-windows\tools>sqlite3 settings.db

sqlite> update secure set value=1 where name='install_non_market_apps';

sqlite> .q

C:\android-sdk-windows\tools>adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

Did not work for me....everything looked to execute fine...I tried to install an app using astro...no dice...
[Nook Color Android Development] Novaglarion:
No, this was my fault. A typo in the instructions.
[Nook Color Android Development] ojo8:
It works! I followed your instructions exactly and got it to work the first time. The new apps don't show up after install though. I don't understand what you mean by "restart the homescreen". The only way I get the new apps to show up is with a reboot.
[Nook Color Android Development] godsfilth:
install a task killer after installing apps kill the applauncher process, astro has a decent task killer

or install ADW.Launcher or Launcher pro apps will show instantly
[Nook Color Android Development] th3c1am:
Sorry I am a noob and rooted my nook via the instructions for Mac OSX since that is what I am working on. I don't know how to do any of this thank god for the detailed instuctions to root on the Mac thread. Can someone please post how to do this for Mac OSX for a noob please???
[Nook Color Android Development] sudermatt:
got it to work

I got this to work after the second try.

Maybe it just takes two tries.

But wow...what a difference this makes....I suggest everybody do this.
[Nook Color Android Development] blamejake:
Works fine! Thanks!
[Nook Color Android Development] wpnyc2009:
Works Great!

This works like a charm. I'm still trying to get full Root as well.
[Nook Color Android Development] KCHASE731:
im getting an error that the remote object does not exist. i browsed with astro and the data folder is empty.

any ideas?

i got it figured out

i took off the "/" infront of the first /data/data...

made it data/data/com....

that worked
[Nook Color Android Development] PrinceMike:
settings.db Question

When attempting to make this change, I accidentally ran the

C:\android-sdk-windows\tools>adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db

command twice. This caused the androidsdk/tools/settings.db file on my pc to increase in size. That seems reasonable, but then I was worried about writing a messed up file back to the nook. So I deleted the pc copy and pulled the file again. This time the file was smaller in size than it was originally. I'm completely new to using the android sdk and adb, so can anyone confirm whether or not it is safe to perform this mod on my nook color now? Does the code work in such a way that the local settings.db will in fact increase in size each time I pull the file but only the data needed is used by the nook once it's put back? Did I loose some crucial data when I deleted the settings.db from my pc? Should I reinstall, the androidsdk?

Just trying to avoid bricking my nook, thanks for your help.

MRH
[Nook Color Android Development] rluzania:
THANK YOU MUCH! i got this working on a mac. it's the same as the windows version.

in termainal...

adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db

sqlite3 settings.db

sqlite> update secure set value=1 where name='install_non_market_apps';

sqlite> .q

adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

the settings.db file gets pushed into the root of your home folder on the mac. (at least for me it was)
[Nook Color Android Development] cal3thousand:
Is the settings file different per user?

If not, can someone just post the edited file?
[Nook Color Android Development] Epicrean:
This isn't working for me... Here is what I am getting

android-sdk-windows\platform-tools>adb pull /data/data/com.android.providers.

settings/databases/settings.db settings.db

1344 KB/s (21504 bytes in 0.015s)

C:\android-sdk-windows\platform-tools>sqlite3 settings.db

'sqlite3' is not recognized as an internal or external command,

operable program or batch file.

C:\android-sdk-windows\platform-tools>

I checked my tools folder and I have sqlite3 so I am not sure what is going on
[Nook Color Android Development] dreadlord369:
Yo in the third quote you didn't put the full address, I was having the same problem and to fix it instead of it being

adb push settings.db /data/data/com.android.providers.settings/settings.db

I made it

adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

and that made it work. Thanks for the post though it was cause of your post that I fixed the problem. Now I can finally install ADW.Launcher
[Nook Color Android Development] hendersonn:
linux user here, im having trouble finding the /data folder... :|
[Nook Color Android Development] rsmurdoch:
works great thanks
[Nook Color Android Development] midnightmaraude:
Can you use terminal emulator here?
[Nook Color Android Development] bckrupps:
What do you type to get into sdk tools in command prompt. Its been a while lol
[Nook Color Android Development] Novaglarion:
cd\*path of sdk\tools folder*

so like:

cd\android-sdk-windows\tools

All depends on where you put the sdk folder.
[Nook Color Android Development] Novaglarion:
Unless someone has found a working sqlite3 binary that works on the device and you have it on your device, no.
[Nook Color Android Development] madsmurf:
This worked Awesome! Thanks much... exactly what I was looking for.
[Nook Color Android Development] samsoccer7:
Worked like a charm! Awesome!
[Nook Color Android Development] tomtbone:
Worked great!
[Nook Color Android Development] candre23:
Pardon me for being a bit dense, but this is the only way to enable installation of non-market apps? Is there any chance of a market app that will enable this option, or is manually editing the database via the SDK on a PC the only way?
[Nook Color Android Development] Novaglarion:
This has a couple alternate methods.

http://nookdevs.com/NookColor_Enable_App_install_from_on-device_installers
[Nook Color Android Development] Ebucel:
I tried this but it tells me .. that the file doesn't exist.

so I searched via windows for any .db files the only ones i found where for astro.

Thanks in advance

FYI:

NC on 1.01 used autonooter
[Nook Color Android Development] candre23:
I'm using autonooter, and have the "non-market apps" checked, but it requires the apps be placed in /system/app/. Using one of the free (non su) file managers, I can't put files there. I tried doing it manually in terminal emulator, but apparently simple commands like "move" and "copy" aren't available.
[Nook Color Android Development] RoboRay:
Just in case anyone is actually trying "move" and "copy" the linux (and therefore Android) equivalents are "mv" and "cp". For reference, here's a list of some of the file-management commands that should be available on the NC:

cd -- changes your current directory or folder

rm -- removes or deletes a file

ls -- lists files in the directory

mkdir -- makes a directory

mv -- move and/or rename

rmdir -- removes a directory

cp -- used to copy files

chmod -- changes file or directory permissions

You will, of course, also have to enter "su" first before you can make changes to /system. Extraordinary care should be taken with the use of "rm" and "mv" in conjuction with "su."
[Nook Color Android Development] Ebucel:
This solved my issue.
[Nook Color Android Development] thorpe24:
this script doesn't work for me says adb not recognized as an internal or external command. do i need to be in pc mode do i just need to run the script i'm totally lost. really want to install apps, but as you can see i suck with adb.
[Nook Color Android Development] bonzer2u:
sounds like you didnt add the jdk install path's to your windows path variable.....
[Nook Color Android Development] thorpe24:
say what???? and i rooted using autonooter, but no luck on installing sideloaded apps or ones from dropbox....
[Nook Color Android Development] wicked_beav:
Is there a way to do this without a pc? My adb is having hissy fits right now and I'm beyond frustrated.
[Nook Color Android Development] HotShotAzn:
Not really. You need sqlite to read the db file (I think). If you just use a text editor, its garbled and you wont find the value you need to change.

If you want, you can email me your system.db file and I'll make the edit for you. I have absolutely no idea if that would work or not so be warned kind of thing...
[Nook Color Android Development] wicked_beav:
Just pisses its so difficult to sideload apps... this is highly frustrating.
[Nook Color Android Development] dcontrol:
Worked great, I didn't want to mess up the adb/usb drivers with my Vibrant, so I just installed terminal on my nc and used cat to grab the settings.db file (bash didn't have cp for some reason?) Thanks a bunch!
[Nook Color Android Development] thegreatcity:
Trying to get this done on my dads NC, but every time I enter this command:

update secure set value=1 where name='install_non_market_apps';

I get:

Error: no such table: secure

Any help?

EDIT: Nevermind a second try from step 1 worked fine.. guess it could have been acting up cause of ADBwireless?
[Nook Color Android Development] rumitg2:
omg i love this. one step closer to a pure google experience
[Nook Color Android Development] mz.choize:
I need help, if you can offer any suggestions please. When I enter this command:

sqlite3 settings.db

I get this:

'sqlite3' is not recognized as an internal or external command,

operable program or batch file.

What does this mean, or what am I doing wrong or perhaps missing? I do see sqlite3 in my tools folder, but idk.:confused:
[Nook Color Android Development] >DARKMAN<:
it means that sqlite is not in your android sdk tools folder you can find it around here, i think on the first post.
[Nook Color Android Development] toastman74:
holy freakin crap this worked awesome!!! gotta love XDA!

Homerun Battle 3D is awesome!!!
[Nook Color Android Development] chinot66:
work gr8, thanks!
[Nook Color Android Development] droid master:
ok My 1st time using ADB so I am a little new i ran the 1st command with

C:\android-sdk-windows\platform-tools>adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db

not C:\android-sdk-windows\tools>adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db

now I am trying to run the correct command I keep getting 'adb is not recognized as an internal or external command,

operable program or batch?

The 1st command i ran did run successful though when i ran it with platform-tools in the command?? is that gonna mess up my nook?
[Nook Color Android Development] dcontrol:
No as long as you were able to copy settings.db from your nook to your pc it should be fine.
[Nook Color Android Development] droid master:
how do I know if it copied? and why cant I run the second command now?

I keep getting 'adb is not recognized as an internal or external command,

operable program or batch?
[Nook Color Android Development] dcontrol:
Wait what? You're running a program on your pc called adb. If it exists in the platform-tools folder and not under the tools folder then that's what you should run
[Nook Color Android Development] droid master:
I am confused? I am all new to this?
[Nook Color Android Development] dcontrol:
Alright lets start at the beginning.

Either in the folder C:\android-sdk-windows\platform-tools

or C:\android-sdk-windows\tools

you have a program called adb.exe that "allows you to control and interface with your Android device."

When you run your command "adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db"

you are running adb, and you're telling it to pull, or copy, a file called settings.db

from your phone to your pc, it will copy it to wherever you ran the adb command from.

The rest of the commands deals with using sqlite to change a parameter in your settings database to allow you to install apps not from the market, and once done to transfer it back to your phone with that setting changed.
[Nook Color Android Development] ikadatom:
I Download SQLITE Editor from the market.

In SQLite Editor open /data/data/com.android.providers.settings/databases/settings.db

choose the table secure

find the entry where the name field is "install non market apps"

change the value field to 1.

reboot the device. and it work
[Nook Color Android Development] khaytsus:
I can't fathom why anyone is doing this manual stuff with the auto nooter image that works so well..
[Nook Color Android Development] puppster1:
Can't get this to work, have tried about 5 times. I check Astro and there's nothing in my data folder. Verified using Sqlite3 to see if I modified the .db file correctly and it shows the 1 but I can't for the life of me figure out why it's not pushing correctly.

I re-read the and re-did the steps/posts according to how everyone who failed initially and then got it working but can't get it to work. Guess I'll be using adb for a while longer unless someone can help me figure out what's going wrong?
[Nook Color Android Development] dcontrol:
Maybe you can just use a root explorer to move it over and replace the old one? Or grab a terminal emulator and mount system then cp or cat it over?
[Nook Color Android Development] puppster1:
I'm completely new to all this android stuff.. i have no idea what you just said :(

Where would I get a root explorer or terminal emulator?
[Nook Color Android Development] dcontrol:
Oh sorry, I guess the other ways are more advanced, I explained earlier in the thread to someone exactly.what's going on, which part are you having problems with?
[Nook Color Android Development] decalex:
Anyone have any ideas here? I'm a frequent adb user with my Samsung Epic, and have been unable to recognize my nook (in adb). (after kill-server and adb devices, shows blank).

The adb_usb.ini is in the correct spot, and have verified "0x2080" when checking. But here's how my comp (win7 x64) recognizes my nook right now, in screen shot.

Any guidance appreciated-- I've read through the materials.
[Nook Color Android Development] puppster1:
I actually have no idea... I can't push the db file to my NC.

I looked and saw that I edited the .db file correctly, showing "1". However when I try to push the .db file, it looks like it pushed correctly but when I try to install through Astro, it says that I can't.

I also checked the data folder using Astro and it's empty..so that's what's wrong atm I guess.

Thanks for any and all help! Sorry for all the weird questions, too new to this. NC is actually my first experience with Android (waiting on a dual-core phone to come to Sprint)
[Nook Color Android Development] decalex:
That sounds like what I want to do-- what were the other commands you used-- to edit the db (without sqlite in terminal manager)?
[Nook Color Android Development] dcontrol:
I just used cat to move it somewhere else like:

cat /data/data/com.android.providers.settings/databases/settings.db /sdcard/settings.db

This is all under root of course, then I just copied that file to my computer and used sqlite to edit it and then used cat to copy it back. Someone said that there's an sqlite editor in the marketplace, that might be easier.
[Nook Color Android Development] dcontrol:
I'm assuming you've already rebooted after you pushed it? Well, if your settings.db is already properly edited, then you just need to copy it over to your nook in the right folder. You can hook it up to your pc and copy it to somewhere you can access, like /sdcard I think is where it goes when you connect the cable. Then you can use root explorer to copy and paste it to the right place, but root explorers usually aren't free. The reason /data doesn't show up in astro most likely is because it isn't mounted as you need root access to see it. So if you already have root access, then grab a free terminal emulator from the marketplace then

su root

then it should ask you to give it permission

then you can do

cat /sdcard/settings.db /data/data/com.android.providers.settings/databases/settings.db

to copy it from /sdcard to where it needs to go.
[Nook Color Android Development] gallahad2000:
Why not just move the .apk to system/apps and adjust the permissions (check the files already in there to see how they should be set) using root explorer. Works more or less perfectly for me.
[Nook Color Android Development] decalex:
Rt on man, thank you. I do want to get adb working-- the root (no pun) of this issue was the whole Dolphin 4.3 problem with pinch-to-zoom, and needing to revert back to 4.2. What ended up working, to allow me to reinstall 4.2 was, going thru the nooter tools, unchecking and rechecking allow unknown apks.

Does 'cat' copy or move? And what's the diff btwn cat and mv? I would think the device would freak if the settings.db was (temporarily) not in there, no?
[Nook Color Android Development] dcontrol:
I think cat is short for concatenate, but I'd need to look it up, basically I've just been using it to print out file contents, but you can print out the file contents to another file, basically copying it. I would use mv or cp but they're either not in the shell or they weren't linked so it doesn't work. I might have an older version too. You know, I actually deleted settings.db before I used cat to copy it over, I wasn't sure if it would just overwrite it. Anyways, dolphin eh? I've settled on Opera Mobile, pinch/zoom works, no flash, but its easier to copy and paste, and I like the big buttons in portrait mode, not so much in landscape, it takes too much room. What advantages does dolphin have?
[Nook Color Android Development] DOG666:
Man, it would be nice to have a step by step video to reffer to for help. When i rooted my evo thru adb it didn't seem so complicated, but now that i picked up a nook color & rooted it thru autonooter, the adb process seems alot harder :( I'm able to use the market to buy/download apps, but i'm having trouble getting apk's to sideload thru astro. I sure hope as time goes by that the nook gets easier cuz' it's an awesome device, & i chose it over the galaxy tab (tab was too expensive). Can't wait for full fledged nook roms too, what i've seen so far makes me happy that i picked up a nook :)
[Nook Color Android Development] DrBouvenstein:
I can't seem to get this to work at all. When I run the adb command, I just get "error: device not found."

I've run the bat file from here: http://xdaforums.com/showthread.php?t=882751

to get the adb drivers, and my NC shows up in my device manager as Android Composite ADB Interface, so they seem to be right...the heck is wrong?

Edit: I forgot to mention, USB Debugging IS checked under NookColor Tools.

Edit: Nevermind, I got it. Had to to the "kill-server" command and remount.
[Nook Color Android Development] QaeadarDAzeal:
Just wanted to hop on and say thanks a bunch for this. Worked like a charm first time.

Cheers, mate.

~Q
[Nook Color Android Development] buffalosolja42:
having problems installing driver for nook

windows only (7 32bit) only wants to see it as portable device and won't let me update even after uninstalling. Found fix http://xdaforums.com/showthread.php?t=910008&page=2
[Nook Color Android Development] buffalosolja42:
driver is correct

but the command says it is not seeing my device? actually error** device not found
[Android Apps and Games] wad3g:
After their website has said 'Coming Soon' for over a year now they've finally released and application in the market.

Go out and grab it for anyone whose interested.