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 listUsers@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

"It still can be. Have you double-checked the cdradmin GRANT permissions for the sipdb access rights ? Is the database created under that name ?"

*Maybe this is my problem!* My OpenSER database it's called openser and not sipdb. Where, in the configuration of cdrtool, can i change this name? Still i have to GRANT permissions to cdradmin to openser database?

Many thanks for your help. Regards

Nuno

2008/10/21 Jerome Martin jmartin@longphone.fr

On Tue, 2008-10-21 at 14:24 +0100, Nuno Marques wrote:

As you can see cdradmin is with % and localhost in the host column.

This means that it can access the database from anywhere. True?

That is correct.

I have sermyadmin working fine, accessing the database.

Good, that seems to leave the mysql config side out (for install/basic setup).

When you say appropriate documentation are you refering to mysql

manual? I didn't understood... what is mysql one ?

Yes, I was referring to mysql one because you description seemed to point at a mysql configuration problem. It still can be. Have you double-checked the cdradmin GRANT permissions for the sipdb access rights ? Is the database created under that name ?

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...

Well, this is something I am afraid you'll have to do mostly on you own (we can explain, but only you can understand [image: ;-)] ). However, your current issue seems more basic than this.

Regards,

*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

Correction:

In the default config files, sipdb is the hostname of the DB server. The default DB name is cdrtool. It seems you did not configure your global.inc in /etc/cdrtool/global.inc at all. you must put in there your db host name or address, database name, etc...

On Tue, 2008-10-21 at 15:49 +0200, Jerome Martin wrote:

On Tue, 2008-10-21 at 14:24 +0100, Nuno Marques wrote:

...

As you can see cdradmin is with % and localhost in the host column. This means that it can access the database from anywhere. True?

That is correct.

...

I have sermyadmin working fine, accessing the database.

Good, that seems to leave the mysql config side out (for install/basic setup).

...

When you say appropriate documentation are you refering to mysql manual? I didn't understood... what is mysql one ?

Yes, I was referring to mysql one because you description seemed to point at a mysql configuration problem. It still can be. Have you double-checked the cdradmin GRANT permissions for the sipdb access rights ? Is the database created under that name ?

...

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...

Well, this is something I am afraid you'll have to do mostly on you own (we can explain, but only you can understand ;-) ). However, your current issue seems more basic than this.

Regards,

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

---

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

On Tue, 2008-10-21 at 16:34 +0100, Nuno Marques wrote:

Ok... i've checked global.inc and altered the hostname. But i still got the same problem. Can you tell me if cdradmin needs permissions to access openser database ? Sorry for this basic questions...

Again, all this is explained in great details in the README file I pointed you to...

Regards

     Nuno

2008/10/21 Jerome Martin jmartin@longphone.fr

    Correction:

    In the default config files, sipdb is the hostname of the DB
    server. The default DB name is cdrtool.
    It seems you did not configure your global.inc
    in /etc/cdrtool/global.inc at all.
    you must put in there your db host name or address, database
    name, etc...




    On Tue, 2008-10-21 at 15:49 +0200, Jerome Martin wrote:

    > 
    > On Tue, 2008-10-21 at 14:24 +0100, Nuno Marques wrote:
    > 
    > 
    > >    As you can see cdradmin is with % and localhost in the
    > > host column. This means that it can access the database
    > > from anywhere. True?
    > 
    > That is correct.
    > 
    > 
    > >    I have sermyadmin working fine, accessing the database.
    > 
    > Good, that seems to leave the mysql config side out (for
    > install/basic setup).
    > 
    > 
    > >    When you say appropriate documentation are you refering
    > > to mysql manual? I didn't understood... what is mysql
    > > one ?
    > 
    > Yes, I was referring to mysql one because you description
    > seemed to point at a mysql configuration problem.
    > It still can be. Have you double-checked the cdradmin GRANT
    > permissions for the sipdb access rights ? Is the database
    > created under that name ?
    > 
    > 
    > >    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...
    > 
    > Well, this is something I am afraid you'll have to do mostly
    > on you own (we can explain, but only you can
    > understand ;-) ).
    > However, your current issue seems more basic than this.
    > 
    > Regards,
    > 
    > 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
    > 
    > 
    > 
    > 
    > 
    > _______________________________________________
    > 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

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