<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.3">
</HEAD>
<BODY>
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>
Again, all this is explained in great details in the README file I pointed you to...<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">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" ALIGN="middle" ALT=";-)" BORDER="0"> ).<BR>
However, your current issue seems more basic than this.<BR>
<BR>
Regards,<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<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">longphone.fr</A></FONT></FONT><BR>
<FONT COLOR="#c0c0c0">Web :</FONT><FONT COLOR="#99cc00"> <A HREF="http://www.longphone.com">www.longphone.com</A></FONT><BR>
<BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</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">Users@lists.kamailio.org</A> <A HREF="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</A>
</BLOCKQUOTE>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<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">longphone.fr</A></FONT></FONT><BR>
<FONT COLOR="#c0c0c0">Web :</FONT><FONT COLOR="#99cc00"> <A HREF="http://www.longphone.com">www.longphone.com</A></FONT><BR>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<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">@longphone.fr</FONT></FONT><BR>
<FONT COLOR="#c0c0c0">Web :</FONT><FONT COLOR="#99cc00"> <A HREF="http://www.longphone.com">www.longphone.com</A></FONT><BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>