yashsingh1/xdaforums huggingface dataset:
[G1 Q&A, Help & Troubleshooting] mejorguille:
If you are using Firerat's MTD hack, you need to downgrade your recovery to ra-1.6.2. Remember that the new recovery does not agree with the old apps to sd. From there, do a full wipe, flash DRC83_base_defrangled, and super D. You should probably install the market ADW as well, (superD uses an old version of it), and also remove the spareparts and terminal just so she doesn't mess with it.
[Captivate Q&A, Help & Troubleshooting] kirbo20:
This is a pretty easy process. I went in to Root Explorer - dbdata - databases - com.android.providers.settings, copied settings.db to my sd card, edited it on my pc with a db editor changed 0 to a 1 next to non market apps. Copied it back to the original directory, rebooted and installed a non market app.

Please use caution. If you want to make sure the db save properly open it on your sd card before you copy and replace the original. It should open up as a readable table. If it opens up in a txt editor its corrupt. This permanently enables non market apps. You can not toggle it on and off.

I will try and post pictures soon.

**If this has helped you please consider a donation.**

Thanks
[Captivate Q&A, Help & Troubleshooting] clubtech:
Which DB Editor did you use?
[Captivate Q&A, Help & Troubleshooting] kirbo20:
Actually its just called Data Base Editor. Program Files says is by ACID/ODE. I will post a link.

Here
[Captivate Q&A, Help & Troubleshooting] Muhamadabdelaall:
Captivate Help

Does it mean th after this you are able to install any 3rd party application with no restrictions?

Thanks
[Captivate Q&A, Help & Troubleshooting] modest_mandroid:
You can actually do it through firefox too. There's a firefox addon called 'SQLite manager' that you can use to edit the file, if you don't want to download a separate program.
[Captivate Q&A, Help & Troubleshooting] YellowGTO:
Root Explorer is the pay program on the market? Any free alternitives?
[Captivate Q&A, Help & Troubleshooting] iJITSU:
Are you just trying to install non-market apps on the Captivate? If so, then just download the usb driver for the Captivate and then Droid Explorer (may also need SDK installed; not sure). With Droid Explorer, you can easily load non-market apps within seconds. Good solution for a non tech guy like me.
[Captivate Q&A, Help & Troubleshooting] ewingr:
Being brand spanking new to Android, still have question. I like very specific instructions.

Do you download files to whatever directory you want to make and put the files in? Then is there an option to select, and do install? My background is WinMO, so on that you can just use a file explorer and double click or tap, and it installs.
[Captivate Q&A, Help & Troubleshooting] kirbo20:
Yes

(too short)
[Captivate Q&A, Help & Troubleshooting] Muhamadabdelaall:
Confirmation

So if I installed "PDAnet" for tethering it will work after rooting?

Thanks for the answer
[Captivate Q&A, Help & Troubleshooting] kirbo20:
PDA Net will work without rooting. Just put your phone on airplane mode and enable wifi. Go to the market and download it. Once it is downloaded you can turn off airplane mode and you're good to go.
[Captivate Q&A, Help & Troubleshooting] Muhamadabdelaall:
oh, thanks alot man for that I was unaware of.
[Captivate Q&A, Help & Troubleshooting] blazewit:
will flashing a new rom when they start coming out also allow you to do this or do i have to do this regardless?
[Captivate Q&A, Help & Troubleshooting] GermanGuy:
Where do you see the 0, the one you recommend to change to a 1? I only see lots of squares.
[Captivate Q&A, Help & Troubleshooting] seriouslyjeff:
So... Thank you so much for this info. I downloaded your file and put it into the correct DIR and have non market apps installing with no problem. However I can not get Titanium backup to work correctly. =/ When I try to restore an app it says installing and I have to force close titanium to get it to stop. Probably about half the apps I try and do this for install the other backups do not. Is any one else having any issues like this or know how to fix it?
[Captivate Q&A, Help & Troubleshooting] tbae2:
Where did you see the number to change? Mine just looks like a bunch of gibberish
[Captivate Q&A, Help & Troubleshooting] stoneskid:
When into this dir dbdata - databases - com.android.providers.settings and cant find any files. Using linda
[Captivate Q&A, Help & Troubleshooting] tbae2:
I used this DB editor instead

http://sqlitestudio.one.pl/index.rvt

connect to the settings.db file, on the left side click Tables, and then click Secure. It will show a grid on the right with _id, name, value etc. Click the Data tab, in the search box type market. And there should be only one value that shows up as "install_nonmarket_apps". Set the value to one. Refersh it and then copy it back to your phone.
[Captivate Q&A, Help & Troubleshooting] Citznfish:
How the heck do you do this? I have Droid Explorer installed but not BusyBox. I have Windows 7 and can't figure out how to get BusyBox on my phone. I have rooted the phone but that's about it. in Droid Explorer when I connect to my phone it shows nothing!
[Captivate Q&A, Help & Troubleshooting] bjabah:
Very good instructions tbae2, it worked just fine.

Thanks,

bja
[Captivate Q&A, Help & Troubleshooting] JacenSolo2001:
Thanks - I now have the Captivate I wanted - rooted and able to install software from anywhere !! Bring on the ROMS !!
[Captivate Q&A, Help & Troubleshooting] derek4484:
I can also confirm that this works well. I purchased root explorer from the market. I went to the folder that the OP said to. I copied the file settings.db to the sdcard. I then used sqlitestudio to modify the table "secure" the value is about fifth or sixth down the list. Just change the "0" to a "1". Disconnect from the database (no need to save it). Then pasted that file over the original, and restarted the phone (not sure if this was necessary, but I did it anyways). I then went to slideme.org and downloaded a cheesy game .apk file. Saved it to the sdcard. When I clicked on this file in root explorer it asked me to install it. It installed fine. Very happy. I have now rooted and gotten it to load non-market apps.
[Captivate Q&A, Help & Troubleshooting] Shovelhead84:
Very nice suggestion. Gave it a try and literally only took me 5 minutes to figure it out. I have never seen Droid Explorer before and it was very easy to use. This is a nice solution until I get some familiarity with the captivate and decide which root/rom/style direction I want to go.

Thanks iJitsu.

(had to add fancy widget. I am not feeling the Samsung Clock and calendar)
[Captivate Q&A, Help & Troubleshooting] pantyryder69:
Did you install SDK?
[Captivate Q&A, Help & Troubleshooting] dmnall:
Well This site is awesome a fully rooted Captivate and Now Non Market Apps able to install. I am loving Android even more.

Thank you again,

Charlie
[Captivate Q&A, Help & Troubleshooting] shawnchalfant:
Any free app other than Root Manager?
[Captivate Q&A, Help & Troubleshooting] cropythy:
Could someone explain a little bit more at how to get to the right db with one of those editors? Database editing is something I am not good at and could use a little bit of help.
[Captivate Q&A, Help & Troubleshooting] JacenSolo2001:
I just used the file he provided at the end of the 1st or 2nd post, worked like a charm, avoided the editing part
[Captivate Q&A, Help & Troubleshooting] needslipo:
tried with astro manager... dbdata shows up as an empty folder
[Captivate Q&A, Help & Troubleshooting] masterofthebass:
I found using busybox and adb worked easily for copying. The one thing I do suggest, is making sure the file permissions on settings.db are set to write for all groups. I wasn't able to change some settings because these permissions were off.
[Captivate Q&A, Help & Troubleshooting] stoneskid:
Do you need to be rooted for this to work?
[Captivate Q&A, Help & Troubleshooting] YellowGTO:
Yeah you need to be rooted, to even install Busybox.
[Captivate Q&A, Help & Troubleshooting] derek4484:
I think the easiest way is to use SQLiteStudio. Its free and small.

On the left look for the table called "Secure" Open it. Go to the data tab. The non market install is 6 items down. Just edit the 0 to a 1. There is no "Save" function. Just disconnect from the database. It saves everytime you make a change.
[Captivate Q&A, Help & Troubleshooting] nayo911:
How do you copy (SETTING.DB) to sd card, i cant do it for some reaSON?
[Captivate Q&A, Help & Troubleshooting] :
Guys,

Afer Rooting the phone, what kind of AT&T restrictions we still have on our phone? I appreciate the answerer
[Captivate Q&A, Help & Troubleshooting] jhego:
I followed the instructions and changed the 0 to 1 but when i tried installing the new LauncherPro.apk, it says download unsuccessful. Help please.
[Captivate Q&A, Help & Troubleshooting] dmnall:
Well it sounds like you are not doing something right because I followed the instructions and just to double test it again, I am downloading launcherpro right now and it installed perfectly on my Captivate!

After Editing the File, did you replace the stock one settings.db with the altered one? Make sure your phone is not mounting the storage on your computer?

Cheers,

Charlie
[Captivate Q&A, Help & Troubleshooting] garringm:
I have not gotten my captivate due to unforeseen circumstances but I have one question, are you not able to use the adb drivers from sdk to push non-market apps to /data/app a lot easier than modifying files.
[Captivate Q&A, Help & Troubleshooting] sherifone:
I did this on a mac with no driver installation and no issues.

I used root explorer to copy the settings.db file to the sd card, and I then used the SQLite Manager extension for firefox to edit the file on the SD card directly.

Unmounted the SD card from the computer, went back to root explorer, copied the settings.db file back to its original location, rebooted and bam. All set.
[Captivate Q&A, Help & Troubleshooting] jhego:
I actually had to download it to my comp then to my SD card and it installed from there. I think it's just site that was not letting me download. I tried other non-market apps and they installed just fine so that should mean that it worked:) Thanks for your help anyway.
[Captivate Q&A, Help & Troubleshooting] gr1fter:
ok don't laugh...but where can i even get a 3rd party non-market app to test if this working or not.
[Captivate Q&A, Help & Troubleshooting] skizzz:
Few here

http://slideme.org/
[Captivate Q&A, Help & Troubleshooting] ricethief:
I haven't tried it yet but Android Central just released their, point and click program to do this. It says device does not have to be rooted either.

http://www.androidcentral.com/sideload-android-apps-all-you-want-sideload-wonder-machine
[Captivate Q&A, Help & Troubleshooting] :
Or you can just download iAPK.exe and drag and drop apk into it, and it will automaticly install them tru adb, i change the settings.db since its a joke to do it...
[Captivate Q&A, Help & Troubleshooting] mackentosh:
Cant find Root Explorer

i downloaded root explorer to my captivate and i downloaded SQlitestudio but i cant find root explorer on my computer to edit it please help:mad: !!!!!
[Captivate Q&A, Help & Troubleshooting] skizzz:
Reboot your phone and do not plug into the computer.

Open root explorer and browse down to the file that OP mentions.

Copy to SD card to a folder you can browse into.

Go to the phone settings and set it for USB mass torage

Plug into the computer and copy the config file to your local machine

With SQL lite open the file, no not open the file in notepad or anything, it will corrupt it.

Edit the file as the OP said.

Copy the file back to the phone.

Open root explorer again, rename the old config file or delete it. Then copy the newly modified on into the same location.

Reboot phone and done!
[Captivate Q&A, Help & Troubleshooting] mackentosh:
I got it thanks i installed flash 10.1 apk and its not working for me :(:(
[Captivate Q&A, Help & Troubleshooting] :
Flash 10.1 dosnt work on 2.1, unless your running a sense rom then you can install a hack't flash 10.1.apk by auxx which enables full flash 10.1 on any sense 2.1 rom.
[Captivate Q&A, Help & Troubleshooting] steeldragonnyc:
IT WORKS!!!

Thanks sooooo much for the link m8 I tried it and it works
[Captivate Q&A, Help & Troubleshooting] robstunner:
This, It says its in the SDcard, but no where to be found!
[Captivate Q&A, Help & Troubleshooting] robstunner:
Ah, i was still connected to the computer, that was it! Sweet, got my mabilo working great! Thanks all
[Captivate Q&A, Help & Troubleshooting] madjsp:
I booted into windows 7 and used android central and it worked. My phone is rooted so I can't confirm that it will work on a non-rooted phone, but I downloaded four .apk files and installed them to my phone using their program.

Really makes it fool proof. I downloaded the drivers from Samsung's website. Also, I put my phone in USB debugging mode, and then mounted my phone. Then, no problems putting files on my phone!
[Captivate Q&A, Help & Troubleshooting] poulosjr:
awesome post!!!! thanks for the info! seemless!!! :D
[Captivate Q&A, Help & Troubleshooting] skizzz:
Do you have a link for this?
[Captivate Q&A, Help & Troubleshooting] poulosjr:
is there any way to do the editing directly from the captivate BC I noticed they have an SQLite app for androids
[Captivate Q&A, Help & Troubleshooting] skizzz:
I haven't tried but i don't see why not.

Why dont you just get root explorer and SQL lite for firefox and get it done?
[Captivate Q&A, Help & Troubleshooting] TexUs:
Is there a free alternative to Root Explorer??

Linda seems to work except for the fact you cannot get to the file itself (you can type in the entire path to the file, which will then just try to open it- no copy commands).
[Captivate Q&A, Help & Troubleshooting] Inspiredwire:
I imagine the instructions to enable sideloading are nearly identical to the HTC Aria.

xdaforums.com/showpost.php?p=7264947&postcount=4
[Captivate Q&A, Help & Troubleshooting] djgleebs:
for some reason, only on the root explorer app, it declines my credit card... but i can buy anything else in the market...

help? lol
[Captivate Q&A, Help & Troubleshooting] TexUs:
You're saying it's possible to do this from ADB with

adb remount

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

???
[Captivate Q&A, Help & Troubleshooting] systoxity:
why arent u guys using droid explorer?
[Captivate Q&A, Help & Troubleshooting] shaneaus:
Droid Explorer doesn't work on Windows Vista 64 machines....
[Captivate Q&A, Help & Troubleshooting] dieselstation:
i can CONFIRM that this works but you have to have ADB drivers installed first.
[Captivate Q&A, Help & Troubleshooting] systoxity:
like it wont start or connect?
[Captivate Q&A, Help & Troubleshooting] DanteDrac:
Droid Explorer works fine for me on Windows 7 64bit. I used the samsung drivers + SDK.
[Captivate Q&A, Help & Troubleshooting] tdk650:
another question..

Could you post where in the db editor you can change this, i dont have any thing that says non market apps. Step by step pictures in the database editor would be useful. I open it and i dont see where i could change that setting. Any help would be appreciated. thanks
[Captivate Q&A, Help & Troubleshooting] Fortune090:
With SQlite, go to Tables>double-click secure>Data tab>(#6) install_non_market_apps.
[Captivate Q&A, Help & Troubleshooting] littleasian:
im going to try this later and i just wanted to make sure. when you say copy the settings.db file to the sd, do you mean the EXTERNAL sd card? the user-swappable sd card? or are you referring to the built in INTERNAL sd card?
[Captivate Q&A, Help & Troubleshooting] decepticon:
Nevermind, found an app for the Mac that works as well. http://mac.softpedia.com/progDownload/SQLite-Database-Browser-Download-30549.html
[Captivate Q&A, Help & Troubleshooting] ewingr:
SDCard not show existing files/folders?

I'm concerned I am selecting wrong place.

I have root explorer, selected and copied the file, and when I go back up to browse to teh SD Card, I find something called sdcard, but when I go into it it does not list anything. However I do have items there.

Is that because it is not System Files?

[EDIT]

I did go ahead and paste it there, and it shows in Root Explorer, but from the PC I do not see it.

[EDIT2]

Never mind. I rebooted, and tried again, and am getting there.
[Captivate Q&A, Help & Troubleshooting] brandonb81:
So, I've rooted my phone. I've installed the SDK and Busybox, the Samsung Drivers and Droid Explorer.

In Droid Explorer I get this:

Doesn't show anything in my dbdata folder... Not sure what I'm doing wrong.

Also, when I run root explorer on my phone and it's disconnected from the computer, I get this:

It never asked me for superuser permission. Any ideas? Thanks in advance!
[Captivate Q&A, Help & Troubleshooting] TexUs:
What OS you running? My Droid Explorer only shows the root, no files or anything, and the reboot options don't work (but it does find the device and act likes it can connect to it).
[Captivate Q&A, Help & Troubleshooting] caelestis2:
If you dont want to pay for root explorer just to install non-market apps (like me) then follow this:

Warning: I take no responsibility if you corrupt your settings.db if you don't follow this precisely.

Install the SDK and samsung drivers, plug the phone into usb, set it to usb debugging mode, and launch a command line (and navigate to your sdk tools directory where adb is in the command line)

You must be rooted already, and install the busybox installer from the market.

In the command line run these commands:

Make sure your phone is turned on when you type su and and allow it superuser permissions

adb start-server
adb shell
su
cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db
exit
exit

Now your settings.db will be in the root of your sdcard. Mount and copy the file over to your computer, open one it up with one of the sqlite editors mentioned in this thread and open the table called secure, and find the key called install_non_market_apps and change it from 0 to 1 and make sure to save it.

Copy the new settings.db over to the root of your sd card and type this in the terminal once again:

adb shell
su
cd /dbdata/databases/com.android.providers.settings
rm settings.db
cp /sdcard/settings.db settings.db
chown system.sdcard_rw settings.db
exit
exit
adb reboot
[Captivate Q&A, Help & Troubleshooting] big3:
Missing 1 BIG!!! STEP! after you have done saved it back in the original location, you must unmount the memory cards or else it wont work. I will be posting EXACT commands i used for Win 7 x64 in a bit.
[Captivate Q&A, Help & Troubleshooting] Seyiji:
Ok caelestis2 I followed your steps exactly and now whenever I try to disable USB debugging it says it is still enabled :confused:

Oh it works and I can install non market apps but it won't let me enable or disable any settings :(
[Captivate Q&A, Help & Troubleshooting] brandonb81:
I'm running Windows 7 64 bit.

I'll try the other method being posted. I'd like to be able to install apps from e-mail or from sites on the phone. Side loading works, but it's relatively inconvenient.
[Captivate Q&A, Help & Troubleshooting] YellowGTO:
1 step is missing from your guide.

Anyone who does this you have to do

adb shell

su

chmod 777 /dbdata/databases/com.android.providers.settings/settings.db

reboot

Then you will be good.
[Captivate Q&A, Help & Troubleshooting] max_warheads:
Minor note:

make that:

adb shell

su

chown system.system /dbdata/databases/com.android.providers.settings/settings.db

reboot

This is the original permissions that was on the file. Why inadvertanly create a security oopsy? ;)

Because yeah.. when you copy it back from using it on the PC, it will come in as chown root.root and you can't properly modify settings!!! (aka my wireless turned itself off every 1 minute until i figured this out an fixed it.. )
[Captivate Q&A, Help & Troubleshooting] Seyiji:
Thank you both :D

Everything seems to be back the way it should be now! I appriciate your help :)
[Captivate Q&A, Help & Troubleshooting] big3:
The DOS prompt continues to say "data not found".

Anyone?! This is gona be a big $%#@&!! problem for me.

Update: I have gotten it to work. PHEW! Now all that needs to be done is a set of much more clear/ specific instructions.
[Captivate Q&A, Help & Troubleshooting] TexUs:
Instructions are clear enough... They're just in three different posts ;)
[Captivate Q&A, Help & Troubleshooting] max_warheads:
EDIT:

SEE http://xdaforums.com/showthread.php?t=738376

Ok, lets consolidate a bit of this.

Root your phone, see http://xdaforums.com/showthread.php?t=725555

Then, once root is confirmed as working, from my Win7x64, with USB Debugging ON. Ensure that you phone is UNLOCKED as it the SU app will ask for permission for 'UNKOWN' in the following command.

Connect to PC, and Eject/Safely Remove the SD card, and "Turn off USB Storage" on the phone.

open command prompt, follow along:

> c:
> cd \android\tools
> abd shell
$ su
# cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db
# exit
$ exit

mount the SD cards to the pc,

"USB Connected select to... ", Mount

mine mounted as H:

> copy H:\settings.db settings.db

> sqlite3 settings.db
~> update secure set value="1" where name="install_nonmarket_apps";
1 row updated
~> .quit

> copy settings.db H:\settings.db

Eject the drive, safely remove, etc.

"Turn off USB storage" etc, to mount it back to the phone

> adb shell
$ su
# cp /sdcard/settings.db /dbdata/databases/com.android.providers.settings/settings.db
# chown system.[b]system[/b] /dbdata/databases/com.android.providers.settings/settings.db
# chmod 660 /dbdata/databases/com.android.providers.settings/settings.db
# exit
$ exit

> adb reboot

Bam. Done.
[Captivate Q&A, Help & Troubleshooting] TexUs:
I thought I had this however...

"Cannot download. The content is not supported on this phone."

I'm rooted, I switched that flag... ??? What else could there be?

Edit- I just re-copied the settings.db file to verify and yes, the flag took, it's set on...
[Captivate Q&A, Help & Troubleshooting] max_warheads:
I just copy the .apk's t my sd card and click on them from ASTRO, installed the latest version of Snesoid on my phone this way.
[Captivate Q&A, Help & Troubleshooting] brandonb81:
I get the message saying for security, non market apps cannot be installed. Where are you getting that error message? And did you reboot your phone?

I look forward to trying out the consolidated instructions later today. Thanks!
[Captivate Q&A, Help & Troubleshooting] caelestis2:
Properly mounting and unmounting the phone should go without saying.

Sorry if I wasn't clear enough but I was reciting what I did at the top of my head at 2 AM. I also use linux.
[Captivate Q&A, Help & Troubleshooting] TexUs:
How to do it OTA though? I'm trying to install the AMOLED Notification "LED" someone in the SGS posted... No go.

The security message is the one you get prior to these instructions. I'm not sure if mine is related due to restrictions or what...
[Captivate Q&A, Help & Troubleshooting] RDI:
So I got Root Explorer, click on dbdata, and it says "Mounted as r/o" Your phone does not appear to be rooted. This is required in order to gain access to protected files
[Captivate Q&A, Help & Troubleshooting] zhagas:
I'm still getting the "for security, non market apps cannot be installed" error too after following the consolidated post above. Ran through the instructions twice and verified it was still set to "1" when I copied it to the phone the second time.

As a side note, there is a small typo in the last set of commands "andorid" instead of "android" that threw me for a couple of minutes thinking I was doing something wrong. :)