this is my second email, i would like you give me the information that i need
 
i have an error log in my radius system (FR 0.8.1 with MySQL)

[root@radius raddb]# tail -f /var/log/radius/radius.log
Mon Feb 17 14:04:58 2003 : Info: Ready to process requests.
Mon Feb 17 14:05:54 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:07:03 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:08:11 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:08:53 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:09:37 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:09:42 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:09:56 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:10:24 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:11:01 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:14:39 2003 : Error: rlm_sql_getvpdata: database query error
Mon Feb 17 14:14:45 2003 : Error: rlm_sql_getvpdata: database query error

what is about an error ?
i see that this code generated from sql.c

i have checked my database and i think there isn't something wrong.
 
my table looks like :
 
radcheck
+-----+-----------------+--------------------+----+------------------------------------------------------+
| id  | username        | attribute          | op | value                                          |
+-----+-----------------+--------------------+----+------------------------------------------------------+
|   1 | 5612800@isp | User-Password      | == | xxxYYY                       |
|  2 | 5670262@isp | User-Password      | == | YYYxxx                        |
+-----+-----------------+--------------------+----+------------------------------------------------------+
4 rows in set (0.00 sec)
radgroupcheck
+----+-----------+-------------------+----+-----------------------+
| id | groupname | attribute         | op | value                 |
+----+-----------+-------------------+----+-----------------------+
|  1 | isp    | Framed-Protocol   | == | PPP                   |
|  2 | isp    | Service-Type      | == | Framed-User           |
+----+-----------+-------------------+----+-----------------------+

radgroupreply
+----+-----------+-----------------------+----+---------------------+
| id | groupname | attribute             | op | value               |
+----+-----------+-----------------------+----+---------------------+
|  1 | isp    | Framed-Compression    | == | Van-Jacobson-TCP-IP |
|  2 | isp    | Framed-MTU            | == | 1400                |
|  3 | isp    | Framed-Protocol       | == | PPP                 |
|  4 | isp    | MS-Primary-DNS-Server | == | 202.134.1.10        |
+----+-----------+-----------------------+----+---------------------+
i don't use radreply table, i have a big log file which be got from accessing user in logging and disconnecting user.
two error records from one accessing user ("Error: rlm_sql_getvpdata: database query error")
but user don't have an error and have successfully access.
 
is this error a seriously problem and can decrease radius performance ?
 
thank you,
 
eDoS

Reply via email to