Mitel Forums - The Unofficial Source

Mitel Forums => Mitel MiVoice Business/MCD/3300 => Topic started by: Chicken on February 19, 2020, 02:06:49 PM

Title: Access Database on NuPoint
Post by: Chicken on February 19, 2020, 02:06:49 PM

Hi everyone,

Does anyone know if we can connect to the database on the NuPoint server?

We'd like to be able to run historical reports on certain call flows without using the call flow report on the NuPoint. Reason being that when the server is rebooted, all of that data is gone and we can't run a report for a specific month. In order to do that, we'd need to reset the call flow report at the beginning of the month and clear it before the next month and hope that the server is not rebooted in the meantime.

Is there a way to grab that data?

Title: Re: Access Database on NuPoint
Post by: a.ghezzi on February 26, 2020, 04:01:18 PM

Does anyone know if we can connect to the database on the NuPoint server?   Yes

do you edit two file


/etc/e-smith/templates/var/lib/pgsql/10/data/postgresql.conf
/etc/e-smith/templates/var/lib/pgsql/10/data/pg_hba.conf


Bye Alessandro

Title: Re: Access Database on NuPoint
Post by: johnp on February 27, 2020, 07:32:18 PM

FWIW, never edit a template directly. You can create/copy the original to customer templates edit this file and expand what ever requires this so as to replace the original with your modified setting. Modified setting can be deleted and another expand can be done to get back to default

Title: Re: Access Database on NuPoint
Post by: Chicken on February 28, 2020, 02:29:10 PM

Quote from: a.ghezzi on February 26, 2020, 04:01:18 PM

Does anyone know if we can connect to the database on the NuPoint server?   Yes

do you edit two file


/etc/e-smith/templates/var/lib/pgsql/10/data/postgresql.conf
/etc/e-smith/templates/var/lib/pgsql/10/data/pg_hba.conf


Bye Alessandro

Alessandro, to clarify, I am trying to get access to where the NuPoint stores the call flow report data. The postgresql.conf and pg_hba.conf were folders that don't provide any data.

Currently:

when the server is rebooted we lose all call flow report data.
when someone forgets to clear the call flow report data from the NuPoint at the end of the month, it's impossible to run a report on 1/1/2020 to 1/31/2020 (for example) because it will display ALL call flow data since the LAST TIME it was cleared.

I am trying to pull that data so I can have it for historical purposes.

Title: Re: Access Database on NuPoint
Post by: Ronan on March 03, 2020, 10:45:37 AM

Did you ask Mitel ?

Did they answer "if you want stats buy MiCC" ? :d