Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-12-01 Thread Guy Fraser
I sent the tarball to Peter Nixon.

Since I changed all the filename extensions from .php3 to .php, a patch 
would be twice as
large, unless I did some trickery. I'll look into it.

Kostas Kalevras wrote:

On Fri, 28 Nov 2003, Guy Fraser wrote:

 

Hmm...

The updated version of dialup admin I sent in didn't seem to show
up on the list.
The attachment was 70kB, I presume thats why.

Where should I send this updated source, so it can be tested, and
put into the main source?
   

I 'd rather prefer a patch to the current CVS version rather than the whole
thing. Either put it on a web page somewhere, or send it to me directly. Though
i don't use postgresql
 

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.


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

--
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

 

--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.




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


Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-12-01 Thread Peter Nixon
http://www.peternixon.net/tmp/dialupadmin-pg-netsnmp.tar.bz

I have not yet had time to look at it. 

Cheers

Peter

On Monday 01 December 2003 18:00, Guy Fraser wrote:
 I sent the tarball to Peter Nixon.

 Since I changed all the filename extensions from .php3 to .php, a patch
 would be twice as
 large, unless I did some trickery. I'll look into it.

 Kostas Kalevras wrote:
 On Fri, 28 Nov 2003, Guy Fraser wrote:
 Hmm...
 
 The updated version of dialup admin I sent in didn't seem to show
 up on the list.
 
 The attachment was 70kB, I presume thats why.
 
 Where should I send this updated source, so it can be tested, and
 put into the main source?
 
 I 'd rather prefer a patch to the current CVS version rather than the
  whole thing. Either put it on a web page somewhere, or send it to me
  directly. Though i don't use postgresql
 
 --
 Guy Fraser
 Network Administrator
 The Internet Centre
 780-450-6787 , 1-888-450-6787
 
 There is a fine line between genius and lunacy, fear not, walk the
 line with pride. Not all things will end up as you wanted, but you
 will certainly discover things the meek and timid will miss out on.
 
 
 
 
 -
 List info/subscribe/unsubscribe? See
  http://www.freeradius.org/list/users.html
 
 --
 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

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc

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


Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-11-29 Thread Peter Nixon
Guy Fraser wrote:

Hmm...

The updated version of dialup admin I sent in didn't seem to show
up on the list.
The attachment was 70kB, I presume thats why.

Where should I send this updated source, so it can be tested, and
put into the main source?
Mail it to me directly..

Peter

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


Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-11-29 Thread Kostas Kalevras
On Fri, 28 Nov 2003, Guy Fraser wrote:

 Hmm...

 The updated version of dialup admin I sent in didn't seem to show
 up on the list.

 The attachment was 70kB, I presume thats why.

 Where should I send this updated source, so it can be tested, and
 put into the main source?

I 'd rather prefer a patch to the current CVS version rather than the whole
thing. Either put it on a web page somewhere, or send it to me directly. Though
i don't use postgresql


 --
 Guy Fraser
 Network Administrator
 The Internet Centre
 780-450-6787 , 1-888-450-6787

 There is a fine line between genius and lunacy, fear not, walk the
 line with pride. Not all things will end up as you wanted, but you
 will certainly discover things the meek and timid will miss out on.




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


--
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


Re: dialup-admin / new help-pages

2003-11-01 Thread Kostas Kalevras
On Thu, 30 Oct 2003, Ulrich Walcher wrote:

 HI,

 I have done some additions to user_edit.attrs and some help pages...

 They're all on http://www.walcher.co.at/fr/

Added, thanks a lot


 Greets,
 Uli


--
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


Re: Dialup Admin

2003-10-29 Thread Ulrich Walcher
Am Die, 2003-10-28 um 17.59 schrieb Bruno Gianelli Braido:
 Hello all,
  
 I'd like to use the Dialup_Admin, I tried use the example from 
 http://kstadler.ch/index.php?topgroupid=1subgroupid=14groupid=11
 but not success.
 Who knows where I get a good example???
 My equipament is a PM3, Freeradius with Auth Mysql.
 
 Thanks for your help.
[...]
Do you have FR with MySQL working?
No success is not very precise. Give us a little more details and
maybe someone con help you.

Uli


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


Re: Dialup Admin

2003-10-29 Thread Ulrich Walcher
Am Mit, 2003-10-29 um 12.57 schrieb Bruno Gianelli Braido:
 Thanks for your help Uli,
 
 So my FR is working with Mysql, my problem is configure the Dialup
 Admin, I used the help come with DialupAdmin but not work.
 Where I get a example to configure the Dialup Admin

[...]
Most important is to have php working properly.
apache with php4:
http://www.php.net/manual/en/install.apache.php

All attributes are well explained in conf/admin.conf

There you might have to change:
general_base_dir: /usr/local/dialup_admin
general_radiusd_base_dir: /usr/local/radiusd
general_test_account_login: test
general_test_account_password: testpass
general_radius_server: localhost [IP-Address_of_RADIUS_server]
general_radius_server_auth_proto: pap
general_encryption_method: crypt
sql_server: localhost [IP-Address_of_sql_server]
sql_username: dialup_admin
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

You'll have to change:
general_radius_server_secret: XX
sql_password: XX

The rest should work by default.
Little more information on what's not working is helpful. Otherwise the
answer will be be: You misconfigured something...

Uli




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


Re: Dialup Admin Users File

2003-10-02 Thread Matt
Are there any perl scripts for use for web administration when using a plain
users file?  I would think it would be possible.

Matt


 On Mon, 29 Sep 2003, Matt wrote:

  Is it possible to use Dialup Admin with a plain users file?  If so how?

 No it isn't possible.

 
  Matt
 


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


Re: Dialup Admin Users File

2003-09-29 Thread Kostas Kalevras
On Mon, 29 Sep 2003, Matt wrote:

 Is it possible to use Dialup Admin with a plain users file?  If so how?

No it isn't possible.


 Matt


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


--
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


Re: dialup-admin patch

2003-09-16 Thread Ulrich Walcher
Forgot one case...


--- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
2003-05-11 16:03
:37.0 +0200
+++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-16
15:17:24.
0 +0200
@@ -58,13 +58,23 @@
 $link = @da_sql_pconnect($config);
 if ($link){
$search = @da_sql_query($link,$config,
-   SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
GROUP BY Gr
oupName;);
+   SELECT DISTINCT s.groupname FROM $config[sql_groupcheck_table]
CROSS JO
IN (SELECT DISTINCT u.groupname FROM $config[sql_groupreply_table] CROSS
JOIN $c
onfig[sql_usergroup_table] u) as s;);
if ($search){
if (@da_sql_num_rows($search,$config)){
while( $row =
@da_sql_fetch_array($search,$config) ){
$num++;
-   $group = $row[GroupName];
-   $num_members = $row['COUNT(*)'];
+   $group = $row[groupname];
+   $search2 = @da_sql_query($link,$config,
+   SELECT COUNT(*) FROM
$config[sql_usergroup_tabl
e] WHERE groupname = '$group';);
+   if ($search2) {
+   if
(@da_sql_num_rows($search,$config)){
+   while( $row2 =
@da_sql_fetch_arr
ay($search2,$config) ){
+   $num_members =
$row2['co
unt'];
+   }
+   }
+   }
+   else
+   echo bDatabase query failed:
 . da_s
ql_error($link,$config) . /bbr\n;
echo EOM
tr align=center
td$num/td


Am Fre, 2003-09-12 um 15.52 schrieb Ulrich Walcher:
 Hi,
 a little patch that solves the problem of groups with no members
 assigned not being displayed. (At least it works for Postgres).
 
 OoLee
 
 --- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
 2003-05-11 16:03:37.0 +0200
 +++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-12
 15:45:18.0 +0200
 @@ -58,13 +58,23 @@
  $link = @da_sql_pconnect($config);
  if ($link){
 $search = @da_sql_query($link,$config,
 -   SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
 GROUP BY GroupName;);
 +   SELECT DISTINCT c.groupname FROM $config[sql_groupcheck_table]
 c CROSS JOIN $config[sql_groupreply_table] r;);
 if ($search){
 if (@da_sql_num_rows($search,$config)){
 while( $row =
 @da_sql_fetch_array($search,$config) ){
 $num++;
 -   $group = $row[GroupName];
 -   $num_members = $row['COUNT(*)'];
 +   $group = $row[groupname];
 +   $search2 = @da_sql_query($link,$config,
 +   SELECT COUNT(*) FROM
 $config[sql_usergroup_table] WHERE groupname = '$group';);
 +   if ($search2) {
 +   if
 (@da_sql_num_rows($search,$config)){
 +   while( $row2 =
 @da_sql_fetch_array($search2,$config) ){
 +   $num_members =
 $row2['count'];
 +   }
 +   }
 +   }
 +   else
 +   echo bDatabase query failed:
  . da_sql_error($link,$config) . /bbr\n;
 echo EOM
 tr align=center
 td$num/td
 
 
 
 - 
 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 patch2

2003-09-16 Thread Ulrich Walcher
and here also...

--- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3  
2003-01-28 15:14:53.0 +0100
+++ /usr/local/dialup_admin/lib/sql/defaults.php3   2003-09-16
15:18:27.0 +0200
@@ -121,10 +121,10 @@
$link = @da_sql_pconnect($config);
if ($link){
$res = @da_sql_query($link,$config,
-   SELECT DISTINCT GroupName FROM
$config[sql_usergroup_table];);
+   SELECT DISTINCT s.groupname FROM
$config[sql_groupcheck_table] CROSS JOIN (SELECT DISTINCT u.groupname
FROM $config[sql_groupreply_table] CROSS JOIN
$config[sql_usergroup_table] u) as s;);
if ($res){
while(($row =
@da_sql_fetch_array($res,$config)))
-   $member_groups[] = $row[GroupName];
+   $member_groups[] = $row[groupname];
}
else
echo bDatabase query failed:  .
da_sql_error($link,$config) . /bbr\n;


Am Fre, 2003-09-12 um 16.08 schrieb Ulrich Walcher:
 Oops,
 forgot to add this one...
 
 OoLee
 
 --- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3  
 2003-01-28 15:14:53.0 +0100
 +++ /usr/local/dialup_admin/lib/sql/defaults.php3   2003-09-12
 16:04:15.0 +0200
 @@ -121,10 +121,10 @@
 $link = @da_sql_pconnect($config);
 if ($link){
 $res = @da_sql_query($link,$config,
 -   SELECT DISTINCT GroupName FROM
 $config[sql_usergroup_table];);
 +   SELECT DISTINCT c.groupname FROM
 $config[sql_groupcheck_table] c CROSS JOIN $config[sql_groupreply_table]
 r;);
 if ($res){
 while(($row =
 @da_sql_fetch_array($res,$config)))
 -   $member_groups[] = $row[GroupName];
 +   $member_groups[] = $row[groupname];
 }
 else
 echo bDatabase query failed:  .
 da_sql_error($link,$config) . /bbr\n;
 
 
 
 - 
 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 | stats.php3

2003-08-28 Thread Kostas Kalevras
On Wed, 27 Aug 2003, Ulrich Walcher wrote:

 Replacing line 92/93

   if ($server != 'all')
   $s = AND NASIPAddress = '$server';

 with

   if ($server != ''  $server != 'all')
   $s = AND NASIPAddress = '$server';

 solves a problem when running with PostgreSQL.

 Database query failed: ERROR: invalid INET value '' 

Fixed, thanks



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


--
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


Re: dialup-admin | new help pages

2003-08-26 Thread Kostas Kalevras
On Wed, 20 Aug 2003, Ulrich Walcher wrote:

 http://www.bcore.de/data/dialup_admin.help.tar.gz

Added, thanks


 Am Mit, 2003-08-20 um 16.17 schrieb Alan DeKok:
  Ulrich Walcher [EMAIL PROTECTED] wrote:
   I just wrote some new help pages for dialup-admin and altered
   user_edit.attrs.
   Where to should I mail the diff and the pages?
 
Put them in a 'tar' file on a web page, and mail the URL to the
  list.
 
Alan DeKok.
 
  -
  List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 


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


--
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


Re: dialup-admin | new help pages

2003-08-20 Thread Alan DeKok
Ulrich Walcher [EMAIL PROTECTED] wrote:
 I just wrote some new help pages for dialup-admin and altered
 user_edit.attrs.
 Where to should I mail the diff and the pages?

  Put them in a 'tar' file on a web page, and mail the URL to the
list.

  Alan DeKok.

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


Re: dialup-admin | new help pages

2003-08-20 Thread Ulrich Walcher
http://www.bcore.de/data/dialup_admin.help.tar.gz

Am Mit, 2003-08-20 um 16.17 schrieb Alan DeKok:
 Ulrich Walcher [EMAIL PROTECTED] wrote:
  I just wrote some new help pages for dialup-admin and altered
  user_edit.attrs.
  Where to should I mail the diff and the pages?
 
   Put them in a 'tar' file on a web page, and mail the URL to the
 list.
 
   Alan DeKok.
 
 - 
 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 question

2003-07-14 Thread Kostas Kalevras
On Mon, 14 Jul 2003, Truong Manh Cuong wrote:

 I use dialup-admin and this is my questions:

 -- I open the radcheck table: user's password is raw, not encript. so anyone that 
 can access to postgresql database then he or she can see password.
 in PHP code of user_new.php3, I see password encript procedure, how to use this 
 procedure ?

In conf/admin.conf:

general_encryption_method: crypt


 -- Why I need bad users table?

It's a way to keep track of unauthorized actions performed by your users. It's
only an informative table.

 -- If I use radgroupcheck and use groups in this table for usergroup, and I
 don't use radgroupreply table, what happens ? I mean that I drop
 radgroupreply table.

Probably nothing should happen.


 Thanks in advance.
 Manh Cuong.

--
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


Re: Dialup admin

2003-03-01 Thread mberzig

Try to change file_uploads=On in the php.ini file


Selon Eric [EMAIL PROTECTED]:

 Hello,
 I have such problem with Dialup admin:
 When i run it in my browser the left frame (buttons) is stay unloaded  showa
 
 the content of buttons.html.php3 file.
 I use php-4.3.0  apache 1.3.27  all off my other php-applications works 
 perfectly except Dialup admin :(
 Have somebody any ideas about it?
 Thanks in advance!!!
 
 - 
 List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
 




-
This mail sent through IMP: http://horde.org/imp/

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


Re: Dialup admin

2003-03-01 Thread Eric
It is already turned to On



On Saturday 01 March 2003 16:38, [EMAIL PROTECTED] wrote:
 Try to change file_uploads=On in the php.ini file

 Selon Eric [EMAIL PROTECTED]:
  Hello,
  I have such problem with Dialup admin:
  When i run it in my browser the left frame (buttons) is stay unloaded 
  showa
 
  the content of buttons.html.php3 file.
  I use php-4.3.0  apache 1.3.27  all off my other php-applications works
  perfectly except Dialup admin :(
  Have somebody any ideas about it?
  Thanks in advance!!!
 
  -
  List info/subscribe/unsubscribe? See
  http://www.freeradius.org/list/users.html

 -
 This mail sent through IMP: http://horde.org/imp/

 -
 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

2003-03-01 Thread Evren Yurtesen
do you have any other .php3 files working? maybe you should set in your
apache conf file that not only .php files should be treated as php files
but also .php3 fiels

On Sat, 1 Mar 2003, Eric wrote:

 Hello,
 I have such problem with Dialup admin:
 When i run it in my browser the left frame (buttons) is stay unloaded  showa 
 the content of buttons.html.php3 file.
 I use php-4.3.0  apache 1.3.27  all off my other php-applications works 
 perfectly except Dialup admin :(
 Have somebody any ideas about it?
 Thanks in advance!!!
 
 - 
 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 problems

2003-01-26 Thread Nachko Halachev
I have similar problem with dialup admin, but enabling safe mode = On and 
variables_order = EGPCS in php.ini solve problem.
Also interface didnt work with Konqueror browser. Natscape is fine .

 I have free radius runing but can not get the interface to work I don't get
 any errors but when I  attempt to add a user using the interface it does
 not do a thing.

 Regards,
 Peter Rahnev

 -
 http://kulinar.GBG.bg -  ÐÅÖÅÏÒÈ | ÏÎÄÏÐÀÂÊÈ |  ÏÐÎÄÓÊÒÈ | ÃÎÒÂÀÐÑÊÈ
 ÒÅÕÍÈÊÈ |  ÊÓËÈÍÀÐÅÍ ÊÀËÅÍÄÀÐ

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

-- 
Best Regards,

Nachko Halachev


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



Re: Dialup-Admin

2003-01-09 Thread Kostas Kalevras
On Tue, 7 Jan 2003, Mike Paneth wrote:

 Kostas wrote

   I have just started to use version 1.61 and I have the following
 questions.
  
   When I select Statistics (and select sessions, uploads and
 downloads,
   the results are all zero, even though the radacct table has entries.
 
  Do you press the Refresh button and you still don't get results?

 Yes, refresh does nothing

Strange, do you have the right start and stop time set in the statistics page?


  
   When I select a user, how do I change the allowed session time?  My
 users
   are volume based not time based.
 
  You can change the Session Timeout from the EDIT page if I understand you
  correctly.
 
 Edit only allows the following to be changes
 Protocol, Ip Address, Ip netmask, MTU, Compression used, Session timeout,
 Idle timeout, Port limit, Lock message

Edit the user_edit.attrs file to match your needs.


 The session timeout only affects the per-session timeout.  No daily or
 weekly limits can be set from here.

  
   Also the account status is all zeros.
 
  The Account Status is only for the last 7 days. Do you have sessions for
 that
  user for the last 7 days?
 
 The Accounting report generator gave the following

 Client IP Address Download Login Time Logout Time NAS IP Address NAS Port
 Session Time Upload User Name
   -  2.10 MBs 2003-01-06 10:40:29 2003-01-06 10:57:35 192.168.1.1 0 0
 seconds  146.48 KBs fred
   -  0.62 MBs 2003-01-07 12:13:20 2003-01-07 12:14:55 192.168.1.100 0 0
 seconds  120.56 KBs fred

 When I edit user fred, I get the following in the Account status for the
 last 7 days section
 Connections  0
 Online time  0 seconds
 Failed Logins  0
 Upload  0.00 KBs
 Download  0.00 KBs
 Average Time  0 seconds
 Average Upload  0.00 KBs
 Average Download  0.00 KBs

That's really strange, what does the user accounting page give you?

--
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



Re: Dialup-Admin

2003-01-06 Thread Kostas Kalevras
On Mon, 6 Jan 2003, Mike Paneth wrote:

 I have just started to use version 1.61 and I have the following questions.

 When I select Statistics (and select sessions, uploads and downloads,
 the results are all zero, even though the radacct table has entries.

Do you press the Refresh button and you still don't get results?


 When I select a user, how do I change the allowed session time?  My users
 are volume based not time based.

You can change the Session Timeout from the EDIT page if I understand you
correctly.


 Also the account status is all zeros.

The Account Status is only for the last 7 days. Do you have sessions for that
user for the last 7 days?


 Is it possible to convert the html to shtml so I can pass this securely over the 
network?

use https ?


 Is it possible to have login security, so only valid users can access these pages?

Use apache http authentication.


 Sorry, but I am not a programmer and don't fully understand these issues, or how to 
solve them.

 Mike Paneth
 Melbourne Australia


--
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



RE: Dialup-Admin

2003-01-06 Thread Tim D. McCracken



Obviously you are 
not using FreeRadius, so you are on the wrong list. FreeRadius is 
currently on version .8

  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mike 
  PanethSent: Monday, January 06, 2003 12:06 AMTo: 
  [EMAIL PROTECTED]Subject: 
  Dialup-Admin
  I have just started to use version 1.61 and I 
  have the following questions.
  
  When I select "Statistics" (and select 
  "sessions", "uploads" and "downloads", the results are all zero, even though 
  the radacct table has entries.
  
  When I select a user, how do I change the 
  "allowed session" time? My users are volume based not time 
  based.
  
  Also the account status is all 
zeros.
  
  Is it possible to convert the html to shtml so I 
  can pass this securely over the network?
  
  Is it possible to have login security, so only 
  valid users can access these pages?
  
  Sorry, but I am not a programmer and don't fully 
  understand these issues, or how to solve them.
  
  Mike Paneth
  Melbourne Australia
  


RE: Dialup-Admin

2003-01-06 Thread Evren Yurtesen
no, he is on the right list I think, freeradius version is 0.81 but
dialupadmin version is about 1.61 if I am not mistaken?

On Mon, 6 Jan 2003, Tim D. McCracken wrote:

 Obviously you are not using FreeRadius, so you are on the wrong list.
 FreeRadius is currently on version .8
   -Original Message-
   From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Paneth
   Sent: Monday, January 06, 2003 12:06 AM
   To: [EMAIL PROTECTED]
   Subject: Dialup-Admin
 
 
   I have just started to use version 1.61 and I have the following
 questions.
 
   When I select Statistics (and select sessions, uploads and
 downloads, the results are all zero, even though the radacct table has
 entries.
 
   When I select a user, how do I change the allowed session time?  My
 users are volume based not time based.
 
   Also the account status is all zeros.
 
   Is it possible to convert the html to shtml so I can pass this securely
 over the network?
 
   Is it possible to have login security, so only valid users can access
 these pages?
 
   Sorry, but I am not a programmer and don't fully understand these issues,
 or how to solve them.
 
   Mike Paneth
   Melbourne Australia
 
 


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



RE: Dialup-Admin

2003-01-06 Thread Evren Yurtesen
About the questions, I put SSL server so I am using dialup_admin with ssl
and you can use any kind of security the apache or your web server 
software supports for accessing the pages. I put a simple
username/password which was enough for me.

Evren

On Mon, 6 Jan 2003, Evren Yurtesen wrote:

 no, he is on the right list I think, freeradius version is 0.81 but
 dialupadmin version is about 1.61 if I am not mistaken?
 
 On Mon, 6 Jan 2003, Tim D. McCracken wrote:
 
  Obviously you are not using FreeRadius, so you are on the wrong list.
  FreeRadius is currently on version .8
-Original Message-
From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Paneth
Sent: Monday, January 06, 2003 12:06 AM
To: [EMAIL PROTECTED]
Subject: Dialup-Admin
  
  
I have just started to use version 1.61 and I have the following
  questions.
  
When I select Statistics (and select sessions, uploads and
  downloads, the results are all zero, even though the radacct table has
  entries.
  
When I select a user, how do I change the allowed session time?  My
  users are volume based not time based.
  
Also the account status is all zeros.
  
Is it possible to convert the html to shtml so I can pass this securely
  over the network?
  
Is it possible to have login security, so only valid users can access
  these pages?
  
Sorry, but I am not a programmer and don't fully understand these issues,
  or how to solve them.
  
Mike Paneth
Melbourne Australia
  
  
 
 
 - 
 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

2003-01-06 Thread Mike Paneth
Kostas wrote

  I have just started to use version 1.61 and I have the following
questions.
 
  When I select Statistics (and select sessions, uploads and
downloads,
  the results are all zero, even though the radacct table has entries.

 Do you press the Refresh button and you still don't get results?

Yes, refresh does nothing

 
  When I select a user, how do I change the allowed session time?  My
users
  are volume based not time based.

 You can change the Session Timeout from the EDIT page if I understand you
 correctly.

Edit only allows the following to be changes
Protocol, Ip Address, Ip netmask, MTU, Compression used, Session timeout,
Idle timeout, Port limit, Lock message

The session timeout only affects the per-session timeout.  No daily or
weekly limits can be set from here.

 
  Also the account status is all zeros.

 The Account Status is only for the last 7 days. Do you have sessions for
that
 user for the last 7 days?

The Accounting report generator gave the following

Client IP Address Download Login Time Logout Time NAS IP Address NAS Port
Session Time Upload User Name
  -  2.10 MBs 2003-01-06 10:40:29 2003-01-06 10:57:35 192.168.1.1 0 0
seconds  146.48 KBs fred
  -  0.62 MBs 2003-01-07 12:13:20 2003-01-07 12:14:55 192.168.1.100 0 0
seconds  120.56 KBs fred

When I edit user fred, I get the following in the Account status for the
last 7 days section
Connections  0
Online time  0 seconds
Failed Logins  0
Upload  0.00 KBs
Download  0.00 KBs
Average Time  0 seconds
Average Upload  0.00 KBs
Average Download  0.00 KBs

  Mike Paneth
  Melbourne Australia
 

 --
 Kostas Kalevras Network Operations Center
 [EMAIL PROTECTED] National Technical University of Athens, Greece
 Work Phone: +30 210 7721861
 'Go back to the shadow' Gandalf


The config file is as follows

#
# 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: el
general_prefered_lang_name: Greek
#
# Uncomment this if normal attributes (not the ;lang-xx ones) in ldap
# are utf8 encoded.
#
#general_decode_normal_attributes: yes
#
#general_base_dir: /usr/local/dialup_admin
#general_radiusd_base_dir: /usr/local/radiusd
#general_domain: company.com
general_base_dir: /data/dialup_admin
general_radiusd_base_dir: /usr/local
general_domain: marinett.com

#
# 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
#
# 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
#
# 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
#


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
#
# it can be either ldap or sql
#
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
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table without
first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: testing123
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1812
#
# sorry, single valued for now. Should become something like
# password[server-name]: x
#
general_radius_server_secret: XX
general_auth_request_file: %{general_base_dir}/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)
#
general_accounting_info_order: desc

nas1_name: Firewall.%{general_domain}
nas1_model: Mikes firewall (192.168.1.1)
nas1_ip: 192.168.1.1
nas1_port_num: 100
nas1_community: public

nas2_name: M.%{general_domain}
nas2_model: M Wireless system (192.168.1.100)
nas2_ip: 192.168.1.100
nas2_port_num: 100
nas2_community: public


Re: Dialup Admin - Help!

2002-10-06 Thread Andrew Hardman



it just says user not found. doesnt find any user 
on any page. yet to finger_user.php works fine. i can see whos dialed 
in.


What do you mean by 
cannot edit current users? Does it find a current user or itjust says 
that the user was not found? Does the Accounting or Find Userpages work 
ok? Enable mysql logging and check the sql queries executed 
bydialup_admin. If you run them by hand do they produce any 
results?--Kostas Kalevras Network Operations 
Center[EMAIL PROTECTED] 
National Technical University of Athens, GreeceWork Phone: +30 210 
7721861'Go back to the shadow' 
Gandalf


Re: Dialup Admin - Help!

2002-10-06 Thread Kostas Kalevras

On Sun, 6 Oct 2002, Andrew Hardman wrote:

 it just says user not found. doesnt find any user on any page. yet to
 finger_user.php works fine. i can see whos dialed in.

What happens if you try to add a new user?
Do you do user authentication/authorization from mysql?

Can you do a show tables in mysql for the radius database? Does it contain all
the tables?

If you do a SELECT * FROM radcheck WHERE UserName='something'
and SELECT * FROM radreply WHERE UserName = 'something' where something is a
valid username in mysql what do you get back?

--
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



Re: Dialup Admin - Help!

2002-10-03 Thread Aaron Webb

Have you checked the permissions of your radius MySQL user?

-AW

On October 3, 2002 04:14 am, Andrew Hardman wrote:
 This is pretty much a follow up to a previous listing.
 http://lists.cistron.nl/pipermail/freeradius-users/2002-June/008022.html

 I have the same problem. I can see the users online but cannot create or
 administer current users in the database.

 sql_type: mysql
 sql_server: localhost
 sql_port: 3306
 sql_username: radius
 sql_password: xx
 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

 Where am i going wrong. It seems to read from mysql but cannot create. When
 i check online users it tells me the name of the person next to the
 username ok. As I entered userinfo via webmin.

 Any Ideas?

 Andrew Hardman
 Email: [EMAIL PROTECTED]


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



Re: Dialup Admin - Help!

2002-10-03 Thread Andrew Hardman

Yeh I have, radius has full rights to add edit and delete etc. Its strange
cause I can see whos logged in but cannot edit current or even add users.
Although if i change any of the settings it tells me connect connect to sql
database

Andrew


Have you checked the permissions of your radius MySQL user?

-AW

On October 3, 2002 04:14 am, Andrew Hardman wrote:
 This is pretty much a follow up to a previous listing.
 http://lists.cistron.nl/pipermail/freeradius-users/2002-June/008022.html

 I have the same problem. I can see the users online but cannot create or
 administer current users in the database.

 sql_type: mysql
 sql_server: localhost
 sql_port: 3306
 sql_username: radius
 sql_password: xx
 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

 Where am i going wrong. It seems to read from mysql but cannot create.
When
 i check online users it tells me the name of the person next to the
 username ok. As I entered userinfo via webmin.

 Any Ideas?

 Andrew Hardman
 Email: [EMAIL PROTECTED]


Andrew Hardman
Email: [EMAIL PROTECTED]




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



Re: Dialup admin FATAL error in apache repost

2002-07-03 Thread Kostas Kalevras

On Wed, 3 Jul 2002, Marcello Lupo wrote:

 HI to all ...
 i repost this message becouse i very need help.


 I have installed the dialup_admin package on freeradius 0.5, apache
 1.3.26 and php
 4.2.1.
 WHen i try to get some user information and the query return some
 results, i get this error on apache-php logs

 FATAL:  emalloc():  Unable to allocate 1087359016 bytes
 [Mon Jul  1 09:47:26 2002] [notice] child pid 16608 exit signal
 Segmentation fault (11)


 If for example i query the database for a user that doesn't exist the
 problem don't occur. I only get the error message user does not exist.
 If the user exist i get the error.

 Other than i have always this kind of notice in the logs:

 [Mon Jul  1 09:47:25 2002] [error] PHP Notice:  Use of undefined
 constant sql_date_format - assumed 'sql_date_format' in
 /usr/local/dialup_admin/htdocs/user_admin.php3 on line 60
 /usr/local/dialup_admin/htdocs/user_admin.php3(60) : Notice - Use of
 undefined constant sql_date_format - assumed 'sql_date_format'
 [Mon Jul  1 09:47:25 2002] [error] PHP Notice:  Use of undefined
 constant sql_date_format - assumed 'sql_date_format' in
 /usr/local/dialup_admin/htdocs/user_admin.php3 on line 64
 /usr/local/dialup_admin/htdocs/user_admin.php3(64) : Notice - Use of
 undefined constant sql_date_format - assumed 'sql_date_format'

 Any ideas??
 Thank you
 MArcello

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

Are you using an ldap database or sql?
When you access the other pages (accounting,online users,create user) what do
you get?
Did you create the user through the create user page or manually?
Could you post your admin.conf and a user entry that triggers the problem?

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



Re: Dialup admin FATAL error in apache repost

2002-07-03 Thread Marcello Lupo

Hi thank you for the answer, well...

I Use mysql. I have imported the users with a perl script from an old
/etc/shadow System.
I get the same error in every page i have to get some result from the
database.
I'm able to create users with the interface but if i try to get
information of the user created i get the error.
The page of the online users is running, i think becouse it use only the
snmpfinger on the NAS.
The statistic page is working properly.
I have a little more question: How may i have the group to insert the
user in shown in the new user page and let the dialup_admin to insert
the user in the group i specified?


This are my tables:

mysql show tables;
+--+
| Tables_in_radius |
+--+
| badusers |
| radacct  |
| radcheck |
| radgroupcheck|
| radgroupreply|
| radreply |
| usergroup|
| userinfo |
+--+
8 rows in set (0.01 sec)

This is an account that trigger the error, but all the accounts trigger
the problem.

mysql select * from radcheck where username='pipperino';
++---+++--+
| id | UserName  | Attribute  | Value  |
op   |
++---+++--+
|  1 | pipperino | Crypt-Password | $1$/EhFx4aw$.jqrX7F5RwKB5ExUINRYH0
|  |
++---+++--+
1 row in set (0.01 sec)

mysql select * from usergroup where username='pipperino';
++---+---+
| id | UserName  | GroupName |
++---+---+
|  1 | pipperino | DEFAULT   |
++---+---+
1 row in set (0.09 sec)


This is  my admin.cong file:


# it can be el (greek) or default
#
general_prefered_lang: el
general_prefered_lang_name: Greek
#
general_base_dir: /usr/local/dialup_admin
general_radiusd_base_dir: /usr/local
general_domain: domain.com
#
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
#
# it can be either ldap or sql
#
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
#
# can be 'snmp' (for snmpfinger) or empty to query the radacct table
without first
# querying the nas
#
general_finger_type: snmp
general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
#
# this information is used from the server check page
#
general_test_account_login: test
general_test_account_password: testpass
#
# These are used as default values for the user test page
#
general_radius_server: localhost
general_radius_server_port: 1645
#
# sorry, single valued for now. Should become something like
# password[server-name]: x
#
general_radius_server_secret: secret
general_auth_request_file: %{general_base_dir}/conf/auth.request
#
# can be one of crypt,md5,clear
#
general_encryption_method: crypt
#
# can be either asc (older dates first) or desc (recent dates first)
#
general_accounting_info_order: desc

nas1_name: as5300.%{general_domain}
nas1_model: Cisco AS5300 access server
nas1_ip: xxx.xxx.xxx.xxx
nas1_port_num: 60
nas1_community: public
nas2_name: nas2.%{general_domain}
nas2_model: Cisco 2511 access server
nas2_ip: 147.122.122.123
nas2_port_num: 16
nas2_community: public
nas3_name: nas3.%{general_domain}
nas3_model: Cisco 5300 access server
nas3_ip: 147.122.122.124
nas3_port_num: 210
nas3_community: public

ldap_server: ldap.%{general_domain}
ldap_base: dc=company,dc=com
ldap_binddn: cn=Directory Manager
ldap_bindpw: XXX
ldap_default_new_entry_suffix: ou=dialup,ou=guests,%{ldap_base}
ldap_default_dn: uid=default-dialup,%{ldap_base}
ldap_regular_profile_attr: dialupregularprofile

#
# can be one of mysql,pg where:
# mysq: MySQL database (port 3306)
# pg: PostgreSQL database (port 5432)
#
sql_type: mysql
sql_server: localhost
sql_port: 3306
sql_username: username
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
#
# true or false
#
#sql_use_user_info_table: true
#sql_use_operators: true
sql_use_user_info_table: false
sql_use_operators: false
#
#
sql_password_attribute: Crypt-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

counter_default_daily: 14400
counter_default_weekly: 72000
counter_default_monthly: none

**







Kostas Kalevras wrote:
 
 On Wed, 3 Jul 

Re: Dialup admin - a small change which helps me a lot.

2002-07-03 Thread Kostas Kalevras

On Wed, 3 Jul 2002, Alexandre Strube wrote:

 On dialup admin, adding the following line to htdocs/user_finger.php3
 META HTTP-EQUIV=Refresh CONTENT=30
 below the head line will make the online users page reload twice a minute,
 so I don't need to get reloading the page every time. Hope this interest someone.

Added, thanks.

It will just refresh every 50 secs instead of 30 secs since the page can take a
few seconds to load when fingering a Cisco 5800 :-)

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



Re: Dialup Admin again

2002-06-11 Thread Kostas Kalevras

On Mon, 10 Jun 2002, Alexandre Strube wrote:

 When set to clear text password on admin.conf the user_admin.php3 file can check
 the password correctly! But I could never get this to work when using crypt on
 general_encryption_method line... It always says NO It is wrong, even when
 the password is correct...

What OS are you using? The crypt function can get very tricky some times.


 Another thing worth of mention: when the line above is set to clear, it still set 
the password
 value on Crypt-Password record from radcheck table, which stops radius from 
authenticating
 the user ... It tries to find a crypted password, but what it finds is a cleartext 
one...

 Of course when I changed this, I changed the password on radcheck table so the
 user is always authenticating correctly...

There is an sql_password_attribute configuration directive in conf/admin.conf.
You could just change that.

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



RE: Dialup Admin question

2002-06-04 Thread Kostas Kalevras

On Mon, 3 Jun 2002, Deramus, Chris wrote:

 Does it print out any messages? If you try adding a new user what happens?
 Do you have problem seeing the accounting information or everything? If you
 try to administer an active account, does it report that it didn't find it
 or does it show the user administration page ok?

 The page to load fine. I click the Edit Users section on the left frame and
 it says user not found. I do a search for user 'TestRad' (which does exist
 cause I'm currently logged in as him on my laptop) and it says User does not
 exist.

 The accounting page shows my attributes and gives me the selection to choose
 from, but when I hit the submit button it just resets the values and doesn't
 display anything (including error messages). When I had enter new user
 information on the Add User section, and then hit the enter button the
 information disappears and that entry isn't added to the database.

So it takes the column information from the database but doesn't find anything
in the accounting table. That seems strange. If you do a 'SELECT UserName FROM
radacct LIMIT 10' will it give you any results?

Could you send the sql_* config directives from the admin.conf (apart from the
sql password of course).


 It doesn't display any active accounts even though I'm currently logged on
 right now.

If you do a 'SELECT UserName from radacct WHERE AcctStartTime = '0'' what does
it show when you are loged in? The admin.conf allows you to do a finger to the
nas (that only works for cisco access servers currently) or just use the
information provided from the accounting database. Which of the two have you
enabled?


 Thanks,

 Chris DeRamus
 HQ VPN Administrator
 Verizon
 301-903-2093




--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



Re: Dialup Admin question

2002-06-03 Thread Kostas Kalevras

On Mon, 3 Jun 2002, Deramus, Chris wrote:

 I know this service is mainly for Free Radius questions but I figured since
 this product was written for FreeRadius that someone on here has had
 experience using it.

 I have FreeRadius successfully working with MySQL for Authorization and PAP
 for authentication. The system works great and I'm very happy. I'm now
 trying to bring a web front online for added administration convenience. I
 have Dialup Admin installed and it seems to be working fine, however it's
 not pulling any information from the MySQL database and tables. I've looked
 over the admin.conf file many a times and short of the basic configuration
 changes are there any major changes that any of you had to make before this
 would begin to work.

 Thanks,

 Chris DeRamus
 HQ VPN Administrator
 Verizon
 301-903-2093

Does it print out any messages? If you try adding a new user what happens? Do
you have problem seeing the accounting information or everything? If you try to
administer an active account, does it report that it didn't find it or does it
show the user administration page ok?

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



RE: Dialup Admin question

2002-06-03 Thread Deramus, Chris
Title: RE: Dialup Admin question





Does it print out any messages? If you try adding a new user what happens? Do you have problem seeing the accounting information or everything? If you try to administer an active account, does it report that it didn't find it or does it show the user administration page ok?

The page to load fine. I click the Edit Users section on the left frame and it says user not found. I do a search for user 'TestRad' (which does exist cause I'm currently logged in as him on my laptop) and it says User does not exist. 

The accounting page shows my attributes and gives me the selection to choose from, but when I hit the submit button it just resets the values and doesn't display anything (including error messages). When I had enter new user information on the Add User section, and then hit the enter button the information disappears and that entry isn't added to the database. 

It doesn't display any active accounts even though I'm currently logged on right now. 


Thanks,


Chris DeRamus 
HQ VPN Administrator 
Verizon 
301-903-2093 






Re: Dialup-Admin

2002-04-02 Thread pavesi


When Apache was initially set up during the Caldera OpenLinux installation
the default php extension was set to just php rather than php3. So I
renamed all of the dialup-admin files to have a php extension and I edited
them all replacing php3 with php. Everything appears to be working for the

why did you not just edit the httpd.conf file and add   '.php3' after the .php
include??


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



Re: Dialup-Admin

2002-04-02 Thread Jason M. Weber

When I change the following line in accounting.php:

$link = @da_sql_pconnect($config) or die...

to

$link = mysql_pconnect(localhost, username,password) or die...

I can connect to the db and the accounting page works just fine. A problem
with my config file? A problem with this @da_sql_pconnect function? (I
can't seem to find it referenced at php.net so I'm assuming it's a function
somewhere in the dialup-admin stuff but I can't find it. I'm just looking
for some suggestions folks. Thanks.

~ Jason

- Original Message -
From: Jason M. Weber [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: April 02, 2002 9:14 AM
Subject: Dialup-Admin


 When Apache was initially set up during the Caldera OpenLinux installation
 the default php extension was set to just php rather than php3. So I
 renamed all of the dialup-admin files to have a php extension and I edited
 them all replacing php3 with php. Everything appears to be working for the
 most part; radiusd, MySQL, and Apache are all running. But when I try to
use
 the Dialup_Admin I ran into some problems:

 When I click on:

 Accounting: cannot connect to sql databse
Problem line appears to be $link = @da_sql_pconnect($config) or die...
Obviously the script is unable to open a persistent connection to the
 MySQL db. Any ideas?

 Edit User: Could not connect to database.
 New User: Could not connect to database.
 Check Server: Could not connect to database.

 I have changed the sql_username and sql_password in admin.conf. Can MySQL
 usernames have an underscore in them? The MySQL user that I set up for
 radius was dialup_admin, could this be the problem? Clearly I'm missing
 something big (not unusual).

 Are these problems related to my tinkering around with the file
extensions?

 Thanks much.

 ~ Jason


 -
 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 ... error in delete_user.php3, line 18

2002-03-10 Thread Kostas Kalevras

On Sat, 9 Mar 2002, Peter Santiago wrote:

 code fragment reads
  if ($res){
if ($config[sql_use_user_info_table] == 'true'){
 $res = @da_sql_query($config[sql_database], - error.. this
 will return false
DELETE FROM $config[sql_user_info_table] WHERE UserName
 = '$login';);
 if ($res)
 echo bUser $login deleted
 successfully/bbr\n;
  else
  echo bError deleting user $login from user
 info table/bbr\n;
 }

 Isn't that line supposed to read

 $res = @da_sql_query($link,$config, DELETE FROM
 $config[sql_user_info_table] WHERE UserName = '$login';);

 ???


 Peter


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


Yes you 're right. Bug fixed in cvs

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



RE: dialup-admin--- sorry.. my mistake...

2002-03-09 Thread Peter Santiago

problem just solved itself... I must be brain-dead... Kostas, you did a very
wonderful job...

peter


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



Re: dialup-admin

2002-03-09 Thread Kostas Kalevras

On Sat, 9 Mar 2002, Peter Santiago wrote:

 the following commands does not execute properly...

 1. Check server doesn't return any results...

general_radiusd_base_dir should contain the base directory of the freeradius
installation *not* the radiusd binary. The way you 've edited admin.conf will
make the radclient path look like this:
/usr/sbin/radiusd/bin/radclient which does not seem correct. Only if
dialup_admin can access radclient can the 'check server' and 'test user' pages
work properly.

 2. Edit users on the left side menu doesn't retrieve userinfo, when the
 input box is filled the username.  One has to enter the user name again in
 the main window then click on show user, before the userinfo comes out

Just put the username in the input box and press enter. :-)

 general_base_dir: /var/www/html/dialup_admin
 general_radiusd_base_dir: /usr/sbin/radiusd
 general_domain: psinergybbs.com
 #
 general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
 general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
 #

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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



RE: dialup-admin

2002-03-09 Thread Peter Santiago

Thanks Kostas  I must be getting senile, to miss such an obvious error
:(

Peter

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kostas
Kalevras
Sent: 09 March 2002 23:31
To: Freeradius-Users@Lists. Cistron. Nl
Subject: Re: dialup-admin


On Sat, 9 Mar 2002, Peter Santiago wrote:

 the following commands does not execute properly...

 1. Check server doesn't return any results...

general_radiusd_base_dir should contain the base directory of the freeradius
installation *not* the radiusd binary. The way you 've edited admin.conf
will
make the radclient path look like this:
/usr/sbin/radiusd/bin/radclient which does not seem correct. Only if
dialup_admin can access radclient can the 'check server' and 'test user'
pages
work properly.

 2. Edit users on the left side menu doesn't retrieve userinfo, when the
 input box is filled the username.  One has to enter the user name again in
 the main window then click on show user, before the userinfo comes out

Just put the username in the input box and press enter. :-)

 general_base_dir: /var/www/html/dialup_admin
 general_radiusd_base_dir: /usr/sbin/radiusd
 general_domain: psinergybbs.com
 #
 general_snmpfinger_bin: %{general_base_dir}/bin/snmpfinger
 general_radclient_bin: %{general_radiusd_base_dir}/bin/radclient
 #

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]  National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf


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


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