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@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*@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*@longphone.fr Web : www.longphone.com