ing lines..
>
> extension=mysql.so
>
> Please let me know any additional config required.
>
> thanks,
>
>
> Rana
>
>
>
>
>
> --
>
> Date: Thu, 24 Jul 2008 07:02:42 +0200
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [OpenSER-U
Thu, 24 Jul 2008 07:02:42 +0200From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Re: [OpenSER-Users] CDRTool with OpenSERCC: users@lists.openser.org
Hi Rana,you need to have php4-mysql installed and loaded in your php code.DanB
On Thu, Jul 24, 2008 at 3:00 AM, Rana Dhekial <[EMAIL PROTECTED]> wrote:
We ar
Hi Rana,
you need to have php4-mysql installed and loaded in your php code.
DanB
On Thu, Jul 24, 2008 at 3:00 AM, Rana Dhekial <[EMAIL PROTECTED]> wrote:
> We are trying to install cdrtool on the same machine where OpenSER (
> 1.2.2 ) is running. We get the following error message when tryin
We are trying to install cdrtool on the same machine where OpenSER ( 1.2.2 )
is running. We get the following error message when trying to access the page:
http:///CDRToolFatal error: Call to undefined function:
mysql_pconnect() in /var/www/CDRTool/phplib/db_mysql.inc on line 73MySQL
version
AHA!! So THAT's what I was missing!!
Thanks a lot Adrian!
d
On Wed, Jun 18, 2008 at 2:14 AM, Adrian Georgescu <[EMAIL PROTECTED]>
wrote:
> David,
>
> When $RatingEngine['split_rating_table'] setting is true, after
> changing the rates
> in the web interface or by importing them, you must run t
David,
When $RatingEngine['split_rating_table'] setting is true, after
changing the rates
in the web interface or by importing them, you must run the script from
scripts/splitRatingTables.php to split the central billing_rates table
into
individual tables for each rate id. You do not need this
Well, in any case, now we both know how it works... ;)
thanks a lot!
d
On Mon, Jun 16, 2008 at 6:14 PM, Iñaki Baz Castillo <[EMAIL PROTECTED]>
wrote:
> El Monday 16 June 2008 18:06:08 David Villasmil escribió:
>
> > At least in my case, it doesn't find the rate... Same thing, I had to
> > creat
El Monday 16 June 2008 18:06:08 David Villasmil escribió:
> At least in my case, it doesn't find the rate... Same thing, I had to
> create the table...
>
> without creating the table:
>
> Jun 16 12:02:30 rgi-sql CDRTool[15559]: Error: Cannot find rates for
> callid= [EMAIL PROTECTED], billing
> [E
On Mon, Jun 16, 2008 at 5:55 PM, Iñaki Baz Castillo <[EMAIL PROTECTED]>
wrote:
> El Monday 16 June 2008 17:44:56 David Villasmil escribió:
>
> > But as it happens, when you specify a profile like I did: billing profile
> > is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED
> > "BIL
El Monday 16 June 2008 17:44:56 David Villasmil escribió:
> But as it happens, when you specify a profile like I did: billing profile
> is NORMAL, but RATE NAME is 1, then you MUST CREATE A TABLE CALLED
> "BILLING_RATES_1", I don't know if cdrtool is supposed to create it but
> didn't do it for me
El Monday 16 June 2008 17:27:21 David Villasmil escribió:
> Jun 16 11:18:37 rgi-sql ^\$V^H[15556]: Database error for query update
> billing_rates_Normal set
> gateway='82.144.106.187',domain='',subscriber='',destination='001',duration
>Rate='5',application='audio',connectCost='0' where id = '6' a
I finally got it work, I'd like to explain here what the problem was and how
I fixed it:
To start with, after installing cdrtool, and adding some info my tables
ended like this:
select * from destinations;
+++++-+---+
| id | gateway
I just found two errors... something noone ever said (at least to me) aobut
cdrtool, i got this on the syslog:
Jun 16 11:18:37 rgi-sql ^\$V^H[15556]: Database error for query update
billing_rates_Normal set
gateway='82.144.106.187',domain='',subscriber='',destination='001',durationRate='5',applica
El Monday 16 June 2008 16:53:37 David Villasmil escribió:
> Tis say that's what I have... except you don't expand on you Customers'
> table..
Yes sorry, in your first mail it cost to me to understand the tables.
Sincerelly the only advice I caould give to you is readin gslowly some times
the READ
Tis say that's what I have... except you don't expand on you Customers'
table..
mysql> select * from destinations; select * from billing_customers; select *
from billing_profiles;select * from billing_rates;
++-+++-+---+
| id | gateway | domain | sub
El Monday 16 June 2008 13:16:17 David Villasmil escribió:
> I also have installed and configure cdrtool, but I can't seem to make
> it work properly, as documentation is very bad I had to half-make it
> work in starts and fits. Now i got it to al least show the destination
> description as per the
Hello all,
Well after may headaches and countless trial and error, I finally
got openser to use the LCR module and force mediaproxy on all calls,
thanks Iñaki and Raul for your help!
I also have installed and configure cdrtool, but I can't seem to make
it work properly, as documentation is v
El Sábado, 7 de Junio de 2008, Adrian Georgescu escribió:
> If the call has 0 seconds duration, CDRTool does not calculate a cost,
> it is zero. The connection fee applies only if the call has a positive
> duration.
Yes Adrian, I'm sorry since I've realized of that just 2 minutes ago :)
--
Iñaki
If the call has 0 seconds duration, CDRTool does not calculate a cost,
it is zero. The connection fee applies only if the call has a positive
duration.
Adrian
Hi, RFC3261 says that a UAC should send inmediately a BYE after a 2XX
response
if the offer in the 2xx response is not a
Hi, RFC3261 says that a UAC should send inmediately a BYE after a 2XX response
if the offer in the 2xx response is not acceptable (when the INVITE has no
body). So this will generate an answered call of duration 0 (probably).
But if the CDRTool rate has "connect" fixed amount then this invalid c
Great,
many thanks Adrian.
DanB
On Wed, May 28, 2008 at 6:29 PM, Adrian Georgescu <[EMAIL PROTECTED]>
wrote:
> Dan, you are right and I found the problem. The fix will be available
> with the next CDRTool release due next week together with Mediaproxy 2.0
>
> Adrian
>
> If you need a fix now fo
Dan, you are right and I found the problem. The fix will be available
with the next CDRTool release due next week together with Mediaproxy 2.0
Adrian
If you need a fix now for your 6.4.1:
--- rating_lib-6.4.1.phtml 2008-05-28 18:25:18.0 +0200
+++ rating_lib.phtml2008-05-28 18:
Adrian,
I have noticed when upgrading from old 5.3.2 to 6.4.1
Bellow are the helps from both versions (notice ShowPrice command):
version
CDRTool version 5.3.2
help
Version
Help
ShowAccounts
MaxSessionTime From=sip:[EMAIL PROTECTED]
<[EMAIL PROTECTED]>To=sip:0031650222333 Duration=7200 Lock=1
Dan
I have no changed anything related to this. Usually I write in the
changelog about such dramatic changes.
What did you notice and between which versions?
Adrian
>
I have noticed that recently ShowPrice behavior has changed, and
since did
not find it in Changelog I decided t
El Wednesday 28 May 2008 14:37:57 Dan-Cristian Bogos escribió:
> If that was done, why is "To=" parameter still mandatory? The presence or
> absence of it does not make any different in queries, as far as I can see.
"To" header is mandatory (RFC 3261) in any SIP request. Probably it doesn't
resp
Guys,
I have noticed that recently ShowPrice behavior has changed, and since did
not find it in Changelog I decided to try my shoot over here .
There are no more queries based on destination number but DestinationId.
Was the support for destination number lost for good, or only temporarily?
If th
Adrian Georgescu <[EMAIL PROTECTED]> wrote:
> You must provision in the destinations table with all prefixes for
> PSTN destinations (at least all country codes). The software will
> find the longest match from that table.
Actually, destinations table entries are already present. This table
was
You must provision in the destinations table with all prefixes for
PSTN destinations (at least all country codes). The software will
find the longest match from that table.
Adrian
>>
Trying cdrtool prepaid rating, got stuck with something.
When a request like "MaxSessionTime From=sip:m
Hi!
Trying cdrtool prepaid rating, got stuck with something.
When a request like "MaxSessionTime From=sip:[EMAIL PROTECTED]
To=sip:[EMAIL PROTECTED] Duration=7200 Lock=0" is given, cdrtool
always return "0", no matter what amount of balance is available in
prepaid table. This is what I see in sy
Hello,
does anyone has set up the CDR Tool?
We set this up in 6.4.1 and have the Problem that we are not able to create
a billing user. We did not found anything regarding the soap/xml
Is it Possible to get a documentation or a example user?
Thank you
Wolfgang
Wolfgang Uelpenich
WU
Hello,
Iam New to this List and OpenSER...
Does anyone has set up the CDR Tool?
We set this up in 6.4.1 and have the Problem that we are not able to create
a billing user. We did not found anything regarding the soap/xml.
Is it Possible to get a documentation or a example user?
Thank you
Hi Iñaki,
I checked the code and made test calls that span multiple profiles.
The calculus is correct.
The confusion likely arises because StartTime is printed in each
span, while it is the StartTime of the call itself and not of the span.
Finally the sum of all spans equals the duration of
Hi, CDRTool can calculate the price of a call involving various spans (rates).
But it does it wrongly since the start time for each span is set to the start
time of the call, so the price is much higher than the correct one.
An example: This is a call of more than 3 days of duration. Note that i
El Friday 15 February 2008 09:27:14 Dan-Cristian Bogos escribió:
> Hi Iñaki,
>
> if I understand your question correctly, yes the columns names are correct.
> It's all depicted in function GetProfiles(), inside rating_lib.phtml.
> WeekDay is just the "stage" name, but in reality profile_name is bee
Hi Iñaki,
if I understand your question correctly, yes the columns names are correct.
It's all depicted in function GetProfiles(), inside rating_lib.phtml.
WeekDay is just the "stage" name, but in reality profile_name is been used
and matched with one from billing_profile table, column "name".
Ch
Hi, using CDRTool 6.1.7.
In the Rating section I select "Customers". This view is in fact related to
the "billing_customers" table, but the column names look like incorrect:
Web MySQL Table
-
>Just to clarify, are you speaking about "In" and "Out" columns? do you see
>values "In" and "Out" in some of the records in those columns?
Oops! Sorry, yeah wasnt talking about the same thing :P
No, I see nothing in these columns either. Not sure what they are for,
something to do with routing t
Hola,
>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?
Yes, I believe this info is provided by mediaproxy as it relates to the KB
of RTP
data relayed by mediaproxy, this cannot be deduced as you need to be s
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 authentica
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
> > work
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 in
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 authentica
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 "I
:P This was simple to fix, turns out my admin account in CDRTool didnt have
full admin privileges as far as CDRTool was concerned.
Not sure if Id accidentically messed it up or if the default is like that...
Well anyway, in case anyone else is as dumb as me in future :D now the answer
is on the
Ok, Rating engine seems to be working ok when I have a canonicalURI starting
"00"
and in the database I see this for a rated call:
Span: 1
Duration: 75 s
StartTime: 2008-02-02 12:33:15 (UK)
ProfileId: 442 for weekend
RateId: 442 for 0-24h
Rate: 0.0200 / 60 s
ts.openser.org
Subject: Re: [OpenSER-Users] CDRTool rating on test system (without PSTN)
zero cost problem
Date: 04/02/08 11:28
> Hi Andy,
>
> I suspect that your problem is related to
> var $intAccessCode = '00'; inside cdrlib.phtml.
> Based on that all the numbers w
Hi Andy,
I suspect that your problem is related to
var $intAccessCode = '00'; inside cdrlib.phtml.
Based on that all the numbers which should not be altered and be
considered billable should contain "00" as international prefix.
Have a look on that, perhaps it helps.
Cheers,
DanB
On Feb
Hi all,
im trying to "trick" CDRTool into rating calls when my OpenSER isnt actually
routing anything to a PSTN, Im trying just putting the handset username as an
internation number without the leading zera (ie 4420888) but CDRTool is
rating ever call as zero cost.
Maybe its something to
How do i create a datasource for Cisco RAS.
--
TC
___
Users mailing list
Users@lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
Hi Andi,
I've seen this a few times. Did you try to just hit the reload button?
Bye Lorenz
_
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Andy Smith
Gesendet: Dienstag, 8. Januar 2008 21:51
An: users@lists.openser.org
Betreff: Re: [OpenSER-Users] CDRTool help?
t actually tells us anything useful as the fundamental problem seems to
be $cdr_source is null
thanks for ur input! Andy.
- Original Message -
From: Lorenz Barth
To: Andy Smith ; users@lists.openser.org
Sent: Tuesday, January 08, 2008 9:53 PM
Subject: AW: [OpenS
mmm, again! :S well here is the bottom half of my email
It seems that in callsearch.phtml "$cdr_source" is not being set, but I dont
understand why not and I am not
sure how to get more debugging info out of the whole thing (Im not used to
PHP), I dont see any errors
in the syslog :(
Wi
Sorry, not all of the text I originally sent has appeared on the list archives,
so here is the full email another time! :P
Hi,
can anyone provide any advice on getting CDRTool to work?
I have installed CDRTool 6.0 on a Debian Linux system 2.6 Kernel with
Apache/2.2.6 (Unix) PHP/5.2.5
I am
Hi,
can anyone provide any advice on getting CDRTool to work?
I have installed CDRTool 6.0 on a Debian Linux system 2.6 Kernel with
Apache/2.2.6 (Unix) PHP/5.2.5
I am attempting to get it to work with OpenSER only (I have commented out the
Asterisk and sip_trace sections
in global.inc) and I
Hi every one
It's my first time there,
I am trying to install cdrtool, I installed openser with radius and mysql
accounting, I follow the install file with cdrtool, but it seam it's not
very clear I added these line in my openser.cfg as they said in the install
file
268 loadmodule "acc.so"
55 matches
Mail list logo
