[Met_help] [rt.rap.ucar.edu #91312] History for Batch plotting on AWS

[Tatiana Burek via RT]

----------------------------------------------------------------
  Initial Request
----------------------------------------------------------------

Hi,

I'm trying to test out batch plotting on AWS (via WCOSS), and I'm getting
some weird errors before the plotting script fails.

One of them says: 2019-07-30
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown Source)
-1 initDBList - Access denied for user 'logan.dawson'@'205.156.8.85' (using
password: NO)

Then, it tries creating the plot before a second error says: "Database
mv_ylin_pcp is invalid"

I thought I might be running into an authentication/access problem, but the
simple ssh test (ssh logan.dawson at 205.156.8.85 'ls -al') works, and I'm
able to list out the available databases (using
/gpfs/hps3/emc/global/noscrub/Mallory.Row/VRFY/METviewer_AWS/mv_db_size_on_aws.sh
 logan.dawson)


Here's the full run command I'm using:
/gpfs/hps3/emc/global/noscrub/Mallory.Row/VRFY/METviewer_AWS/mv_batch_on_aws.sh
logan.dawson /meso/save/Logan.Dawson/CAM_verif
/meso/save/Logan.Dawson/CAM_verif/test.xml

My XML script, the output, and the mv_batch script are all attached for
reference.

Thanks,
Logan


-- 
*Logan C. Dawson, Ph.D.*
Support Scientist, I.M. Systems Group, Inc.
NOAA/NWS/NCEP/EMC
5830 University Research Court
College Park, MD 20740
(301) 683-3944


----------------------------------------------------------------
  Complete Ticket History
----------------------------------------------------------------

Subject: Batch plotting on AWS
From: Tatiana Burek
Time: Tue Jul 30 14:51:07 2019

Logan,
I found 2 problems:
1. There is no database user with your name registered in the AWS DB.
It means that you can't create databases. I will request the account
for you.

2. We are still adjusting users permissions and databases ownership on
AWS. Till now the assumption was that only the user who created a
database can use and delete it. But at the same time all users can use
any database using UI to create plots. So it seems reasonable to let
all users to use all databases with the batch mode. I made the changes
for that and your script should work now.

Tatiana



On Tue Jul 30 11:36:17 2019, logan.dawson at noaa.gov wrote:
> Hi,
>
> I'm trying to test out batch plotting on AWS (via WCOSS), and I'm
> getting
> some weird errors before the plotting script fails.
>
> One of them says: 2019-07-30
> edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
> Source)
> -1 initDBList - Access denied for user 'logan.dawson'@'205.156.8.85'
> (using
> password: NO)
>
> Then, it tries creating the plot before a second error says:
"Database
> mv_ylin_pcp is invalid"
>
> I thought I might be running into an authentication/access problem,
> but the
> simple ssh test (ssh logan.dawson at 205.156.8.85 'ls -al') works, and
> I'm
> able to list out the available databases (using
>
/gpfs/hps3/emc/global/noscrub/Mallory.Row/VRFY/METviewer_AWS/mv_db_size_on_aws.sh
>  logan.dawson)
>
>
> Here's the full run command I'm using:
>
/gpfs/hps3/emc/global/noscrub/Mallory.Row/VRFY/METviewer_AWS/mv_batch_on_aws.sh
> logan.dawson /meso/save/Logan.Dawson/CAM_verif
> /meso/save/Logan.Dawson/CAM_verif/test.xml
>
> My XML script, the output, and the mv_batch script are all attached
> for
> reference.
>
> Thanks,
> Logan



------------------------------------------------