21 Oct
2008
21 Oct
'08
12:13 a.m.
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
21 Oct
21 Oct
11:41 a.m.
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(a)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(a)longphone.fr
Web : www.longphone.com
3:24 p.m.
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(a)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*(a)longphone.fr
Web : www.longphone.com
3:49 p.m.
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(a)longphone.fr
Web : www.longphone.com
4:44 p.m.
"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(a)longphone.fr>
> 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*(a)longphone.fr
> Web : www.longphone.com
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 ?
4:58 p.m.
On Tue, 2008-10-21 at 15:44 +0100, Nuno Marques wrote:
"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?
Have you read http://cdrtool.ag-projects.com/browser/doc/INSTALL.txt ?
I think it explains the DB configuration part...
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(a)longphone.fr
Web : www.longphone.com
5:05 p.m.
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:
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(a)longphone.fr
Web : www.longphone.com
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(a)longphone.fr
Web : www.longphone.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users 
5:34 p.m.
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...
Regards
Nuno
2008/10/21 Jerome Martin <jmartin(a)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 [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*(a)longphone.fr
Web : www.longphone.com
_______________________________________________
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*(a)longphone.fr
Web : www.longphone.com
5:39 p.m.
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(a)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:
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(a)longphone.fr
Web : www.longphone.com
On Tue, 2008-10-21 at 14:24 +0100, Nuno Marques wrote:
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(a)longphone.fr
Web : www.longphone.com
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(a)longphone.fr
Web : www.longphone.com
_______________________________________________
Users mailing list
Users(a)lists.kamailio.org
http://lists.kamailio.org/cgi-bin/mailman/listinfo/users 
24 Oct
24 Oct
10:45 p.m.
Finally i've discovered the problem with CDRTool and successfully put it
working (problems in the global.inc configuration).
Thanks to all who helped me.
Now i have a problem inside CDRTool - when i choose the menu sessions it
gives me this error:
OpenSER (MediaProxy 2.x)Error connecting to 10.0.0.1:25061: Connection timed
out (110)
The problem is that i'm not using Mediaproxy 2.x, i'm using mediaproxy
1.9.1.
Can anyone tell me if the CDRTool 6.6.10 is compatible with mediaproxy
1.9.x.
If it is compatible with 1.9.x how can i change the configuration so that
CDRT can connect to mediaproxy?
Thanks in advance.
BR,
Nuno
2008/10/21 Jerome Martin <jmartin(a)longphone.fr>
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(a)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 [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*(a)longphone.fr
Web : www.longphone.com
_______________________________________________
Users mailing list
Users(a)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*(a)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*(a)longphone.fr
Web : www.longphone.com
5683
days inactive
5687
days old
9 comments
2 participants
participants (2)
-
Jerome Martin -
Nuno Marques