Hello.

I'm trying to make working a custom trigger.

I want to save the id of the request into a mysql server when the request status change to Resolved.

The script is in python (3.5.2) and this is my code,

3. import pymysql.cursors
4. import sys
5. 
   
6. # Connect to the database
7. connection = pymysql.connect(host='192.168.1.120',
8.                              user='root',
9.                              password='root',
10.                              db='idsdb',
11.                              cursorclass=pymysql.cursors.DictCursor)
12. 
    
13. try:
14.     with connection.cursor() as cursor:
15.         # Create a new record
16.         sql = "INSERT INTO `datos` (`id`) VALUES (%s)"
17.         cursor.execute(sql, (str(sys.argv[1])))
18. 
    
19.     # connection is not autocommit by default. So you must commit to save
20.     # your changes.
21.     connection.commit()
22. 
    
23. finally:
24.     connection.close()

When I execute the script form the cmd of windows like this "python sos.py 2333", the data is inserted.

But with the Custom Trigger dosn´t work.

my script is in the next path "C:\ManageEngine\ServiceDesk\integration\custom_scripts\sos.py"

and this is my custom trigger configuration

What i´m doing wrong??