Re: radreply table / OP field length

[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

radreply table / OP field length

[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