RE: Expiration date on users utilizing freeradius and mysql

2006-03-30 Thread Atkins, Dwane P
I submitted this yesterday and was not sure if maybe it did not get out
to folks.  How would I put an expiration date on a mysql field so that
it would match a radius entry?

Also, is there a way that I can call up a web based screen and have all
the information at my fingertips for inputting user data?

Thanks

Dwane

-Original Message-
From: Atkins, Dwane P [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 29, 2006 10:59 AM
To: mysql@lists.mysql.com
Subject: Expiration date on users utilizing freeradius and mysql

I am using freeradius with MySql and what I would like to do is create
in my radius table an user with attributes stating a start and stop
date.

 

I would like to be able to do a bulk entry (more than 1 at a time) or
would love for this to be web based.  


Is this process out there?


Thanks

Dwane

 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: Expiration date on users utilizing freeradius and mysql

2006-03-30 Thread SGreen
We got the question. However what you ask isn't purely a database issue. 

How does your authentication program (freeradius?) handle expiration 
dates? If it doesn't then adding those to the database won't help a bit. 
If it does, then there should already be a date column. (or two) in the 
appropriate table(s). 

Either way, the change(s) you want to make are more in the realm of 
programming than database administration.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/30/2006 09:17:26 AM:

 I submitted this yesterday and was not sure if maybe it did not get out
 to folks.  How would I put an expiration date on a mysql field so that
 it would match a radius entry?
 
 Also, is there a way that I can call up a web based screen and have all
 the information at my fingertips for inputting user data?
 
 Thanks
 
 Dwane
 
 -Original Message-
 From: Atkins, Dwane P [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, March 29, 2006 10:59 AM
 To: mysql@lists.mysql.com
 Subject: Expiration date on users utilizing freeradius and mysql
 
 I am using freeradius with MySql and what I would like to do is create
 in my radius table an user with attributes stating a start and stop
 date.
 
 
 
 I would like to be able to do a bulk entry (more than 1 at a time) or
 would love for this to be web based. 
 
 
 Is this process out there?
 
 
 Thanks
 
 Dwane
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 


Expiration date on users utilizing freeradius and mysql

2006-03-29 Thread Atkins, Dwane P
I am using freeradius with MySql and what I would like to do is create
in my radius table an user with attributes stating a start and stop
date.

 

I would like to be able to do a bulk entry (more than 1 at a time) or
would love for this to be web based.  


Is this process out there?


Thanks

Dwane