sqlite3: permission denied

[Nick77]

already read something in some threads but couldn't find a definite answer to a question: must i have root to be able to run a sql command from "run shell" action?

i would like to run some sql commands that allow me to make some work on a db. I created the db by myself and i saved it on sdcard.

but if i try and run a sql command i get the same %error: "sqlite3: permission denied".

for instance i tried the following:

Test Sql (17)
A1: Run Shell [ Command:sqlite3 Watchedlist.db "SELECT * FROM t1"; Timeout (Seconds):0 Use Root:Off Store Output In:%output Store Errors In:%error Store Result In:%result Continue Task After Error:On ] 
A2: Flash [ Text:%output Long:Off ] 
A3: Flash [ Text:%result Long:Off ] 
A4: Flash [ Text:%error Long:Off ] 

No matter what kind of sql command i put in there, A3 is always "127" and A4 is always "sqlite3: permission denied".

i guess i must have root to do all of this, but can anyone confirm it?

and if so, is there any workaround to do it without root permission?

thanks in advance 

[nanobrain]

result 127 means "command not found". Do you actually have sqlite3 installed on your phone?. IIRC it is not installed by default and needs to be installed separately. Ideally you need root for that. If you are not rooted you need to find the sqlite3 executable and place it into the Tasker directory. There was a discussion here in the forum how to do it somewhere. Also, you probably need to specify the absolute path to the database. If sqlite3 is present you might need to specify its path as well.

Hope that helps,

[Nick77]

thanks for your help.

at least now i know why it doesn't work on my phone