topic Re: Adding a python module for XIQ-SE scripting and workflows in ExtremeCloud IQ- Site Engine Management Center

Adding a python module for XIQ-SE scripting and workflows

Jave — Thu, 11 May 2023 13:13:24 GMT

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

Re: Adding a python module for XIQ-SE scripting and workflows

Robert_Haynes — Fri, 12 May 2023 13:39:54 GMT

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.

Re: Adding a python module for XIQ-SE scripting and workflows

Robert_Haynes — Fri, 12 May 2023 13:48:27 GMT

See https://community.extremenetworks.com/t5/extremecloud-iq-site-engine/xmc-and-python-install-additional-modules/m-p/35053 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

Re: Adding a python module for XIQ-SE scripting and workflows

Zdeněk_Pala — Mon, 15 May 2023 06:44:41 GMT

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.")

Re: Adding a python module for XIQ-SE scripting and workflows

Zdeněk_Pala — Mon, 15 May 2023 06:46:07 GMT

External SQL use example: Import credentials from MySQL to local repository

Re: Adding a python module for XIQ-SE scripting and workflows

Jave — Mon, 15 May 2023 12:32:44 GMT

Hi @Zdeněk_Pala ,

I had actually seen your workflow working through system calls but I was not aware of this built-in driver: thank you very much, it meets my needs !

Regards,

Jave

Re: Adding a python module for XIQ-SE scripting and workflows

Jave — Fri, 08 Nov 2024 12:37:27 GMT

Hi,

After upgrade to latest version of XIQ-SE, I have now this error for scripts using mysql JDBC driver:

driver [com.mysql.jdbc.Driver] not found

but it runs correctly using "org.postgresql.Driver".

How can I correct this ? Is it related to XIQ-SE database migration from mysql to postgres ?

Regards.

Re: Adding a python module for XIQ-SE scripting and workflows

Robert_Haynes — Fri, 08 Nov 2024 13:39:50 GMT

I would imagine so. All things MySQL are being removed as a result of the migration. Do you need mySQL for the purpose of the workflow since you've upgraded SE to 24.7+?

Re: Adding a python module for XIQ-SE scripting and workflows

Jave — Fri, 08 Nov 2024 14:16:19 GMT

Hi @Robert_Haynes

Yes. I have created a workflow which execute SQL request towards a MySQL database in order to retrieve provisionning's datas for a ZTP+ discovered device, like it's management IP and VLAN, it's name and many others parameters. This database is provisionned via a web interface by network administrators. If MySQL driver is not available anymore I would be forced to modify all my setup...

Regards.

Re: Adding a python module for XIQ-SE scripting and workflows

Zdeněk_Pala — Fri, 08 Nov 2024 17:55:27 GMT

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.")

Re: Adding a python module for XIQ-SE scripting and workflows

Jave — Fri, 08 Nov 2024 19:30:36 GMT

Hi @Zdeněk_Pala

I've already do that few hours ago, it works. I unfortunately had to rewrite my php code for the web application for provisioning the database in question. But no problem, everything works correctly now.

Regards.