Mark Tomlinson wrote:
Hi,
I am also having problems setting up ODBC logging and alike cant find anything in the documentation that explains how to configure it.
thanks
mark
My example:
Install MySQL
Install MySQL ODBC driver
In MySQL create a database (example: pbx)
Under pbx database, create a table (example: calllog)
Fields:
date--format date
time--format time
from_number--format VARCHAR/CHAR (30 characters may be enough)
to_number-- same format as dfrom_number
duration--format int
Create a DSN in MySQL ODBC (DSN name example: MySQL) with database point to pbx database
In Axon ODBC Log
ODBC DSN: <enter your DSN name (my example is "MySQL")>
User name: <your MySQL login name>
Password: <your MySQL password>
SQL COMMAND: <example INSERT INTO calllog (date, time, from_number, to_number, duration) values ('%date%', '%time%', '%from%','%to%','%duration%')>
You can display the above information on web by means of php script. If you want to calculate the time for billing, set up another user table and set the tariff, then total cost=tariff X duration
If your config is properly done, your can trace the SQL command under Axon log txt some what like this:
16:32:20 Executing SQL command: INSERT INTO calllog (date, time, from_number, to_number, duration) values ('2007-11-06', '16:31:55', '98xxx','sip:984201011@10.0.xxx.xxx:5060','24')
Hope this can help