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> -
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.