Storage Issue: Analytics storage DB error. Insufficient permissions on the mount point

Answered

Andrew Sharrem

• Authorized Reseller

August 04, 2021 21:48

• 
• 
• 

With regards to support article: https://support.networkoptix.com/hc/en-us/articles/360052405994-How-to-fix-the-Analytics-Database-Storage-Issue 
How can I Programmatically set this value before I send "New Systems" out to my installers.
I see there is an API to set the value, but this would only work on an existing system, not a ready to setup system?
https://127.0.0.1:7001/api/systemSettings?forceAnalyticsDbStoragePermissions=true

As a distributor, we build & supply Linux Nx appliances to Integrators, and it is undesirable that installers must use the advanced web interface to change the setting on "every" server instance they install & create.

Ideally this should be a default setting for new servers.

I am also confused why this is a permissions issue when the mediaserver can create the "HD Witness Media" folder on new drives that are installed, but can't use the same drive for AnalyticsDbStorage without this setting?

One possible solution might be to allow this setting from the mediaserver.conf file.

Then I could add something like this to my build scripts;
sudo sed -i "$ a forceAnalyticsDbStoragePermissions=1" /opt/networkoptix/mediaserver/etc/mediaserver.conf

Welcome your thoughts.

0

• 

  Sergey Yuldashev

  • Network Optix team

  August 05, 2021 13:27

  Hello Andrew,

  While we do understand your struggle, let me clarify why it's done how it's done.

  We intentionally put it to the "Advanced" tab so that end users would not modify it on their own. Moreover, we hope that our partners do not share the existence of this hidden page with the users due to its content sensitivity. 
  The reason for that as well as why it is off by default is the security concerns introduced with this setting applied. When it's done, server modifies the parental directory permissions. I.e. every file in this directory besides ones owned by Nx will be affected.

  Thus we:

  1. Do not recommend setting it unless it is utterly required
  2. Recommend, if possible, to have a separate mount point dedicated for an analytics database storage only

  If you still would like to apply it to all the customers afterwards, feel free to send the mentioned API call prior to the system configuration with default admin:admin credentials pair:

  https://127.0.0.1:7001/api/systemSettings?forceAnalyticsDbStoragePermissions=true

  After applied, it will not affect "New System" state and will be kept after the further setup on the customers' side.

   

  0
• 

  Andrew Sharrem

  • Authorized Reseller

  August 11, 2021 04:22

  • 
  • 
  • 

  Thank you. The following code works well in my setup scripts (bash);

  curl "http://admin:admin@127.0.0.1:7001/api/systemSettings?forceAnalyticsDbStoragePermissions=true"

  0
• 

  Norman

  • Network Optix team

  August 24, 2021 14:18

  Hi Andrew Sharrem,

  We have not heard back from you in a while, so we are going to assume your question has been answered and set this topic to 'Answered'.

  0

Please sign in to leave a comment.