Freeradius and MySQL problem!!!

[Ackbar Joolia]

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 at lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com at lists.freeradius.org] On Behalf Of tnt at 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 at 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 at lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com at lists.freeradius.org] On Behalf Of tnt at 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 at 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 at lists.freeradius.org [mailto:freeradius-users-bounces+ackbar.joolia=bglobalplc.com at listsfreeradius.org] On Behalf Of tnt at 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 at 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 at 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 at 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 at bglobalmetering.com