I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe
Now I do not have that error, I started radiusd -x end: Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing ! ----- Original Message ----- From: Giuseppe Parlato To: FreeRadius users mailing list Sent: Friday, May 19, 2006 7:01 PM Subject: rlm_sql_getvpdata: database query error I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe ------------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
No access-requests are making it to your radius server then. You need to make sure your client is pointed at it properly or that you don't have your radius server firewalled. Chris Carver Network Engineer Giuseppe Parlato wrote:
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/Bill> rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing !
----- Original Message -----
*From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:01 PM *Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error
can anyone help me please?
Giuseppe
------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
It is an upgrade, so firewall can't be the problem Giuseppe ----- Original Message ----- From: "Chris Carver" <ccarver@pennswoods.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, May 19, 2006 8:28 PM Subject: Re: rlm_sql_getvpdata: database query error
No access-requests are making it to your radius server then. You need to make sure your client is pointed at it properly or that you don't have your radius server firewalled.
Chris Carver Network Engineer
Giuseppe Parlato wrote:
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/Bill> rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing ! ----- Original Message -----
*From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:01 PM *Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe
------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
Use tcpdump on the radius server to see if packets are being received. If they are not, you need to find the reason why. A networking issue, not a freeradius issue. tcpdump port 1812 Chris Carver Network Engineer Giuseppe Parlato wrote:
It is an upgrade, so firewall can't be the problem
Giuseppe
----- Original Message ----- From: "Chris Carver" <ccarver@pennswoods.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, May 19, 2006 8:28 PM Subject: Re: rlm_sql_getvpdata: database query error
No access-requests are making it to your radius server then. You need to make sure your client is pointed at it properly or that you don't have your radius server firewalled.
Chris Carver Network Engineer
Giuseppe Parlato wrote:
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/Bill> rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing ! ----- Original Message -----
*From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:01 PM *Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Sorry I couldn't answer before. Now I was able to get requests from SER (sip server) but at the end of each processed request in freeradius I get this error: rlm_sql: Failed to create the pair: Unknown value VOIP for attribute Service-Type rlm_sql (sql): Error getting data from database Giuseppe ----- Original Message ----- From: "Chris Carver" <ccarver@pennswoods.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, May 19, 2006 9:48 PM Subject: Re: rlm_sql_getvpdata: database query error
Use tcpdump on the radius server to see if packets are being received. If they are not, you need to find the reason why. A networking issue, not a freeradius issue.
tcpdump port 1812
Chris Carver Network Engineer
Giuseppe Parlato wrote:
It is an upgrade, so firewall can't be the problem
Giuseppe
----- Original Message ----- From: "Chris Carver" <ccarver@pennswoods.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, May 19, 2006 8:28 PM Subject: Re: rlm_sql_getvpdata: database query error
No access-requests are making it to your radius server then. You need to make sure your client is pointed at it properly or that you don't have your radius server firewalled.
Chris Carver Network Engineer
Giuseppe Parlato wrote:
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/Bill> rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing ! ----- Original Message -----
*From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:01 PM *Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/2006
"Giuseppe Parlato" <gparlato@tnet.it> wrote:
Sorry I couldn't answer before. Now I was able to get requests from SER (sip server) but at the end of each processed request in freeradius I get this error: rlm_sql: Failed to create the pair: Unknown value VOIP for attribute Service-Type
What documentation said VOIP was an allowed value for Service-Type? Or, what documentation said to use VOIP as a value? Alan DeKok.
But actually in dictionary file I do not have attribute/value for VOIP, where can I check? or how can disable it? Maybe the reason is I upgraded from 1.0.1 to 1.1.1. However I copied the old dictionary file in freeradius directory and also I copied old dictionary files in freeradius directory. Any advice please? Giuseppe ----- Original Message ----- From: "Alan DeKok" <aland@nitros9.org> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Tuesday, May 23, 2006 5:07 PM Subject: Re: rlm_sql_getvpdata: database query error
"Giuseppe Parlato" <gparlato@tnet.it> wrote:
Sorry I couldn't answer before. Now I was able to get requests from SER (sip server) but at the end of each processed request in freeradius I get this error: rlm_sql: Failed to create the pair: Unknown value VOIP for attribute Service-Type
What documentation said VOIP was an allowed value for Service-Type? Or, what documentation said to use VOIP as a value?
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/05/2006
"Giuseppe Parlato" <gparlato@tnet.it> wrote:
But actually in dictionary file I do not have attribute/value for VOIP, where can I check? or how can disable it?
The problem is that your SQL table has VOIP as a value for Service-Type. Don't do that. That's what the error says. Alan DeKok.
I have an other freeradius up and it is working (configuration is really the same) whit the same ms sql server ??? why this freeradius has problems, that I can't understand. T.T Giu ----- Original Message ----- From: "Alan DeKok" <aland@nitros9.org> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Saturday, May 27, 2006 4:06 PM Subject: Re: rlm_sql_getvpdata: database query error
"Giuseppe Parlato" <gparlato@tnet.it> wrote:
But actually in dictionary file I do not have attribute/value for VOIP, where can I check? or how can disable it?
The problem is that your SQL table has VOIP as a value for Service-Type. Don't do that. That's what the error says.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.2/349 - Release Date: 26/05/2006
in mssql.conf file I have.. authorize_reply_query = "VoIP_RadiusAuthentication '%{User-Name}','%{Calling-Station-Id}', \ '%{Called-Station-Id}','%{NAS-IP-Address}','%{h323-conf-id}','VOIP'" maybe related to that error? Giuseppe ----- Original Message ----- From: "Giuseppe Parlato" <gparlato@tnet.it> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Saturday, May 27, 2006 4:41 PM Subject: Re: rlm_sql_getvpdata: database query error
I have an other freeradius up and it is working (configuration is really the same) whit the same ms sql server ??? why this freeradius has problems, that I can't understand.
T.T
Giu
----- Original Message ----- From: "Alan DeKok" <aland@nitros9.org> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Saturday, May 27, 2006 4:06 PM Subject: Re: rlm_sql_getvpdata: database query error
"Giuseppe Parlato" <gparlato@tnet.it> wrote:
But actually in dictionary file I do not have attribute/value for VOIP, where can I check? or how can disable it?
The problem is that your SQL table has VOIP as a value for Service-Type. Don't do that. That's what the error says.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.2/349 - Release Date: 26/05/2006
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.2/349 - Release Date: 26/05/2006
tail -f /usr/local/var/log/radius/radius.log Fri May 19 20:52:29 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Fri May 19 20:52:29 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Attempting to connect to xxxx@xxx:/Bill Fri May 19 20:52:29 2006 : Info: Ready to process requests. Fri May 19 20:54:01 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Fri May 19 20:54:01 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Attempting to connect to xxxx@xxxx:/Bill Fri May 19 20:54:01 2006 : Info: Ready to process requests. I have freeradius -> unixODBC -> sql server ----- Original Message ----- From: Giuseppe Parlato To: FreeRadius users mailing list Sent: Friday, May 19, 2006 7:43 PM Subject: Re: rlm_sql_getvpdata: database query error Now I do not have that error, I started radiusd -x end: Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing ! ----- Original Message ----- From: Giuseppe Parlato To: FreeRadius users mailing list Sent: Friday, May 19, 2006 7:01 PM Subject: rlm_sql_getvpdata: database query error I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error can anyone help me please? Giuseppe ---------------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006 ------------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
No requests are hitting your radius server. Look at the last line, 'ready to process requests.' Its not processing anything. You need to make sure the access-request packets from the client are making their way to the server. Well, you can be sure they're not if thats all thats showing in radiusd -X. You need to figure out why Chris Carver Network Engineer Giuseppe Parlato wrote:
tail -f /usr/local/var/log/radius/radius.log
Fri May 19 20:52:29 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Fri May 19 20:52:29 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Attempting to connect to xxxx@xxx:/Bill <mailto:xxxx@xxx:/Bill> Fri May 19 20:52:29 2006 : Info: Ready to process requests. Fri May 19 20:54:01 2006 : Info: Using deprecated naslist file. Support for this will go away soon. Fri May 19 20:54:01 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean output=none? Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Attempting to connect to xxxx@xxxx:/Bill <mailto:xxxx@xxxx:/Bill> Fri May 19 20:54:01 2006 : Info: Ready to process requests.
I have freeradius -> unixODBC -> sql server
----- Original Message ----- *From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:43 PM *Subject:* Re: rlm_sql_getvpdata: database query error
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded DIGEST Module: Instantiated digest (digest) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/Bill> rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4 rlm_sql (sql): Connected new DB handle, #4 rlm_sql (sql): starting 5 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5 rlm_sql (sql): Connected new DB handle, #5 rlm_sql (sql): starting 6 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6 rlm_sql (sql): Connected new DB handle, #6 rlm_sql (sql): starting 7 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7 rlm_sql (sql): Connected new DB handle, #7 rlm_sql (sql): starting 8 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8 rlm_sql (sql): Connected new DB handle, #8 rlm_sql (sql): starting 9 rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9 rlm_sql (sql): Connected new DB handle, #9 Module: Instantiated sql (sql) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Ready to process requests. ...after that just nothing !
----- Original Message -----
*From:* Giuseppe Parlato <mailto:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *Sent:* Friday, May 19, 2006 7:01 PM *Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the following error: rlm_sql_getvpdata: database query error
can anyone help me please?
Giuseppe
------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 18/05/2006
------------------------------------------------------------------------
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Alan DeKok -
Chris Carver -
Giuseppe Parlato