Problem in setting up radius database in sql

Thu Nov 20 14:11:52 CET 2008

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 <aa_ytm at hotmail.com> wrote:

>  try 'yum install freeradius-mysql'
>
> ------------------------------
> Date: Thu, 20 Nov 2008 13:15:42 +0500
> From: saeedakhtar.484 at gmail.com
> To: freeradius-users at lists.freeradius.org
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081120/78037f8b/attachment.html>