perfSONAR User Q&A and Other Discussion

["Smith, Cody A." <>]

Hey Mark, 

Thanks for the reply. I’m still getting the same errors after both the command you sent, and a reboot. 

Cody Smith
Performance Engineer
OARnet
A member of the Ohio Technology Consortium
1224 Kinnear Road, Columbus, Ohio 43212
Office: (614) 292-9415 • Fax: (614) 292-9390

 

From: Mark Feit <>
Date: Thursday, June 22, 2017 at 3:29 PM
To: "Smith, Cody A." <>, perfsonar-user <>
Subject: Re: [perfsonar-user] pScheduler Cannot Connect to DB

Smith, Cody A. writes:

 

Recently, our MaDDash server has ran into a bit of a snag, We’re getting an internal server error ( 500 ) and all signs point to not being able to connect to the pScheduler DB .

…

To me, it seems like the application can’t connect to the DB because the authentication for the scheduler is failing. Any idea how to remedy this, or is this a red herring?

 

The database and the programs that use it are part of the pscheduler-server package, which generates a new random password to be used during the connection process on installation and during upgrades.  If something happens that causes an upgrade to fail mid-stream, it’s possible that the file that stores the password and what the database thinks it should be can get out of sync.  Because of a quirk in the way RPM works, there isn’t a way to cleanly roll the entire system back to its prior state where everything matched.

 

A “yum -y reinstall pscheduler-server” should make things right again and won’t destroy any data.

 

--Mark