- If you intend to stop and start the VM, you may want to add Vantage Express to autostart. ssh to your VM and run the following commands:
sudo -i
cat <<EOF >> /etc/default/virtualbox
VBOXAUTOSTART_DB=/etc/vbox
VBOXAUTOSTART_CONFIG=/etc/vbox/autostart.cfg
EOF
cat <<EOF > /etc/systemd/system/vantage-express.service
[Unit]
Description=vm1
After=network.target virtualbox.service
Before=runlevel2.target shutdown.target
[Service]
User=root
Group=root
Type=forking
Restart=no
TimeoutSec=5min
IgnoreSIGPIPE=no
KillMode=process
GuessMainPID=no
RemainAfterExit=yes
ExecStart=/usr/bin/VBoxManage startvm vantage-express --type headless
ExecStop=/usr/bin/VBoxManage controlvm vantage-express savestate
[Install]
WantedBy=multi-user.target
EOF
systemctl daemon-reload
systemctl enable vantage-express
systemctl start vantage-express
- If you would like to connect to Vantage Express from the Internet, you will need to open up firewall holes to your VM. You should also change the default password to
dbcuser: -
To change the password for
dbcuser go to your VM and start bteq:bteq -
Login to your database using
dbcas username and password:.logon localhost/dbc -
Change the password for
dbcuser:MODIFY USER dbc AS PASSWORD = new_password; -
You can now open up port 1025 to the internet:
aws ec2 authorize-security-group-ingress \ --group-id $AWS_CUSTOM_SECURITY_GROUP_ID \ --ip-permissions '[{"IpProtocol": "tcp", "FromPort": 1025, "ToPort": 1025, "IpRanges": [{"CidrIp": "0.0.0.0/0", "Description": "Allow Teradata port"}]}]'