Re: ippool-dhcp and Oracle

2013-06-09 Thread Бен Томпсон
Hello everyone After fixing my mistake with the $ versus % symbols I tried ippool-dhcp again. My select statement worked and allocated an IP from the pool, but it seems that all the other sql statements (update and commit) generated the error "(0) ERROR: dhcp_sqlippool : database query error in: .

Re: ippool-dhcp and Oracle

2013-06-09 Thread Бен Томпсон
Many thanks. 2013/6/9 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-

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 "dhc

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, > framedipad

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, pool

Re: ippool-dhcp and Oracle

2013-03-25 Thread Бен Томпсон
2013/3/25 Arran Cudbard-Bell : > > On 25 Mar 2013, at 02:57, Arran Cudbard-Bell > 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. Many t

Re: ippool-dhcp and Oracle

2013-03-25 Thread Arran Cudbard-Bell
On 25 Mar 2013, at 02:57, Arran Cudbard-Bell 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 info/subscribe/unsubscribe? See htt

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-24 Thread Бен Томпсон
2013/3/25 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

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/24 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 do

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 > a

Re: ippool-dhcp and Oracle

2013-03-24 Thread Бен Томпсон
2013/3/23 Бен Томпсон : > 2013/3/23 Arran Cudbard-Bell : >> >> On 23 Mar 2013, at 12:22, Бен Томпсон 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 onl

Re: ippool-dhcp and Oracle

2013-03-23 Thread Бен Томпсон
2013/3/23 Arran Cudbard-Bell : > > On 23 Mar 2013, at 12:22, Бен Томпсон 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? >

Re: ippool-dhcp and Oracle

2013-03-23 Thread Arran Cudbard-Bell
On 23 Mar 2013, at 12:22, Бен Томпсон 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 that is required I a

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 the mys