Attendence System

[elliott0184]

Try pinging the server after you've got a connection, but before trying to make a cursor.  That way you can make sure the database is running and you're connected.  https://dev.mysql.com/doc/connector-pyth...-ping.html  

You could also skip the cursor and use the connection directly with .cmd_query(): https://dev.mysql.com/doc/connector-pyth...query.html

ok so i tried to ping the server and i still gives me a big error. NEW code

import time


import mysql.connector


from mysql.connector import errorcode


from datetime import datetime


try:
   cnx = mysql.connector.connect(user='root', password='password', database='staff', host='localhost')
   
except mysql.connector.Error as err:
   if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
       print("Something is wrong with your username or password")
   elif err.errno == errorcode.ER_BAD_DB_ERROR:
       print("Database does not exist")
   else:
       print(err)
else:
   cnx.close()


cnx.ping(attempts=1,delay=0)

Then i get the error

Error:
OSError                                   Traceback (most recent call last)
/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/network.py in send_plain(self, buf, packet_number)
   129                 else:
--> 130                     self.sock.sendall(packet)
   131             except IOError as err:

OSError: [Errno 9] Bad file descriptor

During handling of the above exception, another exception occurred:

OperationalError                          Traceback (most recent call last)
/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/connection.py in ping(self, reconnect, attempts, delay)
  1011         try:
-> 1012             self.cmd_ping()
  1013         except:

/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/connection.py in cmd_ping(self)
   874         """
--> 875         return self._handle_ok(self._send_cmd(ServerCmd.PING))
   876 

/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/connection.py in _send_cmd(self, command, argument, packet_number, packet, expect_response)
   503                 self._protocol.make_command(command, packet or argument),
--> 504                 packet_number)
   505         except AttributeError:

/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/network.py in send_plain(self, buf, packet_number)
   132                 raise errors.OperationalError(
--> 133                     errno=2055, values=(self.get_address(), _strioerror(err)))
   134             except AttributeError:
OperationalError: 2055: Lost connection to MySQL server at 'localhost:3306', system error: 9 Bad file descriptor

During handling of the above exception, another exception occurred:

InterfaceError                            Traceback (most recent call last)
<ipython-input-6-ee7505b13fb4> in <module>()
----> 1 cnx.ping(attempts=1,delay=0)

/home/Elliott/Documents/ana/lib/python3.5/site-packages/mysql/connector/connection.py in ping(self, reconnect, attempts, delay)
  1015                 self.reconnect(attempts=attempts, delay=delay)
  1016             else:
-> 1017                 raise errors.InterfaceError("Connection to MySQL is"
  1018                                             " not available.")
  1019 

InterfaceError: Connection to MySQL is not available.

Sorry for the big errors and for me being not very good at python. :) I have learned loads over the last few days and i thank you all for your help.