[Met_help] [rt.rap.ucar.edu #81106] History for Problem loading VSDBs to NCEP MetViewer Server: no database connection?
Tatiana Burek via RT
met_help at ucar.edu
Fri Jul 7 14:05:10 MDT 2017
----------------------------------------------------------------
Initial Request
----------------------------------------------------------------
Hello. I tried loading data to NCEP MetViewer server but the database
(mv_ylin_pcp) does not show up in the pull-down menu of the loaded
database even after 'reload database' and opening a new browser window.
Here's what I did for loading:
1) ssh to vm-lnx-metviewdev-process1 as wd22yl
2) sudo -i -u metviewer
3) mysql --defaults-file=/usr1/metviewer/.my.cnf -e"drop database
mv_ylin_pcp" (I tried loading the database twice)
4) mysql --defaults-file=/usr1/metviewer/.my.cnf -e'create database
mv_ylin_pcp'
5) mysql --defaults-file=/usr1/metviewer/.my.cnf mv_ylin_pcp <
/usr1/metviewer/metviewer/sql/mv_mysql.sql
6) /usr1/metviewer/metviewer/bin/mv_load.sh
/metviewer/staging/wd22yl/load_test.xml_ying.new_database >
/metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626
From 'mysql', I do see
| mv_ylin_pcp | 283832 | 2017-07-06 20:37:17
Here's a possible smoking gun: looking at the output
/metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626 and compare
it to an earlier load output (loadlog.20161001-20170513, same directory,
created on 22 May), today's load output is missing the following:
----------------------------------------------------------------------------
Database Connection:
db: mysql
host: vm-lnx-metviewdev-db1.ncep.noaa.gov:3306
database: mv_ylin_pcp
user: metviewer
password: @&R8M%x5_U~rXa
----------------------------------------------------------------------------
Can you tell what might have been the problem?
Thank you very much for your help -
Ying
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
----------------------------------------------------------------
Complete Ticket History
----------------------------------------------------------------
Subject: Problem loading VSDBs to NCEP MetViewer Server: no database connection?
From: Tatiana Burek
Time: Fri Jul 07 12:57:16 2017
Ying,
I checked METViewer on NCEP server ( metviewerdev.ncep.noaa.gov ) and
your database - mv_ylin_pcp - was on the list of available databases.
it is the last one.
Please try to view the application again and maybe clear the browser
cache.
Tatiana
On Thu Jul 06 15:26:13 2017, ying.lin at noaa.gov wrote:
> Hello. I tried loading data to NCEP MetViewer server but the
database
> (mv_ylin_pcp) does not show up in the pull-down menu of the loaded
> database even after 'reload database' and opening a new browser
window.
>
> Here's what I did for loading:
>
> 1) ssh to vm-lnx-metviewdev-process1 as wd22yl
>
> 2) sudo -i -u metviewer
>
> 3) mysql --defaults-file=/usr1/metviewer/.my.cnf -e"drop database
> mv_ylin_pcp" (I tried loading the database twice)
>
> 4) mysql --defaults-file=/usr1/metviewer/.my.cnf -e'create database
> mv_ylin_pcp'
>
> 5) mysql --defaults-file=/usr1/metviewer/.my.cnf mv_ylin_pcp <
> /usr1/metviewer/metviewer/sql/mv_mysql.sql
>
> 6) /usr1/metviewer/metviewer/bin/mv_load.sh
> /metviewer/staging/wd22yl/load_test.xml_ying.new_database >
> /metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626
>
> From 'mysql', I do see
>
> | mv_ylin_pcp | 283832 | 2017-07-06 20:37:17
>
> Here's a possible smoking gun: looking at the output
> /metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626 and
compare
> it to an earlier load output (loadlog.20161001-20170513, same
directory,
> created on 22 May), today's load output is missing the following:
>
>
----------------------------------------------------------------------------
>
> Database Connection:
> db: mysql
> host: vm-lnx-metviewdev-db1.ncep.noaa.gov:3306
> database: mv_ylin_pcp
> user: metviewer
> password: @&R8M%x5_U~rXa
>
>
----------------------------------------------------------------------------
>
> Can you tell what might have been the problem?
>
> Thank you very much for your help -
>
> Ying
>
------------------------------------------------
Subject: Re: [rt.rap.ucar.edu #81106] Problem loading VSDBs to NCEP MetViewer Server: no database connection?
From: Ying Lin
Time: Fri Jul 07 13:52:04 2017
Tatiana,
I see it now. Thank you very much!
Have a great weekend -
Ying
On 07/07/2017 02:57 PM, Tatiana Burek via RT wrote:
> Ying,
> I checked METViewer on NCEP server ( metviewerdev.ncep.noaa.gov )
and your database - mv_ylin_pcp - was on the list of available
databases. it is the last one.
> Please try to view the application again and maybe clear the
browser cache.
>
> Tatiana
>
> On Thu Jul 06 15:26:13 2017, ying.lin at noaa.gov wrote:
>> Hello. I tried loading data to NCEP MetViewer server but the
database
>> (mv_ylin_pcp) does not show up in the pull-down menu of the loaded
>> database even after 'reload database' and opening a new browser
window.
>>
>> Here's what I did for loading:
>>
>> 1) ssh to vm-lnx-metviewdev-process1 as wd22yl
>>
>> 2) sudo -i -u metviewer
>>
>> 3) mysql --defaults-file=/usr1/metviewer/.my.cnf -e"drop database
>> mv_ylin_pcp" (I tried loading the database twice)
>>
>> 4) mysql --defaults-file=/usr1/metviewer/.my.cnf -e'create database
>> mv_ylin_pcp'
>>
>> 5) mysql --defaults-file=/usr1/metviewer/.my.cnf mv_ylin_pcp <
>> /usr1/metviewer/metviewer/sql/mv_mysql.sql
>>
>> 6) /usr1/metviewer/metviewer/bin/mv_load.sh
>> /metviewer/staging/wd22yl/load_test.xml_ying.new_database >
>> /metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626
>>
>> From 'mysql', I do see
>>
>> | mv_ylin_pcp | 283832 | 2017-07-06
20:37:17
>>
>> Here's a possible smoking gun: looking at the output
>> /metviewer/staging/wd22yl/out.load/loadlog.20170501-20170626 and
compare
>> it to an earlier load output (loadlog.20161001-20170513, same
directory,
>> created on 22 May), today's load output is missing the following:
>>
>>
----------------------------------------------------------------------------
>>
>> Database Connection:
>> db: mysql
>> host: vm-lnx-metviewdev-db1.ncep.noaa.gov:3306
>> database: mv_ylin_pcp
>> user: metviewer
>> password: @&R8M%x5_U~rXa
>>
>>
----------------------------------------------------------------------------
>>
>> Can you tell what might have been the problem?
>>
>> Thank you very much for your help -
>>
>> Ying
>>
>
>
--
Ying Lin
NCEP/EMC/Verification, Post-processing and Product Generation Branch
NCWCP Cubicle No. 2015
Ying.Lin at noaa.gov
------------------------------------------------
More information about the Met_help
mailing list