I see, thanks for the feedback. I'll check back it anything changes while I try to get Postgresql installed on my end.
On Sun, May 23, 2021, 1:03 PM Marques Lee <[email protected]> wrote: > 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 a topic in the > Google Groups "go-cd" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/go-cd/GFTkOtjKALU/unsubscribe. > To unsubscribe from this group and all its topics, 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 > <https://groups.google.com/d/msgid/go-cd/CAPKX9jZDDKMX8rOTVryFkgZYFCax5s_%3DX%2BoF-N1x32tEWCnzQg%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/CAFD%2B7DmohMFesChM9Xq-QpSgTHqw2k71o9HTdyumz4sWNyKoSQ%40mail.gmail.com.
