It's not reading sql.conf. Check permissions on that file. Ivan Kalik Kalik Informatika ISP
Dana 2/7/2007, "Ackbar Joolia" <[EMAIL PROTECTED]> piše: >HI Ivan >The sql in authorize and accounting are all uncommented. > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL >PROTECTED] >Sent: 02 July 2007 14:16 >To: FreeRadius users mailing list >Subject: RE: Freeradius and MySQL problem!!! > >Have you included sql in your radiusd.conf or are sql entries still >commented out? > >Ivan Kalik >Kalik Informatika ISP > > >Dana 2/7/2007, "Ackbar Joolia" <[EMAIL PROTECTED]> piše: > >>Here it is: >>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" >> pap: auto_header = yes >>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: ntlm_auth = "(null)" >>Module: Instantiated mschap (mschap) >>Module: Loaded System >> unix: cache = no >> unix: passwd = "(null)" >> unix: shadow = "(null)" >> 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 >> preprocess: with_alvarion_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 Acct-Unique-Session-Id >> acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, >> Client-IP-Address, NAS-Port" >>Module: Instantiated acct_unique (acct_unique) >>Module: Loaded detail >> detail: detailfile = >> "/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d" >> detail: detailperm = 384 >> detail: dirperm = 493 >> detail: locking = no >>Module: Instantiated detail (detail) >>Module: Loaded radutmp >> radutmp: filename = "/usr/local/var/log/radius/radutmp" >> radutmp: username = "%{User-Name}" >> radutmp: case_sensitive = yes >> radutmp: check_with_nas = yes >> radutmp: perm = 384 >> radutmp: callerid = yes >>Module: Instantiated radutmp (radutmp) >>Listening on authentication *:1812 >>Listening on accounting *:1813 >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL >>PROTECTED] >>Sent: 02 July 2007 12:38 >>To: FreeRadius users mailing list >>Subject: Re: Freeradius and MySQL problem!!! >> >>You haven't posted your radiusd -X output. >> >>Ivan Kalik >>Kalik Informatika ISP >> >> >>Dana 2/7/2007, "Ackbar Joolia" <[EMAIL PROTECTED]> piše: >> >>>Dear all, >>> >>>I have been using freeradius properly configured with mysql for some >>>time now. However it suddenly stopped working. What more, I upgraded to >>>the 1.6 version, and now when I run radiusd -X, it doesn't even show >>>that its tied in with the MySQL database... >>> >>> >>>Can anyone please help me? I have done all the right things i.e. sql in >>>radius.conf, but its not tying in with the mysql database. Am I missing >>>anything obvious ??? >>> >>> >>>Thanks >>> >>>Al >>> >>> >>> >>> >>>- >>>List info/subscribe/unsubscribe? See >>>http://www.freeradius.org/list/users.html >>> >>> >> >>- >>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html >> >> >>*** Email COnfidentiality Notice *** >>This message is private and confidential.If you have received this in error, >>please notify us and remove it from your system. Contact [EMAIL PROTECTED] >> >> >>- >>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html >> >> > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > >*** Email COnfidentiality Notice *** >This message is private and confidential.If you have received this in error, >please notify us and remove it from your system. Contact [EMAIL PROTECTED] > > >- >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html