Workaround for Fixing 'Unsupported Sources'

[fluffyarmada]

http://forum.xda-developers.com/archive/index.php/t-644769.html << I got my idea from there.

If you update the /data/data/com.android.providers.settings/databases/settings.dbfile so that "install_non_market_apps" = 1 instead of 0, you will be able to install non-market apps off of your sdcard or wherever.

This works for me at least, but you'll have to root first.

I ended up editing the file with the SQLite Manager firefox add-on.

But, since that took me a really long time, I'll just upload the edited settings.db for you. (don't forget to make the extention .db instead of .db.txt)

Now, as far as I know, this won't mess anything up... BUT, I'd feel a lot better if someone who knows more about Android would provide some feedback before anyone else tries this. [It works for me, but I'm not sure if any other user-specific settings are kept in that file that I don't know about!]

But, at least for me, I no longer need to use adb to install apks that aren't from the Android Market.

I hope this is useful to someone... :)

EDIT::

You will lose your settings if you use the attached settings.db.txt file. Your best bet is to pull the file off your phone, edit it with something that understands sqlite3's database format, and then push it back. It's just better that way.

Further EDIT:: As someone pointed out later in this thread, this file unbeknownst to me when I shared it, actually has a unique ID by which phones can be identified on the android market, etc. While this isn't a huge deal, it can lead to some rather strange behavior... my phone for example has started attempting to download apps from the android market all by itself.

So--- if you want to side-load apps, change the variable in the database like I explained above. :)

[cropythy]

Sorry, completely new to android but where would you put this file so it would allow side-loading?

[fluffyarmada]

You'd have to replace /data/data/com.android.providers.settings/databases/settings.db with it. You'll have to have your phone rooted first though. Then you'll have to transfer the file to your phone with adb, and you'll then copy it over the existing settings.db file.


Honestly, it might not even be worth the trouble now that attn1 is just doing the whole ROMs. :)

But make sure you take off the .txt.

[attn1]

This works. Thanks.

[justince]

For some reason, i'm getting a permissons error regardless that i successfuly rooted my phone...o_o

[attn1]

For some reason, i'm getting a permissons error regardless that i successfuly rooted my phone...o_o

did you boot the phone and do adb remount with debugging enabled?

[justince]

USB debugging? Yeah.
What i did was i used the other method to sideload root explorer, took the settings.db.txt, deleted the .txt part and replaced it via root explorer, and now i can sideload whenever...however, when i try to delete any of the att bloatware, its read only o_o fawking att
Can anyone confirm any other way to remove bloatware without flashing the rom?

[attn1]

USB debugging? Yeah.
What i did was i used the other method to sideload root explorer, took the settings.db.txt, deleted the .txt part and replaced it via root explorer, and now i can sideload whenever...however, when i try to delete any of the att bloatware, its read only o_o fawking att
Can anyone confirm any other way to remove bloatware without flashing the rom?

That's why made the ROM without all that -er- stuff.

[panda703]

That's why made the ROM without all that -er- stuff.

Attn's Rom is fucking great. many thanks btw

[judicious]

a bit confused..

how do i type in this code "/data/data/com.android.providers.settings/databases/settings.db"?

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

or something else because that doesnt work.

[SiW73]

I'm not sure if any other user-specific settings are kept in that file that I don't know about!

The only issue I see (as an Android newcomer, but with a development background) is that the settings.db contains an android_id that is supposed to be unique (it gets generated when you boot the phone the first time after a reset). So anyone installing your settings.db is going to have the same ID.

I'm sure it won't be an issue for most people but I wonder if there'd be a collision in any apps that are designed to communicate between Android devices? For this reason I'll be tweaking my own settings.db once the phone arrives later today.

Big thanks for posting this though!

[fluffyarmada]

Thanks for that, I honestly had no idea. I'm very new to Android. And this was a kludge. :)

[attn1]

http://forum.xda-developers.com/archive/index.php/t-644769.html << I got my idea from there.

If you update the /data/data/com.android.providers.settings/databases/settings.dbfile so that "install_non_market_apps" = 1 instead of 0, you will be able to install non-market apps off of your sdcard or wherever.

This works for me at least, but you'll have to root first.

I ended up editing the file with the SQLite Manager firefox add-on.

But, since that took me a really long time, I'll just upload the edited settings.db for you. (don't forget to make the extention .db instead of .db.txt)

Now, as far as I know, this won't mess anything up... BUT, I'd feel a lot better if someone who knows more about Android would provide some feedback before anyone else tries this. [It works for me, but I'm not sure if any other user-specific settings are kept in that file that I don't know about!]

But, at least for me, I no longer need to use adb to install apks that aren't from the Android Market.

I hope this is useful to someone... :)

EDIT::

You will lose your settings if you use the attached settings.db.txt file. Your best bet is to pull the file off your phone, edit it with something that understands sqlite3's database format, and then push it back. It's just better that way.

Further EDIT:: As someone pointed out later in this thread, this file unbeknownst to me when I shared it, actually has a unique ID by which phones can be identified on the android market, etc. While this isn't a huge deal, it can lead to some rather strange behavior... my phone for example has started attempting to download apps from the android market all by itself.

So--- if you want to side-load apps, change the variable in the database like I explained above. :)


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)

[Cobus]

I wonder if this might be why google voice fails to install properly for some...

Sent from my HTC Liberty using XDA App

[fluffyarmada]

I wonder if this might be why google voice fails to install properly for some...

Sent from my HTC Liberty using XDA App

It is possible. The Google apps all use the android_id, afaik.

Although, I do remember I was never able to get the settings menu to setup the voicemail forwarding... I always had to use the weird GSM code. (The weird number with a bunch of * and # that you have to type in if you follow google's directions.)

[tiga2001]

a bit confused..

how do i type in this code "/data/data/com.android.providers.settings/databases/settings.db"?

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

or something else because that doesnt work.

After you've rooted your phone, download the new settings.db into the same folder as where your adb program is. Then type:
adb push /data/data/com.android.providers.settings/databases/settings.db
in that folder while your phone is connect via usb.
I'm not sure if you have to restart your phone into recovery or not. Can someone check on this?

[fluffyarmada]

After you've rooted your phone, download the new settings.db into the same folder as where your adb program is. Then type:
adb push /data/data/com.android.providers.settings/databases/settings.db
in that folder while your phone is connect via usb.
I'm not sure if you have to restart your phone into recovery or not. Can someone check on this?

Well, it's
$ adb push /path/to/file/on/computer/settings.db /path/to/file/on/phone/settings.db

So, if your settings.db is in your tools folder, then you can do
$ adb push settings.db /data/data/com.android.providers.settings/databases/settings.db

[judicious]

what happen to the file download? i cant find it..

[fluffyarmada]

what happen to the file download? i cant find it..

Please follow the instructions posted by attn1 on reply number 13 to this thread.

I removed the settings.db, because it actually has a bunch of extra settings I didn't know about like a handset specific android_id variable... that caused me a bit of trouble... ;)

But, follow the instructions on reply #13 on this thread, and you'll be able to fix it yourself. :)

Sorry for the inconvenience.

[froggyarts]

so if we already used the file, is there anyway to revert it back to default and then change the settings via the method outlined above? or.. if we failed to make a copy of our original settings.db file.. basically am i SOL?

EDIT: nevermind, just rebooted into Clockwork and wiped the phone.

[corno1979]

when I do ./adb remount, i get the error:
remount failed: Operation not permitted

I'm in charge only mode with USB debugging on. I've toggled these settings around and nothing seems to work. ./adb shell su seems to be working right. what do you think is the problem?

[attn1]

when I do ./adb remount, i get the error:
remount failed: Operation not permitted

I'm in charge only mode with USB debugging on. I've toggled these settings around and nothing seems to work. ./adb shell su seems to be working right. what do you think is the problem?

start android, enable usb debugging and try it from there.

[corno1979]

start android, enable usb debugging and try it from there.

that's exactly what i've been doing. Any other ideas? everything seemed to work fine during the rooting instructions.

[attn1]

that's exactly what i've been doing. Any other ideas? everything seemed to work fine during the rooting instructions.

did you flash one of my roms to root or did you use the alternate method?

[corno1979]

did you flash one of my roms to root or did you use the alternate method?

I did the alt method. I guess I could try again with your rom if you think it will be different.

[moosefist]

I am glad that ended up working for someone's att android. My backflip still sucks incase you lucky, root loving aria people haven't noticed. Hopefully I will have mine soon.

[corno1979]

did you flash one of my roms to root or did you use the alternate method?
Used your rom and it worked like a charm. Thanks.

[sfernandez]

after rooting and putting in the settings.db. I just installed Droid Explorer on my pc and all I have to do is connect usb and double click what ever .apk i want to install and thats it. No need for any codes or special place to put .apk files.
Here is the link http://de.codeplex.com/releases/view/47457

[bcmobile]

Is this any different to setting 'allow unknown sources' under the application settings menu?

[fluffyarmada]

Is this any different to setting 'allow unknown sources' under the application settings menu?

This does the exact same thing. We only have to do it this way because AT&T made HTC take away the option in the menu. Luckily, that's the extent to which they modified it– and fixing it is as easy as updating the settings file manually. :)

[bcmobile]

This does the exact same thing. We only have to do it this way because AT&T made HTC take away the option in the menu. Luckily, that's the extent to which they modified it– and fixing it is as easy as updating the settings file manually. :)

Ah OK. Thanks

[indierocker774]

Or.....you could just select the option to install "unknown resources" from the applications tab with the main menu settings and use a program like Astro File Manager to install the APK...

Unless I missed something here...

indie

edit-and then I wised up and read the rest of the thread. whoops, my bad guys lol

[PUTALE]

VERY NICE WORK GUYS. man, this will come in really handy. my next phone will very possibly be an android so I will definitely apply the change.

[sfernandez]

I just installed PdaNet(for the drivers) & Droid Explorer( so you can install .apk from your PC) and all you have to do is connect usb( make sure you click settings\Application\Development\ make sure usb debbuging is enabled) and double click what ever .apk you want to install and thats it. I did this on mine which is rooted and my wife's which isnt rooted, and installed everything just fine 1,2,3.

Droid Explorer
http://de.codeplex.com/releases/view/47457

PdaNet
http://www.junefabrics.com/android/

[struff]

I just installed PdaNet(for the drivers) & Droid Explorer( so you can install .apk from your PC) and all you have to do is connect usb( make sure you click settings\Application\Development\ make sure usb debbuging is enabled) and double click what ever .apk you want to install and thats it. I did this on mine which is rooted and my wife's which isnt rooted, and installed everything just fine 1,2,3.

Droid Explorer
http://de.codeplex.com/releases/view/47457

PdaNet
http://www.junefabrics.com/android/



IT WORKS!!!! :)

I just used this method to install SiriusXM and Skype to my non-rooted Aria.


Thanks!!

[jaredcg]

when i try to pull the settings.db (adb pull /data/data/com.android.providers.settings/database/settings.db settings.db)
i get remote object does not exist any ideas thanks

[corno1979]

when i try to pull the settings.db (adb pull /data/data/com.android.providers.settings/database/settings.db settings.db)
i get remote object does not exist any ideas thanks
Try /databases/ (plural).

[attn1]

Try /databases/ (plural).

good catch. corrected.

[xdafly]

does Droid Explorer (installed on a spare XP Pro SP3 laptop) take the place on manually executing adb commands ?

if yes, how does one execute adb from Droid Explorer to make change to settings.db ? Do you run Sqlite Explorer ?

[attn1]

does Droid Explorer (installed on a spare XP Pro SP3 laptop) take the place on manually executing adb commands ?

if yes, how does one execute adb from Droid Explorer to make change to settings.db ? Do you run Sqlite Explorer ?


I don't use Droid Explorer, do I can't say.

Why not just run the commands? You only need to do it once after a wipe. it was done this way because these are tools everyone who has rooted has.

[SysAdmNj]

IT WORKS!!!! :)

I just used this method to install SiriusXM and Skype to my non-rooted Aria.


Thanks!!

Skype works? Voice over data on AT&T?

[jaredcg]

Try /databases/ (plural).

thanks that worked i need to pay more attention next time :)

[xdafly]

Why not just run the commands? You only need to do it once after a wipe. it was done this way because these are tools everyone who has rooted has.

I have not rooted and as you can see from (sfernandez) post, he has one unrooted and one rooted device with apps installed outside marketplace.

Perhaps sfernandez did not even change settings.db ?

[sfernandez]

I have not rooted and as you can see from (sfernandez) post, he has one unrooted and one rooted device with apps installed outside marketplace.

Perhaps sfernandez did not even change settings.db ?

I did change the settings.db on my rooted...but on my wifes unrooted I didn't change anything..everything is stock. The only setting I clicked on was the usb debugging. I just was trying 2 figure out how to install off PC and not on phone since I have my phone and my wifes has her phone. That is easier for me, plus she doesn't have the unlimited data like I do.

[struff]

Skype works? Voice over data on AT&T?

No, it wants to dial a phone number to voice-chat. Pretty frigging stupid IMHO.

But the point is that method worked to install it and other 3rd party apps.

[hocplyr98]

COMMON
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Reboot phone and sideloading works. (thanks fluffyarmada)


So where do I find the updated settings.db?? And could you put a thorough guide for a noob like me? I just pulled it, edited it and pushed it back, then restarted the phone. It looped the bootscreen

[HIroChi]

nvm, doing more research
Trying to figure out how to push files using eclipse.

[judicious]

i'm lost...there's no sqlite3..how do i change the format of the value for the non market app thing?

where can i find the settings.db? or how can i edit .db files?

[pvillasuso]

Why don't you all use this :

HTC Sync Update 3.0.5372

http://forum.xda-developers.com/showthread.php?t=724014

IMO , I think it's the easiest way ...

http://www.blogcdn.com/www.engadget.com/media/2010/07/7-11-10-htcsync600-copy.jpg

[oahceasgnikgneas]

Why don't you all use this :

HTC Sync Update 3.0.5372

http://forum.xda-developers.com/showthread.php?t=724014

IMO , I think it's the easiest way ...

http://www.blogcdn.com/www.engadget.com/media/2010/07/7-11-10-htcsync600-copy.jpg

I think it's because you need to use a computer (windows too) in order to do that.

If I just wanted to install an app that I already have on my SD card (say from a backup using ASTRO) then this would be quicker than turning on a computer, connecting to the computer, pulling the apps off of the phone, running HTC sync or android sdk, and installing the app.

Sent from my HTC Liberty using XDA App

[xdafly]

there's no sqlite3..how do i change the format of the value for the non market app thing?

where can i find the settings.db? or how can i edit .db files?

google this phrase and download from the first link
android sdk download

now you have the zip and you can unzip to C:\ and simply rename the folder created to C:\android

next run this batch file (start, run, cmd, ok)

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

[tiga2001]

Further EDIT:: As someone pointed out later in this thread, this file unbeknownst to me when I shared it, actually has a unique ID by which phones can be identified on the android market, etc. While this isn't a huge deal, it can lead to some rather strange behavior... my phone for example has started attempting to download apps from the android market all by itself.


So what if we already put your modified settings.db on our phones. Is there any way to restore or generate this file then try to modify the variable?

[tiga2001]

google this phrase and download from the first link
android sdk download

now you have the zip and you can unzip to C:\ and simply rename the folder created to C:\android

next run this batch file (start, run, cmd, ok)

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

To add to this. If you don't have sqlite3, you should be able to install it from your repository if you're using linux. If you're using Windows, download it from http://www.sqlite.org/download.html . Place the unzipped file into C:\WINDOWS\system32 . Also, In this line,
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
I'm not sure if you want the semicolon if you're using bash in linux. I'm not sure about the code in DOS.

[pvillasuso]

Quick request , if anyone can give me some info, please :confused:

For both root and not-rooted

Any dropbox users arround ? to try to install non-market , using it ( dropbox ) ? would it be possible , or it's the same as having an .apk @ the SDcard ?

Thx in advance ...

Edit : This was a very noob post ! :D

Thanks to all

I did it using

Droid Explorer http://de.codeplex.com/

&

SQlite Administrator http://sqliteadmin.orbmu2k.de/

[KreacherComfort]

It works! My phone feels un-crippled!

[orbhunterx]

Thank you very much!

Finally have a truly liberated Android!

[pgill34]

I am new to all of this so i was wondering is someone could post how to do this using ubuntu as i dont have access to a windows machine thanks

[Gene Poole]

I did this modification (changed 'install_non_market_apps' to 1) after I rooted my Aria. I thought all was well until I tried to use any GPS enabled app. I thought it was fried or something, but reverting to a stock ROM fixed it. I finally traced it to this setting. Enabling it in settings.db kills the GPS; resetting it to 0 re-enables the GPS. Has anyone else seen this behavior?

[xdafly]

someone could post how to do this using ubuntu

1. download the android sdk for linux and unpack
http://developer.android.com/sdk/index.html

2. as an alternative, you could grab the linux tools and unpack
http://www.mediafire.com/?1dqytjijveq
(I put mine on /home/ubuntu/tools)

3. open konsole as root
prefix all the commands with ./ so for example adb devices is ./adb devices

ie.

./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

[xdafly]

.. until I tried to use any GPS enabled app. I thought it was fried or something, but reverting to a stock ROM fixed it.

after you applied the setting, did you reboot the device ? I've now flashed dozen Aria's with liberated..B003 and ran the same sideloading enabling set of commands and GPS apps are working fine.

[mcangeli]

Ok, I managed to get it working using the adb method in the command window. On windows 7 you have to run CMD as an administrator in order to have proper privileges...

[Gene Poole]

after you applied the setting, did you reboot the device ? I've now flashed dozen Aria's with liberated..B003 and ran the same sideloading enabling set of commands and GPS apps are working fine.

Yes, several times.

I found this post searching:

forum.xda-developers.com/showpost.php?p=7189504&postcount=198

The GPS thing is crossed out but no explanation on why. I'll followup in that thread.

[spdivr]

I used this post to load an apk from the SD card. I used Root Explorer to navigate to the setting listed at the beginning of the post, then used SQLite Editor to open the "Secure" link and sure enough, there was the line about allowing unsupported sources. I pressed on the field that showed "0", clicked in the menu to edit, changed it to one, rebooted and then used a free APK installed from the market to install the app. Worked great!

[arajay]

i'm sorry to seem like such an idiot but i can't get any of the ./adb commands to work... i'm not even sure my comp is seeing the phone.. clockwork worked and my aria is rooted with liberated b005...

could someone please post a step by step for OSX from the beginning? i feel like i'm missing a step somewhere and i'm pulling my hair out when i know its something simple..

still loving Android tho. and my little aria is a beast. much needed upgrade from WM...

[ocswing]

i'm sorry to seem like such an idiot but i can't get any of the ./adb commands to work... i'm not even sure my comp is seeing the phone.. clockwork worked and my aria is rooted with liberated b005...

could someone please post a step by step for OSX from the beginning? i feel like i'm missing a step somewhere and i'm pulling my hair out when i know its something simple..

still loving Android tho. and my little aria is a beast. much needed upgrade from WM...

See post #13 in this thread for the instructions. There's really not much more to it than that.

Install the Android SDK first. Open Terminal and navigate to your sdk/tools directory. Then run the commands as instructed. The "echo" command probably won't return anything, but you should get confirmation text when doing the remount, push, or pull commands.

Edit: Also, you can check to see if your phone is connected by entering 'adb devices' in your terminal window. Should be listed as HTCXXXXXX. "XXXX" will be some series of numbers and letters.

[capychimp]

Hey guys, i am trying to port this one to magic and hero with a friend, goes well for us, but we met this problem you have too,

well if your running a rom based on the RUU and deodexed i have a fixed file for you, that makes editing the setttings.db not needed, i have attached a flashable zip file for you, or you can extract the file and cook your roms, and not worry about unsupported sources.

you can't see it in the settings menu or anything, it is just enabled by dafault and you cannot switch it off. but it works 100% well on the port based of the RUU so should for you too, i will upload a zip for odexed roms too, so you have it for all
3rdpartyapps.zip deodexed rom
3rdpartyapps_odex.zip odexed rom

[capychimp]

did it function for you guys?

[hashbrown]

nope, neither one worked for me. I tried to flash both from clockwork.

[capychimp]

you tried install an apk afterwards? i mean after flashing this?

[arajay]

Im sorry i got so excited once i got it to work... thanks for letting me know i shouldn't see anything after the echo.

Sent from my HTC Liberty using XDA App

[capychimp]

so it does work for you?

[hashbrown]

Not working, I tried to flash apps stored on my sd card. I still got the security block after flashing that zip. Actually both zip files. Ive since moved to cm6 rom and don't have to worry about app blocks anymore!

Sent from my Liberty using XDA App

[CamthalionElendil]

So I manage to get the settings.db out of my Aria.
Now how I edit it??:o

[DKuntz2]

So I manage to get the settings.db out of my Aria.
Now how I edit it??:o
http://forum.xda-developers.com/showpost.php?p=7010987&postcount=13

[jmreed97]

http://forum.xda-developers.com/showpost.php?p=7010987&postcount=13

I've got it working... I couldn't get ADB to work properly (and want to stay with a stock ROM for now). So I downloaded the sqlite editor from the market (already had root explorer) and edited the settings.db manually.

Make sure you do a nandroid back-up first. I'm not sure what I did wrong the, but I got stuck in a bootloop the first time and had to restore my back-up and try again.

Thanks to everyone who posted how to do this!

[jmreed97]

Ok, I managed to get it working using the adb method in the command window. On windows 7 you have to run CMD as an administrator in order to have proper privileges...

I missed this post. This must have been my problem. How do you run CMD as an administrator though?

[vtec1]

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\android-sdk-windows\tools>adb devices
List of devices attached
HT06MR000935 device


C:\android-sdk-windows\tools>adb remount
remount succeeded

C:\android-sdk-windows\tools>adb pull/data/data/com.android.providers.settings/d
atabases/settings.db settings.db
Android Debug Bridge version 1.0.26

-d - directs command to the only connected USB devic
e
returns an error if more than one USB device is
present.
-e - directs command to the only running emulator.
returns an error if more than one emulator is r
unning.
-s <serial number> - directs command to the USB device or emulator w
ith
the given serial number. Overrides ANDROID_SERI
AL
environment variable.
-p <product name or path> - simple product name like 'sooner', or
a relative/absolute path to a product
out directory like 'out/target/product/sooner'.

If -p is not specified, the ANDROID_PRODUCT_OUT

environment variable is used, which must
be an absolute path.
devices - list all connected devices
connect <host>:<port> - connect to a device via TCP/IP
disconnect <host>:<port> - disconnect from a TCP/IP device

device commands:
adb push <local> <remote> - copy file/dir to device
adb pull <remote> [<local>] - copy file/dir from device
adb sync [ <directory> ] - copy host->device only if changed
(see 'adb help all')
adb shell - run remote shell interactively
adb shell <command> - run remote shell command
adb emu <command> - run emulator console command
adb logcat [ <filter-spec> ] - View device log
adb forward <local> <remote> - forward socket connections
forward specs are one of:
tcp:<port>
localabstract:<unix domain socket name>
localreserved:<unix domain socket name>
localfilesystem:<unix domain socket name>
dev:<character device name>
jdwp:<process pid> (remote only)
adb jdwp - list PIDs of processes hosting a JDWP transport

adb install [-l] [-r] [-s] <file> - push this package file to the device and i
nstall it
('-l' means forward-lock the app)
('-r' means reinstall the app, keeping its data
)
('-s' means install on SD card instead of inter
nal storage)
adb uninstall [-k] <package> - remove this app package from the device
('-k' means keep the data and cache directories
)
adb bugreport - return all information from the device
that should be included in a bug report.

adb help - show this help message
adb version - show version num

DATAOPTS:
(no option) - don't touch the data partition
-w - wipe the data partition
-d - flash the data partition

scripting:
adb wait-for-device - block until device is online
adb start-server - ensure that there is a server running
adb kill-server - kill the server if it is running
adb get-state - prints: offline | bootloader | device
adb get-serialno - prints: <serial-number>
adb status-window - continuously print device status for a specifie
d device
adb remount - remounts the /system partition on the device re
ad-write
adb reboot [bootloader|recovery] - reboots the device, optionally into the boo
tloader or recovery program
adb reboot-bootloader - reboots the device into the bootloader
adb root - restarts the adbd daemon with root permissions
adb usb - restarts the adbd daemon listening on USB
adb tcpip <port> - restarts the adbd daemon listening on TCP on th
e specified port
networking:
adb ppp <tty> [parameters] - Run PPP over USB.
Note: you should not automatically start a PPP connection.
<tty> refers to the tty for PPP stream. Eg. dev:/dev/omap_csmi_tty1
[parameters] - Eg. defaultroute debug dump local notty usepeerdns

adb sync notes: adb sync [ <directory> ]
<localdir> can be interpreted in several ways:

- If <directory> is not specified, both /system and /data partitions will be u
pdated.

- If it is "system" or "data", only the corresponding partition
is updated.

C:\android-sdk-windows\tools>echo select value from secure where name = 'install
_non_market_apps';|sqlite3 settings.db
Error: near line 1: no such table: secure

C:\android-sdk-windows\tools>

what am i doing wrong?

[hashbrown]

Put your phone in recovery mode.
Goto advanced>mount system and mount data.
Follow steps in post #13 in cmd screen and you'll be fine.

[vtec1]

Sweet thanks!!!!


Sent from my Liberty using XDA App

[ckuke4]

Put your phone in recovery mode.
Goto advanced>mount system and mount data.
Follow steps in post #13 in cmd screen and you'll be fine.

Yes, this is what works. It was said to not put your phone in recovery mode in some of the directions, but this is what worked for me. Maybe someone could make this a sticky so we don't have to wait until page 8 to finally see how to do it. Cheers.

[Sengfeng]

...Also be aware that putting the file back in place generally has to be done while the phone is in recovery mode as the system files are locked from deletion while Android is running.

[alain_HTC]

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:

[list]
COMMON
Enable USB debugging (settings > applications > development > USB Debugging)
adb remount
....

I have S-Off + installed 'su' on my HTC Aria phone (I can run Ti backup and it does get root access) and have admin access to my win7 machine (I run cmd.exe as Admin) and installed the latest Androuid SDK (which puts adb under platform-tools/ directory so I ahd to update path to that and android-sdk\tools dir)

but when I run

C:\tmp>adb remount
* daemon not running. starting it now on port 5037 *
* daemon started successfully *
remount failed: Operation not permitted

what am I missing (win7) ?

I called AT&T tech support 4 times over a week to get the patch upgrade for sideloading and they can't figure it out...so I figure I will try this instead.

[M1m3R]

...digging up old threads...

http://forum.xda-developers.com/showthread.php?t=730398
^^ that one has some more info...

http://de.codeplex.com/
^^ looks like one could edit the sqlite value on the phone.

...or, you could look into installing a different ROM...

[alain_HTC]

C:\tmp>adb remount
remount failed: Operation not permitted


thanks M1m3R !

found the solution reading the first old thread - elboby post #29 http://forum.xda-developers.com/showthread.php?t=730398&page=3

the ONLY way to get this to work (I read all the thread, running cmd.exe as admin on win7 didn't solve it, short of getting a custom ROM which I didn't want to) was to do this:

1.Reboot into ClockworkMod Recovery
2.Choose partitions menu
3.select mount /data
(for me CWM 2.5.0.7 I had to mount /data *and* /system and they were not under partition menu, but data mount... but you get the idea)
4.Run the commands to get the sideload...see post#13 by attn1

Gene Poole then said
The system partition doesn't like to be mounted read/write in normal operating mode. +1 on the clockwork method.

[M1m3R]

thanks M1m3R !
Glad you go it going.