I'm getting the following error in the radius log and don't know how to handle it. I assume it's handled somewhere within the radius.conf file but I can't find anything about it. Sun Dec 25 09:28:07 2005 : Error: rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session" Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): Error getting data from database Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): SQL query error; rejecting user I'm a newbie to all this and am stumbling along :) -- LeRoy & Dorothy Location: http://map.datastormusers.com/user2.cfm?user=1591 My Web Page: http://www.rvfulltimer.com
Zitat von LeRoy DeVries <dutch1918@gmail.com>:
I'm getting the following error in the radius log and don't know how to handle it. I assume it's handled somewhere within the radius.conf file but I can't find anything about it.
Sun Dec 25 09:28:07 2005 : Error: rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session" add a line to your dictionary file (on suse: /etc/raddb/dictionary): ATTRIBUTE Max-All-Session 3000 integer
Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): Error getting data from database are you sure you set the correct variables in sql.conf, e.g. user who is allowd to connect to sql db and password? an example:
sql { server = "localhost" login = "radiusd" password "donttellanyone" }
Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): SQL query error; rejecting user
I'm a newbie to all this and am stumbling along :)
-- LeRoy & Dorothy Location: http://map.datastormusers.com/user2.cfm?user=1591 My Web Page: http://www.rvfulltimer.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
regards markus -- Markus Krause email: krause@biochem.mpg.de Computing Center Tel.: 089 - 89 40 85 99 Group Lottspeich / Proteomics Fax.: 089 - 89 40 85 98 --------------------------------------------------------------------- This message was sent using https://webmail.biochem.mpg.de If you encounter any problems please report to rz-linux@biochem.mpg.de
On Monday 26 December 2005 06:15, Markus Krause wrote:
Zitat von LeRoy DeVries <dutch1918@gmail.com>:
I'm getting the following error in the radius log and don't know how to handle it. I assume it's handled somewhere within the radius.conf file but I can't find anything about it.
Sun Dec 25 09:28:07 2005 : Error: rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session"
add a line to your dictionary file (on suse: /etc/raddb/dictionary): ATTRIBUTE Max-All-Session 3000 integer
Thanks Markus... Now I'm getting the following Mon Dec 26 08:13:56 2005 : Error: radiusd.conf: "SQL" modules aren't allowed in 'authenticate' sections -- they have no such method. If I remove the sql from that section it doesn't complain. How does sql handle this. Also as a side note, I tried logging on using a wireless client and the loggin in "failed" both on the sql ( database is populated) and USERS (uncommented "steve") but I can't find any logs on why. FWIW I am using Chillispot for a captive portal which uses a SSL web interface for the radius server which I config to use sql database and the USERS file. The database was made from phpMyPrepaid.
LeRoy DeVries <dutch1918@gmail.com> wrote:
Mon Dec 26 08:13:56 2005 : Error: radiusd.conf: "SQL" modules aren't allowed in 'authenticate' sections -- they have no such method.
Why did you put it there?
If I remove the sql from that section it doesn't complain. How does sql handle this. Also as a side note, I tried logging on using a wireless client and the loggin in "failed" both on the sql ( database is populated) and USERS (uncommented "steve") but I can't find any logs on why.
Try running the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list. Honestly, I just don't understand why it's so hard to do that. Alan DeKok.
On Monday 26 December 2005 09:38, Alan DeKok wrote:
Try running the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list.
Honestly, I just don't understand why it's so hard to do that.
Alan DeKok.
Sorry I just could not find any info on that. After doing a google search I finnaly found it and how to place in debug mode. Now I why it is failing... rlm_sqlcounter: Entering module authorize code Segmentation fault Now to find out how to fix it. :) LeRoy
On Monday 26 December 2005 10:12, LeRoy DeVries wrote:
On Monday 26 December 2005 09:38, Alan DeKok wrote:
Try running the server in debugging mode, as suggested in the FAQ, README, INSTALL, and daily on this list.
Honestly, I just don't understand why it's so hard to do that.
Alan DeKok.
Sorry I just could not find any info on that. After doing a google search I finnaly found it and how to place in debug mode.
Now I why it is failing...
rlm_sqlcounter: Entering module authorize code Segmentation fault
Now to find out how to fix it. :)
I found the error and corrected it. I forgot to add the query. LeRoy
LeRoy DeVries wrote:
I'm getting the following error in the radius log and don't know how to handle it. I assume it's handled somewhere within the radius.conf file but I can't find anything about it.
Sun Dec 25 09:28:07 2005 : Error: rlm_sql: Failed to create the pair: Unknown attribute "Max-All-Session" Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): Error getting data from database Sun Dec 25 09:28:07 2005 : Error: rlm_sql (sql): SQL query error; rejecting user
I'm a newbie to all this and am stumbling along :)
You need to check that the dictionary that contains the attribute mentioned is included in /etc/raddb/dictionary or wherever your radius.conf lists it. Follow the syntax in that file to include it. -- Lewis Bergman Texas Communications 4309 Maple St. Abilene, TX 79602-8044 Off. 325-691-1301 Cell 325-439-0533 fax 325-695-6841
participants (4)
-
Alan DeKok -
LeRoy DeVries -
Lewis Bergman -
Markus Krause