<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Ardogan,<br>
<br>
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:<br>
echo "---".$sql."---"<br>
Execute the query in pgsql and send back both the query and postgres
error.<br>
<br>
Regards,<br>
Alex<br>
<br>
<br>
On 08/13/2012 02:47 PM, Ardogan Tekinsoy wrote:
<blockquote
cite="mid:CAF+rJRbSpymX5Tj6_E2eGTuVWEbTJk-Pu5TcSsb54U_PekEaRg@mail.gmail.com"
type="cite"><br>
<div class="gmail_quote">I have configured opensip-cp with
postgresql. DB connection works and I see the results on Domains
or Users/User Management pages. <br>
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. <br>
<br>
Failed to issue query, error message : MDB2 Error: unknown error<br>
<br>
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. <br>
</div>
<br>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>