FreeRadius start problem



  • Hi, I am using Pfsense 2.3.4-RELEASE (amd64)
    But Freenas Server doesen't work. System logs says:

    Jul 2 14:49:41  login      login on ttyv0 as root
    Jul 2 14:49:52  radiusd  50689  rlm_eap: SSL error error:02001002:system library:fopen:No such file or directory
    Jul 2 14:49:52  radiusd  50689  rlm_eap_tls: Error reading certificate file /usr/local/etc/raddb/certs/server_cert.pem
    Jul 2 14:49:52  radiusd  50689  rlm_eap: Failed to initialize type tls
    Jul 2 14:49:52  radiusd  50689  /usr/local/etc/raddb/eap.conf[2]: Instantiation failed for module "eap"
    Jul 2 14:49:52  radiusd  50689  /usr/local/etc/raddb/sites-enabled/default[331]: Failed to find "eap" in the "modules" section.
    Jul 2 14:49:52  radiusd  50689  /usr/local/etc/raddb/sites-enabled/default[266]: Errors parsing authenticate section.
    Jul 2 14:49:52  radiusd  50689  Failed to load virtual server <default>When I create a certificate and select or activate the certificate "Services=>Freeradius=>EAP"
    system logs says:

    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect to radius@localhost:3306/radius
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
    Jul 3 01:36:19 radiusd 28013 rlm_sql_mysql: Starting connect to MySQL server for #0
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Connected new DB handle, #0
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
    Jul 3 01:36:19 radiusd 28013 rlm_sql_mysql: Starting connect to MySQL server for #1
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Connected new DB handle, #1
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
    Jul 3 01:36:19 radiusd 28013 rlm_sql_mysql: Starting connect to MySQL server for #2
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Connected new DB handle, #2
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
    Jul 3 01:36:19 radiusd 28013 rlm_sql_mysql: Starting connect to MySQL server for #3
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Connected new DB handle, #3
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
    Jul 3 01:36:19 radiusd 28013 rlm_sql_mysql: Starting connect to MySQL server for #4
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Connected new DB handle, #4
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Table 'radius.nas' doesn't exist
    Jul 3 01:36:19 radiusd 28013 Failed to load clients from SQL.
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Closing sqlsocket 4
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Closing sqlsocket 3
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Closing sqlsocket 2
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Closing sqlsocket 1
    Jul 3 01:36:19 radiusd 28013 rlm_sql (sql): Closing sqlsocket 0
    Jul 3 01:36:19 radiusd 28013 /usr/local/etc/raddb/sql.conf[2]: Instantiation failed for module "sql"
    Jul 3 01:36:19 radiusd 28013 /usr/local/etc/raddb/sites-enabled/default[185]: Failed to find "sql" in the "modules" section.
    Jul 3 01:36:19 radiusd 28013 /usr/local/etc/raddb/sites-enabled/default[185]: Failed to parse "sql" entry.
    Jul 3 01:36:19 radiusd 28013 /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section.
    Jul 3 01:36:19 radiusd 28013 Failed to load virtual server <default>What is the problem? Best regards.
    Sorry for my English!</default></default>


  • Rebel Alliance Developer Netgate

    Which FreeRADIUS package are you using, the 2.x package or the 3.x package? If you are using the 2.x package, remove it and then install the 3.x package.

    Also, you appear to be running a MySQL server on the firewall itself ("Attempting to connect to radius@localhost:3306/radius") which is not possible unless you made unsupported manual changes to the firewall packages or installed a package from an outside source, which may have compromised/broken your installation in some way, leading to the error you see.