rasqlinsert password

[Paul Schmehl]

Never mind.  Discovered you can't use the @ in passwords.  It fools 
rasqlinsert into thinking everything after it is hostname.

--On October 16, 2012 11:05:30 AM -0500 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
>
> 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
>>
>>
>>
>> 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