radreply table / OP field length

2006-06-13 Thread Cliff Hayes 
Hello,

The included db_mysql.sql which creates the MySQL schema required for
FreeRADIUS created the radreply table with a two-character OP field (I
assume for use with <=, >=, etc).  It defaults to a single "=" and when I
add a record, subsequent queries from a Microsoft SQL 2000 linked Database
connection fail because it wants both characters filled (== maybe).  We use
Platypus as our billing system, which resides in the Microsoft SQL 2000
environment and talks to FreeRADIUS via the link mentioned above.  Should I
change the default to "==" or is there something else?

Here is the error:

Server: Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' returned an unexpected data length for the
fixed-length column '[FreeRADIUS]...[radreply].op'. The expected data length
is 2, while the returned data length is 1.
OLE DB error trace [Non-interface error:  Unexpected data length returned
for the column:  ProviderName='MSDASQL',
TableName='[FreeRADIUS]...[radreply]', ColumnName='op', ExpectedLength='2',
ReturnedLength='1'].

Cliff

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: radreply table / OP field length

2006-06-14 Thread Nicolas Baradakis 
Cliff Hayes wrote:

> The included db_mysql.sql which creates the MySQL schema required for
> FreeRADIUS created the radreply table with a two-character OP field (I
> assume for use with <=, >=, etc).  It defaults to a single "=" and when I
> add a record, subsequent queries from a Microsoft SQL 2000 linked Database
> connection fail because it wants both characters filled (== maybe).

FreeRADIUS provides SQL schemas for both MySQL and Microsoft SQL.
I don't really understand why you're using the MySQL schema if you're
going to run a different server later.

> We use Platypus as our billing system, which resides in the Microsoft
> SQL 2000 environment and talks to FreeRADIUS via the link mentioned
> above.  Should I change the default to "==" or is there something
> else?

The operator "==" isn't allowed in a reply item. Please look at this
page for a description of the operators:

http://freeradius.org/radiusd/doc/rlm_sql

-- 
Nicolas Baradakis

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html