<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Kib Eki a écrit :
<blockquote cite="mid42E73B51.6070907@gmx.net" type="cite">Hi,
<br>
<br>
I configured cdr_mysql (addons 1.0.9) to write the cdr records to the
mysql db.
<br>
<br>
The problem is that no records are written to the db. Why?
<br>
<br>
I can import the csv-file to the db. so i assume the db is setup
correct.
<br>
<br>
Is there any chance to get debug from cdr_mysql to find his problem?
<br>
<br>
This is my cdr_mysql.conf file:
<br>
[global]
<br>
hostname=localhost
<br>
dbname=cdr
<br>
password=passw0rd
<br>
user=root
<br>
;port=3306
<br>
;sock=/tmp/mysql.sock
<br>
userfield=1
<br>
<br>
Thanks and Regards
<br>
<br>
_______________________________________________
<br>
Asterisk-Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a>
<br>
To UNSUBSCRIBE or update options visit:
<br>
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a>
<br>
</blockquote>
<br>
Asterisk don't use directly mysql database for cdr, astersisk use odbc
and odbc connect to mysql.<br>
<br>
So you must configure odbc corectly wiyt libmyodbc (on debian)<br>
the config file are here:<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<font size="2">/etc/odbcinst.ini :</font><br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<font size="2">[MySQL]</font>
<br>
<font size="2">Description = MySQL
driver</font>
<br>
<font size="2">Driver =
/usr/lib/odbc/libmyodbc.so</font>
<br>
<font size="2">Setup =
/usr/lib/odbc/libodbcmyS.so</font>
<br>
<font size="2">CPTimeout =</font>
<br>
<font size="2">CPReuse =</font>
<br>
<font size="2">FileUsage = 1</font><font face="Nimbus Mono L"><font
size="2"><br>
<br>
<br>
</font></font>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style><br>
<br>
<font size="2">/etc/odbc.ini :</font><br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<font size="2">[MySQL-asterisk]</font>
<br>
<font size="2">Description =
MySQL Asterisk Database</font>
<br>
<font size="2">Driver =
MySQL</font>
<br>
<font size="2">Socket =
/var/run/mysqld/mysqld.sock</font>
<br>
<font size="2">Server = @ipofMysqlddatabase (not domain name)</font>
<br>
<font size="2">User =</font>
<br>
<font size="2">Password =</font>
<br>
<font size="2">Database =
asterisk</font>
<br>
<font size="2">Option = 3</font>
<br>
<font size="2">#Port =</font><br>
<br>
<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<font size="2">/etc/asterisk/cdr_odbc.conf</font> :<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.9.{milestone} (Linux)">
<meta name="CREATED" content="20050620;11453200">
<meta name="CHANGED" content="20050727;10480800">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<font size="2">[global]</font>
<br>
<font size="2">dsn=MySQL-asterisk</font>
<br>
<font size="2">username=database_username</font>
<br>
<font size="2">password=database_password</font>
<br>
<font size="2">loguniqueid=yes</font><br>
<br>
<br>
</body>
</html>