5 use FS::Daemon ':all'; #daemonize1 drop_root daemonize2 myexit logfile sig*
6 use FS::UID qw( adminsuidsetup );
7 use FS::Record qw( qsearch qsearchs dbh );
12 my $user = shift or die &usage;
14 #daemonize1('freeside-sprepaidd', $user); #keep unique pid files w/multi installs
15 daemonize1('freeside-cdrrewrited');
19 adminsuidsetup($user);
21 logfile( "%%%FREESIDE_LOG%%%/cdrrewrited-log.". $FS::UID::datasrc );
27 die "not running; relevant conf options are all off\n"
33 my %sessionnum_unmatch = ();
34 my $sessionnum_retry = 4 * 60 * 60; # 4 hours
35 my $sessionnum_giveup = 4 * 24 * 60 * 60; # 4 days
37 my %cdr_type = map { lc($_->cdrtypename) => $_->cdrtypenum }
38 qsearch('cdr_type',{});
42 #hmm... don't want to do an expensive search with an ever-growing bunch
43 # of unprocessed CDRs during the month... better to mark them all as
44 # rewritten "skipped", i.e. why we're a daemon in the first place
45 # instead of just doing this search like normal CDRs
48 #used only by taqua, should have no effect otherwise
49 my @recent = grep { ($sessionnum_unmatch{$_} + $sessionnum_retry) > time }
50 keys %sessionnum_unmatch;
51 my $extra_sql = scalar(@recent)
52 ? ' AND acctid NOT IN ('. join(',', @recent). ') '
55 #order matters for removing dupes--only the first is preserved
56 $extra_sql .= ' ORDER BY acctid '
57 if $conf->exists('cdr-skip_duplicate_rewrite');
60 my %skip = (); #used only by taqua
66 'extra_sql' => 'FOR UPDATE', #XXX overwritten by opt below...would fixing this break anything?
68 'extra_sql' => 'WHERE freesidestatus IS NULL '.
69 ' AND freesiderewritestatus IS NULL '.
71 ' LIMIT 1024', #arbitrary, but don't eat too much memory
75 next if $skip{$cdr->acctid}; #used only by taqua
80 if ($conf->exists('cdr-skip_duplicate_rewrite')) {
81 #qsearch can't handle timestamp type of calldate
82 my $sth = dbh->prepare(
83 'SELECT 1 FROM cdr WHERE src=? AND dst=? AND calldate=? AND acctid < ? LIMIT 1'
85 $sth->execute($cdr->src,$cdr->dst,$cdr->calldate,$cdr->acctid) or die $sth->errstr;
86 my $isdup = $sth->fetchrow_hashref;
89 #we only act on this cdr, not touching previous dupes
90 #if a dupe somehow creeped in previously, too late to fix it
91 $cdr->freesidestatus('done'); #prevent it from being billed
92 push(@status,'duplicate');
96 if ( $conf->exists('cdr-asterisk_forward_rewrite')
97 && $cdr->dstchannel =~ /^Local\/(\d+)/i && $1 ne $cdr->dst
103 warn "dst ". $cdr->dst. " does not match dstchannel $dst ".
104 "(". $cdr->dstchannel. "); rewriting CDR as a forwarded call";
106 $cdr->charged_party($cdr->dst);
110 push @status, 'asterisk_forward';
114 # XXX weird special case stuff--can we modularize this somehow?
116 if ( $conf->exists('cdr-asterisk_australia_rewrite') and
117 $cdr->disposition eq 'ANSWERED' ) {
120 if ( $dst =~ /^0?(12|13|1800|1900|0055)/ ) {
121 # toll free or smart numbers, any length
123 $cdr->charged_party($dst);
125 elsif ( $dst =~ /^(11|0011)/ ) {
126 # will be followed by country code
127 $type = 'international';
128 $dst =~ s/^$1/0011/; #standardize
131 elsif ( length($dst) == 10 and$dst =~ /^04/ ) {
134 elsif ( length($dst) == 10 and $dst =~ /^02|03|07|08/ ) {
137 elsif ( length($dst) == 8 ) {
138 # local call, no area code
144 if ( $type and exists($cdr_type{$type}) ) {
145 $cdr->cdrtypenum($cdr_type{$type});
146 push @status, 'asterisk_australia';
149 $warning{"no CDR type defined for $type calls"}++;
153 if ( $conf->exists('cdr-charged_party_rewrite') && ! $cdr->charged_party ) {
155 $cdr->set_charged_party;
156 push @status, 'charged_party';
160 if ( $cdr->cdrtypenum == 1
163 $conf->exists('cdr-taqua-accountcode_rewrite') or
164 $conf->exists('cdr-taqua-callerid_rewrite') )
168 #find the matching CDR
169 my %search = ( 'sessionnum' => $cdr->sessionnum );
170 if ( $cdr->lastapp eq 'acctcode' ) {
171 $search{'src'} = $cdr->subscriber;
172 } elsif ( $cdr->lastapp eq 'CallerId' ) {
173 $search{'dst'} = $cdr->subscriber;
175 my $primary = qsearchs('cdr', \%search);
177 unless ( $primary ) {
179 my $cantfind = "can't find primary CDR with session ". $cdr->sessionnum.
180 ", src ". $cdr->subscriber;
181 if ( $cdr->calldate_unix + $sessionnum_giveup < time ) {
182 warn "ERROR: $cantfind; giving up\n";
183 push @status, 'taqua-sessionnum-NOTFOUND';
184 $cdr->status('done'); #so it doesn't try to rate
185 delete $sessionnum_unmatch{$cdr->acctid}; #so it doesn't suck mem
187 warn "WARNING: $cantfind; will keep trying\n";
188 $sessionnum_unmatch{$cdr->acctid} = time;
194 if ( $cdr->lastapp eq 'acctcode' ) {
195 # lastdata contains the dialed account code
196 $primary->accountcode( $cdr->lastdata );
197 push @status, 'taqua-accountcode';
198 } elsif ( $cdr->lastapp eq 'CallerId' ) {
199 # lastdata contains "allowed" or "restricted"
200 # or case variants thereof
201 if ( lc($cdr->lastdata) eq 'restricted' ) {
202 $primary->clid( 'PRIVATE' );
204 push @status, 'taqua-callerid';
206 warn "unknown Taqua service name: ".$cdr->lastapp."\n";
208 #$primary->freesiderewritestatus( 'taqua-accountcode-primary' );
209 my $error = $primary->replace if $primary->modified;
211 warn "WARNING: error rewriting primary CDR (will retry): $error\n";
214 $skip{$primary->acctid} = 1;
216 $cdr->status('done'); #so it doesn't try to rate
222 if ( $conf->exists('cdr-intl_to_domestic_rewrite') and
223 $cdr->dst =~ /^(011)(\d{0,7})$/ ) {
225 push @status, 'intl_to_domestic';
228 $cdr->freesiderewritestatus(
229 scalar(@status) ? join('/', @status) : 'skipped'
232 my $error = $cdr->replace;
235 warn "WARNING: error rewriting CDR (will retry in 30 seconds):".
237 sleep 30; #i dunno, wait and see if the database comes back?
240 last if sigterm() || sigint();
244 foreach (sort keys %warning) {
245 warn "WARNING: $_ (x $warning{$_})\n";
249 myexit() if sigterm() || sigint();
250 #sleep 1 unless $found;
251 sleep 5 unless $found;
258 $conf->exists('cdr-asterisk_forward_rewrite')
259 || $conf->exists('cdr-asterisk_australia_rewrite')
260 || $conf->exists('cdr-charged_party_rewrite')
261 || $conf->exists('cdr-taqua-accountcode_rewrite')
262 || $conf->exists('cdr-taqua-callerid_rewrite')
263 || $conf->exists('cdr-intl_to_domestic_rewrite')
264 || $conf->exists('cdr-skip_duplicate_rewrite')
270 die "Usage:\n\n freeside-cdrrewrited user\n";
275 freeside-cdrrewrited - Real-time daemon for CDR rewriting
283 Runs continuously, searches for CDRs and does forwarded-call rewriting if any
284 of the following config options are enabled:
288 =item cdr-skip_duplicate_rewrite
290 Marks as 'done' (prevents billing for) any CDRs with
291 a src, dst and calldate identical to an existing CDR
293 =item cdr-asterisk_australia_rewrite
295 Classifies Australian numbers as domestic, mobile, tollfree, international, or
296 "other", and tries to assign a cdrtypenum based on that.
298 =item cdr-asterisk_forward_rewrite
300 Identifies Asterisk forwarded calls using the 'dstchannel' field. If the
301 dstchannel is "Local/" followed by a number, but the number doesn't match the
302 dst field, the dst field will be rewritten to match.
304 =item cdr-charged_party_rewrite
306 Calls set_charged_party on all calls.
308 =item cdr-taqua-accountcode_rewrite
310 =item cdr-taqua-callerid_rewrite
312 These actually have the same effect. Taqua uses cdrtypenum = 1 to tag accessory
313 records. They will have "sessionnum" = that of the primary record, and
314 "lastapp" indicating their function:
316 - "acctcode": "lastdata" contains the dialed account code. Insert this into the
317 accountcode field of the primary record.
319 - "CallerId": "lastdata" contains "allowed" or "restricted". If "restricted"
320 then the clid field of the primary record is set to "PRIVATE".
322 =item cdr-intl_to_domestic_rewrite
324 Finds records where the destination number has the "011" international prefix,
325 but with seven or fewer digits in the rest of the number, and strips the "011"
326 prefix so that they will be treated as domestic calls. This is very uncommon.