OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Table names with periods

From: Chance Ellis (chance.ellisgmail.com)
Date: Tue Oct 04 2005 - 09:09:04 CDT

Thanks everyone for all of the replies! I have been banging my head against
this for a week now and I was never looking in the direction of the cron
script... Sometimes it helps having another set (or ten) of eyes looking at
the problem.
 Thanks again!

 On 10/3/05, Bastian Balthazar Bux <BastianBalthazarBuxpnpitalia.it> wrote:
>
> Chance Ellis wrote:
> [snip]
> > of CREATE TABLE entries. I then import those files with a cron script
> into
> > mysql. This is where I am looking to convert IP address into something
> [snip]
>
> There is a world of possibilities at this point, one is this:
>
> sed \
>
> --expression='s/NEEDTOREPLACETHIS\([0123456789]\).\([0123456789]\)\.\([0123456789]\)\.\([0123456789]\)*NEEDTOREPLACETHIS/\1_\2_\3_\4/'
> \
> SAVEDFILENAME \
> | mysql -ublabla -psecret dbname
>
>
>
> You can do quite everyting from a cron script, also create sql query
> from normal syslog logs.
>
>