[Met_help] [rt.rap.ucar.edu #98487] History for Connection to METviewer
John Halley Gotway via RT
met_help at ucar.edu
Wed Feb 10 08:59:48 MST 2021
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
I am having problems connecting to METviewer from WCOSS today. I am
getting errors that look like this:
Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLSyntaxErrorException: Access denied for user 'perry.shafran'@'%'
to database 'mv_lam_grid2obs_2021_metplus'
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
at
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
at
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
at org.mariadb.jdbc.Driver.connect(Driver.java:92)
2021-02-01
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown Source)
-1 initDBList - Access denied for user 'perry.shafran'@'%' to database
'mv_lam_grid2obs_2021_metplus'
Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLSyntaxErrorException: Access denied for user 'perry.shafran'@'%'
to database 'mv_lam_grid2obs_2021_metplus'
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
at
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
Is this part of the same earlier problem of too many processes hitting
METviewer jamming the ability to further load data?
Thanks!
Perry
--
Perry C. Shafran
Verification/MEG Group Leader for IMSG
VPPPG Branch of EMC/NCEP/NOAA/NWS
Office: 301-683-3765
Cell: 301-717-6454
(he/him/his)
perry.shafran at noaa.gov
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: Connection to METviewer
From: perry.shafran at noaa.gov
Time: Mon Feb 01 14:52:52 2021
I forgot to mention, here's the command I was using to load METviewer,
in
case you want to look:
sh mv_load_to_aws.sh perry.shafran /gpfs/dell2/ptmp/Perry.Shafran/lam/
/gpfs/dell2/emc/verification/save/Perry.Shafran/aws/load_met_lam.xml
Thanks!
Perry
On Mon, Feb 1, 2021 at 4:50 PM met_help at ucar.edu via RT
<met_help at ucar.edu>
wrote:
> Greetings,
>
> This message has been automatically generated in response to the
creation
> of a trouble ticket regarding:
> "Connection to METviewer",
> a summary of which appears below.
>
> There is no need to reply to this message right now. Your ticket
has been
> assigned an ID of [rt.rap.ucar.edu #98487].
>
> Please include the string:
>
> [rt.rap.ucar.edu #98487]
>
> in the subject line of all future correspondence about this issue.
To do
> so, you may reply to this message.
>
> For more information, please see:
>
> MET Online Tutorial:
>
https://www.dtcenter.org/met/users/support/online_tutorial/index.php
>
> MET Users Guide:
> https://www.dtcenter.org/met/users/docs/overview.php
>
> MET FAQs:
> https://www.dtcenter.org/met/users/support/faqs/index.php
>
> MET-Help Email Archive:
> http://mailman.ucar.edu/pipermail/met_help
>
> Thank you,
> met_help at ucar.edu
>
>
-------------------------------------------------------------------------
> I am having problems connecting to METviewer from WCOSS today. I am
> getting errors that look like this:
>
> Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> SEVERE: Unable to create initial connections of pool.
> java.sql.SQLSyntaxErrorException: Access denied for user
'perry.shafran'@
> '%'
> to database 'mv_lam_grid2obs_2021_metplus'
> at
>
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> at
>
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> at
> org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> at
>
>
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
> at org.mariadb.jdbc.Driver.connect(Driver.java:92)
>
> 2021-02-01
> edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
Source)
> -1 initDBList - Access denied for user 'perry.shafran'@'%' to
database
> 'mv_lam_grid2obs_2021_metplus'
> Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> SEVERE: Unable to create initial connections of pool.
> java.sql.SQLSyntaxErrorException: Access denied for user
'perry.shafran'@
> '%'
> to database 'mv_lam_grid2obs_2021_metplus'
> at
>
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> at
>
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> at
> org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
>
> Is this part of the same earlier problem of too many processes
hitting
> METviewer jamming the ability to further load data?
>
> Thanks!
>
> Perry
>
> --
> Perry C. Shafran
> Verification/MEG Group Leader for IMSG
> VPPPG Branch of EMC/NCEP/NOAA/NWS
> Office: 301-683-3765
> Cell: 301-717-6454
> (he/him/his)
> perry.shafran at noaa.gov
>
>
--
Perry C. Shafran
Verification/MEG Group Leader for IMSG
VPPPG Branch of EMC/NCEP/NOAA/NWS
Office: 301-683-3765
Cell: 301-717-6454
(he/him/his)
perry.shafran at noaa.gov
------------------------------------------------
Subject: Connection to METviewer
From: John Halley Gotway
Time: Mon Feb 01 20:34:11 2021
Tatiana,
Can you please take a look at this METviewer connection issue from
Perry
when you get a chance?
I’ll assign it to you in RT next time I’m able to log on.
Thanks,
John
On Mon, Feb 1, 2021 at 2:53 PM perry.shafran at noaa.gov via RT <
met_help at ucar.edu> wrote:
>
> <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=98487 >
>
> I forgot to mention, here's the command I was using to load
METviewer, in
> case you want to look:
>
> sh mv_load_to_aws.sh perry.shafran
/gpfs/dell2/ptmp/Perry.Shafran/lam/
> /gpfs/dell2/emc/verification/save/Perry.Shafran/aws/load_met_lam.xml
>
> Thanks!
>
> Perry
>
> On Mon, Feb 1, 2021 at 4:50 PM met_help at ucar.edu via RT
<met_help at ucar.edu
> >
> wrote:
>
> > Greetings,
> >
> > This message has been automatically generated in response to the
creation
> > of a trouble ticket regarding:
> > "Connection to METviewer",
> > a summary of which appears below.
> >
> > There is no need to reply to this message right now. Your ticket
has
> been
> > assigned an ID of [rt.rap.ucar.edu #98487].
> >
> > Please include the string:
> >
> > [rt.rap.ucar.edu #98487]
> >
> > in the subject line of all future correspondence about this issue.
To do
> > so, you may reply to this message.
> >
> > For more information, please see:
> >
> > MET Online Tutorial:
> >
https://www.dtcenter.org/met/users/support/online_tutorial/index.php
> >
> > MET Users Guide:
> > https://www.dtcenter.org/met/users/docs/overview.php
> >
> > MET FAQs:
> > https://www.dtcenter.org/met/users/support/faqs/index.php
> >
> > MET-Help Email Archive:
> > http://mailman.ucar.edu/pipermail/met_help
> >
> > Thank you,
> > met_help at ucar.edu
> >
> >
-------------------------------------------------------------------------
> > I am having problems connecting to METviewer from WCOSS today. I
am
> > getting errors that look like this:
> >
> > Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> > SEVERE: Unable to create initial connections of pool.
> > java.sql.SQLSyntaxErrorException: Access denied for user
'perry.shafran'@
> > '%'
> > to database 'mv_lam_grid2obs_2021_metplus'
> > at
> >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > at
> >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > at
> >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > at
> > org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > at
> >
> >
>
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
> > at org.mariadb.jdbc.Driver.connect(Driver.java:92)
> >
> > 2021-02-01
> >
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
> Source)
> > -1 initDBList - Access denied for user 'perry.shafran'@'%' to
database
> > 'mv_lam_grid2obs_2021_metplus'
> > Feb 01, 2021 9:28:00 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> > SEVERE: Unable to create initial connections of pool.
> > java.sql.SQLSyntaxErrorException: Access denied for user
'perry.shafran'@
> > '%'
> > to database 'mv_lam_grid2obs_2021_metplus'
> > at
> >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > at
> >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > at
> >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > at
> > org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> >
> > Is this part of the same earlier problem of too many processes
hitting
> > METviewer jamming the ability to further load data?
> >
> > Thanks!
> >
> > Perry
> >
> > --
> > Perry C. Shafran
> > Verification/MEG Group Leader for IMSG
> > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > Office: 301-683-3765
> > Cell: 301-717-6454
> > (he/him/his)
> > perry.shafran at noaa.gov
> >
> >
>
> --
> Perry C. Shafran
> Verification/MEG Group Leader for IMSG
> VPPPG Branch of EMC/NCEP/NOAA/NWS
> Office: 301-683-3765
> Cell: 301-717-6454
> (he/him/his)
> perry.shafran at noaa.gov
>
>
------------------------------------------------
Subject: Connection to METviewer
From: perry.shafran at noaa.gov
Time: Tue Feb 02 06:10:47 2021
Hi, again,
I just wanted to let you know that NCO is running a 24-hr parallel
production test, so you won't be able to check anything out on WCOSS
today
until tomorrow morning. But I can log on if you want to see xml files
or
anything like that.
Thanks!
Perry
On Mon, Feb 1, 2021 at 10:34 PM John Halley Gotway via RT
<met_help at ucar.edu>
wrote:
> Tatiana,
>
> Can you please take a look at this METviewer connection issue from
Perry
> when you get a chance?
>
> I’ll assign it to you in RT next time I’m able to log on.
>
> Thanks,
> John
>
> On Mon, Feb 1, 2021 at 2:53 PM perry.shafran at noaa.gov via RT <
> met_help at ucar.edu> wrote:
>
> >
> > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=98487 >
> >
> > I forgot to mention, here's the command I was using to load
METviewer, in
> > case you want to look:
> >
> > sh mv_load_to_aws.sh perry.shafran
/gpfs/dell2/ptmp/Perry.Shafran/lam/
> >
/gpfs/dell2/emc/verification/save/Perry.Shafran/aws/load_met_lam.xml
> >
> > Thanks!
> >
> > Perry
> >
> > On Mon, Feb 1, 2021 at 4:50 PM met_help at ucar.edu via RT <
> met_help at ucar.edu
> > >
> > wrote:
> >
> > > Greetings,
> > >
> > > This message has been automatically generated in response to the
> creation
> > > of a trouble ticket regarding:
> > > "Connection to METviewer",
> > > a summary of which appears below.
> > >
> > > There is no need to reply to this message right now. Your
ticket has
> > been
> > > assigned an ID of [rt.rap.ucar.edu #98487].
> > >
> > > Please include the string:
> > >
> > > [rt.rap.ucar.edu #98487]
> > >
> > > in the subject line of all future correspondence about this
issue. To
> do
> > > so, you may reply to this message.
> > >
> > > For more information, please see:
> > >
> > > MET Online Tutorial:
> > >
> https://www.dtcenter.org/met/users/support/online_tutorial/index.php
> > >
> > > MET Users Guide:
> > > https://www.dtcenter.org/met/users/docs/overview.php
> > >
> > > MET FAQs:
> > > https://www.dtcenter.org/met/users/support/faqs/index.php
> > >
> > > MET-Help Email Archive:
> > > http://mailman.ucar.edu/pipermail/met_help
> > >
> > > Thank you,
> > > met_help at ucar.edu
> > >
> > >
>
-------------------------------------------------------------------------
> > > I am having problems connecting to METviewer from WCOSS today.
I am
> > > getting errors that look like this:
> > >
> > > Feb 01, 2021 9:28:00 PM
org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > SEVERE: Unable to create initial connections of pool.
> > > java.sql.SQLSyntaxErrorException: Access denied for user
> 'perry.shafran'@
> > > '%'
> > > to database 'mv_lam_grid2obs_2021_metplus'
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > at
> > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
> > > at org.mariadb.jdbc.Driver.connect(Driver.java:92)
> > >
> > > 2021-02-01
> > >
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
> > Source)
> > > -1 initDBList - Access denied for user 'perry.shafran'@'%' to
database
> > > 'mv_lam_grid2obs_2021_metplus'
> > > Feb 01, 2021 9:28:00 PM
org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > SEVERE: Unable to create initial connections of pool.
> > > java.sql.SQLSyntaxErrorException: Access denied for user
> 'perry.shafran'@
> > > '%'
> > > to database 'mv_lam_grid2obs_2021_metplus'
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > at
> > >
> > >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > at
> > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > >
> > > Is this part of the same earlier problem of too many processes
hitting
> > > METviewer jamming the ability to further load data?
> > >
> > > Thanks!
> > >
> > > Perry
> > >
> > > --
> > > Perry C. Shafran
> > > Verification/MEG Group Leader for IMSG
> > > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > > Office: 301-683-3765
> > > Cell: 301-717-6454
> > > (he/him/his)
> > > perry.shafran at noaa.gov
> > >
> > >
> >
> > --
> > Perry C. Shafran
> > Verification/MEG Group Leader for IMSG
> > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > Office: 301-683-3765
> > Cell: 301-717-6454
> > (he/him/his)
> > perry.shafran at noaa.gov
> >
> >
>
>
--
Perry C. Shafran
Verification/MEG Group Leader for IMSG
VPPPG Branch of EMC/NCEP/NOAA/NWS
Office: 301-683-3765
Cell: 301-717-6454
(he/him/his)
perry.shafran at noaa.gov
------------------------------------------------
Subject: Connection to METviewer
From: Tatiana Burek
Time: Tue Feb 02 10:48:52 2021
Perry
Database mv_lam_grid2obs_2021_metplus doesn't exist on AWS.
There is a database with name mv_lam_gridtobs_2021_metplus. Is it the
one you try to use?
Tatiana
On Tue Feb 02 06:10:47 2021, perry.shafran at noaa.gov wrote:
> Hi, again,
>
> I just wanted to let you know that NCO is running a 24-hr parallel
> production test, so you won't be able to check anything out on WCOSS
> today
> until tomorrow morning. But I can log on if you want to see xml
files
> or
> anything like that.
>
> Thanks!
>
> Perry
>
> On Mon, Feb 1, 2021 at 10:34 PM John Halley Gotway via RT
> <met_help at ucar.edu>
> wrote:
>
> > Tatiana,
> >
> > Can you please take a look at this METviewer connection issue from
> > Perry
> > when you get a chance?
> >
> > I’ll assign it to you in RT next time I’m able to log on.
> >
> > Thanks,
> > John
> >
> > On Mon, Feb 1, 2021 at 2:53 PM perry.shafran at noaa.gov via RT <
> > met_help at ucar.edu> wrote:
> >
> > >
> > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=98487 >
> > >
> > > I forgot to mention, here's the command I was using to load
> > > METviewer, in
> > > case you want to look:
> > >
> > > sh mv_load_to_aws.sh perry.shafran
> > > /gpfs/dell2/ptmp/Perry.Shafran/lam/
> > >
/gpfs/dell2/emc/verification/save/Perry.Shafran/aws/load_met_lam.xml
> > >
> > > Thanks!
> > >
> > > Perry
> > >
> > > On Mon, Feb 1, 2021 at 4:50 PM met_help at ucar.edu via RT <
> > met_help at ucar.edu
> > > >
> > > wrote:
> > >
> > > > Greetings,
> > > >
> > > > This message has been automatically generated in response to
the
> > creation
> > > > of a trouble ticket regarding:
> > > > "Connection to METviewer",
> > > > a summary of which appears below.
> > > >
> > > > There is no need to reply to this message right now. Your
ticket
> > > > has
> > > been
> > > > assigned an ID of [rt.rap.ucar.edu #98487].
> > > >
> > > > Please include the string:
> > > >
> > > > [rt.rap.ucar.edu #98487]
> > > >
> > > > in the subject line of all future correspondence about this
> > > > issue. To
> > do
> > > > so, you may reply to this message.
> > > >
> > > > For more information, please see:
> > > >
> > > > MET Online Tutorial:
> > > >
> >
https://www.dtcenter.org/met/users/support/online_tutorial/index.php
> > > >
> > > > MET Users Guide:
> > > > https://www.dtcenter.org/met/users/docs/overview.php
> > > >
> > > > MET FAQs:
> > > > https://www.dtcenter.org/met/users/support/faqs/index.php
> > > >
> > > > MET-Help Email Archive:
> > > > http://mailman.ucar.edu/pipermail/met_help
> > > >
> > > > Thank you,
> > > > met_help at ucar.edu
> > > >
> > > >
> >
-------------------------------------------------------------------------
> > > > I am having problems connecting to METviewer from WCOSS today.
I
> > > > am
> > > > getting errors that look like this:
> > > >
> > > > Feb 01, 2021 9:28:00 PM
> > > > org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > > SEVERE: Unable to create initial connections of pool.
> > > > java.sql.SQLSyntaxErrorException: Access denied for user
> > 'perry.shafran'@
> > > > '%'
> > > > to database 'mv_lam_grid2obs_2021_metplus'
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > > at
> > > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
> > > > at org.mariadb.jdbc.Driver.connect(Driver.java:92)
> > > >
> > > > 2021-02-01
> > > >
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
> > > Source)
> > > > -1 initDBList - Access denied for user 'perry.shafran'@'%' to
> > > > database
> > > > 'mv_lam_grid2obs_2021_metplus'
> > > > Feb 01, 2021 9:28:00 PM
> > > > org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > > SEVERE: Unable to create initial connections of pool.
> > > > java.sql.SQLSyntaxErrorException: Access denied for user
> > 'perry.shafran'@
> > > > '%'
> > > > to database 'mv_lam_grid2obs_2021_metplus'
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > > at
> > > >
> > > >
> > >
> >
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > > at
> > > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > > >
> > > > Is this part of the same earlier problem of too many processes
> > > > hitting
> > > > METviewer jamming the ability to further load data?
> > > >
> > > > Thanks!
> > > >
> > > > Perry
> > > >
> > > > --
> > > > Perry C. Shafran
> > > > Verification/MEG Group Leader for IMSG
> > > > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > > > Office: 301-683-3765
> > > > Cell: 301-717-6454
> > > > (he/him/his)
> > > > perry.shafran at noaa.gov
> > > >
> > > >
> > >
> > > --
> > > Perry C. Shafran
> > > Verification/MEG Group Leader for IMSG
> > > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > > Office: 301-683-3765
> > > Cell: 301-717-6454
> > > (he/him/his)
> > > perry.shafran at noaa.gov
> > >
> > >
> >
> >
------------------------------------------------
Subject: Connection to METviewer
From: perry.shafran at noaa.gov
Time: Tue Feb 02 10:51:26 2021
Oh! I named the database incorrectly. I wanted it to be grid2obs. I
guess this is the source of the error?
Yeesh, simple as that.
Thanks!
Perry
On Tue, Feb 2, 2021 at 12:49 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Perry
> Database mv_lam_grid2obs_2021_metplus doesn't exist on AWS.
> There is a database with name mv_lam_gridtobs_2021_metplus. Is it
the one
> you try to use?
>
> Tatiana
>
> On Tue Feb 02 06:10:47 2021, perry.shafran at noaa.gov wrote:
> > Hi, again,
> >
> > I just wanted to let you know that NCO is running a 24-hr parallel
> > production test, so you won't be able to check anything out on
WCOSS
> > today
> > until tomorrow morning. But I can log on if you want to see xml
files
> > or
> > anything like that.
> >
> > Thanks!
> >
> > Perry
> >
> > On Mon, Feb 1, 2021 at 10:34 PM John Halley Gotway via RT
> > <met_help at ucar.edu>
> > wrote:
> >
> > > Tatiana,
> > >
> > > Can you please take a look at this METviewer connection issue
from
> > > Perry
> > > when you get a chance?
> > >
> > > I’ll assign it to you in RT next time I’m able to log on.
> > >
> > > Thanks,
> > > John
> > >
> > > On Mon, Feb 1, 2021 at 2:53 PM perry.shafran at noaa.gov via RT <
> > > met_help at ucar.edu> wrote:
> > >
> > > >
> > > > <URL: https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=98487
>
> > > >
> > > > I forgot to mention, here's the command I was using to load
> > > > METviewer, in
> > > > case you want to look:
> > > >
> > > > sh mv_load_to_aws.sh perry.shafran
> > > > /gpfs/dell2/ptmp/Perry.Shafran/lam/
> > > >
/gpfs/dell2/emc/verification/save/Perry.Shafran/aws/load_met_lam.xml
> > > >
> > > > Thanks!
> > > >
> > > > Perry
> > > >
> > > > On Mon, Feb 1, 2021 at 4:50 PM met_help at ucar.edu via RT <
> > > met_help at ucar.edu
> > > > >
> > > > wrote:
> > > >
> > > > > Greetings,
> > > > >
> > > > > This message has been automatically generated in response to
the
> > > creation
> > > > > of a trouble ticket regarding:
> > > > > "Connection to METviewer",
> > > > > a summary of which appears below.
> > > > >
> > > > > There is no need to reply to this message right now. Your
ticket
> > > > > has
> > > > been
> > > > > assigned an ID of [rt.rap.ucar.edu #98487].
> > > > >
> > > > > Please include the string:
> > > > >
> > > > > [rt.rap.ucar.edu #98487]
> > > > >
> > > > > in the subject line of all future correspondence about this
> > > > > issue. To
> > > do
> > > > > so, you may reply to this message.
> > > > >
> > > > > For more information, please see:
> > > > >
> > > > > MET Online Tutorial:
> > > > >
> > >
https://www.dtcenter.org/met/users/support/online_tutorial/index.php
> > > > >
> > > > > MET Users Guide:
> > > > > https://www.dtcenter.org/met/users/docs/overview.php
> > > > >
> > > > > MET FAQs:
> > > > > https://www.dtcenter.org/met/users/support/faqs/index.php
> > > > >
> > > > > MET-Help Email Archive:
> > > > > http://mailman.ucar.edu/pipermail/met_help
> > > > >
> > > > > Thank you,
> > > > > met_help at ucar.edu
> > > > >
> > > > >
> > >
>
-------------------------------------------------------------------------
> > > > > I am having problems connecting to METviewer from WCOSS
today. I
> > > > > am
> > > > > getting errors that look like this:
> > > > >
> > > > > Feb 01, 2021 9:28:00 PM
> > > > > org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > > > SEVERE: Unable to create initial connections of pool.
> > > > > java.sql.SQLSyntaxErrorException: Access denied for user
> > > 'perry.shafran'@
> > > > > '%'
> > > > > to database 'mv_lam_grid2obs_2021_metplus'
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > > > at
> > > > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:174)
> > > > > at org.mariadb.jdbc.Driver.connect(Driver.java:92)
> > > > >
> > > > > 2021-02-01
> > > > >
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.initDBList(Unknown
> > > > Source)
> > > > > -1 initDBList - Access denied for user 'perry.shafran'@'%'
to
> > > > > database
> > > > > 'mv_lam_grid2obs_2021_metplus'
> > > > > Feb 01, 2021 9:28:00 PM
> > > > > org.apache.tomcat.jdbc.pool.ConnectionPool init
> > > > > SEVERE: Unable to create initial connections of pool.
> > > > > java.sql.SQLSyntaxErrorException: Access denied for user
> > > 'perry.shafran'@
> > > > > '%'
> > > > > to database 'mv_lam_grid2obs_2021_metplus'
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1128)
> > > > > at
> > > > >
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:560)
> > > > >
> > > > > Is this part of the same earlier problem of too many
processes
> > > > > hitting
> > > > > METviewer jamming the ability to further load data?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Perry
> > > > >
> > > > > --
> > > > > Perry C. Shafran
> > > > > Verification/MEG Group Leader for IMSG
> > > > > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > > > > Office: 301-683-3765
> > > > > Cell: 301-717-6454
> > > > > (he/him/his)
> > > > > perry.shafran at noaa.gov
> > > > >
> > > > >
> > > >
> > > > --
> > > > Perry C. Shafran
> > > > Verification/MEG Group Leader for IMSG
> > > > VPPPG Branch of EMC/NCEP/NOAA/NWS
> > > > Office: 301-683-3765
> > > > Cell: 301-717-6454
> > > > (he/him/his)
> > > > perry.shafran at noaa.gov
> > > >
> > > >
> > >
> > >
>
>
>
>
--
Perry C. Shafran
Verification/MEG Group Leader for IMSG
VPPPG Branch of EMC/NCEP/NOAA/NWS
Office: 301-683-3765
Cell: 301-717-6454
(he/him/his)
perry.shafran at noaa.gov
------------------------------------------------
More information about the Met_help
mailing list