yashsingh1/xdaforums huggingface dataset:
[Nexus 5 Q&A, Help & Troubleshooting] bailyc:
This app appears to help the issue. I didn't have time to test very long, but it was able to hold a Bluetooth tethering connection for about 30 minutes, which beat the 3-5 min I was getting before. Presumably, this doesn't fix the underlying issue but it's better than nothing.

Can I ask if you experience any serious battery drain while using this app?

Thanks again for the recommendation!
[Nexus 5 Q&A, Help & Troubleshooting] painter_:
No issue with battery drain that I have seen. It only keeps the bluetooth connection active when you are connected to something. I have been using it for at least 1.5 years.
[Nexus 5 Q&A, Help & Troubleshooting] bailyc:
Ok, great to know. Thanks again.
[Nexus 5 Q&A, Help & Troubleshooting] ilovebbq:
it works!

after i uncapitalized the T in tether in the sqlite db fix

at least i think that's what fixed it

that and a reboot.
[Nexus 5 Q&A, Help & Troubleshooting] ajs1122:
I know you got your bootloop resolved, but there is a simpler solution so I figured I would share. I experienced the same issue. The problem is caused by the renaming of settings.db to settings.db.keep in the original folder. What actually needs to be done is to make a copy of this file to a different location and then rename, not rename the original.

I was able to fix my bootloop by just going into the bootloader and in TWRP browsing to the affected file and deleting the file with the fixed "tether_dun_required" entry. I then renamed settings.db.keep back to settings.db and rebooted without issue. No more bootloop and very little pain.

To get things to work properly you have to actually overwrite the settings.db file with the revised settings.db file. Hence the reason to save a copy somewhere else.
[Nexus 5 Q&A, Help & Troubleshooting] jkuperman:
I'm not sure that's actually the case. I was stuck in bootloop and the problem was that when I copied the settings.db file to another folder, edited it and copied it back, the ownership of the file changed from system to root, thus not allowing the system access to the file. Once I chowned the file to system:system, it worked fine. I didn't overwrite the original file. I just renamed it to settings.old.db, copied my edited system.db file back into the original directory (with the correct permissions) and everything works fine. So you definitely don't have to overwrite the original.
[Nexus 5 Q&A, Help & Troubleshooting] pendoric:
I also worry that perhaps the journal file no longer matched the db file. In the end I clean installed.

a) copied the db file for posterity.

b) Ran SQLite editor directly on the live file

c) Rebooted the phone.

It now works for me, except the T-Mobile sniffer now catches my laptop and still shuts me down. I have a work around by setting the browser string but this is not ideal. Is there a VPN client for the phone that will VPN all hotspot data from any client to avoid this?

Pen.
[Nexus 5 Q&A, Help & Troubleshooting] cjrivera04:
Anyone know if this works for Sprint. Was going to try it but sprint activated devices don't seem to have access to the APN under the mobile network tab like T-Mobile folks. At least I don't anyways. Thanks.
[Nexus 5 Q&A, Help & Troubleshooting] S0nico:
I solved with this app: WiFi Tether Router

on Google Play store https://play.google.com/store/apps/details?id=net.snclab.wifitetherrouter&hl=en

the developer has done a compatible update

I contacted the developer via email and he told me after a few hours

the developer advised me to select these settings

Interface wlan0

Method 0 - Auto

works also with

Interface wlan0

Method 2
[Nexus 5 Q&A, Help & Troubleshooting] eksasol:
So that's where the animation scale values are located. No more slow animation on stock for me.
[Nexus 5 Q&A, Help & Troubleshooting] iyouqt:
I'm on the $30/100/unlimited plan, and I applied the fix and had tethering working for a while (103mb), but now I'm being redirected to the upsell page. I rechecked all my settings and nothing has changed. Is this problem unique to me, or are others dealing with it too?
[Nexus 5 Q&A, Help & Troubleshooting] wideasleep1:
Chrome? UA switcher extension?
[Nexus 5 Q&A, Help & Troubleshooting] iyouqt:
Was using Firefox, default UA. Didn't think about changing the UA, but it works when I switch it to mobile. I'd prefer to have it how it was originally (working normally on default UA), but this is certainly better than nothing. Thanks~
[Nexus 5 Q&A, Help & Troubleshooting] wideasleep1:
Only the first 100MB are included in the plan. Anything else requires tweaks.
[Nexus 5 Q&A, Help & Troubleshooting] Saturn1217:
Tried to read through all 22 pages of this thread.

I don't have a Nexus 5 yet but am planning on making it my next phone and of course this thread has me very concerned because I tether my phone to my Nexus 7 on a daily basis.

I know this may sound weird but I buy Nexus devices specifically so I do NOT have to root and mod them so my question is: If I upgrade my plan (from a grandfathered even more plus 5gb plan) to the new simple choice 2.5gb plan does that include tether and will I then have no problems and not need any hacks? The new plan and the old plan cost the same so I wouldn't mind doing this.

Any input would be much appreciated!
[Nexus 5 Q&A, Help & Troubleshooting] andy o:
If you don't wanna root, then whatever T-mobile advertises is what you should be getting, so check that plan for it.

Another thing, you may buy Nexus devices so you don't have to install custom firmware, but another big thing about Nexus devices is that they're easily bootloader-unlocked, thus easy to root. So yes, one of their advantages is that you can root them easily, not that they have less need for rooting.
[Nexus 5 Q&A, Help & Troubleshooting] moonx02:
I've also ran into this problem as well..

Any new progress?
[Nexus 5 Q&A, Help & Troubleshooting] ss2pheonix:
Tmo just started routing me to the paywall when tethering with my nexus 4 even from an android tablet. I assume it is because of the 4.4 upgrade, but i tried this fix (3 times) and every time my phone gets stuck in the boot animation. Do you know what is going on? Also I'm supposed to have 100mb of tethering data but tmo wont let me do anything but go to the my.tmobile site, why is that?
[Nexus 5 Q&A, Help & Troubleshooting] edgardch:
Yes, it works with N5 from Sprint. Don't do the APN thing, my computer automatically recognizes the connection to IPv4.

Also, make sure you make a backup before you change the settings.db. Mine got in a boot-loop after replacing the file. Thank God I decided to make a backup. After restoring it, what I did was to backup the settings.db to settings.db.bak and then editing the settings.db with SQLite Editor, restarted and voila!
[Nexus 5 Q&A, Help & Troubleshooting] moonx02:
So I was able to fix my tethering problem with tmobile/nexus 5 with:

"I was able to work around the issue by modifying the following sqlite database (you'll need root):

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

You need to add a new entry to the global table called "tether_dun_required" with a value of 0.

It looks like you need to do this because some configuration data was added to Android for T-mobile that forwards tethered data to this APN: pcweb.tmobile.com

T-mobile is probably checking to see if your account has tethering enabled when you go through this APN.

After I made this change I also needed to change my APN settings so that it uses ipv4 instead of ipv6. It seems like tethering with ipv6 does not work 100% yet."

However, trying to flash the Cataclysm Rom on my Nexus 5 isn't working.

Well, it say flash successful but I have a whole handful of problems.

No homescreen. No pull down toggle switches. Etc Etc.

Do you guys think this tether fix I did is causing my flashing to go wrong??

Any help will help. Thanks in advance guys.
[Nexus 5 Q&A, Help & Troubleshooting] edgardch:
Unfortunately, I think you are right :( After doing this on my Sprint N5, the 1st thing I noticed was the Bluetooth not functioning. Then I did a factory reset and BT was working but not the MTP, then reset it again to find out the BT wasn't working yet AGAIN! This sucks! I am restoring it for the 3rd time. This is just not fun.
[Nexus 5 Q&A, Help & Troubleshooting] Волк:
So, after reading quite a bit of this thread, the current state of this issue is unclear.

It looks as of there is a "fix"/work around beyond just a UA change and that programs which don't use port 80, such as a torrent client, also get blocked (and didn't in the past).

The work around is here:

http://xdaforums.com/showthread.php?p=47561341

But some people experience severe issues afterwards.

One thing I notice is the majority of people having this tether block are on a limited data plan, and one user is on the unlimited (which they don't let you buy tethering on, idiots) but didn't get blocked after heavy data use.

Can someone confirm that my above observations are correct?

I have a classic (I think) 400 or 500 minute plan, unlimited text, unlimited hi-speed data and want to upgrade to the N5, but I must be able to tether.

Edit: Also, the tether issue exists on Sprint?

Changing to 4G or 3G from LTE doesn't solve the problem also seems to be the case.

And CM11 & AOSP ROMs also have this issue.
[Nexus 5 Q&A, Help & Troubleshooting] ssnacks:
Issue with MMS after db key added

I proactively updated this setting in anticipation of switching from AT&T to T-Mobile next week. I discovered that I could not send or receive MMS messages today. After a ton of troubleshooting including APN resets, switching from Hangouts to GOSMS, I remembered that I edited this setting.

I deleted the key and copied the database back and temporally screwed up the database completely. When the database was unavailable to the phone, MMS worked again. I copied it again and go the database back with MMS work once the key was deleted.

I also checked with other AT&T users in my area to see if they could use MMS. They had no issues.

I cannot say for certain that this caused the problem, but deleting the key seemed to fix it. I also checked the code (below) to verify that it should only affect the DUN APN and the code does not mention that it should have any effect on the MMSC APN. I wanted to mention it in case anyone else had MMS issues after adding this key to the database.

http://www.androidjavadoc.com/2.3/android/provider/Settings.Secure.html#TETHER_DUN_REQUIRED
[Nexus 5 Q&A, Help & Troubleshooting] moonx02:
So I am going to try revert all the adjustment I did and THEN try to flashing the phone to a different rom.

So, if reverting back to stock settings/values then flashing it works, we would need to do need make these adjustments after flashing to our permanent (or at what you're going to have for awhile) rom that we decide upon.

BUT if doing this doesn't work, I would be stuck with stock rom and back to square one on how to fix this....

If this doesn't work, I'm just gonna have to settle being stuck on the stock rom or just return this thing since it's been only 2 days since I got this phone.

I will keep you guys posted... Wish me luck guys.
[Nexus 5 Q&A, Help & Troubleshooting] moonx02:
Okay. So after reverting to the settings file and flashing it was the same bugginess.

HOWEVER, I learned that you would need to used a custom CWM recovery image for the Nexus 5 or it won't wipe properly and causing unstable/glitches to happen. So in conclusion, this tweak fix is COMPLETELY safe for flash as long as you use the correct recovery image.

Hope this helps!
[Nexus 5 Q&A, Help & Troubleshooting] edgardch:
OK, so after my 3rd time restoring my N5 to factory settings, all my issues are gone!!! I don't know why the BT and the MTP were not working before, but this time around, I kept using my BT mouse the whole process. I'm not quite sure what the problem was, but damn, I'm glad I finally have a fully functional phone with hotspot :)
[Nexus 5 Q&A, Help & Troubleshooting] doubleatheman:
Looks like I gotta root my phone... lol, I always try to keep stock android without root, but stupid stuff like this makes me have to tinker with everything! I dont mind... beyond having to resetup my phone...
[Nexus 5 Q&A, Help & Troubleshooting] :
Fix permissions in your custom recovery will get you out of boot loops. It did for me, at least TWRP.
[Nexus 5 Q&A, Help & Troubleshooting] tatico28:
The fix is easier than you guys think, Here's a workaround for the uninitiated ones.... Should work on most mobile devices. You'll probably need a VPN if you want to tether a laptop.

thanks to jeeeenx for this.

hit thanks if I helped you!:cowboy:
[Nexus 5 Q&A, Help & Troubleshooting] g1modfan:
Hi guys, are these fixes still working with n4 new factory krt16s?

Did these and working in n4 krt160 (thank you all!), and i don't want to update if these fixes won't work in krt16s.
[Nexus 5 Q&A, Help & Troubleshooting] ss2pheonix:
Thankyou that worked great
[Nexus 5 Q&A, Help & Troubleshooting] RussianBear:
They've definitely changed something in the past month or two. I was able to tether to my ipod w/o any issues. I hit my 500mb limit today. I figured, no big deal, will just fire up my vpn (L2TP) from the ipod. Done deal, right? Nope. They can still detect it somehow.

I will have to check it out on my pc. I have a hunch they can somehow tell that tethering is enabled on the phone (if this was already brought up, pardon my ignorance on not reading all the pages).

edit: applied the fix to settings.db and now the phone is looping. of course, I didn't back anything up or had a zip fie made to flash the settings back in recovery. Can anyone upload a flashable zip of the settings.db file? Thanks!

edit2: thanks to twrp's integrated file manager, I've renamed the file to .bak and rebooted :)

edit 3: we're back in business. thanks, yak!
[Nexus 5 Q&A, Help & Troubleshooting] tarroyo:
For those of you that are just finding out about this mod or are having problems with this mod, This is what works for me.

This method https://docs.google.com/document/d/1Wso8Cb3rU0DApFe2lg5RcMrelAEoYY-fZ4MAghnIuqs/edit?pli=1 along with changing both my 'APN Protocol and APN Roaming Protocol to IPv4/IPv6'

With this User Agent, Tethering my N5 to a laptop these settings work for me

Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_3; en-us) AppleWebKit/533.16 (KHTML, like Gecko) Version/5.0 Safari/533.16
[Nexus 5 Q&A, Help & Troubleshooting] notbrodie:
twice i've done this, and twice my phone has bootlooped afterwards. does the entry have to have a specific ID#? i'm not really familiar with sqlilte, but i would like to be able to tether using the native capability

EDIT: solved the bootloop by using adb to pull the db file to my laptop, remove the edit, then pushed it back. whatever line this guy is adding is the cause of the bootloop. does anyone have any ideas how to solve this?
[Nexus 5 Q&A, Help & Troubleshooting] bluegizmo83:
Ok here is an easy Step-By-Step. You will need to buy and download SQLite Editor from the play store ($2.99). I have tried a few different free editors and could not get any of them to work. https://play.google.com/store/apps/details?id=com.speedsoftware.sqleditor&hl=en

Step 1: Open the SQLite Editor app (approve root privileges) and navigate to "/data/data/com.android.providers.settings/databases/" and then click on the "settings.db" file

Step 2: Click on "Global"

Step 3: Click on the + icon in the upper left corner

Step 4: Leave the _id field on (auto). In the Name field type "tether_dun_required". In the Value field type "0" (the number zero). Click SAVE.

Now just back out of the SQLite Editor app and then reboot your phone!
[Nexus 5 Q&A, Help & Troubleshooting] RussianBear:
Mine did this at first. You need to make sure you select proper access for this file once it's in the system directory. Change it from "root" to "system" access instead (in using es explorer, btw).
[Nexus 5 Q&A, Help & Troubleshooting] :
This...

http://xdaforums.com/showthread.php?p=47832740
[Nexus 5 Q&A, Help & Troubleshooting] wund3rground:
Hmm... Worked for me without bootloops...
[Nexus 5 Q&A, Help & Troubleshooting] h20wakebum:
I have no issues tethering. I just upgraded to the $70 unlimited plan with 2.5GB hotspot. hope this helps
[Nexus 5 Q&A, Help & Troubleshooting] glenelgstudio:
This method worked great for me. U was ready to get rid of this phone but its good now. Its very easy to do if you follow these five steps. Thank you very much. One question. If I change Roms do I need to do this again?
[Nexus 5 Q&A, Help & Troubleshooting] iTzGavin96:
What program/app did you use to view and edit the Sq lite database file? Es isn't playing well with it right now and my other root Explorer won't give me any edit options, but I can see the global table with 80 something values in it
[Nexus 5 Q&A, Help & Troubleshooting] ad78:
i used this method when I'm on stock ROM. i updated with KANGAKAT ROM and you don't need this anymore. I'm using the native tethering now without any modifications
[Nexus 5 Q&A, Help & Troubleshooting] yuyuyuyu1:
Anyway to modify the SQLite database without paying for the app?
[Nexus 5 Q&A, Help & Troubleshooting] andy o:
I did it on Windows. I used literally the first program Google found, out of sourceforge. I copied the file to SD and then to Windows for editing, then back to SD and back to the original location. I assume you can also do it with adb. Didn't have to restore permissions or anything. Just like that.
[Nexus 5 Q&A, Help & Troubleshooting] ziddey:
Try:

# settings put global tether_dun_required 0

edit: might not work since there's no tether_dun_required to begin with
[Nexus 5 Q&A, Help & Troubleshooting] _ice_:
My tethering works fine. Stock kit Kat, rooted.

Also I'm on a old school data plan with no tethering add on
[Nexus 5 Q&A, Help & Troubleshooting] regalatre:
Nice fix
[Nexus 5 Q&A, Help & Troubleshooting] bobaka:
worked fine for me on nexus 4. $2.99 well worth it.
[Nexus 5 Q&A, Help & Troubleshooting] jdavet:
First of all, thanks for the fix! This worked wonderfully... for a few weeks. But the Tmobile message came back out of nowhere last night as I was online. Any ideas?

Note: A new database appeared in /data/data/com.android.providers.settings/databases called settings.db.org ... I don't know if this has anything to do with my issue.
[Nexus 5 Q&A, Help & Troubleshooting] tarroyo:
Did u change your user agent after applying this hack?
[Nexus 5 Q&A, Help & Troubleshooting] RussianBear:
You still need to use a vpn, if you're trying to hide your traffic.
[Nexus 5 Q&A, Help & Troubleshooting] jdavet:
Thanks for the information. Both using a vpn or changing the user agent worked. I was hoping not to have to use solutions since I didn't need to do that after I first applied the hack. But no big deal! It's better than paying a monthly tethering plan! Thanks again for your time!
[Nexus 5 Q&A, Help & Troubleshooting] tcemle:
any idea about the spring version of the nexus 5
[Nexus 5 Q&A, Help & Troubleshooting] famewolf:
Hit the tethering block on my n5....strangely it seems to be giving it to me regardless of whether I try to get internet on my phone or on a pc tethered...as in I get the hotspot upsell page anytime I try to go anywhere...period.

I added the entry to settings.db using sqlite3 on my linux pc.

INSERT INTO global (name,value) VALUES ('tether_dun_required','0');

and yet the problem continues to occur. *sigh* Always something.
[Nexus 5 Q&A, Help & Troubleshooting] RussianBear:
Did you already exhaust your tethering traffic? Did you make sure that entry was actually entered? Make sure to either use a vpn or a user agent string changer.
[Nexus 5 Q&A, Help & Troubleshooting] tennandcoz1:
People try a different browser.
[Nexus 5 Q&A, Help & Troubleshooting] Letitride:
I managed to get the N5' s built-in Hotspot App working with another line to settings.db

... add a new entry to the global table called "WiFi_on" with a value of 1 "
[Nexus 5 Q&A, Help & Troubleshooting] famewolf:
Didn't exaust the traffic as I'm on now with my N4....the entry is actually there as I went back in and did a .dump of the table and saw it. I've never needed to change user agent but even on the n5 itself when I went into lightning browser and changed the user agent to mobile from "default" it still wouldn't work on the actual phone...have not heard others indicate that...only that it wouldn't work on the tethered devices so I think I'm gonna try a new rom...maybe that katakang some one mentioned earlier.

---------- Post added at 11:42 PM ---------- Previous post was at 11:41 PM ----------

Appreciate the response. I was trying to get actual usb tethering going...I guess most folks are using wifi but not here.
[Nexus 5 Q&A, Help & Troubleshooting] dmorrison:
missing info

Which table do I use? I tried the system table, but that didn't work. There wasn't a table called "global".
[Nexus 5 Q&A, Help & Troubleshooting] NlBO:
Did you only add this line of is this in addition to the dun line. I've used 4.5 gigs of tethered traffic using the dun line with a combination of wifi and USB tether. But I recently got a Tmobile text saying I've used 2 out of 2.5 gig's. AAlthough it seems once I reach the 2.5 a string agent changer will solve it. Just odd its warned me of 2 gigs when I'm over 4.5
[Nexus 5 Q&A, Help & Troubleshooting] andrewNY:
Anyone know if this could be developed into an Xposed Framework module? Thus the setting could be flipped on/off without having to manually edit the settings.db?
[Nexus 5 Q&A, Help & Troubleshooting] AaronMFeld:
Tether starts with errors

I tried using the database hack, but my tether, using the latest available and also the stable available from the play store did not work. I am getting errors like "tethering is starting with errors" etc. I am on Tmobile

It would be helpful if someone who has this working with Tmo would please post exactly which version of root tether they are using and the configuration options. For instance are they using this as "generic" "auto" or as some other phone. I did use the other database hack, WiiFi_on

and that worked to allow me to use the built in tether. I like using mac access for security, and the native tether app does not have that, so I would still appreciate any help in getting the root tether app to work.

Thanks all!
[Nexus 5 Q&A, Help & Troubleshooting] hoihtah:
Nexus 5 on t-mobile family plan with unlimited 4G and 2.5GB 4G tethering

Used native tethering without any modification for about a month... during which i know i went over 2.5GB for tethering.

Today, I was greeted with t-mobile page so I tried the following with a success.

Thought I'd share.

-used root explorer to navigate to /data/data/com.android.providers.settings/databases/

(i've already purchased root explorer in the past. but i'm sure there are some free ones as well.)

-copy settings.db to /storage/emulated

-plug in usb cable

-copy settings.db file to desktop (windows 7) ... also probably a good idea to backup this file... in case things go wrong.

-go to http://sourceforge.net/projects/sqlitebrowser/ and download

-unzip and run SQLite Database Browser

-open settings.db file

-select "Browse Data" Tab

-select "global" table

-"New Record"

-under name column double click and type "tether_dun_required"

-under value column double click and type "0"

-save / quit

-copy the settings.db file from desktop to Nexus 5 /storage/emulated directory

-open root explorer to move the file back into /data/data/com.android.providers.settings/databases/

-Settings - More Wireless & Networking - Mobile Networks - Access Point Names - T-mobile GPRS (mine is fast.t-mobile.com) - APN protocol (change this to IPV4/IPv6)

-Settings - More Wireless & Networking - Mobile Networks - Access Point Names - T-mobile GPRS (mine is fast.t-mobile.com) - APN roaming protocol (change this to IPV4/IPv6)

reboot

Now I'm back on tethering.

Hope this helps