That said I haven’t taken a look at the database parts of the code in a long time, so there’s that. I hope I’m not underestimating the work.
On Fri, May 21, 2021 at 6:03 AM HUSSEIN KADIRI <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/go-cd/7909ce43-05ec-4b4a-aa98-950cc8e2f2a0n%40googlegroups.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/CAPKX9jacs8Yp37V1h6iN861%3DbhpEx2%3D99Nc7zK8zkB9WZDyzGg%40mail.gmail.com.
