usnistgov / dane_tester

3 stars 1 forks source link

Can't connect to MySQL server #5

Open TheTesla opened 6 years ago

TheTesla commented 6 years ago

something went wrong again:

https://dane-test.had.dnsops.gov/server/dane_check.cgi?host=mymail.smartrns.net

''' Checking mymail.smartrns.net: --> -->

OperationalError Python 3.4.5: /usr/bin/python3 Sat Feb 17 18:54:29 2018 A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

/var/www/html/server/dane_check.cgi in () 83 print("Checking {0}:
".format(host)) 84 sys.stdout.flush() => 85 dane_checker.process(host,format='html') 86 sys.stdout.flush() 87 print("

Compare with dane.sys4.de

".format(host)) dane_checker = <module 'dane_checker' from '/var/www/dane-tester/server/dane_checker.py'>, dane_checker.process = , host = 'mymail.smartrns.net', builtin format = /var/www/dane-tester/server/dane_checker.py in process(domain='mymail.smartrns.net', format='html') 1303 ret = tlsa_https_verify(domain) 1304 else: => 1305 ret = tlsa_smtp_verify(domain) 1306 if ret[-1].passed==True: 1307 passed.append(domain) ret undefined, global tlsa_smtp_verify = , domain = 'mymail.smartrns.net' /var/www/dane-tester/server/dane_checker.py in tlsa_smtp_verify(destination_hostname='mymail.smartrns.net') 1154 ret = [] 1155 delivery_tlsa = [] => 1156 mx_data = dns_query_mx(destination_hostname) 1157 if not mx_data: 1158 ret += [ DaneTestResult(what='no MX record for {}'. mx_data undefined, global dns_query_mx = , destination_hostname = 'mymail.smartrns.net' /var/www/dane-tester/server/dane_checker.py in dns_query_mx(qname='mymail.smartrns.net') 960 961 def dns_query_mx(qname): => 962 return dns_query(qname,request_type=dns.rdatatype.MX) 963 964 def dns_query_cname(qname): global dns_query = , qname = 'mymail.smartrns.net', request_type undefined, global dns = <module 'dns' from '/usr/lib/python3.4/site-packages/dnspython-1.15.0-py3.4.egg/dns/init.py'>, dns.rdatatype = <module 'dns.rdatatype' from '/usr/lib/python3.4...ges/dnspython-1.15.0-py3.4.egg/dns/rdatatype.py'>, dns.rdatatype.MX = 15 /var/www/dane-tester/server/dane_checker.py in dns_query(qname='mymail.smartrns.net', request_type=15) 920 import dns.rdatatype 921 def dns_query(qname,request_type=dns.rdatatype.A): => 922 T = Tester() 923 T.newtest(testname="py.test") 924 response = dbdns.query(T,qname,request_type) T undefined, global Tester = <class 'tester.Tester'> /var/www/dane-tester/email/tester.py in init(self=, testid=None, rw=True) 68 sys.stderr.write(" MYSQL SERVER NOT RUNNING \n") 69 sys.stderr.write("****\n") => 70 raise e 71 72 # if testname is specified, create a new test e undefined /var/www/dane-tester/email/tester.py in init(self=, testid=None, rw=True) 63 password=sec.get("password"), 64 charset='utf8', => 65 db=sec.get("emaildb",DB_NAME)) 66 except pymysql.err.OperationalError as e: 67 sys.stderr.write("****\n") db undefined, sec = , sec.get = <bound method SectionProxy.get of >, global DB_NAME = 'emaildb' /usr/lib/python3.4/site-packages/pymysql/init.py in Connect(*args=(), *kwargs={'charset': 'utf8', 'db': 'emaildb', 'host': 'db1.antd.nist.gov', 'password': 'dbpassword++', 'user': 'dbwriter'}) 88 """ 89 from .connections import Connection => 90 return Connection(args, **kwargs) 91 92 from pymysql import connections as _orig_conn Connection = <class 'pymysql.connections.Connection'>, args = (), kwargs = {'charset': 'utf8', 'db': 'emaildb', 'host': 'db1.antd.nist.gov', 'password': 'dbpassword++', 'user': 'dbwriter'} /usr/lib/python3.4/site-packages/pymysql/connections.py in init(self=, host='db1.antd.nist.gov', user='dbwriter', password='dbpassword++', database='emaildb', port=0, unix_socket=None, charset='utf8', sql_mode=None, read_default_file=None, conv={0: <class 'decimal.Decimal'>, 1: <class 'int'>, 2: <class 'int'>, 3: <class 'int'>, 4: <class 'float'>, 5: <class 'float'>, 7: , <class 'NoneType'>: , 9: <class 'int'>, <class 'datetime.time'>: , ...}, use_unicode=True, client_flag=2728461, cursorclass=<class 'pymysql.cursors.Cursor'>, init_command=None, connect_timeout=None, ssl=None, read_default_group=None, compress=None, named_pipe=None, no_delay=None, autocommit=False, db='emaildb', passwd=None, local_infile=False, max_allowed_packet=16777216, defer_connect=False, auth_plugin_map={}, read_timeout=None, write_timeout=None) 688 self._sock = None 689 else: => 690 self.connect() 691 692 def _create_ssl_ctx(self, sslp): self = , self.connect = <bound method Connection.connect of > /usr/lib/python3.4/site-packages/pymysql/connections.py in connect(self=, sock=None) 937 exc.traceback = traceback.format_exc() 938 if DEBUG: print(exc.traceback) => 939 raise exc 940 941 # If e is neither DatabaseError or IOError, It's a bug. exc = OperationalError(2003, "Can't connect to MySQL s...ist.gov' ([Errno -2] Name or service not known)") OperationalError: (2003, "Can't connect to MySQL server on 'db1.antd.nist.gov' ([Errno -2] Name or service not known)") args = (2003, "Can't connect to MySQL server on 'db1.antd.nist.gov' ([Errno -2] Name or service not known)") original_exception = gaierror(-2, 'Name or service not known') traceback = 'Traceback (most recent call last):\n File "/usr/...t.gaierror: [Errno -2] Name or service not known\n' with_traceback =

'''

scottr-nist commented 6 years ago

For some reason the zone for the db went bogus. It needs to be resigned.