Insert data into 'secure' table from shell script

Question

hii everyone I am trying to manually set the lock screen to none in a Moto A855(Droid 1) device i have written following shell script for running same but I am getting Exceptions while running the code , i followed this link for nesting quotes and this link for inserting data into Sqlite from ADB

./adb shell su -c 'mount -o remount,rw /data'
./adb shell su -c 'sqlite3 /data/data/com.android.providers.settings/databases/settings.db "insert into secure values(50,'"'lockscreen.disabled'"',1);"'

I am getting following errors while running the script

sh: no closing quote
/system/bin/sh: ": not found

please help me

thanks in Advance

Arnab Nandy · Accepted Answer · 2014-11-14 04:32:14Z

0

Try the following instead, as I think it's a comma issue.

./adb shell su -c 'sqlite3 /data/data/com.android.providers.settings/databases/settings.db '"'insert into secure values(50,'"'lockscreen.disabled'"',1);'"'

edited Nov 14, 2014 at 4:32

answered Nov 13, 2014 at 7:09

Arnab Nandy

6,8025 gold badges50 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Arnab Nandy Over a year ago

your command's problem is it not able to find closing " or ' in any case.

Software Sainath Over a year ago

thank you so much for replying i have copied your answer and pasted in my script then it is showing Usage: su [options] [LOGIN] Options: -c, --command COMMAND pass COMMAND to the invoked shell -h, --help display this help message and exit -, -l, --login make the shell a login shell -s, --shell SHELL use SHELL instead of the default in passwd -v, --version display version number and exit -V display version code and exit. this is Superuser.apk

Collectives™ on Stack Overflow

Insert data into 'secure' table from shell script

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related