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]
RE: Expiration date on users utilizing freeradius and mysql
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
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
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
* 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
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 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
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
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