Hi all!
Does anybody know if there a way to use DNS alias when distributing reports from Visual Analytics.
I have set up VA-server with certificates using alias. When distributing reports from VA our recipients get mail including link that points to hostname, not alias. Leading to certificate error when trying to access report using emailed link.
Alias: report.ru.com
hostname: bs-ap-201.ru.com
Distributing reports with link pointing to bs-ap-201.ru.com, would like report.ru.com.
Version: Viya 3.5, Visual Analytics 8.5.1
Best Regards
SAS Technical Support was helpful and provided me with this solution:
# Check value of URL
. /opt/sas/viya/config/consul.conf
export CONSUL_HTTP_TOKEN=$(sudo cat /opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token)
/opt/sas/viya/home/bin/sas-bootstrap-config kv read --recurse config/application/sas.url.external.viya
# Set new value
. /opt/sas/viya/config/consul.conf
export CONSUL_HTTP_TOKEN=$(sudo cat /opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token)
/opt/sas/viya/home/bin/sas-bootstrap-config kv write --force --key config/application/sas.url.external.viya --value https://report.ru.com
# Restart reportdistribution
sudo systemctl stop sas-viya-reportdistribution-default
sudo systemctl start sas-viya-reportdistribution-default
Now it works!
Hello @viswmmo
this seems to me as an architectural mistake. SAS will always create reports using the URLs provided in the SAS deployment. If the alias is not defined in the SAS deployment itself, it might be an challenge in certain areas.
But not all is lost: perhaps there is an option to modify this parameter for the report distribution, within the SAS Environment Manager. I would suggest you contact SAS Technical Support for this subject. When you feel wiser, please share with us.
Best regards,
Juan
SAS Technical Support was helpful and provided me with this solution:
# Check value of URL
. /opt/sas/viya/config/consul.conf
export CONSUL_HTTP_TOKEN=$(sudo cat /opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token)
/opt/sas/viya/home/bin/sas-bootstrap-config kv read --recurse config/application/sas.url.external.viya
# Set new value
. /opt/sas/viya/config/consul.conf
export CONSUL_HTTP_TOKEN=$(sudo cat /opt/sas/viya/config/etc/SASSecurityCertificateFramework/tokens/consul/default/client.token)
/opt/sas/viya/home/bin/sas-bootstrap-config kv write --force --key config/application/sas.url.external.viya --value https://report.ru.com
# Restart reportdistribution
sudo systemctl stop sas-viya-reportdistribution-default
sudo systemctl start sas-viya-reportdistribution-default
Now it works!
Really good news, and thanks for sharing!
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.