Thanks for your response.

   But i've already verified the user location detail and it's ok in the CLI, but with browser it's giving the same error.
   I made a query to mysql.user table and get this result:

+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | cdradmin         |
| %         | locker           |
| %         | openser          |
| %         | openserro        |
| %         | sermyadmin       |
| localhost | cdradmin         |
| localhost | debian-sys-maint |
| localhost | locker           |
| localhost | openser          |
| localhost | openserro        |
| localhost | root             |
| localhost | sermyadmin       |
| openser   | root             |
+-----------+------------------+
13 rows in set (0.00 sec)

   As you can see cdradmin is with % and localhost in the host column. This means that it can access the database from anywhere. True?
   I have sermyadmin working fine, accessing the database.
   When you say appropriate documentation are you refering to mysql manual? I didn't understood... what is mysql one ?
   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...
   That's why i was asking for help in documentation...
   Thanks anyway.

   BR

        Nuno

2008/10/21 Jerome Martin <jmartin@longphone.fr>
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