forum.lissyara.su

Код: Выделить всё

# удаляем зависшие сесии в БД(посре рестарта mpd не удаляеться почемуто...)
$query="select max(RadAcctId)as mymax,count(username) as mycount,username from radius.radacct where AcctStopTime='0000-00-00 00:00:00' group by username";
$res=mysql_query($query);
while ($row=mysql_fetch_assoc($res))
{

	if ($row['mycount']>1)
	{
    	# удаляем зависшие сессии
		$query="delete from radius.radacct where username='".$row['username']."' and RadAcctId<>".$row['mymax']." and AcctStopTime='0000-00-00 00:00:00'";
        mysql_query($query);
	}
}

Код: Выделить всё

freeradius-1.1.7_3

Код: Выделить всё

#!/bin/sh

radclient="/usr/local/bin/radclient"
server=127.0.0.1
secrets=testing123

#usage () {
#        echo "Usage: $0 radius-server secret" >&2
#        exit 1
#}

#if [ $# -lt 2 ]
#then
#        usage
#fi

case "$1" in
        start)
                echo -n ' NAS Accounting-On: '
		(
		        echo "Acct-Status-Type = Accounting-On" 
		) | ${radclient} ${server} acct ${secrets}
                ;;
        stop)
		echo -n ' NAS Accounting-Off: '
		(
		        echo "Acct-Status-Type = Accounting-Off" 
		) | ${radclient} ${server} acct ${secrets}
		;;
        -h)
                echo "Usage: `basename $0` { start | stop }"
                ;;
        *)
                ;;

esac

Код: Выделить всё

echo "Acct-Status-Type = Accounting-Off" | ${radclient} ${server} acct ${secrets}

Код: Выделить всё

#!/bin/sh
#
# $FreeBSD: ports/net/mpd4/files/mpd4.sh.in,v 1.3 2007/07/06 07:35:54 sem Exp $
#

# PROVIDE: mpd
# REQUIRE: SERVERS
# BEFORE: DAEMON
# KEYWORD: shutdown

#
# Add the following lines to /etc/rc.conf to enable mpd4:
# mpd_enable (bool):    Set to "NO" by default.
#                       Set it to "YES" to enable mpd4.
# mpd_flags (string):   Set to "-b" by default.
#                       Extra flags passed to start command.
#
# See mpd(8) for flags.
#

. /etc/rc.subr

name="mpd4"
rcvar=`set_rcvar mpd`

load_rc_config ${name}

: ${mpd_enable="NO"}
: ${mpd_flags="-b"}

pidfile="/var/run/${name}.pid"
command="/usr/local/sbin/${name}"
required_files="/usr/local/etc/${name}/mpd.conf /usr/local/etc/${name}/mpd.links"

case "${mpd_flags}" in
*-p\ *)
        echo "ERROR: \$mpd_flags includes -p option." \
                "PID file is already set to $pidfile."
        exit 1
        ;;
*)
        command_args="-p ${pidfile} ${mpd_flags}"
        ;;
esac
echo "Acct-Status-Type = Accounting-Off"| /usr/local/bin/radclient 127.0.0.1 acct testing123
run_rc_command "$1"

Код: Выделить всё

....
*)
        command_args="-p ${pidfile} ${mpd_flags}"
        ;;
esac
my_script.sh "$1"
run_rc_command "$1"