Process Query Language (PQL) is a special-purpose programming language for managing process models based on information about process instances that these models describe. PQL is based upon temporal logic and adopts the concrete syntax of SQL.
________ ________ ___
|\ __ \ |\ __ \ |\ \
\ \ \|\ \\ \ \|\ \\ \ \
\ \ ____\\ \ \\\ \\ \ \
\ \ \___| \ \ \\\ \\ \ \____
\ \__\ \ \_____ \\ \_______\
\|__| \|___| \__\\|_______|
\|__|
www.processquerying.com
Process Query Language (PQL) is a special-purpose programming language for managing process models based on information about process instances that these models describe. PQL is based upon temporal logic and adopts the concrete syntax of SQL.
--------------------
SYSTEM REQUIREMENTS
--------------------
1. MySQL 5.7.8+
2. Java 7
--------------------
TESTED ENVIRONMENTS
--------------------
PQL-1.3: macOS Mojave version 10.14.1; JRE 1.8.0_144; MySQL Community server Ver 5.7.24 for MacOS
PQL-1.3: Windows 10 Education (64-bit); JRE 1.8.0_171; MySQL Ver 14.14 Distrib 5.7.24, for Win64 (x86_64)
PQL-1.2: Windows 10 Education (64-bit); JRE 1.8.0_171; MySQL Ver 14.14 Distrib 5.7.24, for Win64 (x86_64)
PQL-X.Y refers to the corresponding PQL release published at https://github.com/processquerying/PQL/tree/master/release.
-------------------------
INSTALLATION INSTRUCTIONS
-------------------------
1. Download latest PQL release from https://github.com/processquerying/PQL/tree/master/release.
2. Install supplied PQL.MySQL-*.sql schema file.
3. Update MySQL URL, user, and password parameters in PQL.ini.
4. Start using PQL by following the supplied examples!
------------
PUBLICATIONS
------------
1. Polyvyanyy, Artem; ter Hofstede, Arthur H. M.; Marcello, La Rosa; Ouyang, Chun; Pika, Anastasiia (2019). "Process Query Language: Design, Implementation, and Evaluation". arXiv:[1909.09543](https://arxiv.org/abs/1909.09543)
---------------
FRIEND PROJECTS
---------------
1. The jBPT Library (https://github.com/jbpt/codebase) provides many useful functionalities to
the PQL tool.
2. Apromore process model repository (https://github.com/apromore/ApromoreCode) integrates the PQL tool,
refer to the custom installation instructions in the README file of the Apromore project. A screencast
on using PQL in Apromore is available here: https://www.youtube.com/watch?v=S_U6frTWd3M.
I have followed the instruction for running the PQL. After installing MySQL and configure the pql_master user and password. I encountered the below error. Even I try to grant permission, the problem still exists. Could you please help me? Thank you very much
MySQL Shell granting access.
MySQL SQL > \connect pql_master@localhost
Creating a session to 'pql_master@localhost'
Fetching schema names for autocompletion... Press ^C to stop.
Your MySQL connection id is 62
Server version: 5.7.28-log MySQL Community Server (GPL)
No default schema selected; type \use to set one.
MySQL localhost:3306 ssl SQL > \use pql
Default schema set to pql.
Fetching table and column names from pql for auto-completion... Press ^C to stop.
MySQL localhost:3306 ssl pql SQL > grant all on . to 'pql_master'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.0006 sec)
Warning (code 1287): Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement.
MySQL localhost:3306 ssl pql SQL > flush privileges;
Query OK, 0 rows affected (0.0020 sec)
MySQL localhost:3306 ssl pql SQL > show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| pql |
| sys |
+--------------------+
5 rows in set (0.0006 sec)
MySQL localhost:3306 ssl pql SQL >
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: java.sql.SQLException: Access denied for user 'pql_master'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1709)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1252)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jbpt.persist.MySQLConnection.connect(MySQLConnection.java:63)
at org.jbpt.persist.MySQLConnection.(MySQLConnection.java:29)
at org.pql.bot.PQLBotCLI.main(PQLBotCLI.java:98)
... 5 more