Extreme Networks

Jave · ‎05-11-2023

Hi,

Trying to access a distant SQL database from a workflow, I'm unable to import relevant python module. Is this natively possible or should I installed additionnal python module ? And if yes, how ? Older post talk about former XMC, but seems not to be effective in XIQ-SE.

Regards.

Jave

Robert_Haynes · ‎05-12-2023

Officially I do not think there is a means to import modules in either Python or Jython as used by XMC/XIQ-SE.

XMC/XIQ-SE includes python2.7/python3 command line interpreters but primarily uses Jython - a Java-based python interpreter for its GUI-based Python script executions.

While it's likely possible to tweak the system to use pip, etc to import modules for either I do not think formally this is supported.

To add formal support would be a product enhancement / feature request.

View solution in original post

Zdeněk_Pala · ‎05-14-2023

You may consider using the build-in driver. more details in the XIQ-SE licensing calculation workflow:

from com.ziclix.python.sql import zxJDBC

try:
    cnxn = zxJDBC.connect(url,emc_vars["dbUser"], emc_vars["dbPassword"], driver)
    mycursor = cnxn.cursor()
    mycursor.close()
    cnxn.close()
except:
    status = emc_results.Status;
    emc_results.setStatus( status.ERROR )
    emc_results.put("workflowMessage","MySQL Database access issue, check the password in Variables!")
    wf_error("MySQL Database access issue, check the password in Variables!")
else:
    wf_info("MySQL Database access OK.")

Regards Zdeněk Pala

View solution in original post

Zdeněk_Pala · 4 weeks ago

Hi,

If you replace the MySQL driver with PSQL driver you should be able to re-use majority of the workflow. basic SQL commands are the same for MySQL and PSQL...

from com.ziclix.python.sql import zxJDBC

# Try the DB connection and if it is not successful than stop

url = 'jdbc:postgresql://localhost:4589/netsight'  #URL with port and database name
driver = 'org.postgresql.Driver'
try:
    cnxn = zxJDBC.connect(url,emc_vars["dbUser"], emc_vars["dbPassword"], driver)
    mycursor = cnxn.cursor()
    mycursor.close()
    cnxn.close()
except:
    status = emc_results.Status;
    emc_results.setStatus( status.ERROR )
    emc_results.put("workflowMessage","Database access issue, check the password in Variables!")
else:
    print ("Database access OK.")

Regards Zdeněk Pala

View solution in original post

Robert_Haynes · ‎05-12-2023

See https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/xmc-and-python-install-addition...as this is a group provided script that essentially uses PIP within Jython to import modules. Modules must be Python 2.7 compatible.

... this is of course not GTAC supported

Extreme Networks

Adding a python module for XIQ-SE scripting and workflows

Adding a python module for XIQ-SE scripting and workflows