Dear Sir, I complier freeradius 3.0.2 with sqlite enable and complier successful. But when I run ./radiusd -XC -d ./raddb/ then display below error ...... # Instantiating module "linelog" from file ./raddb//mods-enabled/linelog linelog { filename = "/home/saxontseng/senao_ source/ap_controller/ freeradius/install/LINUX/var/ log/radius/linelog" permissions = 384 format = "This is a log message for %{User-Name}" reference = "%{%{Packet-Type}:-format}" } ./raddb//mods-enabled/sql[26]: Failed to link to module 'rlm_sqlite': rlm_sqlite.so: cannot open shared object file: No such file or directory And after I check I find only have "rlm_sql_sqlite.so", not find any rlm_sqlite.so. I just modify site-enable/default and mod-available/sql, make ln to mod-enabled/sql below is my diff with those two config file --- mods-available/sql 2014-04-01 15:14:36.935046321 +0800 +++ /home/saxontseng/freeradius- server-3.0.2/raddb/mods- available/sql 2014-03-21 20:27:25.000000000 +0800 @@ -23,15 +23,15 @@ # # Driver specific options are: # - sqlite { - # Path to the sqlite database - filename = "$(PWD)/bin/LINUX/radius.db" - - # If the file above does not exist and bootstrap is set - # a new database file will be created, and the SQL statements - # contained within the file will be executed. - bootstrap = "$(PWD)/bin/LINUX/freeradius/ etc/raddb/mods-config/sql/ main/sql_sqlite/schema.sql" - } +# sqlite { +# # Path to the sqlite database +# filename = "/my/sqlite/database.db" +# +# # If the file above does not exist and bootstrap is set +# # a new database file will be created, and the SQL statements +# # contained within the file will be executed. +# bootstrap = "/my/sqlite/schema.sql" +# } # # mysql { # # If any of the below files are set tls encryption is enabled @@ -55,14 +55,14 @@ # * rlm_sql_sqlite # * rlm_sql_null (log queries to disk) # - driver = "rlm_sql_sqlite" + driver = "rlm_sql_null" # The dialect of SQL you want to use, this should usually match # the driver you selected above. # # If you're using rlm_sql_null, then it should be the type of # database the logged queries are going to be executed against. - dialect = "sqlite" + dialect = "mysql" # Connection info: # @@ -110,7 +110,7 @@ # Write SQL queries to a logfile. This is potentially useful for tracing # issues with authorization queries. - logfile = ${logdir}/sqllog.sql +# logfile = ${logdir}/sqllog.sql # As of version 3.0, the "pool" section has replaced the # following configuration items: --- sites-enabled/default 2014-04-01 14:03:20.544123741 +0800 +++ /home/saxontseng/freeradius- server-3.0.2/raddb/sites- available/default 2014-03-21 20:27:25.000000000 +0800 @@ -252,7 +252,7 @@ # If you want to have a log of authentication requests, # un-comment the following line, and the 'detail auth_log' # section, above. - auth_log +# auth_log # # The chap module will set 'Auth-Type := CHAP' if we are @@ -271,7 +271,7 @@ # If you have a Cisco SIP server authenticating against # FreeRADIUS, uncomment the following line, and the 'digest' # line in the 'authenticate' section. -# digest + digest # # The WiMAX specification says that the Calling-Station-Id @@ -328,14 +328,14 @@ # # Read the 'users' file -# files + files # # Look in an SQL database. The schema of the database # is meant to mirror the "users" file. # # See "Authorization Queries" in sql.conf - sql + -sql # # If you are using /etc/smbpasswd, and are also doing @@ -434,7 +434,7 @@ # If you have a Cisco SIP server authenticating against # FreeRADIUS, uncomment the following line, and the 'digest' # line in the 'authorize' section. -# digest + digest # # Pluggable Authentication Modules. @@ -548,7 +548,7 @@ # Update the wtmp file # # If you don't use "radlast", you can delete this line. -# unix + unix # # For Simultaneous-Use tracking. @@ -565,7 +565,7 @@ # Log traffic to an SQL database. # # See "Accounting queries" in sql.conf - sql + -sql # # If you receive stop packets with zero session length, @@ -613,7 +613,7 @@ # # See "Simultaneous Use Checking Queries" in sql.conf - sql +# sql } @@ -639,7 +639,7 @@ # After authenticating the user, do another SQL query. # # See "Authentication Logging Queries" in sql.conf - sql + -sql # # Instead of sending the query to the SQL server, @@ -742,7 +742,7 @@ # Post-Auth-Type REJECT { # log failed authentications in SQL, too. - sql + -sql attr_filter.access_reject # Insert EAP-Failure message if the request was Does my config have wrong? How to config will make 3.0.2 run with sqlite? Regards, SaxonTseng