rasqlinsert password

[John Kennedy]

You need to escape the "@" symbol in the password.

John

On Tue, Oct 16, 2012 at 10:24 AM, Paul Schmehl <pschmehl_lists at tx.rr.com>wrote:

> 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<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/20121016/875acb6e/attachment.html>