Dear Ulrich,
Now the error had gone in "Check Server" option in dialup_admin web tool
But I have still some problem in connecting my sql server. I'm still unable
to connect to my "mysql" database server.
Here is my admin.conf
general_prefered_lang: el
general_prefered_lang_name: Greek
general_charset: iso-8859-1
general_tmp_dir: /var/www/html/dialup_admin/tmp
general_base_dir: /var/www/html/dialup_admin
general_radiusd_base_dir: /usr/local/radiusd
general_domain: coollink.us
general_use_session: no
general_most_recent_fl: 30
general_realm_delimiter: @
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
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_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
general_test_account_login: xxxx
general_test_account_password: xxxx
general_radius_server: <my radius ip adrres>
general_radius_server_port: <my radius server port>
general_radius_server_auth_proto: chap
general_radius_server_secret: <my password for client in radius server>
general_auth_request_file: %{general_base_dir}/conf/auth.request
general_encryption_method: crypt
general_accounting_info_order: desc
general_stats_use_totacct: no
sql_type: mysql
sql_server: <mysql server ip
sql_port: 3306
sql_username: xxxx
sql_password: xxxx
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_use_user_info_table: true
sql_use_operators: true
sql_password_attribute: User-Password
sql_date_format: Y-m-d
sql_full_date_format: Y-m-d H:i:s
sql_row_limit: 40
sql_connect_timeout: 3
counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none
TIA! and more power!
Bernie
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
