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