ICRADIUS не может получить данные от mysql
- From
- Ivan Savichev (2:5026/49.29)
- To
- All
- Date
- 2006-10-31T23:31:08Z
- Area
- RU.UNIX.BSD
Привет All !
Есть cisco с блоком модемов, она в целях AAA ходит к icradius, хранящему базу в
mysql. Работало это больше года, а в последнюю неделю радиус по паре раз в день
не может получить ответ от mysql:
Mon Oct 30 17:06:37 2006: Auth: Login OK: [user_99] (from nas cisco1/S38)
socket 0 (0 sec)
Mon Oct 30 17:22:25 2006: Error: MYSQL Error: Cannot get result
Mon Oct 30 17:22:25 2006: Error: MYSQL Error: MySQL server has gone away
Mon Oct 30 17:22:25 2006: Error: MASTER: accounting process died - exit.
сработал временный костыль в виде перезапускалки радиуса
Mon Oct 30 17:25:10 2006: Info: Starting - reading configuration files ...
Mon Oct 30 17:25:10 2006: Info: SQL: Attempting to connect to
radius@localhost:radius
Mon Oct 30 17:25:11 2006: Info: Ready to process requests.
mysql не падал, вот лог :
061030 17:21:53 11 Query SELECT username, password, "", 125, 126,
CONCAT('/var/mail/virtual/', maildir),
061030 17:22:25 71 Connect postfix@localhost on postfix
71 Query SELECT goto FROM alias WHERE address =
'root@************ru' and active = 71 Query SELECT goto FROM alias WHERE
address = 'root' and active = '1'
71 Query SELECT goto FROM alias WHERE address =
'root@************ru' and active = 65 Query SELECT goto FROM alias WHERE
address = 'root@************ru' and active =
иногда происходит так:
Tue Oct 31 22:48:16 2006: Error: MYSQL Error: Cannot get result
Tue Oct 31 22:48:16 2006: Error: MYSQL Error: MySQL server has gone away
Tue Oct 31 22:48:19 2006: Error: Dropping duplicate authentication packet from
client cisco1 - ID: 205
Tue Oct 31 22:49:53 2006: Error: MYSQL Error: Cannot get result
Tue Oct 31 22:49:53 2006: Error: MYSQL Error: MySQL server has gone away
Tue Oct 31 22:49:56 2006: Error: Dropping duplicate authentication packet from
client cisco1 - ID: 206
т.е. радиус висит и все попытки авторизоваться дропает.. что бы с ним такое
сделать? mysql обновил - ничего не изменилось, ICRADIUS 0.18 - свежее не
будет...
my.cfg:
[client]
port = 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 16
old-passwords
max_connections = 128
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
ivan% mysql -V
mysql Ver 14.12 Distrib 5.0.26, for portbld-freebsd6.0 (i386) using 5.0
ivan% uname -mrs
FreeBSD 6.0-RELEASE i386
памяти на машинке 2Гб, mysql не нагружен..
Ivan
* Originally in RU.UNIX.BSD
--- @G:\Progra~1\uptime\uptime.txt
* Origin: Diamonds are not forever (2:5026/49.29)
SEEN-BY: 46/50 50/12 551 140/1 400/567 814 450/1024 452/25 154 461/48 1313
SEEN-BY: 469/142 2432/260 4615/21 4635/1024 5000/5000 5001/100 5002/63 5010/2
SEEN-BY: 5011/13 5012/30 46 5015/28 5019/31 5020/178 380 400 545 715 760 830
SEEN-BY: 5020/921 958 1042 1641 1822 1960 2024 2238 2395 2452 2871 3452 4441
SEEN-BY: 5021/29 44 5022/5 5023/46 5025/3 9595 5026/49 62 63 5027/12 5028/61
SEEN-BY: 5029/60 5030/115 731 830 901 1080 1957 5035/38 5036/10 5042/12 21
SEEN-BY: 5043/0 19 5045/7 5049/19 164 5050/151 5052/4 5054/1 4 8 9 11 28 35 36
SEEN-BY: 5054/37 45 50 63 66 67 70 75 84 85 89 5058/42 999 5059/9 5060/900
SEEN-BY: 5062/10 5063/3 5064/7 5070/156 5071/22 166 5074/24 5076/1 5077/70
SEEN-BY: 5078/20 5080/111 147 197 237 239 1003 5084/9 5085/13 87 5093/4 33 55
SEEN-BY: 5095/20 5096/18 5097/31 303 6001/10 6028/1 6053/1 6055/2 6056/1
SEEN-BY: 6070/5 6083/12
PATH: 5026/49 5020/715 5080/1003 5020/545 5054/1 37