[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