Hi,

Please read the appropriate documentation, i.e. mysql one for answer to this question.

However, here is a quick hint that could be relevant to your problem: check that the host which the user cdradmin is allowed to connect from in the mysql user table is the same as the host cdrtool tries to connect from (if your user is allowed to connect from localhost but kamailio uses an other IP to connect, it will not work).

When you connect from the CLI, unless you explicitely specify otherwise, the host na;e used is "localhost".

Generally speaking, I would advise to try to go step-by-step for that sort of ambitious (for a first time) config.
Trying to install everything at once is a recipe for disaster, but YMMV.

Regards,

On Mon, 2008-10-20 at 23:13 +0100, Nuno Marques wrote:

Hi,

   I'm trying to follow the INSTALL.txt of the CDRTool to accomplish a nice installation of OpenSER 1.3.2 + Mediaproxy + SerMyAdmin + Asterisk + CDRTool + FreeRadius.
   All went well until i started CDRTool installation... it's a little confusing for a newbie like me but... all the steps of the installation seem to went well.
   When i go to the browser to look for the CDRTool portal it gives me this error:

Database error: pconnect as cdradmin to sipdb failed. Session halted.

   I thought it was a mysql users problem... so i went to the shell and tried to enter mysql with login and password for cdradmin, and... No problem. It worked fine. Mysql accepted the user login/password.
   Is there someone who can tell me where can i look for errors... I'm really stuck on this part...
   Thanks in advance,

                           Nuno

_______________________________________________
Users mailing list
Users@lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users

Jérôme Martin | LongPhone
Responsable Architecture Réseau
122, rue la Boetie | 75008 Paris
Tel : +33 (0)1 56 26 28 44
Fax : +33 (0)1 56 26 28 45
Mail : jmartin@longphone.fr
Web : www.longphone.com