question

Jacob P. avatar image
Jacob P. asked ·

CAS/ADS Server Configuration Automation

Hello,

We are in the process of modifying some of our automation for DCRUM Installations and have hit a roadblock. Currently after installation is completed when a user navigates to the CAS through the web browser they are greeted with the Server Configuration screen:

serverconfig.png

We know what settings we want to implement and if we knew what configuration file these settings are made at, we could modify directly with our scripts to avoid this extra step. Please advise in what file we can make these changes and which properties/fields/parameters we would need to modify.

nam serverads
serverconfig.png (33.7 KiB)
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Krzysztof P. avatar image
Krzysztof P. answered ·

Hello,

I've prepared SQL queries which can be executed to set up automatically Configuration screen (restart is required):

1. Site options (AS - AS)

if exists (select * from RtmProps where propertyName = 'RtmJob.Step') update RtmProps set propertyValue = '0' where propertyName = 'RtmJob.Step' go

if exists (select * from RtmProps where propertyName = 'PCS_USE_AS') update RtmProps set propertyValue = '1' where propertyName = 'PCS_USE_AS' go if exists (select * from RtmProps where propertyName = 'PCS_USE_BGP') update RtmProps set propertyValue = '1' where propertyName = 'PCS_USE_BGP' go

2. User IP address ranges (example):

if exists (select * from RtmProps where propertyName = 'RtmJob.clientToName.0') update RtmProps set propertyValue = '167.207.1.1-167.207.1.9' where propertyName = 'RtmJob.clientToName.0' else insert into RtmProps (propertyName, propertyValue,BuildWhenUserChanged,DefValueForCurVer) values ('RtmJob.clientToName.0', '167.207.1.1-167.207.1.9', 2020114, '') go if exists (select * from RtmProps where propertyName = 'RtmJob.clientToName.1') update RtmProps set propertyValue = '167.207.1.11-167.207.1.255' where propertyName = 'RtmJob.clientToName.1' else insert into RtmProps (propertyName, propertyValue,BuildWhenUserChanged,DefValueForCurVer) values ('RtmJob.clientToName.1', '167.207.1.11-167.207.1.255', 2020114, '') go

3. PVU mode (with check box selected):

if exists (select * from RtmProps where propertyName = 'PCS_IGNORE_NAMES') update RtmProps set propertyValue = '1' where propertyName = 'PCS_IGNORE_NAMES' go if exists (select * from RtmProps where propertyName = 'PCS_IS_USER') update RtmProps set propertyValue = '1' where propertyName = 'PCS_IS_USER' go

4. ISP Extended:

if exists (select * from RtmProps where propertyName = 'IS_EXTENDED_ISP') update RtmProps set propertyValue = '1' where propertyName = 'IS_EXTENDED_ISP' go

If any other settings are needed, please answer to this post.

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

This is good, but what would be the properties, for the selections based on the screenshot below?

config.png

0 Likes 0 · ·
config.png (31.6 KiB)
Adam P. avatar image
Adam P. answered ·

So are you OK just with knowledge which options from this screen map to which properties in the DB?

4 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

If they are DB properties and not a configuration file, I'm not sure how well it will work, but yes I would like to know those properties.

0 Likes 0 · ·

Hi Adam, could you let us know what DB properties these are?

0 Likes 0 · ·

Working on this and will let you know.

1 Like 1 · ·

Thank you very much.

0 Likes 0 · ·
Krzysztof P. avatar image
Krzysztof P. answered ·

1. Site options (CIDR - CIDR)

if exists (select * from RtmProps where propertyName = 'RtmJob.Step')

update RtmProps set propertyValue = '0' where propertyName = 'RtmJob.Step' go

if exists (select * from RtmProps where propertyName = 'PCS_USE_AS')

update RtmProps set propertyValue = '0' where propertyName = 'PCS_USE_AS' go

if exists (select * from RtmProps where propertyName = 'PCS_USE_BGP')

update RtmProps set propertyValue = '1' where propertyName = 'PCS_USE_BGP' go

if exists (select * from RtmProps where propertyName = 'PCS_AGGREGATE_CIDR_AS')

update RtmProps set propertyValue = '1' where propertyName = 'PCS_AGGREGATE_CIDR_AS' go

2. User IP address ranges:

if exists (select * from RtmProps where propertyName = 'RtmJob.clientToName.0')

update RtmProps set propertyValue = '0.0.0.0-255.255.255.254' where propertyName = 'RtmJob.clientToName.0'

else

insert into RtmProps (propertyName, propertyValue,BuildWhenUserChanged,DefValueForCurVer) values ('RtmJob.clientToName.0', '0.0.0.0-255.255.255.254', 2020114, '')

go

3. Enable on-demand access

if exists (select * from RtmProps where propertyName = 'STORE_ON_DEMAND_STATS')

update RtmProps set propertyValue = '0' where propertyName = 'STORE_ON_DEMAND_STATS' go

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.