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><br>Regards<br>
<br> Nuno<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>
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...<div><div></div><div class="Wj3C7c"><br>
<br>
On Tue, 2008-10-21 at 15:49 +0200, Jerome Martin wrote:<br>
</div></div><blockquote type="CITE"><div><div></div><div class="Wj3C7c">
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>
</td>
</tr>
</tbody></table>
</div></div><pre>_______________________________________________
Users mailing list
<div class="Ih2E3d"><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>
</div></pre>
</blockquote>
<table width="100%" cellpadding="0" cellspacing="0">
<tbody><tr>
<td>
<br><div class="Ih2E3d">
<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>
</div></td>
</tr>
</tbody></table>
</div>
</blockquote></div><br>