Database Info

[SOLVED] Change wifi MAC Address

I have succesfully changed wifi mac address of my optimus.
We have to just insert a line "macaddr=XX:XX:XX:XX:XX:XX" in the nvram.txt
Here is how I did it:
You require:
1.)Rooted phone.
2.)anroid sdk
1.)First pull the nvram.txt file from /etc/wl to sdcard:
in cmd(windows) goto android-sdk-windows\tools and type
adb shell
2.)Copy nvram.txt from /etc/wl to sdcard
cp /etc/wl/nvram.txt /sdcard/nvram.txt
3.) Using text editor in phone add following line at the end:
macaddr=XX:XX:XX:XX:XX:XX (replace XX:XX:.... with desired mac addr.)
4.)Save file and copy it to /etc/wl from adb shell
cp /sdcard/nvram.txt /etc/wl/nvram.txt
5.)Reboot and it is done.
To restore orignal mac address just delete the macaddr line.
Note:
1.) Tested only in stock LG rome with GNM OC kernel. In other roms or kernel the location of nvram.txt may differ according to the parameter using which driver module (wireless.ko or bcm4325.ko) just find that file and use the above process. It will work.
2.) The file cannot be edited in windows as windows has different new line character than linux. It has to be edited in some linux compactible file editor like Programmers Notepad.

y wud u wanna change ur mac?

B'Coz I can access free Internet by doing this.....

Nice one
And to change hostname? Any ideas?
I changed it, and in phone it appears to be changed. But my router doesn't say the same... Has original hostname...

Yup thats worked with me thanks for sharing
Sent from my LG-P500 using XDA App

Yea bcoz android does'nt use hostname to connect with router. I'm trying to figure out the configuration file for that.....

how to find mac address
how to find the mac address in lg optimus one???

Thats why my optimus one can not take the ip from some puplic networks??

make this thread sticky

not working on Acer Liquid E ! !!
how can I change my mac !!??!!

1st step i already duno how to do T_T
know the pull things from nvram.txt file from /etc/wl to sdcard which require me to root my phone 1st then only can pull out
but after that in cmd(windows) goto android-sdk-windows\tools and type
adb shell
my computer can't detect that was a file in computer,and what is the android-sdk ?

Screw android-sdk ..LOLz..Do this install root explorer on your phone ..navigate to that file on your phone using root explorer , click on mount r/w button ,then long press and select open in text editor, then go to the end of the file and add this
macaddr=xx:xx:xx:xx:xx:xx
replace xx with a combination of hex letter i.e. 1,2,3,4,5,6,7,8,9,A,B,C,D,E,F
example DB:12:3F:4F:11:AA
Save and exit
Reboot
You are all done check phone status in settings

sarfaraz1989 said:
Screw android-sdk ..LOLz..Do this install root explorer on your phone ..navigate to that file on your phone using root explorer , click on mount r/w button ,then long press and select open in text editor, then go to the end of the file and add this
macaddr=xx:xx:xx:xx:xx:xx
replace xx with a combination of hex letter i.e. 1,2,3,4,5,6,7,8,9,A,B,C,D,E,F
example DB:12:3F:4F:11:AA
Save and exit
Reboot
You are all done check phone status in settings
Click to expand...
Click to collapse
after root my phone using z4root/gingerbreak,then download the root explorer from here is it ??
https://market.android.com/details?id=com.speedsoftware.rootexplorer&feature=search_result
if correct navigate to which file ??
sry android newbie here T_T

How about IMEI in some other file.
Wohhh atom bomb.
Sent from my LG-P500 using XDA Premium App

arrgh need solve my wifi problem ASAP
already more than 2week can't connect wifi in my college wifi T_T

Awesome, I've been looking for this everywhere. I can verify this method also works on stock rooted LG Optimus V.

whant's next
i've been change macaddr 'but nothing happen .device not connet wifi.it sitll ask password

you said you can access free internet.
i was just curious that how?
i mean free internet from the service provider or from where???
i too want to use it.
does that mean that if there is any wifi network then i will be able to use it without any pass???

Its simple to change your wifi mac address xD
Root you phone
install busybox (market.android. com/details?id=stericson.busybox) remove the space in link
download Terminal Emulator (market.android. com/details?id=jackpal.androidterm)
in terminal emulator
type -
su
then
busybox ifconfig wlan0 down
busybox ifconfig wlan0 hw ether wlan0 xx:xx:xx:xx:xx:xx
busybox ifconfig wlan0 up
YOU'RE DONE
DONT FORGET THE THANKS BUTTON

vermilion871 said:
Root you phone
install busybox (market.android. com/details?id=stericson.busybox) remove the space in link
download Terminal Emulator (market.android. com/details?id=jackpal.androidterm)
in terminal emulator
type -
su
then
busybox ifconfig wlan0 down
busybox ifconfig wlan0 hw ether wlan0 xx:xx:xx:xx:xx:xx
busybox ifconfig wlan0 up
YOU'RE DONE
DONT FORGET THE THANKS BUTTON
Click to expand...
Click to collapse
is there a way to revert this?
I mean get back to the original hardware mac?

[GUIDE][HOW-TO] Use VPN in Jellybean without security lock

I am not responsible for anything that may come of or from this information. Use at your own risk!
Step #1)
Create security lock through Settings (pattern, pin, password).
Step #2)
Add VPN connections
Step #3)
Plug the phone in and run these commands (requires adb to be setup properly and drivers). I am sure there is a way to do this directly on the phone but this is easier for me.
Commands to remove security:
Code:
adb shell
sqlite3 /data/system/locksettings.db
update locksettings set value=0 where name='lockscreen.password_type';
.exit
exit
Finished!
For me no reboot was required and you do not have to restore pattern in order to create more VPN connections.
Optional Step:
If you decide that you want to restore the security run the one that fits you.
Commands to restore pattern:
Code:
adb shell
sqlite3 /data/system/locksettings.db
update locksettings set value=65536 where name='lockscreen.password_type';
.exit
exit
Commands to restore pin:
Code:
adb shell
sqlite3 /data/system/locksettings.db
update locksettings set value=131072 where name='lockscreen.password_type';
.exit
exit
Commands to restore password:
Code:
adb shell
sqlite3 /data/system/locksettings.db
update locksettings set value=262144 where name='lockscreen.password_type';
.exit
exit

Great! Thank you!

really helpful, i've been fed up with stupid design.

Brilliant, does it also work for ICS?

I don't have an ICS device. If I can find someone that is willing to let me take a look at their ICS device I can see.

When I restart my phone, it needs a password to access VPN menu. what should I do? I don't want to run these commands every time I restart my phone. any solutions?

does it work with exchange password policy as well?
Sent from my GT-I9300 using xda app-developers app

P30SiNa said:
When I restart my phone, it needs a password to access VPN menu. what should I do? I don't want to run these commands every time I restart my phone. any solutions?
Click to expand...
Click to collapse
Hmm did notice that before I will see whats up with that,
portnoy.vitaly said:
does it work with exchange password policy as well?
Sent from my GT-I9300 using xda app-developers app
Click to expand...
Click to collapse
I am not sure but I would imagine so. I would try with pattern lock and not PIN or Password.

Says that "sqlite3: not found" ....
I justd used Forget password option and entered pin , then i didnt choose any options , and the pattern removed

Just tried this. Added vpn, removed lock pattern. It went back to slide, worked fine.
Rebooted, not visiting VPN settings it's asking me to enter credential storage...any ideas how I can a) get past this without wiping my wifi/vpns, or b) remove this but keep my vpns and slide lock?

sorset said:
Says that "sqlite3: not found" ....
I justd used Forget password option and entered pin , then i didnt choose any options , and the pattern removed
Click to expand...
Click to collapse
Same here.
Works great, thanks for sharing :good:

spumanti said:
Same here.
Works great, thanks for sharing :good:
Click to expand...
Click to collapse
Works for me, too, until I reboot :/

Doesn't work. Apparently it's problem with sqlite.
soinfo_relocate(linker.cpp:1013): cannot locate symbol "sqlite3_enable_load_extension" referenced by "sqlite3"...CANNOT LINK EXECUTABLE
Any help please?

Use Script Manager to make this done on every boot.
1. Make this a batch file:
Code:
#!/system/bin/sh
echo "update locksettings set value=0 where name='lockscreen.password_type';" | sqlite3 /data/system/locksettings.db
and save it to your sdcard
2. Use Script Manager to run it on boot and enable su (root).
3. Test it by running it from script manager and see if it runs correctly. You can try enabling PIN and it should be disabled after running this.
4. Final test: reboot your phone and see if PIN/password is disabled.
Keep in mind this gets executed after everything else, so if you try to wake your phone right away, you might still see the PIN prompt.
Another way without script manager:
1. Make this a batch file:
Code:
#!/system/bin/sh
echo "update locksettings set value=0 where name='lockscreen.password_type';" | sqlite3 /data/system/locksettings.db
and save it to your sdcard as 99pinremove
2. Run the following using adb:
Code:
adb shell
su
mount -o remount rw /system
cp /sdcard/99pinremove /etc/init.d/99pinremove
chmod 755 /etc/init.d/99pinremove
chown root:shell /etc/init.d/99pinremove
exit
exit

In 4.4 there is no such file
Code:
/data/system/locksettings.db
.. any ideas?

[Q] backtrack permission denied

Hi,
I download backtrack-v10-image and I used the Linux Installer from linuxonandroid to launch it, but when I want to install anything, it's shows me "permission denied" in terminal emulator :crying: as well as in console of backtrack "requested operation requires superusers privilege" and when i tape Vnc password's it's show me "authentications failure" .
So I try to start the image manually using the bootbt provided by the website of backtrack. this faith it, the console shows me backtrack
[email protected] by red, against the keys of keyboard are completely messed up, whether in the physical or virtual keyboard.
Sorry if I'm not in the right section .... thank you
tf300t , ww_epad -10.6.1.15.3-20130416, rooted
ps: I can't post any link, you have to google it (To prevent spam on the XDA forums, ALL new users prevented from posting outside links in their messages. After approximately 10 posts, you will be able to post outside links. Thank you for understanding!) as you can see that I'm noob here .

solved by my self, i was able to do it by modifying the directory of the image and using linuxonandroid launcher, but i took precaution to note the password now, like this:
[email protected]:/ $
[email protected]:/ $ cd /sdcard/BT5
[email protected]:/sdcard/BT5 $ su
[email protected]:/storage/emulated/legacy/BT5 # sh /data/data/com.zpwebsites.linuxonandroid/files/bootscript.sh /sdcard/BT5/backtrack.img
Checking loop device... MISSING
Creating loop device... OK
mount: mounting /storage on /data/local/mnt/external_sd failed: Invalid argument
No user defined mount points
net.ipv4.ip_forward = 1
Config file not found, using defaults!(/root/cfg/backtrack.img.config)
Starting first boot setup.......
Creating User account (named backtrack)
Enter new UNIX password: <you have to note this password to use it in backtrack console after sudo su
Retype new UNIX password:
passwd: password updated successfully
The user `backtrack' is already a member of `tty'.
Please enter a password for VNC (must be between 6 and 8 characters long
Using password file /home/backtrack/.vnc/passwd
Password:
Password too short
groupadd: group 'sdcard-rw' already exists
Start VNC server? (y/n)
y
Start SSH server? (y/n)
y
Now enter the screen size you want in pixels (e.g. 800x480), followed by [ENTER]:
1280x752
New 'X' desktop is localhost:0
Starting applications specified in /home/backtrack/.vnc/xstartup
Log file is /home/backtrack/.vnc/localhost:0.log
If you see the message 'New 'X' Desktop is localhost:0' then you are ready to VNC into your backtrack OS..
If connection from a different machine on the same network as the android device use the address below:
eth0: error fetching interface information: Device not found
If using androidVNC, change the 'Color Format' setting to 24-bit colour, and once you've VNC'd in, change the 'input mode' to touchpad (in settings)
* Starting OpenBSD Secure Shell server sshd [ OK ]
Save settings as defaults? (y/n) (You can always change it later in the app)
y
Config saved to /root/cfg/backtrack.img.config
To shut down the Linux environment, just enter 'exit' at this terminal - and WAIT for all shutdown routines to finish!
Click to expand...
Click to collapse
I just want to know how to clean the installation of the "chroot"
without move / rename the image in android to return to the initial state of "chroot"
(without the files are installed in the backtrack)

Settings.db gone on Marshmallow?? R

Guys I have a question...
On stock lollipop there is a DATABASE folder located at com.android.providers.settings ,inside the database folder a file called SETTINGS.DB .
I usually edit this file to avoid carrier detecting that I'm tethering and as always worked.
Now I updated to marshmallow on my N5 but the setting.db isn't there anymore.
Ideas?
Thanx
Sent from my Nexus 5 using Tapatalk

I have the same issue.
Basically Tether no longer works on my Nexus 5.
-Hotspot turns on and Data is working on Nexus 5, but connected (Tethered Devices) cannot get internet access.....DNS_Probe failures

I rolled back to lollipop for the moment while finding a solution
Sent from my Nexus 5 using Tapatalk

This worked for me on Sprint device
I used adb to change the settings.db
1. Typed "adb shell"
2. Then "settings put global tether_dun_required 0"
3. I also added in the build.prop file "net.tethering.noprovisioning=true"
reboot and enjoy
Hope this helped.

chrisduclo said:
This worked for me on Sprint device
I used adb to change the settings.db
1. Typed "adb shell"
2. Then "settings put global tether_dun_required 0"
3. I also added in the build.prop file "net.tethering.noprovisioning=true"
reboot and enjoy
Hope this helped.
Click to expand...
Click to collapse
Thanks I'll give that a try now.
Successful, Hotspot working here now.
I already had the build.prop entry (force of habitat) :
net.tethering.noprovisioning=true
For the setting global entry:
I used Terminal Emulator
su (for super user)
Then typed "settings put global tether_dun_required 0"
After making entry I rebooted device and tested Hotspot.
Hotspot working.

My Nexus 5 with rooted (Elementalx) Android 6.0 works with tethering by just turning it on. I am on AT&T.

mariano3113 said:
Thanks I'll give that a try now.
Successful, Hotspot working here now.
I already had the build.prop entry (force of habitat) :
net.tethering.noprovisioning=true
For the setting global entry:
I used Terminal Emulator
su (for super user)
Then typed "settings put global tether_dun_required 0"
After making entry I rebooted device and tested Hotspot.
Hotspot working.
Click to expand...
Click to collapse
Can u make a step by step tutorial for the less knowledge people like me please lol
Sent from my P01MA using Tapatalk

He just told you
Sent from my Nexus 5 using Tapatalk

guinnes.s said:
Can u make a step by step tutorial for the less knowledge people like me please lol
Sent from my P01MA using Tapatalk
Click to expand...
Click to collapse
Step 1) Use a Nexus 5 or 6 on Marshmallow with Root* (There are plenty of threads and ROMs detailing Root access on those Nexus devices with Busybox and Super Su/SuperUser working)
Step 2) Download a File Explorer that offers root privilege like ES File Explorer (Root Explorer toggled On and granted SU access)
Step 3) Navigate in file explorer to System ->Build.prop
Step 4) Open build.prop (Es File Explorer has ES Note Editor included)
Step 5) choose to edit, so that you can add the line entry: net.tethering.noprovisioning=true
Step 6) Save build.prop and exit
Step 7) Download Terminal Emulator or some other Terminal App
Step 8) Open Terminal app and grant SU either by prompt or by typing "su" as a command *App and SU confirmation process may vary*
Step 9) After SU access is acquired in Terminal Emulator/app type: settings put global tethering_dun_required 0
Step 10)Exit Terminal app
Step 11) Reboot device
Step 12) Test Native Hotspot/tether
If not working and on Sprint/CDMA carrier double check/repeat steps 1-12
(CDMA carriers don't allow APN edit on Nexus 5...APN list does not show)
If using GSM carrier (At&t, T-Mobile), if hotspot is still not working;
-Go to settings->Wireless & Networks choose More
-Select Cellurlar Networks
-Select Access Point Names (APN)
-Go to APN Type and add: ,dun
(Comma dun with no spaces*)
Save & Exit
Reboot device
Test Hotspot/tethering, if not working double check all entry changes...

Can you still do this on a phone that is not rooted? This worked on lollipop but doesn't on marshmallow:
adb shell content insert --uri content://settings/system --bind name:s:tether_dun_required --bind value:i:0

testinguser said:
Can you still do this on a phone that is not rooted? This worked on lollipop but doesn't on marshmallow:
adb shell content insert --uri content://settings/system --bind name:s:tether_dun_required --bind value:i:0
Click to expand...
Click to collapse
what's the error that you're getting when you run that command.

[/COLOR]
mariano3113 said:
Step 1) Use a Nexus 5 or 6 on Marshmallow with Root* (There are plenty of threads and ROMs detailing Root access on those Nexus devices with Busybox and Super Su/SuperUser working)
Step 2) Download a File Explorer that offers root privilege like ES File Explorer (Root Explorer toggled On and granted SU access)
Step 3) Navigate in file explorer to System ->Build.prop
Step 4) Open build.prop (Es File Explorer has ES Note Editor included)
Step 5) choose to edit, so that you can add the line entry: net.tethering.noprovisioning=true
Step 6) Save build.prop and exit
Step 7) Download Terminal Emulator or some other Terminal App
Step 8) Open Terminal app and grant SU either by prompt or by typing "su" as a command *App and SU confirmation process may vary*
Step 9) After SU access is acquired in Terminal Emulator/app type: settings put global tethering_dun_required 0
Step 10)Exit Terminal app
Step 11) Reboot device
Step 12) Test Native Hotspot/tether
If not working and on Sprint/CDMA carrier double check/repeat steps 1-12
(CDMA carriers don't allow APN edit on Nexus 5...APN list does not show)
If using GSM carrier (At&t, T-Mobile), if hotspot is still not working;
-Go to settings->Wireless & Networks choose More
-Select Cellurlar Networks
-Select Access Point Names (APN)
-Go to APN Type and add: ,dun
(Comma dun with no spaces*)
Save & Exit
Reboot device
Test Hotspot/tethering, if not working double check all entry changes...
Click to expand...
Click to collapse
I've tried multiple Terminal Emulators on my device and receive an error message after inserting the "settings put global tethering_dun_required 0" and then hitting "ENTER" key on Google Keyboard. I think this process must be completed on a computer using adb command. Can you confirm that the Terminal Emulator app was successful in making this change? I have tried multiple emulators... Thank you!
NEXUS 6, Rooted, Stock 6.0 MRA58K

HUSKER77 said:
[/COLOR]
I've tried multiple Terminal Emulators on my device and receive an error message after inserting the "settings put global tethering_dun_required 0" and then hitting "ENTER" key on Google Keyboard. I think this process must be completed on a computer using adb command. Can you confirm that the Terminal Emulator app was successful in making this change? I have tried multiple emulators... Thank you!
NEXUS 6, Rooted, Stock 6.0 MRA58K
Click to expand...
Click to collapse
Adding some images as confirmation: Current device used for Screen shots was Nexus 5 (hammerhead)
Terminal App screenshot
Su entry screenshot
SU access prompt screenshot
Root Terminal screenshot
Settings Dun entry screenshot
Successful entry w/no error message screenshot
Hope that helps. I'll try tonight on Nexus 6 (shamu) as a follow up.
testinguser said:
Can you still do this on a phone that is not rooted? This worked on lollipop but doesn't on marshmallow:
adb shell content insert --uri content://settings/system --bind name:s:tether_dun_required --bind value:i:0
Click to expand...
Click to collapse
Yes, you should be able to force set value via adb shell without root.
-Or it used to- with Nexus Devices I have an inclanation to Root

HUSKER77 said:
[/COLOR]
I've tried multiple Terminal Emulators on my device and receive an error message after inserting the "settings put global tethering_dun_required 0" and then hitting "ENTER" key on Google Keyboard. I think this process must be completed on a computer using adb command. Can you confirm that the Terminal Emulator app was successful in making this change? I have tried multiple emulators... Thank you!
NEXUS 6, Rooted, Stock 6.0 MRA58K
Click to expand...
Click to collapse
Follow up with success on Marshmallow with Nexus 6 (shamu) (No errors)

testinguser said:
Can you still do this on a phone that is not rooted? This worked on lollipop but doesn't on marshmallow:
adb shell content insert --uri content://settings/system --bind name:s:tether_dun_required --bind value:i:0
Click to expand...
Click to collapse
I just tried this command on 6.0 MRA58K and it appeared to work, I got no errors. I also modified build.prop as above. I will try tomorrow to see if the Tethering data increments within my T-Mobile Account app.

mariano3113 said:
Yes, you should be able to force set value via adb shell without root.
-Or it used to- with Nexus Devices I have an inclanation to Root
Click to expand...
Click to collapse
So you're saying we could get tether on Nexus Marshmallow *without* root?
...or that we can force set that value with ADB shell without root, but *also* need to edit build.prop?
Thanks!

On my N5 on MetroPCS, I was able to enable tethering by just running the following:
Code:
adb shell
settings put global tether_dun_required 0
I ran it has su originally, but I can run it without and don't get any errors. I didn't change the build.prop I did have to change the APN type to IP4 (it would work at first on IP6 but when I switched towers or something it would stop). So in theory in my case root shouldn't be needed, my device is now unrooted again and all is working fine.
Tethering now works, I think this is a little different than some of the other carriers since MetroPCS allows tethering, but just not with a BYOD from what I have heard.

Guys, anyone know the location of settings.db on MM?

On my Sprint Nexus 5 running 6.0.1
I ran the
adb shell
settings put global tether_dun_required 0
Didn't edit build.prop since I have no idea how to.
I'm tethering. No root. Bone stock. No warnings or anything yet.

kschossow said:
On my Sprint Nexus 5 running 6.0.1
I ran the
adb shell
settings put global tether_dun_required 0
Didn't edit build.prop since I have no idea how to.
I'm tethering. No root. Bone stock. No warnings or anything yet.
Click to expand...
Click to collapse
OK. Works perfect on my Nexus 5.
On my Nexus 6p I do the same commands but I get this message when I try to turn on hotspot. "Your device does not support this service. Please contact your service provider."
I thought it might work on the 6p seeing as it works on the Nexus 5. Both are on marshmallow. Any ideas?

How to enter /data/system/users/0/settings_ssaid.xml without root?

Is there way to enter /data/system/users/0/settings_ssaid.xml without root ?
beacuse this app must need same ssaid in other devices i need to enter /data/system/users/0/settings_ssaid.xml see ssaid without root pls help me

Android ID can be changed with the help of ADB through the following command
Code:
adb shell "settings secure put android_id [my_new_android_id]"
where ROOT isn't required.

xXx yYy said:
Android ID can be changed with the help of ADB through the following command
Code:
adb shell "settings secure put android_id [my_new_android_id]"
where ROOT isn't required.
Click to expand...
Click to collapse
no i want see ssaid first without root after that i will change with other device rooted

OMG
Then simply revise the command as follows
Code:
adb shell "settings get secure android_id"
Hint: Become familiar with Android's system ( LINUX ) commands.

I need app developer help will give you enough money have a problem that I want to solve
This app can be accessed from another device only once a month.
It uses a value called ssaid, which is different for each device.
What I want is to bypass this ssaid value
It seems that this value is stored on the server