'Real' Shell Access to modify config-Files (edit Dyndns-Settings)

Question

I must quickly migrate from UTM 9 to XG because my private network (3 families) exceeds the limit of 50 devices (handys for the Kids ... :-) To reach my homenet from the outside is (unfortunately ;-) a core-requirement of my family and we can't get a static IP from my provider. 
 The new firewall has no DynDNS-Support for my (free) DynDNS provider selfhost.eu, but the Protocoll is DynDNS.org-kompatible, which is directly supported in the dropdownbox. 
 I thought it must be possible to change the service-url for the ip-update in a config-file. So I found an old post, which adresses this problem and someone wrote (for UTM9): "Modify /var/confd/res/dyndns/features.ph to change URI from DynDNS directly" 
 But in the console of the new XG I can only choose predefined commands and can't edit and navigate the underlying filesystem (except using a hard-disk editor and change the bits directly). 
 Can somebody give me a tip, how I can solve this problem? (e.g. free console-acess or another workaround to modify the right config file in the new UTM version) 
 (Loosing support / warranty for the whole system after file-modification is no big problem for me, because it's a private license at home and nobody dies when something goes wrong ... :-)

MarkusArndt · Accepted Answer

I solved the Problem myself and it works with selfhost.eu now: 
 
- Logon to Sophos XG via Putty 
- Select 5 and 3 for Console (Thanks to lferrara!) 
- List all Dyndns-Provider with command 
 psql -U nobody -d corporate -c "select * from tblddnsserviceprovider" 
- The Entry with ID 1 is Provider 'Dyndns' with Protokoll 'dyndns2' and the korrekt Provider-URL 
- My free Dyndns-Provider, selfhost.eu, offers the same Protocoll dyndns2 with his own Update-URL (= carol.selfhost.de) 
- I upgraded the URL with the folowing command: 
 psql -U nobody -d corporate -c "update tblddnsserviceprovider set serverstring = 'carol.selfhost.de' where serviceproviderid=1" 
- I restarted the XG but I don't know, if it's really necressary. 
- I added Dyndns-Config for Provider "Dyndns" in the WebConsole with HostName and Credetials from selfhost.eu. 
 
After Reconnecting the WAN-Interface (DSL/PPPoE) the Sophos sucessully upgrades the Public IP at selfhost!! :-) 
 
( 
At first I try to insert an own entry in the table tblddnsserviceprovider but this was a bad idea. The Dyndns-client-Service from XG-OS went "red" and doesn't start anymore!?? To get it working again I and dropped my new entry. 
Unfortunally I can't update or delete Dyndns-Lines in WebConsole after this try. After deleting the Account via database 
	psql -U nobody -d corporate -c "delete from tblddnsaccountdetail" 
the client-process starts without problems, when I restarted the XG. 
So - no warranty for not destroying your Database ... :-) 
) 
 
But when you only upgrade the URL from an existing Provider-Entry the risik is very small I think. 
 
This hack will surly work with many other Dyndns-Providers, when they offer the dyndns2-Protokoll to update the IP.

FloSupport · Answer

Hey Mr.Roboto 
 Unfortunately some manual config-file changes are reset or overwritten during regular operation. 
 We do have a KB article for integrating Sophos XG Firewall with third party Dynamic DNS service providers through the GUI. 
 Best,