Бен Томпсон wrote:
> I began work on testing with Oracle but I have come across a couple of
> issues. Firstly one of my SQL statements is throwing up an error, and
> secondly the server is sending a unicast reply when I need a
> broadcast. I should be able to fix the dodgy SQL but I wondered if
> anyone could help me fix the broadcast/unicast problem. Here is the
> full degug :-
The debug log
> Received DHCP-Discover of id 64b2e216 from 0.0.0.0:68 to 0.0.0.0:67
> DHCP-Opcode = Client-Message
> DHCP-Hardware-Type = Ethernet
> DHCP-Hardware-Address-Length = 6
> DHCP-Hop-Count = 0
> DHCP-Transaction-Id = 1689444886
> DHCP-Number-of-Seconds = 0
> DHCP-Flags = 0
The broadcast flag isn't set. So the client is asking for a unicast
response.
> (0) dhcp_sqlippool : expand: 'START TRANSACTION' -> 'START TRANSACTION'
> rlm_sql (sql): Executing query: 'START TRANSACTION'
> rlm_sql_oracle: execute query failed in sql_query: ORA-00900: invalid
> SQL statement
That needs to be fixed. I don't know much about Oracle, and I don't
have an Oracle system running to test it.
> (0) DHCP: Reply will be sent unicast to your-ip-address
> Sending DHCP-Offer of id 64b2e216 to 10.99.0.11:68
You should be able to fix this by doing:
update reply {
DHCP-Flags = Broadcast
}
Which will force the server to send a broadcast reply.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
