[Q] problem using adb to unlock phone [want to find solution deadly!!!] - Defy Q&A, Help & Troubleshooting

My phone was locked after too many attempts to unlock the pattern password(i didnt did it myself, anyway~)
I didnt turn on usb debugging before the phone was locked so i tried to start adb daemon from the CWM recovery(in advanced->start adbd)
i followed instructions there after google around: http://chethaka.wordpress.com/2013/02/28/unlock-an-android-device/
Type following commands in cmd
adb devices (verify device is identified by pc. If not reconnect device and try again. it should display “device” with a serial no)
adb shell
cd /data/data/com.android.providers.settings/databases
sqlite3 settings.db
update system set value=0 where name='lock_pattern_autolock';
update secure set value=0 where name='lock_pattern_autolock'; (for some devices update “system” is enough but I had to update “secure” too)
update system set value=0 where name='lockscreen.lockedoutpermanently';
update secure set value=0 where name='lockscreen.lockedoutpermanently';
.quit
exit
adb reboot
however i failed on the step "sqlite3 settings.db", saying that
"3 settings.db <
register_localized_collators() failed"
why is that?? what should i do???
(my last post related: http://forum.xda-developers.com/showthread.php?t=2531921)

screenshot

help
any answer??

Use aroma file manager to remove gesture.key
Sent from my MB526 using Tapatalk 4

Related

[Question] Pattern lock - too many attempts

Good day,
I was curious about what would happen if i do to many fail attempts in the pattern lock screen of my magic.
I looked around on google to find the answere and noticed that there were many many pages that talked about andoid having a bug.
If i understood correctly, after x times incorrect pattern inputh you get a login screen for your google account you used for the phone.
The bug seems to make the login impossible.
You will be able to enter the credencials but login will always fail.
I was wondering if anybody is aware about this and can tell me if this bug has been solved now.
Many people talk about performing a hard reset when this happens.
Which is a solution,... but not one i was hoping for.
NOTE- i am not in this situation now, i can access my phone.
But i do have a lot of D**Head friend who love to figure out what happens when they try to many times.
If you try too many times you get a timeout. You have to wait 30 seconds for each attempt.
Don't know bout the loginscreen though, never happened to me.
Lucky for you, I've had the exact same problem recently and found a solution that doesn't require full reset =)
./adb shell
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update system set value=0 where name='lock_pattern_autolock';
sqlite> update system set value=0 where name='lockscreen.lockedoutpermanently';
sqlite> .exit
# exit
originally found on http://www.naschenweng.info/2009/09/17/android-too-many-pattern-attempts-phone-is-locked
good luck!
Hi there!
I have exactly the same problem but when i try the solution using the sqlite3 commande, i got an sqlite3: not found .
Is there any pre-requisite i forgot?
My steps were: fastboot with a modified image then adb shell: didn't work, then normal boot and adb shell: didn't work too.
Any help will we welcome!
Lg eve pattern locked need help!!!
my pattern lock was entered wrong too many times and i dont know how to access the phone even my google account wont work what do I do?
i have an Lg eve .
Here is what i got.
C:\AndroidSDK\tools>adb shell
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update system set value=0 where name='lock_pattern_autolock';
sqlite> update system set value=0 where name='lockscreen.lockedoutpermanently';
sqlite> .exit
# exit# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update system set value=0 where name='lock_pattern_autolock';
sqlite> update system set value=0 where name='lockscreen.lockedoutpermanently';
sqlite> .exit
# # sqlite: not found
# sqlite: not found
# sqlite: not found
#
# exit
#
Click to expand...
Click to collapse
Have an idea?
afras said:
Have an idea?
Click to expand...
Click to collapse
Yeah. You did it wrong.
Pay attention:
Type this:
./adb shell
Click to expand...
Click to collapse
You'll get a shell prompt.
Type this:
sqlite3 data/data/com.android.providers.settings/databases/settings.db
Click to expand...
Click to collapse
You'll get the sqlite prompt.
Type these three lines:
update system set value=0 where name='lock_pattern_autolock';
update system set value=0 where name='lockscreen.lockedoutpermanently';
.exit
Click to expand...
Click to collapse
Many thanks to you my friend, it worked
You sir, are a life-saver
lost
ok i am having the exact problem with my lg eve android...but where do i type in these codes is my question?
im getting crazy
sqlite3 is there right?? see screenshot
C:\android-sdk-windows\tools>adb -d shell
$ su
su
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite3: not found
#
running sqlite3 manually (doubleclicking sqlite3) works perfectly, but it doesnt connect to my android phone
Hi,
I try to unlock my sister's phone (HTC Tattoo), but it doesn't work, I have a problem with sqlite3 : I write in the shell "sqlite3 data/data/com.android.providers.settings/databases/settings.db" and I have this : "sqlite3: permission denied"
I don't know what to do !? The device is recognized (adb devices detects it) and the Debug USB mode is activate.
I'm waiting for your help.
P.S. : excuse me for my bad english : I'm french !
Easier fix!
I just finish talking to rogers and all you have to do 9if your willing to reset your phone and lose all your apps etc) is hold one of your volume buttons the centre menu button and the photo button hold these 3 for about 15-25 seconds and it will ask you to factory reset your phone! problem solved!
I have a Q...
Approximate how many times you have to enter the wrong password/pattern to have it permanently locked?
I don't think it perma locks. If you mess it up, it should just ask for your Google credentials again.
Sent from my T-Mobile myTouch 3G using Tapatalk
yeah... I want to know how many attempts before it asks you for the google credentials.
thx
3-5, can't remember for sure though.
Sqlite3 not found
>20 wrong codes and your locked out.
>I found this out thanks to my darling wife...and of course I had just turned off wireless an hour before to stop kids downloading crap whislt playing >games.
>So now I'm stuck...
C:\android-sdk-windows\tools>adb shell
$ su
su
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite3: not found
#
>Any ideas how to "find" sqlite3? :fingers-crossed:

Rooted, can I now sideload?

I am rooted with the Liberated ROM and using unrevoked tool. I tried sideloading an app I downloaded from my phone's browser and it said the phone was still locked outside of the marketplace apps. Am I doing something wrong?
Thanks
if windows and assuming you have installed the Android SDK, rename the SDK folder to simply c:\android
then run this little batch file (save it via notepad as whateveryouwant.bat), alternatively execute line by line the commands below
cd\android\tools
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
pause 1
adb reboot
You need to enable sideloading separately. Refer to this post, specifically the section entitled "Also, enable installation of non-Market (untrusted) apps (sideloading)."
http://forum.xda-developers.com/showpost.php?p=6906288&postcount=2
kaschenberg said:
I am rooted with the Liberated ROM and using unrevoked tool. I tried sideloading an app I downloaded from my phone's browser and it said the phone was still locked outside of the marketplace apps. Am I doing something wrong?
Thanks
Click to expand...
Click to collapse
NOTES:
You MUST have root access on the phone in order for this to work
You must have the tools directory from the Android SDK installed.
sqlite3 is included in the Android SDK tools, so this would be the best way:
Windows:
Enable USB debugging (settings > applications > development > USB Debugging)
From the command prompt, change to the sdk/tools directory.
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo select value from secure where name = 'install_non_market_apps';|sqlite3 settings.db
If the last command returns 1, then your change is successful.
Linux/OS X
Enable USB debugging (settings > applications > development > USB Debugging)
From a superuser command prompt, change to the /sdk/tools directory
./adb remount
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
./adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "select value from secure where name = 'install_non_market_apps';"|./sqlite3 settings.db
If the last command returns 1, then your change is successful.
Reboot phone and sideloading works. (thanks fluffyarmada)
xdafly said:
if windows and assuming you have installed the Android SDK, rename the SDK folder to simply c:\android
then run this little batch file (save it via notepad as whateveryouwant.bat), alternatively execute line by line the commands below
cd\android\tools
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
pause 1
adb reboot
Click to expand...
Click to collapse
worked perfectly! thanks for that! i just ran line for line in cmd prompt and i can now sideload just fine on the phone. now, just need to find apps to sideload!!! already installed swype and tried the wifi tether thing, but after that, i dont know what else to load up! i guess its back to more forum searching. but thanks so much!
sorry for the noobish question...
is sideloading the same as installing and running apps from the SD card? and, i have also heard that if you run anything from the SD card, you should go with a Class 6 SD.
im holding off on the root for now... but these are some of the few questions i had in regards to it
jbizz said:
sorry for the noobish question...
is sideloading the same as installing and running apps from the SD card? and, i have also heard that if you run anything from the SD card, you should go with a Class 6 SD.
im holding off on the root for now... but these are some of the few questions i had in regards to it
Click to expand...
Click to collapse
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.
attn1 said:
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.
Click to expand...
Click to collapse
cool deal, wasnt for sure or not. i have a Patriot 8gb Class 4. so in any case, im still good. looking forward to rooting my phone in a week or 2.
attn1 said:
No, it is not. That is referred to as apps2sd. That is not currently available on the Aria, and once it is, a class 2 Samsung works just fine.
Click to expand...
Click to collapse
In anticipation of this I just purchased a 16gig sd card sound...can't wait...
Sent from my HTC Aria using XDA App
attn1 said:
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
COMMON
Enable USB debugging (settings > applications > development > USB Debugging)
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Reboot phone and sideloading works. (thanks fluffyarmada)
Click to expand...
Click to collapse
I have an HTC Aria, rooted with Clockwork, an 003 rom version installed.
The annoying AT&T startup was replaced as stated elsewhere, yet I see the AT&T files it was suppose to delete are still present.
(Debugging in Settings is on, and signature verification is off in Clockwork)
I'm unclear why the AT&T files still remain after running the 003 rom, or how to manually remove them.
More importantly...
I'm confused on what the step by step means are to get my Aria to accept unapproved apps.
Exactly how do I make the modifications you posted to allow non-Market apps to be installed on my Aria?
After installing Adroid SDK, ran Sqlite3.exe, and typed in this on my Windows Vista pc -
sqlite> adb remount (enter)
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db (enter)
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db (enter)
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db (enter)
I then x'ed out of Sqlite and rebooted the Aria.
I obviously missed something, because after downloading a non-Market app to the Aria successfully, when I clicked to install it, I'm still getting the same message that it's not allowed.
What do I need to correctly make the code work???
Best solution I could find for installing non market apps. http://forum.androidcentral.com/showthread.php?p=236589#post236589
I've worked on this a few hrs now. I got Clockwork Recovery to work. Figured out HTC Sync was reverting the phone to stock recovery somehow. Removed that though...
Have rerun Unrevoked, and I can get into clockwork. I'm not interested in changing to different ROM now, just removing ATT crap.
When I try sideloading instructions/alternate method for removing ATT stuff, I get an error in cmd:
C:\android\tools>adb remount
remount failed: Operation not permitted
adb devices returns:
List of devices attached:
<myserial#> device
Any ideas? Have I not completed the root access procedure? I thought it was part of the Unrevoked process.
attn1 said:
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
COMMON
Enable USB debugging (settings > applications > development > USB Debugging)
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Reboot phone and sideloading works. (thanks fluffyarmada)
Click to expand...
Click to collapse
Remember to run all this from within the android-sdk-linux_86/tools directory. For users that have modified their path, adb can be run from anywhere, but these commands won't work properly.
Thanks for the guide! Seems to have worked properly.
Great! The problem was the drive. I had to cd to the device drive (h: in my case) to get it to find the files. Thanks again.
I got the Swype apk, installed it, and it's working perfectly!
Quick question. Does the phone have to be operating in a boot mode via Clockwork OR on and operating normally when you do this. Once connected via USB does it have to be set for Charge only, Sync, or Disk drive when this is done. I know it should be set for USB debugging. My phone is rooted but still has the original ROM. I am getting a permission denied error when I run the adb remount command.
attn1 said:
NOTES:
You MUST have root access in order for this to work
You must have the tools directory from the Android SDK installed.
sqlite3 is included in the Android SDK tools, so this would be the best way:
Windows:
Enable USB debugging (settings > applications > development > USB Debugging)
From the command prompt, change to the sdk/tools directory.
adb remount
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
Optional test for success:
adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo select value from secure where name = 'install_non_market_apps';|sqlite3 settings.db
If the last command returns 1, then your change is successful.
Linux/OS X
Enable USB debugging (settings > applications > development > USB Debugging)
From a superuser command prompt, change to the /sdk/tools directory
./adb remount
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
adb push settings.db /data/data/com.android.providers.settings/databases settings.db
Optional test for success:
./adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
echo "select value from secure where name = 'install_non_market_apps';"|./sqlite3 settings.db
If the last command returns 1, then your change is successful.
Reboot phone and sideloading works. (thanks fluffyarmada)
[/list]
Click to expand...
Click to collapse
anybody could translated in to normal language for people who is not in familiar with computer??
can't push settings.db
I've got a problem! I'm able to pull settings.db and make the change. But when I try pushing it back onto the phone, all it does is print the help screen. I've got an htc aria and am using ubuntu. Thanks!
ctoacsn said:
I've got a problem! I'm able to pull settings.db and make the change. But when I try pushing it back onto the phone, all it does is print the help screen. I've got an htc aria and am using ubuntu. Thanks!
Click to expand...
Click to collapse
I figured out my problem. The instructions for linux say
Code:
adb push settings.db /data/data/com.android.providers.settings/databases settings.db
when it should be
Code:
adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
There was a space, instead of / between databases and settings.db
http://de.codeplex.com/
getting error:
adb remount
remount failed: Operation not permitted
when trying to set the sideloading as mentioned by attn1.
inWindows Vista, after rooting using unrevoked process.
Note that I have both the SU app showing up in All apps on phone and the ClockworkMod and ran adb from the \tools directory.
Anyone know what the problem is?

Install 3rd party apps on stock, rooted Aria

Since it took me over an hour to finally get this to work, I figured I would make a new post. (That's a long time to just change a 0 to a 1)
If you want to use your stock Rom but are rooted then this is the easiest way to be able to install non-market apps. I take no credit for this as it is from a post from Attn1 (thanks!).
HTC Sync does not have a choice to add apps in the latest version that I have, I don't know if did before, but I could not get it working. We can all thank AT&T
for this!
Put your phone into Recovery mode.
Goto advanced>mount system and mount data.
Make sure your phone is recognized by adb devices in
your Terminal program.
If not you can use adb kill-server then adb start-server
If you're using linux then you need to precede the adb command
with ./adb
Follow the directions below and you will installing non-market apps
in no time.
NOTE: You MUST have root access in order for this to work
sqlite3 is included in the Android SDK tools, so this would be the best way:
* COMMON
* Enable USB debugging (settings > applications > development > USB Debugging)
* adb remount
* adb pull /data/data/com.android.providers.settings/databases/settings.db settings.db
Linux/OS X
* echo "update secure set value = 1 where name = 'install_non_market_apps';"|./sqlite3 settings.db
WINDOWS
* echo update secure set value = 1 where name = 'install_non_market_apps';|sqlite3 settings.db
COMMON
* adb push settings.db /data/data/com.android.providers.settings/databases/settings.db
* Reboot phone and sideloading works. (thanks fluffyarmada)
Yes!!! Thank you, this worked! Rooted, stock HTC Aria 2.2.2.
The only problem I had was that sqlite3 was in the "tools" folders, so I had to copy it into "platform-tools."
Side load wonder machine
Sent from my SAMSUNG-SGH-I897 using XDA App
thankz dude..it's work
my thumb is for u

Disabling PIN lock

Anyway to do this via adb? Found No Lock app in market...but I need to run the app first and enable no lock. Then it doesn't apply on boot.
I'm trying to unlock a friends phone without resetting data. Btw...this phone I'm trying to unlock is rooted. She's an idiot and forgot the pin she used and thinks she pressed the wrong pin....twice to confirm. Lol
I know its possible. I just need to find an app that runs/opens after I adb install it. And applies on boot. Or maybe a shell command to open it?
Edit:
***confirmed****
This works for pattern. I need PIN. Can anyone help?
> adb -d shell
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update secure set value=0 where name='lock_pattern_autolock';
sqlite> .exit
# exit
> adb reboot
Sent from my DROIDX using XDA App
andrewp3481 said:
Anyway to do this via adb? Found No Lock app in market...but I need to run the app first and enable no lock. Then it doesn't apply on boot.
I'm trying to unlock a friends phone without resetting data. Btw...this phone I'm trying to unlock is rooted. She's an idiot and forgot the pin she used and thinks she pressed the wrong pin....twice to confirm. Lol
I know its possible. I just need to find an app that runs/opens after I adb install it. And applies on boot. Or maybe a shell command to open it?
Edit:
***confirmed****
This works for pattern. I need PIN. Can anyone help?
> adb -d shell
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update secure set value=0 where name='lock_pattern_autolock';
sqlite> .exit
# exit
> adb reboot
Sent from my DROIDX using XDA App
Click to expand...
Click to collapse
did you try sqlite> update secure set value=0 where name='lock_pin_autolock';
edit:
if that doesnt work do this please:
> adb -d shell
# sqlite3 data/data/com.android.providers.settings/databases/settings.db
sqlite> update secure set value=65536 where name='lockscreen.password_type';
sqlite> .exit
# exit
> adb reboot
that should remove all passwords on lock screen. i cant try here at work but i can once i get home if you like.

GUIDE:how to bypass lockscreen (usefull for when forget your password)

hi all
this is my last guide
i wana teach you how to pass lock screen passwrod or pattern when you forget your password (or when you want to see what files your friend has in his mobile but you don't have the pass )
ok first of all you will need the file that i attached(it is platform-tools of android eclipse that you need to install it as an add-on)
ok. now i explain how to do it
0-download attached file
1-extarct the zip any were you want
2- go to platform-tools folder
3-get the shift key and right click any where in the folder that there is no item there
4-click on Open Command Window here and do these things
easy way that work better (i tried both methods in stock rom and only this one worked
1-write this in command port and press enter
HTML:
adb shell rm /data/system/gesture.key
2-reboot your phone
3- now you can unlock your phone with any pattern
hard way that may not work
1- write this things one by one in the command port
HTML:
cd /data/data/com.android.providers.settings/databases
sqlite3 settings.db
update system set value=0 where name='lock_pattern_autolock';
update system set value=0 where name='lockscreen.lockedoutpermanently';
.quit
2- now reboot your phone
3- pattern should be disabled
(as i said this way didnt work in stock 4.1.b.13 but it may work in others)
The ONLY bad thing about this is that you NEED ADB Debugging on. I guess you could do it in recovery if you had it installed, but I'm not 100% sure
you can be 100% sure about doing it in recovery

Categories

Resources