Add new comment

Want to support HowtoForge? Become a subscriber!
Submitted by Anonymous (not registered) on Mon, 2009-03-23 08:40.

  installed but testing Access-Reject

root@Ubuntu804:/var/log/freeradius# more radius.log
Mon Mar 23 14:23:44 2009 : Info: Using deprecated naslist file.  Support for this will go away soon.
Mon Mar 23 14:23:44 2009 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Mon Mar 23 14:23:44 2009 : Info: Ready to process requests.
Mon Mar 23 15:12:18 2009 : Info: Using deprecated naslist file.  Support for this will go away soon.
Mon Mar 23 15:12:18 2009 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Mon Mar 23 15:12:19 2009 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Mon Mar 23 15:12:19 2009 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/radius
Mon Mar 23 15:12:19 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Mon Mar 23 15:12:19 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Mon Mar 23 15:12:19 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Mon Mar 23 15:12:19 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Mon Mar 23 15:12:19 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Mon Mar 23 15:12:19 2009 : Info: Ready to process requests.
Mon Mar 23 15:14:40 2009 : Info: Using deprecated naslist file.  Support for this will go away soon.
Mon Mar 23 15:14:40 2009 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Mon Mar 23 15:14:40 2009 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Mon Mar 23 15:14:40 2009 : Info: rlm_sql (sql): Attempting to connect to root@localhost:/radius
Mon Mar 23 15:14:40 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Mon Mar 23 15:14:40 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Mon Mar 23 15:14:40 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Mon Mar 23 15:14:40 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Mon Mar 23 15:14:40 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Mon Mar 23 15:14:41 2009 : Info: Ready to process requests.
Mon Mar 23 15:23:29 2009 : Info: Using deprecated naslist file.  Support for this will go away soon.
Mon Mar 23 15:23:29 2009 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Mon Mar 23 15:23:29 2009 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
Mon Mar 23 15:23:29 2009 : Info: rlm_sql (sql): Attempting to connect to radius@localhost:/radius
Mon Mar 23 15:23:29 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Mon Mar 23 15:23:29 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Mon Mar 23 15:23:29 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Mon Mar 23 15:23:29 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Mon Mar 23 15:23:29 2009 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Mon Mar 23 15:23:29 2009 : Info: Ready to process requests.
root@Ubuntu804:/var/log/freeradius# radtest sqltest testpwd localhost 1812 testing123
Sending Access-Request of id 50 to 127.0.0.1 port 1812
        User-Name = "sqltest"
        User-Password = "testpwd"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
Re-sending Access-Request of id 50 to 127.0.0.1 port 1812
        User-Name = "sqltest"
        User-Password = "testpwd"
        NAS-IP-Address = 255.255.255.255
        NAS-Port = 1812
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=50, length=20
root@Ubuntu804:/var/log/freeradius#

 

root@Ubuntu804:/var/log/freeradius# mysql -u radius -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use radius;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from radcheck;
+----+----------+-----------+----+---------+
| id | UserName | Attribute | op | Value   |
+----+----------+-----------+----+---------+
|  1 | sqltest  | password  | == | testpwd |
+----+----------+-----------+----+---------+
1 row in set (0.00 sec)

mysql>
 

Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.

Reply

*
*
The content of this field is kept private and will not be shown publicly.


*

  • Images can be added to this post.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <div>
  • Lines and paragraphs break automatically.