[OpenSIPS-Users] [Kamailio-Users] Problems with CDRTool installation!

[Nuno Marques]

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 at 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 listUsers at lists.kamailio.orghttp://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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20081021/a9548308/attachment-0001.htm