OK - I think I figured out my problem, although not sure exactly which
correction I did fixed it. However, I am still getting the MySQL Debug
output and was wondering how to get rid of it:
DEBUG(SQL,MYSQL DRIVER): Query: SELECT groupname FROM usergroup WHERE
username = 'srmiller';
DEBUG(SQL,MYSQL DRIVER): Query Result:
Thanks,
Scott Miller
----- Original Message -----
From: "Scott Miller" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list" <[email protected]>
Sent: Monday, February 06, 2006 10:45 AM
Subject: Re: dialup-admin problem
Thanks for all the help. I verified that "error_reporting" is set to
E_ALL, and have changed "display_errors" to On.
Now, when I go to dialup-admin I get the first page fine, but when I click
a link, here's the errors it displays:
(above link window)
Notice: Undefined variable: HTTP_SERVER_VARS in
/usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 22
-----------------
(inside link window - above links)
Notice: import_request_variables() [function.import-request-variables]: No
prefix specified - possible security hazard in
/usr/local/dialup-admin/conf/config.php3 on line 8
Notice: Use of undefined constant general_use_session - assumed
'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line
61
Notice: Undefined variable: login in
/usr/local/dialup-admin/conf/config.php3 on line 66
Notice: Undefined variable: login in
/usr/local/dialup-admin/conf/config.php3 on line 69
Notice: Use of undefined constant general_username_mappings_file - assumed
'general_username_mappings_file' in
/usr/local/dialup-admin/conf/config.php3 on line 76
Notice: Undefined index: general_username_mappings_file in
/usr/local/dialup-admin/conf/config.php3 on line 76
Notice: Use of undefined constant general_use_session - assumed
'general_use_session' in
/usr/local/dialup-admin/html/buttons/default/buttons.html.php3 on line 91
-----------------
(Right side when I click on "Find User" (all others have alot more
"notice" statements:)
Notice: import_request_variables() [function.import-request-variables]: No
prefix specified - possible security hazard in
/usr/local/dialup-admin/conf/config.php3 on line 8
Notice: Use of undefined constant general_use_session - assumed
'general_use_session' in /usr/local/dialup-admin/conf/config.php3 on line
61
Notice: Undefined variable: login in
/usr/local/dialup-admin/conf/config.php3 on line 66
Notice: Undefined variable: login in
/usr/local/dialup-admin/conf/config.php3 on line 69
Notice: Use of undefined constant general_username_mappings_file - assumed
'general_username_mappings_file' in
/usr/local/dialup-admin/conf/config.php3 on line 76
Notice: Undefined index: general_username_mappings_file in
/usr/local/dialup-admin/conf/config.php3 on line 76
Notice: Undefined variable: search_IN in
/usr/local/dialup-admin/htdocs/find.php3 on line 3
Notice: Undefined variable: radius_attr in
/usr/local/dialup-admin/htdocs/find.php3 on line 4
Notice: Undefined variable: max_results in
/usr/local/dialup-admin/htdocs/find.php3 on line 5
I was getting permissions errors, but then changed group ownership to
"apache" and set the entire directory to "755"
Any help with these errors would be appriciated.
Thanks,
Scott Miller
----- Original Message -----
From: "Rich Marriner" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
<[email protected]>
Sent: Tuesday, January 24, 2006 10:05 AM
Subject: Re: dialup-admin problem
FreeBSD 6.0
Apache 2.2.0
PHP 5.1.1
FreeRadius 1.0.5
Dialup_admin works fine for me. It does appear to be a PHP problem.
Look at your apache logs and see what errors you are getting if any. You
might want to check the "error_reporting" setting in your php.ini, make
sure it is set to E_ALL so you can see what errors are occuring. If this
is not a production box you might even want to change "display_errors" to
On.
This should give you a couple more "hints" on where to go next.
Rich
Scott Miller wrote:
I've found that my problem might be with Apache 2 and PHP 5 - does
anyone else have dialup-admin running properly on Apache 2 and PHP 5?
I'd hate to think I'd have to downgrade.
Thanks,
Scott
----- Original Message ----- From: "Scott Miller"
<[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
<[email protected]>
Sent: Monday, January 23, 2006 1:03 PM
Subject: dialup-admin problem
I've installed freeradius 1.1.0, went through all the tests and
everything (the tests) seems to be working fine there. My platform is:
Fedora Core 4
Sendmail 8.13.4
Apache 2.0.54
MySQL 4.1.16
PHP 5.0.5-2.1
Freeradius 1.1.0
I've also followed the instructions for the dialup-admin, and have run
into a problem. When I view servername.com/dialup-admin, I can see the
first page just fine, but when I click on any link on the left, the
right side just turns white - nothing displays. The "home" link brings
me back to the "A web based administration interface for the freeradius
radius server " page, but no other links seem to bring anyting up.
Here's what I did:
1. Copied the directory dialup-admin to the /user/local/ directory
2. In /var/www/html I created a simlink
/user/local/dialup-admin/htdocs named dialup-admin
ln -s /usr/local/dialup-admin/htdocs /var/www/html/dialup-admin
3. Edited httpd.conf to the following
# Scott Added for freeradius dialup-admin
#LoadModule php4_module libexec/libphp4.so
#AddModule mod_php4.c
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
I had to comment out the fist two lines, because httpd kept failing and
producing the error: Apache 1.3 configuration directives found please
read /usr/share/doc/httpd-2.0.54/migration.html
4. I did not do: [1.3.2.2] Creating a more secure web interface. -
wanting to make it work first, then will start securing it.
5. Created the 4 additional MySQL Databases according to the
instructions and all look fine.
6. I then went through the general configuraiton options. I commented
out all LDAP options, and fixed the following:
<Start admin.conf>
general_prefered_lang: en
general_prefered_lang_name: English
general_charset: iso-8859-1
#general_decode_normal_attributes: yes
general_base_dir: /usr/local/dialup-admin
general_radiusd_base_dir: /usr/local/radiusd
general_use_session: no
general_most_recent_fl: 30
#general_strip_realms : yes
general_realm_delimiter: @
general_realm_format: suffix
general_show_user_password: yes
general_raddb_dir: %{general_radiusd_base_dir}/etc/raddb
general_ldap_attrmap: %{general_raddb_dir}/ldap.attrmap
#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
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
general_finger_type: snmp
general_nas_type: cisco
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
general_test_account_login: test
general_test_account_password: testpass
general_radius_server: localhost
general_radius_server_port: 1812
general_radius_server_auth_proto: pap
general_radius_server_secret: commented-out
general_auth_request_file: %{general_base_dir}/conf/auth.request
general_encryption_method: crypt
general_accounting_info_order: desc
general_stats_use_totacct: no
general_restrict_badusers_access: no
INCLUDE: %{general_base_dir}/conf/naslist.conf
INCLUDE: %{general_base_dir}/conf/captions.conf
#ldap_server: ldap.%{general_domain}
#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
#ldap_use_http_credentials: yes
#ldap_directory_manager: cn=Directory Manager
#ldap_map_to_directory_manager: admin
#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
#ldap_filter: (uid=%u)
#ldap_userdn: uid=%u,%{ldap_base}
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: xxxxxxx
sql_password: xxxxxxx
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
sql_command: /usr/local/bin/mysql
general_snmp_type: net
general_snmpwalk_command: /usr/local/bin/snmpwalk
general_snmpget_command: /usr/local/bin/snmpget
sql_debug: true
#sql_use_http_credentials: yes
#sql_accounting_extra_query: %ma
sql_use_user_info_table: true
sql_use_operators: true
#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
sql_row_limit: 40
sql_connect_timeout: 3
#sql_extra_servers: sql2.company.com sql3.company.com
counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none
#counter_monthly_calculate_usage: true
<Stop admin.conf>
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
--
Richard Marriner II Maingear.Net
Sr. Network Consultant I.T. Consulting
[EMAIL PROTECTED] www.maingear.net
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
