Hi Team, I currently have a running Network DB service on CentOS 7. When I go to create a secondary service using the DBSVC utility and lets say I name it "archive", it asks me if I would like to override the "archive" service, even though it does not currently exist. It does not matter what I name it, it wants me to override. Any idea on the correct steps for setting up a secondary Network (type) database service on SQL Anywhere 17? How to run it via Systemd? **Command:** dbsvc -as -t Network -w archive /opt/progeny/database/archive/databasename.db -n archive **Existing service details:** [Unit] Description=SQLAnywhere Network service After=syslog.target network.target local-fs.target [Service] Type=forking Nice=0 PermissionsStartOnly=True User=sybase17 Group=sybase17 RuntimeDirectory=SA_ RuntimeDirectoryMode=0775 PIDFile=/run/SA_/service.pid Environment="TMP=/tmp/\x2eSQLAnywhere" Environment="ODBCINI=" Environment="PIDFILE=/run/SA_/service\x2epid" Environment="SVC_IFACE=systemd" Environment="SQLANYDIR=/opt/sybase17/sybase17production" Environment="BIN=bin64" Environment="BITNESS=64" Environment="DBSVC_TYPE=network" Environment="SVC_TOOL_CMDLINE='-sb' '0' '-ec' 'SIMPLE' '-o' '/opt/database/messages.txt' '-os' '1m' '-oe' '/opt/database/errors.txt' '-x' 'TCPIP{PORT=40000}' '-n' 'servicename' '/opt/progeny/database/databasename.db' '-ud' '-ek' '1234567890' " ExecStartPre=/usr/bin/rm -f "/run/SA_/service\x2epid" ExecStopPost=/usr/bin/rm -f "/run/SA_/service\x2epid" ExecStart=/opt/sybase17/sybase17production/bin64s/dbsvc RUNSERVICECMD start [Install] WantedBy=multi-user.target ################################################# Looking forward to your help. |
What happens if you let it go ahead and "override" it? Does it fail with a different error message?
It does not fail. It just overrides my existing service running under /usr/lib/systemd/system/SA_.service
Does "dbsvc -l" list the existing service with its expected service name?
It does not. running './dbsvc -l' outputs the following:
"SQL Anywhere Service Utility 17.0.0.1062"
I tried running this in the past in hopes of checking if there were any existing services listed with the name "archive"...
You are using a very old v17 version (the initial release IIRC). According to the readme files of newer builds, several improvements and fixes have been made to dbsvc particularly on Linux, so you might try a newer EBF. Note, I do not know if this will help in your case...
Thanks Volker. I will go ahead and try newer version and report back my findings.