Re: ippool-dhcp and Oracle

2013-06-09 Thread Alan DeKok
Бен Томпсон wrote: I am still testing ippool-dhcp and after updating to the latest git HEAD I have come across a new issue. For some reason I am seeing the error Unknown attribute regarding the variable %{pool-key}. That's because the Pool-Key attribute doesn't exist. The example

Re: ippool-dhcp and Oracle

2013-06-09 Thread Бен Томпсон
Many thanks. 2013/6/9 Alan DeKok al...@deployingradius.com Бен Томпсон wrote: I am still testing ippool-dhcp and after updating to the latest git HEAD I have come across a new issue. For some reason I am seeing the error Unknown attribute regarding the variable %{pool-key}. That's

Re: ippool-dhcp and Oracle

2013-06-09 Thread Бен Томпсон
the some fields in the table but I as far as I can see the other sql statements will work fine even if the fields are not cleared. So I tried the setting allocate-clear as an empty string but I recieved the following error: /usr/local/etc/raddb/sql/ippool-dhcp/oracle/queries.conf[33]: Configuration

Re: ippool-dhcp and Oracle

2013-03-31 Thread Бен Томпсон
Many thanks. I will give it a try. I am still working on this but, I have some further issues which I need to resolve. Firstly the ippool table for the oracle ippool schema contains various columns which are defined as NOT NULL: CREATE TABLE radippool ( id INT PRIMARY KEY,

Re: ippool-dhcp and Oracle

2013-03-31 Thread Alan DeKok
Бен Томпсон wrote: Firstly the ippool table for the oracle ippool schema contains various columns which are defined as NOT NULL: That is probably too strong a requirement. CREATE TABLE radippool ( id INT PRIMARY KEY, pool_name VARCHAR(30) NOT NULL, framedipaddress

Re: ippool-dhcp and Oracle

2013-03-25 Thread Arran Cudbard-Bell
I am not sure what is happening here so I will have to do some reading. Fixed. Git pull. -Arran - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: ippool-dhcp and Oracle

2013-03-25 Thread Arran Cudbard-Bell
On 25 Mar 2013, at 02:57, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: I am not sure what is happening here so I will have to do some reading. Fixed. Git pull. Or would have been if git push hadn't hung... Sorry GitHub has been really flakey lately. -Arran - List

Re: ippool-dhcp and Oracle

2013-03-25 Thread Бен Томпсон
2013/3/25 Arran Cudbard-Bell a.cudba...@freeradius.org: On 25 Mar 2013, at 02:57, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: I am not sure what is happening here so I will have to do some reading. Fixed. Git pull. Or would have been if git push hadn't hung... Sorry GitHub has

Re: ippool-dhcp and Oracle

2013-03-24 Thread Бен Томпсон
2013/3/23 Бен Томпсон b.thomp...@latera.ru: 2013/3/23 Arran Cudbard-Bell a.cudba...@freeradius.org: On 23 Mar 2013, at 12:22, Бен Томпсон b.thomp...@latera.ru wrote: Hello Everyone Could anyone advise me what would be required to us dhcp-ippool with Oracle? I had a quick look through

Re: ippool-dhcp and Oracle

2013-03-24 Thread Alan DeKok
Бен Томпсон 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

Re: ippool-dhcp and Oracle

2013-03-24 Thread Бен Томпсон
2013/3/24 Alan DeKok al...@deployingradius.com: Бен Томпсон 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

Re: ippool-dhcp and Oracle

2013-03-24 Thread Alan DeKok
Бен Томпсон wrote: The SQL statement START TRANSACTION looks to be hard coded into rlm_sqlippool.c but I don't know enough about Oracle etiher to say why it is flagged as an error. It's a configuration item. You can change it by editing the queries, and adding: allocate-begin = ...

Re: ippool-dhcp and Oracle

2013-03-24 Thread Бен Томпсон
2013/3/25 Alan DeKok al...@deployingradius.com: Бен Томпсон wrote: The SQL statement START TRANSACTION looks to be hard coded into rlm_sqlippool.c but I don't know enough about Oracle etiher to say why it is flagged as an error. It's a configuration item. You can change it by editing the

ippool-dhcp and Oracle

2013-03-23 Thread Бен Томпсон
Hello Everyone Could anyone advise me what would be required to us dhcp-ippool with Oracle? I had a quick look through the files in git and it seems to me that the only thing missing is queries.conf? If that is all that is required I am happy to do the work of porting the sql queries from

Re: ippool-dhcp and Oracle

2013-03-23 Thread Arran Cudbard-Bell
On 23 Mar 2013, at 12:22, Бен Томпсон b.thomp...@latera.ru wrote: Hello Everyone Could anyone advise me what would be required to us dhcp-ippool with Oracle? I had a quick look through the files in git and it seems to me that the only thing missing is queries.conf? If that is all

Re: ippool-dhcp and Oracle

2013-03-23 Thread Бен Томпсон
2013/3/23 Arran Cudbard-Bell a.cudba...@freeradius.org: On 23 Mar 2013, at 12:22, Бен Томпсон b.thomp...@latera.ru wrote: Hello Everyone Could anyone advise me what would be required to us dhcp-ippool with Oracle? I had a quick look through the files in git and it seems to me that the only