[ARGUS] how to specify password for rasqlinsert ?

[Carter Bullard]

Hey Russell,
Are you getting this error message ??

% rasqlinsert -Xw mysql://carter:password@localhost/test/table_2019_07_09 <mysql://carter:password@localhost/test/table_2019_07_09>
rasqlinsert[108003]: 10:42:26.420175 mysql_connect error Access denied for user 'carter'@'localhost' (using password: YES)

I tested this quite a bit and it works for me to pass the password like above.  We grab everything between the ‘:’ and the ‘@‘ and present that as the password to mysql_connect().   If your password has characters that the shell may not like, I  think that quoting them, escaping, whatever, shouldl help, but if you put the quotes around just the password, they will be included in the text we present as the password.

You can set the password in your .rarc file using the RA_DB_PASS variable, something like:
   RA_DATABASE=“test”
   RA_DB_USER=“carter”
   RA_DB_PASS=“password”

You maybe running into other permission problems, since you’re using rasqlinsert().  The user will need create permissions for databases and tables, which maybe another problem.

Carter

> On Jul 22, 2019, at 12:07 AM, Russell Fulton <r.fulton at auckland.ac.nz> wrote:
> 
> I am looking at producing hourly tables of flow summaries using rasqlinsert but I can’t figure out how to give the mysql password.
> 
> I tried the standard mysql://user:pass@localhost/…. I put the whole string in single quotes to protect the special characters - I also tried escaping the specials.
> 
> Creds work fine in the mysql -u …. -p
> 
> 
> Russell
> _______________________________________________
> argus mailing list
> argus at qosient.com
> https://pairlist1.pair.net/mailman/listinfo/argus

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20190722/01264b86/attachment.html>