Jun-09-2020, 11:13 PM
Im getting an error "the machine refuses it" when running my script to write to a table
from pylogix import PLC
import sys
sys.path.append('..')
import time
import pymysql
with PLC() as comm:
comm.IPAddress = '172.21.12.10'
comm.ProcessorSlot = 0
ret = comm.GetPLCTime()
print( "Fecha y Hora de Registro Revision Fallas", ret.Value)
time.sleep(1)
Estacion = "D2R_030"
print("Connecting To Database")
connection = pymysql.connect(host='ACTWSLT01',
user='METALSA\satmslt',
password='T$m@l19*',
db='Python_PLC')
cursor = connection.cursor()
print("Connected")
#------------------------------------------------------------------------------------------ ESTACION D2R_030 -------------------------------------------------------------------------------#
print("INICIO DE REVISION ESTACION :" , Estacion)
#ACTUADOR 1
ACTUADOR = comm.Read('D2R_030.Status.Act._1.WBypassed')
ret = comm.GetPLCTime()
Numero_Act_EnBypass = 0
if ACTUADOR.Value == True:
Sensor = "ACTUADOR 1 WORK SENSOR EN BY PASS"
Numero_Act_EnBypass= (Numero_Act_EnBypass+1)
sql = "INSERT INTO 'PLC Actuadores' ('Id', 'IP', 'Date', 'Estacion', 'Tag', 'Value') VALUES (%s, %s, %s, %s, %s)"
cursor.execute(sql,(comm.IPAddress, ret.Value, Estacion, ACTUADOR, Sensor))
plc_data = plc_data.append(temp_dict.copy(), ignore_index=True)
plc_data.to_excel("Actuadores.xlsx", sheet_name='Result', index=False)
print(Sensor)
connection.commit()
else:
Sensor = "ACTUADOR 1 WORK OK"
print(Sensor)
comm._closeConnection
connection.close()
print("Terminado")Error:Traceback (most recent call last):
File "C:\Users\jsalass\AppData\Roaming\Python\Python38\site-packages\pymysql\connections.py", line 581, in connect
sock = socket.create_connection(
File "C:\Program Files (x86)\Python38-32\lib\socket.py", line 808, in create_connection
raise err
File "C:\Program Files (x86)\Python38-32\lib\socket.py", line 796, in create_connection
sock.connect(sa)
ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\jsalass\Desktop\Prueba SQL.py", line 23, in <module>
connection = pymysql.connect(host='ACTWSLT01',
File "C:\Users\jsalass\AppData\Roaming\Python\Python38\site-packages\pymysql\__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "C:\Users\jsalass\AppData\Roaming\Python\Python38\site-packages\pymysql\connections.py", line 325, in __init__
self.connect()
File "C:\Users\jsalass\AppData\Roaming\Python\Python38\site-packages\pymysql\connections.py", line 630, in connect
raise exc
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'ACTWSLT01' ([WinError 10061] No connection could be made because the target machine actively refused it)")