<!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 Gabriel,<br>
<br>
the root of your problem is the incompatibility between the version
of cdrtool and opensips - the trusted_peers table is part of an
older version of opensips : starting with 1.6.0 version, the table
was merged into "addresses" table - see
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Main/Ver160#toc30">http://www.opensips.org/Main/Ver160#toc30</a>).<br>
<br>
So the solution you had (creating the view is ok, as it is offering
to cdrtool the table in the old format, but using the new opensips
table)<br>
<br>
Regards,<br>
Bogdan<br>
<br>
On 10/24/2011 08:56 PM, Gabriel Bermudez wrote:
<blockquote
cite="mid:CAEdRDQF8LJ5QBpjDpEipWXQBXLjnf0CbRAzu_T87Hr4dah9ajQ@mail.gmail.com"
type="cite">Hi,
<div><br>
</div>
<div>I was getting the following error with cdrtool 8.2.2 and
opensips 1.6.2</div>
<div><br>
</div>
<div>
<div>Oct 24 19:20:02 server2 cdrtool[27021]: Database error:
Invalid SQL: select * from trusted_peers</div>
</div>
<div><br>
</div>
<div>I remembered a similar thread about cdrtool complaining about
a trusted table so I adapted the solution to this and it
worked!!! (<a moz-do-not-send="true"
href="http://www.openser.org/pipermail/users/2009-December/009882.html">http://www.openser.org/pipermail/users/2009-December/009882.html</a>).
Can somebody confirm this is the right solution or I was just
lucky today :D</div>
<div><br>
</div>
<div>Regards,</div>
<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>
<br>
<pre class="moz-signature" cols="72">--
Bogdan-Andrei Iancu
OpenSIPS eBootcamp - 19th of September 2011
OpenSIPS solutions and "know-how"</pre>
</body>
</html>