Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Web Help Desk (WHD) > Failed Web Help Desk v12.0.0 upgrade on Mac OS X

Failed Web Help Desk v12.0.0 upgrade on Mac OS X

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 24 Votes: 0 Revisions: 10

Issue

Web Help Desk on Mac OS X is unable to update to
version 12.0.0, receiving an error that the database migration cannot run because PostgreSQL service is not started.

Cause


This issue may be caused by the
Default shared memory settings for Mac OS X, which can be too low for the embedded PostgreSQL database to start.

Resolution


The PostgreSQL Global Development Documentation recommends editing the /etc/sysctl.conf file, to contain variable assignments such as:

kern.sysv.shmmax=1073741824
kern.sysv.shmmin=1
kern.sysv.shmmni=32 
kern.sysv.shmseg=8
kern.sysv.shmall=262144

Always set up your preferred values using /etc/sysctl.conf, so the operating system saves the values across reboots. OS X system updates usually overwrite /etc/rc, so you should expect to have to redo these edits after each update.In OS X 10.2 and earlier, edit the commands directly above in the file /System/Library/StartupItems/SystemTuning/SystemTuning. Linux installations with external PostgreSQL databases may also require memory settings adjustment. See the PostgreSQL Global Development Documentation, 17.4 Managing Kernel Resources for more detailed information on increasing the shared memory limits for OS X, as well as for Linux. 

Keep in mind that:

 

  • In some OS X versions, all five shared-memory parameters must be set in /etc/sysctl.conf, or the values are ignored.
  • Recent releases of OS X ignore SHMMAX  values that are not exact multiples of 4096.OS X measures SHMALL in 4 kb pages.
  • Older OS X versions require rebooting to enable changes in the shared memory.
  • As of OS X 10.5, using sysctl, it is possible to change all variables but SHMMNI on the fly, using the variables noted above.

 

Note: If PostgreSQL does not start after editing the shared memory values, you may find that you have an additional Postgres driver in /Library/Java/Extensions overriding the Postgres driver provided with Web Help Desk. If this extra driver exists
in
/Library/Java/Extensions, delete it before you restart Web Help Desk. Also, if you are using a Microsoft Exchange SSL connection, make sure you have applied the latest hotfix to your installation.

 

1073741824
Last modified

Tags

Classifications

Public