[Met_help] [rt.rap.ucar.edu #95539] History for AWS METviewer pruning still not working
Tatiana Burek via RT
met_help at ucar.edu
Tue Oct 13 12:10:08 MDT 2020
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hi Tatiana,
I'm now attempting to prune data from some of my METviewer databases, and
I'm still getting the same errors that I brought up during last week's
METplus telecon:
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
It seems like there's an authentication issue, maybe preventing me from
pruning data from databases that I own?
Caused by: java.sql.SQLException: Access denied for user
'logan.dawson'@'205.156.8.85'
(using password: NO)
I need to prune a subset of data from about 7 different databases that I
own. Do you need me to give you a list of those databases so you can modify
the permissions on them?
Thanks,
Logan
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Tatiana Burek
Time: Mon Jun 08 12:51:32 2020
Hi Logan,
Could you send me your XML and the command line you use.
Thanks,
Tatiana
On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> Hi Tatiana,
>
> I'm now attempting to prune data from some of my METviewer
databases, and
> I'm still getting the same errors that I brought up during last
week's
> METplus telecon:
> https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
>
> It seems like there's an authentication issue, maybe preventing me
from
> pruning data from databases that I own?
>
> Caused by: java.sql.SQLException: Access denied for user
> 'logan.dawson'@'205.156.8.85'
> (using password: NO)
>
> I need to prune a subset of data from about 7 different databases
that I
> own. Do you need me to give you a list of those databases so you can
modify
> the permissions on them?
>
> Thanks,
> Logan
>
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Mon Jun 08 13:08:04 2020
Hi Tatiana,
I've attached the XML and bash script I'm attempting to run. The
command
I'm trying is:
./mv_prune_on_aws.sh logan.dawson prune.xml
Thanks,
Logan
On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Hi Logan,
>
> Could you send me your XML and the command line you use.
>
> Thanks,
> Tatiana
> On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > Hi Tatiana,
> >
> > I'm now attempting to prune data from some of my METviewer
databases, and
> > I'm still getting the same errors that I brought up during last
week's
> > METplus telecon:
> >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> >
> > It seems like there's an authentication issue, maybe preventing me
from
> > pruning data from databases that I own?
> >
> > Caused by: java.sql.SQLException: Access denied for user
> > 'logan.dawson'@'205.156.8.85'
> > (using password: NO)
> >
> > I need to prune a subset of data from about 7 different databases
that I
> > own. Do you need me to give you a list of those databases so you
can
> modify
> > the permissions on them?
> >
> > Thanks,
> > Logan
> >
>
>
>
>
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Tatiana Burek
Time: Mon Jun 08 13:35:48 2020
Logan,
Instead of using the server name in <host> tag try to use
rds_host:3306
<host>rds_host:3306</host>
And I checked - you own 'mv_hrefv3_eval_radar_metplus' database so I
don't need to change the privileges.
Tatiana
On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> Hi Tatiana,
>
> I've attached the XML and bash script I'm attempting to run. The
> command
> I'm trying is:
>
> ./mv_prune_on_aws.sh logan.dawson prune.xml
>
> Thanks,
> Logan
>
> On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Hi Logan,
> >
> > Could you send me your XML and the command line you use.
> >
> > Thanks,
> > Tatiana
> > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > > Hi Tatiana,
> > >
> > > I'm now attempting to prune data from some of my METviewer
> > > databases, and
> > > I'm still getting the same errors that I brought up during last
> > > week's
> > > METplus telecon:
> > >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > >
> > > It seems like there's an authentication issue, maybe preventing
me
> > > from
> > > pruning data from databases that I own?
> > >
> > > Caused by: java.sql.SQLException: Access denied for user
> > > 'logan.dawson'@'205.156.8.85'
> > > (using password: NO)
> > >
> > > I need to prune a subset of data from about 7 different
databases
> > > that I
> > > own. Do you need me to give you a list of those databases so you
> > > can
> > modify
> > > the permissions on them?
> > >
> > > Thanks,
> > > Logan
> > >
> >
> >
> >
> >
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Mon Jun 08 13:48:04 2020
Unfortunately, I'm getting the same behavior with rds_host:3306
instead of
the full server name.
-Logan
On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Logan,
>
> Instead of using the server name in <host> tag try to use
rds_host:3306
> <host>rds_host:3306</host>
>
> And I checked - you own 'mv_hrefv3_eval_radar_metplus' database so I
don't
> need to change the privileges.
>
> Tatiana
>
> On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > Hi Tatiana,
> >
> > I've attached the XML and bash script I'm attempting to run. The
> > command
> > I'm trying is:
> >
> > ./mv_prune_on_aws.sh logan.dawson prune.xml
> >
> > Thanks,
> > Logan
> >
> > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > > Hi Logan,
> > >
> > > Could you send me your XML and the command line you use.
> > >
> > > Thanks,
> > > Tatiana
> > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > > > Hi Tatiana,
> > > >
> > > > I'm now attempting to prune data from some of my METviewer
> > > > databases, and
> > > > I'm still getting the same errors that I brought up during
last
> > > > week's
> > > > METplus telecon:
> > > >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > >
> > > > It seems like there's an authentication issue, maybe
preventing me
> > > > from
> > > > pruning data from databases that I own?
> > > >
> > > > Caused by: java.sql.SQLException: Access denied for user
> > > > 'logan.dawson'@'205.156.8.85'
> > > > (using password: NO)
> > > >
> > > > I need to prune a subset of data from about 7 different
databases
> > > > that I
> > > > own. Do you need me to give you a list of those databases so
you
> > > > can
> > > modify
> > > > the permissions on them?
> > > >
> > > > Thanks,
> > > > Logan
> > > >
> > >
> > >
> > >
> > >
>
>
>
>
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Tatiana Burek
Time: Mon Jun 08 14:01:41 2020
Logan,
I added a few diagnostic messages to the script on AWS.
Could you run your command again, pleas.
Tatiana
On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> Unfortunately, I'm getting the same behavior with rds_host:3306
instead of
> the full server name.
>
> -Logan
>
> On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
<met_help at ucar.edu>
> wrote:
>
> > Logan,
> >
> > Instead of using the server name in <host> tag try to use
rds_host:3306
> > <host>rds_host:3306</host>
> >
> > And I checked - you own 'mv_hrefv3_eval_radar_metplus' database so
I don't
> > need to change the privileges.
> >
> > Tatiana
> >
> > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > > Hi Tatiana,
> > >
> > > I've attached the XML and bash script I'm attempting to run. The
> > > command
> > > I'm trying is:
> > >
> > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > >
> > > Thanks,
> > > Logan
> > >
> > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > > > Hi Logan,
> > > >
> > > > Could you send me your XML and the command line you use.
> > > >
> > > > Thanks,
> > > > Tatiana
> > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > > > > Hi Tatiana,
> > > > >
> > > > > I'm now attempting to prune data from some of my METviewer
> > > > > databases, and
> > > > > I'm still getting the same errors that I brought up during
last
> > > > > week's
> > > > > METplus telecon:
> > > > >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > >
> > > > > It seems like there's an authentication issue, maybe
preventing me
> > > > > from
> > > > > pruning data from databases that I own?
> > > > >
> > > > > Caused by: java.sql.SQLException: Access denied for user
> > > > > 'logan.dawson'@'205.156.8.85'
> > > > > (using password: NO)
> > > > >
> > > > > I need to prune a subset of data from about 7 different
databases
> > > > > that I
> > > > > own. Do you need me to give you a list of those databases so
you
> > > > > can
> > > > modify
> > > > > the permissions on them?
> > > > >
> > > > > Thanks,
> > > > > Logan
> > > > >
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> >
>
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Mon Jun 08 14:12:00 2020
Hi Tatiana,
Here's the updated output from my latest attempt (attached).
-Logan
On Mon, Jun 8, 2020 at 4:01 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Logan,
> I added a few diagnostic messages to the script on AWS.
> Could you run your command again, pleas.
>
> Tatiana
>
> On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> > Unfortunately, I'm getting the same behavior with rds_host:3306
instead
> of
> > the full server name.
> >
> > -Logan
> >
> > On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
<met_help at ucar.edu>
> > wrote:
> >
> > > Logan,
> > >
> > > Instead of using the server name in <host> tag try to use
rds_host:3306
> > > <host>rds_host:3306</host>
> > >
> > > And I checked - you own 'mv_hrefv3_eval_radar_metplus' database
so I
> don't
> > > need to change the privileges.
> > >
> > > Tatiana
> > >
> > > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > > > Hi Tatiana,
> > > >
> > > > I've attached the XML and bash script I'm attempting to run.
The
> > > > command
> > > > I'm trying is:
> > > >
> > > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > > >
> > > > Thanks,
> > > > Logan
> > > >
> > > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > > <met_help at ucar.edu>
> > > > wrote:
> > > >
> > > > > Hi Logan,
> > > > >
> > > > > Could you send me your XML and the command line you use.
> > > > >
> > > > > Thanks,
> > > > > Tatiana
> > > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > > > > > Hi Tatiana,
> > > > > >
> > > > > > I'm now attempting to prune data from some of my METviewer
> > > > > > databases, and
> > > > > > I'm still getting the same errors that I brought up during
last
> > > > > > week's
> > > > > > METplus telecon:
> > > > > >
> https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > > >
> > > > > > It seems like there's an authentication issue, maybe
preventing
> me
> > > > > > from
> > > > > > pruning data from databases that I own?
> > > > > >
> > > > > > Caused by: java.sql.SQLException: Access denied for user
> > > > > > 'logan.dawson'@'205.156.8.85'
> > > > > > (using password: NO)
> > > > > >
> > > > > > I need to prune a subset of data from about 7 different
databases
> > > > > > that I
> > > > > > own. Do you need me to give you a list of those databases
so you
> > > > > > can
> > > > > modify
> > > > > > the permissions on them?
> > > > > >
> > > > > > Thanks,
> > > > > > Logan
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Mon Jun 08 14:12:00 2020
CALLING: scp prune.xml logan.dawson at 205.156.8.85:~
Jun 08, 2020 8:09:23 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLException: Communications link failure with primary. No
active connection found for master.
at
org.mariadb.jdbc.internal.failover.AbstractMastersListener.throwFailoverMessage(AbstractMastersListener.java:538)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.checkInitialConnection(MastersSlavesListener.java:336)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.initializeConnection(MastersSlavesListener.java:173)
at
org.mariadb.jdbc.internal.failover.FailoverProxy.<init>(FailoverProxy.java:116)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:542)
at
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
at org.mariadb.jdbc.Driver.connect(Driver.java:92)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:715)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:647)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:466)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:141)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
Source)
at edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.<init>(Unknown
Source)
at edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.<init>(Unknown
Source)
at
edu.ucar.metviewer.db.aurora.AuroraAppDatabaseManager.<init>(Unknown
Source)
at edu.ucar.metviewer.prune.MVPruneDB.main(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user
'logan.dawson'@'205.156.8.85' (using password: NO)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:412)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:369)
at
org.mariadb.jdbc.internal.protocol.AuroraProtocol.loop(AuroraProtocol.java:167)
at
org.mariadb.jdbc.internal.failover.impl.AuroraListener.reconnectFailedConnection(AuroraListener.java:210)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.initializeConnection(MastersSlavesListener.java:170)
... 18 more
2020-06-08
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
Source) -1 initDBList - Communications link failure with primary. No
active connection found for master.
Jun 08, 2020 8:09:38 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLException: Communications link failure with primary. No
active connection found for master.
at
org.mariadb.jdbc.internal.failover.AbstractMastersListener.throwFailoverMessage(AbstractMastersListener.java:538)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.checkInitialConnection(MastersSlavesListener.java:336)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.initializeConnection(MastersSlavesListener.java:173)
at
org.mariadb.jdbc.internal.failover.FailoverProxy.<init>(FailoverProxy.java:116)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:542)
at
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
at org.mariadb.jdbc.Driver.connect(Driver.java:92)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:715)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:647)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:466)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:141)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
at
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
Source)
at edu.ucar.metviewer.prune.PruneDbManagerMysql.pruneData(Unknown
Source)
at edu.ucar.metviewer.prune.MVPruneDB.main(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user
'logan.dawson'@'205.156.8.85' (using password: NO)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:412)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:369)
at
org.mariadb.jdbc.internal.protocol.AuroraProtocol.loop(AuroraProtocol.java:167)
at
org.mariadb.jdbc.internal.failover.impl.AuroraListener.reconnectFailedConnection(AuroraListener.java:210)
at
org.mariadb.jdbc.internal.failover.impl.MastersSlavesListener.initializeConnection(MastersSlavesListener.java:170)
... 16 more
2020-06-08
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
Source) -1 getConnection - can't get connection for database
mv_hrefv3_eval_radar_metplus Communications link failure with primary.
No active connection found for master.
Exception in thread "main" java.lang.NullPointerException
at edu.ucar.metviewer.prune.PruneDbManagerMysql.getAllTables(Unknown
Source)
at edu.ucar.metviewer.prune.PruneDbManagerMysql.pruneData(Unknown
Source)
at edu.ucar.metviewer.prune.MVPruneDB.main(Unknown Source)
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Tatiana Burek
Time: Mon Jun 08 14:57:36 2020
Logan,
Could you execute following command from the same server where you run
METviewer pruning:
ssh logan.dawson at 205.156.8.85 'cat /opt/metviewer/bin/.test | openssl
enc -aes-128-cbc -a -d -salt -pass pass:test'
You should get 'test_pass' as a result.
Tatiana
On Mon Jun 08 14:12:00 2020, logan.dawson at noaa.gov wrote:
> Hi Tatiana,
>
> Here's the updated output from my latest attempt (attached).
>
> -Logan
>
> On Mon, Jun 8, 2020 at 4:01 PM Tatiana Burek via RT
> <met_help at ucar.edu>
> wrote:
>
> > Logan,
> > I added a few diagnostic messages to the script on AWS.
> > Could you run your command again, pleas.
> >
> > Tatiana
> >
> > On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> > > Unfortunately, I'm getting the same behavior with rds_host:3306
> > > instead
> > of
> > > the full server name.
> > >
> > > -Logan
> > >
> > > On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > > > Logan,
> > > >
> > > > Instead of using the server name in <host> tag try to use
> > > > rds_host:3306
> > > > <host>rds_host:3306</host>
> > > >
> > > > And I checked - you own 'mv_hrefv3_eval_radar_metplus'
database
> > > > so I
> > don't
> > > > need to change the privileges.
> > > >
> > > > Tatiana
> > > >
> > > > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > > > > Hi Tatiana,
> > > > >
> > > > > I've attached the XML and bash script I'm attempting to run.
> > > > > The
> > > > > command
> > > > > I'm trying is:
> > > > >
> > > > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > > > >
> > > > > Thanks,
> > > > > Logan
> > > > >
> > > > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > > > <met_help at ucar.edu>
> > > > > wrote:
> > > > >
> > > > > > Hi Logan,
> > > > > >
> > > > > > Could you send me your XML and the command line you use.
> > > > > >
> > > > > > Thanks,
> > > > > > Tatiana
> > > > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov wrote:
> > > > > > > Hi Tatiana,
> > > > > > >
> > > > > > > I'm now attempting to prune data from some of my
METviewer
> > > > > > > databases, and
> > > > > > > I'm still getting the same errors that I brought up
during
> > > > > > > last
> > > > > > > week's
> > > > > > > METplus telecon:
> > > > > > >
> >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > > > >
> > > > > > > It seems like there's an authentication issue, maybe
> > > > > > > preventing
> > me
> > > > > > > from
> > > > > > > pruning data from databases that I own?
> > > > > > >
> > > > > > > Caused by: java.sql.SQLException: Access denied for user
> > > > > > > 'logan.dawson'@'205.156.8.85'
> > > > > > > (using password: NO)
> > > > > > >
> > > > > > > I need to prune a subset of data from about 7 different
> > > > > > > databases
> > > > > > > that I
> > > > > > > own. Do you need me to give you a list of those
databases
> > > > > > > so you
> > > > > > > can
> > > > > > modify
> > > > > > > the permissions on them?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Logan
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Mon Jun 08 15:00:27 2020
I do get 'test_pass' as a result of running that command.
-Logan
On Mon, Jun 8, 2020 at 4:57 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Logan,
> Could you execute following command from the same server where you
run
> METviewer pruning:
> ssh logan.dawson at 205.156.8.85 'cat /opt/metviewer/bin/.test |
openssl enc
> -aes-128-cbc -a -d -salt -pass pass:test'
>
> You should get 'test_pass' as a result.
>
> Tatiana
>
> On Mon Jun 08 14:12:00 2020, logan.dawson at noaa.gov wrote:
> > Hi Tatiana,
> >
> > Here's the updated output from my latest attempt (attached).
> >
> > -Logan
> >
> > On Mon, Jun 8, 2020 at 4:01 PM Tatiana Burek via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > > Logan,
> > > I added a few diagnostic messages to the script on AWS.
> > > Could you run your command again, pleas.
> > >
> > > Tatiana
> > >
> > > On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> > > > Unfortunately, I'm getting the same behavior with
rds_host:3306
> > > > instead
> > > of
> > > > the full server name.
> > > >
> > > > -Logan
> > > >
> > > > On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
> > > > <met_help at ucar.edu>
> > > > wrote:
> > > >
> > > > > Logan,
> > > > >
> > > > > Instead of using the server name in <host> tag try to use
> > > > > rds_host:3306
> > > > > <host>rds_host:3306</host>
> > > > >
> > > > > And I checked - you own 'mv_hrefv3_eval_radar_metplus'
database
> > > > > so I
> > > don't
> > > > > need to change the privileges.
> > > > >
> > > > > Tatiana
> > > > >
> > > > > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > > > > > Hi Tatiana,
> > > > > >
> > > > > > I've attached the XML and bash script I'm attempting to
run.
> > > > > > The
> > > > > > command
> > > > > > I'm trying is:
> > > > > >
> > > > > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > > > > >
> > > > > > Thanks,
> > > > > > Logan
> > > > > >
> > > > > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > > > > <met_help at ucar.edu>
> > > > > > wrote:
> > > > > >
> > > > > > > Hi Logan,
> > > > > > >
> > > > > > > Could you send me your XML and the command line you use.
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Tatiana
> > > > > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov
wrote:
> > > > > > > > Hi Tatiana,
> > > > > > > >
> > > > > > > > I'm now attempting to prune data from some of my
METviewer
> > > > > > > > databases, and
> > > > > > > > I'm still getting the same errors that I brought up
during
> > > > > > > > last
> > > > > > > > week's
> > > > > > > > METplus telecon:
> > > > > > > >
> > >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > > > > >
> > > > > > > > It seems like there's an authentication issue, maybe
> > > > > > > > preventing
> > > me
> > > > > > > > from
> > > > > > > > pruning data from databases that I own?
> > > > > > > >
> > > > > > > > Caused by: java.sql.SQLException: Access denied for
user
> > > > > > > > 'logan.dawson'@'205.156.8.85'
> > > > > > > > (using password: NO)
> > > > > > > >
> > > > > > > > I need to prune a subset of data from about 7
different
> > > > > > > > databases
> > > > > > > > that I
> > > > > > > > own. Do you need me to give you a list of those
databases
> > > > > > > > so you
> > > > > > > > can
> > > > > > > modify
> > > > > > > > the permissions on them?
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Logan
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
>
>
>
>
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Tatiana Burek
Time: Tue Jun 09 07:29:00 2020
Logan,
Could you try running the pruning script again. Hopefully, it will
work this time.
Tatiana
On Mon Jun 08 15:00:27 2020, logan.dawson at noaa.gov wrote:
> I do get 'test_pass' as a result of running that command.
>
> -Logan
>
> On Mon, Jun 8, 2020 at 4:57 PM Tatiana Burek via RT
<met_help at ucar.edu>
> wrote:
>
> > Logan,
> > Could you execute following command from the same server where you
run
> > METviewer pruning:
> > ssh logan.dawson at 205.156.8.85 'cat /opt/metviewer/bin/.test |
openssl enc
> > -aes-128-cbc -a -d -salt -pass pass:test'
> >
> > You should get 'test_pass' as a result.
> >
> > Tatiana
> >
> > On Mon Jun 08 14:12:00 2020, logan.dawson at noaa.gov wrote:
> > > Hi Tatiana,
> > >
> > > Here's the updated output from my latest attempt (attached).
> > >
> > > -Logan
> > >
> > > On Mon, Jun 8, 2020 at 4:01 PM Tatiana Burek via RT
> > > <met_help at ucar.edu>
> > > wrote:
> > >
> > > > Logan,
> > > > I added a few diagnostic messages to the script on AWS.
> > > > Could you run your command again, pleas.
> > > >
> > > > Tatiana
> > > >
> > > > On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> > > > > Unfortunately, I'm getting the same behavior with
rds_host:3306
> > > > > instead
> > > > of
> > > > > the full server name.
> > > > >
> > > > > -Logan
> > > > >
> > > > > On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
> > > > > <met_help at ucar.edu>
> > > > > wrote:
> > > > >
> > > > > > Logan,
> > > > > >
> > > > > > Instead of using the server name in <host> tag try to use
> > > > > > rds_host:3306
> > > > > > <host>rds_host:3306</host>
> > > > > >
> > > > > > And I checked - you own 'mv_hrefv3_eval_radar_metplus'
database
> > > > > > so I
> > > > don't
> > > > > > need to change the privileges.
> > > > > >
> > > > > > Tatiana
> > > > > >
> > > > > > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov wrote:
> > > > > > > Hi Tatiana,
> > > > > > >
> > > > > > > I've attached the XML and bash script I'm attempting to
run.
> > > > > > > The
> > > > > > > command
> > > > > > > I'm trying is:
> > > > > > >
> > > > > > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Logan
> > > > > > >
> > > > > > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > > > > > <met_help at ucar.edu>
> > > > > > > wrote:
> > > > > > >
> > > > > > > > Hi Logan,
> > > > > > > >
> > > > > > > > Could you send me your XML and the command line you
use.
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Tatiana
> > > > > > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov
wrote:
> > > > > > > > > Hi Tatiana,
> > > > > > > > >
> > > > > > > > > I'm now attempting to prune data from some of my
METviewer
> > > > > > > > > databases, and
> > > > > > > > > I'm still getting the same errors that I brought up
during
> > > > > > > > > last
> > > > > > > > > week's
> > > > > > > > > METplus telecon:
> > > > > > > > >
> > > >
https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > > > > > >
> > > > > > > > > It seems like there's an authentication issue, maybe
> > > > > > > > > preventing
> > > > me
> > > > > > > > > from
> > > > > > > > > pruning data from databases that I own?
> > > > > > > > >
> > > > > > > > > Caused by: java.sql.SQLException: Access denied for
user
> > > > > > > > > 'logan.dawson'@'205.156.8.85'
> > > > > > > > > (using password: NO)
> > > > > > > > >
> > > > > > > > > I need to prune a subset of data from about 7
different
> > > > > > > > > databases
> > > > > > > > > that I
> > > > > > > > > own. Do you need me to give you a list of those
databases
> > > > > > > > > so you
> > > > > > > > > can
> > > > > > > > modify
> > > > > > > > > the permissions on them?
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Logan
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> >
>
------------------------------------------------
Subject: AWS METviewer pruning still not working
From: Logan Dawson - NOAA Affiliate
Time: Tue Jun 09 07:45:57 2020
Hi Tatiana,
The pruning script worked in "info only" mode, and it's also working
while
actively pruning data. Thanks very much for finding the fix!
Thanks,
Logan
On Tue, Jun 9, 2020 at 9:29 AM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Logan,
>
> Could you try running the pruning script again. Hopefully, it will
work
> this time.
>
> Tatiana
>
> On Mon Jun 08 15:00:27 2020, logan.dawson at noaa.gov wrote:
> > I do get 'test_pass' as a result of running that command.
> >
> > -Logan
> >
> > On Mon, Jun 8, 2020 at 4:57 PM Tatiana Burek via RT
<met_help at ucar.edu>
> > wrote:
> >
> > > Logan,
> > > Could you execute following command from the same server where
you run
> > > METviewer pruning:
> > > ssh logan.dawson at 205.156.8.85 'cat /opt/metviewer/bin/.test |
openssl
> enc
> > > -aes-128-cbc -a -d -salt -pass pass:test'
> > >
> > > You should get 'test_pass' as a result.
> > >
> > > Tatiana
> > >
> > > On Mon Jun 08 14:12:00 2020, logan.dawson at noaa.gov wrote:
> > > > Hi Tatiana,
> > > >
> > > > Here's the updated output from my latest attempt (attached).
> > > >
> > > > -Logan
> > > >
> > > > On Mon, Jun 8, 2020 at 4:01 PM Tatiana Burek via RT
> > > > <met_help at ucar.edu>
> > > > wrote:
> > > >
> > > > > Logan,
> > > > > I added a few diagnostic messages to the script on AWS.
> > > > > Could you run your command again, pleas.
> > > > >
> > > > > Tatiana
> > > > >
> > > > > On Mon Jun 08 13:48:04 2020, logan.dawson at noaa.gov wrote:
> > > > > > Unfortunately, I'm getting the same behavior with
rds_host:3306
> > > > > > instead
> > > > > of
> > > > > > the full server name.
> > > > > >
> > > > > > -Logan
> > > > > >
> > > > > > On Mon, Jun 8, 2020 at 3:35 PM Tatiana Burek via RT
> > > > > > <met_help at ucar.edu>
> > > > > > wrote:
> > > > > >
> > > > > > > Logan,
> > > > > > >
> > > > > > > Instead of using the server name in <host> tag try to
use
> > > > > > > rds_host:3306
> > > > > > > <host>rds_host:3306</host>
> > > > > > >
> > > > > > > And I checked - you own 'mv_hrefv3_eval_radar_metplus'
database
> > > > > > > so I
> > > > > don't
> > > > > > > need to change the privileges.
> > > > > > >
> > > > > > > Tatiana
> > > > > > >
> > > > > > > On Mon Jun 08 13:08:04 2020, logan.dawson at noaa.gov
wrote:
> > > > > > > > Hi Tatiana,
> > > > > > > >
> > > > > > > > I've attached the XML and bash script I'm attempting
to run.
> > > > > > > > The
> > > > > > > > command
> > > > > > > > I'm trying is:
> > > > > > > >
> > > > > > > > ./mv_prune_on_aws.sh logan.dawson prune.xml
> > > > > > > >
> > > > > > > > Thanks,
> > > > > > > > Logan
> > > > > > > >
> > > > > > > > On Mon, Jun 8, 2020 at 2:56 PM Tatiana Burek via RT
> > > > > > > > <met_help at ucar.edu>
> > > > > > > > wrote:
> > > > > > > >
> > > > > > > > > Hi Logan,
> > > > > > > > >
> > > > > > > > > Could you send me your XML and the command line you
use.
> > > > > > > > >
> > > > > > > > > Thanks,
> > > > > > > > > Tatiana
> > > > > > > > > On Mon Jun 08 09:37:43 2020, logan.dawson at noaa.gov
wrote:
> > > > > > > > > > Hi Tatiana,
> > > > > > > > > >
> > > > > > > > > > I'm now attempting to prune data from some of my
> METviewer
> > > > > > > > > > databases, and
> > > > > > > > > > I'm still getting the same errors that I brought
up
> during
> > > > > > > > > > last
> > > > > > > > > > week's
> > > > > > > > > > METplus telecon:
> > > > > > > > > >
> > > > >
> https://www.emc.ncep.noaa.gov/users/Logan.Dawson/MEG/hold/prune.out
> > > > > > > > > >
> > > > > > > > > > It seems like there's an authentication issue,
maybe
> > > > > > > > > > preventing
> > > > > me
> > > > > > > > > > from
> > > > > > > > > > pruning data from databases that I own?
> > > > > > > > > >
> > > > > > > > > > Caused by: java.sql.SQLException: Access denied
for user
> > > > > > > > > > 'logan.dawson'@'205.156.8.85'
> > > > > > > > > > (using password: NO)
> > > > > > > > > >
> > > > > > > > > > I need to prune a subset of data from about 7
different
> > > > > > > > > > databases
> > > > > > > > > > that I
> > > > > > > > > > own. Do you need me to give you a list of those
databases
> > > > > > > > > > so you
> > > > > > > > > > can
> > > > > > > > > modify
> > > > > > > > > > the permissions on them?
> > > > > > > > > >
> > > > > > > > > > Thanks,
> > > > > > > > > > Logan
> > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
--
Logan C. Dawson, Ph.D.
Physical Scientist, VPPPG/MEG
NOAA/NWS/NCEP/EMC
(301) 683-3944
------------------------------------------------
More information about the Met_help
mailing list