[Asterisk-Users] Mysql CDR

[Paulo Mannheimer]

Hi Miklos,
 
try starting * with -vvvvvvvvvvvc and see if there is any warning
 
also, try connecting to your mysql server by issuing >mysql
asteriskcdrdb then 
 
> show tables;
> select * from cdr;
 
best,
 
PHM

-----Original Message-----
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of listas
iPfone
Sent: sexta-feira, 12 de dezembro de 2003 16:47
To: Asterisk-Users at lists.digium.com
Subject: [Asterisk-Users] Mysql CDR


Hi all
 
I just installed the mysql cdr support and my database is not
registering the calls :(
 
using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so
are loaded
 
It is necessary to unload  the cdr_csv.so? how to do it?
 
in crd_mysql.conf  i have:
 
[global]
hostname=localhost
dbname=asteriskcdrdb
password=new_password 
user=asteriskcdruser
;port=3306
;sock=/tmp/mysql.sock
 
i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be
there ..or not?
 
and in modules.conf i have:
 
load => cdr_addon_mysql.so
 
It is correct? something more is needed? ( i created the database and
table from wiki instructions)
 
How can i know if asterisk is or not trying to register the calls to the
database?
 
 
 
Thanks!
 
miklos
 
 
 
iPFONE Telefonia IP
Rua Caio Graco 735 São Paulo SP 
iPBX +55 11 3801-3702
UK +44 870 - 3403539
FWD 64662
sip:ipfone at sipserver.com.br 
www.ipfone.com.br
info at ipfone.com.br 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031212/d6b5e58b/attachment.htm