rasqlinsert password

[Matt Brown]

That's interesting.


Instead, you can try using the ra "run commands" file:

echo "RA_DB_PASS=\"SQLPASSWORD\"" >> $HOME/.rarc

You can set several values in .rarc

http://qosient.com/argus/man/man5/rarc.5.pdf


On Wed, Oct 17, 2012 at 12:05 AM, Paul Schmehl <pschmehl_lists at tx.rr.com>wrote:

> I did.  It has this:
>
> rasqlinsert -m none -r file -w mysql://user@localhost/db/**table
>
> There's no password in there.
>
> After trying some things I got info on the console that seemed helpful.
>
> dbUrl:       mysql://[user[:pass]@]host[:**port]/db/table
>
> So I tried this:
>
> rasqlinsert -Z b -F rasqlinsert.conf -r /path/to/argus/files/2012-10-**
> 15/argus.log.2012-10-15.16\:00\:00.bz2 -w mysql://user:pass@buttercup4.**
> utdallas.edu/databasename/**tablename<http://user:pass@buttercup4.utdallas.edu/databasename/tablename>
>
> And got this:
> rasqlinsert[2674]: 2012-10-16 15:59:44 mysql_connect error Unknown MySQL
> server host 'pass at buttercup4.utdallas.edu' (0)
>
> Do I need to enclose user and pass in quotes?  escape the @?
>
> I'm running 3.0.4.1 on FreeBSD.
>
>
> --On October 16, 2012 11:52:58 PM +0800 Matt Brown <matthewbrown at gmail.com>
> wrote:
>
>  Check out the invocation section of the man page:
>>
>>
>> http://qosient.com/argus/man/**man1/rasqlinsert.1.pdf<http://qosient.com/argus/man/man1/rasqlinsert.1.pdf>
>>
>>
>>
>> On Tue, Oct 16, 2012 at 11:35 PM, Paul Schmehl <pschmehl_lists at tx.rr.com>
>> wrote:
>>
>> There doesn't appear to be any provision for entering a password when
>> using rasqlinsert.  Am I reading the man page wrong?  Is rasqlinsert
>> designed to not use a password?
>>
>
>
>
> --
> Paul Schmehl, Senior Infosec Analyst
> As if it wasn't already obvious, my opinions
> are my own and not those of my employer.
> *********************************************
> "It is as useless to argue with those who have
> renounced the use of reason as to administer
> medication to the dead." Thomas Jefferson
> "There are some ideas so wrong that only a very
> intelligent person could believe in them." George Orwell
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20121017/57664560/attachment.html>