I am using ubuntu 7.04 ... btw link sent by Ivan really worked ..... thanks to all. Regards,
Saeed Akhtar On Thu, Nov 20, 2008 at 5:58 PM, Saif Aadil <[EMAIL PROTECTED]> wrote: > try 'yum install freeradius-mysql' > > ------------------------------ > Date: Thu, 20 Nov 2008 13:15:42 +0500 > From: [EMAIL PROTECTED] > To: [email protected] > Subject: Problem in setting up radius database in sql > > Hi all, > I want to setup radius database in mysql.... I browse through wiki and > found an artical "SQL How to" http://wiki.freeradius.org/SQL_HOWTO .... I > went through step by step and when in the last i tried to run radiusd ... I > ended up with following error: > > Module: Linked to module rlm_sql > Module: Instantiating sql > sql { > driver = "rlm_sql_mysql" > server = "localhost" > port = "" > login = "root" > password = "123" > radius_db = "radius" > read_groups = yes > sqltrace = yes > sqltracefile = "/usr/local/var/log/radius/sqltrace.sql" > readclients = no > deletestalesessions = yes > num_sql_socks = 5 > sql_user_name = "%{User-Name}" > default_user_profile = "" > nas_query = "SELECT id,nasname,shortname,type,secret FROM nas" > authorize_check_query = "SELECT id, UserName, Attribute, Value, op FROM > radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" > authorize_reply_query = "SELECT id, UserName, Attribute, Value, op FROM > radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" > authorize_group_check_query = "SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op > FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' > AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY > radgroupcheck.id" > authorize_group_reply_query = "SELECT > radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op > FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' > AND usergroup.GroupName = radgroupreply.GroupName ORDER BY > radgroupreply.id" > accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', > AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), > AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = > '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND > NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'" > accounting_update_query = "UPDATE radacct SET FramedIPAddress = > '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', > AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = > '%{Acct-Output-Octets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND > UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'" > accounting_update_query_alt = "INSERT into radacct (AcctSessionId, > AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, > AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, > AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, > ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay) > values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', > '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', > '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + > %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', > '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', > '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', > '%{Framed-IP-Address}', '0')" > accounting_start_query = "INSERT into radacct (AcctSessionId, > AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, > AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, > ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, > CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, > FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) > values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', > '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', > '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', > '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', > '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', > '%{Acct-Delay-Time}', '0')" > accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', > AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' > WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' > AND NASIPAddress = '%{NAS-IP-Address}'" > accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', > AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = > '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', > AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = > '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE > AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND > NASIPAddress = '%{NAS-IP-Address}'" > accounting_stop_query_alt = "INSERT into radacct (AcctSessionId, > AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, > AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, > ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, > CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, > FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) > values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', > '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', > '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + > %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', > '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', > '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', > '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', > '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')" > group_membership_query = "SELECT GroupName FROM usergroup WHERE > UserName='%{SQL-User-Name}'" > connect_failure_retry_delay = 60 > simul_count_query = "" > simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, > NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol > FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" > postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) > values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', > '%{reply:Packet-Type}', NOW())" > safe-characters = > "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" > } > rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: > cannot open shared object file: No such file or directory > rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the > search path of your system's ld. > /usr/local/etc/raddb/sql.conf[14]: Instantiation failed for module "sql" > /usr/local/etc/raddb/radiusd.conf[1847]: Failed to find module "sql". > /usr/local/etc/raddb/radiusd.conf[1776]: Errors parsing authorize section. > } > } > Errors initializing modules > > If somebody could help me i'll be very thankful. > > Regards, > > > Saeed Akhtar > > > ------------------------------ > Get news, entertainment and everything you care about at Live.com. Check > it out! <http://www.live.com/getstarted.aspx> > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
