Develop Bugs

[HOWTO] Fix Appbrain fast web installer (using android_id)

Hi, after the update to froyo (in my case JP6) i found out the appbrain fast web installer wasn't working anymore. After some reading, it seems that the android_id (which this app uses) is set to a fixed number during the froyo update. This means the app cannot find a unique android_id to send the 'install instruction' to.
Source: http://forum.xda-developers.com/showthread.php?p=8604909#post86049
1. Make sure and backup your /dbdata/databases /com.android.providers.settings /settings.db file
Then in ADB or connectbot type the following
su
cd /dbdata/databases/com.android.providers.settings sqlite3 settings.db
sqlite> insert into secure (’name’, ‘value’ ) values (’android_id’,'device_id_goes_here’);
sqlite> .exit
Reboot
note 'device_id_goes_here’is your 16 digit HEX device ID
Click to expand...
Click to collapse
This fix seems to do the job, but i can't get it to work. Probably because i made a mistake with the usage of su and shell etc.
So i tried to fix it another way and this is how i did it (similar to the other fix):
1) With RootExplorer (or similar) navigate to: /dbdata/databases/com.android.providers.settings/
2) Make a backup of the file (by copying it)
3) Change the permissions of the file (using RootExplorer) ,so that it can be moved/sent to your pc using Dropbox,Gmail,Bluetooth etc. In this example i have moved it to my c:/ folder on windows.
4) When the file is on your pc. Run windows command (cmd) and navigate (using cd) to your /android/tools folder.
5) Execute: 'sqlite3 c:/settings.db
6) Now type in (after sqlite>): insert into secure (’name’, ‘value’ ) values (’android_id’,'device_id_goes_here’);
Note: 'device_id_goes_here' is a random (so you can choose whatever you want) 16 digit number.
7) Type: .exit and close the cmd box.
8) copy the settings.db file back to your phone and move it back to /dbdata/databases/com.android.providers.settings/
Choose yes when overwrite prompt pops up.
9) Reboot your device
10) Register your device using the 'Fast web installer' app on your phone.
11) DONE! You're ok again to install apps OTA using the appbrain market!
Click to expand...
Click to collapse
Note, if you don't know how to do step 4-7, read some articles about how to set up and use adb (since that also contains the sqlite3 tool)
I hope this helps for people having problems with this.

Hanness said:
Hi, after the update to froyo (in my case JP6) i found out the appbrain fast web installer wasn't working anymore. After some reading, it seems that the android_id (which this app uses) is set to a fixed number during the froyo update. This means the app cannot find a unique android_id to send the 'install instruction' to.
Source: http://forum.xda-developers.com/showthread.php?p=8604909#post86049
This fix seems to do the job, but i can't get it to work. Probably because i made a mistake with the usage of su and shell etc.
So i tried to fix it another way and this is how i did it (similar to the other fix):
Note, if you don't know how to do step 4-7, read some articles about how to set up and use adb (since that also contains the sqlite3 tool)
I hope this helps for people having problems with this.
Click to expand...
Click to collapse
Looks good. One question, how do you find out what your original device ID is? I have a UK unbranded GT-I9000... what's the ANDROID ID for that?

Ah, you just make one up. I used SQLite Editor to just edit the file, made up my own number and rebooted. Works fine now. A bit simpler than your suggestion above.

tokyogtr said:
Ah, you just make one up. I used SQLite Editor to just edit the file, made up my own number and rebooted. Works fine now. A bit simpler than your suggestion above.
Click to expand...
Click to collapse
That should indeed be easier
In the post I refer to in the captivate forum, there is mentioned an app to find out your android_id. But to know your original id, you would first have to reflash to an older firmware where the id is not touched. But it is true, you can just make up your own 16digit number. Only some games with online highscores fixed to the id instead of an account could benefit to know your old id, I think.

Worked for me!
Sent from my GT-I9000 using Tapatalk

hum
shud be easier to just download "Android ID Changer" from market after installing sqlite3. does the same trick.. but more user-friendly for people not so comfortable to use adb shell.

trasig said:
shud be easier to just download "Android ID Changer" from market after installing sqlite3. does the same trick.. but more user-friendly for people not so comfortable to use adb shell.
Click to expand...
Click to collapse
Hmm maybe Iḿ retarded, but how do I install sqlite3 to my phone?

No clue what he meant with installing sqlite3, I just downloaded the said Android ID Changer, made up and applied an ID and now Fast Web Installer works just fine.
I don't know if it is just coincidence or due to this, but before that I had tons of "download unsuccessfull" errors with the Market. Downloads failed nine out of ten times. Now, with changed ID, it works flawlessly again! My phone runs on JP6 Voodoo Doctor Edition 2.1.
Thanks for this advice!

I just installed the ID changer, entered a new code and rebooted, but the ID had not changed..
first time i tried it i got an "error editing databases".... do you have to change permissions to the folder/directory for the settings.db?

ukdtweak said:
I just installed the ID changer, entered a new code and rebooted, but the ID had not changed..
first time i tried it i got an "error editing databases".... do you have to change permissions to the folder/directory for the settings.db?
Click to expand...
Click to collapse
same problem here....

The only thing remotely related I could think of is that I had my system folder mounted as R/W with SGS Toolbox. But does that affect dbdata?

Check SGS Toolbox on mine and system was already mounted as RW...
I have tried changing the permissions with Root Explorer, to dbdata etc. but after rebooting, they are back as they were?

Beats me... but I can now confirm that the "download unsuccessfull" errors are back in place. It was just a coincidence after all, and shows that the blame is on Google, not any specific ROM or mod.
Fast Web Installer still worked though, even made it past the "unsuccessfull" barrier.

Wonderful fix!
Hanness, have you considered reporting this to Samsung? I think having the proper Android ID set and retained during firmware updates is quite important.

miki4242 said:
Wonderful fix!
Hanness, have you considered reporting this to Samsung? I think having the proper Android ID set and retained during firmware updates is quite important.
Click to expand...
Click to collapse
According to this, this may be due to ro.serialno not being set in build.prop

trasig said:
shud be easier to just download "Android ID Changer" from market after installing sqlite3. does the same trick.. but more user-friendly for people not so comfortable to use adb shell.
Click to expand...
Click to collapse
Android ID Changer did the trick for me . (I have not done anything with sqlite3.)

I used http://www.dbsoftlab.com/database-editors/database-browser/overview.html to edit settings.db as explained.
Works like a charm. Downloads & Updates are flying in!
Edit: After few downloads it stucks again, I deleted Market data. Works again. Bugs everywhere ...

Hanness said:
Hi, after the update to froyo (in my case JP6) i found out the appbrain fast web installer wasn't working anymore. After some reading, it seems that the android_id (which this app uses) is set to a fixed number during the froyo update. This means the app cannot find a unique android_id to send the 'install instruction' to.
Source: http://forum.xda-developers.com/showthread.php?p=8604909#post86049
This fix seems to do the job, but i can't get it to work. Probably because i made a mistake with the usage of su and shell etc.
So i tried to fix it another way and this is how i did it (similar to the other fix):
Note, if you don't know how to do step 4-7, read some articles about how to set up and use adb (since that also contains the sqlite3 tool)
I hope this helps for people having problems with this.
Click to expand...
Click to collapse
Thank you very much...I followed your instructions exactly and managed to fix it. Android ID changer didn't work for me.

sadly appbrain is blocked in China for whatever reason I don't know... so that won't work for me hehe

stassano said:
sadly appbrain is blocked in China for whatever reason I don't know... so that won't work for me hehe
Click to expand...
Click to collapse
oh well, the great firewall of china at work again.

[19-nov-2011] Active Auto APN For all Build

Auto APN Activation
hi for all friend and thanks for Dungphp's For provide this file
many friend have problem with data connection on installed build, hope this method problem data connecton solve.with corect parameter.
im after many search in web and xda-dev... find and create installer and file for Add auto apn for all Build can use.
If no active Auto APN use of this method:
1-with root explorer delete file (/system/etc/customer/apns-conf.xml or /system/etc/apns-conf.xml) (If exist)
2-connect device with usb charge only (adb previously installed please)
3-down this and extract rar file and run install.bat
4-on settings > ireless & networks >mobile network >access Point Name > press menu key and press reset to default
5-enjoy
*** if mms not worked , please delete your apn and set manually its woked 100% ***

Very well, thank you for sharing

I just PM'd Dungphp about that cause i was having problems with certain sense builds allowing me to select the correct apn but no E/H in the notification area/status bar. Thanks.

essi_baba said:
Auto APN Activation
hi for all guys and thanks for Dungphp's For provide this file
many gays have problem...
Click to expand...
Click to collapse
bwuahahahahhhhaaaaa!

essi_baba said:
Auto APN Activation
hi for all guys and thanks for Dungphp's For provide this file
many gays have problem with data connection on installed build, hope this
Click to expand...
Click to collapse
dohclude said:
bwuahahahahhhhaaaaa!
Click to expand...
Click to collapse
Come on We all know he meant "guys" lol...
anyways awesome work OP keep up the work. XD

essi_baba said:
many gays have problem
Click to expand...
Click to collapse
hmmmm

edit comment
im sorry for type wrong word .
first post edited.

essi_baba said:
Auto APN Activation
hi for all friend and thanks for Dungphp's For provide this file
many friend have problem with data connection on installed build, hope this method problem data connecton solve.with corect parameter.
im after many search in web and xda-dev... find and create installer and file for Add auto apn for all Build can use.
If no active Auto APN use of this method:
1-with root explorer delete file (/system/etc/customer/apns-conf.xml or /system/etc/apns-conf.xml)
2-connect device with usb charge only (adb previously installed please)
3-down this and extract rar file and run install.bat
4-enjoy
Click to expand...
Click to collapse
u change it to friend now yea...hehehe
NWY, tried this but its not working for me,
can't find folder (sytem/etc/customer)..
so just skip it n proced with install.bat,check setting still no apn,
found out,apns-conf.xml was push to (system/etc/apns-conf.xml),then i delete system/etc/apns-conf.xml n reinstall it again,but still nothing on apn..
something wrong with i did??

install
oroo708 said:
u change it to friend now yea...hehehe
NWY, tried this but its not working for me,
can't find folder (sytem/etc/customer)..
so just skip it n proced with install.bat,check setting still no apn,
found out,apns-conf.xml was push to (system/etc/apns-conf.xml),then i delete system/etc/apns-conf.xml n reinstall it again,but still nothing on apn..
something wrong with i did??
Click to expand...
Click to collapse
If you only do :
1-with root explorer delete file (/system/etc/customer/apns-conf.xml or /system/etc/apns-conf.xml) (If exist)
2-connect device with usb charge only (adb previously installed please)
3-down this and extract rar file and run install.bat
4-on settings > wireless & networks >mobile network >access Point Name > press menu key and press reset to default
5-enjoy

essi_baba said:
If you only do :
4-on settings > ireless & networks >mobile network >access Point Name > press menu key and press reset to default
5-enjoy
Click to expand...
Click to collapse
done it but still nothing..
is it my rom or what??i'm using NDT ginger..

Works for me. Thankx.
One more thing. If you actually have root explorer, there is no need to use adb commands. Just replace the apns-conf.xml file in /system/etc/ and reset permissions as rw-r-r and reboot device.
Once rebooted, go to APN and press menu, then press Reset APN to default. Worked for me.

Hi !
Worked for me on Samsung Galaxy S GT-I9000 ICS ( TiramiSlim ROM ).
But Failed on Samsung Galaxy SII GT-I9100 MIUI ICS CM9 ( cMIUI ROM ).
Nowadays, thanks for this hudge list !!! )

[Guide]Set the Straight Talk APN on a (rooted) Stock 4.4.2 AT&T ROM

UPDATE: There is a much simpler solution that anyone can use without learning Linux commanline or file permissions. See this thread for details:
http://forum.xda-developers.com/showpost.php?p=54462957&postcount=13
WARNING: If you do not understand every step of these low-level Linux command-line technical instructions, then do not attempt this method or you may brick your phone! These instructions are written for people who understand android developer tools, Linux command-line tools, and file permissions. If you do not understand these Android development basics, then find another walkthrough.
I got my phone up and running and text messaging, 4G LTE data connectivity, and phone calls worked just fine, however, I noticed I was unable to send and receive MMS messages (picture messaging). I tried every solution I could find on the web for changing the APNs on my rooted LG Optimus G Pro E980, and by trial and error, I discovered the following solution:
The stock Android ROM supplied by AT&T for the Optimus G Pro - Android 4.4.2 (Build E98020G), has disabled the ability to add working APN settings through the system APN settings dialog by defaulting all new APNs to have the (apn) type="default,dun". The settings screen does not let you change this value, so you have to edit the values directly in the SQLite database.
None of the free SQLite-database-editors in the Android market were able to edit the read-only /data/data/com.android.providers.telephony/databases/telephony.db file (after following instructions for editing the APN in the database in the folder where it is stored).
So, using ES File Manager (search for "com.estrongs.android.pop" on google play), I copied it to my SD-Card, copied to my computer and edited it with SQLite Database Browser (a SourceForge project identified as sqlitebrowser).
VERY IMPORTANT: The permissions change when copying the file from your computer to the SDCARD and when copying it from the SDCARD to the /data/data/com.android.providers.telephony/databases/ folder. So, I had to set the permissions back to the original telephony.db permissions & owner. The permissions should match all of the other .db files in the /data/data/com.android.providers.telephony/databases/ folder, like so:
RW-RW----
VERY IMPORTANT:Change the file owner back to "radio" from "root". Change the group back to "radio" from "root". If you do not change the owner and group back to "radio" after you copy the telephony.db file back to the /data/data/com.android.providers.telephony/databases/telephony.db path, the phone.apk process will repeatedly crash until it restarts your phone (and your phone will keep rebooting until you delete the telephony.db file that has incorrect permissions or incorrect owner). To boot, the phone.apk runs under the "radio" group and needs the critical Android OS file: telephony.db to be owned and accessible by the "radio" group.
After creating an APN per Straight Talk's instructions, changing the type field in the carriers (APNs) record stored in the telephony.db, copying over the new telephony.db (and overwriting the original), changing the permissions & owner of the copied file, and rebooting the phone, I was able to send and receive text messages and picture messages (MMS) to myself.
Note: My phone came with the correct "Service Center Address" setting, because it was an AT&T branded phone before I brought it to Straight Talk. However, you may need to change this setting if you came from another carrier with your phone. The correct setting for Straight Talk customers on the AT&T LTE network should be (the same as it is for AT&T customers on an AT&T plan):
Code:
+13123149810
Although the /system/etc/apns-config.xml file has several, misleading APN values in it, this file is not used to store the APN records in Android 4.4.*. Instead, APNs are stored in the /data/data/com.android.providers.telephony/databases/telephony.db SQLite database.
Also, there is a rumor spreading around the internet that you cannot send MMS messages when your WIFI is connected (instead of a 4G LTE connection). That is false: my phone sends and receives MMS messages while the WIFI is connected.​To make it easier for you to change your APN settings on your phone, I have attached my working telephony.db file. It contains only one APN record for Straight Talk on AT&T's LTE network. I deleted all of the other APN records from the database, per Straight Talk's APN instructions.
If you are curious, I also attached the database dump of the attached telephony.db, which was auto-generated by SQLite Database Browser. It is a text file called "telephony-dump.sql".

Hi, I tried this step by step and now my phone does nothing but crash repeatedly. Any way to fix this?

How to unbrick your phone if you missed steps in the instructions
l337m45732 said:
Hi, I tried this step by step and now my phone does nothing but crash repeatedly. Any way to fix this?
Click to expand...
Click to collapse
If you do not understand every step of the above low-level Linux command-line technical instructions, then do not attempt this method or you may brick your phone!
It sounds like a permissions issue - the android operating system is crashing because it does not have permission to read the critical OS file: telephony.db. Did you set the owner, group, and permissions on the telephony.db file correctly? If you are unable to change the permissions back on the telephony.db, then follow the instructions above to fix your problem:
ratkiley said:
VERY IMPORTANT: The permissions change both when copying it to and when copying it from the SD-Card. So, I had to set the permissions back to the original telephony.db permissions & owner, (matching the other .db files in the /data/data/com.android.providers.telephony/databases/ folder):
RW-RW----
VERY IMPORTANT:Change the file owner and group back to "radio" from "root". If you do not change the owner and group back after you copy the file back to the /data/data/com.android.providers.telephony/databases/telephony.db path, the phone.apk process will repeatedly crash until it restarts your phone (and your phone will keep rebooting until you delete the telephony.db file that is owned by "root").
Click to expand...
Click to collapse
If you don't know how to delete the telephony.db file, then you can flash the stock AT&T android Operating System image file to unbrick your phone. There are many tutorials and walkthroughs on this topic on xda developers. This walkthrough is pretty comprehensive:
http://forum.xda-developers.com/showpost.php?p=44983841&postcount=1

Remove default APN T-Mobile US LTE?

Is there a way of removing the default APN on a Galaxy Note3 (running Android 4.3)? I have the phone rooted.
Thanks!

m4f1050 said:
Is there a way of removing the default APN on a Galaxy Note3 (running Android 4.3)? I have the phone rooted.
Thanks!
Click to expand...
Click to collapse
create a new one, if u cant delete it...
and add this to APN type...
APN type= default,supl,mms (this will make it default APN)

mdiaz33685 said:
create a new one, if u cant delete it...
and add this to APN type...
APN type= default,supl,mms (this will make it default APN)
Click to expand...
Click to collapse
Thanks but I already did that. I am looking to delete the default T-Mobile US LTE one

You can't and there is no real reason to bother to remove it anyway. Just use the new entry.

You can remove it, but it requires a SQL editor.
Go to data/data/com.android.providers.telephony/databases and edit nwk_info.db
Select the "carriers" table and locate the T-Mobile US LTE / 310260 entry (should be line 26)
Scroll all the way to the far right and change the editable value from 0 to 1.
Restart your phone and you should be able to edit the entry.
The other option is to edit /system/etc/apns-conf.xml directly.
Remember the first rule in tweaking your system... make a backup copy first.

rjohnstone said:
You can remove it, but it requires a SQL editor.
Go to data/data/com.android.providers.telephony/databases and edit nwk_info.db
Select the "carriers" table and locate the T-Mobile US LTE / 310260 entry (should be line 26)
Scroll all the way to the far right and change the editable value from 0 to 1.
Restart your phone and you should be able to edit the entry.
The other option is to edit /system/etc/apns-conf.xml directly.
Remember the first rule in tweaking your system... make a backup copy first.
Click to expand...
Click to collapse
See, this is the type of answer I like to get... not "create a new one" or "you don't need to remove it".. If I want to remove it, LET ME REMOVE IT, it's my phone!
Thanks rjohnstone (for telling me how to edit the entry) and mdiaz (for the APN types)! BTW used SqlLite, great app, only $2.99 on Play store and works VERY well!

[Root] [Sprint Galaxy S6] [Nougat] Enable Hotspot by manually editing APN database

I found through some searching the location of the telephony.db file in Android N and I was successfully able to edit it to enable the native hotspot.
Here's a poorly written guide:
1. Using a root browser or ADB shell, copy /data/user_de/0/com.android.providers.telephony/databases/telephony.db to the root of the internal storage (/storage/emulated/0)
Code:
adb shell su
cp /data/user_de/0/com.android.providers.telephony/databases/telephony.db /storage/emulated/0/
exit
If you have the premium version of jrummy's root browser, it has a built in database editor and you may use it. Edit: You can't edit the file in place, you must copy it to /storage/emulated/0 to edit, then copy it back.
2. Copy the telephony.db file to your computer
Code:
adb pull /storage/emulated/0/telephony.db
3. Using a SQLite editor on your computer, open the telephony.db file, and open the "carriers" table.
4. Find "APN2 LTE internet" and in the type column add "dun" to the end, so it should read "default,mms,dun"
5. Do the same with "APN2 EHRPD internet"
6. Write the changes to the database.
7. Put the file back on the phone's storage
Code:
adb push telephony.db /storage/emulated/0/
8. Rename the telephony.db in "/data/user_de/0/com.android.providers.telephony/databases/" to telephony.db.bak
Code:
adb shell su
mv /data/user_de/0/com.android.provicers.telephony/databases telephony.db.bak
9. Copy the telephony.db from the storage to "/data/user_de/0/com.android.providers.telephony/databases/"
Code:
(adb shell su if you exited the shell previously)
mv /storage/emulated/0/telephony.db /data/user_de/0/com.android.providers.telephony/databases/telephony.db
exit
10. Reboot. Tethering should now work.
I'm not sure if this adds the hotspot icon to the quick settings or if the icon is left over from a failed attempt to get the hotspot working. (Edit: button seems to always be there)
Note: Updating your profile may reset the APN settings. If so, you should be able to follow this guide again.
Edit: At some point my profile updated or something and disabled the hotspot. I did this procedure again and it worked.
tdhite's SkyHigh kernel does this automatically but it breaks private mode and I kind of wanted that.
Credit where it's due: This thread is where I found the location of telephony.db

Thanks! I'm quite happy with tdhite's skyhigh kernel atm which has hotspot built in, but its great to know that if for some reason I cant use skyhigh in the future, there are still alternatives for getting hotspot!

remove root
I am not able to get this to work. Hangs at Samsung portion of the boot.

trendkilla254 said:
I am not able to get this to work. Hangs at Samsung portion of the boot.
Click to expand...
Click to collapse
I'm sorry to hear that. I'm not a developer or anything so I couldn't tell you exactly what went wrong. Are you using the stock ROM?

I found some interesting info on this and was actually able to edit the apn and get my phone to boot. I just moved the file to the SD card and used sqlite editor. The key is after you copy the file back to original folder set permissions rw_rw__ just like the other files. Change both owner and group back to radio.
I get no signal in my house so I have to wait till I get to work tomorrow to actually test the Hotspot.
Sent from my SM-G925P using Tapatalk

baknblack said:
I found some interesting info on this and was actually able to edit the apn and get my phone to boot. I just moved the file to the SD card and used sqlite editor. The key is after you copy the file back to original folder set permissions rw_rw__ just like the other files. Change both owner and group back to radio.
I get no signal in my house so I have to wait till I get to work tomorrow to actually test the Hotspot.
Sent from my SM-G925P using Tapatalk
Click to expand...
Click to collapse
For anyone interested. This actually works for me.
Sent from my SM-G925P using Tapatalk

I dont see "APN2 EHRPD internet" in telephony.db on my S6 Edge Sprint Nougat phone.

potolok said:
I dont see "APN2 EHRPD internet" in telephony.db on my S6 Edge Sprint Nougat phone.
Click to expand...
Click to collapse
Here's mine if the link works
https://drive.google.com/file/d/17pSf3NBbxImTvHhAMclSwtSNF30rl-qY/view?usp=drivesdk
Sent from my SM-G925P using Tapatalk

Tried all the ways of activation Hotspot on Nougat (QC7), fixes, changing CSC etc.... But all without success

Can anyone confirm this works with QJ1 stock that has been rooted?

baknblack said:
Here's mine if the link works
https://drive.google.com/file/d/17pSf3NBbxImTvHhAMclSwtSNF30rl-qY/view?usp=drivesdk
Sent from my SM-G925P using Tapatalk
Click to expand...
Click to collapse
I don't think sharing your own APN database is a good idea.
potolok said:
I dont see "APN2 EHRPD internet" in telephony.db on my S6 Edge Sprint Nougat phone.
Click to expand...
Click to collapse
Make sure you're looking in the "carriers" table. For me they are the last two. They might not say APN2, but they should have "EHRPD internet" and "LTE internet" in the name and under type by default should say "default,mms"

Thank you so much for posting this, Man!! I had been searching all over the web for answers!! Hotspot working perfectly now.
I just used root explorer, and sqlite editor, and followed your steps. Thanks again =)