search

Icinga / icingaweb2-module-reporting

Icinga Reporting is the central component for reporting related functionality in the monitoring web frontend and framework Icinga Web 2.
GNU General Public License v2.0
64 stars 24 forks source link

PostgreSQL support #8

Closed mtdeguzis closed 4 years ago

mtdeguzis commented 5 years ago

Is your feature request related to a problem? Please describe.

No

Describe the solution you'd like

We are a PostreSQL shop mainly and use it for any backing resources within Icinga2/Icinagweb2. We would like to utilize this existing DB store to add the Reporting module, rather than go through the pain of adding and maintaining another DB store (MySQL).

Describe alternatives you've considered

Setting up our own reporting solution with Hadoop Hive, but that does not solve integration or schema issues that we would need to solve ourselves. Plus, this has great integration and automation we would love to use.

Additional context

None for now.

Philambdo commented 5 years ago

Just for now i tried to fork it (https://github.com/Philambdo/icingaweb2-module-reporting-1) and added a basic postgres schema - that at least works for now. Not sane or safe but enough for testing. I also had to fix column names and touch the corresponding php code because "end" is not a valid name for a column in postgres. At the moment i'm not sure where to go from here. Where is your favourite line of communication/discussion ? Here/IRC/Forum?

Greetings, Florian

lippserd commented 5 years ago

Hi,

Thanks for the report. PostreSQL support is planned but we did not start to implement it yet. @Philambdo cool stuff that you're working on this. Any chance to create a PR and we sort things out then?

Cheers, Eric

radioactive9 commented 4 years ago

Hello

I have a requirement to publish Availability reports. I am looking for something which can support postgres as everything else is in postgres. Do you have any instruction how i can do this in Postgres and not mySQL.