need help from FR gurus.

Abul Monsur Mannan monsurc1 at gmail.com
Fri Jun 9 19:03:33 CEST 2006


Dear FR lovers,
Here is the packages I've got in RH Linux4 with freeradius-1.1.1. and
mysql.I've a problem about the driver of mysql.Would you please give
me some time to figure out where r the problems and what r the
solutions ?

[root at localhost ~]# rpm -qa|grep mysql
mysqlclient10-3.23.58-4.RHEL4.1
mysql-4.1.7-4.RHEL4.1
mysql-devel-4.1.7-4.RHEL4.1
mysql-server-4.1.7-4.RHEL4.1
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysql-bench-4.1.7-4.RHEL4.1

[root at localhost ~]# cd
/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql

[root at localhost rlm_sql_mysql]# ls
config.cache  config.h.in  config.status  configure.in  Makefile.in
config.h      config.log   configure      Makefile      sql_mysql.c

[root at localhost lib]# cd
/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql [root at localhost
rlm_sql]# ls
conf.h         configure     Makefile     rlm_sql.c   rlm_sql.lo  sql.lo
config.log     configure.in  Makefile.in  rlm_sql.h   rlm_sql.o   sql.o
config.status  drivers       README       rlm_sql.la  sql.c       stable

[root at localhost rlm_sql]# cd
/usr/local/src/freeradius-1.1.1/src/modules/lib [root at localhost lib]#
ls
notused-1.1.1.so           rlm_eap_leap.so            rlm_mschap.la
notused.a                  rlm_eap_md5-1.1.1.so       rlm_mschap.lai
notused.la                 rlm_eap_md5.a              rlm_mschap.so
notused.lai                rlm_eap_md5.la             rlm_ns_mta_md5-1.1.1.so
notused.so                 rlm_eap_md5.lai            rlm_ns_mta_md5.a
rlm_acct_unique-1.1.1.so   rlm_eap_md5.so             rlm_ns_mta_md5.la
rlm_acct_unique.a          rlm_eap_mschapv2-1.1.1.so  rlm_ns_mta_md5.lai
rlm_acct_unique.la         rlm_eap_mschapv2.a         rlm_ns_mta_md5.so
rlm_acct_unique.lai        rlm_eap_mschapv2.la        rlm_otp-1.1.1.so
rlm_acct_unique.so         rlm_eap_mschapv2.lai       rlm_otp.a
rlm_always-1.1.1.so        rlm_eap_mschapv2.so        rlm_otp.la
rlm_always.a               rlm_eap_peap-1.1.1.so      rlm_otp.lai
rlm_always.la              rlm_eap_peap.a             rlm_otp.so
rlm_always.lai             rlm_eap_peap.la            rlm_pam-1.1.1.so
rlm_always.so              rlm_eap_peap.lai           rlm_pam.a
rlm_attr_filter-1.1.1.so   rlm_eap_peap.so            rlm_pam.la
rlm_attr_filter.a          rlm_eap_sim-1.1.1.so       rlm_pam.lai
rlm_attr_filter.la         rlm_eap_sim.a              rlm_pam.so
rlm_attr_filter.lai        rlm_eap_sim.la             rlm_pap-1.1.1.so
rlm_attr_filter.so         rlm_eap_sim.lai            rlm_pap.a
rlm_attr_rewrite-1.1.1.so  rlm_eap_sim.so             rlm_pap.la
rlm_attr_rewrite.a         rlm_eap.so                 rlm_pap.lai
rlm_attr_rewrite.la        rlm_eap_tls-1.1.1.so       rlm_pap.so
rlm_attr_rewrite.lai       rlm_eap_tls.a              rlm_passwd-1.1.1.so
rlm_attr_rewrite.so        rlm_eap_tls.la             rlm_passwd.a
rlm_chap-1.1.1.so          rlm_eap_tls.lai            rlm_passwd.la
rlm_chap.a                 rlm_eap_tls.so             rlm_passwd.lai
rlm_chap.la                rlm_eap_ttls-1.1.1.so      rlm_passwd.so
rlm_chap.lai               rlm_eap_ttls.a             rlm_perl-1.1.1.so
rlm_chap.so                rlm_eap_ttls.la            rlm_perl.a
rlm_checkval-1.1.1.so      rlm_eap_ttls.lai           rlm_perl.la
rlm_checkval.a             rlm_eap_ttls.so            rlm_perl.lai
rlm_checkval.la            rlm_exec-1.1.1.so          rlm_perl.so
rlm_checkval.lai           rlm_exec.a                 rlm_preprocess-1.1.1.so
rlm_checkval.so            rlm_exec.la                rlm_preprocess.a
rlm_counter-1.1.1.so       rlm_exec.lai               rlm_preprocess.la
rlm_counter.a              rlm_exec.so                rlm_preprocess.lai
rlm_counter.la             rlm_expr-1.1.1.so          rlm_preprocess.so
rlm_counter.lai            rlm_expr.a                 rlm_radutmp-1.1.1.so
rlm_counter.so             rlm_expr.la                rlm_radutmp.a
rlm_dbm-1.1.1.so           rlm_expr.lai               rlm_radutmp.la
rlm_dbm.a                  rlm_expr.so                rlm_radutmp.lai
rlm_dbm_cat                rlm_fastusers-1.1.1.so     rlm_radutmp.so
rlm_dbm.la                 rlm_fastusers.a            rlm_realm-1.1.1.so
rlm_dbm.lai                rlm_fastusers.la           rlm_realm.a
rlm_dbm_parser             rlm_fastusers.lai          rlm_realm.la
rlm_dbm.so                 rlm_fastusers.so           rlm_realm.lai
rlm_detail-1.1.1.so        rlm_files-1.1.1.so         rlm_realm.so
rlm_detail.a               rlm_files.a                rlm_sql-1.1.1.so
rlm_detail.la              rlm_files.la               rlm_sql.a
rlm_detail.lai             rlm_files.lai              rlm_sqlcounter-1.1.1.so
rlm_detail.so              rlm_files.so               rlm_sqlcounter.a
rlm_digest-1.1.1.so        rlm_ippool-1.1.1.so        rlm_sqlcounter.la
rlm_digest.a               rlm_ippool.a               rlm_sqlcounter.lai
rlm_digest.la              rlm_ippool.la              rlm_sqlcounter.so
rlm_digest.lai             rlm_ippool.lai             rlm_sql.la
rlm_digest.so              rlm_ippool.so              rlm_sql.lai
rlm_eap-1.1.1.so           rlm_ippool_tool            rlm_sql_log-1.1.1.so
rlm_eap.a                  rlm_krb5-1.1.1.so          rlm_sql_log.a
rlm_eap_gtc-1.1.1.so       rlm_krb5.a                 rlm_sql_log.la
rlm_eap_gtc.a              rlm_krb5.la                rlm_sql_log.lai
rlm_eap_gtc.la             rlm_krb5.lai               rlm_sql_log.so
rlm_eap_gtc.lai            rlm_krb5.so                rlm_sql.so
rlm_eap_gtc.so             rlm_ldap-1.1.1.so          rlm_unix-1.1.1.so
rlm_eap.la                 rlm_ldap.a                 rlm_unix.a
rlm_eap.lai                rlm_ldap.la                rlm_unix.la
rlm_eap_leap-1.1.1.so      rlm_ldap.lai               rlm_unix.lai
rlm_eap_leap.a             rlm_ldap.so                rlm_unix.so
rlm_eap_leap.la            rlm_mschap-1.1.1.so        smbencrypt
rlm_eap_leap.lai           rlm_mschap.a

[root at localhost lib]# cd /usr/local/src/freeradius-1.1.1/doc/examples
[root at localhost examples]# ls
iplanet.ldif    Makefile   mysql.sql        oracle.sql
iplanet.schema  mssql.sql  openldap.schema  postgresql.sql


After running the command in terminal window Radius-X I got the error
message like below---
*
*
*
rlm_sql (sql): "/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql"
is NOT an SQL driver!
radiusd.conf[14]: sql: Module instantiation failed.
radiusd.conf[1798] Unknown module "sql".
radiusd.conf[1727] Failed to parse authorize section.

Is there any GURU  to help me out of this problem.

Thank you.



More information about the Freeradius-Users mailing list