yashsingh1/xdaforums huggingface dataset:
[Captivate Android Development] Ptaaty:
Yeah- I have the same situation. New FW (JH2) and did the unleash the beast method. I got root, removed the bloatware apps - but now I can't install anything unless through the market.

How bad is it? Titanium is now near useless - it says "Warning System Configuration : Your system settings will prevent you from restoring applications. To correct this, go to your phone's settings, then in "applications" and tick "Unknown sources" checkbox."

So I can't restore anything through titanium. Something has changes in JH2 I think.
[Captivate Android Development] max_warheads:
Can someone running JH2 get us the factory file ownership for the new rom? We may need to update the methods.
[Captivate Android Development] MaxPower5000:
Modification of procedures

Good afternoon all, I am a bit of a noob so bear with me. When executing the main procedures, all seemed to be well. If anything that I can offer for change, it would be to copy the /mounted windows phone sd card/settings.db to a different directory on the host PC for editing, instead of just C:\. When attempting to edit the DB from the SQLite manager from FireFox, it kept telling me that the file was read-only (incidentally windows had no knowledge of it). So I copied to the desktop, and ran the FF plugin again, and was able to update it without trouble. Re-mounted the phones SD cards, copied back from the desktop to /mounted windows phone sd card/settings.db and ran the rest of the procedure without fail.

P.S. I'm decent in linux, so i renamed the origin file (/dbdata/databases/com.android.providers.settings/settings.db), and (/sdcard/settings.db) into settings.db.old so all the originals would still be there in the event of restoration.
[Captivate Android Development] max_warheads:
@MaxPower500:

Yay, someone backed up their file :) (no, seriously, well over half the problems people have had was because of corrupt file in transfer, and not making the backup as instructed)

As for c:.. yeah, don't copy it there, especially on V/7... unhappy campers when you try to edit a file in the root of the system drive. In my event, I used 'c:' simply to ensure that I was on the correct drive (as some people may be at work, using a profile-set home drive, say, H: )
[Captivate Android Development] pietro_spina:
Using Ubuntu Linux 10.04 (lucid)

In your method 5 I had to put some double quote in the echo command

$ echo "update secure set value = 1 where name = 'install_non_market_apps';"|sqlite3 settings.db

also you have a warning about using ./adb instead of adb for linux users but if the user has added the SDK /tools directory to his $PATH the ./ is unnecessary... however anyone savy enough to add the path probably gets it... :-) great summary and thanks... I love guides that let me compare tons of options...

-p
[Captivate Android Development] askpcguy:
I took the liberty of posting the first post in an article located on the samsungcaptivate.wikia titled "How To Enable Non-Market apps for Captivate"
[Captivate Android Development] max_warheads:
@pietro:

yup... PATH would do it, if others thought of it ;) I don't assume anything. I'll note the quoting of the echo.

@askpcguy:

All I ask is the credit gets passed to helpers, and then you link back here so that it has reference to any updated information.
[Captivate Android Development] djb703:
I did method 3, figured buying root explorer and sqllite would come in handy, i like being able to do everything without a PC, due to all the problems i had trying to get the phone to connect USB to windows 7. Have mac laptop havn't tried messing with that.

Anyways option 3 worked great. I think, havn't tried to sideload an app yet.

But on to my question.

I thought this would also open up the market to apps that att ristricted. Tried to download PDA Net from market thinking it would show up now, but seems like ATT is still blocking apps on the market.

Is there a way to view the market without ATT's restrictions. I know i could probably find PDA net and side load it now, but trust the market a little more.
[Captivate Android Development] no driver:
Last night I was able to use method 5 with no problem on JH2 without a lagfix (I was trying to install it). Today after a fresh odin flash of JH2 and installing the lagfix with the ext4 option I'm also getting the error message for chown system.system. Maybe it's a lagfix problem?
[Captivate Android Development] max_warheads:
@djb703:

This simply enables non-market sources. The market restrictions placed by ATT are a seperate beast. There is Market Enabler, as well as simply turning the phone to Airplane mode and then manually enabling Wifi should get you what you need.

Also, AppBrain is your friend.

@no driver: So.. it worked before the lagfix?
[Captivate Android Development] no driver:
Yes. I stupidly didn't backup my settings.db (though I haven't had any problems so far even though I didn't chown successfully) but I'm going to put an older backup prelagfix and with JH2 back on my phone to see if I can change it and possibly bring it in to my post lagfix setup.

If I want to check the ownership of the file before I do anything to it, what command do I use?
[Captivate Android Development] max_warheads:
I see no problem with using your own android_id from a prior ROM on your own phone. When you have your phone using the same android_id as someone elses, thats another story.
[Captivate Android Development] no driver:
What sorts of settings should I be trying to change to see if my non chowned settings.db is ok or not? It looks like I can do basic stuff like turn GPS and wifi on and off, and I was able to get into the LBSTest menu, which is good probably good enough for me. But I want to know if there are other things that I won't be able to do down the road because of my failure to chown the modified settings.db.
[Captivate Android Development] max_warheads:
Truthfully, if your wifi and gps settings are sticking for more than 10-15 seconds, then the system is able to modify as needed. The system.system chown is restoring the factory ownership from JF6, and on JH2/JH3, I can't say for sure.
[Captivate Android Development] grave101:
I have the same issue, I accidentally deleted settings.db can't get past the boot animation. I tried doing a clear all user data on the one click root, but still having the same issue. I still have my original settings.db saved on my desktop, I just don't know how to insert it back into the database of my phone.

Edit: now the captivate won't show up on my computer
[Captivate Android Development] looksbetterinred:
I have followed the steps but have been beating my brains out for the past 2 days. I have a file in my phone root named settings.db. I have been back and forth with the steps and I am totally lost now. I'm not sure what to do next. When I try either:

# Type in: cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db OR

# Type in: cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db.backup

I get "no such file or directory". AHHHHHHHHHHHHHHHHHHHHHHHHH :confused::(
[Captivate Android Development] networkdood:
I used method 1 and when I get to the chown part, I receive error - "unknown user/group system:system"

I will keep trying, though....gotta have sideloading
[Captivate Android Development] networkdood:
That last ls-l is exactly what I have.....
[Captivate Android Development] no driver:
I *think* you'll be ok then. I haven't had any trouble changing settings on my phone so far, though to be fair I haven't tried to adjust many, and I can load whatever I want.
[Captivate Android Development] jvanbrecht:
Wierd, I have the prerequisites.. but I do not have cp on my phone... where is the find command when you need it. I ended up going the dd route to move the file from the sdcard to the correct location (and fixed the permissions and ownership of the file). Still annoying..

Any ideas why I do not have CP..

edit: also, the location within the database was different..

Atleast when I attempted to execute the sql command provided, I got an error within the database. (I ended up using the firefox plugin to make the change).
[Captivate Android Development] max_warheads:
Can you check your ROM version for me?
[Captivate Android Development] jvanbrecht:
Stock Rom.

2.1-update1
[Captivate Android Development] max_warheads:
so I987UCJF6?

What if any other procedures did you use/do prior to making this change?
[Captivate Android Development] jvanbrecht:
Yes, thats the baseband version.

Only changes I made prior, rooting using the original method that first came out (no point and clicky apps). Titanium backup was installed, but I have not used it to remove anything just yet.

I have not really messed with the device outside of of rooting it (and trying an overclock app, that sucked the life out of the battery, no suprise there).

I'm curious if its a path issue, but there is no cp in /sbin nor in /system/bin or any of the other folders I perused, although I can say I did not look in all of them (no tab completion is a pain)
[Captivate Android Development] max_warheads:
yes, it is a pain. Check system/xbin, but it should be in /system/bin ....
[Captivate Android Development] Dave the Knave:
I must thank you for this. This should have been put up a long time ago. I've been waiting to do this since I got my phone on Saturday.
[Captivate Android Development] jvanbrecht:
Nope, not there either..

$ ./adb.exe shell
$ su
su
# cd /system/xbin
cd /system/xbin
# ls
ls
ipctool
busybox
su
#
[Captivate Android Development] no driver:
I didn't have cp the first time I rooted so I installed busybox again and it was there. Just something you might want to try.
[Captivate Android Development] simbadogg:
just to be sure, because i have to return this phone to an att store in 30 days, before returning the phone when i do a factory reset, will it revert all of these changes back to stock. so all i have to do is unroot it and it'll be good to go as far as the return? i just want to be sure before i get started, as far as with android i'm a newb, i searched but didn't find any definite answers
[Captivate Android Development] max_warheads:
Truth be told, I personally cannot say for a fact that a factory reset will replace the settings.db file outright, removing this change.

It's not complex to fix however.
[Captivate Android Development] pensfan99:
I am on a mac and when I type in the code it says that is a directory and then it does not do anything. Does anyone know what to do?
[Captivate Android Development] SeaborneClink:
Just a reference, when I did the

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

I did not get a "1 row updated successfully" You might want to add in a check step

select * where name='install_non_market_apps';

Just so people editing can make sure that their change was successful.

sqlite3

Ubuntu 10.04
[Captivate Android Development] Maximum Bob Lutz:
To All the really smart Dev types who seem to help others out:

I recently used the 1'st method to enable side loading and it worked beautifully. Sadly, after doing that, anytime I try to install/update/download an application from the market it force closes on me (I can start it, it will download, then it will force close). Now I had also applied the one click lag fix (RyanZA EXT2 Beta 2-3 to be percise) and had the phone rooted with the One-Click-Root method. Since then I've undone the lagfix with the included undo BAT program and have un-rooted the phone with the the same program to no avail, so by power of deduction I probably mucked up appling the side-loading fix. Which means that at this point I'm at a bit of a loss for what to try next, and I'd really like to avoid reflashing/odin 3-ing the stock recovery back on and having to redo my homescreens, contacts, etc.

Thanks in Advanced

EDIT: Also, I have the system dump for the force closes if that would help
[Captivate Android Development] darkamikaze:
Can anyone see if these apps in the market are available for download because for some reason they aren't appearing in my market

-Simply Lockscreen

-furdiburb

-Seeds of Life

Be greatly appreciated
[Captivate Android Development] max_warheads:
This fix does not enable market-access, only non-market sources.
[Captivate Android Development] max_warheads:
See apparently similar behavior at http://xdaforums.com/showthread.php?t=768370
[Captivate Android Development] darkamikaze:
Interesting.. So how does that work lol.. How can some people with the captivate see those apps in the market and I can't @_@

Sent from xdaApp - Captivate
[Captivate Android Development] tschaber:
did method 1 and now my phone wont get past boot, I made a backup of the original settings.db, but its on my desktop on my computer, is there anyway to restore it?

nm i got everything fixed
[Captivate Android Development] Maximum Bob Lutz:
Thanks a lot
[Captivate Android Development] max_warheads:
No problem :)
[Captivate Android Development] confrontation:
can anybody send me the modded settings.db file? I have tried a few methods but cant get it to work ,If I had the file I know where to put it.
[Captivate Android Development] Bec07:
Ouch... this looks like a real pain...

Should be a lesson to get the original device and not ATT versions ever again...
[Captivate Android Development] max_warheads:
It's really not all that hard
[Captivate Android Development] Leviuqse:
i know what the problem is....the newest busybox doesnt have the chowd command..so this is why the library.db or w/e is not updating correctly!!!

SOMEONE PLEASE WHICH VERSION OF BUSYBOX DID YOU USED TO CHANGE THE SETTINGS!!!!

I already tried all methods..not working ..all of them "bricked" my captivate..I'm not a n00b...I had a nexus one..droid..htc evo...all of them with roms..so i have some experience with androids now.
[Captivate Android Development] shaolin95:
Is there an easy way to see if my mod is working?

I suddenly seem to not be finding some apps like Glyder 2 by GLU and Angry Birds lite beta.
[Captivate Android Development] max_warheads:
not finding? This is NOT MARKET ACCESS
[Captivate Android Development] confrontation:
Would be a great help please
[Captivate Android Development] techmik67:
***Absolutely do not use someone else's settings.db unless you specifially make it a point replace android_id with your android_id!***

I just copied that from the OP, where I think it should be HUGE and BOLD and COLORED so people don't miss it!!

If that's what you think, why not download and use One Click Root and then something like SREv1.2.1a (both separate threads). Quick and painless.....

See above
[Captivate Android Development] Colton5419:
Thank you!

Used to install the BETA .apk of Angry Birds!
[Captivate Android Development] mkc90:
need help please

im using the method 5 of this guide

when i put this in the cmd

echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db

it tells me this error near line 1: no such table: source

can somebody help please
[Captivate Android Development] max_warheads:
Are you certain the settings.db file is in the same directory?
[Captivate Android Development] KENYONB:
method 2 works nicely, and i can still d/l, upgrade apps from market. :)
[Captivate Android Development] rich81420:
Help

Used method 3. Took about 15min. Reading from my nice iphone 4 peace of crap.

Act im still having the same problem if I try to download any app from the web it says "file type not supported"

Im rooted with clockwork mod and one click lag fix then I ran method 3

Hoping to get the live mario.paper

Any help would be.great thx in advance
[Captivate Android Development] LMSarmiento:
Potentially Easier Means to Enable Sideloading of Captivate

If this hasn't been added to the possible means of enabling Captivate sideloading, then this is one to consider as it is the easiest set of instruction that I've seen (and subsequently used).

Credit goes out to Joe Levi, and his posted article at http://pocketnow.com/android/how-to-enable-app-sideloading-on-the-att-samsung-captivate

I'm using a Win7, 64 bit system. As for my phone, this is all I did with it prior to using the sideloading instructions:

1 - Rooted my phone using the instructions from "One Click Root/UnRoot"

2 - Backed up my phone using the instructions from "ClockworkMod Recovery for Captivate"

The end-result was a tested and operational sideloading Captivate that worked on the first try with the following instructions, starting with Prerequisites #5 (there is a typo from the original article, so you will not find a Prerequisites #4):

Prerequisites

1. You're going to need an AT Captivate (otherwise these instructions won't do you much good).

2. Root access. If you haven't already done so, follow our How-to Root your AT&T Captivate tutorial.

3. BusyBox. Download and install the BusyBox app from the Android Market. Open BusyBox and follow the instructions to enable it.

5. A SQL Database Manager. Try the SQLite plugin for Firefox (which you can get here). Of course, if you go this route you'll need Firefox, too.

Enable App "Sideloading"

1. On your Captivate, turn on USB debugging: Settings, Applications, Development

2. Plug your Samsung Captivate into your computer via USB

3. Open a Command Prompt (with administrative privileges) on your computer and navigate to the tools folder with the Android SDK folder (something like cd C:\Users\pocketnow\Desktop\android-sdk-windows\tools (enter))

4. Once in that folder type the following:

adb shell (enter)

su (enter)

cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db (enter)

cp /dbdata/databases/com.android.providers.settings/settings.db /sdcard/settings.db.backup (enter)

exit (enter)

exit (enter) (yes, exit twice)

adb pull /sdcard/settings.db %userprofile%\desktop (enter)

5. Leave Command Prompt open, we'll need it later.

6. Open SQLite Manager in Firefox by pressing Tools, SQLite Manager.

7 . Click "Database" then "Connect Database".

8. Navigate to settings.db on your Desktop and expand the tables.

9. Click "Secure", scroll down to ID 6, "install_non_market_apps" and double-click it. (Under the "Browse & Search" Tab)

10. Change "value" from 0 to 1.

11. Close SQLite Manager

12. Go back to the command prompt window, and type the following:

adb push %userprofile%\desktop\settings.db /sdcard (enter)

adb shell (enter)

su (enter)

cp /sdcard/settings.db /dbdata/databases/com.android.providers.settings (enter)

chmod 777 /dbdata/databases/com.android.providers.settings/settings.db (enter)

reboot (enter)

13. Unplug your Captivate from your computer while your phone reboots.

If all went according to plan you can now bypass the Market and sideload apps onto your phone!
[Captivate Android Development] max_warheads:
1) He's saying sideloading, which is different than Non-Market Apps, and he's going to cause confusion!

2) Hes a month behind me in posting.

3) He's describing the methods already listed here. A blend between 1 & 2.

4) chmod 777 is a security loophole.

Unfortunately, not impressed.
[Captivate Android Development] tazman171:
:confused: Easiest? Did you look at what you just wrote and actually expect anybody to believe that. :rolleyes: Hah! Whatever man, take some cheese with that spam? Like another, lol! :p
[Captivate Android Development] fatbas202:
Great write up. It was really helpful and let Titanium Backup work.

One thing that you may want to mention is that this enables the setting, but it does not enable the checkbox to be visible in the Settings > Applications. I did this like 6 times and couldn't figure out why the hell the option was not showing up, until I just ran Titanium Backup and it worked.

Thank you very much!!!
[Captivate Android Development] tazman171:
Oh yeah, I meant to say thank you too, got side tracked by that other post. I used Method three and it worked great. I had already bought one of the programs earlier so this was great for me. Thanks again for that tutorial, was spinning circles before.

PROPS!! :cool:
[Captivate Android Development] max_warheads:
Sorry I forgot to follow up on this, but the setting is not there in the ROM, so it won't magically appear :/ sorry.
[Captivate Android Development] gruvngyrl:
I'm doing something terribly wrong here, and I'm afraid I'm totally screwing up files on my phone. (And I'm frustrated. :mad:)

Between this guide, and the other one here, I've managed to piece together how to get as far as this:

but I'm stuck at the part where you see all progress stopped. I'm pretty sure that's not the command prompt I was supposed to have by the time I was typing in those last couple commands, and nothing was happening, so I f*cked up somewhere.

Can anyone tell me where I screwed up, and if quitting out of the command window/box/thing halfway through every time is doing irreversible damage to my phone's files?

Edited to add: I had to repost this because after the forums went down, all messages I posted yesterday were deleted. Hopefully they don't pop back up and make me a dreaded double-poster.
[Captivate Android Development] max_warheads:
For whatever reason, the quit command did not process in sqlite.

...> copy settings.db .....

Btw, Kudos for actually making the backup ;)

OH, and DO NOT chmod 777 ;)
[Captivate Android Development] blahze9:
Don't type in the 1 Row Updated in the SQlite command :)
[Captivate Android Development] olieebur:
edit:wrong thread!
[Captivate Android Development] phishie:
What am I doing wrong here, I feel like I must be missing something really obvious...

*Edit: I have USB debugging on, not mounted, and "unknown" (read: adb shell) was granted root.
[Captivate Android Development] AW794:
Im having trouble locating a DB editor for windows. I have the settings file copied to my SD card, now im trying to edit it in windows. What free db editor are you using?
[Captivate Android Development] Dave the Knave:
I have your answer. I had this same problem and its because of busy box. The version we have in the root pack is not the latest version and for whatever reason, it doesn't have a link to the cp command. If you type "busybox cp /dbdata/databases/com.android.providers.settings/setting.db /mnt/sdcard" without quotes obviously, it will work.
[Captivate Android Development] max_warheads:
There is a FF add-on SQLite Manager (i think thats the name), and you can search for that. If you are not using FF, then the ADB includes sqlite3.exe in the tools folder, although it is command line. For a GUI, I like SQLite Administrator :) http://sqliteadmin.orbmu2k.de/
[Captivate Android Development] Jkburba:
checking the setting.db

ok i've read this thing thread and changed the line in the sqlite on FF which seemed pretty easy but in the instructions it says to check the file on the sdcard before replacing it ... well i go to where i saved it and click on it it says "no app can perform this action" this is because i dont have the app sqlite editor on my phone right and not that its corrupt? I just want to make sure its not a corrupt file b4 i replace it and reboot. Might seem like a dumb question but how they said to check it on the phone seems to be it should open without any more apps installed
[Captivate Android Development] Dave the Knave:
Jkburba, one of the files you push to the phone in the rooting process is sqlite3. You can just edit it on the phone and not have to worry about it being corrupted or if you had just followed the directions provided you wouldn't have to worry about it either. You're only going to corrupt a file by moving it back and forth between storage mediums. Leaving it on the phone and just editing it lessens that possibility of corruption.

Sent from my Captivate
[Captivate Android Development] max_warheads:
miztaken, this didn't used to be the case, hence the differentiation. But truth be told, corruption is unlikely, the suggestion to make a backup copy is a CYOA deal.