Reference9:Release Notes Linux Reporting: Difference between revisions

From innovaphone wiki
Jump to navigation Jump to search
m (Protected "Support:DVL-Roadmap Reporting V1": Security Reasons [edit=sysop:move=sysop])
(Replacing page with 'This roadmap describes the V1 (that is, Reference9:Concept_Reporting based) Reporting based on the linux application platform.<br/> <br/> This article is generated automat...')
Line 5: Line 5:
Please see ''[[Support:What is the DVL-Roadmap?|the disclaimer]]'' before using the information presented here!
Please see ''[[Support:What is the DVL-Roadmap?|the disclaimer]]'' before using the information presented here!


 
__NOEDITSECTION__
   
{{#invoke-url: http://wiki.innovaphone.com/extensions/InvokeUrlFunction/generateProjectList.php?area=fixes&category=Reporting%20V1}}
= V1 Hotfix 1 (10181) =
These are the fixes included in Reporting V1 hotfix 1.<!---->
[http://mantis.innovaphone.com/view.php?id=64095 Definition]
 
 
   
== reporting callback request from mypbx may crash with uninitialized reporting config ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63709 63709]
|}
If one has never configured replication or ldap for Reporting, a reporting callback request from mypbx won't work (the process crashes).<br/>This is fixed now by checking a config parameter.
   
== reporting: wrong remote party in some transfer and forward events ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63819 63819]
|}
We assumed that the remote party does not change after transfer/forward event and that the next event after those contains more information over the remote party but this is wrong since the remote party may change.
   
== reporting: process.fcgi crashes with filters containing a remote number condition ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63878 63878]
|}
forgot to open parenthesis<br/>conn_length was also forgotten to change to conn_duration
   
== Reporting: better visibility of replication status ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63920 63920]
|}
The connection status to the configured replication server is now shown.<br/>The last run is now also shown, even if there was no successful database connection.
   
== reporting: if conn to/from event present, conn-duration must be at least one ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=64267 64267]
|}
Sometimes conn event and disc/rel event present the same time. Maybe, this should be changed in PBX but we check it anyway.<br/>Connected time must be at least 1. This is also applicable for billing.
   
== reporting: mypbx missed calls wrong for multiple registrations ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65103 65103]
|}
If one user has multiple registrations, missed calls were recognized, although the calls has been answered.<br/>Calls from other registrations are disregarded now.
   
== reporting: show call duration time instead of conn duration time in report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65132 65132]
|}
As the whole call flow is shown in the report, showing the call duration makes more sense.
   
== reporting: conn, call and billing time calculation ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65146 65146]
|}
billing calls are those having "from", "ct" or "cf" as dir attribute in cdrs. So far we have only considered calls with a setup-from as first event but "ct" and "cf" calls can present a setup-to event and they must be charged too.<br/><br/>all times must be ended with the first disc event.<br/><br/>conn time must not be counted after a transfer-from or cf-from event.
   
== reporting: allow two or more LDAP configurations to have same PBX name ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65253 65253]
|}
it is needed if you have more than one trunk.
   
== Linux: LDAP query if no name available in CDR ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63134 63134]
|}
If the CDR contains no name on it, make a LDAP query to the PBX before writing the CDR into the database.<br/>Try with OPENLDAP library.
   
== reporting: replication not running ssl ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63933 63933]
|}
configure postgresql to run ssl during replication. We will use the web server certificate.
   
== reporting: added delete tag in application xml file ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=63936 63936]
|}
delete tag defines which files/directories must be deleted during uninstall
   
== Reporting: separate authentication for reporting web access ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=64875 64875]
|}
It is now possible to configure a separate authentication to the innovaphone reporting web site.<br/>
   
== reporting: download xml report if it has an invalid format ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=64882 64882]
|}
we offer now a link to download the xml report if it has an invalid format and therefore cannot be displayed by the browser.
   
== reporting: LDAP: add Name and Number attributes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=64919 64919]
|}
we have added two new fields for Name and Number Attributes in the LDAP configuration. <br/>So far we had just used "displayName" as Name attribute and "mobile,telephoneNumber and HomePhone" as Number attributes.
   
== reporting: improvements on xml/pdf representation ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65151 65151]
|}
we usually use information on the alarm event but conn event normally contains more data. Check which one is better.<br/><br/>pdf looks strange if LDAP returns large strings
   
== reporting: suppress last digits of called/calling party for external calls ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65259 65259]
|}
allow to suppress last digits of called/calling party for external calls. It can be configured how many digits must be replaced with a '*'.
   
== reporting: diagnostics page available with logs/rpcap ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65365 65365]
|}
The diagnostics page with reporting related log files and rpcap functionality is now also available on the reporting web site.
   
== Reporting: transfers on a slave PBX will now generate a new event: transfer-remote ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65475 65475]
|}
when a transfer event happens on a slave PBX, it cannot be known the status of the call afterwards. This new event indicates this situation and a connected status will be shown in the report.
   
== reporting: show only one CDR for transfer/forward calls per user ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=65820 65820]
|}
Currently both generated CDRs for a user of a transfer or forward call are shown. Diversions are now divided in two CDRs, one showing the whole call flow and another containing billing information, which will not be shown in call lists.
   
= V1 Hotfix 2 (10197) =
These are the fixes included in Reporting V1 hotfix 2.<!---->
[http://mantis.innovaphone.com/view.php?id=66705 Definition]
 
 
   
== Reporting: check if database is being restored before writing a CDR ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=66757 66757]
|}
avoid writing a CDR to the DB if it is being restored since this could corrupt the DB. <br/>This CDR will be sent by the PBX again since Linux is responding with 500 HTTP Error Code.
   
== Cumulative hotfix installation script didn't apply second hotfix ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=66917 66917]
|}
As the version of the previously installed hotfix hasn't been set properly.
   
== Reporting: current password was not checked before setting a new password ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=67386 67386]
|}
we used localhost and given password to make a connection to the db but localhost needs no password.
   
== reporting: postgresql-8.4 debian package update ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=66271 66271]
|}
debian update for postgresql 8.4.
   
= V1 Hotfix 3 (10201) =
These are the fixes included in Reporting V1 hotfix 3.<!---->
[http://mantis.innovaphone.com/view.php?id=67577 Definition]
 
 
   
== Duplicated report lines on certain filter options ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=68123 68123]
|}
Certain filter options caused duplicated lines in a report.<br/>This has been fixed by changing the query.
   
== Reporting: ldap results were not escaped ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=68654 68654]
|}
any string must be 'postgresql' escaped before inserting it into the DB.
   
= V1 Hotfix 4 (10237) =
These are the fixes included in Reporting V1 hotfix 4.<!---->
[http://mantis.innovaphone.com/view.php?id=71206 Definition]
 
 
   
== invalid log file entries for mypbx requests if reporting database is not running ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71277 71277]
|}
Invalid log file entries have been written for mypbx requests, if the reporting database was down.
   
== Call list sorting by call duration now numerical, not alphanumerical ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71450 71450]
|}
The call list sorting by call duration was alphanumerical, not numerical.<br/>This has been fixed.
   
== Viewing log files with invalid chars now possible ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71716 71716]
|}
Viewing log files with invalid chars is now possible over the diagnostics page.
   
== linux: added non-blocking option on flock() call for log files ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71838 71838]
|}
The flock() call was eventually blocking if the lock could not be acquired. If we do not get the lock after ten attempts, the log trace will be lost.
   
== dynamic list row add/remove doesn't trigger page to top any more ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71957 71957]
|}
Adding or removing a line of a dynamic list doesn't trigger the jump to the page top any more.
   
== Possibility to clear the call list in mypbx ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71202 71202]
|}
A new button is now available in mypbx to clear the call list.
   
== possibility to clear log files ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71714 71714]
|}
Log files can be cleared now.<br/>Just system specific log files can't be cleared.
   
== added trace level option ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71857 71857]
|}
There is now the possibility to enable further tracing levels.
   
== Increased maximum height of filter list ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=71865 71865]
|}
Currently only four filter options can be viewed at a time.<br/><br/>With the fix, the lists height increases from 2 until 16 items until the scrollbar of the list is enabled.
   
= V1 Hotfix 5 (10276) =
These are the fixes included in Reporting V1 hotfix 5.<!---->
[http://mantis.innovaphone.com/view.php?id=72213 Definition]
 
 
   
== LDAP filters are now stored in the DB instead of XML ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=73439 73439]
|}
LDAP filters have been moved to the DB.<br/>This makes it easier to replicate them to a standby installation.
   
== reporting: send reports per email ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=72391 72391]
|}
Reports can be now sent per email.
   
== filter option for report times ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=73006 73006]
|}
A filter can now define report times, e.g. all records between 08:00 and 16:00.<br/>
   
== reporting: logo and footer for pdf reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=73542 73542]
|}
It is now possible to add a logo and footer in pdf reports
   
== exclude outgoing calls without number/h323 from mypbx call list ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=73561 73561]
|}
Calls are not shown anymore, if someone just offhooks and onhooks without dialing.
   
= V1 Hotfix 6 (10282) =
These are the fixes included in Reporting V1 hotfix 6.<!---->
[http://mantis.innovaphone.com/view.php?id=74057 Definition]
 
 
   
== reporting: mails were not sent in vm installations ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75359 75359]
|}
The vm installation was creating a local-host-names file with wrong data and this was making DNS problems.
   
== reporting: possible buffer overrun reading system processes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75645 75645]
|}
when restoring db from a backup, we do not accept cdrs. We look the running processes searching from "db-restore" in files whose size is null. I allocated a 1024 bytes thinking that was enough, apparently not.
   
== mypbx call list query optimized for speed ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75646 75646]
|}
The query execution lasted quite long, if a user had cleared the call list and less than 20 calls in this list.
   
== reporting: summary of pdf reports was not displayed correctly ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75655 75655]
|}
The summary was not always displayed correctly
   
== report mails with non latin1 chars in mail name ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75667 75667]
|}
The mail name has to be correctly encoded to be correctly parsed by cron.
   
== LDAP servers now support object filters ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75697 75697]
|}
This is needed, if an innovaphone PBX is used as phone book.
   
== check if reporting application already exists on reporting application install ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75828 75828]
|}
This check hasn't been done yet and caused application issues, if someone installs an already existing reporting application again.
   
== Reporting: pdf reports showing connected duration instead of call duration ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=76303 76303]
|}
both times are normally equal, that's why we did not see the bug.
   
== possible trap after failed DB insert of a CDR ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=76625 76625]
|}
A possible trap after a failed DB insert of a CDR has been fixed.
   
== prevent failing CDR insert with replication ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=76633 76633]
|}
A missing LOCK statement could have caused a failed CDR insert in replication scenarios.
   
== Possiblity to delete CDRs from database since time X and/or pbx object Y ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=73944 73944]
|}
You can now define a time period and/or a pbx object for which CDRs are deleted in the database.
   
== reporting: test email functionality ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75760 75760]
|}
under diagnostics kann man ein email senden. So berprft man ob emails verschickt werden.
   
== reporting: call duration and alert duration in filter settings ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75764 75764]
|}
How long a call was connected or how long a "not connected" call was ringing.
   
== reporting: send mails via external server (smtp relay) ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=75903 75903]
|}
it is now possible to configure the mail client on Linux to send mails via Exchange.
   
= V1 Hotfix 7 (10285) =
These are the fixes included in Reporting V1 hotfix 7.<!---->
[http://mantis.innovaphone.com/view.php?id=91997 Definition]
 
 
   
== check for postgresql installation before editing postgresql conf file ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=77334 77334]
|}
only remove certain lines from default pg_hba.conf file if postgresql hasn't been installed yet.
   
== myPBX: Clearing call list does not work in IE8 ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=77915 77915]
|}
IE8 caches the HTTP requests to reporting. Therefore after clearing the call list the old (uncleared) callist is displayed again.<br/>An expires header is now sent within the response.
   
== Reporting: Localised date and time format in myPBX call list ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=76779 76779]
|}
Call list shall contain localised date and time. Also today's and yesterday's date should be replaced by words.<br/>
   
== reporting: make LDAP queries for Trunk Line Objects ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=76906 76906]
|}
we now see in reports in the "Left" column "external number Amt" for the Amt object but this external number may appear in LDAP. If this number is found in LDAP, we replace previous value with the LDAP result.
   
== moved/changed some shared code for future innovaphone applications ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=77381 77381]
|}
Some shared code has been moved for future innovaphone applications for the linux application platform.
   
= V1 Hotfix 8 (10288) =
These are the fixes included in Reporting V1 hotfix 8.<!---->
[http://mantis.innovaphone.com/view.php?id=76643 Definition]
 
 
   
== some preperations for web interface translations ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=78428 78428]
|}
Changed some small things for future web interface translations.
   
== filter call direction options transfer/call forward did not work ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=78618 78618]
|}
Both options did not work and have been fixed.
   
== Show pickup party after transfer/cf/alert in call report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=79495 79495]
|}
Currently the connect information is wrong for calls which have been pickuped.<br/>Now, a new line will be shown for the pickup party.<br/><br/><!--<br/>pg_report.c<br/>pg_report.h<br/>pickup.jpg<br/>pickup_rev.jpg<br/>pickup_pdf.jpg<br/>pickup_rev_pdf.jpg<br/>call_pickup_left.jpg<br/>call_pickup_right.jpg<br/>call_list.xsl<br/>report.xsl<br/>-->
   
== option to show filter info in xml/pdf for call report not only in an email report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=78762 78762]
|}
Currently only the PDF of an email report contains the filter information.<br/>Now, also the xml can contain it and manual reports can also contain the information now.
   
== Parse language code from mypbx ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=78879 78879]
|}
For localization of the call list.
   
= V1 Hotfix 9  (10294) =
These are the fixes included in Reporting V1 hotfix 9.<!---->
[http://mantis.innovaphone.com/view.php?id=79707 Definition]
 
 
   
== Reporting: Mails not sent due to special characters ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=80459 80459]
|}
wrong handling of special characters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>-->
   
== Enter key submits filter changes now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=80763 80763]
|}
The enter key now submits filter changes when used in a filter editing field.
   
== Reporting: avoid empty page at end of PDF reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=80787 80787]
|}
sometimes an empty page appeared at the end of pdf reports.<br/><br/><!--<br/>pg_report.c<br/>-->
   
= V1 Hotfix 10 (10303) =
These are the fixes included in Reporting V1 hotfix 10.<!---->
[http://mantis.innovaphone.com/view.php?id=81059 Definition]
 
 
   
== Enter key submits mail changes now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=81184 81184]
|}
Instead of canceling changes.<br/><br/><!--<br/>config_reporting.php<br/>-->
   
== do not send an alarm for deadlocks on CDR insert ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=83267 83267]
|}
as this CDR insert will be retried afterwards again.<br/><br/><!--<br/>cdr.c<br/>-->
   
== multi-client capability for reporting ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=82835 82835]
|}
It is now possible to configure different user logins. The admin can assign so called base filters to these users and the users can just use the assigned base filters to create reports or report mails.<br/>They can also create own filters based on one of the assigned base filters.<br/><br/><!--<br/>report.php<br/>config_reporting.php<br/>include.php<br/>java.js<br/>include_main.php<br/>reporting_database.dump<br/>update_seq.psql<br/>config.sh<br/>replication.c<br/>process.c<br/>pg_report.c<br/>innovaphone-reporting.xml<br/>-->
   
== German translation for the web interface and reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=83047 83047]
|}
Added the german translation.
   
= V1 Hotfix 11 (10317) =
These are the fixes included in Reporting V1 hotfix 11.<!---->
[http://mantis.innovaphone.com/view.php?id=83653 Definition]
 
 
   
== Localise time of callbacks in reports and mypbx calllist ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=84256 84256]
|}
The callback time was language independet and now it is localised in the report xml, which is used for reports and the mypbx calllist.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>-->
   
== PDF report creation didn't work with group by and sort by options ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=84346 84346]
|}
e.g. in Report Mails, but also from web ui.<br/><br/><!--<br/>report.php<br/>-->
   
== Suggest possible PBX object names on creation of a report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=83834 83834]
|}
On entering a PBX object (long name) to create a report for this object, possible values are now selectable from a displayed list.<br/>To keep the response time low, only values from CDRs of the last week are shown.<br/><br/><!--<br/>inputpage.class.php<br/>innoinputpage.class.php<br/>include.php<br/>config_reporting.php<br/>-->
   
== retry sending of Report Mail on failure and write error to log file ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=84591 84591]
|}
The sending of a report mail is now retried two times, if the sending fails and the error is written to the innovaphone-reporting log file, if the last try also fails.<br/><br/><!--<br/>config.sh<br/>-->
   
== Language for Report Mail configurable ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=84692 84692]
|}
The language for a report mail is now configurable.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>-->
   
== Alarms are now cleared if condition is cleared ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85085 85085]
|}
Alarms of the Linux Application Platform or by applications like Reporting are now cleared, if the alarm condition doesn't exist anymore.<br/><br/><!--<br/>backup.php<br/>config.php<br/>diagnostics.php<br/>include_main.php<br/>cdr.c<br/>-->
   
= V1 Hotfix 12 (10323) =
These are the fixes included in Reporting V1 hotfix 12.<!---->
[http://mantis.innovaphone.com/view.php?id=85437 Definition]
 
 
   
== Remove duplicate connected CFNR calls from report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85476 85476]
|}
Users with multiple registrations had multiple calls in their report, if the call had a CFNR and was connected afterwards.<br/><br/><!--<br/>pg_report.c<br/>-->
   
== Sent mail reports are not stored in sent file anymore ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85485 85485]
|}
Sent mail reports had been stored in a file. This isn't done anymore now.<br/><br/><!--<br/>init_script.sh<br/>install_hotfix.sh<br/>-->
   
== Occasional corrupt report attachments ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85556 85556]
|}
Sometimes sent report archives were corrupt, because the sending mail program didn't recognize the mime type of the file and changed the binary file before sending it.<br/>This is fixed now.<br/><br/><!--<br/>mime.types<br/>init_script.sh<br/>make.sh<br/>onerror_template.sh<br/>Makefile<br/>-->
   
== Don't treat CFU calls with connect as "No response" calls ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85863 85863]
|}
With a filter with the "No response" check, forwarded calls with a connect after the forward shouldn't be shown.<br/><br/><!--<br/>report.php<br/>-->
   
== Enable PosgreSQL Autovauum feature correctly ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=86504 86504]
|}
There was a configuration option missing for this feature to work properly.<br/><br/><!--<br/>postgresql.conf<br/>-->
   
== Restrict myPBX call list to calls of the last month ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=86573 86573]
|}
This prevents high response times if a user does not have 20 calls in the last month.<br/><br/><!--<br/>mypbx.c<br/>-->
   
== Do not uninstall already installed packages after failed hotfix installation ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=86597 86597]
|}
Due to a bug, already installed packages have been uninstalled after a failed hotfix installation.
   
== Column with "Alerting time" for reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85478 85478]
|}
Show the alerting time as column in report.<br/><br/><!--<br/>pg_report.c<br/>include.php<br/>report.xsl<br/>language files<br/>-->
   
== Option to compress/not compress the report in a report mail ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85580 85580]
|}
Added the possibility to define whether a report in a mail will be compressed or not.<br/><br/><!--<br/>config_reporting.php<br/>include.php<br/>report.php<br/>lang files<br/>-->
   
== Reporting: reports in CSV format ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85823 85823]
|}
Reports in CSV format without call history
''Status:''
<!--<br/>pg_report.c<br/>report.php<br/>report.xsl<br/>inno-lib.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>-->
   
== Summary for each group in a grouped report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85972 85972]
|}
Each group gets now a new summary line after the last record of the group, which contains the following information:<br/><br/>Number of incoming calls<br/>Number of outgoing calls<br/>Total connected duration<br/>Total alert duration<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>report.css<br/>process-text-tables.h<br/>process-strings-utf8.h<br/>-->
   
= V1 Hotfix 13 (10329) =
These are the fixes included in Reporting V1 hotfix 13.<!---->
[http://mantis.innovaphone.com/view.php?id=87141 Definition]
 
 
   
== Alert/conn duration filter didn't always work ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=86970 86970]
|}
The filter settings for alert and conn duration didn't work under certain other filter options.<br/><br/><!--<br/>report.php<br/>-->
   
== CSV export didn't work with certain group by and sort by settings ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=87492 87492]
|}
If group by was set to date and sort by to any value, the CSV export failed.<br/><br/><!--<br/>pg_report.c<br/>-->
   
== Report on the web didn't show correct group summary if sorted differently ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=87532 87532]
|}
A grouped report didn't correctly show the group summary, if one of the sort columns has been used.<br/><br/><!--<br/>report.xsl<br/>-->
   
== Reporting: Remote Party Information is empty ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=87742 87742]
|}
Calls having only Setup and Rel events contain the information of the remote party inside the release event. (we were using setup)
''Status:''
<!--<br/>pg_report.c<br/>-->
   
== LDAP server configuration now requires LDAP port and suggests default 389 ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=87983 87983]
|}
The LDAP port is now required and the default port 389 is suggested.<br/><br/><!--<br/>include.php<br/>report.php<br/>-->
   
== Check of running processes didn't work sometimes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=88553 88553]
|}
Due to the output width of the ps command. <br/><br/><!--<br/>config.sh<br/>init_script.sh<br/>install_script.sh<br/>install_exchange/reporting/faxserver.sh<br/>exchange.php<br/>innovaphone-faxserver<br/>innovaphone.fax.config.class.php<br/>-->
   
== Possibility to configure displayed duration in report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=85768 85768]
|}
You have now the possibility to select the displayed duration:<br/>Call Duration (Total) <br/>Call Duration (User)<br/>Billing Duration<br/><br/><!--<br/>inno-lib.h<br/>mypbx.c<br/>pg_report.c/h<br/>process_strings-utf8.h<br/>config_reporting.php<br/>include.php<br/>lang-reporting-*.inc<br/>report.php<br/>report.xsl<br/>install_hotfix.sh<br/>psql_commands<br/>reporting_database.dump<br/>-->
   
== Optimized myPBX call list query ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=86824 86824]
|}
The query has been optimized for a faster response time.<br/><br/><!--<br/>mypbx.c<br/>-->
   
== Reporting: LDAP Einrichtung mit Wildcard fr PBX Name ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=88129 88129]
|}
Jetzt wird '%' als Wildcard akzeptiert.
''Status:''
<!--<br/>cdr.c<br/>pg_report.c<br/>-->
   
== Check of running db restore/backup etc. available for other applications now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=88339 88339]
|}
The check of a running db restore/backup etc. is now available for other applications.<br/>This offers the possibility to prevent database access during certain operations.<br/><br/><!--<br/>cdr.c<br/>administration.php<br/>application.php<br/>include_main.php<br/>backup.php<br/>config.sh<br/>config_reporting.php<br/>postgresql.php<br/>config_faxserver.php<br/>language files<br/>-->
   
== Anonymize internal names/numbers in a report ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=88425 88425]
|}
New option added to anonymize internal names/numbers.<br/><br/><!--<br/>reporting_database.dump<br/>inno-lib.h<br/>pg_report.c<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>config_reporting.php<br/>include.php<br/>report.php<br/>report.xsl<br/>lang-reporting-de/en.inc<br/>-->
   
= V1 Hotfix 14 (10336) =
These are the fixes included in Reporting V1 hotfix 14.<!---->
[http://mantis.innovaphone.com/view.php?id=91970 Definition]
 
 
   
== Avoid using exec and system in PHP ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=89234 89234]
|}
these functions are consuming very much time. We will now implement locks through files and PHP will only call file_exist function.<br/>These change will also be applied to cdr.c<br/><br/><!--<br/>cdr.c<br/>config.sh<br/>config.php<br/>postgresql.php<br/>config_reporting.php<br/>config_faxserver.php<br/>config_exchange.php<br/>include_main.php<br/>diagnostics.php<br/>backup.php<br/>application.php<br/>administration.php<br/>-->
   
== Anonym flag now available as base filter option ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=88907 88907]
|}
If this flag is set, all reports created with this base filter will be anonym.<br/><br/><!--<br/>report.php<br/>include.php<br/>config_reporting.php<br/>reporting_database.dump<br/>psql_commands.txt<br/>psql_commands_undo.txt<br/>install_hotfix.sh<br/>-->
   
== Show summarized alert duration in summary ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=89033 89033]
|}
The alert duration of incoming/outgoing calls is now shown in the summary.<br/><br/><!--<br/>pg_report.c<br/>report.xsl<br/>process-strings-utf8.h<br/>process-text-tables.h<br/>-->
   
== Some optimizations for a better web ui performance ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=89238 89238]
|}
Added some session vars to avoid running slow code multiple times.<br/>Background processes run with a lower priority now.<br/><br/><!--<br/>config_reporting.php<br/>administration.php<br/>install_reporting.sh<br/>install_exchange.sh<br/>config_exchange.php<br/>install_faxserver.sh<br/>innovaphone_check<br/>innovaphone-faxserver<br/>install_hotfix.sh (2x)<br/>include_main.php<br/>-->
   
= V1 Hotfix 15 (10353) =
These are the fixes included in Reporting V1 hotfix 15.<!---->
[http://mantis.innovaphone.com/view.php?id=91972 Definition]
 
 
   
== Internal database connection was slow due to SSL mode ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=90519 90519]
|}
The connection string was slightly wrong, so SSL mode wasn't disabled as intended.<br/>Therefor the connection was slower than expected.<br/><br/><!--<br/>postgresql.php<br/>administration.php<br/>-->
   
== Reporting: optimization of the CDR receiving process ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=90894 90894]
|}
postgresql takes too long to open a connection to the db. Now we have an opened DB connection and we queue the incoming CDRs.<br/><!--<br/>cdr.c<br/>cdr.h<br/>pg_report.c<br/>reporting_config.c<br/>reporting_config.h<br/>inno-lib.c<br/>inno-lib.h<br/>-->
   
== LDAP: use next configured server if the actual one returns no name or error. ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=91228 91228]
|}
if actual LDAP server does not return a name maybe another configured server does. Therefore test all configured LDAP servers.<br/>Right now we only use the first valid one.
   
== Stop database if application is uninstalled ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=91293 91293]
|}
The database is now stopped, if it gets uninstalled on an application uninstall.<br/>Otherwise it doesn't start again on the correct port after a new install...<br/><br/><!--<br/>uninstall_script.sh<br/>-->
   
== LDAP: National/Trunk prefix may not exist ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=91798 91798]
|}
Some countries like Norway or Spain do not present a Trunk Prefix like Germany does.
   
= V1 Hotfix 16 (10358) =
These are the fixes included in Reporting V1 hotfix 16.<!---->
[http://mantis.innovaphone.com/view.php?id=91973 Definition]
 
 
   
== Filter with too many conditions failed ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=92762 92762]
|}
A filter with too many conditions caused a buffer overrun.<br/><br/><!--<br/>pg_report.c<br/>-->
   
= V1 Hotfix 17 (10369) =
These are the fixes included in Reporting V1 hotfix 17.<!---->
[http://mantis.innovaphone.com/view.php?id=93156 Definition]
 
 
   
== Fixed user login page alignment ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=93309 93309]
|}
The page was wrongly aligned.<br/><br/><!--<br/>login.php<br/>-->
   
== Deletion of a large amount of CDRs didn't work ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=94803 94803]
|}
If one tried to delete a large amount of CDRs (e.g. > 100000), the process failed without an error message.<br/>This is fixed now, although the process lasts longer now.<br/><br/><!--<br/>config_reporting.php<br/>-->
   
== PDF report creation might have failed with selected grouping ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=94972 94972]
|}
The page count has been wrongly calculated, if the report has been grouped.<br/><br/><!--<br/>pg_report.c<br/>-->
   
== Limit web reports to prevent browser crashes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=95003 95003]
|}
If the shown web report is too large, some browsers are crashing.<br/>This is now prevented by a limit to the shown calls. The report itself can still be directly downloaded without this limit.<br/><br/><!--<br/>report.css<br/>report.xsl<br/>report.php<br/>include.php<br/>language files<br/>pg_report.c<br/>inno_lib.h<br/>-->
   
== External calls mistakenly recognised as pickup calls ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=95663 95663]
|}
If an external connected number differs from the called number, the call has been recognized as a pickup call.<br/><br/><!--<br/>pg_report.c<br/>-->
   
== LDAP: add number resolution without percentage character ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=95749 95749]
|}
a customer has problems with LDAP resolution and we guess the problem resides on the % character. Now the filter contains both cases, number with and without percentages.
   
== Increased performance of database restore ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=94771 94771]
|}
With a change of the restore process, the restore time could be reduced.<br/><br/><!--<br/>config.sh<br/>Makefile<br/>make.sh<br/>onerror_template.sh<br/>install_reporting/faxserver/exchange.sh<br/>get_add_constraint_statement.psql<br/>get_add_index_statement.psql<br/>get_drop_statements.psql<br/>-->
   
== Direct report download on web interface ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=94935 94935]
|}
For huge reports it might be usefull to directly download the report instead of viewing it in the browser first before downloading it.<br/><br/><!--<br/>java.js<br/>report.php<br/>report.xsl<br/>pg_report.c<br/>pg_report.h<br/>include.php<br/>-->
   
== Added Italian translation ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=95366 95366]
|}
Italian translation is now available for the Linux Application Platform and its applications.<br/><br/><!--<br/>all it language files<br/>-->
   
= V1 Hotfix 18 (10371) =
These are the fixes included in Reporting V1 hotfix 18.<!---->
[http://mantis.innovaphone.com/view.php?id=95927 Definition]
 
 
   
== Mails: allow SMTP Relay without Authentication ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=96062 96062]
|}
Mail tool was wrongly configured if user was given without password.<br/><br/><!--<br/>report.php<br/>config.sh<br/>-->
   
== myPBX call list authentication works with Reporting access credentials now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=96094 96094]
|}
The myPBX call list authentication only worked with the Linux Web Server credentials, although it is possible to configure separate Reporting access credentials.<br/>Now both credentials will work.<br/><br/><!--<br/>mypbx.c<br/>-->
   
= V1 Hotfix 19 (10372) =
These are the fixes included in Reporting V1 hotfix 19.<!---->
[http://mantis.innovaphone.com/view.php?id=96850 Definition]
 
 
   
== Save Reporting user login in browser ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=97621 97621]
|}
The "Stay logged in" checkmark didn't work.<br/><br/><!--<br/>login.php<br/>-->
   
== Report number filtering only checks first number now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=97703 97703]
|}
Instead of checking all numbers, just the first relevant number is checked now.<br/><br/><!--<br/>report.php<br/>cdr.c<br/>pg_report.c/.h<br/>-->
   
== User defined filter can be deleted now ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=97721 97721]
|}
The check if the filter can be deleted has been fixed and a user defined filter can be deleted now.<br/><br/><!--<br/>config_reporting.php<br/>-->
   
= V1 Hotfix 20 (10375) =
These are the fixes included in Reporting V1 hotfix 20.<!---->
[http://mantis.innovaphone.com/view.php?id=98559 Definition]
 
 
   
== IE10 compatibility for web reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=99330 99330]
|}
Creation of web reports in IE10 wasn't working.<br/><br/><!--<br/>java.js<br/>-->
   
== Force PostgreSQL to free disk space after deletion of CDRs ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=99967 99967]
|}
PostgreSQL does not free disk space after deletion of table data to keep the space for further usage.<br/>Now this space is really freed after deleting CDRs.<br/><br/><!--<br/>config.sh<br/>config_reporting.php<br/>-->
   
= V1 Hotfix 21 (10376) =
These are the fixes included in Reporting V1 hotfix 21.<!---->
[http://mantis.innovaphone.com/view.php?id=99996 Definition]
 
 
   
== Support of UTF-8 only languages like Russian ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=100942 100942]
|}
Currently only latin1 languages were possible within the web interface. Now also UTF8 only languages are possible.<br/><br/><!--<br/>translator.class.php<br/>include_main.php<br/>all language files in UTF-8 now<br/>-->
   
= V1 Hotfix 22 (10377) =
These are the fixes included in Reporting V1 hotfix 22.<!---->
[http://mantis.innovaphone.com/view.php?id=101086 Definition]
 
 
   
== LDAP: traces for unset parameters ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=101846 101846]
|}
<!--<br/>cdr.c<br/>reporting_config.c<br/>config_reporting.php<br/>-->
   
== Wrong http error strings returned on failing CDR ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=101969 101969]
|}
There was a mismatch of error code and error string.<br/><br/><!--<br/>inno-lib.c<br/>-->
   
== Retry CDR insert after broken postgresql connection ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=102304 102304]
|}
Instead of directly returning an error, the insert is now retried one time.<br/><br/><!--<br/>process.c<br/>-->
   
= V1 Hotfix 23 (10380) =
These are the fixes included in Reporting V1 hotfix 23.<!---->
[http://mantis.innovaphone.com/view.php?id=102533 Definition]
 
 
   
= V1 Hotfix 24 (10383) =
These are the fixes included in Reporting V1 hotfix 24.<!---->
[http://mantis.innovaphone.com/view.php?id=107998 Definition]
 
 
   
== Increased max length of report mails field ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=107134 107134]
|}
From 60 to 1024 chars.<br/><br/><!--<br/>config_reporting.php<br/>-->
   
== Correctly escape long name and pbx/system name ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=107723 107723]
|}
Otherwise the report generation failed.<br/><br/><!--<br/>report.php<br/>include.php<br/>pg_report.c<br/>mypbx.c<br/>inputpage.class.php<br/>-->
   
== Fix wrongly released version number in cumulative hotfix ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=107872 107872]
|}
The cumulative hotfix 23 contained a hotfix 22 with a wrong build number 10378.<br/>The cumulative hotfix 24 will now replace this number with 10377 and further hotfixes will be installed correctly.<br/><br/><!--<br/>install_hotfixes.sh<br/>-->
   
= V1 Hotfix 25 (10386) =
These are the fixes included in Reporting V1 hotfix 25.<!---->
[http://mantis.innovaphone.com/view.php?id=108002 Definition]
 
 
   
== LDAP: rebind needed to follow referrals ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=108647 108647]
|}
If we try to follow the referrals we need to re-authenticate. If not done the LDAP library attempts with anonymous and the server responds with an error.<br/><br/><!--<br/>cdr.c<br/>-->
   
== Correctly show connected number in report if no alert is present and setup is empty ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=108667 108667]
|}
The connected number was shown as "N/A". Now the correct connected number is shown.<br/><br/><!--<br/>pg_report.c<br/>-->
   
== Report compatibility with IE 11 ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=109496 109496]
|}
Microsoft changed their navigator.appName to "Netscape" (obviously) so we needed another check to test for Internet Explorer...<br/><br/><!--<br/>java.js<br/>-->
   
= V1 Hotfix 26 (10387) =
These are the fixes included in Reporting V1 hotfix 26.<!---->
[http://mantis.innovaphone.com/view.php?id=109658 Definition]
 
 
   
== LDAP: search filter was not correct ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=110893 110893]
|}
LDAP filter was not built correctly, add exact number dialed<br/><br/><!--<br/>cdr.c<br/>-->
   
== LDAP: name resolution for an internal number in special case ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=111136 111136]
|}
setup-from before an unconditional diversion contains no name information.<br/><br/><!--<br/>cdr.c<br/>-->
   
= V1 Hotfix 27 (10389) =
These are the fixes included in Reporting V1 hotfix 27.<!---->
[http://mantis.innovaphone.com/view.php?id=111548 Definition]
 
 
   
== LDAP: Name resolution did not work for local numbers ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=112320 112320]
|}
The customer did not entry the phone number im LDAP Server including area code for local numbers.<br/><br/><!--<br/>cdr.c<br/>-->
   
== Fixed wrong reporting data for certain call forwards ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=112365 112365]
|}
Certain call forward scenarios produced wrong caller information reports.<br/>Old CDRs will be still wrongly shown. Just new CDRs are fixed.<br/><br/><!--<br/>cdr.c<br/>-->
   
= V1 Hotfix 28 (10391) =
These are the fixes included in Reporting V1 hotfix 28.<!---->
[http://mantis.innovaphone.com/view.php?id=112814 Definition]
 
 
   
== Reporting-LDAP: case insensitive comparison for name- and numberattributes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=114996 114996]
|}
Name attributes were not found.<br/><br/><!--<br/>cdr.c<br/>-->
   
== Reporting-LDAP: search only for configured name- and number attributes ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=115349 115349]
|}
Client was asking for all existing attributes. We save now some bandwidth.<br/><br/><!--<br/>cdr.c<br/>-->
   
= V1 Hotfix 29 (10396) =
These are the fixes included in Reporting V1 hotfix 29.<!---->
[http://mantis.innovaphone.com/view.php?id=116358 Definition]
 
 
   
== Reporting cleanup might have failed ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=113885 113885]
|}
e.g. if the database connection broke down during cleanup, the database was in a bad state afterwards.<br/><br/><!--<br/>include.php<br/>config_reporting.php (just V1)<br/>-->
   
= V1 Hotfix 30 (10397) =
These are the fixes included in Reporting V1 hotfix 30.<!---->
[http://mantis.innovaphone.com/view.php?id=118522 Definition]
 
 
   
== XML escape callback information in reports ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=118658 118658]
|}
Otherwise the report can't be displayed.<br/><br/><!--<br/>pg_report.c<br/>-->
   
= V1 Hotfix 31 (10400) =
These are the fixes included in Reporting V1 hotfix 31.<!---->
[http://mantis.innovaphone.com/view.php?id=119797 Definition]
 
 
   
== LDAP: no external line defined, direct dialing case. ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=127830 127830]
|}
Reporting was not resolving names in this special situation where no Trunk Object was defined.<br/><br/><!--<br/>cdr.c<br/>-->
   
== Optimized sorting for CDRs with the same timestamps ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=128195 128195]
|}
CDRs with the same timestamp are now additionally sorted by their database ID.<br/><br/><!--<br/>report.php<br/>-->
   
= V1 Hotfix 32 (10401) =
These are the fixes included in Reporting V1 hotfix 32.<!---->
[http://mantis.innovaphone.com/view.php?id=128346 Definition]
 
 
   
== Fixed potential failure of reporting replication due to duplicated CDR guids ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=129490 129490]
|}
If there have been duplicated CDR guids the replication might have failed.<br/>This is fixed now.<br/><br/><!--<br/>replication.c<br/>include.php<br/>cdr_cleanup.php<br/>reporting_cleanup<br/>install_reporting.sh<br/>install_hotfix.sh<br/>psql_commands.txt<br/>psql_commands_undo.txt<br/>reporting_database.dump<br/>-->
   
= V1 Hotfix 33 (10404) =
These are the fixes included in Reporting V1 hotfix 33.<!---->
[http://mantis.innovaphone.com/view.php?id=130501 Definition]
 
 
   
= V1 Hotfix 34 (10405) =
These are the fixes included in Reporting V1 hotfix 34.<!---->
[http://mantis.innovaphone.com/view.php?id=133955 Definition]
 
 
   
== LDAP: no name resolution if external line prefix was longer than one digit ==
 
{|
|Status
|<font><font color="green">Closed</font></font>
|-
|Id
|[http://mantis.innovaphone.com/view.php?id=138518 138518]
|}
external line can be longer.
   
= V1 Hotfix 35 (10406) =
These are the fixes included in Reporting V1 hotfix 35.<!---->
[http://mantis.innovaphone.com/view.php?id=138700 Definition]
 
 
   
= V1 Hotfix 36 (10408) =
These are the fixes included in Reporting V1 hotfix 36.<!---->
[http://mantis.innovaphone.com/view.php?id=143321 Definition]
 
 
   
= V1 Hotfix 37 =
These are the fixes included in Reporting V1 hotfix 37.<!---->
[http://mantis.innovaphone.com/view.php?id=154920 Definition]

Revision as of 16:41, 5 April 2016

This roadmap describes the V1 (that is, Reference9:Concept_Reporting based) Reporting based on the linux application platform.

This article is generated automatically. Do not edit! Please see the disclaimer before using the information presented here!


SQLSTATE[HY000] [2002] Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte. 1