RE: Freeradius and MySQL problem!!!
Ivan,
I've given all permissions to sql.conf....nothing...it's still the same. Its strange, this used to work well before for the previous version of freeradius. Seems simple, yet!!!
Any other advice?
-----Original Message-----
From: freeradius-users-bounces+ackbar.joolia=bglobalplc.com@lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com@lists.freeradius.org] On Behalf Of tnt@kalik.co.yu
Sent: 02 July 2007 15:50
To: FreeRadius users mailing list
Subject: RE: Freeradius and MySQL problem!!!
It's not reading sql.conf. Check permissions on that file.
Ivan Kalik
Kalik Informatika ISP
Dana 2/7/2007, "Ackbar Joolia" <ackbar.joolia@bglobalplc.com> piše:
>HI Ivan
>The sql in authorize and accounting are all uncommented.
>
>
>-----Original Message-----
>From: freeradius-users-bounces+ackbar.joolia=bglobalplc.com@lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com@lists.freeradius.org] On Behalf Of tnt@kalik.co.yu
>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" <ackbar.joolia@bglobalplc.com> 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: freeradius-users-bounces+ackbar.joolia=bglobalplc.com@lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com@listsfreeradius.org] On Behalf Of tnt@kalik.co.yu
>>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" <ackbar.joolia@bglobalplc.com> 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 info@bglobalmetering.com
>>
>>
>>-
>>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 info@bglobalmetering.com
>
>
>-
>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 info@bglobalmetering.com
This archive was generated by a fusion of
Pipermail (Mailman edition) and
MHonArc.