Re: Ignoring unconnected handle 4..
Thank You I figured it out.It's working now. On 7/11/06, Chris Carver <[EMAIL PROTECTED]> wrote: Abul Monsur Mannan wrote: > Hello FR users > > Can anyone here to light on me.My problem is -- > > [EMAIL PROTECTED] ~]# radtest rumen rumen1 localhost 1812 testing123 > Sending Access-Request of id 66 to 127.0.0.1 port 1812 > User-Name = "rumen" > User-Password = "rumen1" > NAS-IP-Address = 255.255.255.255 > NAS-Port = 1812 > Re-sending Access-Request of id 66 to 127.0.0.1 port 1812 > User-Name = "rumen" > User-Password = "rumen1" > NAS-IP-Address = 255.255.255.255 > NAS-Port = 1812 > > -- > > In radiusd -x command promp-- > > rad_recv: Access-Request packet from host 127.0.0.1:32769, id=66, > length=57 > User-Name = "rumen" > User-Password = "rumen1" > NAS-IP-Address = 255.255.255.255 > NAS-Port = 1812 > Processing the authorize section of radiusd.conf > modcall: entering group authorize for request 23 > modcall[authorize]: module "preprocess" returns ok for request 23 > modcall[authorize]: module "chap" returns noop for request 23 > modcall[authorize]: module "mschap" returns noop for request 23 > rlm_realm: No '@' in User-Name = "rumen", looking up realm NULL > rlm_realm: No such realm "NULL" > modcall[authorize]: module "suffix" returns noop for request 23 > rlm_eap: No EAP-Message, not doing EAP > modcall[authorize]: module "eap" returns noop for request 23 > radius_xlat: 'rumen' > rlm_sql (sql): sql_set_user escaped user --> 'rumen' > radius_xlat: 'SELECT id, UserName, Attribute, Value, op > FROM radcheck WHERE Username = 'rumen' ORDER BY > id' > rlm_sql (sql): Ignoring unconnected handle 4.. > rlm_sql (sql): Ignoring unconnected handle 3.. > rlm_sql (sql): Ignoring unconnected handle 2.. > rlm_sql (sql): Ignoring unconnected handle 1.. > rlm_sql (sql): Ignoring unconnected handle 0.. > rlm_sql (sql): There are no DB handles to use! skipped 5, tried to > connect 0 > modcall[authorize]: module "sql" returns fail for request 23 > modcall: leaving group authorize (returns fail) for request 23 > Finished request 23 > Going to the next request > --- Walking the entire request list --- > Waking up in 6 seconds... > --- Walking the entire request list --- > Cleaning up request 23 ID 66 with timestamp 44b33d38 > Nothing to do. Sleeping until we see a request. > > > By the way ,I have username - rumen with password rumen1 in "radcheck" > table in my mysql DB. > > Thank You in advance. > - List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html For some reason your radius server is completely unable to connect to your mysql database. Look at the information you have configured in your sql configuration file (myssql.conf, sql.conf, etc depending on which you use) and verify it is correct. Try using the command line mysql client to connect to the mysql database you specify to ensure it should work properly. mysql -u -p -h radius Chris Carver Network Engineer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ignoring unconnected handle 4..
Hello FR users Can anyone here to light on me.My problem is -- [EMAIL PROTECTED] ~]# radtest rumen rumen1 localhost 1812 testing123 Sending Access-Request of id 66 to 127.0.0.1 port 1812 User-Name = "rumen" User-Password = "rumen1" NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 Re-sending Access-Request of id 66 to 127.0.0.1 port 1812 User-Name = "rumen" User-Password = "rumen1" NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 -- In radiusd -x command promp-- rad_recv: Access-Request packet from host 127.0.0.1:32769, id=66, length=57 User-Name = "rumen" User-Password = "rumen1" NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 Processing the authorize section of radiusd.conf modcall: entering group authorize for request 23 modcall[authorize]: module "preprocess" returns ok for request 23 modcall[authorize]: module "chap" returns noop for request 23 modcall[authorize]: module "mschap" returns noop for request 23 rlm_realm: No '@' in User-Name = "rumen", looking up realm NULL rlm_realm: No such realm "NULL" modcall[authorize]: module "suffix" returns noop for request 23 rlm_eap: No EAP-Message, not doing EAP modcall[authorize]: module "eap" returns noop for request 23 radius_xlat: 'rumen' rlm_sql (sql): sql_set_user escaped user --> 'rumen' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'rumen' ORDER BY id' rlm_sql (sql): Ignoring unconnected handle 4.. rlm_sql (sql): Ignoring unconnected handle 3.. rlm_sql (sql): Ignoring unconnected handle 2.. rlm_sql (sql): Ignoring unconnected handle 1.. rlm_sql (sql): Ignoring unconnected handle 0.. rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 modcall[authorize]: module "sql" returns fail for request 23 modcall: leaving group authorize (returns fail) for request 23 Finished request 23 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 23 ID 66 with timestamp 44b33d38 Nothing to do. Sleeping until we see a request. By the way ,I have username - rumen with password rumen1 in "radcheck" table in my mysql DB. Thank You in advance. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius-mysql rpm
Thank U all helpful souls. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius-mysql rpm
First of all Thank U Jin Fan very much for the detail email. Can U clarify something more ! 1. Where(path) u unzip the rpm file ? 2. Would u please tell me about ur advice" Then load the first file " - load means what ? copy or move ? Please light on me . On 6/19/06, Jin Fan <[EMAIL PROTECTED]> wrote: I am using an older version of freeradius 1.0.2 and Fedora 4. My way to solve the missing rlm_sql_mysql.so problem is the following. 1. I download the freeradius-mysql rpm package from this website. http://rpmfind.net/linux/RPM/fedora/updates/1/i386/freeradius-mysql-0.9. 3-1.1.i386.html 2. Then I used 7-Zip to extract rlm_sql_mysql.so from the rpm. There are two files in the rpm, rlm_sql_mysql-1.0.2.so and rlm_sql_mysql.so. The second file is the link file to the first file. 3. Then load the first file into /use/lib/ folder, which contains all the link library files. Make a link to the file and name it rlm_sql_mysql.so. You also need to use chmod command to change the file permission. 4. Restart freeradius server and it might run. You might need to find the correct rpm package for your system. Jin Fan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius-mysql rpm
First of all Thank You for your response. Actuallu I'm using Redhat Linux Enterprise 4 .I've 4 cds.After installation, I've got Mysql_devel,mysql_client and mysql_server.But I don't get any rlm_mysql.so file in any directory. In the meantime, I found the freeradius_mysql rpm from web and want to install it. But my Q. is where should I install the file.I want your Help... Please help me out of this problem. Thank You again. On 6/19/06, Kofi Adusei Koduah-Sarpong <[EMAIL PROTECTED]> wrote: It's on the one of cds I can't remember which one which version are you using? Dvd or cds? Just look through the cds. I actually saw it this week while looking for it to make a package for a cobalt RaQ550 box. It has the mysql rpm too. I'll try see which cd it's on when I get home. Hope this helped -Original Message- From: Abul Monsur Mannan [mailto:[EMAIL PROTECTED] Sent: 18 June 2006 14:56 To: FreeRadius users mailing list Subject: freeradius-mysql rpm Dear FR users I've an enquiry.Please response. I'm using RHEL 4.It has no rlm_mysql.so files and I found that it has no freeradius-mysql rpm either. So, can anyone help me providing the info. that where I find that rpm for redhat linux enterprise 4 to use with freeradius-1.1.2? I'm looking fr ur response soon. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
freeradius-mysql rpm
Dear FR users I've an enquiry.Please response. I'm using RHEL 4.It has no rlm_mysql.so files and I found that it has no freeradius-mysql rpm either. So, can anyone help me providing the info. that where I find that rpm for redhat linux enterprise 4 to use with freeradius-1.1.2? I'm looking fr ur response soon. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
need help from FR gurus.
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 ? [EMAIL PROTECTED] ~]# 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 [EMAIL PROTECTED] ~]# cd /usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql [EMAIL PROTECTED] rlm_sql_mysql]# ls config.cache config.h.in config.status configure.in Makefile.in config.h config.log configure Makefile sql_mysql.c [EMAIL PROTECTED] lib]# cd /usr/local/src/freeradius-1.1.1/src/modules/rlm_sql [EMAIL PROTECTED] 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 [EMAIL PROTECTED] rlm_sql]# cd /usr/local/src/freeradius-1.1.1/src/modules/lib [EMAIL PROTECTED] lib]# ls notused-1.1.1.so rlm_eap_leap.sorlm_mschap.la notused.a rlm_eap_md5-1.1.1.so rlm_mschap.lai notused.la rlm_eap_md5.a rlm_mschap.so notused.lairlm_eap_md5.la rlm_ns_mta_md5-1.1.1.so notused.so rlm_eap_md5.lairlm_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.lairlm_eap_mschapv2.larlm_otp-1.1.1.so rlm_acct_unique.so rlm_eap_mschapv2.lai rlm_otp.a rlm_always-1.1.1.sorlm_eap_mschapv2.sorlm_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.larlm_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.sorlm_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.lairlm_eap_sim.la rlm_pap-1.1.1.so rlm_attr_filter.so rlm_eap_sim.lairlm_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.larlm_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.sorlm_eap_tls.la rlm_passwd.a rlm_chap-1.1.1.so rlm_eap_tls.lairlm_passwd.la rlm_chap.a rlm_eap_tls.so rlm_passwd.lai rlm_chap.larlm_eap_ttls-1.1.1.so rlm_passwd.so rlm_chap.lai rlm_eap_ttls.a rlm_perl-1.1.1.so rlm_chap.sorlm_eap_ttls.larlm_perl.a rlm_checkval-1.1.1.so rlm_eap_ttls.lai rlm_perl.la rlm_checkval.a rlm_eap_ttls.sorlm_perl.lai rlm_checkval.larlm_exec-1.1.1.so rlm_perl.so rlm_checkval.lai rlm_exec.a rlm_preprocess-1.1.1.so rlm_checkval.sorlm_exec.larlm_preprocess.a rlm_counter-1.1.1.so rlm_exec.lai rlm_preprocess.la rlm_counter.a rlm_exec.sorlm_preprocess.lai rlm_counter.la rlm_expr-1.1.1.so rlm_preprocess.so rlm_counter.lairlm_expr.a rlm_radutmp-1.1.1.so rlm_counter.so rlm_expr.larlm_radutmp.a rlm_dbm-1.1.1.so rlm_expr.lai rlm_radutmp.la rlm_dbm.a rlm_expr.sorlm_radutmp.lai rlm_dbm_catrlm_fastusers-1.1.1.so rlm_radutmp.so rlm_dbm.la rlm_fastusers.arlm_realm-1.1.1.so rlm_dbm.lairlm_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.sorlm_files-1.1.1.so rlm_realm.so rlm_detail.a rlm_files.arlm_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.sorlm_ippool-1.1.1.sorlm_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.
Re: freeradius rlm_sql driver problem-need help
Hello Edvin I'm sorry for my ignorance Please respond. On 6/3/06, Abul Monsur Mannan <[EMAIL PROTECTED]> wrote: Hello Edvin, > In your sql.conf file - you should enter only "rlm_sql_mysql" under "driver" > option - not the whole path ! If this is entered, be sure that you have > compiled mysql-driver. > My driver option is ok as you said. Since I'm new in the linux area, I don't understand how to compile the mysql-driver. Please show me the way.I'll be grateful to you. > On 6/1/06, Seferovic Edvin <[EMAIL PROTECTED]> wrote: > > Hi, > > > > how did you "installed" it? From an RPM ? or have you compiled and > installed > > it from source? Are your mysql libraries available? > > > > Regards, > > > > Edvin > > > > -Original Message- > > From: > [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > g] On Behalf Of Abul Monsur Mannan > > Sent: Donnerstag, 01. Juni 2006 08:12 > > To: FreeRadius users mailing list > > Subject: freeradius rlm_sql driver problem-need help > > > > Hello FR Users > > > > Can anybody here help me out of this problem? > > I installed freeradius version 1.1.1 with mysql on RH Linux Enterprise 4 > ed. > > I've got this result > > > > [EMAIL PROTECTED] ~]# radiusd -X > > Starting - reading configuration files ... > > > > reread_config: reading radiusd.conf > > Config: including file: /usr/local/etc/raddb/proxy.conf > > Config: including file: /usr/local/etc/raddb/clients.conf > > Config: including file: /usr/local/etc/raddb/snmp.conf > > Config: including file: /usr/local/etc/raddb/eap.conf > > Config: including file: /usr/local/etc/raddb/sql.conf > > main: prefix = "/usr/local" > > main: localstatedir = "/usr/local/var" > > main: logdir = "/usr/local/var/log/radius" > > main: libdir = "/usr/local/lib" > > main: radacctdir = "/usr/local/var/log/radius/radacct" > > main: hostname_lookups = no > > main: max_request_time = 30 > > main: cleanup_delay = 5 > > main: max_requests = 1024 > > main: delete_blocked_requests = 0 > > main: port = 0 > > main: allow_core_dumps = no > > main: log_stripped_names = no > > main: log_file = "/usr/local/var/log/radius/radius.log" > > main: log_auth = no > > main: log_auth_badpass = no > > main: log_auth_goodpass = no > > main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" > > main: user = "(null)" > > main: group = "(null)" > > main: usercollide = no > > main: lower_user = "no" > > main: lower_pass = "no" > > main: nospace_user = "no" > > main: nospace_pass = "no" > > main: checkrad = "/usr/local/sbin/checkrad" > > main: proxy_requests = yes > > proxy: retry_delay = 5 > > proxy: retry_count = 3 > > proxy: synchronous = no > > proxy: default_fallback = yes > > proxy: dead_time = 120 > > proxy: post_proxy_authorize = no > > proxy: wake_all_if_all_dead = no > > security: max_attributes = 200 > > security: reject_delay = 1 > > security: status_server = no > > main: debug_level = 0 > > read_config_files: reading dictionary > > read_config_files: reading naslist > > Using deprecated naslist file. Support for this will go away soon. > > read_config_files: reading clients > > read_config_files: reading realms > > Using deprecated realms file. Support for this will go away soon. > > radiusd: entering modules setup > > Module: Library search path is /usr/local/lib > > Module: Loaded exec > > exec: wait = yes > > exec: program = "(null)" > > exec: input_pairs = "request" > > exec: output_pairs = "(null)" > > exec: packet_type = "(null)" > > rlm_exec: Wait=yes but no output defined. Did you mean output=none? > > Module: Instantiated exec (exec) > > Module: Loaded expr > > Module: Instantiated expr (expr) > > Module: Loaded PAP > > pap: encryption_scheme = "crypt" > > Module: Instantiated pap (pap) > > Module: Loaded CHAP > > Module: Instantiated chap (chap) > > Module: Loaded MS-CHAP > > mschap: use_mppe = yes > > mschap: require_encryption = no > > mschap: require_strong = no > > mschap: with_ntdomain_hack = no > > mschap: passwd = "(null)" > > mschap: authtype = "MS-CHAP" > &g
Re: freeradius rlm_sql driver problem-need help
Hello Edvin, In your sql.conf file - you should enter only "rlm_sql_mysql" under "driver" option - not the whole path ! If this is entered, be sure that you have compiled mysql-driver. My driver option is ok as you said. Since I'm new in the linux area, I don't understand how to compile the mysql-driver. Please show me the way.I'll be grateful to you. On 6/1/06, Seferovic Edvin <[EMAIL PROTECTED]> wrote: > Hi, > > how did you "installed" it? From an RPM ? or have you compiled and installed > it from source? Are your mysql libraries available? > > Regards, > > Edvin > > -Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > g] On Behalf Of Abul Monsur Mannan > Sent: Donnerstag, 01. Juni 2006 08:12 > To: FreeRadius users mailing list > Subject: freeradius rlm_sql driver problem-need help > > Hello FR Users > > Can anybody here help me out of this problem? > I installed freeradius version 1.1.1 with mysql on RH Linux Enterprise 4 ed. > I've got this result > > [EMAIL PROTECTED] ~]# radiusd -X > Starting - reading configuration files ... > > reread_config: reading radiusd.conf > Config: including file: /usr/local/etc/raddb/proxy.conf > Config: including file: /usr/local/etc/raddb/clients.conf > Config: including file: /usr/local/etc/raddb/snmp.conf > Config: including file: /usr/local/etc/raddb/eap.conf > Config: including file: /usr/local/etc/raddb/sql.conf > main: prefix = "/usr/local" > main: localstatedir = "/usr/local/var" > main: logdir = "/usr/local/var/log/radius" > main: libdir = "/usr/local/lib" > main: radacctdir = "/usr/local/var/log/radius/radacct" > main: hostname_lookups = no > main: max_request_time = 30 > main: cleanup_delay = 5 > main: max_requests = 1024 > main: delete_blocked_requests = 0 > main: port = 0 > main: allow_core_dumps = no > main: log_stripped_names = no > main: log_file = "/usr/local/var/log/radius/radius.log" > main: log_auth = no > main: log_auth_badpass = no > main: log_auth_goodpass = no > main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" > main: user = "(null)" > main: group = "(null)" > main: usercollide = no > main: lower_user = "no" > main: lower_pass = "no" > main: nospace_user = "no" > main: nospace_pass = "no" > main: checkrad = "/usr/local/sbin/checkrad" > main: proxy_requests = yes > proxy: retry_delay = 5 > proxy: retry_count = 3 > proxy: synchronous = no > proxy: default_fallback = yes > proxy: dead_time = 120 > proxy: post_proxy_authorize = no > proxy: wake_all_if_all_dead = no > security: max_attributes = 200 > security: reject_delay = 1 > security: status_server = no > main: debug_level = 0 > read_config_files: reading dictionary > read_config_files: reading naslist > Using deprecated naslist file. Support for this will go away soon. > read_config_files: reading clients > read_config_files: reading realms > Using deprecated realms file. Support for this will go away soon. > radiusd: entering modules setup > Module: Library search path is /usr/local/lib > Module: Loaded exec > exec: wait = yes > exec: program = "(null)" > exec: input_pairs = "request" > exec: output_pairs = "(null)" > exec: packet_type = "(null)" > rlm_exec: Wait=yes but no output defined. Did you mean output=none? > Module: Instantiated exec (exec) > Module: Loaded expr > Module: Instantiated expr (expr) > Module: Loaded PAP > pap: encryption_scheme = "crypt" > Module: Instantiated pap (pap) > Module: Loaded CHAP > Module: Instantiated chap (chap) > Module: Loaded MS-CHAP > mschap: use_mppe = yes > mschap: require_encryption = no > mschap: require_strong = no > mschap: with_ntdomain_hack = no > mschap: passwd = "(null)" > mschap: authtype = "MS-CHAP" > mschap: ntlm_auth = "(null)" > Module: Instantiated mschap (mschap) > Module: Loaded eap > eap: default_eap_type = "md5" > eap: timer_expire = 60 > eap: ignore_unknown_eap_types = no > eap: cisco_accounting_username_bug = no > rlm_eap: Loaded and initialized type md5 > rlm_eap: Loaded and initialized type leap > gtc: challenge = "Password: " > gtc: auth_type = "PAP" > rlm_eap: Loaded and initialized type gtc > mschapv2: with_ntdomain_hack = no > rlm_eap: Loaded and initialized type mschapv2 > Module: Instantiated eap (eap) > Module: Loaded preprocess > preprocess: hunt
Re: freeradius rlm_sql driver problem-need help
Hello Edvin, Thanks for responding. mysql was installed from the linux Enterprise 4 cd by selecting the mysql devel,server and client options. --Monsur On 6/1/06, Seferovic Edvin <[EMAIL PROTECTED]> wrote: Hi, how did you "installed" it? From an RPM ? or have you compiled and installed it from source? Are your mysql libraries available? Regards, Edvin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] g] On Behalf Of Abul Monsur Mannan Sent: Donnerstag, 01. Juni 2006 08:12 To: FreeRadius users mailing list Subject: freeradius rlm_sql driver problem-need help Hello FR Users Can anybody here help me out of this problem? I installed freeradius version 1.1.1 with mysql on RH Linux Enterprise 4 ed. I've got this result [EMAIL PROTECTED] ~]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms Using deprecated realms file. Support for this will go away soon. radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "/usr/local/etc/raddb/users" files: acctusersfile = "/usr/local/etc/raddb/acct_users" files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" files: compat = "no" Module: Instantiated files (f
freeradius rlm_sql driver problem-need help
Hello FR Users
Can anybody here help me out of this problem?
I installed freeradius version 1.1.1 with mysql on RH Linux Enterprise 4 ed.
I've got this result
[EMAIL PROTECTED] ~]# radiusd -X
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /usr/local/etc/raddb/proxy.conf
Config: including file: /usr/local/etc/raddb/clients.conf
Config: including file: /usr/local/etc/raddb/snmp.conf
Config: including file: /usr/local/etc/raddb/eap.conf
Config: including file: /usr/local/etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/usr/local/var"
main: logdir = "/usr/local/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/usr/local/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/usr/local/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = no
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will go away soon.
read_config_files: reading clients
read_config_files: reading realms
Using deprecated realms file. Support for this will go away soon.
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded exec
exec: wait = yes
exec: program = "(null)"
exec: input_pairs = "request"
exec: output_pairs = "(null)"
exec: packet_type = "(null)"
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded eap
eap: default_eap_type = "md5"
eap: timer_expire = 60
eap: ignore_unknown_eap_types = no
eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
gtc: challenge = "Password: "
gtc: auth_type = "PAP"
rlm_eap: Loaded and initialized type gtc
mschapv2: with_ntdomain_hack = no
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded preprocess
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
preprocess: hints = "/usr/local/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
realm: ignore_default = no
realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded files
files: usersfile = "/usr/local/etc/raddb/users"
files: acctusersfile = "/usr/local/etc/raddb/acct_users"
files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded SQL
sql: driver =
"/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "radius"
sql: password = "radpass"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{Stripped-User-Name:-%{User-Name:-DEFAULT}}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id, UserName, Attribute, Value,
opFROM radcheck WHERE Username = '%{SQL-User-Name}'
ORDER BY id"
sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value,
rlm_mysql module instantiation failed.
Hello FR Users
Can anybody here help me out of this problem?
I installed freeradius version 1.1.1 with mysql on RH Linux Enterprise 4 ed.
I've got this result
[EMAIL PROTECTED] ~]# radiusd -X
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /usr/local/etc/raddb/proxy.conf
Config: including file: /usr/local/etc/raddb/clients.conf
Config: including file: /usr/local/etc/raddb/snmp.conf
Config: including file: /usr/local/etc/raddb/eap.conf
Config: including file: /usr/local/etc/raddb/sql.conf
main: prefix = "/usr/local"
main: localstatedir = "/usr/local/var"
main: logdir = "/usr/local/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/usr/local/var/log/radius/radacct"
main: hostname_lookups = no
main: max_request_time = 30
main: cleanup_delay = 5
main: max_requests = 1024
main: delete_blocked_requests = 0
main: port = 0
main: allow_core_dumps = no
main: log_stripped_names = no
main: log_file = "/usr/local/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"
main: user = "(null)"
main: group = "(null)"
main: usercollide = no
main: lower_user = "no"
main: lower_pass = "no"
main: nospace_user = "no"
main: nospace_pass = "no"
main: checkrad = "/usr/local/sbin/checkrad"
main: proxy_requests = yes
proxy: retry_delay = 5
proxy: retry_count = 3
proxy: synchronous = no
proxy: default_fallback = yes
proxy: dead_time = 120
proxy: post_proxy_authorize = no
proxy: wake_all_if_all_dead = no
security: max_attributes = 200
security: reject_delay = 1
security: status_server = no
main: debug_level = 0
read_config_files: reading dictionary
read_config_files: reading naslist
Using deprecated naslist file. Support for this will go away soon.
read_config_files: reading clients
read_config_files: reading realms
Using deprecated realms file. Support for this will go away soon.
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded exec
exec: wait = yes
exec: program = "(null)"
exec: input_pairs = "request"
exec: output_pairs = "(null)"
exec: packet_type = "(null)"
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
pap: encryption_scheme = "crypt"
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
mschap: use_mppe = yes
mschap: require_encryption = no
mschap: require_strong = no
mschap: with_ntdomain_hack = no
mschap: passwd = "(null)"
mschap: authtype = "MS-CHAP"
mschap: ntlm_auth = "(null)"
Module: Instantiated mschap (mschap)
Module: Loaded eap
eap: default_eap_type = "md5"
eap: timer_expire = 60
eap: ignore_unknown_eap_types = no
eap: cisco_accounting_username_bug = no
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
gtc: challenge = "Password: "
gtc: auth_type = "PAP"
rlm_eap: Loaded and initialized type gtc
mschapv2: with_ntdomain_hack = no
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded preprocess
preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
preprocess: hints = "/usr/local/etc/raddb/hints"
preprocess: with_ascend_hack = no
preprocess: ascend_channels_per_line = 23
preprocess: with_ntdomain_hack = no
preprocess: with_specialix_jetstream_hack = no
preprocess: with_cisco_vsa_hack = no
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
realm: ignore_default = no
realm: ignore_null = no
Module: Instantiated realm (suffix)
Module: Loaded files
files: usersfile = "/usr/local/etc/raddb/users"
files: acctusersfile = "/usr/local/etc/raddb/acct_users"
files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded SQL
sql: driver =
"/usr/local/src/freeradius-1.1.1/src/modules/rlm_sql/drivers/rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "radius"
sql: password = "radpass"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
sql: readclients = no
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{Stripped-User-Name:-%{User-Name:-DEFAULT}}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "SELECT id, UserName, Attribute, Value,
opFROM radcheck WHERE Username = '%{SQL-User-Name}'
ORDER BY id"
sql: authorize_reply_query = "SELECT id, UserName, Attribute, Valu
Re: radiusd run time problem
Make sure the rlm_sql libs appear in the lib dir of the dir you installed it in. rlm_sql is not installed in lib dir. It's intalled in /driver/rlm_sql the default dir when redhat enterprise installed. I installed sql devel,sql server and sql client. Do I need to copy any file to the dir where I installed freeradius? --Monsur student On 5/22/06, Chris Carver <[EMAIL PROTECTED]> wrote: Do --with-mysql Make sure the rlm_sql libs appear in the lib dir of the dir you installed it in. Chris Carver Network Engineer Abul Monsur Mannan wrote: > Tahnk you for your responce. > > I've Mysql Devel,server and client installed. > I did like this-- > > ./configur --with -mysql > > as said in > OnLamp:http://www.onlamp.com/pub/a/onlamp/excerpt/radius_5/index1.html > > Thank You again. > > On 5/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> Hi, >> >> > When I execute at root - #radiusd -X the following error message is >> > returned. >> > >> > radiusd.conf[14]: sql: Module instantiation failed. >> > radiusd.conf[1798] Unknown module "sql". >> > radiusd.conf[1727] Failed to parse authorize section. >> >> your config file is asking to load the SQL module but you dont >> have the SQL support compiled in. how did you install FreeRADIUS? >> via a package, or from source? if from source, did you note the errors >> thrown open by the ./configure step? to have SQL support you'd need >> the SQL development environment installed. if you dont need >> SQL, simply comment it out of your config file. >> >> > I've done all the steps that stated on Onlamp's webpage. >> >> its best to state the full URL in these cases too. OnLAMP has >> many many many tutorials >> >> > Could you pls help me out and guide me with full linux command? >> >> the way you called FreeRADIUS is fine...for debugging >> >> alan >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > - List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radiusd run time problem
> ./configur --with -mysql ^^^ with the space? ofcourse not. On 5/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi, > I've Mysql Devel,server and client installed. > I did like this-- > > ./configur --with -mysql ^^^ with the space? alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: radiusd run time problem
Tahnk you for your responce. I've Mysql Devel,server and client installed. I did like this-- ./configur --with -mysql as said in OnLamp:http://www.onlamp.com/pub/a/onlamp/excerpt/radius_5/index1.html Thank You again. On 5/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi, > When I execute at root - #radiusd -X the following error message is > returned. > > radiusd.conf[14]: sql: Module instantiation failed. > radiusd.conf[1798] Unknown module "sql". > radiusd.conf[1727] Failed to parse authorize section. your config file is asking to load the SQL module but you dont have the SQL support compiled in. how did you install FreeRADIUS? via a package, or from source? if from source, did you note the errors thrown open by the ./configure step? to have SQL support you'd need the SQL development environment installed. if you dont need SQL, simply comment it out of your config file. > I've done all the steps that stated on Onlamp's webpage. its best to state the full URL in these cases too. OnLAMP has many many many tutorials > Could you pls help me out and guide me with full linux command? the way you called FreeRADIUS is fine...for debugging alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
radiusd run time problem
Dear FR users, I'm new in this field . I need your help. When I execute at root - #radiusd -X the following error message is returned. radiusd.conf[14]: sql: Module instantiation failed. radiusd.conf[1798] Unknown module "sql". radiusd.conf[1727] Failed to parse authorize section. I've done all the steps that stated on Onlamp's webpage. Could you pls help me out and guide me with full linux command? I'm looking for your kind Thank you. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Fwd: freeradius cannot find the rlm_sql module
-- Forwarded message -- From: Abul Monsur Mannan <[EMAIL PROTECTED]> Date: May 19, 2006 3:28 AM Subject: freeradius cannot find the rlm_sql module To: freeradius-users@lists.freeradius.org -- Forwarded message -- From: Abul Monsur Mannan <[EMAIL PROTECTED]> Date: May 19, 2006 2:47 AM Subject: freeradius cannot find the rlm_sql module To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Hi fr users, I setup Freeradius and mysql again.Actually, at earlier try I ran the server with the command radiusd -X successfuly but now i found the output here [EMAIL PROTECTED] freeradius-1.1.1]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = "(null)" unix: shadow = "/etc/shadow" unix: group = "(null)" unix: radwtmp = "/usr/local/var/log/radius/radwtmp" unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "/usr/local/etc/raddb/users" files: acctusersfile = "/usr/local/etc/raddb/acct_users" files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" files: compat = "no" Module: Instantiated files (files) Module: Lo
freeradius cannot find the rlm_sql module
-- Forwarded message -- From: Abul Monsur Mannan <[EMAIL PROTECTED]> Date: May 19, 2006 2:47 AM Subject: freeradius cannot find the rlm_sql module To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Hi fr users, I setup Freeradius and mysql again.Actually, at earlier try I ran the server with the command radiusd -X successfuly but now i found the output here [EMAIL PROTECTED] freeradius-1.1.1]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = "(null)" unix: shadow = "/etc/shadow" unix: group = "(null)" unix: radwtmp = "/usr/local/var/log/radius/radwtmp" unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "/usr/local/etc/raddb/users" files: acctusersfile = "/usr/local/etc/raddb/acct_users" files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" files: compat = "no" Module: Instantiated files (files) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "raduser" sql: password = "radpass" sql: radius_db = "testdb&quo
Re: Mysql with freeradius Error again
Many thanks for quick reply.I'll do and try then must inform U about the result. Thanks again. On 5/16/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Quoting Abul Monsur Mannan <[EMAIL PROTECTED]>: > how can I configure freeradius to accept request from mysql ? I'm > using Freeradius1.1.1 on Redhat Enterprise4.Should I populate the > tables 'redrely' as well as 'redgroup' with others? You need to populate all the tables except accounting with the correct information. Spend 10 minutes on google and search for a freeradius+mysql tutorial, there's plenty arround explaining what goes in what tables, with examples etc. -- Chris - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql with freeradius Error again
Hello memebers, how can I configure freeradius to accept request from mysql ? I'm using Freeradius1.1.1 on Redhat Enterprise4.Should I populate the tables 'redrely' as well as 'redgroup' with others? Alan, thank U for your reply.But U didn't show me the way to get rid of the problem..U know I'm new here. Please help me out. -Monsur - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
