VoIP Mailing List Archives

[preetha.ayyappan at gm...]

hi,
I am getting the call records saved in the folder cdr-csv.I need to save this cdr details in mysql database.Is it possible to do?If yes please assist me to do this.

Thanks

[wasim at convergence.pk]

look for cdrload.pl script in /usr/src/freeswitch/scripts/contrib/wasim
use with discretion and fix as needed ...

On Fri, Sep 26, 2008 at 6:27 PM, preetha Ayyappan <preetha.ayyappan@gmail.com (preetha.ayyappan@gmail.com)> wrote:

[anthony.minessale at g...]

you have 2 options in the category of just doing it simple.

1) write a cron job to kill -HUP `cat /usr/local/freeswitch/logs/freeswitch.pid` then when the cdr file rotates parse and insert it into the db.
2) alter the template in cdr_csv.conf.xml so it directly creates sql statements instead of CSV data and do the same as option 1 but a lot easier.

For anything more advanced than that it would take a lot more understanding on your part and explanation on mine.


On Fri, Sep 26, 2008 at 7:27 AM, preetha Ayyappan <preetha.ayyappan@gmail.com (preetha.ayyappan@gmail.com)> wrote:

[preetha.ayyappan at gm...]

Thanks wasim.I have changed the line
my $dbh = DBI->connect("DBI:mysql:database=freeswitchdb;host=localhost","freeswitch","1234") in /usr/src/freeswitch/scripts/contrib/wasim/cdrload.pl .then i called an extension.Now the call details are recorded only in master.csv.I am not getting the details updated in database.Anything i have to do further after changing the above line in cdrload.pl ?

[wasim at convergence.pk]

On Sat, Sep 27, 2008 at 10:43 AM, preetha Ayyappan <preetha.ayyappan@gmail.com (preetha.ayyappan@gmail.com)> wrote:

[preetha.ayyappan at gm...]

Actually now I can able to save the call detail records in the database through php.But the csv file does not contains the disposition details.How can i get the disposition in csv file?

Thanks.


On 9/26/08, Anthony Minessale <anthony.minessale@gmail.com (anthony.minessale@gmail.com)> wrote:

[wasim at convergence.pk]

Sat, Sep 27, 2008 at 2:26 PM, preetha Ayyappan <preetha.ayyappan@gmail.com (preetha.ayyappan@gmail.com)> wrote:

[preetha.ayyappan at gm...]

I dont understand.could you please tell me in brief?

On 9/27/08, Wasim Baig <wasim@convergence.pk (wasim@convergence.pk)> wrote:

[freeswitch at cartisso...]

I ended up editing the video footage from Cluecon 2008 instead of
working on coding. I might be able to work up a direct logger (a
revamping of the original mod_cdr) in the near future if all works out
well for me time-wise.

--
Yossi Neiman
Cartis Solutions, Inc.
http://www.cartissolutions.com



preetha Ayyappan wrote:

[brian at freeswitch.org]

Everyone thank Yossi for his hard work on the Cluecon Videos.

http://files.freeswitch.org/cluecon_2008/


Please check them out.


/b



On Sep 29, 2008, at 10:31 AM, Yossi Neiman wrote: