RE: db_mysql.sql

2007-07-11 Thread Joel Eddy
Is version 1.1.6 missing the db_mysql.sql script?
Is it possible to use the one from 1.0.1 or some other version?
Or is there a link I've missed somewhere to get it?

By the way I APPRECIATE all that you programmers are doing.
I can only imagine the long hours put in to make this product work.

THANK YOU !!


Joel


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


RE: DB_MYSQL.SQL

2007-07-11 Thread Joel Eddy
For those that need it, like I did you can add this to the end of
http://wiki.freeradius.org/MySQL_DDL_script to get your database
to create the userinfo table also

#
# Table structure for table 'userinfo'
#
CREATE TABLE userinfo (
  id int(10) NOT NULL auto_increment,
  UserName varchar(30),
  Name varchar(200),
  Mail varchar(200),
  Department varchar(200),
  WorkPhone varchar(200),
  HomePhone varchar(200),
  Mobile varchar(200),
  PRIMARY KEY (id),
  KEY UserName (UserName),
  KEY Departmet (Department)
);



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


RE: Web up

2006-08-25 Thread Joel Eddy

Site up from here in Iowa


Joel


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


Re: sql.conf

2006-03-20 Thread Joel Eddy

If it's a new install check that your iptables aren't blocking your access also


- Original Message - 
From: Laker Netman [EMAIL PROTECTED]

To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Monday, March 20, 2006 5:23 PM
Subject: Re: sql.conf



There is definitely a password problem.  But it may be
due to *where* your logging in from, rather than the
password.  Are FR and MySQL on the same box?

Have you double checked with the mysql client that you
can login to the database (on the machine where mysql
is installed).  From a command prompt just type mysql
-p, enter the password.  If there is no error,
something else more serious is amiss or you do not
have [EMAIL PROTECTED] configured in the DB where zz is
the host where mysql is installed.

Laker


--- Atkins, Dwane P [EMAIL PROTECTED] wrote:


Why is it that when I run a radiusd -X, I always
come back with errors
on saying that it cannot connect to the mysql
server:

 


rlm_sql (sql): Driver rlm_sql_mysql (module
rlm_sql_mysql) loaded and
linked

rlm_sql (sql): Attempting to connect to
[EMAIL PROTECTED]:/radius

rlm_sql (sql): starting 0

rlm_sql (sql): Attempting to connect rlm_sql_mysql
#0

rlm_sql_mysql: Starting connect to MySQL server for
#0

rlm_sql_mysql: Couldn't connect socket to MySQL
server
[EMAIL PROTECTED]:radius

rlm_sql_mysql: Mysql error 'Access denied for user
'radius'@'localhost'
(using password: YES)'

rlm_sql (sql): Failed to connect DB handle #0

rlm_sql (sql): starting 1

rlm_sql (sql): starting 2

rlm_sql (sql): starting 3

rlm_sql (sql): starting 4

rlm_sql (sql): Failed to connect to any SQL server.

 


I have put this in my sql.conf like so:

 


# Connect info

server = localhost

login = radius

password = x

 


# Database table configuration

radius_db = radius
mailto:[EMAIL PROTECTED]  

 


What am I doing wrong?  I have followed a number of
whitepapers to
install this and most of them say the same thing. 

 


I downloaded freeradius and mysql-server using the
'yum install' option.
Now, when I do a ./configure on freeradius, do I
need to do it with a
-with-mysql option?

 


Should I try this on something other than FC4?  I am
opened to options.


Thanks


Dwane

 

 - 
List info/subscribe/unsubscribe? See

http://www.freeradius.org/list/users.html


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
- 
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: Wiki is now live

2005-12-12 Thread Joel Eddy

Thanks Peter.


Joel

- Original Message - 
From: Alan DeKok [EMAIL PROTECTED]

To: freeradius-users@lists.freeradius.org
Sent: Monday, December 12, 2005 11:55 AM
Subject: Wiki is now live



http://wiki.freeradius.org/

 Please feel free to add documentation, configuration examples, etc.
Right now it's pretty minimal and free-form.

 Thanks to Peter Nixon for setting it up and hosting it.

 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: Setting up Dialup_admin

2005-05-17 Thread Joel Eddy
Douglas,
In this section of your php.conf file add the last line to it.
It should be located in the httpd directory.
Hope this helps.

#
# Cause the PHP interpreter to handle files with a .php extension.
#
AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3
Joel


- Original Message - 
From: Douglas Huber [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Tuesday, May 17, 2005 1:10 PM
Subject: Setting up Dialup_admin


I am have setup freeradius 1.0.2.  The php web interface seems to have a
problem.  When I launch it, I get the page, but the sidebar where
options/button should be is blank with scraps of php code in it.
Any advice on what is wrong ?
dch
--
dch

-
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: postgresql problem/question

2005-05-09 Thread Joel Eddy
Dave,
Not sure if I'll be much help on this one, but I'll do my best.
In my radgroupreply I have Auth-Type := Local
I don't know if that will fix it or not.
Also, I think freeradius had a file sql.conf that had to have stuff 
uncommented
to get it to record certain info. Yours should be postgresql.conf. You also 
need to tell
radiusd.conf to use that file if you haven't already.

Have you been down through the radiusd.conf file to uncomment things in 
there too?
I remember having to read over it and make changes there.

Hope this helps. If I think of anything else I'll let you know.
Nice activation interface.
Also when you get time this today give me a call. I want to get with you on 
the
DSL lines for us and put together a plan of attack.

SQL result
Host: localhost
Database: radius
Generation Time: May 09, 2005 at 10:02 AM
Generated by: phpMyAdmin 2.6.0-pl2 / MySQL 3.23.58
SQL-query: SELECT * FROM `radgroupreply` LIMIT 0, 30;
Rows: 8
 id  GroupName  Attribute  op  Value  prio
 1 dialin Framed-Compression := Van-Jacobsen-TCP-IP 0
 2 dialin Framed-Protocol := PPP 0
 3 dialin Service-Type := Framed-User 0
 4 dialin Auth-Type := Local 0
 5 dialin Framed-MTU := 1500 0
 6 dialin Session-Timeout := 14400 0
 7 dialin Idle-Timeout := 1200 0
 8 dialin Port-Limit := 1 0

- Original Message - 
From: Dave Weis [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Monday, May 09, 2005 6:58 AM
Subject: postgresql problem/question


I'm trying to use postgresql to store my radius data. I have most of it 
working except for a stored procedure to return the static 
routing/addressing information for a login. It tries to work but I don't 
get the correct output in radtest.

select * from generate_radreply('[EMAIL PROTECTED]');
   id   | username | attribute | op | value
+--+---++
 104032 | [EMAIL PROTECTED] | Framed-IP-Address | := | 1.2.3.4
When I run radtest:
rad_recv: Access-Accept packet from host 127.0.0.1:1812, id=59, length=56
Framed-IP-Address = 255.255.255.255
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Routing = Broadcast-Listen
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP
The other reply items come from radgroupreply. When I run radiusd -X I see 
this in the logs:
  modcall[post-auth]: module sql returns ok for request 0
modcall: group post-auth returns ok for request 0
Sending Access-Accept of id 59 to 127.0.0.1:57298
Framed-IP-Address BARE-WORD :=
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Routing = Broadcast-Listen
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP
Finished request 0

Any ideas why my data is not making it back?
Thanks
dave
--
Dave Weis
[EMAIL PROTECTED]
http://www.internetsolver.com/
- 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: Simultaneous use ?

2005-04-08 Thread Joel Eddy
To answer some of my own questions, and maybe someone else's with the same 
issues
running 3COM USRHiper equipment.

To get the SNMP_Sessions and BER modules for Perl go to: 
http://www.switch.ch/misc/leinen/snmp/perl/dist/SNMP_Session-1.07.tar.gz

After installing these my simultaneous use works.
Joel

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


RE: Simultaneous use and log ?

2005-04-07 Thread Joel Eddy
1. I've got a simultaneous use problem.
   1a. I have 3COM  USRHIPER equipment.
   1b. I have the Net::Telnet module installed
   1c. port_density is 256
   Do I still need the SNMP_Session and  BER modules to make this work?
   If so where do I get these? I've looked in CPAN and I don't find them 
there.

2. Freeradius start up log or ??
   2a. I have tried starting radiusd -sx to see if it is seeing the 
Simultaneous  Use line.
   2b. But it goes by so fast I can't tell, so is there a log file 
somewhere that it logs to on startup?

3. The HiperArc cards are running firmware 5.3.3
Thanks for any help you can provide.
Joel 


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


Re: (dialupadmin) user edit not showing passwords

2005-03-10 Thread Joel Eddy
Nick,
I had the same problem. I'm using MySql and the column is named 
User-Password

The file user_edit.attrs in your dialup_admin/conf directory.
add to the file above the line Auth-Type
User-PasswordUsers Password
That should do it.
Joel
- Original Message - 
From: Nick Bright [EMAIL PROTECTED]
To: freeradius-users freeradius-users@lists.freeradius.org
Sent: Thursday, March 10, 2005 10:55 AM
Subject: (dialupadmin) user edit not showing passwords


I'm storing passwords in plain text, to ease troubleshooting, and even
though I have general_show_user_password: yes in my admin.conf file, the
dialup_admin pages don't show the users' password anywhere (though I can
reset the password properly).
Ideally I think it should be on the show page only, my thought is to
put another row on the table in the Check Password area that would
show the password as in the database - leaving the check form, so that
a test could still be done.
If it /should/ be working, please advise what to check for as I've been
poking around for a bit, and don't see anything that would be causing it
not to work.
--
- Nick Bright
 Terraworld, Inc
 888-332-1616 x315
 http://home.terraworld.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


Re: (dialupadmin) user edit not showing passwords

2005-03-10 Thread Joel Eddy
I would have to agree with the idea of passwords not being visable.
However, in our situation and maybe even Nick's, if we have
a customer call in with issues connecting we typically make sure
the ID is correct and have them retype their password.
It is nice to be able to see what it is, without having to create a new one
every time they would call.
It's not an issue for us as there is only two of us that have access to the
information.
Just my 2 cents.
Joel
- Original Message - 
From: Kostas Kalevras [EMAIL PROTECTED]
To: freeradius-users freeradius-users@lists.freeradius.org
Sent: Thursday, March 10, 2005 12:18 PM
Subject: Re: (dialupadmin) user edit not showing passwords


On Thu, 10 Mar 2005, Nick Bright wrote:
I'm storing passwords in plain text, to ease troubleshooting, and even
though I have general_show_user_password: yes in my admin.conf file, the
dialup_admin pages don't show the users' password anywhere (though I can
reset the password properly).
Hmm, the comments in admin.conf should be updated. The idea is just to be 
able to see if a user password exists (hence the corresponding comment in 
the user edit page) and to reset the value if needed. I strongly disagree 
with being able to see and edit the user password in clear text (for 
various reasons) so the above behaviour is not likely to change.
If you need to see the actual clear text password value you can do what 
was suggested and add a corresponding line in the user_edit.attrs file.

Ideally I think it should be on the show page only, my thought is to
put another row on the table in the Check Password area that would
show the password as in the database - leaving the check form, so that
a test could still be done.
If it /should/ be working, please advise what to check for as I've been
poking around for a bit, and don't see anything that would be causing it
not to work.
--
- Nick Bright
 Terraworld, Inc
 888-332-1616 x315
 http://home.terraworld.net
-
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



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


RE: Dialup Admin ?

2005-02-25 Thread Joel Eddy
I had asked a question about Dialup Admin and didn't see any replies back.
So I was wondering is this maybe not the list to ask about Dialup Admin.
If not is there a list for Dialup Admin and could someone send the link to 
it.

Thanks,
Joel 


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


Re: [radius] RE: Dialup Admin ?

2005-02-25 Thread Joel Eddy
Okay. I'll dig through and see if I can find what I'm looking for.
Thanks.

Joel- Original Message - 
From: Nick Marino [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Friday, February 25, 2005 2:26 PM
Subject: Re: [radius] RE: Dialup Admin ?


- Original Message - 
From:  Joel Eddy [EMAIL PROTECTED]
To: Free Radius Org freeradius-users@lists.freeradius.org
Sent: Friday, February 25, 2005 1:50 PM
Subject: [radius] RE: Dialup Admin ?


I had asked a question about Dialup Admin and didn't see any replies back.
So I was wondering is this maybe not the list to ask about Dialup Admin.
If not is there a list for Dialup Admin and could someone send the link 
to it.

Thanks,
Joel
Generaly yes this is the place but there is so much info in the achives 
most here expect you to look it up through the archives. They really dont 
like to repeat things here in this list.

Nick Marino - IT Solutions
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 2/22/2005
- 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 ?

2005-02-24 Thread Joel Eddy
In my dialup admin in user info I can see fields for
Name, Mail, Department, Home Phone, Work Phone Mobile Phone and Home 
Address.

I can make changes in all of them except Home Address. I loaded the userinfo 
table
with the address and I can see through the sql debug display that it checks 
the table and displays
the home address there. However it does not display it in the userinfo in 
Dialup Admin.

There must be a file in .../dialup_admin/htdocs or in .../dialup_admin/ ... 
conf  that needs
a tweak?

I worked on .../dialup_admin/htdocs/user_info.php3 enough to let me now 
input the address
data but it errors with unable to update the userinfo table.

Can someone point me to the exact file that needs tweaked.
Thanks in advance.
Joel
 Name (First Name Lastname)
 Mail
 Department
 Home Phone
 Work Phone
 Mobile Phone
 Home Address


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


Re: CHAP / PAP ?

2005-02-18 Thread Joel Eddy
Mike,
That did it. I changed the users file in /etc/raddb/
# First setup all accounts to be checked against the UNIX /etc/passwd.
# (Unless a password was already given earlier in this file).
#
DEFAULT Auth-Type = System
   Fall-Through = 1
to:
DEFAULT Auth-Type = PAP
   Fall-Through = 1
Then change in the radiusd.conf in /etc/raddb/
In the Modules section for the  PAP module
change:
pap {
   encryption_scheme = crypt
}
to:
pap {
   encryption_scheme = clear
}
This will allow the webtv receivers to authenticate with freeradius using 
PAP.
And it will still use CHAP for the PC users.

BIG THANKS to you Mike. And a BIG THANKS to you Alan
for your input also.

Joel
- Original Message - 
From: Joel Eddy [EMAIL PROTECTED]
To: Joel Eddy [EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 10:28 PM
Subject: Fw: CHAP / PAP ?


try this on freeradius to auth PAP
- Original Message - 
From: Michael Mitchell [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 17, 2005 7:06 PM
Subject: Re: CHAP / PAP ?


Hi Joel,
Yep, the default users file sets Auth-Type := System by default. The 
order, and behaviour of the modules in your 'authorize' section of 
radiusd.conf which Auth-Type is eventually used. I believe that each 
module will set the Auth-Type appropriate, *IF* the Auth-Type hasn't 
already been set...

I've never really worked out the best way to change this behaviour that 
still adheres to the intended design, and still get the results I want.

If you don't need to process the users file for authorization, you should 
be able to remove it from the 'authorize', section.

Otherwise, if you do need to process the users file, probably the easiest 
is to change the default behaviour in the users file, ie change:

#
# First setup all accounts to be checked against the UNIX /etc/passwd.
# (Unless a password was already given earlier in this file).
#
DEFAULT Auth-Type = System
   Fall-Through = 1
to:
DEFAULT Auth-Type = PAP
   Fall-Through = 1
That should still let CHAP work when specified, but will default to PAP 
if no other method of authentication has already been specified.

This is untested of course, so please report back to me if it worked or 
not...

Alan or others may want to comment on this...
regards,
Mike

  Joel Eddy [EMAIL PROTECTED] wrote:
I'm running the server that way at all times. I was reading in the 
Radius
book to run it that way so you can see the log file go by.

When I look at it says
rad_check_password: Found Auth-Type System
auth: type System
modcall[authenticate]: module unix returns notfound for request 969
modcall; group authenticate returns notfound for request 969
auth: Failed to validate user
I know I didn't set auth type to system. Or at least rather sure.
I made sure not to set that as I've seen Alan go ape if that gets set.
So I didn't want the rath of kan for setting it. ;-)

-
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: CHAP / PAP ?

2005-02-17 Thread Joel Eddy
Stupid question.
Is it possible to do CHAP for some accounts and PAP for others?
I'm using CHAP and it works great for PC users. But I have some WebTV 
receivers that
as far as I can tell only do PAP. And they aren't getting connected through
my 3COM Total Control 1000's.

Would it work it I created and seperate group for them and used encrypted 
passwords
in MySql to authenticate them?

Using Freeradius 1.0.1-1, MySql 3.23.58-9.1
Joel 

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


Re: CHAP / PAP ?

2005-02-17 Thread Joel Eddy
I'm running the server that way at all times. I was reading in the Radius 
book
to run it that way so you can see the log file go by.

When I look at it says
rad_check_password: Found Auth-Type System
auth: type System
modcall[authenticate]: module unix returns notfound for request 969
modcall; group authenticate returns notfound for request 969
auth: Failed to validate user
I know I didn't set auth type to system. Or at least rather sure.
I made sure not to set that as I've seen Alan go ape if that gets set.
So I didn't want the rath of kan for setting it. ;-)
It's got me perplexed. I'll do more reading in the Radius book.
Joel

- Original Message - 
From: Mitchell, Michael J [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 17, 2005 6:20 PM
Subject: RE: CHAP / PAP ?

Run the server in debug mode (radiusd -X) and you'll see EXACTLY why its
failing...
You need to ensure an Auth-Type is being set somewhere, sounds like it
may not be...
Also make sure your shared secret is correct. IIRC, you can have the
wrong shared secret, and CHAP will still work, but PAP wont. At least
that was my experience with NTRADPING.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Of Joel Eddy
Sent: Friday, 18 February 2005 11:15 AM
To: freeradius-users@lists.freeradius.org
Subject: Re: CHAP / PAP ?
Okay,
In MySql the passwords are in plain text.
When I use NTRADPING to check authentication it will only give
me an accept if I have the check mark in CHAP.
If I remove the check it won't authenticate.
I guess the question is do I need something special in
Radgroupreply to do PAP authentication?
Joel
-
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: CHAP / PAP ?

2005-02-17 Thread Joel Eddy
I APPRECIATE the help. If I'm understanding it correctly.
The user file in /etc/raddb is read first then it moves to MySql to get
it's information for the user if nothing matches in the user file.
As far as I can see I don't need to process the user file if I get everything
set up correctly in the MySql database.
If I use MySql to handle the process do I need to create a user table in
the radius database to process authentication?
If that would work could you or someone that has it set up
send what would be required in it or a link to a how-to.
Otherwise if it would be better to just make the changes in the user file
I could do that instead.
Sorry If I'm rambling. Just thinking out loud.
Other than that I am LOVING freeradius and dialup admin.
Just a few more small adjustments and I'll have it.
I give you much applause. Keep up the good work.
You've freed me of Microsoft forever by having this product of much
labor available.
You have my total admiration.( a little a$$ kissing here, or smoke in the 
orifice) ;-)

I can only hope and pray that I become as wise as many of
you are using Linux.
Again THANKS for the help. If I get this to work I'll be sure
to report back so the rest may benefit from it's results.
Joel
- Original Message - 
From: Alan DeKok [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 17, 2005 7:12 PM
Subject: Re: CHAP / PAP ?


Michael Mitchell [EMAIL PROTECTED] wrote:
DEFAULT Auth-Type = PAP
Fall-Through = 1
That should still let CHAP work when specified, but will default to PAP if no 
other method of authentication has already been specified.

This is untested of course, so please report back to me if it worked or 
not...

Alan or others may want to comment on this...
 It's probably a good idea.
 I'm in the process of hacking the rlm_unix module in CVS so that it
doesn't read /etc/passwd any more.  Now that we have rlm_passwd, that
module can read /etc/passwd.
 We can then have an authorize section to rlm_unix, and list it in
authorize, just like pap, chap, and mschap.  It will add a
Crypt-Password to the request, if the user is in /etc/passwd.
 Then, the users file can be updated to do Auth-Type = PAP by
default.  The PAP module will take care of figuring out how to
authenticate the user via the Crypt-Password.
 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: Dialupadmin port number

2005-02-09 Thread Joel Eddy
Here is the how to that is in dialup_admin. I followed it and I have mine up 
and running.
You may need to tweak a few things to match your install.


Joel
- Original Message - 
From: Eric Gregory [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Saturday, January 22, 2005 2:47 PM
Subject: Re: Dialupadmin port number


You need to be running a seperate webserver which serves the dial-up admin
pages, set the web server to whatever port you like
Eric
On Saturday 22 January 2005 21:44, Ed Engelking II wrote:
I'm new to FreeRadius.  I've recently setup a FreeRadius server,
noting that ports 1645, 1812, and 1813 were in use.  Based on the
information that I've read thus far, dialupadmin is included with
FreeRadius, but I'm stumped on how to access the Web interface.  I've
directed the Web browser at all the listed ports above to no success.
I've googled for the port number, and have gone over the FAQ and
installation information several times to determine if I've missed
anything.  Am I just overlooking something very obvious?
Any help on this matter would be greately appreciated.
--Ed
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html


Dialup Admin HOWTO 
--

Version 0.1 Sun Oct 26 04:03:00 EET 2003
1. Installation
1.1 Obtaining Dialup Admin
1.2 Prerequisities
1.3 Installing  System Configuration
1.3.1 Unpacking  Installation
1.3.2 Apache Configuration
1.3.2.1 Enabling PHP Support On Apache
1.3.2.2 Creating a more secure web interface
1.3.3 Creating the mySQL Tables
2. Configuration
	2.1 Configuration Options
		2.1.1 General Options 
		2.1.2 Realms Options
		2.1.3 LDAP/SQL Options
		2.1.4 NAS Quering
		2.1.5 Test Variables
		2.1.6 Encryption Methods
		2.1.7 NAS Informations
		2.1.8 LDAP Options
		2.1.9 SQL Options
		2.1.10 Limits Timers
		2.1.11 Various Options
	2.2 The bin/ scripts
		2.2.1 The snmpfinger script
		2.2.2 The log_badlogins script
		2.2.3 The clean_radacct script
		2.2.4 The truncate_radacct script
		2.2.5 The tot_stats script
		2.2.6 The monthly_tot_stats script
	2.3 User Attributes
	2.4 Finishing Off

3. Troubleshooting
	3.1 When I try to access some page I see the php code instead of html
	3.2 When an attribute contains double () or single (') quotes 
	something goes wrong
	3.3 Even though I have uncommented Dialup-Access in user_edits.attrs,
	when editing a user, that field is not available...
	3.4 Why do the personal information fields show multiple entries for 
	attributes like name, department, etc in the user_admin page?
	3.5 After I make a few changes in one of the configuration files 
	things only work like they worked before
	3.6 It is still not working

4. HOWTO Information
1. Installation
---
This section will take you step by step to create system suitable for 
dialup admin to run properly.

[1.1] Obtaining Dialup Admin
There are three ways to obtain the dialup admin package. 

Either download the latest FreeRadius package which most likely contains
the latest dialup admin available. The FreeRadius Package can be obtained 
through ftp://ftp.freeradius.org/pub/radius/freeradius-0.9.2.tar.gz 
which is the current FreeRadius package at the time of writting.

Dialup Admin has it's own web page hosted at Sourceforge at 
http://sourceforge.net/projects/dialup-admin/
Though that page is not updated very often. The primary store for dialupadmin
is the freeradius CVS tree so the latest version will always be contained there

Finally one could get the cvs version of Dialup Admin by issuing the 
following commands:

shell cvs -d:pserver:[EMAIL PROTECTED]:/cvsroot/dialup-admin login 

* When prompted for a password simply press the Enter Key
shell cvs -z3 -d:pserver:[EMAIL PROTECTED]:/cvsroot/dialup-admin co 
dialup_admin
[1.2] Prerequisities
Dialup Admin requires the following in order to have full functionality:
o PHP   Obtained at: http://www.php.net
o Date::Manip Perl Module   Obtained at: http://www.cise.ufl.edu/~sbeck/
[1.3] Installing  System Configuration
At this point we presume that either you have successfully installed PHP and 
Date::Manip Perl Module or that your distribution has came with both of them 
precompiled and already installed.

[1.3.1] Unpacking and installation
In order to install the dialup admin first of all the package must be 
uncompressed presuming that we have it in a .tar.gz format and be placed
at a certain directory at the system 
(Could be anything, we use /usr/local/dialup_admin)

shell tar xfvz dialup_admin-X.XX.tar.gz
shell mv dialup_admin /usr/local
The dialup admin contains a number of directories necessary for the program 
to operate. Let's concentrate on the htdocs directory. This directory
contains the php scripts needed. In 

RE: Dialip_admin ?

2005-02-03 Thread Joel Eddy
Could someone give me a link to a howto and faq on dialup_admin?
Having issues with the page displaying correctly on apache 2.0 with MySql 
3.23.58-9.1
left column is html markup only. No buttons or anything.

I've installed by the howto in dialup_admin. But need help finishing up.
Joel

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


Re: Dialip_admin ?

2005-02-03 Thread Joel Eddy
Thanks for the tip. I think that is it. I can see the info with
test.php. But see nothing but text if I use php3.
I'll look into apache then.
Again thanks for the info. ;-)
Joel
- Original Message - 
From: Morgan Nelson [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 03, 2005 10:16 AM
Subject: Re: Dialip_admin ?


Joel Eddy wrote:
 Could someone give me a link to a howto and faq on dialup_admin?
 Having issues with the page displaying correctly on apache 2.0 with
 MySql 3.23.58-9.1 left column is html markup only. No buttons or
 anything.
 I've installed by the howto in dialup_admin. But need help
 finishing up.
 Joel

 - List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
The problem you are seeing is most likely not a dialup admin problem,
but an apache/php config problem.
Make sure you have mod_php installed and working in your apache
install.  To test php, make a file named test.php with only this in it:
---cut---
?php
  phpinfo();
?
---cut---
put that in your webserver html dir, and try to view it from a web
browser.  You should see a bunch of tables describing your php
install.  If you see only the text, something is very wrong with your
mod_php install, or apache config.  Check with the php website to fix
this. (http://www.php.net)
If that works, try renaming the file to test.php3 and see if it
still works.  Dialup admin still uses (for historical reasons,
according to the dialup admin README file) the .php3 extension, which
may or may not be mapped to php in your installation.  Again, refer to
the php website to add a handler in apache for .php3 files.
hope this helps...
Morgan
- 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: Dialip_admin ?

2005-02-03 Thread Joel Eddy
FYI, for anyone else running Apache 2.0, MySql 3.23.58-9.1 with modules for 
php4
and the left column in dialup_admin is nothing but text, here is the fix 
that I had to do.
cd to the /etc/httpd/conf.d and with your favorite text editor open the file 
php.conf and
add this line under AddType

AddType application/x-httpd-php .php
AddType application/x-httpd-php .php3  New line
Save the file and restart apache. You should now see the left column.
I hope this helps someone.
Joel
- Original Message - 
From:  Joel Eddy [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 03, 2005 12:23 PM
Subject: Re: Dialip_admin ?


Thanks for the tip. I think that is it. I can see the info with
test.php. But see nothing but text if I use php3.
I'll look into apache then.
Again thanks for the info. ;-)
Joel
- Original Message - 
From: Morgan Nelson [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Thursday, February 03, 2005 10:16 AM
Subject: Re: Dialip_admin ?


Joel Eddy wrote:
 Could someone give me a link to a howto and faq on dialup_admin?
 Having issues with the page displaying correctly on apache 2.0 with
 MySql 3.23.58-9.1 left column is html markup only. No buttons or
 anything.
 I've installed by the howto in dialup_admin. But need help
 finishing up.
 Joel

 - List info/subscribe/unsubscribe? See
 http://www.freeradius.org/list/users.html
The problem you are seeing is most likely not a dialup admin problem,
but an apache/php config problem.
Make sure you have mod_php installed and working in your apache
install.  To test php, make a file named test.php with only this in it:
---cut---
?php
  phpinfo();
?
---cut---
put that in your webserver html dir, and try to view it from a web
browser.  You should see a bunch of tables describing your php
install.  If you see only the text, something is very wrong with your
mod_php install, or apache config.  Check with the php website to fix
this. (http://www.php.net)
If that works, try renaming the file to test.php3 and see if it
still works.  Dialup admin still uses (for historical reasons,
according to the dialup admin README file) the .php3 extension, which
may or may not be mapped to php in your installation.  Again, refer to
the php website to add a handler in apache for .php3 files.
hope this helps...
Morgan
- 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

2005-02-02 Thread Joel Eddy
I'm setting up dialupadmin. I get in the left had column nothing but
php code
Why, and could someone point me in the direction to correct it.
?php
$auth_user = $HTTP_SERVER_VARS[PHP_AUTH_USER];
if ($auth_user){
if (is_file(../html/buttons/$auth_user/buttons.html.php3))
include(../html/buttons/$auth_user/buttons.html.php3);
else{
if (is_file(../html/buttons/default/buttons.html.php3))
include(../html/buttons/default/buttons.html.php3);
}
}
else{   
if (is_file(../html/buttons/default/buttons.html.php3))
include(../html/buttons/default/buttons.html.php3);
}
?
Joel

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


Re: RE: mysql ?

2005-01-26 Thread Joel Eddy
Thanks for the info. Does someone know what it's purpose in life is? I've 
got the Radius book by O'Reilly
and there is no metnion of it.


Joel
- Original Message - 
From: [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Tuesday, January 25, 2005 9:50 PM
Subject: Re: RE: mysql ?

I have zero 0 in mine...
and all works well.

 Original Message 
== From:  Joel Eddy [EMAIL PROTECTED]
== Date: Tue, 25 Jan 2005 17:41:21 -0600
I hate to be the one that asks the stupid question of the day but
here goes. In the Table radgroupreply in database radius what goes in
the prio entry?
Joel
- 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: RE: mysql ?

2005-01-26 Thread Joel Eddy
If they are set to 0 would that then not return them back to the nas?
Joel
- Original Message - 
From: Cris Boisvert [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Wednesday, January 26, 2005 9:39 AM
Subject: RE: RE: mysql ?


I think its for priority of the response..
Some attributes need to be given back in sequence or they won't work
Ascend data filters are one of them..
So you can set the prio to be 0,1,2,3,4,5,6 etc
As you want the to be given back to the nas...
I may be wrong if so someone please correct me..
Thanx
Cris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joel 
Eddy
Sent: Wednesday, January 26, 2005 10:27 AM
To: freeradius-users@lists.freeradius.org
Subject: Re: RE: mysql ?

Thanks for the info. Does someone know what it's purpose in life is? I've
got the Radius book by O'Reilly
and there is no metnion of it.

Joel
- Original Message - 
From: [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Tuesday, January 25, 2005 9:50 PM
Subject: Re: RE: mysql ?

I have zero 0 in mine...
and all works well.

 Original Message 
== From:  Joel Eddy [EMAIL PROTECTED]
== Date: Tue, 25 Jan 2005 17:41:21 -0600
I hate to be the one that asks the stupid question of the day but
here goes. In the Table radgroupreply in database radius what goes in
the prio entry?
Joel
- 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
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.1 - Release Date: 1/19/2005
--
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.7.1 - Release Date: 1/19/2005

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



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


Simultaneous use

2005-01-26 Thread Joel Eddy
Where in the MySql database do I put the simultaneous use entry? So
there is only one use permitted.
Joel

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


RE: mysql ?

2005-01-25 Thread Joel Eddy
I hate to be the one that asks the stupid question of the day but here goes.
In the Table radgroupreply in database radius what goes in
the prio entry?
Joel
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: web interface

2004-06-17 Thread Joel Eddy
webmin

url http://www.webmin.com


Sincerely,

Joel Eddy
Iowa Connect, Inc.
http://www.iowaconnect.com
Ph. 641-456-5964
Fax 641-456-5912

- Original Message - 
From: Marco Marques [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 4:22 PM
Subject: web interface


 Hello all ,

 I am using freeradius with mysql , is there any web interface that i can
 use to add and delete ( manage ) the user accounts in the sql server?

 Best regards


 Marco

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



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