[Met_help] [rt.rap.ucar.edu #96393] History for doesn't have privileges to delete database

[Tatiana Burek via RT]

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

Hello,

I tried to delete a database but got error as below:
.%/run_delte.sh
User binyu.wang doesn't have privileges to delete database
mv_g2g_met_verf_Reventado

Here is my script:
#!/bin/sh
scripts=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
$scripts/mv_delete_db_on_aws.sh binyu.wang mv_g2g_met_verf_Reventado

I got a similar error when I tried to upload some new files to another
database:
SEVERE: Unable to create initial connections of pool.
java.sql.SQLSyntaxErrorException: Access denied for user 'binyu.wang'@'%'
to database 'mv_g2g_met_verf_Reventador'

Please help, thank you.
Binyu


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

Subject: doesn't have privileges to delete database
From: Tatiana Burek
Time: Fri Aug 21 07:33:41 2020

Hi Binyu,

The log message that you attached has database name
'mv_g2g_met_verf_Reventador'. The database with this name doesn't
exist but I found 'mv_g2g_met_Reventador' (without verf). If this is a
database you intended to work with you need to fix the db name in your
XML and the command line parameter.

Tatiana

On Thu Aug 20 19:54:57 2020, binyu.wang at noaa.gov wrote:
> Hello,
>
> I tried to delete a database but got error as below:
> .%/run_delte.sh
> User binyu.wang doesn't have privileges to delete database
> mv_g2g_met_verf_Reventado
>
> Here is my script:
> #!/bin/sh
>
scripts=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
> $scripts/mv_delete_db_on_aws.sh binyu.wang mv_g2g_met_verf_Reventado
>
> I got a similar error when I tried to upload some new files to
another
> database:
> SEVERE: Unable to create initial connections of pool.
> java.sql.SQLSyntaxErrorException: Access denied for user
'binyu.wang'@'%'
> to database 'mv_g2g_met_verf_Reventador'
>
> Please help, thank you.
> Binyu



------------------------------------------------
Subject: doesn't have privileges to delete database
From: binyu.wang at noaa.gov
Time: Fri Aug 21 09:09:36 2020

Thank you very much!  Tatiana.

Binyu

On Fri, Aug 21, 2020 at 9:33 AM Tatiana Burek via RT
<met_help at ucar.edu>
wrote:

> Hi Binyu,
>
> The log message that you attached has database name
> 'mv_g2g_met_verf_Reventador'. The database with this name doesn't
exist but
> I found 'mv_g2g_met_Reventador' (without verf). If this is a
database you
> intended to work with you need to fix the db name in your XML and
the
> command line parameter.
>
> Tatiana
>
> On Thu Aug 20 19:54:57 2020, binyu.wang at noaa.gov wrote:
> > Hello,
> >
> > I tried to delete a database but got error as below:
> > .%/run_delte.sh
> > User binyu.wang doesn't have privileges to delete database
> > mv_g2g_met_verf_Reventado
> >
> > Here is my script:
> > #!/bin/sh
> >
>
scripts=/gpfs/dell2/emc/modeling/noscrub/Binyu.Wang/MET/METviewer_AWS/script
> > $scripts/mv_delete_db_on_aws.sh binyu.wang
mv_g2g_met_verf_Reventado
> >
> > I got a similar error when I tried to upload some new files to
another
> > database:
> > SEVERE: Unable to create initial connections of pool.
> > java.sql.SQLSyntaxErrorException: Access denied for user
'binyu.wang'@
> '%'
> > to database 'mv_g2g_met_verf_Reventador'
> >
> > Please help, thank you.
> > Binyu
>
>
>
>

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