On Wed, 22 Oct 2003, apellido jr., wilfredo p wrote: > Good day Mr. Kalevras. statistics, user's statistics > and online users doesnt show anything in latest > dialup_admin cvsup. here's my config
Doesn't show anything meaning a blank page or no accounting data? Make sure that you are using the new conf/accounting.attrs file > > > ------------------------------------------------- > admin.conf > ------------------------------------------------- > > # > # 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: en > general_prefered_lang_name: English > # > # The charset which will be added as a meta tag in all > pages > # > general_charset: iso-8859-1 > # > # Uncomment this if normal attributes (not the > ;lang-xx ones) in ldap > # are utf8 encoded. > # > #general_decode_normal_attributes: yes > # > # The directory where dialupadmin is installed > # > general_base_dir: /usr/local/www/data/dialup_admin > # > # The base directory of the freeradius radius > installation > # > general_radiusd_base_dir: /usr/local/freeradius-0.9.2 > general_domain: mactan.ph > # > # 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 > # > > # > # Determines if the administrator will be able to > change the user password through > # the user edit page > general_show_user_password: yes > > > #general_ldap_attrmap: > %{general_radiusd_base_dir}/etc/raddb/ldap.attrmap > general_sql_attrmap: > %{general_base_dir}/conf/sql.attrmap > general_accounting_attrs_file: > %{general_base_dir}/conf/accounting.attrs > #general_extra_ldap_attrmap: > %{general_base_dir}/conf/extra.ldap-attrmap > # > # it can be either ldap or sql > # This affects the user base not accounting. > Accounting is always in sql > # > general_lib_type: sql > # > # Define which attributes will be visible in the user > edit page > # > general_user_edit_attrs_file: > %{general_base_dir}/conf/user_edit.attrs > # > # Used by the Accounting Report Generator > # > general_sql_attrs_file: > %{general_base_dir}/conf/sql.attrs > # > # Set default values for various attributes > # > 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 > # This is used by the online users page > # > 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: cache > general_test_account_password: cache > # > # These are used as default values for the user test > page > # > general_radius_server: localhost > general_radius_server_port: 1645 > # > # can be either pap or chap > # > general_radius_server_auth_proto: pap > # > # sorry, single valued for now. Should become > something like > # password[server-name]: xxxxx > # > general_radius_server_secret: cyclades > general_auth_request_file: > %{general_base_dir}/conf/auth.request > # > # can be one of crypt,md5,clear > # > general_encryption_method: clear > # > # can be either asc (older dates first) or desc > (recent dates first) > # This is used in the user accounting and badusers > pages > # > general_accounting_info_order: desc > # > # Use the totacct table in the user statistics page > instead of the radacct > # table. That will make the page run quicker. totacct > should have data for > # this to work :-) > # > general_stats_use_totacct: yes > > INCLUDE: %{general_base_dir}/conf/naslist.conf > > INCLUDE: %{general_base_dir}/conf/captions.conf > > # > # 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 > # > # Uncomment to enable ldap debug > # > #ldap_debug: true > # > # Allow for defining the ldap filter used when > searching for a user > # Variables supported: > # %u: username > # %U: username provided though http authentication > # > # One use of this would be to restrict access to only > the user's belonging to > # a specific administrator like this: > # ldap_filter: > (&(uid=%u)(manager=uid=%U,ou=admins,o=company,c=com)) > # > #ldap_filter: (uid=%u) > > > # > # 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: radius > sql_password: mysql% > 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 > sql_total_accounting_table: totacct > # > # Uncomment to enable sql debug > # > sql_debug: true > # > # If set to yes then the HTTP credentials (http > authentication) > # will be used to connect to the sql server instead of > sql_username > # and sql_password. That way multiple admins with > different rights > # on the sql database can connect through one > dialup_admin interface. > #sql_use_http_credentials: yes > > > # > # 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: Y-m-d > sql_full_date_format: Y-m-d H:i:s > # > # Used in the accounting report generator so that we > # don't return too many results > # > sql_row_limit: 40 > # > # These options are used by the log_badlogins script > and by the > # mysql driver > # > # Set the sql connect timeout (secs) > sql_connect_timeout: 3 > # Give a space separated list of extra mysql servers > to connect to when > # logging bad logins or adding users in the badusers > table > #sql_extra_servers: sql2.company.com sql3.company.com > > # > # Default values for the various user limits in case > the counter module > # is used to impose such limits. > # The value should be the user limit in seconds or > none for nothing > # > counter_default_daily: none > counter_default_weekly: none > counter_default_monthly: none > # > # Since calculating monthly usage can be quite > expensive we make > # it configurable > # This is not needed if the monthly limit is not none > counter_monthly_calculate_usage: true > > ------------------------------------------ > naslist.conf > ------------------------------------------ > > # > # This file contains the NAS list > # > nas1_name: cyclades.%{general_domain} > nas1_model: cyclades access server > nas1_ip: 203.177.29.224 > nas1_port_num: 16 > nas1_community: public > #nas2_name: nas2.%{general_domain} > #nas2_model: Cisco 2511 access server > #nas2_ip: 147.122.122.123 > #nas2_port_num: 16 > #nas2_community: public > # > # finger type can also be set per NAS > # snmp: Use snmp to query the NAS > # database: Only query the sql database > # > # If it is not set, general_finger_type is assumed > #nas2_finger_type: database > #nas3_name: nas3.%{general_domain} > #nas3_model: Cisco 5300 access server > #nas3_ip: 147.122.122.124 > #nas3_port_num: 210 > #nas3_community: public > > > what im missing? thanks a lot .... > > > ===== > wilfredo pahilanga apellido jr. > technical support > mactan online > bacolod city, philippines > +63 34 4348311 > > If you can't hear me, it's because i'm in parentheses. > > __________________________________ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html