dialup_admin problem

classic Classic list List threaded Threaded
2 messages Options
| Threaded
Open this post in threaded view
|

dialup_admin problem

Okka Radius

I am using Freeradius version 1.04 that comes with its own version of
dialup_admin.
I've successfully got Freeradius to authenticate using MYSQL as a backend.

My problem is in getting dialup_admin to read the database when I access my
radius server on the web.
My admin.conf for dialup_admin is below

#
# 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/dialup_admin
#
# The base directory of the freeradius radius installation
#
#general_radiusd_base_dir: /usr/local/radiusd
general_radiusd_base_dir: /usr/local/etc/raddb
#general_domain: company.com
general_domain: domain.name.ext
#
# 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
#general_use_session: yes
#
# 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
general_strip_realms: no
#
# 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 see and change the user
password through
# the user edit page
general_show_user_password: yes

general_raddb_dir: %{general_radiusd_base_dir}/etc/raddb
general_ldap_attrmap: %{general_raddb_dir}/ldap.attrmap

# Need to fix admin.conf file parser
#general_clients_conf: %{general_raddb_dir}/clients.conf
general_clients_conf: /usr/local/etc/raddb/clients.conf
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
#
# Defines the nas type. This is only used by snmpfinger
# cisco and lucent are supported for now
#
#general_nas_type: cisco
general_nas_type: other
#general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_snmpfinger_bin: /usr/local/dialup_admin/bin/snmpfinger
#general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
general_radclient_bin: /usr/local/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
#general_test_account_login: john
#general_test_account_login: building
general_test_account_password: testing123
#general_test_account_password: john101
#general_test_account_password: building101
#
# These are used as default values for the user test page
#
#general_radius_server: localhost
general_radius_server: fully.qualified.domain.name.of.server
general_radius_server_port: 1812
#
# can be either pap or chap
#
#general_radius_server_auth_proto: pap
general_radius_server_auth_proto: chap
#
# sorry, single valued for now. Should become something like
# password[server-name]: xxxxx
#
general_radius_server_secret: secret
#general_auth_request_file: %{general_base_dir}/conf/auth.request
general_auth_reguest_file: /usr/local/dialup_admin/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)
# 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: no
#general_stats_use_totacct: yes
#
# If set to yes then we only allow each administrator to examine it's own
entries
# in the badusers table
#
general_restrict_badusers_access: no

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
# %mu: mappings for userdb
# %ma: mappings for accounting
#
# 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)
#
# If ldap_userdn is set then we use that for user dns, we don't perform an
ldap
# search. This can be somewhat faster. The variables supported for
ldap_filter
# are also supported here
#
#ldap_userdn: uid=%u,%{ldap_base}


#
# can be one of mysql,pg where:
# mysq: MySQL database (port 3306)
# pg: PostgreSQL database (port 5432)
#
sql_type: mysql
#sql_type: mysq
sql_server: fully.qualified.domain.name.of.server
sql_port: 3306
sql_username: name
sql_password: password
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
sql_nas_table: nas
#
# This variable is used by the scripts in the bin folder
# It should contain the path to the sql binary used to run
# sql commands (mysql and psql are only supported for now)
sql_command: /usr/local/bin/mysql

#
# This variable is used by the scripts in the bin folder
# It should contain the snmp type and  path to the binary
# used to run snmp commands.
# (ucd = UCD-Snmp and net = Net-Snmp are only supported for now)
general_snmp_type: net
general_snmpwalk_command: /usr/bin/snmpwalk
general_snmpget_command: /usr/bin/snmpget
#
# 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
#
# If set the query will be added to all of the queries on the accounting
# table
#sql_accounting_extra_query: %ma


#
# 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: 14400
counter_default_weekly: 72000
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

I am using Apache version 2.0.54 along with PHP-4.3.11
My apache httpd.conf section for dialup_admin is below

<Directory /usr/local/apache2/htdocs/dialup>
AuthName "Radius Auth"
AuthType Basic
AuthUserFile /usr/local/dialup_admin/.htpasswd
require valid-user
</Directory>

When I connect to http://fully.qualified.domain.name.of.server/dialup and
enter in the username and password , I get all the usual html pages BUT the
moment I click on the check server link then the check fails the userid and
pass specified in admin.conf and when I select anything else eg accounting ,
then it displays a simple message stating that it cannot connecting to the
sql databse ( spelt like that ) and selecting any other link says that it
cannot connect to the SQL database.

These users defined in the admin.conf for test purposes are valid users in
the correct mysql tables and they do authenticate successfully , I'm using
MySQL Control Centre 0.94 Beta for Windows to add the users since I can't do
it with the web interface since it does'nt want to work.

Can any assist me , it would be much appreciated.

Many thanks in advance.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
| Threaded
Open this post in threaded view
|

RE: dialup_admin problem

rashad
You must point to actual IP address (or FQDN) of machine where mysql server
running.
To do this edit this line in admin.conf:

sql_server: fully.qualified.domain.name.of.server

If your web server running in the same machine where mysql server is
running:
sql_server: 127.0.0.1

>I am using Freeradius version 1.04 that comes with its own version of
>dialup_admin.
>I've successfully got Freeradius to authenticate using MYSQL as a backend.
>
>My problem is in getting dialup_admin to read the database when I access my
>radius server on the web.
>
>
>#
># can be one of mysql,pg where:
># mysq: MySQL database (port 3306)
># pg: PostgreSQL database (port 5432)
>#
>sql_type: mysql
>#sql_type: mysq
>sql_server: fully.qualified.domain.name.of.server
>sql_port: 3306


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html