Nevermind, I read the docs a 4th time and figured it out! thx
Regards, Evan S. Weiner Systems Engineer & Support Team Leader Venture Networking Services / Velocity IP 501 East Franklin Street Suite 414 Richmond, Virginia 23219 VNS: (804) 521-4208 Direct: (804) 521-4213 Fax: (804) 521-4008 E-Mail: [EMAIL PROTECTED] -----Original Message----- From: Evan Weiner Sent: Sunday, February 02, 2003 10:15 PM To: [EMAIL PROTECTED] Subject: RE: sql issues Alan, When I start freeradius, the log shows it connecting fine...I 'broke' the config and changed the password to something other than what it really is...here's what the log spit out... Info: Reloading configuration files. Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Info: rlm_sql (sql): Attempting to connect to radius@arbra-lo:/radius Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Error: rlm_sql_mysql: Couldn't connect socket to MySQL server radius@arbra-lo:radius Error: rlm_sql_mysql: Mysql error 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' Error: rlm_sql (sql): Failed to connect DB handle #0 Info: Ready to process requests. When I set it properly, it connects without problem... When I initially set up freeradius, I followed this doc... http://www.frontios.com/freeradius.html. It specifically says to add sql into the 'authenticate' section, but when I do this, freeRADIUS errors out... Error: radiusd.conf: "SQL" modules aren't allowed in 'authenticate' sections -- they have no such method. And FreeRADIUS does NOT load. When I put simply comment 'unix' out in the 'authenticate' section, it denies everything, because there is no where to authenticate it... Can you give me some guidance about where I am going wrong? Regards, Evan S. Weiner Systems Engineer & Support Team Leader Venture Networking Services / Velocity IP 501 East Franklin Street Suite 414 Richmond, Virginia 23219 VNS: (804) 521-4208 Direct: (804) 521-4213 Fax: (804) 521-4008 E-Mail: [EMAIL PROTECTED] -----Original Message----- From: Alan DeKok [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 02, 2003 4:01 PM To: [EMAIL PROTECTED] Subject: Re: sql issues "Evan Weiner" <[EMAIL PROTECTED]> wrote: > I'm having some trouble getting FreeRadius working with MySQL. > Everything loads fine, but then when I try to do a test query against > the radius server, the client returns a timeout. The pertinent part > from the radius logfile is... > > Fri Jan 31 12:58:39 2003 : Error: Discarding new request from client > vnsinternal:59204 - ID: 13 due to live request 42 > Fri Jan 31 12:58:39 2003 : Error: rlm_sql_getvpdata: database query > error > Fri Jan 31 12:58:39 2003 : Error: rlm_sql (sql): SQL query error; > rejecting user Your SQL database doesn't work. That's what the error messages mean. > Can anyone help me? Make sure your SQL database works. Make sure that it responds to the requests from FreeRADIUS. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
