summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rwxr-xr-x.scripts/datamgmt.py101
1 files changed, 0 insertions, 101 deletions
diff --git a/.scripts/datamgmt.py b/.scripts/datamgmt.py
deleted file mode 100755
index 0d8f056d..00000000
--- a/.scripts/datamgmt.py
+++ /dev/null
@@ -1,101 +0,0 @@
-#!/usr/bin/python2
-import sqlite3
-import os, sys
-
-def create_db(netname):
- conn = sqlite3.connect("/etc/tinc/"+ netname + "/hosts.sqlite")
- db = conn.cursor()
- db.execute('''create table hosts(hostname text, subnet text, address text, port text, r_pub text, t_pub text)''')
- conn.commit()
- db.close()
-
-def PubInDb(netname, hostname):
- pubfile = open("/etc/tinc/" + netname + "/hosts/.pubkeys/" + hostname, "r")
- publines = pubfile.readlines()
- pubfile.close()
- pubkey = ""
- for i in range(len(publines)):
- pubkey += publines[i]
- print(pubkey)
- conn = sqlite3.connect("/etc/tinc/" + netname + "/hosts.sqlite")
- c = conn.cursor()
- tupel = [pubkey, hostname]
- c.execute('UPDATE hosts SET r_pub=? WHERE hostname=?', tupel)
- conn.commit()
- c.close()
-
-def HostInDb(netname, hostname):
- hostFile = open("/etc/tinc/"+ netname + "/hosts/" + hostname, "r")
- hostlines = hostFile.readlines()
- hostFile.close()
- conn = sqlite3.connect("/etc/tinc/"+ netname + "/hosts.sqlite")
- db = conn.cursor()
-
- lines = 0
- Subnet = ""
- Tinc_pub_key = ""
- Address = "#Address = none\n"
- Port = "Port = 655\n"
- while lines < len(hostlines):
- if hostlines[lines][0:4] == "Addr":
- Address = hostlines[lines]
- print Address
- if hostlines[lines][0:4] == "Subn":
- Subnet = hostlines[lines]
- print Subnet
- if hostlines[lines][0:4] == "Port":
- Port = hostlines[lines]
- print Port
- if hostlines[lines][0:10] == "-----BEGIN":
- Tinc_pub_key_array = hostlines[lines:lines+8]
- line = 0
- Tinc_pub_key = ""
- while line < len(Tinc_pub_key_array):
- Tinc_pub_key += Tinc_pub_key_array[line]
- line += 1
- print Tinc_pub_key
- lines += 1
- if not(Subnet == "" or Tinc_pub_key == ""):
- tupel = (hostname, Subnet, Address, Port, Tinc_pub_key )
- conn = sqlite3.connect("/etc/tinc/"+ netname + "/hosts.sqlite")
- db = conn.cursor()
- db.execute('insert into hosts values(?,?,?,?,"none",?)', tupel)
- conn.commit()
- db.close()
-
-def ShowDb(netname):
- conn = sqlite3.connect("/etc/tinc/" + netname + "/hosts.sqlite")
- db = conn.cursor()
- db.execute("select * from hosts")
- for hosts in db:
- for i in range(len(hosts)):
- print hosts[i]
- db.close
-
-def DirInDb(netname):
- #the normal tinc files are read into the sqlite
- files = os.listdir("/etc/tinc/" + netname + "/hosts/")
- file_n = 0
- while file_n < len(files):
- if files[file_n][0] == ".":
- files.remove(files[file_n])
- file_n -= 1
- file_n += 1
- for filename in files:
- HostInDb(netname, filename)
- #the pubkeys are included into the sqlite
- pubfiles = os.listdir("/etc/tinc/" + netname + "/hosts/.pubkeys/")
- for pubname in pubfiles:
- PubInDb(netname, pubname)
-
-
-#Program start here
-netname = sys.argv[1]
-
-try:
- os.remove("/etc/tinc/" + netname + "/hosts.sqlite")
-except:
- print("no hosts.sqlite found")
-
-create_db(netname)
-DirInDb(netname)