sap_ase16_systemd

Purpose:

Few scripts for a systemd service type unit and rotate logs for SAP (Sybase) ASE 16 database server and replication server on a single linux instance. This automates starting, stopping and log cleanup.

Use it as an example to clone/fork/copy/split/modify your own.

License

MIT

Files and Directories

File	Description
sybase.service	Service unit file.
sybase	Shell script contains the main logic for starting and stopping.
logrotate.d/sybase	Rotate logs example for an ASE instance
README	This file

Dir	Description
/sap/cfg/ASE-16_0/install/CFRSV602TSGAPP4_PID.d/	PID file directory

TODO

Instructions

Design Notes:

Designed to be a single unit of one dataserver and one backupserver and one repserver.
Servers start asynchronously (this is default behaviour of the startserver script).
Backupserver is logically named SYB_BACKUP (otherwise change the code a bit).
Shutdown assumes al connections are gone (nowait not used).
Uses the User directive in the Unit file so no su or sudo needed in the script.
Replication server start assumes there is a rep agent running on the RSSD database.
Developed on Centos7/ SAP ASE 16 (Express edition) for setting up a test VM.

Installation:

Clone this repo.
Adjust scripts to your needs, see also Configuration
Copy the unit script to /etc/systemd/system/ (With permissions: -rw-r--r--.).
Copy the sybase script to /home/sybase/.bin/ path is referred in the unit file).
Make script executable for login sybase.
sudo systemctl daemon-reload
Optionall: The logrotate file goes into /etc/logrotate.d (Centos/Redhat), verify path to log file!

Do some testing:

systemctl start sybase.service (su - sybase first)
systemctl status sybase.service
systemctl stop sybase.service (su - sybase first)

While testing check the errorlog for your database server.

Finally:

If ok, reboot Linux and test database connectivity (allow some time to bring databases online).

Configuration:

Configuration variables:

SYBASE Installation path software .
ADMINUSER Contains name of the database admin login (sa by default).
SERVERPW Contains the password for database server ADMINUSER. (Concider using openssl and encypted password files or a product like vault for storing secrets).
Script assumes passwords for ADMINUSER are identical on ASE and REP.
SERVER Name of the SAP ASE server
REPSERVER Name of the Replication server instance (Take the ID server).

Examples of changes:

Change it to sap_ase.service.
Use a different account to start services (this example also owns the installation).
Get this password from an encrypted password service or script.
Change the path to the start stop script.
Change the location of the pid file setup in the unit file and script.

Sample output

systemctl status sybase.service

Notice that this will NOT invoke the bash script with the status argument, this is how systemd behaves. For detailed status info invoke the script sybase_start status.

● sybase.service - SYBASE ASE
   Loaded: loaded (/etc/systemd/system/sybase.service; enabled; vendor preset: disabled)
   Active: activating (start) since Fri 2018-02-09 08:58:11 CET; 3min 50s ago
  Process: 1167 ExecStart=/opt/sybase/sybase_start start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/sybase.service
           ├─1252 /bin/sh /opt/sybase/ASE-16_0/install/RUN_SRV
           ├─1262 /opt/sybase/ASE-16_0/bin/dataserver -d/opt/sybase/data/master.dat -e/opt/sybase/ASE-16_0/install/srv.log -c/opt/sybase/ASE-16_0/SRV.cfg -M/opt/sybase/ASE-16_0 -N/opt/sybase/ASE-16_0/...
           ├─1374 /bin/sh /opt/sybase/ASE-16_0/install/RUN_SRV_BS
           ├─1375 /bin/bash /opt/sybase/sybase_start start
           ├─1378 tail -f /opt/sybase/ASE-16_0/install/SRV.log
           ├─1379 tail -n +1
           ├─1393 /opt/sybase/ASE-16_0/bin/backupserver -e/opt/sybase/ASE-16_0/install/srv_BS.log -N25 -C20 -I/opt/sybase/interfaces -M/opt/sybase/ASE-16_0/bin/sybmultbuf -Ssrv_BS
           ├─1909 /opt/sybase/ASE-16_0/bin/jsagent -p 4900 -n srv -t 32 -l 0 -v -e /opt/sybase/ASE-16_0/install/srv_JSAGENT.log -i /opt/sybase > /dev/null
           ├─1922 sh -c /opt/sybase/REP-15_5/install/RUN_PRS & 
           └─1923 /opt/sybase/REP-15_5/bin/repserver -SPRS -C/opt/sybase/REP-15_5/install/PRS.cfg -E/opt/sybase/REP-15_5/install/PRS.log -I/opt/sybase/interfaces

Feb 09 08:58:11 srv systemd[1]: Starting SYBASE ASE...

Feb 09 08:58:14 srv sybase_start[1167]: Starting srv service:  pid: 1252  Success.
Feb 09 08:58:15 srv sybase_start[1167]: Starting srv backup service:  Success.
Feb 09 08:58:15 srv sybase_start[1167]: Waiting for repagent on RSSD
Feb 09 08:59:38 srv sybase_start[1167]: 00:0006:00000:00015:2018/02/09 08:59:37.98 server  Started Rep Agent on database, 'PRS_RSSD' (dbid = 7)

eldorplus/sap_ase16_systemd