Hi Iñaki,
For me this is functioning fine, I have just enabled the database accoutning in mediaproxy.ini and it worked as soon as I got mediaproxy working correctly... Do you know if mediaproxy is writing any data to the database? For MySQL you need SQLite and mysql_python. Also for authentication reasons the MySQL user you connect as from Mediaproxy needs to have their password set as OLD_PASSWORD (old/poor security type password) in the users table in mysql DB.
cheers Andy.
Hi, my installation of CDRTool with Mediaproxy and FreeRadius works ok. I see correctly the accounting detail in CDR's (except the fact that I have no yet created rated, profiles and so...). Also I see correctly the web SIP trace created with "siptrace" module.
But in the CDR view the columns "In" and "Out" are always empty. How to fill them? what do they depend on? I've not read nothing about them in the doc.
Thanks a lot.
El Miércoles, 13 de Febrero de 2008, Andy Smith escribió:
Hi Iñaki,
For me this is functioning fine, I have just enabled the database accoutning in mediaproxy.ini and it worked as soon as I got mediaproxy working correctly...
So you see "In" or/and "Out"... ANd do you mean that this info is provided by MediaProxy instead of be deduced by CDRTool in some way?
Do you know if mediaproxy is writing any data to the database? For MySQL you need SQLite and mysql_python. Also for authentication reasons the MySQL user you connect as from Mediaproxy needs to have their password set as OLD_PASSWORD (old/poor security type password) in the users table in mysql DB.
I use Radius in MediaProxy and it writes correctly the info, so...
I will investigate it more. Thanks a lot.
El Miércoles, 13 de Febrero de 2008, Iñaki Baz Castillo escribió:
El Miércoles, 13 de Febrero de 2008, Andy Smith escribió:
Hi Iñaki,
For me this is functioning fine, I have just enabled the database accoutning in mediaproxy.ini and it worked as soon as I got mediaproxy working correctly...
So you see "In" or/and "Out"... ANd do you mean that this info is provided by MediaProxy instead of be deduced by CDRTool in some way?
Hummm, the only info provided by MediaProxy (at least when logging it via radius) is the following:
AcctSessionTime = AcctSessionTime + IF(ConnectInfo_stop IS NULL, %{Acct-Session-Time}, 0), \ AcctStopTime = DATE_ADD(AcctStartTime, INTERVAL AcctSessionTime SECOND), \ AcctInputOctets = AcctInputOctets + %{Acct-Input-Octets}, \ AcctOutputOctets = AcctOutputOctets + %{Acct-Output-Octets}, \ SipUserAgents = '%{Sip-User-Agents}', \ SipCodecs = '%{Media-Codecs}', \ SipApplicationType = '%{Sip-Applications}', \ MediaInfo = '%{Media-Info}', \ Normalized = '0' \
I can't see there any info related to "In" or "Out".
Anyway, what are these "In" and "Out" supposed to mean??
Thanks.
-
Andy Smith -
Iñaki Baz Castillo