search

brenoepics / morningstar

An open-source Arcturus Community Fork.
GNU General Public License v3.0
3 stars 2 forks source link

Failed to validate connection com.mysql.jdbc.JDBC4Connection@704a52ec #194

Closed brenoepics closed 1 year ago

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 3, 2019, 13:11

Hi Guys, i'm using a hosting and it have mariadb with method of security that disconnect connection after tot time, can you implement support of mysql hosting? thanks this is the problem

[ArcturusThreadFactory-1-5] WARN com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Failed to validate connection com.mysql.jdbc.JDBC4Connection@704a52ec (No operations allowed after connection closed.)

Build: 486f3ca5b1280f9ebc0ea264c90e647e

brenoepics commented 5 years ago

In GitLab by @Hackerman on Jul 6, 2019, 15:34

Not a Morningstar bug?

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 8, 2019, 16:28

@Hackerman Is a Arcturus missing feature because if you add security settings on your mysql server like timeout etc etc you can't use arcturus, it's a big problem if you want a secure server, i'm using my vps mysql because i cant use mysql server of the hosting because it have a security settings

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 8, 2019, 16:29

@Hackerman arcturus was designed to work only and exclusively on vps without security settings but in practice all free... and it's not a good thing

brenoepics commented 5 years ago

In GitLab by @Hackerman on Jul 15, 2019, 12:15

I use security settings

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 17, 2019, 11:56

my hosting same but i have this problem @Hackerman i think you security settings isn’t the same settings of the hosting

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 17, 2019, 11:57

Server: Localhost via UNIX socket Server type: MariaDB Server connection: SSL is not being used Documentation Server version: 10.2.25-MariaDB - MariaDB Server Protocol version: 10 Server charset: UTF-8 Unicode (utf8)

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 17, 2019, 11:58

hope can be fixed because it’s a problem, i have a hosting and i’m using mysql of my vps…

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 17, 2019, 19:09

@Harmonic hope it can be fixed…

brenoepics commented 5 years ago

In GitLab by @Killua on Jul 18, 2019, 24:01

I move my database from vps to hosting and i set this params but nothing…

db.params=?useSSL=false&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8

Better cyrillic supprot add ?characterEncoding=utf8 to db.params. This will be appended at the end of the JDBC url.

db.pool.minsize=1 db.pool.maxsize=2147483647

brenoepics commented 5 years ago

In GitLab by @ghost on Jul 31, 2019, 11:57

This is a warning and HikariCP should reconnect when a connection is disconnected. You can ignore the message.

brenoepics commented 5 years ago

In GitLab by @ghost on Jul 31, 2019, 11:57

closed