Thanks for the historical context. How much effort would it be to add support for Mysql to the analytics plugin? We primarily use mysql. Would need to jump through some hoops to use postgres. Trying to decide if its worth jumping through those hoops OR implementing Mysql support for analytics.
On Thursday, 20 May 2021 at 16:16:23 UTC-7 Marques Lee wrote: > A bit of history: > > GoCD used to only support h2 and postgres; the analytics plugin was > originally a “premium” plugin which required postgres. > > Later on, support for MySQL was added (I think as part of, or at least > around the same time we moved to liquibase as our ddl manager) to GoCD. > Nobody added that support to analytics as it really wasn’t in demand and > thus not a priority. Once commercial support stopped and the plugin was > open sourced, it was released as-is (almost, anyway —some changes required > for licensing purposes with a dependency). > > On Thu, May 20, 2021 at 4:09 PM Marques Lee <[email protected]> > wrote: > >> I’m pretty sure that while GoCD supports MySQL, the analytics plugin was >> always Postgres-only. I don’t think anyone has added support for other DBs. >> >> On Thu, May 20, 2021 at 4:04 PM HUSSEIN KADIRI <[email protected]> wrote: >> >>> Hi, >>> Trying to setup a Mysql DB for the analytics plugin. Per the configuring >>> database >>> <https://docs.gocd.org/current/installation/configuring_database.html> >>> page, >>> GoCD supports Postgres, Mysql, H2. >>> >>> I'm trying to connect mysql DB to it but it fails. >>> >>> The analytics page suggests postgres per the screenshot and the error >>> message. >>> >>> jvm 1 | 2021-05-20 22:33:24,616 ERROR [qtp1374887279-35] >>> p.c.t.g.a.c.t.g.a.d.PostgresqlDatabase:127 >>> [plugin-com.thoughtworks.gocd.analytics] - Error establishing connection >>> with the database >>> jvm 1 | java.sql.SQLException: Cannot create >>> PoolableConnectionFactory (Protocol error. Session setup failed.) >>> jvm 1 | at >>> org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) >>> jvm 1 | at >>> org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) >>> >>> >>> Does the analytics plugin support other DBs or only postgres? >>> Does anyone have an example configuring a non-Postgres DB for the >>> analytics plugin? >>> >>> >>> -- >>> Hussein Kadiri >>> [image: Screen Shot 2021-05-20 at 3.54.08 PM.png] >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "go-cd" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/go-cd/CAFD%2B7Dk%2BMF6uSPi9dnnz8EQL5CktSo0mF%2BWNf-abSm782Y%3D71g%40mail.gmail.com >>> >>> <https://groups.google.com/d/msgid/go-cd/CAFD%2B7Dk%2BMF6uSPi9dnnz8EQL5CktSo0mF%2BWNf-abSm782Y%3D71g%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/7909ce43-05ec-4b4a-aa98-950cc8e2f2a0n%40googlegroups.com.
