Database Users

[Android] Run Android without a data plan [CHECKLIST]

Hey Gang,
I currently do not have a data plan and won't get one until I switch from Sprint to Verizon. (accounts expire soon)
This is what I want to do with my Vogue:
Setup SD card with EXT2 partitions [CHECK]
Correctly install/run a SenseUI/Hero build [CHECK]
Convert my WM contacts to Android contacts offline [CHECK]
Install APK's offline [CHECK]
Use the internet connection through my PC via USB cable (while running android) [PENDING]
Install a "camera software" APK so i can use the camera [PENDING]
Enjoy the hell out of Android and all the possibilities for the Vogue! [CHECK]
Any and all help checking off my list is much appreciated!
~Syn

The camera already works out of the box. and Talk to enatefox about internet via USB connection.

Install a "camera software" APK so i can use the camera [PENDING]
I am currently using "Pro Paint Camera that came with this Hero/SenseUI build.
I can take pictures but not video. Also, none of the lighting effects work so every picture is very yellowish.
True.... the camera does work, but it is not really usable without adjustment.

I'm in the same situation right now. I want to use android but I'm afraid I wont be able to use internet to access the market (unlike WM/ActiveSync).
The camera issue is something that I can deal with, but I think that it would be nice if someone could make an activesync-like program that can share internet.
Only difference is that I'm on verizon right now, and might consider switching to sprint!

synaptyc said:
Install a "camera software" APK so i can use the camera [PENDING]
I am currently using "Pro Paint Camera that came with this Hero/SenseUI build.
I can take pictures but not video. Also, none of the lighting effects work so every picture is very yellowish.
True.... the camera does work, but it is not really usable without adjustment.
Click to expand...
Click to collapse
I forget exactly when that build came out, but I can assure you that the build I'm using now has a camcorder and camera app outside of Paint Pro Camera.
FWIW, I'm using the Droid donut ion build by Zenulator.
Also, from what I know, internet through USB only allows you to browse the web, and the marketplace doesn't work. There might be some changes in the future, however.

Yes. with Cupcake / Donut the camera/camcorder seem to work with the default applications. They still don't have filters or effects to correct lighting.
... still looking for that app.

Link9228 said:
I forget exactly when that build came out, but I can assure you that the build I'm using now has a camcorder and camera app outside of Paint Pro Camera.
FWIW, I'm using the Droid donut ion build by Zenulator.
Also, from what I know, internet through USB only allows you to browse the web, and the marketplace doesn't work. There might be some changes in the future, however.
Click to expand...
Click to collapse
How would one go about getting Internet via USB? I have searched endlessly (or so I thought). Thanks.

gascan555 said:
How would one go about getting Internet via USB? I have searched endlessly (or so I thought). Thanks.
Click to expand...
Click to collapse
I've been trying to do this too!

gascan555 said:
How would one go about getting Internet via USB? I have searched endlessly (or so I thought). Thanks.
Click to expand...
Click to collapse
I have also been trying to figure this out... but getting Internet via bluetooth rather than USB. So kind of like the bluetooth tethering that is possible right now with Android, but in REVERSE! So Internet-> PC-> Bluetooth-> Android.

USB Internet (at this point) can be very problematic. It can cause your phone to hard freeze out of the blue. I haven't spent a lot of time troubleshooting it since it's hard to figure out what went wrong when I'm forced to reset.
Credit to DimaFern for getting me anywhere near having this working. I just messed with it a little. This is reverse tethering because you are not getting the connection from the phone. So the USB Tethering option is not related in this situation.
Here's my howto
I have not tried this without a Linux host. I believe you can forward traffic with ICS but I don't know what is involved there.
My gateway is .37, my laptop is .107 and the phone gets it's IP from the laptop:
On laptop:
echo "1" | sudo tee /proc/sys/net/ipv4/ip_forward
On Android:
ip addr add 192.168.37.100/24 dev usb0
ifconfig usb0 up
## This is the IP for my laptop:
route add default gw 192.168.37.107
setprop net.dns1 192.168.37.107
cat /proc/net/route
Click to expand...
Click to collapse
The last line is not needed-- it's to show you that it's routing traffic. You won't be able to ping IPs from the command line and somehow Market doesn't think you're online but SAM Market, Browser, etc. do work. It's nice because you are not taxing the RAM of the phone for connectivity so it runs much quicker... unless it hard freezes on you.

i use tetherbot to tether my phone now that it's running android full time. basically install tetherbot and start the socks proxy server on port 1080 then.
Code:
adb forward tcp:1080 tcp:1080
from your computer and set up firefox to connect manually to the proxy.
http://www.google.com/url?sa=t&sour...tLoX-20q2czcpvdhw&sig2=YLuIUO1a9NqdzdKn2NhO5Q
http://www.google.com/url?sa=t&sour...D0n7yQtvLGRfy1GXg&sig2=OMS2j6DiIEHenOugM9VbSg

zenulator said:
http://www.google.com/url?sa=t&sour...D0n7yQtvLGRfy1GXg&sig2=OMS2j6DiIEHenOugM9VbSg
Click to expand...
Click to collapse
WOW..... this second link leads to a beautiful website.
10 levels of gay for poor "kevin" of 'kevin♥Amanda' but still a nice looking site
Geez.... he didn't even get his name capitalized in the header picture
/on_topic: I'll try Tetherbot.
(is there a way to use Tetherbot with Google Chrome? I haven't used Firefox in ages)

zenulator said:
i use tetherbot to tether my phone now that it's running android full time. basically install tetherbot and start the socks proxy server on port 1080 then.
Code:
adb forward tcp:1080 tcp:1080
from your computer and set up firefox to connect manually to the proxy.
http://www.google.com/url?sa=t&sour...tLoX-20q2czcpvdhw&sig2=YLuIUO1a9NqdzdKn2NhO5Q
http://www.google.com/url?sa=t&sour...D0n7yQtvLGRfy1GXg&sig2=OMS2j6DiIEHenOugM9VbSg
Click to expand...
Click to collapse
I'm sorry, but isn't Tetherbot used to share your phone's internet connection with your computer?
I think we are trying to be able to "reverse tether" and not tether.

enatefox (and others)...
I would love to see how this reverse-tethering can work. I know its very complicated and buggy right now, but if you do any more work on it you should create a thread showing how in layman's terms. I have dual-boots on both my computers into Ubuntu 9.10, I know what the terminal is and sudo and some basic commands, but when you type your commands with little explanation I get lost. They could use some clarification [ such as 1) open terminal 2) type these commands. ] And please explain terminal in Android. What apk do I need? I probably have it already but just need to install it. Thanks for any help. I don't have data since my line costs $10 a month (family plan) and data would be $26 a month. I just started reverse-tethering with WM6.5.1 and its really cool.

There aren't any other steps you just run what I posted and change "192.168.37.107" to what your desktop's IP is and "192.168.37.100" to "192.168.xxx.100" where "xxx" is the subnet of your LAN-- matching the 3rd set of numbers of your desktop's IP.
You can run these commands over ADB, which is required to do this. Here's a guide on how to set it up.

Here is what I came up with trying to do the same thing with bluetooth instead :
http://forum.xda-developers.com/showpost.php?p=4404512&postcount=9
I was missing your "ip addr..." command to add the forwarding network, this should help, I will give it a try.
I also came to the conclusion that I needed a way to fake that either the wifi or the data connection was up. Maybe this can be done by issuing a "setprop" command forcing the status to being "up"?

enatefox said:
There aren't any other steps you just run what I posted and change "192.168.37.107" to what your desktop's IP is and "192.168.37.100" to "192.168.xxx.100" where "xxx" is the subnet of your LAN-- matching the 3rd set of numbers of your desktop's IP.
You can run these commands over ADB, which is required to do this. Here's a guide on how to set it up.
Click to expand...
Click to collapse
UGH I'm stuck right now. I'm using Ubuntu 9.10, and when I type in terminal "sudo /etc/init.d/udev restart" I get some error message telling me to do it a different way. So even after restarting the computer, it does not recognize any command for adb. I already did the export PATH to the androidsdk/tools folder and adb is in there, but I cannot get it to open. Any ideas?

Got it to see adb. I forgot to put /home/drkow19 in front of the path...
edit: Has anyone successfully used ADB with zen's 2.0.1? I'm trying right now but it shows no devices connected. In the 50-android.rules file I have 0bb4 instead of 18d1 like enatefox said to. Also, on the Dream forums the file they use is 51-android.rules, whats the diff?

0bb4 and 18d1 are determined in the source code. Different versions can change so whichever is shown, use. The 50 and 51 are indicators for timing. Maybe I have this backwards but 51 should start later than 50 and can address issues with it not being recognized or more precisely, overrode with another operation. I set mine to 51.

Okay I deleted 50 and used 51-android.rules. What is the line about "define vendor id" does that need to be in the 51 file?
I can say adb start-server but no devices... They say you need to sudo adb start-server but when I try that I get "sudo: adb: command not found" How do you add the adb PATH so it works under sudo as well?

Block ads on your Android phone (2010-04-15)

AdFree is a fantastic program created by XDA user delta_foxtrot2 (see this thread in the G1 forum) to facilitate using your hosts file to block ad servers. This makes it extremely easy. Of course you will need root access!
Unfortunately I found some ads still weren't blocked and the last update to the AdFree hosts file happened 2010-02-27. So I decided to update the hosts file myself. I merged the hosts files from adfree/mvps/yoyo and added a bunch of mobile ad providers I've found myself. The list is free of duplicates and comments, so as to keep it as small as possible (it still amounts to about 635 kB).
To install this hosts file, you still need root access obviously:
download the zip
unpack it to the directory where adb.exe is located (if you don't know what adb is or how to get it running, please use the search)
open a command prompt
Code:
adb shell mount -o rw,remount -t yaffs2 /dev/block/mtdblock3 /system
adb push hosts.for.mobile.txt /etc/hosts
adb shell mount -o ro,remount -t yaffs2 /dev/block/mtdblock3 /system
You might need to restart your phone. Also clearing the Android browser cache will apparently help in getting rid of already cached ads (worked for me, ymmv).
As for ethical discussions on blocking ads for free apps, blah. I don't so much have a problem with ads, as I do with the personal data that gets send to the ad providers. I'm talking about location data and whatever else they might want to know about my device and what I'm running ("analytics" is a fancy name for "we want to find out as much about you as we possibly can get away with").
Anyway.. use it, don't use it, up to you.
Last updated
15-4-2010 23:23 (20808 hosts blocked)
.

Thanks a bunch!

Thanks for the updated hosts. So should we even bother with the program, especially if it doesn't get updated hardly at all?

You're welcome!
If you push my hosts file, you don't need the AdFree app, but I wanted to acknowledge his work and give people a simpler alternative to using adb.
Best choice right now is my hosts file as it's simply more comprehensive.
Sent from my HTC Hero using the XDA mobile application powered by Tapatalk

phaelox said:
You're welcome!
If you push my hosts file, you don't need the AdFree app, but I wanted to acknowledge his work and give people a simpler alternative to using adb.
Best choice right now is my hosts file as it's simply more comprehensive.
Sent from my HTC Hero using the XDA mobile application powered by Tapatalk
Click to expand...
Click to collapse
Understood. Yeah, it was a great start/beginning to blocking ads, but no updates. Thanks again.

Thanks! I've been looking for something like this for awhile. Real quick question: is getting "Data connectivity errors" in browser normal with this? It didn't start till I pushed this on my phone.

tmayne said:
Real quick question: is getting "Data connectivity errors" in browser normal with this? It didn't start till I pushed this on my phone.
Click to expand...
Click to collapse
Short answer: Yes.
Long answer:
You may know this, but I'll explain anyway. The way this works is as follows. The loopback address for any network interface is 127.0.0.1 -- this is the address for the device, but only from the device itself, it loops back on itself. We don't want to waste bandwidth with ads, or have ad providers collect all sorts of data on us, so we don't want to connect to them. Any FQDN -Fully Qualified Domain Name- (for example: analytics.admob.com) needs to be converted into an IP address to be able to connect to it. Here's where the 'hosts' file comes in. It's a simple text file with a record on each line that says redirect 'hostname' to 'ip-address'. So we put a line in that reads '127.0.0.1 analytics.admob.com'. This tells our device that any connection made to 'analytics.admob.com' needs to be redirected to '127.0.0.1', which is your device. Basically a dead-end, as you are not running their webserver serving ads on your device, so this results in a data connection error.
Now, usually you will surf to a site that loads images (advertisements) from a server that is listed in this hosts file, and as a result the ads will not load. That shouldn't popup any error windows. But if you try to visit http://analytics.admob.com in your browser, then yes, you will see an error.
If the latter happens with a site you do wish to visit, just open the hosts file in a text editor (one that supports UNIX-style line ends) and remove the line in question, or put a '#' in front of the line to comment it out.
Hope that made it clearer.

Yeah it did. No worries though since it seems that after pressing "Ok" everything works fine! Small trade off for blocked ads! Thanks!

Thanks for this How-TO!
So basicaly that mean we can restrict acces to certain websites from our phone?
eg: adding this line
Code:
127.0.0.1 forum.xda-developers.com
and I'll no longer be able to browse XDA from my phone?
Keep writing such How-To, like this one and the one to sign update.zip, I found this interessant and usefull

tmayne said:
Yeah it did. No worries though since it seems that after pressing "Ok" everything works fine! Small trade off for blocked ads! Thanks!
Click to expand...
Click to collapse
You're welcome, glad I could help.
carbonyle said:
Thanks for this How-TO!
So basicaly that mean we can restrict acces to certain websites from our phone?
eg: adding this line
Code:
127.0.0.1 forum.xda-developers.com
and I'll no longer be able to browse XDA from my phone?
Keep writing such How-To, like this one and the one to sign update.zip, I found this interessant and usefull
Click to expand...
Click to collapse
Cheers. And yes, that's exactly right. Just remember the hosts file takes FQDN's, so you can block a domain (or subdomain) this way, but not a directory or page on a domain. Also, blocking a domain does not also block its subdomains.
PS. this method of using the hosts file is not unique to your android phone, it works on most operating systems on PC as well. See this Wikipedia entry for more info.

what about non rooted phones? I just got myself a htc desire, I'm happy with it but would be happier if I wouldn't be required to see all those ads.

Unfortunately root is required to remount /system as writable to be able to overwrite the hosts file.
Without root you could use another free app found in Market called "AdBlock", which functions as a localhost proxy. Just set localhost as proxy in APN/wifi settings. It doesn't come with a prefilled list of keywords to block though, but it works on a URL level, not FQDN, so you can specify a url or part of it to block.

Just one more quick concern about the Data Connectivity issues: Certain areas of my university require a redirect page login in order to connect to wifi. However, it seems that at certain locations, I get the Data Connectivity error pop up repeatedly and my phone never makes it to the redirect page.
Actually it seems my phone only likes the wifi in my dorm. As stepping outside (to a library or classroom) and attempting to connect to the same wifi produces the error.
Is this an issue with the hosts file or with the phone itself??
Thanks!

If you DO see the wifi redirect page at SOME locations, then the hosts file is not blocking it (wouldn't make sense as it's likely an intranet page anyway). Sounds like wifi reception is unstable on your phone.
This is getting off-topic, but..... Have you already updated your radio? (the part of the ROM that handles everything related to GSM/3G/WiFi/Bluetooth connections). If not, here for the latest radio update.zip - flash through recovery.

phaelox said:
If you DO see the wifi redirect page at SOME locations, then the hosts file is not blocking it (wouldn't make sense as it's likely an intranet page anyway). Sounds like wifi reception is unstable on your phone.
This is getting off-topic, but..... Have you already updated your radio? (the part of the ROM that handles everything related to GSM/3G/WiFi/Bluetooth connections). If not, or the latest radio update.zip - flash through recovery.
Click to expand...
Click to collapse
I should note that I'm using a Motorola Cliq...Handler 1.5 ROM. There is a radio update available for the Motorola Cliq (I'm currently using 1.3.18 and 1.4.8 has been released) but there are some apk incompatibilities with it (particularly Swype which I love...since it's in closed beta right now, there are no accessible updates for it unfortunately).
Since I bought my phone off of ebay, I can't send it back for a new one. The essential things work but it is a bit frustrating that it has some problems.

tmayne said:
I should note that I'm using a Motorola Cliq...Handler 1.5 ROM. There is a radio update available for the Motorola Cliq (I'm currently using 1.3.18 and 1.4.8 has been released) but there are some apk incompatibilities with it (particularly Swype which I love...since it's in closed beta right now, there are no accessible updates for it unfortunately).
Since I bought my phone off of ebay, I can't send it back for a new one. The essential things work but it is a bit frustrating that it has some problems.
Click to expand...
Click to collapse
I'm pretty sure that updating radio won't affect other softwares since "radio" is *just* the piece of code that can handle GSM/Wifi/BT/3G, ... signals

I'll always keep an open mind, but from what I know, I'm with carbonyle on this.
Back on topic:
if you come across an app that still displays ad, regardless of my hosts file, please reply in this topic with the app/version (and a logcat output would be nice if you know how) and I'll see if I can find the ad provider domain and update the hosts file.

I'm confused... This is for blocking apps adds???

:No-Frost: said:
I'm confused... This is for blocking apps adds???
Click to expand...
Click to collapse
Yes it is. See it like a firewall wich blocks mobile ads. Because the app wont recieve any response from the ad url it tries to reach, it'll simply not display the ad (like when you use the app without wifi or data connextion on)

Wooooooo thanks... worked like a charm in glympse shazam and others =D...
PS: Air Control still have adds... Mmm how can we know what's the host for the add in the apps so we can contribute into blocking them???

Watching Video on your Xoom

Most of the information in this post is covered in various threads but I was recently looking for various options for playing video on my XOOM and found it frustrating having to look all over the place. I'd like to try and make this a comprehensive guide to playing video on the XOOM, including streaming over wifi, playing directly from the device etc.
Before you read on...
This isn't always a necessary step, but whenever you plan to interact with your device via USB you should ensure you have the latest version of the USB drivers from Motorola. In my case I was able to access the XOOM and move files to it without any specific drivers, but it's a good idea to keep them up-to-date to avoid potential frustration. Of course if you need to use ADB, you will absolutely need the latest drivers or you'll have no luck at all.
Playing directly from the XOOM
This is obviously the simplest solution, copying the video files onto your XOOM and playing them directly. This won't be the most appropriate solution for those of you with extensive digital media libraries, but we'll cover solutions for that later.
Plug your XOOM into your PC using a micro-USB to USB cable, one of which is typically provided in the box. You'll see your device pop up under "Computer" (Windows 7 & Vista) or "My Computer" (Windows XP).
Double click the device and you'll see that you're able to directly access the device's internal storage.
Double click that and you'll now be looking at all the folders and files on your device
You can now copy files to the device as though it was any other folder on your computer. Feel free to create a folder (I use one called "Files from Computer") if you'd like to keep your copied files separate from the system created stuff.
Choose your player! With all the files copied over to the XOOM, you're ready to play them but you'll first need a decent player capable of playing a range of formats. A couple of my favourites are:
vPlayer
Rockplayer
If there are others that should be added to this list, let me know.
You're all done - either of the above players should be able to play most video files, though I can't say I've really pushed them as most of my files are just XviD avi's. In my experience I've found vPlayer to be slightly better than Rockplayer especially when it comes to seeking, but Rockplayer's free version is an ad-supported full version and vPlayer's is just a temporary trial so it comes down to preference and willingness to pay for a little extra functionality.
Streaming over Wi-fi
This is going to be the preferred solution for many people, since it doesn't involve any copying/moving of files and will allow you to access that media library that you've spent so much time meticulously organising. There's a few different approaches here, I'll cover the simplest approach first.
Streaming from TVersity
If you already have TVersity set up, then you won't need to do much at all and you can skip straight to step 3. Otherwise, you can follow these directions to get it up and running.
Head to TVersity.com and grab the latest version of TVersity. I won't go through the setup and so forth as it's all pretty straightforward and is covered well in TVersity's own documentation.
Once you have TVersity set up, add your video directories to the library and (optional, but preferable) give your computer a static IP address on the network.
Open up your browser on the XOOM and navigate to "YOUR-IP-ADDRESS:41952".
You should see a TVersity page load up with various navigation options. From here it's pretty obvious how to drill down through your folders and locate any file you'd like to play. When you click a file to play it, you will be able to choose which media player you'd like to handle the file in. I've found vPlayer is capable of seeking and will play it quite nicely, but Rockplayer works well also, just without the ability to seek.
Mounting a Network Share
This is more complicated for the novice user (me, for example) but it works well enough and the end result is a little more user friendly once you get there. The major drawback with this one is you must root your device for this method. If you don't want to root your device, you'll need to use one of the other methods discussed in this post. This method allows you to mount a folder that you've shared over the network so that it can be accessed on the tablet as though it's actually a part of the tablet's file structure. This means that almost all video players should simply play the files without too much trouble (at least, theoretically; I can confirm vPlayer and Rockplayer as working with this method).
There are two apps capable of mounting shares, but before we get into that we'll need to ensure you have a CIFS module installed. If you're like me, you're probably wondering wtf a CIFS module is. When you root your device (I used the "one click" process described in this thread) you'll need to find a "cifs.ko" file that matches the particular kernal you've installed. If you use the aforementioned method, you'll find a cifs.ko file you can use inside the zip file (inside the "timat" folder).
Once you have the module use Root Explorer to copy it (or use adb to push it) to this location: /system/lib/modules/cifs.ko and then reboot your XOOM. If you have adb installed on your computer, you can use these steps to verify that it's loaded:
Code:
adb shell
lsmod
You'll be wanting to see the CIFS module in the list as a loaded module. If it's not loaded try typing:
Code:
insmod /system/lib/modules/cifs.ko
If you get an error like I did saying "exec format error" it means you've got the wrong cifs.ko for your kernal, so you'll need to poke around some more and locate the right one.
Congratulations, if you've made it this far you've completed the hardest part - the rest is easy.
Make sure you have an actual folder shared to "Everyone" on your network. Optionally, but preferably, give your computer a static IP address. If you don't do this you'll need to change your settings every time your computer gets a new IP.
Install "Mount Manager" or "CIFS Manager" from the android market. I'll give instructions for CIFS Manager but Mount Manager is just as good and works just fine if you'd rather use that.
Open CIFS Manager. You'll need to do this from the "My Apps" section of the market because for some reason it won't start from a shortcut or from the apptray - annoying!
Open the app-menu and select "Add New Share..."
Your share path should be: "IP-ADDRESS/FOLDER-NAME"
Your mount point will be the location you'd like to mount the share to on your internal memory. By default it likes to mount in "/mnt/cifs/FOLDER-NAME", but this is really up to you. Pick whatever you like here and then go to the next field.
Username/password will be a valid account you can use on the computer hosting the share. I just used my regular Windows 7 account here.
Click "Save Share".
Long-press the new share you've created and then select the option "Mount" when it comes up.
If all is well the icon on the right will turn green and you can now access your share by browsing to your mount point in your favourite video player.
Encoding video for optimal playback
-- COMING SOON --
Conclusion
As I mentioned at the beginning of this post, I had a lot of trouble filtering through all the different posts on this topic and it took a lot of time for me to eventually find and experiment with each of these different options. Hopefully I've saved you all some time and helped out with some of the sticking points you might encounter. If anyone has anything they think I should add, just let me know.
I do plan on adding a section for streaming over 3G, but since I haven't tried it myself (I have a wifi-only XOOM) I can't really contribute to that side of things yet.
If you catch any typos or errors in the above text, please let me know asap and I'll fix them right up. This is my first thread here, and I haven't even made 8 posts yet so I couldn't include external URLs, I'll go through and edit some useful links in as soon as I'm able.

getting data off of broken G1/Dream [rooted]

I have a broken G1, the screen is shot, and something else is screwed up, because it won't process anything. Once it boots it shows the background for a moment, then the lock screen comes on, but without a background. Then it looses all functionality. I can't get it to do anything. However, what's interesting, is that if I get an incoming call, I can answer using the button (not screen), and talk normally. Anyway, I want to know if there is a way, probably using ADB to get all my contacts minimally (since they're not all sync'd w/ Google), but ideally I would like to make a system image from it and run it in one of the emulators (Eclipse, Spring Source or Android SDK is what I have installed now). Any help would be awesome. There are also a few nandroid backups that I could use somehow, but they are a little old.

As far as I know, contacts data is stored in a sqlite-database which is located on /data. As long as you can connect with adb to your phone, you can copy that database to your pc and analyze it using sqlite3.
In this article you can find some additional information. It's a bit old, but still valid and at least it can give you a hint.
If you cannot access to your phone using adb, you can also extract the contacts.db from your latest nandroid backup. You can use unyaffs or mount your image on a linux system as yaffs file system and extract the file(s) you want. Then you can use again sqlite3 to extract the contacts data.
The same way, you can extract other data. It's enough to concentrate on the /data partition of the G1. As long as adb is running, you can copy them to your local PC, if not, you need to extract them from your latest nandroid backup in the same way I described above.

there is an awesome application called droid explorer (i forget the developers name) that you can download free to your pc (probably mac too) if you have usb debugging turned on then all you have to do is plug your phone into pc via usb.
when your phone comes up you have all the options you need here plus more!
seriously i recommend it to everyone. i use it at work sometimes to access my phone without getting caught, it has a great screen-cast function (a bit laggy)
if you dont have usb debugging turned on then look in the forum how to do it via adb. if you cant find droid explorer let me know and i can put it in my dropbox.
another option is get a used g1 from ebay and swap motherboards. or just fix your screen or whatever the problem is

Ok... So I did a little snooping via adb, and fortunately I did leave usb debugging on, so that's a plus. Now there were 2 things that I've tried pulling:
/data/data/com.android.contacts
and
/data/data/com.android.providers.contacts
Unfortunately, these both just gave me .xml files that only had a few lines of code, none of which included contacts or any kind of useful info.
@AndDiSa: I'm going to read the linked article now, but currently I don't have anything useful from /data. Any tips on how I would go about extracting the contacts.db? Articles or links are always great!
@demkantor: I will check that out. Since I don't really know how messed up the phone is, I don't know how useful droid explorer will be, but it sounds like a good utility anyway.
I don't really feel like getting parts for my phone. It's already waaaay behind the curve, and while it's a super fun phone to mess around with, I think it's time to move to something new (like the Droid 1 that I got as a toy phone/media player since I don't have verizon).
Anyway, further help appreciated!
(Oh, and I have to replace the digitizer for my Droid. LOL)

I am not on my PC at the moment, but try to look for
/data/com.android.providers.contacts/databases/contacts2.db
at least in GB this should be the right file or do a
find /data -name "cont*db" -print
in adb shell to look for it.
Sent from my Gingerbread on Dream using XDA App

I'll check it out tomorrow and let you know how it goes. Thanks!

OK! Good news. I found the contacts2.db and was able to pull it. I got SQLite3.exe and started messing around with it. Now what I tried from the link didn't work, as I couldn't get the .db file imported, and don't really know how to declare that as the target of commands. Using the .tables or .databases commands didn't get any results either. .databases just said something like 0-Main and 9-local or something. Do you know how to pull this part off? Hope to hear back soon.
Thanks,
kyle_engineer

Didn't try to use sqlite3 on windows yet, on the phone, you need to do
sqlite3 contacts2.db
> .dump
and you will get all content of the database dumped as sql statements.
Sent from my Gingerbread on Dream using XDA App

Awesome man!!! the .dump worked and I was able to actually get a table output on the screen. Now I just need ot know how to make that something printable (ideally), and I need to try it with my actual G1, not my Droid1... I'll thank you tomorrow when it's done.

Ugh!
So I've been able to correctly import a .db from my droid 1 and get it properly printed on the screen using sqlite3. That worked fine. Now I've pulled the .db from my G1 (which has the needed contacts), and I can't get it to print correctly. Here is what I'm dealing with...
Code:
SQLite3 version 3.7.20
Enter ".help? for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
_sync_state settings
_sync_state_metadata status_updates
accounts v1_settings
activities view_contacts
agg_exceptions view_contacts_restricted
android_metadata view_data
calls view_data_restricted
contact_entities_view view_groups
contact_entities_view_restricted view_raw_contacts
contacts view_raw_contacts_restricted
data view_v1_contact_methods
groups view_v1_extensions
mimetypes view_v1_group_membership
name_lookup view_v1_groups
nickname_lookup view_v1_organizations
packages view_v1_people
phone_lookup view_v1_phones
properties view_v1_photos
raw_contacts
sqlite>
From here, no matter what I try to use the .schema and "select * from XXXX" on, I don't get any user friendly table like I did with the other .db file... could something be messed up with this .db?
Please let me know when you get a chance.
Thanks in advance!
-kyle_engineer

[XOOM 2] [INFO] Xoom 2 ME, Ubuntu Linux, and MTP

Thought I'd share some info regarding connection of the Xoom 2 ME. This may also apply to the Xoom 2 and Xyboards.
The Xoom 2 ME does not mount as USB mass storage, it supports MTP (and, I presume, PTP).
My laptop runs Ubuntu 11.10 with the GNOME 3 desktop. There is no file-browser or popup when the X2ME is plugged in, as there would be when a UMS device is connected. I suspect this is down to the udev config not having the USB IDs, so that's something to look into soon.
Banshee didn't detect it, so I installed the Gmtp application (sudo apt-get install gmtp) and this permits transfer of files to the X2ME. I got a rather poor upload rate of 2.5MB/s on a 1.4GB video file.
It was not possible to download a file from the X2ME using Gmtp -- I haven't yet tried any other apps.
The version of libmtp supplied with Ubuntu 11.10 doesn't recognise the X2ME device codes, though this has already been addressed by the developers. Maybe this will be in Ubuntu 12.04.

try this...that transfer rate is slow but is above full speed USB so the problem lays elsewhere
http://forum.xda-developers.com/showthread.php?t=1077572

Yeah, the syslog reports it as a high speed device, so my assumption is it's working at USB 2 speeds.
Just gave mtpfs a try. If we ignore some random and extremely long hangs of a minute or more, a file download ran at ~14MB/s and seemed to work OK. An upload ran at 40MB/s, but the resulting file was 0 bytes in length and was followed by a lengthy hang.
Will run mtpfs in debug mode to see if it shows why it's hanging. There are some other MTP utilities like gnomad2 that I might try as well.

A few quick updates. First, it seems that USB debugging must be enabled for MTP connectivity to work. When I disable it, the X2ME isn't seen at all by mtp-detect or other utilities.
Gnomad2 works, and was a little faster at upload than gmtp -- it peaked at an "astonishing" 4MB/s . Unfortunately its interface sucks for file access (it is, after all, designed more as a music transfer tool).
There is definitely a long delay every time libmtp connects to the device. This is normally over 1 minute and seems to consist mostly of USB device resets and then connection retries.
Enabling debug of mtpfs didn't flag up anything useful.
A useful aside, if you export LIBMTP_DEBUG=7 before running apps that use libmtp, it enables lots of debug output. Specific information on choosing the debug level are in the lib's README.

What I do is the following:
I have Root FTP on my Xoom which required also to install a script in my Linux Mint distro (would be the same for Ubuntu) and once I want to transfer, I can be via wifi or via USB cable; I just have to run the script in linux (2sec) and activate the Root FTP software on the Xoom and I can use any FTP software to remote in and transfer files to and from the Xoom.

megabiteg said:
What I do is the following:
I have Root FTP on my Xoom which required also to install a script in my Linux Mint distro (would be the same for Ubuntu) and once I want to transfer, I can be via wifi or via USB cable; I just have to run the script in linux (2sec) and activate the Root FTP software on the Xoom and I can use any FTP software to remote in and transfer files to and from the Xoom.
Click to expand...
Click to collapse
Xoom 2 has no root access yet :-( . So this is not possible ... I have no trouble to transfer files to my xoom 2 me with smb network ... Thx for the infos Fluffy . I am trying few things now ...

Yeah, so far the simplest transfer method has been to use ES File Explorer to pull files across via SMB.

TheFluffyOne said:
Yeah, so far the simplest transfer method has been to use ES File Explorer to pull files across via SMB.
Click to expand...
Click to collapse
I prefer 'file expect' to do that i believe is a better file manager but most powerful features of it are not usable because of that stupid motorola firmware. If i wanted to use programs like MotoCast i would buying apple's products Motorola... :banghead:
Sent from my XOOM 2 ME using Tapatalk

Now that ghe tablet have root, are there any ideas how to solve the problem. Something is still blocking the communication via wifi with my computer and is not the firwall i think. Dammit moto I want an ftp server on my tab
Sent from my XOOM 2 ME using Tapatalk

mdcykkk9 said:
Now that ghe tablet have root, are there any ideas how to solve the problem. Something is still blocking the communication via wifi with my computer and is not the firwall i think. Dammit moto I want an ftp server on my tab
Click to expand...
Click to collapse
After having a quick play around for 5 minutes, iptables shows all policies as "allow". Services such as Airdroid are showing as bound to ipv6 sockets rather than ipv4 sockets, so I'm going to have a bit more of a dig around in that area.
For example, from "netstat -nlp" whilst Airdroid is listening on 8888:
tcp6 0 0 :::8888 :::* LISTEN
tcp6 0 0 :::8889 :::* LISTEN

http://forum.xda-developers.com/showthread.php?t=1526465&page=1
This program is solve my problem and now i can wireless transfer files from my xoom 2 to my linux pc. Is not the most elegant solution but until now is the only solution that working for me ...

I finally solved my problem with airdroid filexpert and others similar apps by removing zumoservice from system applications. Probably this will create problems with motocast ( i can't check this, i am linux user)
Sent from my XOOM 2 ME using Tapatalk 2 Beta-3

xyboard
As far as the Xyboard is concerned it works fine for me on Ubuntu. When the device is connected I change from MTP to PTP. It's the second option under usb computer connection on the Xyboard. Once done, I've gotten access to the folders on the device and have tranferred videos, music, and documents. Hope this helps.

Mounting Xoom 2 on SuSE Linux
mdcykkk9 said:
I finally solved my problem with airdroid filexpert and others similar apps by removing zumoservice from system applications. Probably this will create problems with motocast ( i can't check this, i am linux user)
Sent from my XOOM 2 ME using Tapatalk 2 Beta-3
Click to expand...
Click to collapse
Hello
How has the uninstalling of zumoservice solving your Problem ?
I´m trying to mount my xoom 2 me on opensuse 12.2 with kde 4.11 and get an Error which could be caused by
the motocast installer cd which shows up on systems where the motorola drivers are not already installed.
This breaks the connection between linux and xoom. So i ask myself how i can shutdown this "service".
If this is caused by zumoservice i could uninstall it, but a deactivation by Titanium did not solved the Problem yet.
Thanks in advance! Michael

Try deactivate all applications you think that are related with motocast... I don't have now my tablet so i can't help you more, i will try later to find the list of all applications i had removed...
Sent from my Nexus 4 using Tapatalk 4