[RESOLVED] RE: (RADIATOR) RADUSAGE table corrupt..deleted, now getting SQL Timeout for new Access Requests.
Michael Bellears
MBellears at staff.datafx.com.au
Wed Nov 17 17:14:44 CST 2004
I noticed my Recv-Q was growing + growing - So I totally shut down
Radius, restarted, and all *appears* to be functioning correctly
again....Radiusd must have been in some type of "limbo" state..
Thanks to all who replied.
# netstat -lpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp 0 0 0.0.0.0:873 0.0.0.0:*
LISTEN 260/rsync
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN 19425/mysqld
tcp 0 0 0.0.0.0:10000 0.0.0.0:*
LISTEN 18088/perl
tcp 0 0 0.0.0.0:8400 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:80 0.0.0.0:*
LISTEN 283/apache
tcp 0 0 192.168.5.26:8402 0.0.0.0:*
LISTEN 29395/EvMgrC
tcp 0 0 0.0.0.0:21 0.0.0.0:*
LISTEN 272/proftpd (accept
tcp 0 0 0.0.0.0:22 0.0.0.0:*
LISTEN 255/sshd
tcp 0 0 0.0.0.0:1047 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:443 0.0.0.0:*
LISTEN 283/apache
udp 0 0 0.0.0.0:10000 0.0.0.0:*
18088/perl
udp 58416 0 203.149.65.2:1812 0.0.0.0:*
19634/perl
udp 27392 0 203.149.65.2:1813 0.0.0.0:*
19634/perl
# netstat -lpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp 0 0 0.0.0.0:873 0.0.0.0:*
LISTEN 260/rsync
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN 19425/mysqld
tcp 0 0 0.0.0.0:10000 0.0.0.0:*
LISTEN 18088/perl
tcp 0 0 0.0.0.0:8400 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:80 0.0.0.0:*
LISTEN 283/apache
tcp 0 0 192.168.5.26:8402 0.0.0.0:*
LISTEN 29395/EvMgrC
tcp 0 0 0.0.0.0:21 0.0.0.0:*
LISTEN 272/proftpd (accept
tcp 0 0 0.0.0.0:22 0.0.0.0:*
LISTEN 255/sshd
tcp 0 0 0.0.0.0:1047 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:443 0.0.0.0:*
LISTEN 283/apache
udp 0 0 0.0.0.0:10000 0.0.0.0:*
18088/perl
udp 65488 0 203.149.65.2:1812 0.0.0.0:*
19634/perl
udp 49648 0 203.149.65.2:1813 0.0.0.0:*
19634/perl
Post restart:
# netstat -lpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
State PID/Program name
tcp 0 0 0.0.0.0:873 0.0.0.0:*
LISTEN 260/rsync
tcp 0 0 0.0.0.0:3306 0.0.0.0:*
LISTEN 19425/mysqld
tcp 0 0 0.0.0.0:10000 0.0.0.0:*
LISTEN 18088/perl
tcp 0 0 0.0.0.0:8400 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:80 0.0.0.0:*
LISTEN 283/apache
tcp 0 0 192.168.5.26:8402 0.0.0.0:*
LISTEN 29395/EvMgrC
tcp 0 0 0.0.0.0:21 0.0.0.0:*
LISTEN 272/proftpd (accept
tcp 0 0 0.0.0.0:22 0.0.0.0:*
LISTEN 255/sshd
tcp 0 0 0.0.0.0:1047 0.0.0.0:*
LISTEN 29386/cvd
tcp 0 0 0.0.0.0:443 0.0.0.0:*
LISTEN 283/apache
udp 0 0 0.0.0.0:10000 0.0.0.0:*
18088/perl
udp 0 0 203.149.65.2:1812 0.0.0.0:*
30324/perl
udp 0 0 203.149.65.2:1813 0.0.0.0:*
30324/perl
> -----Original Message-----
> From: owner-radiator at open.com.au
> [mailto:owner-radiator at open.com.au] On Behalf Of Michael Bellears
> Sent: Thursday, 18 November 2004 7:44 AM
> To: Hugh Irvine
> Cc: radiator at open.com.au
> Subject: RE: (RADIATOR) RADUSAGE table corrupt..deleted, now
> getting SQL Timeout for new Access Requests.
>
> >
> >
> > Hello Michael -
> >
> > What is shown is a database access timeout on the RADONLINE table.
>
> Sorry Hugh - Where would I locate this info?
>
> >
> > Are you sure the database is running properly?
>
> I can connect to it successfully, and the RADUSAGE table is
> being updated with ACCTSTATUSTYPE 3 records.
>
> mysql> select * from RADUSAGE;
>
> [....]
> 40#184571670##speed:UBR:1 | 203.149.70.64 | 203.63.121.145
> | 15 |
> 1100727352 | 0755720115 at dsl.datafx.com.au | atm 9 | NULL
> |
> | 5 | 337400 | 528431 | 00000AF3 |
> 44969 | 3 | NULL |
> 2:4.90#184588387##speed:UBR:15 | 203.149.70.12 | 203.63.121.145 |
> 43 | 1100727362 | 0755205750 at dsl.datafx.com.au | atm 12 |
> NULL |
> | 0 | 347181 | 171342 | 00000AE5 |
> 51874 | 3 | NULL |
> 3:2.1034#184574142##speed:UBR: | 203.149.70.50 | 203.63.121.145 |
> 16 | 1100727367 | 0755385666 at dsl.datafx.com.au | atm 11 |
> NULL |
> | 15 | 14793932 | 2325273 | 00000AE9 |
> 48963 | 3 | NULL |
> 2:2.1131#184573533##speed:UBR: | 203.149.70.69 | 203.63.121.145 |
> 31 | 1100727472 | 0299290553 at dsl.datafx.com.au | atm 11 |
> NULL |
> +---------------+-----------------+------------------+--------
> -------+--
> ---------------+----------------+--------------------+--------
> ----------
> --------------+-----------------+----------------+---------+--
> ----------
> +------------------------------+---------------------+--------------+
> 1237 rows in set (0.02 sec)
>
> Regards,
> MB
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au To
> unsubscribe, email 'majordomo at open.com.au' with 'unsubscribe
> radiator' in the body of the message.
>
--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list