Re: Freeradius 3.0.14 - Enable SQLite
The directory is not the problem, the value is: libdir = /usr/local/lib64:/usr/local/lib The problem is, that the lib is called /usr/local/lib64/rlm_sql_sqlite.so and we don't know why. An installation with these steps leads us to this error: - ./configure --without-rlm_rediswho --with-rlm_sql_sqlite=yes - make - make install And all the other libs are in /usr/local/lib64: testsystem:~ # ls -l /usr/local/lib64 -rwxr-xr-x 1 root root 86936 Jun 8 10:02 libfreeradius-dhcp.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 libfreeradius-dhcp.la -rwxr-xr-x 1 root root 69328 Jun 8 10:02 libfreeradius-dhcp.so -rwxr-xr-x 1 root root 558930 Jun 8 10:02 libfreeradius-eap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 libfreeradius-eap.la -rwxr-xr-x 1 root root 268656 Jun 8 10:02 libfreeradius-eap.so -rwxr-xr-x 1 root root 1577750 Jun 8 10:02 libfreeradius-radius.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 libfreeradius-radius.la -rwxr-xr-x 1 root root 957200 Jun 8 10:02 libfreeradius-radius.so -rwxr-xr-x 1 root root 1867662 Jun 8 10:02 libfreeradius-server.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 libfreeradius-server.la -rwxr-xr-x 1 root root 924680 Jun 8 10:02 libfreeradius-server.so -rwxr-xr-x 1 root root 127628 Jun 8 10:02 proto_dhcp.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 proto_dhcp.la -rwxr-xr-x 1 root root 84096 Jun 8 10:02 proto_dhcp.so -rwxr-xr-x 1 root root 140424 Jun 8 10:02 proto_vmps.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 proto_vmps.la -rwxr-xr-x 1 root root 87800 Jun 8 10:02 proto_vmps.so -rwxr-xr-x 1 root root 95228 Jun 8 10:02 rlm_always.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_always.la -rwxr-xr-x 1 root root 61248 Jun 8 10:02 rlm_always.so -rwxr-xr-x 1 root root 112584 Jun 8 10:02 rlm_attr_filter.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_attr_filter.la -rwxr-xr-x 1 root root 74328 Jun 8 10:02 rlm_attr_filter.so -rwxr-xr-x 1 root root 142538 Jun 8 10:02 rlm_cache.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_cache.la -rwxr-xr-x 1 root root 96800 Jun 8 10:02 rlm_cache.so -rwxr-xr-x 1 root root 113962 Jun 8 10:02 rlm_cache_rbtree.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_cache_rbtree.la -rwxr-xr-x 1 root root 75344 Jun 8 10:02 rlm_cache_rbtree.so -rwxr-xr-x 1 root root 100210 Jun 8 10:02 rlm_chap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_chap.la -rwxr-xr-x 1 root root 62360 Jun 8 10:02 rlm_chap.so -rwxr-xr-x 1 root root 140700 Jun 8 10:02 rlm_counter.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_counter.la -rwxr-xr-x 1 root root 91904 Jun 8 10:02 rlm_counter.so -rwxr-xr-x 1 root root 103778 Jun 8 10:02 rlm_cram.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_cram.la -rwxr-xr-x 1 root root 65528 Jun 8 10:02 rlm_cram.so -rwxr-xr-x 1 root root 97522 Jun 8 10:02 rlm_date.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_date.la -rwxr-xr-x 1 root root 62808 Jun 8 10:02 rlm_date.so -rwxr-xr-x 1 root root 125236 Jun 8 10:02 rlm_detail.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_detail.la -rwxr-xr-x 1 root root 84552 Jun 8 10:02 rlm_detail.so -rwxr-xr-x 1 root root 107682 Jun 8 10:02 rlm_dhcp.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_dhcp.la -rwxr-xr-x 1 root root 71672 Jun 8 10:02 rlm_dhcp.so -rwxr-xr-x 1 root root 115468 Jun 8 10:02 rlm_digest.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_digest.la -rwxr-xr-x 1 root root 72960 Jun 8 10:02 rlm_digest.so -rwxr-xr-x 1 root root 93784 Jun 8 10:02 rlm_dynamic_clients.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_dynamic_clients.la -rwxr-xr-x 1 root root 60696 Jun 8 10:02 rlm_dynamic_clients.so -rwxr-xr-x 1 root root 407566 Jun 8 10:02 rlm_eap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap.la -rwxr-xr-x 1 root root 205200 Jun 8 10:02 rlm_eap.so -rwxr-xr-x 1 root root 336842 Jun 8 10:02 rlm_eap_fast.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_fast.la -rwxr-xr-x 1 root root 185120 Jun 8 10:02 rlm_eap_fast.so -rwxr-xr-x 1 root root 103380 Jun 8 10:02 rlm_eap_gtc.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_gtc.la -rwxr-xr-x 1 root root 65264 Jun 8 10:02 rlm_eap_gtc.so -rwxr-xr-x 1 root root 245596 Jun 8 10:02 rlm_eap_leap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_leap.la -rwxr-xr-x 1 root root 126904 Jun 8 10:02 rlm_eap_leap.so -rwxr-xr-x 1 root root 131352 Jun 8 10:02 rlm_eap_md5.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_md5.la -rwxr-xr-x 1 root root 76864 Jun 8 10:02 rlm_eap_md5.so -rwxr-xr-x 1 root root 128330 Jun 8 10:02 rlm_eap_mschapv2.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_mschapv2.la -rwxr-xr-x 1 root root 83960 Jun 8 10:02 rlm_eap_mschapv2.so -rwxr-xr-x 1 root root 279094 Jun 8 10:02 rlm_eap_peap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_peap.la -rwxr-xr-x 1 root root 150152 Jun 8 10:02 rlm_eap_peap.so -rwxr-xr-x 1 root root 223726 Jun 8 10:02 rlm_eap_pwd.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_pwd.la -rwxr-xr-x 1 root root 139712 Jun 8 10:02 rlm_eap_pwd.so -rwxr-xr-x 1 root root 126932 Jun 8 10:02 rlm_eap_sim.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_sim.la -rwxr-xr-x 1 root root 81016 Jun 8 10:02 rlm_eap_sim.so -rwxr-xr-x 1 root root 111236 Jun 8 10:02 rlm_eap_tls.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_tls.la -rwxr-xr-x 1 root root 69216 Jun 8 10:02 rlm_eap_tls.so -rwxr-xr-x 1 root root 264774 Jun 8 10:02 rlm_eap_ttls.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_eap_ttls.la -rwxr-xr-x 1 root root 142056 Jun 8 10:02 rlm_eap_ttls.so -rwxr-xr-x 1 root root 114554 Jun 8 10:02 rlm_exec.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_exec.la -rwxr-xr-x 1 root root 75616 Jun 8 10:02 rlm_exec.so -rwxr-xr-x 1 root root 94726 Jun 8 10:02 rlm_expiration.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_expiration.la -rwxr-xr-x 1 root root 61584 Jun 8 10:02 rlm_expiration.so -rwxr-xr-x 1 root root 295066 Jun 8 10:02 rlm_expr.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_expr.la -rwxr-xr-x 1 root root 171200 Jun 8 10:02 rlm_expr.so -rwxr-xr-x 1 root root 115258 Jun 8 10:02 rlm_files.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_files.la -rwxr-xr-x 1 root root 74928 Jun 8 10:02 rlm_files.so -rwxr-xr-x 1 root root 131708 Jun 8 10:02 rlm_ippool.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_ippool.la -rwxr-xr-x 1 root root 85864 Jun 8 10:02 rlm_ippool.so -rwxr-xr-x 1 root root 144484 Jun 8 10:02 rlm_krb5.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_krb5.la -rwxr-xr-x 1 root root 88840 Jun 8 10:02 rlm_krb5.so -rwxr-xr-x 1 root root 793630 Jun 8 10:02 rlm_ldap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_ldap.la -rwxr-xr-x 1 root root 390472 Jun 8 10:02 rlm_ldap.so -rwxr-xr-x 1 root root 105612 Jun 8 10:02 rlm_linelog.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_linelog.la -rwxr-xr-x 1 root root 70256 Jun 8 10:02 rlm_linelog.so -rwxr-xr-x 1 root root 129060 Jun 8 10:02 rlm_logintime.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_logintime.la -rwxr-xr-x 1 root root 80304 Jun 8 10:02 rlm_logintime.so -rwxr-xr-x 1 root root 295300 Jun 8 10:02 rlm_mschap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_mschap.la -rwxr-xr-x 1 root root 158864 Jun 8 10:02 rlm_mschap.so -rwxr-xr-x 1 root root 461756 Jun 8 10:02 rlm_otp.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_otp.la -rwxr-xr-x 1 root root 209232 Jun 8 10:02 rlm_otp.so -rwxr-xr-x 1 root root 100880 Jun 8 10:02 rlm_pam.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_pam.la -rwxr-xr-x 1 root root 64160 Jun 8 10:02 rlm_pam.so -rwxr-xr-x 1 root root 154256 Jun 8 10:02 rlm_pap.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_pap.la -rwxr-xr-x 1 root root 102760 Jun 8 10:02 rlm_pap.so -rwxr-xr-x 1 root root 124596 Jun 8 10:02 rlm_passwd.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_passwd.la -rwxr-xr-x 1 root root 84536 Jun 8 10:02 rlm_passwd.so -rwxr-xr-x 1 root root 273394 Jun 8 10:02 rlm_perl.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_perl.la -rwxr-xr-x 1 root root 164352 Jun 8 10:02 rlm_perl.so -rwxr-xr-x 1 root root 118582 Jun 8 10:02 rlm_preprocess.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_preprocess.la -rwxr-xr-x 1 root root 76992 Jun 8 10:02 rlm_preprocess.so -rwxr-xr-x 1 root root 189492 Jun 8 10:02 rlm_python.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_python.la -rwxr-xr-x 1 root root 128632 Jun 8 10:02 rlm_python.so -rwxr-xr-x 1 root root 122732 Jun 8 10:02 rlm_radutmp.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_radutmp.la -rwxr-xr-x 1 root root 80880 Jun 8 10:02 rlm_radutmp.so -rwxr-xr-x 1 root root 112666 Jun 8 10:02 rlm_realm.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_realm.la -rwxr-xr-x 1 root root 72768 Jun 8 10:02 rlm_realm.so -rwxr-xr-x 1 root root 104862 Jun 8 10:02 rlm_replicate.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_replicate.la -rwxr-xr-x 1 root root 66200 Jun 8 10:02 rlm_replicate.so -rwxr-xr-x 1 root root 102680 Jun 8 10:02 rlm_soh.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_soh.la -rwxr-xr-x 1 root root 65528 Jun 8 10:02 rlm_soh.so -rwxr-xr-x 1 root root 97742 Jun 8 10:02 rlm_sometimes.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sometimes.la -rwxr-xr-x 1 root root 62656 Jun 8 10:02 rlm_sometimes.so -rwxr-xr-x 1 root root 311762 Jun 8 10:02 rlm_sql.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sql.la -rwxr-xr-x 1 root root 180096 Jun 8 10:02 rlm_sql.so -rwxr-xr-x 1 root root 148086 Jun 8 10:02 rlm_sql_mysql.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sql_mysql.la -rwxr-xr-x 1 root root 96240 Jun 8 10:02 rlm_sql_mysql.so -rwxr-xr-x 1 root root 96366 Jun 8 10:02 rlm_sql_null.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sql_null.la -rwxr-xr-x 1 root root 61608 Jun 8 10:02 rlm_sql_null.so -rwxr-xr-x 1 root root 151614 Jun 8 10:02 rlm_sql_sqlite.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sql_sqlite.la -rwxr-xr-x 1 root root 100416 Jun 8 10:02 rlm_sql_sqlite.so -rwxr-xr-x 1 root root 125814 Jun 8 10:02 rlm_sqlcounter.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sqlcounter.la -rwxr-xr-x 1 root root 82344 Jun 8 10:02 rlm_sqlcounter.so -rwxr-xr-x 1 root root 138222 Jun 27 2016 rlm_sqlhpwippool.a -rwxr-xr-x 1 root root 17 Jun 27 2016 rlm_sqlhpwippool.la -rwxr-xr-x 1 root root 88416 Jun 27 2016 rlm_sqlhpwippool.so -rwxr-xr-x 1 root root 132998 Jun 8 10:02 rlm_sqlippool.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_sqlippool.la -rwxr-xr-x 1 root root 88104 Jun 8 10:02 rlm_sqlippool.so -rwxr-xr-x 1 root root 102282 Jun 8 10:02 rlm_test.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_test.la -rwxr-xr-x 1 root root 63272 Jun 8 10:02 rlm_test.so -rwxr-xr-x 1 root root 115418 Jun 8 10:02 rlm_unix.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_unix.la -rwxr-xr-x 1 root root 74688 Jun 8 10:02 rlm_unix.so -rwxr-xr-x 1 root root 101092 Jun 8 10:02 rlm_unpack.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_unpack.la -rwxr-xr-x 1 root root 64104 Jun 8 10:02 rlm_unpack.so -rwxr-xr-x 1 root root 90770 Jun 8 10:02 rlm_utf8.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_utf8.la -rwxr-xr-x 1 root root 59296 Jun 8 10:02 rlm_utf8.so -rwxr-xr-x 1 root root 112242 Jun 8 10:02 rlm_wimax.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_wimax.la -rwxr-xr-x 1 root root 71896 Jun 8 10:02 rlm_wimax.so -rwxr-xr-x 1 root root 136580 Jun 8 10:02 rlm_yubikey.a -rwxr-xr-x 1 root root 17 Jun 8 10:02 rlm_yubikey.la -rwxr-xr-x 1 root root 84464 Jun 8 10:02 rlm_yubikey.so
On Thu, Jun 08, 2017 at 02:15:34PM +0200, Stabla, Daniel wrote:
The directory is not the problem, the value is:
libdir = /usr/local/lib64:/usr/local/lib
OK, what have you set for the "driver" option in mods-enabled/sql? It should be "rlm_sql_sqlite". If you set it to "rlm_sqlite" then you'll get the error you are getting. If that doesn't help, to save more guesswork please post the full output of radiusd -X. Matthew -- Matthew Newton, Ph.D. <mcn4@leicester.ac.uk> Systems Specialist, Infrastructure Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk>
On Jun 8, 2017, at 8:15 AM, Stabla, Daniel <dstabla@materna.de> wrote:
The directory is not the problem, the value is:
libdir = /usr/local/lib64:/usr/local/lib
The problem is, that the lib is called /usr/local/lib64/rlm_sql_sqlite.so and we don't know why.
That's how Linux libraries work... The "libdir" directive says "search for libraries in /usr/local/lib64, and also /usr/local/lib" The library itself is /usr/local/lib64/rlm_sql_sqlite.so, which means it's a file called rlm_sql_sqlite.so, in the directory /usr/local/lib64/ This is basic Unix system administration.
An installation with these steps leads us to this error:
You don't show any errors. Run the server in debug mode as suggested in the FAQ, "man" page, web pages, and pretty much daily on this list. If you aren't clear on how Unix directories and libraries work, it's best to have someone else read the debug messages. Right now, you're looking in entirely the wrong place. Alan DeKok.
participants (3)
-
Alan DeKok -
Matthew Newton -
Stabla, Daniel