Re: dialup_admin on different server
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:
> general_test_account_password:
> general_radius_server:
> general_radius_server_port:
> general_radius_server_auth_proto: chap
>
> general_radius_server_secret:
> 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: sql_port: 3306
> sql_username:
> sql_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_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
Re: dialup_admin on different server
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:
general_test_account_password:
general_radius_server:
general_radius_server_port:
general_radius_server_auth_proto: chap
general_radius_server_secret:
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: http://www.freeradius.org/list/users.html
Re: dialup_admin on different server
Am Don, 2003-09-18 um 13.01 schrieb Bernie Liwanag:
> Dear Evren,
>
> I have already changed the entry for sql_server:localhost to
> sql_server:my_server_ip addr but it still won't work.When I access the
> accounting options, it says "can't connect to sql server"
>
> Below is the result of my "Check Server" test.
>
> Warning: file("") - Permission denied in
> /var/www/html/dialup_admin/htdocs/user_test.php3 on line 99
You don't have the permissions to write to a directory (line 69 in
user_test.php3) which you have to specify in /conf/admin.conf.
Insert a line saying:
general_tmp_dir: /path/to/your/tmp_writeable
All following errors are because of your lack of rights to create the
tmp_file in line 69...
>
> Warning: Unlink failed (No such file or directory) in
> /var/www/html/dialup_admin/htdocs/user_test.php3 on line 100
>
> Warning: The argument needs to be an array in
> /var/www/html/dialup_admin/htdocs/user_test.php3 on line 115
>
> Warning: Invalid argument supplied for foreach() in
> /var/www/html/dialup_admin/htdocs/user_test.php3 on line 118
> Thursday, 18 September 2003, 11:53:52 WAT
> Server: server_ip_address :1812
> (test user testuser)
>
>
>
>
> > Message: 1
> > Date: Thu, 18 Sep 2003 11:30:23 -0700
> > From: Evren Yurtesen <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED]
> > Subject: Re: dialup_admin on different server
> > Reply-To: [EMAIL PROTECTED]
> >
> > see conf/admin.conf
> > change
> > sql_server: localhost
> > to your server address
> > also the user/pass information etc.
> >
> > Bernie Liwanag wrote:
> >
> > > Dear Kostas,
> > >
> > > Thanks for responding! Can you tell me how to configure the dialup_admin
> on
> > > a separate server that will lookup my other freeradius and mysql server.
> > >
> > > TIA!
> > >
> > > 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
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin on different server
do you have your php compiled with radius support? do you have radius
client libraries? something is missing obviously...
Bernie Liwanag wrote:
Dear Evren,
I have already changed the entry for sql_server:localhost to
sql_server:my_server_ip addr but it still won't work.When I access the
accounting options, it says "can't connect to sql server"
Below is the result of my "Check Server" test.
Warning: file("") - Permission denied in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 99
Warning: Unlink failed (No such file or directory) in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 100
Warning: The argument needs to be an array in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 115
Warning: Invalid argument supplied for foreach() in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 118
Thursday, 18 September 2003, 11:53:52 WAT
Server: server_ip_address :1812
(test user testuser)
Message: 1
Date: Thu, 18 Sep 2003 11:30:23 -0700
From: Evren Yurtesen <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: dialup_admin on different server
Reply-To: [EMAIL PROTECTED]
see conf/admin.conf
change
sql_server: localhost
to your server address
also the user/pass information etc.
Bernie Liwanag wrote:
Dear Kostas,
Thanks for responding! Can you tell me how to configure the dialup_admin
on
a separate server that will lookup my other freeradius and mysql server.
TIA!
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: dialup_admin on different server
Dear Evren,
I have already changed the entry for sql_server:localhost to
sql_server:my_server_ip addr but it still won't work.When I access the
accounting options, it says "can't connect to sql server"
Below is the result of my "Check Server" test.
Warning: file("") - Permission denied in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 99
Warning: Unlink failed (No such file or directory) in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 100
Warning: The argument needs to be an array in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 115
Warning: Invalid argument supplied for foreach() in
/var/www/html/dialup_admin/htdocs/user_test.php3 on line 118
Thursday, 18 September 2003, 11:53:52 WAT
Server: server_ip_address :1812
(test user testuser)
> Message: 1
> Date: Thu, 18 Sep 2003 11:30:23 -0700
> From: Evren Yurtesen <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: dialup_admin on different server
> Reply-To: [EMAIL PROTECTED]
>
> see conf/admin.conf
> change
> sql_server: localhost
> to your server address
> also the user/pass information etc.
>
> Bernie Liwanag wrote:
>
> > Dear Kostas,
> >
> > Thanks for responding! Can you tell me how to configure the dialup_admin
on
> > a separate server that will lookup my other freeradius and mysql server.
> >
> > TIA!
> >
> > 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
Re: dialup_admin on different server
see conf/admin.conf change sql_server: localhost to your server address also the user/pass information etc. Bernie Liwanag wrote: Dear Kostas, Thanks for responding! Can you tell me how to configure the dialup_admin on a separate server that will lookup my other freeradius and mysql server. TIA! 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
Re: dialup_admin on different server
On Tue, 16 Sep 2003, Bernie Liwanag wrote: > > Can I run dialup_admin tool on a different server?I want to separate it from my > radius and mysql server. Yes dialupadmin will only query the radius and mysql/ldap server so it does not need to run on the same machine. > > TIA! > > Bernie > -- 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
