The command posted in your mail needs to be in one line. Apparently, you have a line feed character in the script which causes the mysql command to fail.
Martin Von meinem iPhone gesendet Am 11.04.2011 um 20:48 schrieb "Gilbert T. Gutierrez, Jr." <mailing-li...@phoenixinternet.net>: > I was looking at the script in the qmailtoaster wiki for Automatic account > expirations. The script is not working for me and I am not all that great > with bash scripts. Has anyone run this script on the list? When I modify > the script with my server info and run the script, it logs me into mysql and > then stops. when I press ctrl-c I get the following notice. > > mysql> Aborted > ./autodelete.sh: line 128: syntax error near unexpected token `newline' > ./autodelete.sh: line 128: `$MYSQL_DATABASE -E -e "$SQL_QUERY" | $GREP email > | $GAWK -F' ' '{print $2}' >' > > > Can someone help me please or push me an alternative direction? > > Thank you, > Gilbert Gutierrez > > > > --------------------------------------------------------------------------------- > Qmailtoaster is sponsored by Vickers Consulting Group > (www.vickersconsulting.com) > Vickers Consulting Group offers Qmailtoaster support and installations. > If you need professional help with your setup, contact them today! > --------------------------------------------------------------------------------- > Please visit qmailtoaster.com for the latest news, updates, and packages. > To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com > For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com > > --------------------------------------------------------------------------------- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! --------------------------------------------------------------------------------- Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com