[OpenSIPS-Users] opensips-cp MDB2 Error: unknown error

[Alex Ionescu]

Hi Ardogan,

OpenSIPS CP was initially built to work with MySQL. At some point PEAR 
was used in order to be able to use other DB too. Postgres has some 
particularities and there is a chance that a query was build for MySQL 
and Postgres does not support it. What you can do is to go to 
"/opensips-cp/web/tools/system/cdrviewer/template/cdrviewer.main.php" 
and insert this right before line 133:
echo "---".$sql."---"
Execute the query in pgsql and send back both the query and postgres error.

Regards,
Alex


On 08/13/2012 02:47 PM, Ardogan Tekinsoy wrote:
>
> I have configured opensip-cp with postgresql. DB connection works and 
> I see the results on Domains or Users/User Management pages.
> But I get an error on CDRViewer page when I select default Start Date 
> - End Date range. Page doesn't lists the results and this error 
> message is seen on the page.
>
> Failed to issue query, error message : MDB2 Error: unknown error
>
> I have records in my cdrs table. Is it possible to trace the details 
> of this error in a log file so I can give you more information as well.
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120813/832c9a59/attachment.htm>