• Development Wizard
• Install Fedora 38:
• Compile Source code,Install mysql Feture
• Sources
• Global Model全球化数据源(ftp)
• 地区性数据源
• National Weather Service Climate Prediction Center
• ECMWF.int-(Security):

Development Wizard

• Install Mysql On Fedora 38
  • dnf upgrade
  • dnf update
  • dnf search community-mysql
  • dnf install -y community-mysql-server
  • dnf install -y community-mysql-common
  • dnf install -y community-mysql-devel
  • dnf install -y commnuity-mysql-libs
  • rpm -qa |grep -i mysql
  • 列出组件全部安装
• 启动服务
  • systemctl start mysqld
• 开机自启动
  • systemctl enable mysqld
• 查看服务器状态
  • systemctl status mysqld
• 设置密码
  • mysql_secure_installation

Install fedora 38

• VirtualBox，https://www.virtualbox.org/

Compile Source code,Install Mysql Feture

• 安装gcc和gfortran编译器
  • yun install gcc gcc-gfortran -y
• 下载wgrib2软件包
  • http://www.ftp.cpc.ncep.noaa.gov/wd51we/wgrib2/wgrib2.tgz -O /usr/local/src/wgrib2.tgz
  • cd /usr/local/src
  • tar xzvf wgrib2.tgz
  • cd grib2/
• 设置编译环境
  • export CC=gcc
  • export FC=gfortran
• 启用mysql支持
  • vim makefile
  • USE_MYSQL = 1
• 编译
  • make

Enable mysql.local_infile (login as root)

• mysql -uroot -p
• mysql> show global variables like ‘local_infile’;
• mysql> set global local_infile=true;

Import to db📌

• ./wgrib2 gfs.t06z.pgrb2.0p25.f000 -mysql localhost root schelp#789 **db_name scheam_name

Sources

• https://www.cpc.ncep.noaa.gov/products/wesley/wgrib2/netcdf.html
• https://ftp.ncep.noaa.gov/data/nccf/com/gfs/prod/
• https://islocal.cc/arlo/551cdbc9/
• https://www.predictwind.com/

Global Model全球化数据源(ftp)

• GFS美国国家环境预报中心的GFS(全球预报系统)
  • ftp下载地址
  • Data Transfer Online Filter(g2sub V1.1)
• NASA
  • https://www.giss.nasa.gov/tools/panoply/
  • https://www.giss.nasa.gov/tools/panoply/download/PanoplyWin-5.2.8.zip
• ECMWF
  • https://ftp.ncep.noaa.gov/data/nccf/com/gfs/prod/
• SPIRE
• UKMO
• PWG
• PWE

地区性数据源

• NAM
• HRRR
• AROME
• PWG
• PWE

National Weather Service Climate Prediction Center

• https://www.cpc.ncep.noaa.gov/products/wesley/
• necp.noaa.gov:📌
  • https://www.cpc.ncep.noaa.gov/products/wesley/wgrib2/index.html
• wd51we sources:📌
  • https://ftp.cpc.ncep.noaa.gov/wd51we/