Database Users

Someone with ROOT, request!

Hi, odd request but can someone with a rooted CDMA hero perform the following and send me the settings.db that you get
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Hope someone can help!
Thanks

Unfortunately, I'm stuck at work and I can't do it for you now. I'm sure by the time I get home you'll have found someone. If not I'll do it later. Unfortunately, I won't be home until 1am.

Out of curiosity what exactly do you need this file for? What are you trying to do/hack?

H:\android-sdk-windows\tools>adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
1248 KB/s (39936 bytes in 0.031s)
H:\android-sdk-windows\tools>
sprint pcs

Yeah, why do you need this? I just pulled it off my phone to see what was in it, and while I don't see anything that's obviously personal information, one of the tables does contain something called "google_login_public_key" which a quick search suggests is used for encrypting other personal information and passwords.
I would recommend NOT sending this file to anyone unless you know exactly what you're handing over. I'm certainly not suggesting malevolence, but I'm not really sure what a person could do with this information.
If you have some specific question about the structure of the database, why don't you just ask that?

For anyone wondering, this is what would be contained in that.
http://developer.android.com/reference/android/provider/Settings.System.html

Opps I didn't think there was anything personal in it!
Its just a file with all the system settings in it.
The reason I want it is because my app (proximity sensor, in the themes and apps subforum here) doesn't work on CDMA heros unless auto backlight is on. But works all the time on GSM heros (which I have)
So I am working on a fix which turns the autobacklight on when the program starts, then off again when it exits. To do this I need to know what HTC called the auto backlight setting, which is in settings.db
I have my settings.db and found the correct name, made the changes and it toggles autobacklight for me perfectly, however when I sent it to a user with a CDMA hero it didn't! So I am thinking the name used is different for some reason.
Hope all this makes sence!
Thanks
Tom Reay

I'm not sure if this is exactly what you're looking for, but the creation string for the "system" table is:
CREATE TABLE system (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT UNIQUE ON CONFLICT REPLACE,value TEXT);
and the auto-backlight entry is:
_id,name,value
4364,screen_auto,1
Obviously, the 1 means auto-backlight is on right now. However, when I turn auto-backlight off, that entry disappears from the table.
Is that different from the gsm hero?
Like I said before, I'm not totally sure what the "google_login_public_key" (in the "gservices" table) does. And a further look shows hex values for logging_id, logging_id2, and android_id in the "secure" table, and digest in the "htcservices" table. I'm not sure if any of this is personal info.

Thanks, thats really helpful,
On the GSM hero it is screen_brightness_mode , which if set to 1 enables auto backlight, 0 disables
If this setting on the CDMA Hero? The GSM does not have screen_auto
I found this by opening settings.db in notepad and using ctrl+f!
Thanks for the help!

This is so frustrating!
Setting screen_auto to 1 with System.Settings.putInt(1, "screen_auto") does work, but only once you go to menu->setings->sound and display, then it kicks in and works.
Anyone got any insight into this? I don't understand why HTC would change this!

I am not 100% sure of the inner workings, but it sounds like their may be a trigger in that when you go to the screen it re-reads those settings. Probably can't watch what it does their with a debug can you? You would have to figure out how to mimic going into that screen and throwing what ever trigger it does to re-read that setting or reset it.

Anyway of manually changing gsm.sim.operator.numeric?

If I'm correct, it is this "gsm.sim.operator.numeric" that specifies where we are connected on Market, based on what I've observed from the MarketEnabler app. Any way of manually and permanently changing it myself by editing something? (Like build.prop) I dont want to purchase the donate version.
Sent from my NookColor using Tapatalk

I am looking for the same thing as you. But no luck.
Here is a close solution from Modaco
http://android.modaco.com/topic/304693-market-enabler-workaround/
You may create a shortcut on your desktop and press it when u want to change the codes.
This workaround is not fully automatic but better then nothing and it's quite convenient, right?

[GUIDE]Change settings of FireTV via adb

As people constantly keep complaining about not being able to change the android settings db on the FireTV/Stick here's a way to do so. But be careful, I'm not responsible if you break things. Especially don't disable adb...
adb connect FIRETV_IP_ADDRESS
adb shell
settings get global wifi_on
As you can see the settings binary is included, so you can use
Code:
"settings put [table] [parameter] [value]"
to manipulate the settings.db
Tables are
global
system
secure
Click the links to see which parameters are available.
If you have more spare time than I have, want to play around with this and stumble upon anything useful in the settings db (e.g. enable other input methods than firetv standard,...) feel free to share in this thread.
Btw this does not require root and should work on any 4.2+ device.
Again: I am not responsible if you brick your device!!!

I looked at the values and I don't understand if it is possible to change the time zone. I'm using the FireTv in a +2 GMT timezone and there is no support for it at the front end. Obviously I'm on an unrooted box.

papars said:
I looked at the values and I don't understand if it is possible to change the time zone. I'm using the FireTv in a +2 GMT timezone and there is no support for it at the front end. Obviously I'm on an unrooted box.
Click to expand...
Click to collapse
Just sideload an app called time zone changer from google play store

Device Name

I looked around couldn't find anything. Is there any way to change the device name from the default? Is it possible without root?

ericstephani said:
I looked around couldn't find anything. Is there any way to change the device name from the default? Is it possible without root?
Click to expand...
Click to collapse
Not sure what you mean because your post is pretty vague. You cant edit build prop without root though if that's what you are asking...

XxMORPHEOUSxX said:
Not sure what you mean because your post is pretty vague. You cant edit build prop without root though if that's what you are asking...
Click to expand...
Click to collapse
I am referring to it's network name. For example, my phone identifies itself as android-cb9aec3 on my network. On previous phones I have been able to change the device name in the settings. I can't find anything in the settings on the 6P. I'll look into editing build.prop. I imagine the value is part of the "net" class. Thanks for the tip.

ericstephani said:
I am referring to it's network name. For example, my phone identifies itself as android-cb9aec3 on my network. On previous phones I have been able to change the device name in the settings. I can't find anything in the settings on the 6P. I'll look into editing build.prop. I imagine the value is part of the "net" class. Thanks for the tip.
Click to expand...
Click to collapse
Might check in developer options. I know I've seen the option there before.

Settings/Wi-Fi/(menu top right 3 dots) Advanced/Wi-Fi Direct
Looks like there is an option the Rename Device (top right).
Not sure is this is want your looking for?

I'm used to rename my devices in my router settings and that's what I need to have.
Maybe you should describe the purpose a bit more.

BackInA88 said:
Settings/Wi-Fi/(menu top right 3 dots) Advanced/Wi-Fi Direct
Looks like there is an option the Rename Device (top right).
Not sure is this is want your looking for?
Click to expand...
Click to collapse
Thanks for the suggestion. I believe the Wifi Direct name isn't the device's network name. The network name I am referring to is the name that is included with the phone's DHCP request for an IP address.
In previous versions you used to be able to change this in the developer options. I can't find it anymore on Marshmallow.

I set a static IP address on my device and entered the name I wanted to use (nexus6p) and the IP address in my local DNS server. Did the same for my Chromecast device . I only see these names on the network. I've done this with all my wireless devices.

ericstephani said:
Thanks for the suggestion. I believe the Wifi Direct name isn't the device's network name. The network name I am referring to is the name that is included with the phone's DHCP request for an IP address.
In previous versions you used to be able to change this in the developer options. I can't find it anymore on Marshmallow.
Click to expand...
Click to collapse
It still exists on cm13. I have a clean compiled copy if you want. Just pure cm source plus blobs. Nothing added.

Any way to bypass T-Mobile tether?

Like they tittle Say anyway to bypass T-Mobile tether?

If rooted...
Then theres various ways to bypass and if used together chances are good you won't have to pay 2x for data: modifying your apn to allow dun type, adding the line: net.tethering.noprovisioning=true
to your build.prop and finally using adb from a PC (u can try this even if not rooted) type the following from cmd or powershell: "adb shell" followed by "settings put global tether_dun_required 0" without the " "s and restart your phone n hopefully that should do the trick.
If still throttled by TMo go into Magisk and install tethering_enabler or TTL tethering modules. These modules weren't specifically made for the 6T but they should still be effective. If still unsuccessful then modifying the TTL from the device your trying to tether to will help hide the source of data aim for TTL of 65 to confuse tmo.
If your not rooted then use PDANet USB tether to a PC and hide tether options then create a hotspot from the PC your USB tethered to or use the WiFi Sharing option in PDANet PC Menu. At least thats what works the best for me and I've tried many many things... One other possibility if your on stock no root is to add a new apn with all the same info as normal fast.tmobile.net lte apn only enable MVNO type to GIO for apn type leave it blank and save it. This should hide the default TMobile apn (and make the editor think your using a 3rd party like Mint) now go back and edit the new apn and under apn type put: dun,default,mms,supl try and save it. It should error n say dun not supported... Press Home and force close settings-reboot phone. The dun sometimes will stick if this method isn't patched yet I'm sure it will be soon.
Your final options are to use an app from playstore like VPN Hotspot or VPN Tether they might slow your speed a bit but they should tunnel all your data thru a VPN confusing TMo as to the origin of data. Probably the best and easiest way is by using a custom ROM as most haven't been tainted by Google's latest CarrierConfigManager commits or carrier apn restrictions. If anyone knows how to reverse these commits easily or any other methods not listed please let me know.
I'm currently looking for a clean TMo only dun enabled apns-config.xml so I can overwrite the default n modify the build.prop for a quick fix on any new ROM or update...
As you can probably tell being throttled or having to pay 2x for the same data is a pet peeve of mine and I've spent some time researching the topic. I'd love to hear what ended up working for you or if anyone knows a solid method I missed. Or has a recommendation for a good ROM with unlimited hotspot features built in for the 6t let me know.

I installed the app from this thread, https://www.xda-developers.com/vpn-hotspot-share-vpn-connection/. You can also download the app in the Playstore. I also subscribe to Private Internet Access (https://privateinternetaccess.com) and they have an app that you can download from the playstore.
My phone contract has overseas roaming for a number of days but it restricts tethering and hotspot when roaming. The way I bypass this limitation is to run the PIA VPN, then run the VPN Hotspot app, and use the "Repeater" function. This has worked flawlessly sharing my internet connection with other devices..

gigilie said:
Then theres various ways to bypass and if used together chances are good you won't have to pay 2x for data: modifying your apn to allow dun type, adding the line: net.tethering.noprovisioning=true
to your build.prop and finally using adb from a PC (u can try this even if not rooted) type the following from cmd or powershell: "adb shell" followed by "settings put global tether_dun_required 0" without the " "s and restart your phone n hopefully that should do the trick.
If still throttled by TMo go into Magisk and install tethering_enabler or TTL tethering modules. These modules weren't specifically made for the 6T but they should still be effective. If still unsuccessful then modifying the TTL from the device your trying to tether to will help hide the source of data aim for TTL of 65 to confuse tmo.
If your not rooted then use PDANet USB tether to a PC and hide tether options then create a hotspot from the PC your USB tethered to or use the WiFi Sharing option in PDANet PC Menu. At least thats what works the best for me and I've tried many many things... One other possibility if your on stock no root is to add a new apn with all the same info as normal fast.tmobile.net lte apn only enable MVNO type to GIO for apn type leave it blank and save it. This should hide the default TMobile apn (and make the editor think your using a 3rd party like Mint) now go back and edit the new apn and under apn type put: dun,default,mms,supl try and save it. It should error n say dun not supported... Press Home and force close settings-reboot phone. The dun sometimes will stick if this method isn't patched yet I'm sure it will be soon.
Your final options are to use an app from playstore like VPN Hotspot or VPN Tether they might slow your speed a bit but they should tunnel all your data thru a VPN confusing TMo as to the origin of data. Probably the best and easiest way is by using a custom ROM as most haven't been tainted by Google's latest CarrierConfigManager commits or carrier apn restrictions. If anyone knows how to reverse these commits easily or any other methods not listed please let me know.
I'm currently looking for a clean TMo only dun enabled apns-config.xml so I can overwrite the default n modify the build.prop for a quick fix on any new ROM or update...
As you can probably tell being throttled or having to pay 2x for the same data is a pet peeve of mine and I've spent some time researching the topic. I'd love to hear what ended up working for you or if anyone knows a solid method I missed. Or has a recommendation for a good ROM with unlimited hotspot features built in for the 6t let me know.
Click to expand...
Click to collapse
Be sure you reset APN to default values after you install this new file....

Thanks bro I'll test it out...if it works care if I add it to the main post? Yeah I mentioned the VPN app along with a VPN my only issue with that method is the decrease in speed and some apps/devices don't like the VPN way much. Wish google would stop letting carriers dictate Android or itd b nice if the US would put their foot down and not allow companies to bend us over lock our bootloader's, phone's, devices we pay for or try and swindle us by charging 2x for data or throttle us...

gigilie said:
Thanks bro I'll test it out...if it works care if I add it to the main post? Yeah I mentioned the VPN app along with a VPN my only issue with that method is the decrease in speed and some apps/devices don't like the VPN way much. Wish google would stop letting carriers dictate Android or itd b nice if the US would put their foot down and not allow companies to bend us over lock our bootloader's, phone's, devices we pay for or try and swindle us by charging 2x for data or throttle us...
Click to expand...
Click to collapse
seems to work for me. let me know if it works for you....

dustintinsley said:
seems to work for me. let me know if it works for you....
Click to expand...
Click to collapse
Where do I install the files?

LuCkyCn said:
Where do I install the files?
Click to expand...
Click to collapse
replace the file in /etc/
backup your old file first....

dustintinsley said:
replace the file in /etc/
backup your old file first....
Click to expand...
Click to collapse
Not sure what I did wrong, but it's not loading for me. All my APNs disappeared. I reset to default after replacing with the one provided.

Well, I know this post is rather old, but I made a Magisk module that does everything for you...

L
oloyin