Gets your current external IP and stores it in a DB. Sends a pushover notification when it changes. Designed to be used as a cron job

ipget.py

#! /usr/bin/python3
import sys, os, ipaddress, sqlite3, requests
from tabulate import tabulate #you can download tabulate via pip install

DATABASE_FILE = 'FILE_LOCATION_HERE'

DATABASE_EXISTS = os.path.isfile(DATABASE_FILE)

MESSAGE = 'Script ran successfully. A message should appear here every hour.'

IP_CHANGED = 'False'

TABLE_CREATION_SCRIPT = 'CREATE TABLE ip_address \
    (ip_address text,\
    provider text, \
    date text\
    )'

TABLE_ERROR_CREATION_SCRIPT = 'CREATE TABLE error_log \
    (provider text, \
    date text\
    )'

TABLE_LOG_CREATION_SCRIPT = 'CREATE TABLE run_log \
    (message text, \
    ip_changed text,\
    date text\
    )'

TABLE_INSERTION_SCRIPT = "INSERT INTO ip_address VALUES (?,?,datetime('now','localtime'))"

TABLE_ERROR_INSERTION_SCRIPT = "INSERT INTO error_log VALUES (?,datetime('now','localtime'))"   

TABLE_LOG_INSERTION_SCRIPT = "INSERT INTO run_log VALUES (?,?, datetime('now','localtime'))"   

TABLE_SELECTION_SCRIPT = 'select ip_address, max(date) from ip_address'

TABLE_LOG_SELECTION_SCRIPT = 'select ip_changed, date from run_log WHERE [date] >= date("now", "-1 days") order by date asc'   

TABLE_ERROR_SELECTION_SCRIPT = 'select provider, date from error_log WHERE [date] >= date("now", "-1 days") order by date asc'   

conn = sqlite3.connect(DATABASE_FILE)
c = conn.cursor()

dig_commands = [
{'server': 'Open DNS Resolver 1', 'command': 'dig +short myip.opendns.com @resolver1.opendns.com'},
{'server': 'Open DNS Resolver 2', 'command': 'dig +short myip.opendns.com @resolver2.opendns.com'},
{'server': 'Open DNS Resolver 3', 'command': 'dig +short myip.opendns.com @resolver3.opendns.com'},
{'server': 'Open DNS Resolver 4', 'command': 'dig +short myip.opendns.com @resolver4.opendns.com'},
{'server': 'Google', 'command': 'dig @ns1.google.com TXT o-o.myaddr.l.google.com +short'}
]

# pushover stuff below

USER_TOKEN = 'USER_TOKEN_HERE'
APP_TOKEN = 'APP_TOKEN_HERE'

def send_pushover_notification(title, message, priority='1'):
    data = {'token': APP_TOKEN, 'user': USER_TOKEN, 'title': title, 'message': message, 'priority': priority}
    r = requests.post('https://api.pushover.net/1/messages.json', data=data, headers={'User-Agent': 'Python'})

# pushover stuff above

def create_database():
    c.execute(TABLE_CREATION_SCRIPT)
    c.execute(TABLE_ERROR_CREATION_SCRIPT)
    c.execute(TABLE_LOG_CREATION_SCRIPT)
    conn.commit()

def insert_data(script, values):
    c.execute(script, values)
    conn.commit()

def get_latest_recorded_ip():
    c.execute(TABLE_SELECTION_SCRIPT)
    fetched = c.fetchall()[0]
    return fetched[0]

def print_latest_recorded_ip():
    print("Your current IP address is: {}".format(get_latest_recorded_ip()))

def get_ip_address():
    for dig in dig_commands:
        try:
            ip = os.popen(dig['command']+ " 2> /dev/null").read().strip()
            ip = ip.replace('"',"")
            ipaddress.ip_address(ip)
            return (ip, dig['server'])
        except ValueError:
            insert_data(TABLE_ERROR_INSERTION_SCRIPT, tuple([dig['server']]))

    send_pushover_notification("SERVER_NAME_HERE", "Unable to get IP from any providers")
    return tuple(['FAILURE'])

def print_logs():
    print_latest_recorded_ip()
    print()
    c.execute(TABLE_LOG_SELECTION_SCRIPT)
    fetched = c.fetchall()
    print("### Run Log ###\n")
    print(tabulate(fetched, ['IP Changed', 'Date & Time of Check']))
    c.execute(TABLE_ERROR_SELECTION_SCRIPT)
    fetched = c.fetchall()
    if len(fetched) > 0:
        print("### Error Log ###\n")
        print(tabulate(fetched, ['Server', 'Date & Time of Error']))

if len(sys.argv) > 1:
    if sys.argv[1].lower() == 'show':
        print_latest_recorded_ip()
        exit()
    if sys.argv[1].lower() == 'log':
        print_logs()
        exit()

if DATABASE_EXISTS:
    values = get_ip_address()
    if values[0] != 'FAILURE' and values[0] != get_latest_recorded_ip():
        IP_CHANGED = 'True'
        insert_data(TABLE_INSERTION_SCRIPT, values)
        send_pushover_notification("SERVER_NAME_HERE: IP Updated", "IP Address is now: {}".format(values[0]))
else:
    create_database()
    values = get_ip_address()
    if values[0] != 'FAILURE':
        IP_CHANGED = 'True'
        insert_data(TABLE_INSERTION_SCRIPT, values)
        send_pushover_notification("SERVER_NAME_HERE: IP Updated", "IP Address is now: {}".format(values[0]))

insert_data(TABLE_LOG_INSERTION_SCRIPT, (MESSAGE,IP_CHANGED))

conn.close()

Created a file called ip.db and put that in the script. They are in the same folder. Get this error:

Traceback (most recent call last):
  File "/media/william/NewData/docker-info/run/getipchange.py", line 118, in <module>
    if values[0] != 'FAILURE' and values[0] != get_latest_recorded_ip():
  File "/media/william/NewData/docker-info/run/getipchange.py", line 75, in get_latest_recorded_ip
    c.execute(TABLE_SELECTION_SCRIPT)
sqlite3.OperationalError: no such table: ip_address

Managed to get it working via Chatai, Added commandline flag --test-pushover to be able to test if that is working,

import sys
import os
import ipaddress
import sqlite3
import requests
from tabulate import tabulate

DATABASE_FILE = 'ip.db'

DATABASE_EXISTS = os.path.isfile(DATABASE_FILE)

MESSAGE = 'Script ran successfully. A message should appear here every hour.'

IP_CHANGED = 'False'

TABLE_CREATION_SCRIPT = 'CREATE TABLE ip_address \
    (ip_address text,\
    provider text, \
    date text\
    )'

TABLE_ERROR_CREATION_SCRIPT = 'CREATE TABLE error_log \
    (provider text, \
    date text\
    )'

TABLE_LOG_CREATION_SCRIPT = 'CREATE TABLE run_log \
    (message text, \
    ip_changed text,\
    date text\
    )'

TABLE_INSERTION_SCRIPT = "INSERT INTO ip_address VALUES (?,?,datetime('now','localtime'))"

TABLE_ERROR_INSERTION_SCRIPT = "INSERT INTO error_log VALUES (?,datetime('now','localtime'))"

TABLE_LOG_INSERTION_SCRIPT = "INSERT INTO run_log VALUES (?,?, datetime('now','localtime'))"

TABLE_SELECTION_SCRIPT = 'select ip_address, max(date) from ip_address'

TABLE_LOG_SELECTION_SCRIPT = 'select ip_changed, date from run_log WHERE [date] >= date("now", "-1 days") order by date asc'

TABLE_ERROR_SELECTION_SCRIPT = 'select provider, date from error_log WHERE [date] >= date("now", "-1 days") order by date asc'

conn = sqlite3.connect(DATABASE_FILE)
c = conn.cursor()

dig_commands = [
    {'server': 'Open DNS Resolver 1', 'command': 'dig +short myip.opendns.com @resolver1.opendns.com'},
    {'server': 'Open DNS Resolver 2', 'command': 'dig +short myip.opendns.com @resolver2.opendns.com'},
    {'server': 'Open DNS Resolver 3', 'command': 'dig +short myip.opendns.com @resolver3.opendns.com'},
    {'server': 'Open DNS Resolver 4', 'command': 'dig +short myip.opendns.com @resolver4.opendns.com'},
    {'server': 'Google', 'command': 'dig @ns1.google.com TXT o-o.myaddr.l.google.com +short'}
]

USER_TOKEN = 'changethis'
APP_TOKEN = 'changethistoo'

def send_pushover_notification(title, message, priority='1'):
    data = {'token': APP_TOKEN, 'user': USER_TOKEN, 'title': title, 'message': message, 'priority': priority}
    r = requests.post('https://api.pushover.net/1/messages.json', data=data, headers={'User-Agent': 'Python'})

def create_database():
    # Check if the ip_address table already exists
    c.execute("SELECT name FROM sqlite_master WHERE type='table' AND name='ip_address'")
    table_exists = c.fetchone()

    if not table_exists:
        c.execute(TABLE_CREATION_SCRIPT)
        c.execute(TABLE_ERROR_CREATION_SCRIPT)
        c.execute(TABLE_LOG_CREATION_SCRIPT)
        conn.commit()
    else:
        print("Tables already exist. Skipping creation.")

def insert_data(script, values):
    print("Inserting data:", values)  # Add this line to debug
    c.execute(script, values)
    conn.commit()

def get_latest_recorded_ip():
    c.execute(TABLE_SELECTION_SCRIPT)
    fetched = c.fetchall()[0]
    return fetched[0]

def print_latest_recorded_ip():
    print("Your current IP address is: {}".format(get_latest_recorded_ip()))

def get_ip_address():
    for dig in dig_commands:
        try:
            ip = os.popen(dig['command'] + " 2> /dev/null").read().strip()
            ip = ip.replace('"', "")
            ipaddress.ip_address(ip)
            print("IP and server obtained:", ip, dig['server'])  # Add this line to debug
            return (ip, dig['server'])
        except ValueError:
            insert_data(TABLE_ERROR_INSERTION_SCRIPT, tuple([dig['server']]))

    send_pushover_notification("SERVER_NAME_HERE", "Unable to get IP from any providers")
    return tuple(['FAILURE'])

def print_logs():
    print_latest_recorded_ip()
    print()
    c.execute(TABLE_LOG_SELECTION_SCRIPT)
    fetched = c.fetchall()
    print("### Run Log ###\n")
    print(tabulate(fetched, ['IP Changed', 'Date & Time of Check']))
    c.execute(TABLE_ERROR_SELECTION_SCRIPT)
    fetched = c.fetchall()
    if len(fetched) > 0:
        print("### Error Log ###\n")
        print(tabulate(fetched, ['Server', 'Date & Time of Error']))

if __name__ == "__main__":
    create_database()  # Always create the database and tables

    if "--test-pushover" in sys.argv:
        send_pushover_notification("Test Notification", "This is a test notification for Pushover")
        sys.exit()

    values = get_ip_address()
    print("Retrieved values:", values)  # Add this line to debug

    if values[0] != 'FAILURE' and values[0] != get_latest_recorded_ip():
        print("IP has changed. New IP:", values[0])  # Add this line to debug
        IP_CHANGED = 'True'
        insert_data(TABLE_INSERTION_SCRIPT, values)
        send_pushover_notification("SERVER_NAME_HERE: IP Updated", "IP Address is now: {}".format(values[0]))
    else:
        print("IP has not changed. Latest IP:", get_latest_recorded_ip())  # Add this line to debug

    insert_data(TABLE_LOG_INSERTION_SCRIPT, (MESSAGE, IP_CHANGED))

    conn.close()

Created a file called ip.db and put that in the script. They are in the same folder. Get this error:

Traceback (most recent call last):
  File "/media/william/NewData/docker-info/run/getipchange.py", line 118, in <module>
    if values[0] != 'FAILURE' and values[0] != get_latest_recorded_ip():
  File "/media/william/NewData/docker-info/run/getipchange.py", line 75, in get_latest_recorded_ip
    c.execute(TABLE_SELECTION_SCRIPT)
sqlite3.OperationalError: no such table: ip_address

Been a while since I used this, but it checks to see if a database exists and if it doesn't it creates it along with the necessary schema (at least that's how it should work). If you created a database it assumes it has the schema already which is why it errors out. If you try running it without the db it should create it and work. All you need to do is give it a filename to use/check for.

In any case, glad it's of some help to someone other than myself :)

Didn't think of that. This changedversion will now write the db, if the file exists but hasn't had a db written to it yet. Thanks for the script.