dear all,
i using freeradius 0.8 and using sql server 7.0 for database and until now it
still work on my pc.
but now, i want install freeradius 0.8 in another pc.
but the problem is freeradius can't connect to database server.(sql server
7.0)
can you help me? because this is very urgent.
thank you very much for your help.
Tjenen
Note :
this is my freeradius log :
reread_config: reading radiusd.conf
Config: including file: /etc/raddb/proxy.conf
Config: including file: /etc/raddb/clients.conf
Config: including file: /etc/raddb/snmp.conf
Config: including file: /etc/raddb/mssql.conf
main: prefix = "/usr/local"
main: localstatedir = "/var"
main: logdir = "/var/log/radius"
main: libdir = "/usr/local/lib"
main: radacctdir = "/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 = "/var/log/radius/radius.log"
main: log_auth = no
main: log_auth_badpass = no
main: log_auth_goodpass = no
main: pidfile = "/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: servers_per_realm = 15
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
read_config_files: reading clients
read_config_files: reading realms
radiusd: entering modules setup
Module: Library search path is /usr/local/lib
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded System
unix: cache = no
unix: passwd = "/etc/passwd"
unix: shadow = "/etc/shadow"
unix: group = "/etc/group"
unix: radwtmp = "/var/log/radius/radwtmp"
unix: usegroup = no
unix: cache_reload = 600
Module: Instantiated unix (unix)
Module: Loaded preprocess
preprocess: huntgroups = "/etc/raddb/huntgroups"
preprocess: hints = "/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
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
Module: Instantiated realm (suffix)
Module: Loaded SQL
sql: driver = "rlm_sql_freetds"
sql: server = "192.168.100.33"
sql: port = ""
sql: login = "sa"
sql: password = ""
sql: radius_db = "SAKTI"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{User-Name}"
sql: default_user_profile = ""
sql: query_on_not_found = no
sql: authorize_check_query = "EXEC xRadCheck '%{SQL-User-Name}', '',
'%{Called-
Station-Id}', '%{Calling-Station-Id}'"
sql: authorize_reply_query = "EXEC xRadReply '%{SQL-User-Name}',
'%{Calling-Sta
tion-Id}'"
sql: authorize_group_check_query = ""
sql: authorize_group_reply_query = ""
sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S',
AcctSessio
nTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime),
AcctTerminateCause='
%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time} WHERE
AcctSessionTi
me=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND
AcctStartTime
<= '%S'"
sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress =
'%{Framed-
IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName =
'%{SQL-Us
er-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime = 0"
sql: accounting_start_query = "EXEC xCallRadPgs '%{SQL-User-Name}',
'%{Acct-Ses
sion-Id}', '%S', '%{Acct-Delay-Time}', '%{Connect-Info}', '%{SQL-User-Name}',
'%
{NAS-IP-Address}', '%{Acct-Unique-Session-Id}', '%{Realm}', '%{NAS-Port-Id}',
'%
{NAS-Port-Type}', '%{Acct-Authentic}', '%{Called-Station-Id}',
'%{Calling-Statio
n-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{h323
-call-type}', '%{h323-call-origqin}', '%{h323-remote-address}'"
sql: accounting_start_query_alt = "EXEC xCallRadPgs_alt '%{SQL-User-Name}',
'%{
Acct-Session-Id}', '%S', '%{Acct-Delay-Time}', '%{Connect-Info}',
'%{SQL-User-Na
me}', '%{NAS-IP-Address}', '%{Acct-Unique-Session-Id}', '%{h323-call-type}',
'%{
h323-call-origqin}'"
sql: accounting_stop_query = "EXEC xFinishN '%{SQL-User-Name}',
'%{Called-Stati
on-Id}', '%S', '%{Calling-Station-Id}', 'INDOKARD2', '%{Acct-Session-Time}',
'%{
Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Acct-Terminate-Cause}',
'%{Acct
-Delay-Time}', '%{Connect-Info}', '%{Acct-Session-Id}', '%{SQL-User-Name}',
'%{N
AS-IP-Address}', '%{Acct-Unique-Session-Id}', '%{h323-call-type}',
'%{h323-call-
origqin}', '%{h323-remote-address}'"
sql: accounting_stop_query_alt = ""
sql: group_membership_query = ""
sql: connect_failure_retry_delay = 60
sql: simul_count_query = ""
sql: simul_verify_query = ""
rlm_sql (sql): Driver rlm_sql_freetds (module rlm_sql_freetds) loaded and
linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/SAKTI
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_freetds #0
connect: Connection refused
rlm_sql_freetds: Can't connect to the database server
rlm_sql (sql): Failed to connect DB handle #1076900704
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
Module: Instantiated sql (sql)
Module: Loaded files
files: usersfile = "/etc/raddb/users"
files: acctusersfile = "/etc/raddb/acct_users"
files: preproxy_usersfile = "/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-Addre
ss, NAS-Port-Id"
Module: Instantiated acct_unique (acct_unique)
Module: Loaded detail
detail: detailfile =
"/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 = "/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
main: smux_password = ""
main: snmp_write_access = no
SMUX connect try 1
Can't connect to SNMP agent with SMUX: Connection refused
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
