Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Sev Storage Server Enviroment

Sev Storage Server Enviroment 2 years 10 months ago #11066

  • sdockter
  • sdockter's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
  • Karma: 0
I created a storage station on a separate node but am having problems with the sev_xtt tool. When I start it, it asks for a username and password. I enter the pwrp username and password but get a "User not authorized" reply. I set the SevAdmin and SevRead flags in the User Database for the pwrp user, re-built, and then distributed it, but that didn't work.

I also tried to add setXttDefaultPriv admin in the /etc/proview.cnf file.

One other weird thing is that the MySQL database (pwrp__projectname) isn't created automatically. The directory in $pwrp_db isn't created either.

It seems like there is a permission missing somewhere?
The administrator has disabled public write access.

Sev Storage Server Enviroment 2 years 10 months ago #11068

  • sdockter
  • sdockter's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
  • Karma: 0
I was wrong about the MySQL database not being created automatically. It seems like the MySQL database name comes from the SystemName parameter on the System object in the project directory. Mine was named system, so a pwrp__system database was made, which confused me. I changed the System.SystemName to the project name and then the correctly name MySQL database was automatically created.

I'm still having the "User not authorized" problem when using sev_xtt.

A new problem I'm having is only 2 SevHist object get added to the MySQL database. It won't add the ActualValue parameter of the 3rd one but adds the parameter Events. This then seems to cause the rest of the SevHist objects to not get added too.

20210602SevServermySQLproblem.png


The SevHist object is configured to the ActualValue parameter.
The administrator has disabled public write access.

Sev Storage Server Enviroment 2 years 10 months ago #11069

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3178
  • Thank you received: 502
  • Karma: 133
Check the QComSegmentSize in the SevNodeConfig object. This should be zero.

/Claes
The administrator has disabled public write access.
The following user(s) said Thank You: sdockter

Sev Storage Server Enviroment 2 years 10 months ago #11070

  • sdockter
  • sdockter's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
  • Karma: 0
Thanks Claes! That was it. I'm able to add more SevHist object to the MySQL database.

I'm still having problems with the "User not authorized" when using sev_xtt. I have the pwrp user in the common user group with the SevRead and SevAdmin privileges selected:

pwrpprivileges.png


The UserDatabase is selected on the Sev Node distribution object:

SevNodeDistribute.png


When I distribute to the Sev Node, there is a warning that the authorized_keys file isn't found. I don't know what that file is for. The pwr_user2.dat file is in the distribution package, but the privileges value doesn't match what is shown in the user privileges configuration form.
The administrator has disabled public write access.

Sev Storage Server Enviroment 2 years 10 months ago #11074

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3178
  • Thank you received: 502
  • Karma: 133
Set sevXttDefaultPriv to Read or Admin in /etc/proview.cnf

/Claes
The administrator has disabled public write access.
The following user(s) said Thank You: sdockter

Sev Storage Server Enviroment 2 years 10 months ago #11075

  • sdockter
  • sdockter's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
  • Karma: 0
Hi Claes,

I had added that line in the proview.cnf file. But after checking it again, I noticed I had a typo. Once I corrected it, everything worked as expected.

Thanks again!
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 8.273 seconds