Bug 1061408

Description of problem:

The FreeRADIUS 3.0 rlm_sql_sqlite module uses a function call that is not available in the sqlite 3.6.20 module (which is current in CentOS 6.5 and by extension its RHEL equivalent).

When attempting to use SQLite, FreeRADIUS will throw an error related to sqlite3_create_function_v2() not being available.

Version-Release number of selected component (if applicable):

3.0.1

How reproducible:

Try to use the freeradius-sqlite package (which includes SQLite support for FreeRADIUS).

Steps to Reproduce:
1. yum install sqlite freeradius-sqlite freeradius (should install sqlite 3.6.20, freeradius 3.0.1 and freeradius-sqlite 3.0.1).
2. Configure a SQLite database
2.1 sqlite3 /var/tmp_sql_database
2.2 At sqlite prompt: create table psk_keys (keyid text primary key, key blob);
2.3 At sqlite prompt: .exit
2.4 chmod 777 /var/tmp_sql_database
3. Configure FreeRADIUS SQLite support
3.1 Create file /etc/raddb/mods-available/psksql.
3.2 Paste the below text into said file:

sql psksql {
  driver = "rlm_sql_sqlite"
  sqlite {
    filename = "/var/tmp_sql_database"
  }
}

3.3. ln -s /etc/raddb/mods-available/psksql /etc/raddb/mods-enabled/psksql
4. Start FreeRADIUS 3 in debug mode: radius -fxx -l stdout

Actual results:

FreeRADIUS refuses to load with error:

Could not link driver rlm_sql_sqlite: /usr/lib64/freeradius/rlm_sql_sqlite.so: undefined symbol: sqlite3_create_function_v2 Make sure it (and all its dependent libraries!)are in the search path of your system's ld.

Expected results:

FreeRADIUS should be able to load ok.

Additional info:

Doing a positive test by building SQLite 3.8.1 from source and ensuring the public version of SQLite is 3.8.1 (check with "sqlite3 -version"), FreeRADIUS then loads ok.

There is a github commit for this fix:

https://github.com/FreeRADIUS/freeradius-server/commit/0d4fcde3602873067b53eeed55f570da81bcb800

The SQLite release that shipped with the function is 3.7.3 as per http://freecode.com/projects/sqlite/releases/323290