The zoneip on the DB can be a domain?

[felipefalkiner]

I've tried using a domain/dns but it seems it does not work, I just need to update this everytime my external IP changes?

[Mortalelite]

If you having others join your server then it needs to be the Public IP. If your Public IP does change you will have to update the DB. You can use like Noip but still has to be numbers in the DB for the IP. I know Noip does have app that will update the IP to their servers so name does not change but you still have to go into the DB and update the zone ip.

Open server to public - External IP
Just you - 127.0.0.1 or Local IP

[felipefalkiner]

Makes sense! Thanks for the heads up, I do have a no-ip configured too but since on the DB needs to be the numbers, will not make a difference hahaha!

[anakistudio]

I have a solution for you if you are on Linux, as I'm in a similar 'boat'.. I don't have a static IP but it doesn't change often.
I wrote a script that gets your external IP and compares it to the existing one, updating the database if it changed.

#!/bin/bash

IP_FILE=/games/git/LandSandBoat/current_ip.txt

if [ ! -f "$IP_FILE" ]; then
        touch "$IP_FILE"
fi

CURRENT_IP=$(cat "$IP_FILE")
EXTERNAL_IP=$(dig +short myip.opendns.com @resolver1.opendns.com)

# Check if the IP was retrieved successfully
if [ -z "$EXTERNAL_IP" ]; then
        echo "Failed to retrieve external IP address."
        exit 1
fi

if [ "$CURRENT_IP" ] && [ "$EXTERNAL_IP" = "$CURRENT_IP" ]; then
        echo "No change to IP"
        exit 0
fi

#we made it this far, update the IP file, and the IP in the database.
echo $EXTERNAL_IP > "$IP_FILE"

mariadb -u root -D xidb -e "UPDATE zone_settings SET zoneip = '$EXTERNAL_IP'";

if [ $? -eq 0 ]; then
        echo "Successfully updated zone IPs to IP address $EXTERNAL_IP."
        exit 0
else
        echo "Failed to update the entry."
        exit 1
fi

you can add that script to your /etc/cron.hourly folder with the correct permissions, and be worry-free; you can change the timescale if you want by using crontab or a different cron folder.

[felipefalkiner]

Hey! Nice solution!
Thanks for sharing! ♥