Hi Francois,
It was missing. Adding the sql.conf include to the radiusd.conf file
fixed the problem. Thanks for you help tracking this down.
This was the original code in the radiusd.conf file:
modules {
$INCLUDE ${confdir}/modules/
$INCLUDE eap.conf
}
I modified it to:
modules {
$INCLUDE ${confdir}/modules/
$INCLUDE eap.conf
$INCLUDE sql.conf
}
Thank You,
Kerry Melcher
________________________________
From: Francois Gaudreault [mailto:[email protected]]
Sent: Tuesday, October 04, 2011 6:42 AM
To: [email protected]
Subject: Re: [Packetfence-users] Help with Radtest
Can you have a look in the radiusd.conf file, and look for :
$INCLUDE sql.conf
You should have it right under:
$INCLUDE eap.conf
On 11-10-03 5:33 PM, Melcher, Kerry wrote:
I checked the login and password, and manually logged into mysql
to make sure that it was working.
mysql -u pf -p
more sql.conf
sql {
database = "mysql"
driver = "rlm_sql_${database}"
server = "localhost"
port = 3306
login = "pf"
password = "changed"
radius_db = "pf"
acct_table1 = "radacct"
acct_table2 = "radacct"
postauth_table = "radpostauth"
authcheck_table = "radcheck"
authreply_table = "radreply"
groupcheck_table = "radgroupcheck"
groupreply_table = "radgroupreply"
usergroup_table = "radusergroup"
deletestalesessions = yes
sqltrace = no
sqltracefile = ${logdir}/sqltrace.sql
num_sql_socks = 5
connect_failure_retry_delay = 60
lifetime = 0
max_queries = 0
readclients = yes
nas_table = "radius_nas"
$INCLUDE sql/${database}/packetfence.conf
}
Thank You,
Kerry Melcher
________________________________
From: Francois Gaudreault [mailto:[email protected]]
Sent: Monday, October 03, 2011 1:22 PM
To: [email protected]
Subject: Re: [Packetfence-users] Help with Radtest
Make sure you database password is properly set in sql.conf.
On 11-10-03 3:31 PM, Melcher, Kerry wrote:
Hi Francois,
That got it a little closer. It is getting this error
trying to load the sql module that is referenced in the accounting
section. I have a sql_log file in the modules folder but not a sql
file in the module folder. If I remark out the accounting section in
the packetfence server file, radius loads and radtest works.
} # server
server packetfence { # from file
/etc/raddb/sites-enabled/packetfence
modules {
Module: Checking authenticate {...} for more modules to
load
Module: Checking authorize {...} for more modules to
load
Module: Linked to module rlm_perl
Module: Instantiating module "perl" from file
/etc/raddb/modules/perl
perl {
module = "/etc/raddb/example.pl"
func_authorize = "authorize"
func_authenticate = "authenticate"
func_accounting = "accounting"
func_preacct = "preacct"
func_checksimul = "checksimul"
func_detach = "detach"
func_xlat = "xlat"
func_pre_proxy = "pre_proxy"
func_post_proxy = "post_proxy"
func_post_auth = "post_auth"
func_recv_coa = "recv_coa"
func_send_coa = "send_coa"
}
Module: Checking preacct {...} for more modules to load
Module: Checking accounting {...} for more modules to
load
/etc/raddb/sites-enabled/packetfence[32]: Failed to load
module "sql".
/etc/raddb/sites-enabled/packetfence[29]: Errors parsing
accounting section.
Thank You,
Kerry Melcher
________________________________
From: Francois Gaudreault
[mailto:[email protected]]
Sent: Monday, October 03, 2011 6:21 AM
To: [email protected]
Subject: Re: [Packetfence-users] Help with Radtest
Well....
server packetfence {
No such virtual server "packetfence"
cd /etc/raddb/sites-enabled
ln -s ../sites-available/packetfence
ln -s ../sites-available/packetfence-tunnel
Try that.
--
Francois Gaudreault, ing. jr
[email protected] :: +1.514.447.4918 (x130) ::
www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and
PacketFence (www.packetfence.org)
------------------------------------------------------------------------
------
All the data continuously generated in your IT
infrastructure contains a
definitive record of customers, application performance,
security
threats, fraudulent activity and more. Splunk takes this
data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Packetfence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Francois Gaudreault, ing. jr
[email protected] :: +1.514.447.4918 (x130) ::
www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and
PacketFence (www.packetfence.org)
------------------------------------------------------------------------
------
All the data continuously generated in your IT infrastructure
contains a
definitive record of customers, application performance,
security
threats, fraudulent activity and more. Splunk takes this data
and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Packetfence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Francois Gaudreault, ing. jr
[email protected] :: +1.514.447.4918 (x130) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Packetfence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
