I think Arvind is probably right here. There’s enough moving parts around this to make it substantial work now that I’ve dug into the code more. I think it could be spiked in a few days to get something kind of working but longer than that to really flesh out all the things we’d need to bring it to the level of quality required for it to be truly supported and reliable.
On Sat, May 22, 2021 at 11:01 AM Aravind SV <[email protected]> wrote: > I’d think using Postgres would be easier than making sure all the queries > work properly and do what they’re supposed to. Some of the queries are > here > <https://github.com/gocd/gocd-analytics-plugin/tree/e6b0c514934169f68e82c91801c5ac5f0d9738ba/src/main/java/com/thoughtworks/gocd/analytics/mapper> > . > > Though the queries are probably not complex, building the infrastructure > (both code and test) to ensure that both DBs work, is likely much more work. > > * From*: HUSSEIN KADIRI <hussein+kadiri+%[email protected]%3E> > * Subject*: Re: [go-cd] Analytics plugin Mysql DB Setup > * To*: go-cd <go-cd+%[email protected]%3E> > * Date*: Fri, 21 May 2021 06:03:50 -0700 (PDT) > 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/m21r9yfy18.fsf%40arvindsv.com > <https://groups.google.com/d/msgid/go-cd/m21r9yfy18.fsf%40arvindsv.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/CAPKX9jZDDKMX8rOTVryFkgZYFCax5s_%3DX%2BoF-N1x32tEWCnzQg%40mail.gmail.com.
