21 Oct
2008
21 Oct
'08
4: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