sqlippool not working

Guilherme Franco guilhermefranco at gmail.com
Mon Sep 18 22:40:24 CEST 2006


Hi Peter,

Like you told me before, you did some cleanups in the sqlippool.conf.

Well, I've tried to install todays freeradius CVS, and it installed
without the sqlippool module, don't know why.

So, I've compiled it manually from
freeradius-snapshot-20060918/src/modules/rlm_sqlippool/

OK, but when I run radiusd -X, I got this in the end, regardless of my
configuration in sqlippool.conf and radiusd.conf:

Module: Loaded SQL IP Pool
  sqlippool: sql-instance-name = "sql"
  sqlippool: lease-duration = 86400
  sqlippool: pool-name = ""
  sqlippool: allocate-begin = "BEGIN"
  sqlippool: allocate-clear = ""
  sqlippool: allocate-find = ""
  sqlippool: allocate-update = ""
  sqlippool: allocate-commit = "COMMIT"
  sqlippool: allocate-rollback = "ROLLBACK"
  sqlippool: start-begin = "BEGIN"
  sqlippool: start-update = ""
  sqlippool: start-commit = "COMMIT"
  sqlippool: start-rollback = "ROLLBACK"
  sqlippool: alive-begin = "BEGIN"
  sqlippool: alive-update = ""
  sqlippool: alive-commit = "COMMIT"
  sqlippool: alive-rollback = "ROLLBACK"
  sqlippool: stop-begin = "BEGIN"
  sqlippool: stop-clear = ""
  sqlippool: stop-commit = "COMMIT"
  sqlippool: stop-rollback = "ROLLBACK"
  sqlippool: on-begin = "BEGIN"
  sqlippool: on-clear = ""
  sqlippool: on-commit = "COMMIT"
  sqlippool: on-rollback = "ROLLBACK"
  sqlippool: off-begin = "BEGIN"
  sqlippool: off-clear = ""
  sqlippool: off-commit = "COMMIT"
  sqlippool: off-rollback = "ROLLBACK"
rlm_sqlippool: the 'allocate-clear' statement must be set.

It's not even trying to access the Oracle server.

What can it be?

Thanks!



More information about the Freeradius-Users mailing list