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@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@localhost ~]# cd /usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql [root@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@localhost lib]# cd /usr/local/src/freeradius-1.1.1/src/modules/rlm_sql [root@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@localhost rlm_sql]# cd /usr/local/src/freeradius-1.1.1/src/modules/lib [root@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@localhost lib]# cd /usr/local/src/freeradius-1.1.1/doc/examples [root@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.
On 6/9/06, Abul Monsur Mannan <monsurc1@gmail.com> wrote:
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.
No guru needed up to now (not wanting to picture myself even remotely as one *g*) However it looks like you want some setup more closely related to a default one. No need and most probably place for "/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql" in your sql.conf. Your should keep it to the provided "rlm_sql_mysql" for now. Furthermore you seem to rely on the compiled source tree of freeradius as an installation. That doesn't provide a sane environment for meaningful debugging. Please use a package provided by your disrtrbution or do a "make install" in the alternative. After that being done, please post a debugging output (freeradius -X -A) and eventually relevant snippet of your configuration if problems still exist. That should be the minimum effort on your side before bothering the real guru(s) here. Regards, Klaus Hoercher
On Friday 09 June 2006 13:03, Abul Monsur Mannan wrote:
[root@localhost rlm_sql]# cd /usr/local/src/freeradius-1.1.1/src/modules/lib [root@localhost lib]# ls
I don't see rlm_sql_mysql.so in this output, which points to build issues (usually). When you compiled freeradius, were there errors when it tried building that sub-module? If you're using the RH supplied RPMS, I believe they split out the database-specific modules, so you would want to also install freeradius-mysql via yum, up2date, apt, etc.
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.
Wow. How did you get that error? It looks like you've put the full path to the source directory as the sql driver in sql.conf. The only reason to change the driver line in an sql module definition is to specify a different database type than MySQL. What commands are you using to build freeradius? Docs for most OSS usually say "./configure; make; make install", and let you override certain options at each stage if necessary. The lib directory you're showing us is inside the actual source directory, which isn't a normal install location. Kevin Bonner
participants (3)
-
Abul Monsur Mannan -
K. Hoercher -
Kevin Bonner