Re: mysql module help
Ski Mountain wrote: I am trying to get freeradius working with mysql on a new system. I even copied the configuration files from a working system, but I am still having trouble getting the mysql module to load. Yes I have $INCLUDE sql.conf uncommitted from radius.conf Read raddb/sites-available/default. Look for sql Then, read the SQL documentation on the wiki. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql module help
Yes I have already edited the freeradius/sites-available/default file # See Authorization Queries in sql.conf sql From: Alan DeKok al...@deployingradius.com To: Ski Mountain ski_the_mount...@yahoo.com; FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Tuesday, November 15, 2011 4:10 AM Subject: Re: mysql module help Ski Mountain wrote: I am trying to get freeradius working with mysql on a new system. I even copied the configuration files from a working system, but I am still having trouble getting the mysql module to load. Yes I have $INCLUDE sql.conf uncommitted from radius.conf Read raddb/sites-available/default. Look for sql Then, read the SQL documentation on the wiki. Alan DeKok.- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql module help
On Wed, Nov 16, 2011 at 5:44 AM, Ski Mountain ski_the_mount...@yahoo.com wrote: Yes I have already edited the freeradius/sites-available/default Did you edit the right file? If you did, sql would show up on the debug log. The correct file (based on your debug output) should be /etc/raddb/sites-available/default, and not freeradius/sites-available/default -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: mysql module help
Opps wrong directory, I am used to working on systems with /etc/freeradius, while this one should be /etc/raddb the beauty of Debian vs redhat. My bad. From: Fajar A. Nugraha l...@fajar.net To: Ski Mountain ski_the_mount...@yahoo.com; FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Tuesday, November 15, 2011 6:57 PM Subject: Re: mysql module help On Wed, Nov 16, 2011 at 5:44 AM, Ski Mountain ski_the_mount...@yahoo.com wrote: Yes I have already edited the freeradius/sites-available/default Did you edit the right file? If you did, sql would show up on the debug log. The correct file (based on your debug output) should be /etc/raddb/sites-available/default, and not freeradius/sites-available/default -- Fajar- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
mysql module help
I am trying to get freeradius working with mysql on a new system. I even
copied the configuration files from a working system, but I am still having
trouble getting the mysql module to load. Yes I have
$INCLUDE sql.conf
uncommitted from radius.conf
Thanks
[root@server ~]# /usr/sbin/radiusd -X
FreeRADIUS Version 2.1.7, for host i686-redhat-linux-gnu, built on Mar 31 2010
at 00:25:31
Copyright (C) 1999-2009 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License v2.
Starting - reading configuration files ...
including configuration file /etc/raddb/radiusd.conf
including configuration file /etc/raddb/proxy.conf
including configuration file /etc/raddb/clients.conf
including files in directory /etc/raddb/modules/
including configuration file /etc/raddb/modules/preprocess
including configuration file /etc/raddb/modules/otp
including configuration file /etc/raddb/modules/sqlcounter_expire_on_login
including configuration file /etc/raddb/modules/detail
including configuration file /etc/raddb/modules/policy
including configuration file /etc/raddb/modules/sradutmp
including configuration file /etc/raddb/modules/digest
including configuration file /etc/raddb/modules/counter
including configuration file /etc/raddb/modules/detail.log
including configuration file /etc/raddb/modules/wimax
including configuration file /etc/raddb/modules/perl
including configuration file /etc/raddb/modules/chap
including configuration file /etc/raddb/modules/pam
including configuration file /etc/raddb/modules/attr_filter
including configuration file /etc/raddb/modules/smsotp
including configuration file /etc/raddb/modules/checkval
including configuration file /etc/raddb/modules/smbpasswd
including configuration file /etc/raddb/modules/passwd
including configuration file /etc/raddb/modules/etc_group
including configuration file /etc/raddb/modules/expr
including configuration file /etc/raddb/modules/expiration
including configuration file /etc/raddb/modules/files
including configuration file /etc/raddb/modules/linelog
including configuration file /etc/raddb/modules/ippool
including configuration file /etc/raddb/modules/acct_unique
including configuration file /etc/raddb/modules/mac2vlan
including configuration file /etc/raddb/modules/sql_log
including configuration file /etc/raddb/modules/logintime
including configuration file /etc/raddb/modules/detail.example.com
including configuration file /etc/raddb/modules/mac2ip
including configuration file /etc/raddb/modules/echo
including configuration file /etc/raddb/modules/cui
including configuration file /etc/raddb/modules/always
including configuration file /etc/raddb/modules/pap
including configuration file /etc/raddb/modules/inner-eap
including configuration file /etc/raddb/modules/realm
including configuration file /etc/raddb/modules/radutmp
including configuration file /etc/raddb/modules/unix
including configuration file /etc/raddb/modules/exec
including configuration file /etc/raddb/modules/mschap
including configuration file /etc/raddb/modules/attr_rewrite
including configuration file /etc/raddb/eap.conf
including configuration file /etc/raddb/policy.conf
including files in directory /etc/raddb/sites-enabled/
including configuration file /etc/raddb/sites-enabled/control-socket
including configuration file /etc/raddb/sites-enabled/default
including configuration file /etc/raddb/sites-enabled/inner-tunnel
group = radiusd
user = radiusd
including dictionary file /etc/raddb/dictionary
main {
prefix = /usr
localstatedir = /var
logdir = /var/log/radius
libdir = /usr/lib/freeradius
radacctdir = /var/log/radius/radacct
hostname_lookups = no
max_request_time = 30
cleanup_delay = 5
max_requests = 1024
allow_core_dumps = no
pidfile = /var/run/radiusd/radiusd.pid
checkrad = /usr/sbin/checkrad
debug_level = 0
proxy_requests = yes
log {
stripped_names = no
auth = no
auth_badpass = no
auth_goodpass = no
}
security {
max_attributes = 200
reject_delay = 1
status_server = yes
}
}
radiusd: Loading Realms and Home Servers
proxy server {
retry_delay = 5
retry_count = 3
default_fallback = no
dead_time = 120
wake_all_if_all_dead = no
}
home_server localhost {
ipaddr = 127.0.0.1
port = 1812
type = auth
secret = testing123
response_window = 20
max_outstanding = 65536
require_message_authenticator = no
zombie_period = 40
status_check = status-server
ping_interval = 30
check_interval = 30
num_answers_to_alive = 3
num_pings_to_alive = 3
revive_interval = 120
status_check_timeout = 4
irt = 2
mrt = 16
mrc = 5
mrd = 30
}
home_server_pool my_auth_failover {
type = fail-over
home_server = localhost
}
realm example.com {
