Respostas

  • Bem, eu no desespero, formataria novamente o pc onde o mk esta e instalaria a versao anterior,q ue con certeza tem um cd guardado por ai, com a iso, claro que com backup feito algumas dezenas de vezes pra garantir e importar tudo. mais com certeza tem gente com experiencia no forum, e o proprio Pedro que sempre da uma atencao bakana, que pode ajudar vc.
  • Obrigado pela luz, mais vamos continuar aguadando alguém mais experiente nos mostrar outra soluçào.
  • qual o problema ?
  • Ta vendo.. tem vários problemas depois das ultimas atualizações..
    Se alguem souber como voltar para versão 74 eu tbem aceito, acho que foi a melhor.

    Obrigado
  • não tem como downgrade para versão menores que a 4.81, eu avisei isso aqui, somente reinstalando e voltando um backup, no link abaixo vc tem as imagens iso mais atuais:

    www.mk-auth.com.br/iso/


  • José Arailton Dias da Silva disse:
    Obrigado pela luz, mais vamos continuar aguadando alguém mais experiente nos mostrar outra soluçào.
    ate que eu nao viajei na batata ne...
  • Pessoal, depois de penar, descobri que o problema está no freeradius, o processo cai o tempo todo. Segue o log do mesmo para os mais experientes analizarem e darem o seu parecer. Obrigado!

    Log do radius.log

    radius:~# tail -f /var/log/freeradius/radius.log
    Tue Nov 9 22:26:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 22:26:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Tue Nov 9 22:26:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Tue Nov 9 22:33:01 2010 : Info: rlm_sql (sql): Trying to (re)connect unconnected handle 2..
    Tue Nov 9 22:33:01 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Tue Nov 9 22:33:01 2010 : Info: rlm_sql (sql): got socket 2 after skipping 0 unconnected handles, tried to reconnect 1 though
    Tue Nov 9 22:41:24 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969790, but no Login record
    Tue Nov 9 22:41:24 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Tue Nov 9 22:44:26 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969783, but no Login record
    Tue Nov 9 22:44:26 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 22:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Tue Nov 9 22:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Tue Nov 9 22:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 22:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Tue Nov 9 22:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Tue Nov 9 22:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Tue Nov 9 22:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Tue Nov 9 22:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Tue Nov 9 22:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Tue Nov 9 22:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Tue Nov 9 22:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Tue Nov 9 22:45:05 2010 : Error: Errors initializing modules
    Tue Nov 9 22:47:29 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969711, but no Login record
    Tue Nov 9 22:47:29 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Tue Nov 9 23:03:18 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969794, but no Login record
    Tue Nov 9 23:03:18 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Tue Nov 9 23:04:23 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Tue Nov 9 23:04:23 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Tue Nov 9 23:06:34 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 23:06:34 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Tue Nov 9 23:09:56 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969710, but no Login record
    Tue Nov 9 23:17:01 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Tue Nov 9 23:17:01 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 23:17:49 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969413, but no Login record
    Tue Nov 9 23:17:49 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Tue Nov 9 23:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Tue Nov 9 23:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Tue Nov 9 23:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 23:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Tue Nov 9 23:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Tue Nov 9 23:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Tue Nov 9 23:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Tue Nov 9 23:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Tue Nov 9 23:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Tue Nov 9 23:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Tue Nov 9 23:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Tue Nov 9 23:45:05 2010 : Error: Errors initializing modules
    Tue Nov 9 23:49:40 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969792, but no Login record
    Tue Nov 9 23:49:40 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Tue Nov 9 23:55:29 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969793, but no Login record
    Tue Nov 9 23:55:29 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Tue Nov 9 23:56:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Tue Nov 9 23:56:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Tue Nov 9 23:56:51 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Wed Nov 10 00:00:53 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Wed Nov 10 00:35:58 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969801, but no Login record
    Wed Nov 10 00:35:58 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Wed Nov 10 00:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 00:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 00:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 00:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 00:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 00:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 00:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 00:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 00:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 00:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 00:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 00:45:05 2010 : Error: Errors initializing modules
    Wed Nov 10 00:51:02 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969791, but no Login record
    Wed Nov 10 00:51:02 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Wed Nov 10 01:38:20 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969802, but no Login record
    Wed Nov 10 01:38:20 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 01:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 01:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 01:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 01:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 01:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 01:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 01:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 01:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 01:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 01:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 01:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 01:45:05 2010 : Error: Errors initializing modules
    Wed Nov 10 01:45:24 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969728, but no Login record
    Wed Nov 10 01:45:24 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Wed Nov 10 02:45:04 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 02:45:04 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 02:45:04 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 02:45:04 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 02:45:04 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 02:45:04 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 02:45:04 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 02:45:04 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 02:45:04 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 02:45:04 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 02:45:04 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 02:45:04 2010 : Error: Errors initializing modules
    Wed Nov 10 02:47:48 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969784, but no Login record
    Wed Nov 10 02:47:48 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Wed Nov 10 03:45:04 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 03:45:04 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 03:45:04 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 03:45:04 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 03:45:04 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 03:45:04 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 03:45:04 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 03:45:04 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 03:45:04 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 03:45:04 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 03:45:04 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 03:45:04 2010 : Error: Errors initializing modules
    Wed Nov 10 04:36:14 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Wed Nov 10 04:36:14 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
    Wed Nov 10 04:36:26 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 04:36:26 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Wed Nov 10 04:36:26 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Wed Nov 10 04:44:07 2010 : Error: rlm_radutmp: Logout for NAS servidor port 2157969806, but no Login record
    Wed Nov 10 04:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 04:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 04:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 04:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 04:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 04:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 04:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 04:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 04:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 04:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 04:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 04:45:05 2010 : Error: Errors initializing modules
    Wed Nov 10 04:45:20 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 04:45:20 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
    Wed Nov 10 04:45:21 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
    Wed Nov 10 04:51:02 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
    Wed Nov 10 05:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 05:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 05:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 05:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 05:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 05:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 05:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 05:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 05:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 05:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 05:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 05:45:05 2010 : Error: Errors initializing modules
    Wed Nov 10 06:45:05 2010 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Wed Nov 10 06:45:05 2010 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/mkradius
    Wed Nov 10 06:45:05 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
    Wed Nov 10 06:45:05 2010 : Error: rlm_sql_mysql: Couldn't connect socket to MySQL server root@localhost:mkradius
    Wed Nov 10 06:45:05 2010 : Error: rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    Wed Nov 10 06:45:05 2010 : Error: rlm_sql (sql): Failed to connect DB handle #0
    Wed Nov 10 06:45:05 2010 : Info: rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
    Wed Nov 10 06:45:05 2010 : Error: rlm_sql (sql): generate_sql_clients() returned error
    Wed Nov 10 06:45:05 2010 : Error: /etc/freeradius/sql.conf[19]: Instantiation failed for module "sql"
    Wed Nov 10 06:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[118]: Failed to find module "sql".
    Wed Nov 10 06:45:05 2010 : Error: /etc/freeradius/sites-enabled/inner-tunnel[34]: Errors parsing authorize section.
    Wed Nov 10 06:45:05 2010 : Error: Errors initializing modules


    LOG do Syslog


    radius:~# tail -f /var/log/messages
    Nov 9 09:19:05 radius kernel: [ 6.297591] input: PC Speaker as /class/input/input2
    Nov 9 09:19:05 radius kernel: [ 7.148736] Adding 2024180k swap on /dev/sda2. Priority:-1 extents:1 across:2024180k
    Nov 9 09:19:05 radius kernel: [ 30.639318] NET: Registered protocol family 10
    Nov 9 09:19:05 radius kernel: [ 30.639736] lo: Disabled Privacy Extensions
    Nov 9 09:19:05 radius kernel: [ 30.700854] eth0: setting full-duplex.
    Nov 9 09:19:05 radius rsyslogd: [origin software="rsyslogd" swVersion="3.18.6" x-pid="1789" x-info="http://www.rsyslog.com"] restart
    Nov 9 09:19:07 radius kernel: [ 33.338229] tun: Universal TUN/TAP device driver, 1.6
    Nov 9 09:19:07 radius kernel: [ 33.338229] tun: (C) 1999-2004 Max Krasnyansky
    Nov 9 09:19:11 radius kernel: [ 36.971307] ip_tables: (C) 2000-2006 Netfilter Core Team
    Nov 9 09:19:11 radius kernel: [ 37.092496] nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
  • Esses erros na melhor das hipoteses, pode ser o OS que corrompeu algum arquivo e etc...

    Mas há uma grande possibilidade que seja memoria ou algum outro item de hardware que precisa ser melhor investigado.

    Pois aqui eu uso a versão 4.82 e nao tem esses tipos de erros e nao tive problemas com ela, e os erros que tive foram corridos quase que de imediato com uma nova atualização.

    Nao vale a pena ficar preso a um versão desatualizada quando se encontra um problema com uma mais atualizada.

    Creio que se vc testar seus items de hardware vai encontrar uma solução definitiva para seu problema sem ter que trocar ou reinstalar o mk-auth.

    Abraços.
  • Tentou voltar para a 81?

    mkdown 481

    isso via terminal ssh

    Qualquer coisa depois reinicia o servidor...e tenta denovo.
This reply was deleted.