[Met_help] [RAL-IT #106303] History for Metviewer 4.1

Tue Jan 17 12:12:58 MST 2023

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

Hello,

We are installing a local instance of METviewer and have run into an issue.  OS is RHEL 7.9, database is Mariadb 10.3.35, and a Python 3.6.3 environment has been created.  The following is observed in the Catalina.out logs, and I CAN get to the database by CLI using mysql -u user -p.  I believe I have modified all the files where the hostname, user, and password information are necessary for this connection to be established, yet I get the following:

2023-01-13 09:02 edu.ucar.metviewer.MVServlet.init(Unknown Source) -1 init - METviewer app being placed into service by the servlet container.
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databases (conn=125) Could not select database 'Select databases' : Unknown database 'Select databases'
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown Source) -1 getConnection - can't get connection for database Select databases (conn=125) Could not select database 'Select databases' : Unknown database 'Select databases'
2023-01-13 09:02 edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown Source) -1 getListValues - PooledConnection has already been closed.

Thank you,

[cid:image001.png at 01D9272F.B801EB60]
Army Research Laboratory WSMR
Reynaldo Armendarez
Linux System Administrator
Agile Defense Inc.
CTR. Email: reynaldo.a.armendarez.ctr at army.mil<mailto:reynaldo.a.armendarez.ctr at army.mil>
SIPR Email: reynaldo.a.armendarez.ctr at mail.smil.mil<mailto:reynaldo.a.armendarez.ctr at mail.smil.mil>
O: 575-678-2450 C: 575-652-6862 SIPR: 575-678-5587
Company Email: reynaldo.armendarez at agile-defense.com<mailto:reynaldo.armendarez at agile-defense.com>
   Create & Follow the Status of Your Tickets on ServiceNow!
   https://helpdesk.arl.army.mil/
   1-800-276-9602

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

Subject: Metviewer 4.1
From: Julie Prestopnik
Time: Fri Jan 13 09:49:07 2023

Hi Mr. Armendarez.

Thank you for your question.  We are no longer supporting new
questions
through this email.  Please submit a new Discussion
<https://github.com/dtcenter/METplus/discussions/new> through our
GitHub
METplus Discussion Forum
<https://github.com/dtcenter/METplus/discussions>.
You will need to create a free GitHub account if you don't already
have one.

Julie

On Fri, Jan 13, 2023 at 9:16 AM Armendarez, Reynaldo A Jr CTR USARMY
DEVCOM
ARL (USA) via RT <met_help at ucar.edu> wrote:

>
> Fri Jan 13 09:16:44 2023: Request 106303 was acted upon.
> Transaction: Ticket created by reynaldo.a.armendarez.ctr at army.mil
>        Queue: met_help
>      Subject: Metviewer 4.1
>        Owner: Nobody
>   Requestors: reynaldo.a.armendarez.ctr at army.mil
>       Status: new
>  Ticket <URL:
https://rt.rap.ucar.edu/rt/Ticket/Display.html?id=106303 >
>
>
> Hello,
>
> We are installing a local instance of METviewer and have run into an
> issue.  OS is RHEL 7.9, database is Mariadb 10.3.35, and a Python
3.6.3
> environment has been created.  The following is observed in the
> Catalina.out logs, and I CAN get to the database by CLI using mysql
-u user
> -p.  I believe I have modified all the files where the hostname,
user, and
> password information are necessary for this connection to be
established,
> yet I get the following:
>
> 2023-01-13 09:02 edu.ucar.metviewer.MVServlet.init(Unknown Source)
-1 init
> - METviewer app being placed into service by the servlet container.
> 2023-01-13 09:02
>
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
> Source) -1 getConnection - can't get connection for database Select
> databases (conn=125) Could not select database 'Select databases' :
Unknown
> database 'Select databases'
> 2023-01-13 09:02
>
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown
> Source) -1 getListValues - PooledConnection has already been closed.
> 2023-01-13 09:02
>
edu.ucar.metviewer.db.mysql.MysqlDatabaseManager.getConnection(Unknown
> Source) -1 getConnection - can't get connection for database Select
> databases (conn=125) Could not select database 'Select databases' :
Unknown
> database 'Select databases'
> 2023-01-13 09:02
>
edu.ucar.metviewer.db.mysql.MysqlAppDatabaseManager.getListValues(Unknown
> Source) -1 getListValues - PooledConnection has already been closed.
>
> Thank you,
>
> [cid:image001.png at 01D9272F.B801EB60]
> Army Research Laboratory WSMR
> Reynaldo Armendarez
> Linux System Administrator
> Agile Defense Inc.
> CTR. Email: reynaldo.a.armendarez.ctr at army.mil<mailto:
> reynaldo.a.armendarez.ctr at army.mil>
> SIPR Email: reynaldo.a.armendarez.ctr at mail.smil.mil<mailto:
> reynaldo.a.armendarez.ctr at mail.smil.mil>
> O: 575-678-2450 C: 575-652-6862 SIPR: 575-678-5587
> Company Email: reynaldo.armendarez at agile-defense.com<mailto:
> reynaldo.armendarez at agile-defense.com>
>    Create & Follow the Status of Your Tickets on ServiceNow!
>    https://helpdesk.arl.army.mil/
>    1-800-276-9602
>
>
>
>

--
Julie Prestopnik (she/her)
Software Engineer
National Center for Atmospheric Research
Research Applications Laboratory
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.

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