3
3
# Delete sessions from the radacct table which are older than
5
# Works with mysql and postgresql
9
9
$conf=shift||'/usr/local/dialup_admin/conf/admin.conf';
12
13
open CONF, "<$conf"
13
14
or die "Could not open configuration file\n";
16
17
($key,$val)=(split /:\s*/,$_);
18
$sql_type = $val if ($key eq 'sql_type');
17
19
$sql_server = $val if ($key eq 'sql_server');
18
20
$sql_username = $val if ($key eq 'sql_username');
19
21
$sql_password = $val if ($key eq 'sql_password');
20
22
$sql_database = $val if ($key eq 'sql_database');
21
23
$sql_accounting_table = $val if ($key eq 'sql_accounting_table');
24
$sqlcmd = $val if ($key eq 'sql_command');
28
die "sql_command directive is not set in admin.conf\n" if ($sqlcmd eq '');
29
die "Could not find sql binary. Please make sure that the \$sqlcmd variable points to the right location\n" if (! -x $sqlcmd);
31
$sql_password = ($sql_password eq '') ? '' : "-p$sql_password";
25
33
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime;
26
34
$date = POSIX::strftime("%Y-%m-%d %T",$sec,$min,$hour,($mday - $back_days),$mon,$year,$wday,$yday,$isdst);
29
$dbh = DBI->connect("DBI:mysql:$sql_database:$sql_server","$sql_username","$sql_password");
30
$dbh->do("LOCK TABLES $sql_accounting_table WRITE;DELETE FROM $sql_accounting_table WHERE AcctStopTime < '$date';UNLOCK TABLES;");
37
$query = "LOCK TABLES $sql_accounting_table WRITE;" if ($sql_type eq 'mysql');
38
$query .= "DELETE FROM $sql_accounting_table WHERE AcctStopTime < '$date' AND AcctStopTime IS NOT NULL ;";
39
$query .= "UNLOCK TABLES;" if ($sql_type eq 'mysql');
41
open TMP, ">/tmp/truncate_radacct.query"
42
or die "Could not open tmp file\n";
45
$command = "$sqlcmd -h$sql_server -u$sql_username $sql_password $sql_database </tmp/truncate_radacct.query" if ($sql_type eq 'mysql');
46
$command = "$sqlcmd -U $sql_username -f /tmp/truncate_radacct.query $sql_database" if ($sql_type eq 'pg');