Shell Programming and Scripting

Hello,

I could use a little help with the command line part of this. I've got it to sorta work if I use this

Code:

`gawk -F"/"'{ print $3 }'`

I've also tried

Code:

`pwd|cut -d/ -f3`

with no luck. Is this possible to do? I'm basically doing this to copy the users domain, then paste that into the command.

I could not get

Code:

`/scripts/whoowns (pastes in domain with ahk)`

to print the username as part of the username_% either.


What the full command is currently:

Code:

for i in `mysqlshow `/scripts/whoowns (pastes in domain with ahk)`_%|sed '1,4d'|sed '$d'|awk '{ print $2 }'` ; do mysqlcheck -rf $i; done

first - please confirm you are sanitizing the user input.

second - you may want to create a production level script with error checking, logging etc .. rather then a one liner.

can you provide sample input and expected output?

My apologies on not being familiar with security practices as far as sanitizing the input, this would just be run as root and something I'd run on a server with multiple users.

When working it goes..

$ for i in `mysqlshow user_%|sed '1,4d'|sed '$d'|awk '{ print $2 }'` ; do mysqlcheck -rf $i; done
user_jmla1.jos_banner OK
user_jmla1.jos_bannerclient OK
user_jmla1.jos_bannertrack OK

and so on.

A script would be nice, then it could be run on any production server like domain/script|bash though for now this would just be a nice simple one liner.

i strongly suggest you become familar. running scripts from root from user supplied data without sanitizing data is a huge security risk. besides that shouldnt these commands really be run from the mysql user account?

I am still not sure what your asking for. you posted an example run but what variables are you feeding it.

Variables?

mysqlshow user_%|sed '1,4d'|sed '$d'|awk '{ print $2 }'
prints out for example:

user_jmla1
user_wp1
user_zen1

going through a for loop to run mysqlcheck -rf.

for i in `that DB printout`; do mysqlcheck -rf $i; done

I'm just wondering if there is a way I can get the username within that. rather than having to type it out.

mysqlshow `(something to print the username that works)`_%|sed '1,4d'|sed '$d'|awk '{ print $2 }'

Does this work for you?

Code:

mysqlshow user_%|awk -F_ '{print $2}'