Finally i've discovered the problem with CDRTool and successfully put it working (problems in the global.inc configuration).<br>Thanks to all who helped me.<br>Now i have a problem inside CDRTool - when i choose the menu sessions it gives me this error:<br>
<br><h1>OpenSER (MediaProxy 2.x)</h1><font color="red">Error connecting to <a href="http://10.0.0.1:25061">10.0.0.1:25061</a>: Connection timed out (110)<font color="#000000"><br><br>The problem is that i'm not using Mediaproxy 2.x, i'm using mediaproxy <a href="http://1.9.1.">1.9.1.</a><br>
Can anyone tell me if the CDRTool 6.6.10 is compatible with mediaproxy 1.9.x.<br>If it is compatible with 1.9.x how can i change the configuration so that CDRT can connect to mediaproxy?<br><br>Thanks in advance.<br><br>BR,<br>
<br>Nuno<br></font></font><br><br><br><div class="gmail_quote">2008/10/21 Jerome Martin <span dir="ltr"><<a href="mailto:jmartin@longphone.fr">jmartin@longphone.fr</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div class="Ih2E3d">
On Tue, 2008-10-21 at 16:34 +0100, Nuno Marques wrote:<br>
<blockquote type="CITE">
Ok... i've checked global.inc and altered the hostname.<br>
But i still got the same problem.<br>
Can you tell me if cdradmin needs permissions to access openser database ?<br>
Sorry for this basic questions...<br>
</blockquote>
<br></div>
Again, all this is explained in great details in the README file I pointed you to...<div><div></div><div class="Wj3C7c"><br>
<br>
<blockquote type="CITE">
<br>
Regards<br>
<br>
Nuno<br>
<br>
</blockquote>
<blockquote type="CITE">
2008/10/21 Jerome Martin <<a href="mailto:jmartin@longphone.fr" target="_blank">jmartin@longphone.fr</a>>
</blockquote>
<blockquote type="CITE">
<blockquote>
Correction:<br>
<br>
In the default config files, sipdb is the hostname of the DB server. The default DB name is cdrtool.<br>
It seems you did not configure your global.inc in /etc/cdrtool/global.inc at all.<br>
you must put in there your db host name or address, database name, etc...
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<br>
<br>
On Tue, 2008-10-21 at 15:49 +0200, Jerome Martin wrote:<br>
<br>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">
<br>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">
On Tue, 2008-10-21 at 14:24 +0100, Nuno Marques wrote:<br>
<br>
<blockquote type="CITE">
As you can see cdradmin is with % and localhost in the host column. This means that it can access the database from anywhere. True?<br>
</blockquote>
That is correct.<br>
<br>
<blockquote type="CITE">
I have sermyadmin working fine, accessing the database.<br>
</blockquote>
Good, that seems to leave the mysql config side out (for install/basic setup).<br>
<br>
<blockquote type="CITE">
When you say appropriate documentation are you refering to mysql manual? I didn't understood... what is mysql one ?<br>
</blockquote>
Yes, I was referring to mysql one because you description seemed to point at a mysql configuration problem.<br>
It still can be. Have you double-checked the cdradmin GRANT permissions for the sipdb access rights ? Is the database created under that name ?<br>
<br>
<blockquote type="CITE">
I think that my problem at this time is understand the big picture about CDRTool, mainly when it comes to database structure, and some mechanisms...<br>
</blockquote>
Well, this is something I am afraid you'll have to do mostly on you own (we can explain, but only you can understand <img src="cid:1224596969.32688.21.camel@anice.longphone.fr" alt=";-)" align="middle" border="0"> ).<br>
However, your current issue seems more basic than this.<br>
<br>
Regards,<br>
<table width="100%" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<br>
<b><font size="2"><font color="#808080">Jérôme Martin </font></font></b><b><font size="2"><font color="#bebebe">| </font></font></b><b><font size="2"><font color="#99cc00">LongPhone</font></font></b><br>
<b><font size="2"><font color="#808080">Responsable Architecture Réseau</font></font></b><br>
<font size="2"><font color="#bebebe">122, rue la Boetie | 75008 Paris </font></font><br>
<font size="2"><font color="#bebebe">Tel : +33 (0)1 56 26 28 44</font></font><br>
<font size="2"><font color="#bebebe">Fax : +33 (0)1 56 26 28 45</font></font><br>
<font color="#c0c0c0">Mail :</font><font color="#99cc00"> </font><font color="#99cc00"><b><font size="2">jmartin</font></b></font><font size="2"><font color="#bebebe">@<a href="http://longphone.fr" target="_blank">longphone.fr</a></font></font><br>
<font color="#c0c0c0">Web :</font><font color="#99cc00"> <a href="http://www.longphone.com" target="_blank">www.longphone.com</a></font><br>
<br>
<br>
<br>
<br>
</td>
</tr>
</tbody></table>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">
<pre>_______________________________________________
Users mailing list
</pre>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<blockquote type="CITE">
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a> <a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a>
</blockquote>
</blockquote>
</blockquote>
<blockquote type="CITE">
<blockquote>
<table width="100%" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<br>
<b><font size="2"><font color="#808080">Jérôme Martin </font></font></b><b><font size="2"><font color="#bebebe">| </font></font></b><b><font size="2"><font color="#99cc00">LongPhone</font></font></b><br>
<b><font size="2"><font color="#808080">Responsable Architecture Réseau</font></font></b><br>
<font size="2"><font color="#bebebe">122, rue la Boetie | 75008 Paris </font></font><br>
<font size="2"><font color="#bebebe">Tel : +33 (0)1 56 26 28 44</font></font><br>
<font size="2"><font color="#bebebe">Fax : +33 (0)1 56 26 28 45</font></font><br>
<font color="#c0c0c0">Mail :</font><font color="#99cc00"> </font><font color="#99cc00"><b><font size="2">jmartin</font></b></font><font size="2"><font color="#bebebe">@<a href="http://longphone.fr" target="_blank">longphone.fr</a></font></font><br>
<font color="#c0c0c0">Web :</font><font color="#99cc00"> <a href="http://www.longphone.com" target="_blank">www.longphone.com</a></font><br>
<br>
<br>
<br>
</td>
</tr>
</tbody></table>
</blockquote>
</blockquote>
<blockquote type="CITE">
<br>
</blockquote>
<table width="100%" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<br>
<b><font size="2"><font color="#808080">Jérôme Martin </font></font></b><b><font size="2"><font color="#bebebe">| </font></font></b><b><font size="2"><font color="#99cc00">LongPhone</font></font></b><br>
<b><font size="2"><font color="#808080">Responsable Architecture Réseau</font></font></b><br>
<font size="2"><font color="#bebebe">122, rue la Boetie | 75008 Paris </font></font><br>
<font size="2"><font color="#bebebe">Tel : +33 (0)1 56 26 28 44</font></font><br>
<font size="2"><font color="#bebebe">Fax : +33 (0)1 56 26 28 45</font></font><br>
<font color="#c0c0c0">Mail :</font><font color="#99cc00"> </font><font color="#99cc00"><b><font size="2">jmartin</font></b></font><font size="2"><font color="#bebebe">@<a href="http://longphone.fr" target="_blank">longphone.fr</a></font></font><br>
<font color="#c0c0c0">Web :</font><font color="#99cc00"> <a href="http://www.longphone.com" target="_blank">www.longphone.com</a></font><br>
<br>
<br>
</td>
</tr>
</tbody></table>
</div></div></div>
</blockquote></div><br>