rlm_sql_db2 sql server configuration

[Abdurrohman Muhammad]

   is there any configuration example to try? since the documentation for
   db2 is not writen yet
   abdurrm | Sent from my Huawei Mobile

   -------- Original Message --------
   Subject: Re: rlm_sql_db2 sql server configuration
   From: Alan DeKok
   To: FreeRadius users mailing list
   CC:

     On Mar 12, 2016, at 7:53 AM, abdurrm at ub.ac.id wrote:
     >
     > 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"?
     There should be no special configuration.
     > 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"
     Is that really the error message?
     If it can't connect to the SQL server, read the SQL server
     documentation for what connection parameters are used.
     > 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=d
     b2inst1;PWD=xxx)" # i have tried to use PHP-PECL-DB2 DSN based, it
     also wont work.
     That shouldn't be hard to figure out. You have a database, hostname,
     port, etc. in that connection string. And you have similar options
     in the SQL module configuration. How about using the parameters from
     PHP-PECL-DB2 in the FreeRADIUS configuration?
     radius_db = db2admin
     server = x.x.x.
     port = 50000
     login = db2inst1
     password = xxx
     Alan DeKok.
     -
     List info/subscribe/unsubscribe? See
     http://www.freeradius.org/list/users.html
     --
     This email was virus checked by UB Mail Gateway

--
This email was virus checked by UB Mail Gateway

Secure by Sophos