Android Tablets Forum banner

Ugly hack to working market

71874 Views 290 Replies 76 Participants Last post by  william1853
DON'T BOTHER WITH ANY OF THIS ANYMORE. GO HERE: http://www.slatedroid.com/showthread.php?t=4684

Hi all, I found that the Market and Google Talk will work fine if you put in an Android ID yourself. Apparently that was the only issue.
For those of you who already have other android devices, you can get your android ID by doing the command.

1. X devices:adb shell sqlite3 /data/data/com.google.android.googleapps/databases/accounts.db "select * from meta";
2. X devices:adb shell sqlite3 /data/data/com.google.android.googleapps/databases/gls.db "select * from meta";

You'll get a readout with a line that looks likeandroidId||27283232........38434 (a big number) That last number beginning after the bar is your android ID.
If you DONT have an Android device, you can create an Android ID on the 1.6 Emulator by following the directions here: How To Enable the Android Market in the Google Android Emulator - How-To Geek
and then running the 1.X adb code above to get your Android ID.

Once you have your Android ID, run this command with your novel connected (be sure the emulator is shut down and no other devices are connected)
adb shell sqlite3 /data/data/com.google.android.googleapps/databases/gls.db
"update meta set intvalue='ANDROID_ID_HERE' where name='androidId'"; where you've replaced ANDROID_ID_HERE with whatever your real Android ID is.
You can run the 2.X command above to ensure it worked. Reboot, and you should hopefully have working google talk and Market. (and no, you can't have mine)
21 - 40 of 291 Posts
Justin Browning said:
On the actual device I have not tried an emulator. So should/can I emulate a 2.0 device and use that deviceId on the PDN?
You need some kind of device with working market to get a valid android ID, either an android device or the emulator.
On the PD Novel, it will be zero until you fix it (with the valid android ID you get elsewhere).
I did mine with the 1.6 emulator image from the first post.
clockworx said:
I'm not sure why "ls" doesn't work but the correct command is "sqlite3" (as opposed to "sqlite")
That was just a typo on this run. sqlite3 does the same thing.
C:pandigitalhacksandroid-sdk_r06-windowsandroid-sdk-windowstools>adb shell
# cd /system/xbincd /system/xbin
# lslsls: not found
# sqlite3sqlite3sqlite3: not found#
I guess I'll have to bundle up an android sdk for people to use....not sure why there are issues.
Alternately, you can pull off the accounts db file and use sqlite in windows, as edit_text did.
Maybe he'll be nice enough to make a list of the commands he used, but it should be pretty simple:
adb pull /data/data/com.google.android.googleapps/databases/accounts.dbsqlite3.exe accounts.db "select * from meta";
nvrpayretail said:
That was just a typo on this run. sqlite3 does the same thing.
C:pandigitalhacksandroid-sdk_r06-windowsandroid-sdk-windowstools>adb shell
# cd /system/xbincd /system/xbin
# lslsls: not found
# sqlite3sqlite3sqlite3: not found#
You're running this against the emulator, correct? (No PD Novel or any other android device plugged in?). Try "./sqlite3" for that last line.....maybe the path in the shell is messed up, though I have no idea why it would be....
clockworx said:
I guess I'll have to bundle up an android sdk for people to use....not sure why there are issues.Alternately you can pull off the accounts db file and use sqlite in windows, as edit_text did. Maybe he'll be nice enough to make a list of the commands he used, but it should be pretty simple:adb pull /data/data/com.google.android.googleapps/databases/accounts.dbsqlite3.exe accounts.db "select * from meta";
That would pretty much be it, just make sure the sqlite3 file is in the same directory as the accounts.dbOn a side note clockworx, the market seems to work. However, it fails anytime I try to download an app.e_t
Followed the instructions to the letter and it worked!!! Thanks everybody. Now I just need to get Slacker Radio installed as I can't see it in the market. Anybody got an apk?
edit_text said:
That would pretty much be it just make sure the sqlite3 file is in the same directory as the accounts.dbOn a side note clockworx, the market seems to work. However, it fails anytime I try to download an app.e_t
That's the way it should work before the fix (failed download). Try running the 2.X adb command against your novel to be sure android id is set to whatever number you pulled. Also, did you reboot? A good test is to ensure google talk works. If it crashes on launch, the fix isn't working.
Justin Brownin said:
Followed the instructions to the letter and it worked!!! Thanks everybody. Now I just need to get Slacker Radio installed as I can't see it in the market. Anybody got an apk?
Try visiting slacker.com with your browser. According to this (http://www.slacker.com/everywhere/mobile/android/) that should work.
clockworx: Yes, definitely only have the emulator running. Had the same problem using ./sqlite3. For grins, I stopped the emulator and plugged in the PDN. Running the command again, just goes back to the command prompt - no error message. Very odd behavior. I think I've taken up more than enough of your time tonight. Not sure what to try next but I guess I'll pick up on this again tomorrow. Thanks for all of the help.
OK, my bad.... you were right, the android ID was 0. I'm not sure how I managed to do that.e_t
nvrpayretail said:
clockworx: Yes' definitely only have the emulator running. Had the same problem using ./sqlite3. For grins, I stopped the emulator and plugged in the PDN. Running the command again, just goes back to the command prompt - no error message. Very odd behavior. I think I've taken up more than enough of your time tonight. Not sure what to try next but I guess I'll pick up on this again tomorrow. Thanks for all of the help.
I didn't exactly follow the instructions on that page since I know the emulator pretty well. All I did was download the 1.6 SDK using the SDK Setup tool, and then go into "android-sdk-windowsplatformsandroid-4images" and overwrite system.img with the downloaded one that has market enabled. (Backup the original 1.6 system.img if you want to keep it for some reason). Then I made a new virtual device based off of 1.6 (since I had dropped the modded system.img into there), and got the market up and running.That is slightly less convoluted than the directions on that page, so maybe it's worth a shot?
edit_text said:
That would pretty much be it just make sure the sqlite3 file is in the same directory as the accounts.dbOn a side note clockworx, the market seems to work. However, it fails anytime I try to download an app.e_t
One last thing. Using edit_text's method worked. The two commands you provided were all that was needed. I'll still do some more testing to see if I can figure out why using the adb shell command didn't work and post if I find anything.Thanks again...........
I used edit_text's method and it worked perfectly. Just got my novel and can't wait to load a bunch of apps. I tested the market by installing Pandora. It downloaded and installed without any issues. Thanks everyone for your hard work.
See less See more
I have installed the emulator but when I start it I get a virtual device but no navigation keys. Why don't I have navigation keys. Without the keys the simulator is worthless. Someone please help asap.
Thanks clockworx ...You r Gr8 !!! It worked like charm.For Guys it's not working or having issues.

1.) Download the android SDK and install it.
2.) Then create a virtual emu for Android 1.6 and then close the android emulator.
3.) Then install the "system.img" file from:http://www.4shared.com/file/165624746/fc72c3ed/system.html
4.) Then on windows run box type :%userprofile%/.android/avd This will open a file explorer in that folder. Then copy the system.img file downloaded in step 3 there.
5.) Now start the android emulator again and start the virtual dev for 1.6 (created in step 2).
6.) Then create/sign with google account.
7.) Now on PC open the cmd prompt and go to SDK folder/toolsNow type following commands:> adb shell sqlite3 /data/data/com.google.android.googleapps/databases/accounts.db "select * from meta";This will give you a number :androidId||<number> ...this number is your ID
8.) Now close the android emulator completely (Keep the CMD prompt window open if possible) and then connect your PDN.
9.) Now run : adb devices (to check only PDN is connected)
10.) Now run:adb shell sqlite3 /data/data/com.google.android.googleapps/databases/gls.db "update meta set intvalue='number_from_previous_commands' where name='androidId'";
11.) then disconnect PDN and reboot.

That's it ...you are good to go !!!!!Once again THANKS to "clockworx" !!!!

Edited 3/26/11 (format fixes) Please report any broken links or additional mistakes. Thanks, -MrsB
See less See more
Use your mouse for scrolling in emulator..it will little slow, but works !!
enjoys1 said:
Use your mouse for scrolling in emulator..it will little slow but works !!
On the 2.0 version of the emulator there are no navigation keys. Scrolling doesn't do me any good. When I launch an app there is no way to get back to the home screen. How can I get the navigation keys to show on the 2.0 version of the emulator? On the 1.6 version the keys are there, but on the 2.0 version they are not.
Worked for me using the mac sdk and the 1.6 Android VM.Thanks for the directions!
Okay I installed 1.6 and installed the system image. But when I try to sign on to Google it says that I need to slide the keyboard to unlock. I cannot do anything past that point. If someone could help I would appreciate it.
I finally got it working but all my downloads are unsuccessful. What did I do wrong?
21 - 40 of 291 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top