interActive to offline shellScript

reza_zah1991 · 07-07-2013, 05:45 AM

hi folks
i'm write these line in a file with name "qlite.sql"

Code:

create table tb1(name varchar(20),family varchar(20),age integer);
insert into tb1 values("reza","aghazade",22);
insert into tb1 values("amin","aghajani",20);
.mode column
.separator :
.header on
select * from tb1;

& do interActive shellScript in offline Script

Code:

sqlite3 myDB < sqlite.sqlcat

i want to use this bellow code like above,,but it didn't work

Code:

passwd=123098
su root <<EOF
>$passwd
EOF

but it did't work
can enbody know about that?
how to do that?

konsolebox · 07-07-2013, 06:02 AM

You're reading the wrong input file on your second command and you're just opening a new session for root and not actually executing any sqlite3 command.

I think there are basic points you don't read yet so I suggest you read the bash manual (man bash) and some basic scripting tutorials online like Bash Guide for Beginners.

Try to read some docs about sqlite3 and su as well.

reza_zah1991 · 07-07-2013, 09:06 AM

i know below code must create a new session
but after do that,,current user is not root

Code:

passwd=123098
su root <<EOF
>$passwd
EOF

---------- Post added 07-07-13 at 03:07 PM ----------

i know below code must create a new session
but after do that,,current user is not root

Code:

passwd=123098
su root <<EOF
>$passwd
EOF

IDON'T KNOW WHY?

jpollard · 07-07-2013, 10:43 AM

Quote:

Originally Posted by reza_zah1991

i know below code must create a new session
but after do that,,current user is not root

Code:

passwd=123098
su root <<EOF
>$passwd
EOF

---------- Post added 07-07-13 at 03:07 PM ----------

i know below code must create a new session
but after do that,,current user is not root

Code:

passwd=123098
su root <<EOF
>$passwd
EOF

IDON'T KNOW WHY?

Because stdin is not suitable for passwords - su/sudo requires a secure channel for its password so it opens /dev/tty for use with prompts and password input.

Putting a password in a script is bad security... and putting roots password in a file really really bad.

There are utilities around to do this - that was what the "expect" utility does. But misuse of it will/can expose your passwords.