Kostas wrote
> > I have just started to use version 1.61 and I have the following
questions.
> >
> > When I select "Statistics" (and select "sessions", "uploads" and
"downloads",
> > the results are all zero, even though the radacct table has entries.
>
> Do you press the Refresh button and you still don't get results?
Yes, refresh does nothing
> >
> > When I select a user, how do I change the "allowed session" time? My
users
> > are volume based not time based.
>
> You can change the Session Timeout from the EDIT page if I understand you
> correctly.
>
Edit only allows the following to be changes
Protocol, Ip Address, Ip netmask, MTU, Compression used, Session timeout,
Idle timeout, Port limit, Lock message
The session timeout only affects the per-session timeout. No daily or
weekly limits can be set from here.
> >
> > Also the account status is all zeros.
>
> The Account Status is only for the last 7 days. Do you have sessions for
that
> user for the last 7 days?
>
The Accounting report generator gave the following
Client IP Address Download Login Time Logout Time NAS IP Address NAS Port
Session Time Upload User Name
- 2.10 MBs 2003-01-06 10:40:29 2003-01-06 10:57:35 192.168.1.1 0 0
seconds 146.48 KBs fred
- 0.62 MBs 2003-01-07 12:13:20 2003-01-07 12:14:55 192.168.1.100 0 0
seconds 120.56 KBs fred
When I edit user fred, I get the following in the "Account status for the
last 7 days" section
Connections 0
Online time 0 seconds
Failed Logins 0
Upload 0.00 KBs
Download 0.00 KBs
Average Time 0 seconds
Average Upload 0.00 KBs
Average Download 0.00 KBs
> > Mike Paneth
> > Melbourne Australia
> >
>
> --
> Kostas Kalevras Network Operations Center
> [EMAIL PROTECTED] National Technical University of Athens, Greece
> Work Phone: +30 210 7721861
> 'Go back to the shadow' Gandalf
The config file is as follows
#
# Main Configuration File
#
# it can be default or whatever language. Only greek are supported
# from non latin alphabet languages
# These attribute only apply for ldap not for sql
#
general_prefered_lang: el
general_prefered_lang_name: Greek
#
# Uncomment this if normal attributes (not the ;lang-xx ones) in ldap
# are utf8 encoded.
#
#general_decode_normal_attributes: yes
#
#general_base_dir: /usr/local/dialup_admin
#general_radiusd_base_dir: /usr/local/radiusd
#general_domain: company.com
general_base_dir: /data/dialup_admin
general_radiusd_base_dir: /usr/local
general_domain: marinett.com
#
# Set it to yes to use sessions and cache the various mappings
# You can also set use_session = 1 in config.php3 to also cache
# the admin.conf
#
# ---- IMPORTANT -- IMPORTANT -- IMPORTANT ----
#Remember to use the 'Clear Cache' page if you use sessions and do any
changes
#in any of the configuration files.
#
general_use_session: no
#
# This is used by the failed logins page. It states the default back time
# in minutes.
#
general_most_recent_fl: 30
#
# Realm setup
#
# Set general_strip_realms to yes in order to stip realms from usernames.
# By default realms are not striped
#general_strip_realms : yes
#
# The delimiter used in realms. Default is @
#
general_realm_delimiter: @
#
# The format of the realms. Can be either suffix (realm is after the
username)
# or prefix (realm is before the username). Default is suffix
#
general_realm_format: suffix
#
general_ldap_attrmap: %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap
general_sql_attrmap: %{general_base_dir}/conf/sql.attrmap
general_extra_ldap_attrmap: %{general_base_dir}/conf/extra.ldap-attrmap
#
# it can be either ldap or sql
#
general_lib_type: sql
general_user_edit_attrs_file: %{general_base_dir}/conf/user_edit.attrs
general_sql_attrs_file: %{general_base_dir}/conf/sql.attrs
general_default_file: %{general_base_dir}/conf/default.vals
#general_ld_library_path: /usr/local/snmpd/lib
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table without
first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: testing123
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1812
#
# sorry, single valued for now. Should become something like
# password[server-name]: xxxxx
#
general_radius_server_secret: XXXXXX
general_auth_request_file: %{general_base_dir}/conf/auth.request
#
# can be one of crypt,md5,clear#
#general_encryption_method: crypt
general_encryption_method: clear
#
# can be either asc (older dates first) or desc (recent dates first)
#
general_accounting_info_order: desc
nas1_name: Firewall.%{general_domain}
nas1_model: Mikes firewall (192.168.1.1)
nas1_ip: 192.168.1.1
nas1_port_num: 100
nas1_community: public
nas2_name: M.%{general_domain}
nas2_model: M Wireless system (192.168.1.100)
nas2_ip: 192.168.1.100
nas2_port_num: 100
nas2_community: public
nas3_name: AZ RADIUS.%{general_domain}
nas3_model: AZ RADIUS server
nas3_ip: 192.168.1.200
nas3_port_num: 100
nas3_community: public
#
# The ldap server to connect to.
# Both ldap_server and ldap_write_server can be a space-separated
# list of ldap hostnames. In that case the library will try to connect
# to the servers in the order that they appear. If the first host is down
# ldap_connect will ask for the second ldap host and so on.
#
ldap_server: ldap.%{general_domain}
#
# There are many cases where we have a small write master and
# a lot of fast read only replicas. If that is the case uncomment
# ldap_write_server and point it to the write master. It will be
# used only when writing to the directory, not when reading
#
#ldap_write_server: master.%{general_domain}
ldap_base: dc=company,dc=com
ldap_binddn: cn=Directory Manager
ldap_bindpw: XXXXXXX
ldap_default_new_entry_suffix: ou=dialup,ou=guests,%{ldap_base}
ldap_default_dn: uid=default-dialup,%{ldap_base}
ldap_regular_profile_attr: dialupregularprofile
#
# If set to yes then the HTTP credentials (http authentication)
# will be used to bind to the ldap server instead of ldap_binddn
# and ldap_bindpw. That way multiple admins with different rights
# on the ldap database can connect through one dialup_admin interface.
# The ldap_binddn and ldap_bindpw are still needed to find the DN
# to bind with (http authentication will only provide us with a
# username). As a result the ldap_binddn should be able to do a search
# with a filter of (uid=<username>). Normally, the anonymous (empty DN)
# user can do that.
#ldap_use_http_credentials: yes
#
# If we are using http credentials we can map a specific username to the
# directory manager (which usually does not correspond to a specific
username)
#
#ldap_directory_manager: cn=Directory Manager
#ldap_map_to_directory_manager: admin
#
# can be one of mysql,pg where:
# mysq: MySQL database (port 3306)
# pg: PostgreSQL database (port 5432)
#
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: mysql
sql_password: asdfg
sql_database: radius
sql_accounting_table: radacct
sql_badusers_table: badusers
sql_check_table: radcheck
sql_reply_table: radreply
sql_user_info_table: userinfo
sql_groupcheck_table: radgroupcheck
sql_groupreply_table: radgroupreply
sql_usergroup_table: usergroup
#
# true or false
#
sql_use_user_info_table: true
sql_use_operators: true
#
# Set this to the value of the default_user_profile in your
# sql.conf if that one is set. If it is not set leave blank
# or commented out
#sql_default_user_profile: DEFAULT
#
#
sql_password_attribute: User-Password
sql_date_format: d-m-Y
sql_full_date_format: d-m-Y H:i:s
#
# Used in the accounting report generator so that we
# don't return too many results
#
sql_row_limit: 40
counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html