Hi all,
I'm pretty new to OpenSER, and I'm trying to get it working here. I have one OpenSER machine and a few asterisk machines behind this one. All my call go the OpenSER that does load balancing and fail over between my asterisk servers. Up to now I was getting the CDR from all my asterisk, but that is not going very well since I have to search in all asterisk machines to get the cdr for one extension. So I want to get the cdr directly from the openser thats where all calls have to pass. I found some people talking about CDRTool, but I think it does a little too much for me. I'm just looking for some tool that saves the information I need inside mysql so I can build my cdr report with some simple sql queries. Does anyone in here get the cdr out of the openser or is that not even possible? All help is very welcome here.
Thanks in advance,
Thiago
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
El Viernes, 18 de Enero de 2008, tloginbr-openserbr@yahoo.com.br escribió:
Up to now I was getting the CDR from all my asterisk, but that is not going very well since I have to search in all asterisk machines to get the cdr for one extension
You can use the same database for all the Asterisk, so all of them will report CDR in same "cdr" table.
Iñaki Baz Castillo wrote:
You can use the same database for all the Asterisk, so all of them will report CDR in same "cdr" table.
However, I would not rely on CDRs that OpenSER provides, as all it takes is a rouge UA to not send a BYE which will give you incorrect CDRs.
Plus, there are other SIP attacks (if you will) that can lead to incorrect CDRs as well.
Jeremy McNamara
El Viernes, 18 de Enero de 2008, Jeremy McNamara escribió:
Iñaki Baz Castillo wrote:
You can use the same database for all the Asterisk, so all of them will report CDR in same "cdr" table.
However, I would not rely on CDRs that OpenSER provides, as all it takes is a rouge UA to not send a BYE which will give you incorrect CDRs.
But Asterisk will send a BYE after X time without RTP, so it will make fixed OpenSer CDR's.
Thanks a lot for the help guys. I ended up setting up a mysql machine to handle all cdr from my asterisk machines, configuring inside cdr_mysql.conf.
Thiago --- Jeremy McNamara jj@nufone.net escreveu:
Iñaki Baz Castillo wrote:
But Asterisk will send a BYE after X time without RTP, so it will
make fixed
OpenSer CDR's.
Sure....provided one uses Asterisk for their media processing situation and are using a recent version of Asterisk :)
Jeremy
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
Hi Thiago,
Check the admin training materials:
http://www.openser.org/mos/view/OpenSER-Admin-Course---Rome-2007/#Materials
There is a full section about accounting.
Regards, Bogdan
tloginbr-openserbr@yahoo.com.br wrote:
Hi all,
I'm pretty new to OpenSER, and I'm trying to get it working here. I have one OpenSER machine and a few asterisk machines behind this one. All my call go the OpenSER that does load balancing and fail over between my asterisk servers. Up to now I was getting the CDR from all my asterisk, but that is not going very well since I have to search in all asterisk machines to get the cdr for one extension. So I want to get the cdr directly from the openser thats where all calls have to pass. I found some people talking about CDRTool, but I think it does a little too much for me. I'm just looking for some tool that saves the information I need inside mysql so I can build my cdr report with some simple sql queries. Does anyone in here get the cdr out of the openser or is that not even possible? All help is very welcome here.
Thanks in advance,
Thiago
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento!
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
Iñaki Baz Castillo -
Jeremy McNamara -
tloginbr-openserbr＠yahoo.com.br