asterisk users - Jul 2005 - cdr_mysql does not write to mysql db

Hi,

I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db.

The problem is that no records are written to the db. Why?

I can import the csv-file to the db. so i assume the db is setup correct.

Is there any chance to get debug from cdr_mysql to find his problem?

This is my cdr_mysql.conf file:
[global]
hostname=localhost
dbname=cdr
password=passw0rd
user=root
;port=3306
;sock=/tmp/mysql.sock
userfield=1

Thanks and Regards

Dear Kib,

As I believe the Realtime options concerning the mysql database can only be used
with the Asterisk CVS-HEAD version it's still not implemented on Asterisk v
1.0.*
.

Thx
MAG

Kib Eki wrote:
> Hi,
>
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql
db.
>
> The problem is that no records are written to the db. Why?
>
> I can import the csv-file to the db. so i assume the db is setup correct.
>
> Is there any chance to get debug from cdr_mysql to find his problem?
>
> This is my cdr_mysql.conf file:
> [global]
> hostname=localhost
> dbname=cdr
> password=passw0rd
> user=root
> ;port=3306
> ;sock=/tmp/mysql.sock
> userfield=1
>
> Thanks and Regards
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
--
Thx
MAG


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

Kib Eki a ?crit :
> Hi,
>
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the
> mysql db.
>
> The problem is that no records are written to the db. Why?
>
> I can import the csv-file to the db. so i assume the db is setup correct.
>
> Is there any chance to get debug from cdr_mysql to find his problem?
>
> This is my cdr_mysql.conf file:
> [global]
> hostname=localhost
> dbname=cdr
> password=passw0rd
> user=root
> ;port=3306
> ;sock=/tmp/mysql.sock
> userfield=1
>
> Thanks and Regards
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users

Asterisk don't use directly mysql database for cdr, astersisk use odbc
and odbc connect to mysql.

So you must configure odbc corectly wiyt libmyodbc (on debian)
the config file are here:

/etc/odbcinst.ini :

[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
CPTimeout CPReuse FileUsage = 1




/etc/odbc.ini :

[MySQL-asterisk]
Description = MySQL Asterisk Database
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = @ipofMysqlddatabase (not domain name)
User Password Database = asterisk
Option = 3
#Port 


/etc/asterisk/cdr_odbc.conf :

[global]
dsn=MySQL-asterisk
username=database_username
password=database_password
loguniqueid=yes


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

Try to put the IP of you CDR server instead of 'localhost', that's
work for
me.

Regards.
----- Original Message ----- 
From: "Kib Eki" <kibeki@gmx.net>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users@lists.digium.com>
Sent: Wednesday, July 27, 2005 9:44 AM
Subject: [Asterisk-Users] cdr_mysql does not write to mysql db

> Hi,
>
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the
mysql db.
>
> The problem is that no records are written to the db. Why?
>
> I can import the csv-file to the db. so i assume the db is setup correct.
>
> Is there any chance to get debug from cdr_mysql to find his problem?
>
> This is my cdr_mysql.conf file:
> [global]
> hostname=localhost
> dbname=cdr
> password=passw0rd
> user=root
> ;port=3306
> ;sock=/tmp/mysql.sock
> userfield=1
>
> Thanks and Regards
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Kib Eki wrote:
> Hi,
> 
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the 
> mysql db.
> 
> The problem is that no records are written to the db. Why?
Do you have the module installed?

Is the module loaded?

What happens when you type "cdr mysql status" on asterisk command
line?
  You should see something like this:

cytrex*CLI> cdr mysql status
Connected to asterisk@localhost, port 3306 using table cdr for 7 hours, 
41 minutes, 21 seconds.
   Wrote 70 records since last restart.

If you get "no such command" then that means the module isn't
loaded.

If you are using "localhost" then you need to uncomment the sock and 
make sure it's path is correct.

Don't listen to those other guys. The first two were both wrong.

-Matthew

On Wed, 2005-07-27 at 09:44 +0200, Kib Eki wrote:
> Hi,
> 
> I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql
db.
> 
> The problem is that no records are written to the db. Why?
> 
> I can import the csv-file to the db. so i assume the db is setup correct.
> 
> Is there any chance to get debug from cdr_mysql to find his problem?
> 
> This is my cdr_mysql.conf file:
> [global]
> hostname=localhost
> dbname=cdr
> password=passw0rd
> user=root
> ;port=3306
> ;sock=/tmp/mysql.sock
> userfield=1
> 
> Thanks and Regards
> 
	I do not know if this has changed but I remember that when I first
installed the mysql cdr addon the database had to be named
"asteriskcdrdb" and the table where everything is written is
"cdr".

	Apart from that make sure that the module is loaded when you start
Asterisk.  Here is my cdr_mysql.conf:

[global]
hostname=localhost
dbname=asteriskcdrdb
table=cdr
password=dbpassword
user=dbuser
;port=3306
sock=/var/lib/mysql/mysql.sock
userfield=1

	I can see you are missing the "table=" from your config.


-- 
Telecomunicaciones Abiertas de Mexico
Carlos Chavez
Director de Tecnologia
+52-55-91169161 Ext. 2001
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20050727/6ece8fdd/attachment.pgp