Dear OpenL Tablets Team,
I am trying to install OpenL Tablets on a Linux (+mariadb) or Windows (+mysql) server in a multiuser mode. To no avail.
The third screen referred in the Installation Guide (Release 5.19) for the WebStudio Installation Wizard is different from the one I see (see picture). And I do not know what to do with the second screen (see picture).
Thanks for your help
Andre
Unfortunately, User Guides are slightly out of date - this is a known issue and we are working on updating.
Regarding screen 2: To configure Design and Deployment (Production) repositories proceed according to Section 3.5 - Setting Up OpenL Tablets WebStudio with InstallationWizard of Installation Guide..
Regarding Screen 3
Could you please provide more details by answering the following questions:
1. Is appropriate jdbc driver added to lib?
2. Does "root" user have permission to connect to db from external source? You can check it by connecting to the database via another DB application
3. Is correct port specified?
4. Is "openl" database created? OpenL doesn't create is automatically.
5. What version of maria DB do you use?
Best Regards,
Alena
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Regarding Screen 2.
I created both repositories as local with no secure connection. Is it ok?
Regarding Screen 3
Could you please provide more details by answering the following questions:
1. Is appropriate jdbc driver added to lib?
yes
2. Does "root" user have permission to connect to db from external source? You can check it by connecting to the database via another DB application
yes
3. Is correct port specified?
yes
4. Is "openl" database created? OpenL doesn't create is automatically.
yes
5. What version of maria DB do you use?
10
Best Regards,
Andre
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello Alena,
Unfortunately, I cannot install a newer version of MariaDB on this Linux server. We thus shifted to a windows server. But I am blocked exactly at the same level with the same error message although all conditions you mentioned before are fulfilled. I am desesperate!
Best regards
Andre
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Could you attach full log files with errors? If you are using Tomcat, then it will catalina.out and webstudio.log. If by some reason it is impossible, then could you describe your environment as accurate as possible (OpenL version, JDBC driver name and version, Database name and version, OS name and version, Java name and version and etc.)
Currently, OpenL is tested on MariaDB docker image v10.2 and v10.3. And OpenL WebStudio does not use some DB specific configuration and it should work with earler version. But to investigate your issue I need more information to understant what happened.
Regards,
Yury.
Last edit: OpenL Tablets 2018-08-23
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am facing the same issue. I have Oracle Linux 9 with OpenL-Tablets 5.26.11 which I am installing on Tomcat 9.0.80 with JDK 20.0.2 and MariaDB 10.10. The message I get is:
Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: MariaDB 10.10
at org.flywaydb.core.internal.dbsupport.DbSupportFactory.createDbSupport(DbSupportFactory.java:151) ~[flyway-core-4.2.0.1.jar:?]
at org.flywaydb.core.Flyway.execute(Flyway.java:1420) ~[flyway-core-4.2.0.1.jar:?]
at org.flywaydb.core.Flyway.migrate(Flyway.java:971) ~[flyway-core-4.2.0.1.jar:?]
at org.openl.rules.security.standalone.DBMigrationBean.init(DBMigrationBean.java:46) ~[org.openl.security.standalone-5.26.11.jar:5.26.11]
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:578) ~[?:?]
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Could you please let us know which version of the MariaDB connector you are currently using? I'd like to bring to your attention some important compatibility notes:
JDK Support: OpenL 26.11 is compatible with JDK 11. Further details can be found on the OpenL Supported Platforms page.
JDBC Connection URL: For MariaDB, the JDBC connection URL format is
jdbc:mysql://[host][:port]/[schema].
This information is available in the Installation Guide on page 24.
Additional Recommendation:
We encourage you to post any questions or issues you may have on the OpenL Tablets GitHub Discussions page.
Best regards,
Alena Kosolapova
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear OpenL Tablets Team,
I am trying to install OpenL Tablets on a Linux (+mariadb) or Windows (+mysql) server in a multiuser mode. To no avail.
The third screen referred in the Installation Guide (Release 5.19) for the WebStudio Installation Wizard is different from the one I see (see picture). And I do not know what to do with the second screen (see picture).
Thanks for your help
Andre
Last edit: Andre Renard 2018-08-17
Hello Andre,
Unfortunately, User Guides are slightly out of date - this is a known issue and we are working on updating.
Regarding screen 2: To configure Design and Deployment (Production) repositories proceed according to Section 3.5 - Setting Up OpenL Tablets WebStudio with InstallationWizard of Installation Guide..
Regarding Screen 3
Could you please provide more details by answering the following questions:
1. Is appropriate jdbc driver added to lib?
2. Does "root" user have permission to connect to db from external source? You can check it by connecting to the database via another DB application
3. Is correct port specified?
4. Is "openl" database created? OpenL doesn't create is automatically.
5. What version of maria DB do you use?
Best Regards,
Alena
Hi Alena,
Thanks for your answer.
Regarding Screen 2.
I created both repositories as local with no secure connection. Is it ok?
Regarding Screen 3
Could you please provide more details by answering the following questions:
1. Is appropriate jdbc driver added to lib?
Best Regards,
Andre
Hello Andre,
Regarding Screen 2
Yes, it is ok for local repositories
Regarding Screen 3
Unfortunately, MariaDB version 10 is not supported. Supported versions are 10.2+. See http://openl-tablets.org/supported-platforms for more details.
Could you please attach an application log ( webstudio.log, and catalina.log if you use Tomacat), for investigation.
Thak you!
Best Regards,
Alena.
Last edit: OpenL Tablets 2018-08-23
Hello Alena,
Unfortunately, I cannot install a newer version of MariaDB on this Linux server. We thus shifted to a windows server. But I am blocked exactly at the same level with the same error message although all conditions you mentioned before are fulfilled. I am desesperate!
Best regards
Andre
Hi Andre,
Could you attach full log files with errors? If you are using Tomcat, then it will catalina.out and webstudio.log. If by some reason it is impossible, then could you describe your environment as accurate as possible (OpenL version, JDBC driver name and version, Database name and version, OS name and version, Java name and version and etc.)
Currently, OpenL is tested on MariaDB docker image v10.2 and v10.3. And OpenL WebStudio does not use some DB specific configuration and it should work with earler version. But to investigate your issue I need more information to understant what happened.
Regards,
Yury.
Last edit: OpenL Tablets 2018-08-23
I am facing the same issue. I have Oracle Linux 9 with OpenL-Tablets 5.26.11 which I am installing on Tomcat 9.0.80 with JDK 20.0.2 and MariaDB 10.10. The message I get is:
Hello Hussian,
Could you please let us know which version of the MariaDB connector you are currently using? I'd like to bring to your attention some important compatibility notes:
JDK Support: OpenL 26.11 is compatible with JDK 11. Further details can be found on the OpenL Supported Platforms page.
JDBC Connection URL: For MariaDB, the JDBC connection URL format is
jdbc:mysql://[host][:port]/[schema].
This information is available in the Installation Guide on page 24.
Additional Recommendation:
We encourage you to post any questions or issues you may have on the OpenL Tablets GitHub Discussions page.
Best regards,
Alena Kosolapova