RE: Expiration date on users utilizing freeradius and mysql
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
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
Freeradius and MySql
Good morning. I am trying to install Free Radius with MySql, but I either have a login issue or a permissions issue. I have added Radius and [EMAIL PROTECTED] to database, Fedora local users and just about everywhere I can think possible. I have added permissions for radius radius local to databases mysql and database radius. However, when I try to log in to mysql using the command mysql -u radius -p radius, I get and error stating, Error 1045 (28000): Access Denied for user 'radius'@'localhost' (using:Password: YES). I am really frustrated since I have been working on this login and permission issue for some time. Thanks mailto:[EMAIL PROTECTED]
RE: Freeradius and MySql
* a) Verify that you have actually GRANTED permission for the account you are trying to authenticate with SELECT user, host from mysql.user where user ='radius'; mysql SELECT user, host from mysql.user where user ='radius'; ++---+ | user | host | ++---+ | radius | % | | radius | localhost | ++---+ 2 rows in set (0.00 sec) SHOW GRANTS FOR 'user'@'host'; mysql SHOW GRANTS FOR 'radius'@'localhost'; ++ | Grants for [EMAIL PROTECTED]| ++ | GRANT USAGE ON *.* TO 'radius'@'localhost' | | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' | ++ 2 rows in set (0.00 sec) As you can see, it looks like I have granted permissions to the user, [EMAIL PROTECTED] for db radius. I am not sure what to do next. Thanks Dwane From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 9:51 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: Re: Freeradius and MySql Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM: Good morning. I am trying to install Free Radius with MySql, but I either have a login issue or a permissions issue. I have added Radius and [EMAIL PROTECTED] to database, Fedora local users and just about everywhere I can think possible. I have added permissions for radius radius local to databases mysql and database radius. However, when I try to log in to mysql using the command mysql -u radius -p radius, I get and error stating, Error 1045 (28000): Access Denied for user 'radius'@'localhost' (using:Password: YES). I am really frustrated since I have been working on this login and permission issue for some time. Thanks mailto:[EMAIL PROTECTED] Try this: a) Verify that you have actually GRANTED permission for the account you are trying to authenticate with SELECT user, host from mysql.user where user ='radius'; Then for each user-host combination listed above do one of these and compare the privileges listed to those you expected the accounts to have. SHOW GRANTS FOR 'user'@'host'; b) if the records exist but aren't being respected, issue a FLUSH PRIVILEGES command. I have noticed that (in contradiction to the documentation) that you sometimes need to manually refresh the privilege cache even after using a GRANT or REVOKE command. If those don't get you started, come back with whatever new information you learn and we can try something else. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: Freeradius and MySql
I did do a FLUSH PRIVILEGES and this still resulted in the same error. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:31 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: RE: Freeradius and MySql You could try suggestion B) ;-) Shawn Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24 AM: * a) Verify that you have actually GRANTED permission for the account you are trying to authenticate with SELECT user, host from mysql.user where user ='radius'; mysql SELECT user, host from mysql.user where user ='radius'; ++---+ | user | host | ++---+ | radius | % | | radius | localhost | ++---+ 2 rows in set (0.00 sec) SHOW GRANTS FOR 'user'@'host'; mysql SHOW GRANTS FOR 'radius'@'localhost'; ++ | Grants for [EMAIL PROTECTED]| ++ | GRANT USAGE ON *.* TO 'radius'@'localhost' | | GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' | ++ 2 rows in set (0.00 sec) As you can see, it looks like I have granted permissions to the user, [EMAIL PROTECTED] for db radius. I am not sure what to do next. Thanks Dwane From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 9:51 AM To: Atkins, Dwane P Cc: mysql@lists.mysql.com Subject: Re: Freeradius and MySql Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57 AM: Good morning. I am trying to install Free Radius with MySql, but I either have a login issue or a permissions issue. I have added Radius and [EMAIL PROTECTED] to database, Fedora local users and just about everywhere I can think possible. I have added permissions for radius radius local to databases mysql and database radius. However, when I try to log in to mysql using the command mysql -u radius -p radius, I get and error stating, Error 1045 (28000): Access Denied for user 'radius'@'localhost' (using:Password: YES). I am really frustrated since I have been working on this login and permission issue for some time. Thanks mailto:[EMAIL PROTECTED] Try this: a) Verify that you have actually GRANTED permission for the account you are trying to authenticate with SELECT user, host from mysql.user where user ='radius'; Then for each user-host combination listed above do one of these and compare the privileges listed to those you expected the accounts to have. SHOW GRANTS FOR 'user'@'host'; b) if the records exist but aren't being respected, issue a FLUSH PRIVILEGES command. I have noticed that (in contradiction to the documentation) that you sometimes need to manually refresh the privilege cache even after using a GRANT or REVOKE command. If those don't get you started, come back with whatever new information you learn and we can try something else. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
RE: Freeradius and MySql
I didn't encrypt and that was going to be my next questions. How do I
do that?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you
create the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that
pretty easily
UPDATE mysql.user
SET `password`=PASSWORD('plain-text-of-password')
WHERE user='radius';
FLUSH PRIVILEGES;
Then try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:30:41 AM:
I did do a FLUSH PRIVILEGES and this still resulted in the same error.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:31 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
You could try suggestion B) ;-)
Shawn
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24
AM:
* a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
mysql SELECT user, host from mysql.user where user ='radius';
++---+
| user | host |
++---+
| radius | % |
| radius | localhost |
++---+
2 rows in set (0.00 sec)
SHOW GRANTS FOR 'user'@'host';
mysql SHOW GRANTS FOR 'radius'@'localhost';
++
| Grants for [EMAIL PROTECTED]|
++
| GRANT USAGE ON *.* TO 'radius'@'localhost' |
| GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
++
2 rows in set (0.00 sec)
As you can see, it looks like I have granted permissions to the
user,
[EMAIL PROTECTED] for db radius. I am not sure what to do next.
Thanks
Dwane
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 9:51 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: Re: Freeradius and MySql
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
AM:
Good morning. I am trying to install Free Radius with MySql, but
I
either have a login issue or a permissions issue.
I have added Radius and [EMAIL PROTECTED] to database, Fedora local
users
and just about everywhere I can think possible. I have added
permissions for radius radius local to databases mysql and
database
radius. However, when I try to log in to mysql using the command
mysql
-u radius -p radius, I get and error stating, Error 1045 (28000):
Access Denied for user 'radius'@'localhost' (using:Password: YES).
I
am
really frustrated since I have been working on this login and
permission
issue for some time.
Thanks
mailto:[EMAIL PROTECTED]
Try this:
a) Verify that you have actually GRANTED permission for the account
you
are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
Then for each user-host combination listed above do one of these and
compare the privileges listed to those you expected the accounts to
have.
SHOW GRANTS FOR 'user'@'host';
b) if the records exist but aren't being respected, issue a FLUSH
PRIVILEGES command. I have noticed that (in contradiction to the
documentation) that you sometimes need to manually refresh the
privilege
cache even after using a GRANT or REVOKE command.
If those don't get you started, come back with whatever new
information
you learn and we can try something else.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
RE: Freeradius and MySql
Shawn,
Thanks. That has done the trick. It turns out that I had passwords
hashed for [EMAIL PROTECTED], but not [EMAIL PROTECTED] Resetting the password
and flushing the privilege has really helped. Guess what, you have done
in 20 minutes what myself and other could not do in a week.
Dwane
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:45 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
OK, make sure you are using the correct password, too. Did you remember
to encrypt the password with PASSWORD() or OLD_PASSWORD() when you
create the account?
SELECT user, host, password
FROM mysql.user
WHERE user='radius';
make sure your password is hashed, if not we can help you fix that
pretty easily
UPDATE mysql.user
SET `password`=PASSWORD('plain-text-of-password')
WHERE user='radius';
FLUSH PRIVILEGES;
Then try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:30:41 AM:
I did do a FLUSH PRIVILEGES and this still resulted in the same error.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 10:31 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: RE: Freeradius and MySql
You could try suggestion B) ;-)
Shawn
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 11:25:24
AM:
* a) Verify that you have actually GRANTED permission for the
account you are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
mysql SELECT user, host from mysql.user where user ='radius';
++---+
| user | host |
++---+
| radius | % |
| radius | localhost |
++---+
2 rows in set (0.00 sec)
SHOW GRANTS FOR 'user'@'host';
mysql SHOW GRANTS FOR 'radius'@'localhost';
++
| Grants for [EMAIL PROTECTED]|
++
| GRANT USAGE ON *.* TO 'radius'@'localhost' |
| GRANT ALL PRIVILEGES ON `radius`.* TO 'radius'@'localhost' |
++
2 rows in set (0.00 sec)
As you can see, it looks like I have granted permissions to the
user,
[EMAIL PROTECTED] for db radius. I am not sure what to do next.
Thanks
Dwane
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 9:51 AM
To: Atkins, Dwane P
Cc: mysql@lists.mysql.com
Subject: Re: Freeradius and MySql
Atkins, Dwane P [EMAIL PROTECTED] wrote on 03/23/2006 10:38:57
AM:
Good morning. I am trying to install Free Radius with MySql, but
I
either have a login issue or a permissions issue.
I have added Radius and [EMAIL PROTECTED] to database, Fedora local
users
and just about everywhere I can think possible. I have added
permissions for radius radius local to databases mysql and
database
radius. However, when I try to log in to mysql using the command
mysql
-u radius -p radius, I get and error stating, Error 1045 (28000):
Access Denied for user 'radius'@'localhost' (using:Password: YES).
I
am
really frustrated since I have been working on this login and
permission
issue for some time.
Thanks
mailto:[EMAIL PROTECTED]
Try this:
a) Verify that you have actually GRANTED permission for the account
you
are trying to authenticate with
SELECT user, host from mysql.user where user ='radius';
Then for each user-host combination listed above do one of these and
compare the privileges listed to those you expected the accounts to
have.
SHOW GRANTS FOR 'user'@'host';
b) if the records exist but aren't being respected, issue a FLUSH
PRIVILEGES command. I have noticed that (in contradiction to the
documentation) that you sometimes need to manually refresh the
privilege
cache even after using a GRANT or REVOKE command.
If those don't get you started, come back with whatever new
information
you learn and we can try something else.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
