Comments (5)
MySQL 8 is not officially supported by Tigase XMPP Server 7.1.x. Recommended MySQL versions for that Tigase version are 5.5 (minimum) and 5.6 (recommended).
For MySQL 8 it's recommended to update to the latest Tigase version, which supports latest MySQL version. What's more, it doesn't require manually granting rights for Tigase user nor relies on mysql.proc
table.
from tigase-server.
Ok, thanks
from tigase-server.
I have the same problem also with tigase 8, still the same question: "is it safe to add this config to the jdbc query string?" (noAccessToProcedureBodies=true)
here the exception if I do not use it:
Could not initialize bean default (class: class tigase.db.beans.AuthRepositoryMDPoolBean$AuthRepositoryConfigBean), skipping injection of this bean
RootCause:
-> java.lang.RuntimeException: Could not initialize tigase.db.AuthRepository for name 'default'
[tigase.db.beans.MDPoolConfigBean.beanConfigurationChanged(MDPoolConfigBean.java:109)]
-> java.lang.reflect.InvocationTargetException
[java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)]
-> java.lang.RuntimeException: java.lang.RuntimeException: Could not initialize tigase.db.jdbc.TigaseCustomAuth for name 'default'
[java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)]
-> java.lang.RuntimeException: Could not initialize tigase.db.jdbc.TigaseCustomAuth for name 'default'
[tigase.db.beans.MDPoolConfigBean.lambda$setInstances$0(MDPoolConfigBean.java:179)]
-> tigase.db.DBInitException: Could not initialize TigaseCustomAuth instance
[tigase.db.jdbc.TigaseCustomAuth.setDataSource(TigaseCustomAuth.java:929)]
-> java.sql.SQLException: Could not initialize prepared statement
[tigase.db.DataRepositoryPool.executeForEachDataSource(DataRepositoryPool.java:250)]
-> java.lang.RuntimeException: java.lang.RuntimeException: Could not initialize prepared statement
[java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)]
-> java.lang.RuntimeException: Could not initialize prepared statement
[tigase.db.DataRepositoryPool.lambda$executeForEachDataSource$3(DataRepositoryPool.java:239)]
-> java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.
[com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)]
from tigase-server.
Could you check the rights of the Stored Procedures, i.e. if the definer is the Tigase user? (e.g. output of SHOW PROCEDURE STATUS;
)?
If not, this should be adjusted.
from tigase-server.
ok thanks, I have found that some are not, I will fix on that side
from tigase-server.
Related Issues (20)
- How to contribute to the project? HOT 2
- Activation of Offline Presence Plugin HOT 4
- Average Processing Time Statistic Calculation HOT 1
- Connection to localhost:5432 refused HOT 3
- Undelivered stanzas are processed before stream closure commands HOT 1
- documentation of old versions HOT 3
- How do I configure the BOSH port in kubernetes
- List of supported versions of Tigase HOT 1
- problem with HA on AWS aurora mysql for DNS cache HOT 51
- Can you guys add a onion link for connectivity? (For your sure.im server?) HOT 2
- problem with DefaultClusteringStrategy HOT 4
- how to completely disable pubsub? HOT 2
- Error trying to install Tigase server on GCP machine HOT 2
- dockerfile HOT 1
- tig_ma_msgs can`t insert records HOT 2
- Problems with Tigase after default initialization using Spark connection HOT 3
- is possibile to configure update-login-time-query? HOT 3
- maven build error HOT 7
- upgrade tigase from 7.1.5 to 8.2.2 HOT 29
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tigase-server.