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.

asked 11 Dec '19, 09:46

Rcardona's gravatar image

Rcardona
414
accept rate: 0%

edited 11 Dec '19, 11:38

What happens if you let it go ahead and "override" it? Does it fail with a different error message?

(11 Dec '19, 10:13) Breck Carter

It does not fail. It just overrides my existing service running under /usr/lib/systemd/system/SA_.service

(11 Dec '19, 11:38) Rcardona
Replies hidden

Does "dbsvc -l" list the existing service with its expected service name?

(11 Dec '19, 12:19) Volker Barth

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"...

(11 Dec '19, 13:03) Rcardona
Replies hidden

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...

(11 Dec '19, 14:40) Volker Barth

Thanks Volker. I will go ahead and try newer version and report back my findings.

(11 Dec '19, 15:28) Rcardona
showing 4 of 6 show all flat view
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×153
×11

question asked: 11 Dec '19, 09:46

question was seen: 87 times

last updated: 11 Dec '19, 15:28