Embedded Sybase database restore script fails on SLES 12

  • 7018682
  • 03-Mar-2017
  • 03-Mar-2017

Environment

ZENworks Configuration Management 2017

Situation

Embedded Sybase database is running on SLES 12 based Primary Server or ZENworks 2017 Appliance

The embedded database restore script /opt/novell/zenworks/bin/ZenworksLinuxDBRestore.sh fails with messages like:
"...
/ZenworksLinuxDBRestore.sh: line 158: /etc/init.d/novell-zenmntr: No such file or directory
./ZenworksLinuxDBRestore.sh: line 167: /etc/init.d/novell-zenserver: No such file or directory
./ZenworksLinuxDBRestore.sh: line 171: /etc/init.d/novell-zenloader: No such file or directory
...
Failure: Restore

..."


Resolution

Workaround:
1. Manually stop the database & database accessing services:
    - systemctl stop novell-zenloader.service
    - systemctl stop novell-zenserver.service
    - systemctl stop sybase-asa.service
2. Copy the backup database db & log file to the database folder /var/opt/novell/zenworks/database overwriting the existing database files.

3. Restart the services
    - systemctl start novell-zenloader.service
    - systemctl start novell-zenserver.service
    - systemctl start sybase-asa.service

4. Verify that the services are running
    - systemctl status -l novell-zenloader.service
    - systemctl status -l novell-zenserver.service
    - systemctl status -l sybase-asa.service

Cause

The script has not been adopted to support the systemd init system used in SLES 12.

Status

Reported to Engineering

Additional Information

Please note that the script does not cover the Audit database, which needs to be restored using similar steps as above but instead of stopping & restarting the sybase-asa.service, the sybase-audit-asa.service needs to be handled.