[Met_help] [rt.rap.ucar.edu #96599] History for can not upload database
John Halley Gotway via RT
met_help at ucar.edu
Fri Sep 11 13:31:53 MDT 2020
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hello,
This is Binyu Wang from NOAA/EMC. I created a database
(mv_g2g_met_Raikoke_CSI_0p1 ) and tried to load data inside, but I got
error as below:
grid_stat_Raikoke017_hr07_070000L_20190622_020000V_nbrcts. 100% 9198
218.6KB/s 00:00
CALLING: scp
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML/load_g2g_met_verf_Raikoke_CSI_0p01.xml
binyu.wang at 205.156.8.85:~
load_g2g_met_verf_Raikoke_CSI_0p01.xml 100% 1058
25.0KB/s 00:00
---- MVLoad ----
Begin time: 2020-09-08 16:20:42
Parsing: load_g2g_met_verf_Raikoke_CSI_0p01.xml
Sep 08, 2020 4:20:42 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to create initial connections of pool.
java.sql.SQLSyntaxErrorException: Access denied for user 'binyu.wang'@'%'
to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
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)
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.MysqlLoadDatabaseManager.<init>(Unknown Source)
at
edu.ucar.metviewer.db.aurora.AuroraLoadDatabaseManager.<init>(Unknown
Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at edu.ucar.metviewer.db.DatabaseManager.getLoadManager(Unknown
Source)
at edu.ucar.metviewer.MVLoad.main(Unknown Source)
Caused by: java.sql.SQLException: Access denied for user 'binyu.wang'@'%'
to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
.
.
.
2020-09-08
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
Source) -1 getConnection - can't get connection Access denied for user
'binyu.wang'@'%' to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
2020-09-08 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main - **
ERROR: Caught class java.lang.reflect.InvocationTargetException: null
java.lang.reflect.InvocationTargetException
---- MVLoad Done ----
What is the problem? Thank you.
Binyu
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: can not upload database
From: Julie Prestopnik
Time: Tue Sep 08 15:34:43 2020
Hi Binyu.
I have assigned this ticket to Tatiana. Please allow a few business
days
for a response.
Julie
On Tue, Sep 8, 2020 at 3:31 PM binyu.wang at noaa.gov via RT
<met_help at ucar.edu>
wrote:
>
> Tue Sep 08 15:31:37 2020: Request 96599 was acted upon.
> Transaction: Ticket created by binyu.wang at noaa.gov
> Queue: met_help
> Subject: can not upload database
> Owner: Nobody
> Requestors: binyu.wang at noaa.gov
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96599 >
>
>
> Hello,
>
> This is Binyu Wang from NOAA/EMC. I created a database
> (mv_g2g_met_Raikoke_CSI_0p1 ) and tried to load data inside, but I
got
> error as below:
> grid_stat_Raikoke017_hr07_070000L_20190622_020000V_nbrcts. 100% 9198
> 218.6KB/s 00:00
> CALLING: scp
>
>
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML/load_g2g_met_verf_Raikoke_CSI_0p01.xml
> binyu.wang at 205.156.8.85:~
> load_g2g_met_verf_Raikoke_CSI_0p01.xml 100% 1058
> 25.0KB/s 00:00
> ---- MVLoad ----
>
> Begin time: 2020-09-08 16:20:42
> Parsing: load_g2g_met_verf_Raikoke_CSI_0p01.xml
>
> Sep 08, 2020 4:20:42 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> SEVERE: Unable to create initial connections of pool.
> java.sql.SQLSyntaxErrorException: Access denied for user
'binyu.wang'@'%'
> to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> 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)
> 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.MysqlLoadDatabaseManager.<init>(Unknown
Source)
> at
>
edu.ucar.metviewer.db.aurora.AuroraLoadDatabaseManager.<init>(Unknown
> Source)
> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
>
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
>
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
edu.ucar.metviewer.db.DatabaseManager.getLoadManager(Unknown
> Source)
> at edu.ucar.metviewer.MVLoad.main(Unknown Source)
> Caused by: java.sql.SQLException: Access denied for user
'binyu.wang'@'%'
> to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
> .
> .
> .
>
>
> 2020-09-08
>
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
> Source) -1 getConnection - can't get connection Access denied for
user
> 'binyu.wang'@'%' to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> 2020-09-08 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
> ERROR: Caught class java.lang.reflect.InvocationTargetException:
null
> java.lang.reflect.InvocationTargetException
> ---- MVLoad Done ----
>
> What is the problem? Thank you.
>
> Binyu
>
>
--
Julie Prestopnik (she/her/hers)
Software Engineer
National Center for Atmospheric Research
Research Applications Laboratory
Phone: 303.497.8399
Email: jpresto at ucar.edu
My working day may not be your working day. Please do not feel
obliged to
reply to this email outside of your normal working hours.
------------------------------------------------
Subject: can not upload database
From: Tatiana Burek
Time: Wed Sep 09 15:00:02 2020
Hi Binyu
Did you create mv_g2g_met_verf_Raikoke_CSI_0p01 database before
starting
the loading?
I don't see the database with this name on AWS server.
Tatiana
On Tue, Sep 8, 2020 at 3:31 PM binyu.wang at noaa.gov via RT
<met_help at ucar.edu>
wrote:
>
> Tue Sep 08 15:31:37 2020: Request 96599 was acted upon.
> Transaction: Ticket created by binyu.wang at noaa.gov
> Queue: met_help
> Subject: can not upload database
> Owner: Nobody
> Requestors: binyu.wang at noaa.gov
> Status: new
> Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96599 >
>
>
> Hello,
>
> This is Binyu Wang from NOAA/EMC. I created a database
> (mv_g2g_met_Raikoke_CSI_0p1 ) and tried to load data inside, but I
got
> error as below:
> grid_stat_Raikoke017_hr07_070000L_20190622_020000V_nbrcts. 100% 9198
> 218.6KB/s 00:00
> CALLING: scp
>
>
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML/load_g2g_met_verf_Raikoke_CSI_0p01.xml
> binyu.wang at 205.156.8.85:~
> load_g2g_met_verf_Raikoke_CSI_0p01.xml 100% 1058
> 25.0KB/s 00:00
> ---- MVLoad ----
>
> Begin time: 2020-09-08 16:20:42
> Parsing: load_g2g_met_verf_Raikoke_CSI_0p01.xml
>
> Sep 08, 2020 4:20:42 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> SEVERE: Unable to create initial connections of pool.
> java.sql.SQLSyntaxErrorException: Access denied for user
'binyu.wang'@'%'
> to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> 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)
> 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.MysqlLoadDatabaseManager.<init>(Unknown
Source)
> at
>
edu.ucar.metviewer.db.aurora.AuroraLoadDatabaseManager.<init>(Unknown
> Source)
> at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> at
>
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> at
>
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at
edu.ucar.metviewer.db.DatabaseManager.getLoadManager(Unknown
> Source)
> at edu.ucar.metviewer.MVLoad.main(Unknown Source)
> Caused by: java.sql.SQLException: Access denied for user
'binyu.wang'@'%'
> to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
> at
>
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
> .
> .
> .
>
>
> 2020-09-08
>
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
> Source) -1 getConnection - can't get connection Access denied for
user
> 'binyu.wang'@'%' to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> 2020-09-08 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main -
**
> ERROR: Caught class java.lang.reflect.InvocationTargetException:
null
> java.lang.reflect.InvocationTargetException
> ---- MVLoad Done ----
>
> What is the problem? Thank you.
>
> Binyu
>
>
------------------------------------------------
Subject: can not upload database
From: binyu.wang at noaa.gov
Time: Fri Sep 11 10:30:08 2020
Tatiana:
Thank you. I found the problem.
Have a great weekend.
Binyu
On Wed, Sep 9, 2020 at 5:00 PM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:
> Hi Binyu
> Did you create mv_g2g_met_verf_Raikoke_CSI_0p01 database before
starting
> the loading?
> I don't see the database with this name on AWS server.
>
> Tatiana
>
> On Tue, Sep 8, 2020 at 3:31 PM binyu.wang at noaa.gov via RT <
> met_help at ucar.edu>
> wrote:
>
> >
> > Tue Sep 08 15:31:37 2020: Request 96599 was acted upon.
> > Transaction: Ticket created by binyu.wang at noaa.gov
> > Queue: met_help
> > Subject: can not upload database
> > Owner: Nobody
> > Requestors: binyu.wang at noaa.gov
> > Status: new
> > Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=96599 >
> >
> >
> > Hello,
> >
> > This is Binyu Wang from NOAA/EMC. I created a database
> > (mv_g2g_met_Raikoke_CSI_0p1 ) and tried to load data inside, but I
got
> > error as below:
> > grid_stat_Raikoke017_hr07_070000L_20190622_020000V_nbrcts. 100%
9198
> > 218.6KB/s 00:00
> > CALLING: scp
> >
> >
>
/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/g2g/XML/load_g2g_met_verf_Raikoke_CSI_0p01.xml
> > binyu.wang at 205.156.8.85:~
> > load_g2g_met_verf_Raikoke_CSI_0p01.xml 100%
1058
> > 25.0KB/s 00:00
> > ---- MVLoad ----
> >
> > Begin time: 2020-09-08 16:20:42
> > Parsing: load_g2g_met_verf_Raikoke_CSI_0p01.xml
> >
> > Sep 08, 2020 4:20:42 PM org.apache.tomcat.jdbc.pool.ConnectionPool
init
> > SEVERE: Unable to create initial connections of pool.
> > java.sql.SQLSyntaxErrorException: Access denied for user
'binyu.wang'@
> '%'
> > to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> > 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)
> > 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.MysqlLoadDatabaseManager.<init>(Unknown
> Source)
> > at
> >
edu.ucar.metviewer.db.aurora.AuroraLoadDatabaseManager.<init>(Unknown
> > Source)
> > at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> > Method)
> > at
> >
> >
>
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> > at
> >
> >
>
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> > at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> > at
edu.ucar.metviewer.db.DatabaseManager.getLoadManager(Unknown
> > Source)
> > at edu.ucar.metviewer.MVLoad.main(Unknown Source)
> > Caused by: java.sql.SQLException: Access denied for user
'binyu.wang'@
> '%'
> > to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> > at
> >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:850)
> > at
> >
> >
>
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:752)
> > .
> > .
> > .
> >
> >
> > 2020-09-08
> >
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
> > Source) -1 getConnection - can't get connection Access denied for
user
> > 'binyu.wang'@'%' to database 'mv_g2g_met_verf_Raikoke_CSI_0p01'
> > 2020-09-08 edu.ucar.metviewer.MVLoad.main(Unknown Source) -1 main
- **
> > ERROR: Caught class java.lang.reflect.InvocationTargetException:
null
> > java.lang.reflect.InvocationTargetException
> > ---- MVLoad Done ----
> >
> > What is the problem? Thank you.
> >
> > Binyu
> >
> >
>
>
------------------------------------------------
More information about the Met_help
mailing list