Argh... damn wrapping!
Obviously, the following should be on one line:
mysql -uroot -p$PASS -e"insert into whitelist_dnsname
values('$1','#auto-entered via script',1293857999);" policyd;
:-)
E.
> A simple script like so would work within shell:
>
> =-=-=-=-=-=-=-=-=-=
> #!/bin/bash
>
> if [ ! $1 ]; then
> echo "usage: $0 <subdomain.domain.tld>";
> exit;
> fi
>
> printf "Enter the MySQL password to proceed: ";
>
> stty -echo;
> read PASS;
> stty echo;
>
> mysql -uroot -p$PASS -e"insert into whitelist_dnsname
> values('$1','#auto-entered via script',1293857999);" policyd;
>
> echo "";
> echo "";
> echo "Added $1 to whitelist_dnsname within policyd database.";
> echo "";
>
> exit;
>
> =-=-=-=-=-=-=-=-=-=
>
>
> The epoch I used expires the whitelist entry on Dec 31st, 2010, at
> 23:59:59. For security purposes, you have to enter in the SQL password
> each time, especially since you're doing this as root.
>
> Modifying this to suit your needs should be fairly easy; just change the
> SQL query. Even further, it shouldn't be too hard to add the ability to
> have different options so only one script is necessary (like your
> suggestion of "policyd-add --dnswhitelist") rather than multiple scripts
> (like "policyd-add-whitelist", "policyd-add-whitelist_dnsname", etc).
>
> Hope this helps.
>
> E.
>
>
>> Hello,
>> Has anyone taken the time to write a few quick scripts to insert and
>> remove records from
>> the database?
>>
>> Something along the lines of:
>> policyd-add --dnswhitelist dns.name.com
>>
>> --
>> Douglas F. Calvert -/- [EMAIL PROTECTED]
>> 0xC9541FB2 / 0817 30D4 82B6 BB8D 5E66 06F6 B796 073D C954 1FB2
>> Do not email => [EMAIL PROTECTED] <= It would be a bad idea(tm).
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> policyd-users mailing list
>> policyd-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/policyd-users
>>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> policyd-users mailing list
> policyd-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/policyd-users
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
policyd-users mailing list
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users
