rlm_sql_db2 sql server configuration

[abdurrm at ub.ac.id]

hello everyone,

I am trying to connect FR v3 with DB2EC V10.5.
I forced configure to compile rlm_sql_db2 using libdb2 V10.5 instead of 
IBM DB2 UDB V7 as mention in rlm_sl_db2.c
I have read IBM cli SQLConnect() documentation, about what argument 
should been sent. (because SQLConnect() using DSN/Data Source instead of 
Server's IP Address. and my V10.5-libdb2 is works with my php-pecl-db2 
module)
is there any special configuration in etc/raddb/mods-enabled/sql for 
db2? notably "server" and "radius-db"?
I've beed compile both stable 3.0.4 and last master-branch 3.1.x and 
keep give me error "rlm_sql_db2 - could not connect to DB2 server 
[idontknowwhatshouldisethere"

Here is my sql configuration :

  dialect = "db2"
  server = "my.db.2.serv"
  #server = 
"(DATABASE=db2admin;HOSTNAME=x.x.x.x;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=xxx)" # i have tried to use PHP-PECL-DB2 DSN based, it also wont work.
  port = 50000
  login = "db2inst1"
  password = "xxx"
  radius_db = "radiusdb"

  pool {
  start = 1
  min = 0
  max = 1
  spare = 0
  uses = 0
  lifetime = 0
  cleanup_interval = 30
  idle_timeout = 60
  connect_timeout = 3.000000
  held_trigger_min = 0.000000
  held_trigger_max = 0.500000
  retry_delay = 30
  spread = no
  } # i set to 1 connection only to db2, it is also doesnt work with 
default configuration

CentOS Linux release 7.1.1503 (Core) Linux 3.10.0-229.14.1.el7.x86_64 
x86_64 GNU/Linux
DB2/LINUXX8664 10.5.5
FreeRADIUS Version 3.1.0, for host x86_64-unknown-linux-gnu, built on 
Mar 12 2016 at 11:43:10 (my current build)

I knew DB2 is an experimental modul, but Alan DeKok said it works, and 
people using it.
Can someone help.. I have no more idea :(

-- 
This email was virus checked by UB Mail Gateway

Secure by Sophos