Hi Bernie,
how about a little more debug information?
F.e. enable sql_debug in admin.conf...
I don't know that much on MySQL but on PostgreSQL you have to edit a
file called "pg_hba.conf" which controlls which user is allowed to
connect to a specific database from a specific host...
Cheers,
Uli
Am Don, 2003-09-18 um 18.07 schrieb Bernie Liwanag:
> 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
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
