<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>tail -f
/usr/local/var/log/radius/radius.log</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Fri May 19 20:52:29 2006 : Info: Using deprecated
naslist file. Support for this will go away soon.<BR>Fri May 19 20:52:29
2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean
output=none?<BR>Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Driver
rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked<BR>Fri May 19
20:52:29 2006 : Info: rlm_sql (sql): Attempting to connect to <A
href="mailto:xxxx@xxx:/Bill">xxxx@xxx:/Bill</A><BR>Fri May 19 20:52:29 2006 :
Info: Ready to process requests.<BR>Fri May 19 20:54:01 2006 : Info: Using
deprecated naslist file. Support for this will go away soon.<BR>Fri May 19
20:54:01 2006 : Info: rlm_exec: Wait=yes but no output defined. Did you mean
output=none?<BR>Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Driver
rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked<BR>Fri May 19
20:54:01 2006 : Info: rlm_sql (sql): Attempting to connect to <A
href="mailto:xxxx@xxxx:/Bill">xxxx@xxxx:/Bill</A><BR>Fri May 19 20:54:01 2006 :
Info: Ready to process requests.<BR></DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have freeradius -> unixODBC -> sql
server</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=gparlato@tnet.it href="mailto:gparlato@tnet.it">Giuseppe Parlato</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">FreeRadius users mailing
list</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 19, 2006 7:43 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: rlm_sql_getvpdata: database
query error</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Now I do not have that error, </FONT><FONT
face=Arial size=2>I started radiusd -x end:</FONT></DIV>
<DIV><FONT face=Arial size=2><BR>Starting - reading configuration files
...<BR>Using deprecated naslist file. Support for this will go away
soon.<BR>Module: Loaded exec<BR>rlm_exec: Wait=yes but no output defined. Did
you mean output=none?<BR>Module: Instantiated exec (exec)<BR>Module: Loaded
expr<BR>Module: Instantiated expr (expr)<BR>Module: Loaded PAP<BR>Module:
Instantiated pap (pap)<BR>Module: Loaded CHAP<BR>Module: Instantiated chap
(chap)<BR>Module: Loaded MS-CHAP<BR>Module: Instantiated mschap
(mschap)<BR>Module: Loaded DIGEST<BR>Module: Instantiated digest
(digest)<BR>Module: Loaded System<BR>Module: Instantiated unix
(unix)<BR>Module: Loaded eap<BR>rlm_eap: Loaded and initialized type
md5<BR>rlm_eap: Loaded and initialized type leap<BR>rlm_eap: Loaded and
initialized type gtc<BR>rlm_eap: Loaded and initialized type
mschapv2<BR>Module: Instantiated eap (eap)<BR>Module: Loaded
preprocess<BR>Module: Instantiated preprocess (preprocess)<BR>Module: Loaded
realm<BR>Module: Instantiated realm (suffix)<BR>Module: Loaded
files<BR>Module: Instantiated files (files)<BR>Module: Loaded SQL<BR>rlm_sql
(sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and
linked<BR>rlm_sql (sql): Attempting to connect to <A
href="mailto:xxxxx@xxxx:/Bill">xxxxx@xxxx:/Bill</A><BR>rlm_sql (sql): starting
0<BR>rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0<BR>rlm_sql
(sql): Connected new DB handle, #0<BR>rlm_sql (sql): starting 1<BR>rlm_sql
(sql): Attempting to connect rlm_sql_unixodbc #1<BR>rlm_sql (sql): Connected
new DB handle, #1<BR>rlm_sql (sql): starting 2<BR>rlm_sql (sql): Attempting to
connect rlm_sql_unixodbc #2<BR>rlm_sql (sql): Connected new DB handle,
#2<BR>rlm_sql (sql): starting 3<BR>rlm_sql (sql): Attempting to connect
rlm_sql_unixodbc #3<BR>rlm_sql (sql): Connected new DB handle, #3<BR>rlm_sql
(sql): starting 4<BR>rlm_sql (sql): Attempting to connect rlm_sql_unixodbc
#4<BR>rlm_sql (sql): Connected new DB handle, #4<BR>rlm_sql (sql): starting
5<BR>rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5<BR>rlm_sql
(sql): Connected new DB handle, #5<BR>rlm_sql (sql): starting 6<BR>rlm_sql
(sql): Attempting to connect rlm_sql_unixodbc #6<BR>rlm_sql (sql): Connected
new DB handle, #6<BR>rlm_sql (sql): starting 7<BR>rlm_sql (sql): Attempting to
connect rlm_sql_unixodbc #7<BR>rlm_sql (sql): Connected new DB handle,
#7<BR>rlm_sql (sql): starting 8<BR>rlm_sql (sql): Attempting to connect
rlm_sql_unixodbc #8<BR>rlm_sql (sql): Connected new DB handle, #8<BR>rlm_sql
(sql): starting 9<BR>rlm_sql (sql): Attempting to connect rlm_sql_unixodbc
#9<BR>rlm_sql (sql): Connected new DB handle, #9<BR>Module: Instantiated sql
(sql)<BR>Module: Loaded detail<BR>Module: Instantiated detail
(detail)<BR>Module: Loaded radutmp<BR>Module: Instantiated radutmp
(radutmp)<BR>Initializing the thread pool...<BR>Listening on authentication
*:1812<BR>Listening on accounting *:1813<BR>Ready to process
requests.<BR></DIV></FONT>
<DIV><FONT face=Arial size=2>...after that just nothing !</DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=gparlato@tnet.it href="mailto:gparlato@tnet.it">Giuseppe
Parlato</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">FreeRadius users mailing
list</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 19, 2006 7:01
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> rlm_sql_getvpdata: database
query error</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>I upgraded freeradius from 1.0.1 to 1.1.1 and I
get the following error:</FONT></DIV>
<DIV><FONT face=Arial size=2>rlm_sql_getvpdata: database query
error</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>can anyone help me please?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Giuseppe </FONT></DIV>
<P>
<HR>
<P></P>- <BR>List info/subscribe/unsubscribe? See <A
href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</A>
<P>
<HR>
<P></P>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date:
18/05/2006<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>- <BR>List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
<P>
<HR>
<P></P>No virus found in this incoming message.<BR>Checked by AVG Free
Edition.<BR>Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date:
18/05/2006<BR></BLOCKQUOTE></BODY></HTML>