Hi all
INFORMIX VERSION:
Inst_1: onstat -version
Program Name:onstat
Build Version:12.10.FC6AEE
Build Number:N253
Build Host:lxvm-l172
Build OS:Linux 2.6.18-128.el5
Build Date:Wed Nov 4 21:57:33 CST 2015
Build Timestamp:2015-11-04T21:30:00-06
GLS Version:glslib-6.00.FC7
ENVIRONMENT SETTING:
Inst_1: env | egrep "INFORMIX|ONCONFIG"
INFORMIXDIR=/opt/informix_12_1xc6
ONCONFIG=onconfig.dbserver_tcp
INFORMIXCONTIME=15
INFORMIXSERVER=dbserver_tcp
INFORMIXSQLHOSTS=/opt/informix_12_1xc6/etc/sqlhosts
OUTPUT OF /etc/hosts
Inst_1: cat /etc/hosts | egrep -v "^#|^$"
127.0.0.1 localhost
::1 localhost ipv6-localhost ipv6-loopback
fe00::0 ipv6-localnet
ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
127.0.0.2 ifmx-server
OUTPUT OF onstat –g ntt
Inst_1: onstat -g ntt
IBM Informix Dynamic Server Version 12.10.FC6AEE -- On-Line -- Up 04:19:03 -- 376676 Kbytes
global network information:
#netscb connects read write q-free q-limits q-exceed alloc/max
2/ 4 20 14950 14983 2/ 2 135/ 10 0/ 0 2/ 2
Individual thread network information (times):
netscb thread name sid open read write address
45823b88 soctcplst 3 16:28:31 18:15:14 ifmx-server|49000|soctcp
458211c0 soctcppoll 2 17:05:07
SQLHOST SETTING:
Inst_1: cat $INFORMIXSQLHOSTS | egrep -v "^#|^$"
dbserver_tcp onsoctcp ifmx-server 49000
dbserver_shm onipcshm ifmx-server 9088
dbserver_dr drsoctcp ifmx-server 9099
UNIX LEVEL CONNECTIVITY:
Inst_1: ping ifmx-server
PING ifmx-server (127.0.0.2) 56(84) bytes of data.
64 bytes from ifmx-server (127.0.0.2): icmp_seq=1 ttl=64 time=0.039 ms
64 bytes from ifmx-server (127.0.0.2): icmp_seq=2 ttl=64 time=0.052 ms
64 bytes from ifmx-server (127.0.0.2): icmp_seq=3 ttl=64 time=0.051 ms
64 bytes from ifmx-server (127.0.0.2): icmp_seq=4 ttl=64 time=0.050 ms
--- ifmx-server ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2997ms
rtt min/avg/max/mdev = 0.039/0.048/0.052/0.005 ms
Inst_1: hostname
ifmx-server
TEST THE DB CONNECTIOB USING dbaccess
Inst_1: echo "select * from customer where customer_num=101" | dbaccess stores
Database selected.
customer_num 101
fname Ludwig
lname Pauli
company All Sports Supplies
address1 213 Erstwild Court
address2
city Sunnyvale
state CA
zipcode 94086
phone 408-789-8075
1 row(s) retrieved.
TAKING THE FACT THE there are some packaging issue note at:
https://www.ibm.com/developerworks/community/blogs/smoe/entry/Authentication_with_the_Informix_REST_Listener?lang=en
I extracted the file tomcat-embed-core.jar from my old V12.10xC4 (nosql_sdk.zip) and placed it at $INFORMIXDIR/bin directory.
ENSURE RESPECTIVE FILE ARE AVAILABLE:
Inst_1: ls -l $INFORMIXDIR/bin/tomcat-embed-core.jar
-rwxr-xr-x 1 informix informix 2668652 2016-01-18 16:14 /opt/informix_12_1xc6/bin/tomcat-embed-core.jar
Inst_1: ls -l $INFORMIXDIR/bin/jsonListener.jar
-rwxr-xr-x 1 informix informix 15803625 2015-11-04 22:02 /opt/informix_12_1xc6/bin/jsonListener.jar
REST API CONFIG FILE:
Inst_1: java -cp $INFORMIXDIR/bin/jsonListener.jar:$INFORMIXDIR/bin/tomcat-embed-core.jar com.ibm.nosql.server.ListenerCLI -config $INFORMIXDIR/etc/jsonListener-rest.properties -logfile /home/informix/logs/jsonListener-rest.log -start &
Inst_1: cat $INFORMIXDIR/etc/jsonListener-rest.properties | egrep -v "^#|^$"
authentication.enable=false
authentication.localhost.bypass.enable=true
database.dbspace=rootdbs
database.locale.default=en_US.819
listener.idle.timeout=60000
listener.port=30001
listener.type=rest
listener.commands.enable=true
response.documents.count.maximum=1000
security.sql.passthrough=true
url=jdbc:informix-sqli://ifmx-server:49000/sysmaster:INFORMIXSERVER=dbserver_tcp;USER=informix;PASSWORD=password;INFORMIXCONTIME=15
Start the wireless listerner:
Inst_1: java -jar $INFORMIXDIR/bin/jsonListener.jar -config $INFORMIXDIR/etc/jsonListener-rest.properties -logfile /home/informix/logs/jsonListener-rest.log -start &
[1] 7606
Inst_1: starting rest listener on port 30001
Check the log:
Inst_1: cat /home/informix/logs/jsonListener-rest.log
{ "date": "2016-01-18 21:44:12.811" , "thread": "main" , "level": "INFO " , "source": "com.ibm.nosql.server.ListenerCLI" , "message": "build information" , "data": { "version" : "1.2.0-SNAPSHOT" , "informixVersion" : "12.10.xC6" , "buildType" : "local" , "buildLabel" : "201511031758" , "buildEngineHostName" : "hans" , "buildEngineId" : "" , "buildDescription" : "" , "repositoryAddress" : "local" , "jdbcDriverVersion" : "4.10.JC4N900" } }
{ "date": "2016-01-18 21:44:12.998" , "thread": "main" , "level": "WARN " , "listenerId": 1 , "source": "o.a.catalina.core.StandardContext" , "message": "A context path must either be an empty string or start with a '/' and do not end with a '/'. The path [/] does not meet these criteria and has been changed to []" }
{ "date": "2016-01-18 21:44:13.415" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "o.a.coyote.http11.Http11NioProtocol" , "message": "Initializing ProtocolHandler ["http-nio-127.0.0.1-30001"]" }
{ "date": "2016-01-18 21:44:13.468" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "o.a.tomcat.util.net.NioSelectorPool" , "message": "Using a shared selector for servlet write/read" }
{ "date": "2016-01-18 21:44:13.469" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "o.a.catalina.core.StandardService" , "message": "Starting service Tomcat" }
{ "date": "2016-01-18 21:44:13.469" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "o.a.catalina.core.StandardEngine" , "message": "Starting Servlet Engine: Apache Tomcat/8.0.28" }
{ "date": "2016-01-18 21:44:13.589" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "o.a.coyote.http11.Http11NioProtocol" , "message": "Starting ProtocolHandler ["http-nio-127.0.0.1-30001"]" }
{ "date": "2016-01-18 21:44:13.593" , "thread": "main" , "level": "INFO " , "listenerId": 1 , "source": "c.ibm.nosql.server.rest.RestListener" , "message": "LISTENER_START" , "data": { "localAddress" : [ { "hostName" : "localhost" , "hostAddress" : "127.0.0.1" , "anyLocal" : false , "linkLocal" : false , "loopback" : true , "siteLocal" : false } ] , "localPort" : 30001 } }
TESTING REST CONNECTION using curl
1) Inst_1: curl -X GET -i http://ifmx-server:30001/stores/customer
curl: (7) couldn't connect to host
2) Change it to ip address:
curl -X GET -i http://127.0.0.1:30001/stores/customer
and it works and results displayed as json format.
HTTP/1.1 200 OK
Server: Apache-Coyote/1.1
Access-Control-Allow-Credentials: true
Access-Control-Expose-Headers: cursorid
Access-Control-Allow-Origin: localhost
Access-Control-Allow-Headers: Accept,cursorId
Access-Control-Expose-Headers: cursorId
Access-Control-Allow-Credentials: true
Access-Control-Allow-Methods: GET, POST, PUT, DELETE
Set-Cookie: informixRestListener.
sessionId=wzjGQJqAA+u4bblnRlJW+OXLbBxXIvpTniaLZJekhxxXsV6yyDjzAx3VqRlDD5Yd; HttpOnly
Transfer-Encoding: chunked
Date: Tue, 19 Jan 2016 00:12:23 GMT
[{"customer_num":101,"fname":"Ludwig","lname":"Pauli","company":"All
Sports Supplies","address1":"213 Erstwild Court","address2": null ,"
city":"Sunnyvale","state":"CA","zipcode":"94086","phone":"408-789-
8075"},{"customer_num":102,"fname":"Carole","lname":"Sadler","company":"
Sports Spot","address1":"785 Geary St","address2": null ,"city":"San
Francisco","state":"CA","zipcode":"94117","phone":"415-822-1289"},
{"customer_num":103,"fname":"Philip","lname":"Currie","company":"Phil's
Sports","address1":"654 Poplar","address2":"P. O. Box 3498","city":"
Palo Alto","state":"CA","zipcode":"94303","phone":"415-328-4543"},
{"customer_num":104,"fname":"Anthony","lname":"Higgins","company":"Play
Ball!","address1":"East Shopping Cntr.","address2":"422 Bay Road","
city":"Redwood City","state":"CA","zipcode":"94026","phone":"415-368-
1100"},{"customer_num":105,"fname":"Raymond","lname":"Vector","
company":"Los Altos Sports","address1":"1899 La Loma Drive","address2":
null ,"city":"Los Altos","state":"CA","zipcode":"94022","phone":"415-
776-3249"},{"customer_num":106,"fname":"George","lname":"Watson","
company":"Watson & Son","address1":"1143 Carver Place","address2": null
,"city":"Mountain View","state":"CA","zipcode":"94063","phone":"415-389-
8789"},{"customer_num":107,"fname":"Charles","lname":"Ream","company":"
Athletic Supplies","address1":"41 Jordan Avenue","address2": null ,"
city":"Palo Alto","state":"CA","zipcode":"94304","phone":"415-356-
9876"},{"customer_num":108,"fname":"Donald","lname":"Quinn","company":"
Quinn's Sports","address1":"587 Alvarado","address2": null ,"city":"
Redwood City","state":"CA","zipcode":"94063","phone":"415-544-8729"},
{"customer_num":109,"fname":"Jane","lname":"Miller","company":"Sport
Stuff","address1":"Mayfair Mart","address2":"7345 Ross Blvd.","city":"
Sunnyvale","state":"CA","zipcode":"94086","phone":"408-723-8789"},
{"customer_num":110,"fname":"Roy","lname":"Jaeger","company":"AA
Athletics","address1":"520 Topaz Way","address2": null ,"city":"Redwood
City","state":"CA","zipcode":"94062","phone":"415-743-3611"},
{"customer_num":111,"fname":"Frances","lname":"Keyes","company":"Sports
Center","address1":"3199 Sterling Court","address2": null ,"city":"
Sunnyvale","state":"CA","zipcode":"94085","phone":"408-277-7245"},
{"customer_num":112,"fname":"Margaret","lname":"Lawson","company":"
Runners & Others","address1":"234 Wyandotte Way","address2": null ,"
city":"Los Altos","state":"CA","zipcode":"94022","phone":"415-887-
7235"},{"customer_num":113,"fname":"Lana","lname":"Beatty","company":"
Sportstown","address1":"654 Oak Grove","address2": null ,"city":"Menlo
Park","state":"CA","zipcode":"94025","phone":"415-356-9982"},
{"customer_num":114,"fname":"Frank","lname":"Albertson","company":"
Sporting Place","address1":"947 Waverly Place","address2": null ,"
city":"Redwood City","state":"CA","zipcode":"94062","phone":"415-886-
6677"},{"customer_num":115,"fname":"Alfred","lname":"Grant","company":"
Gold Medal Sports","address1":"776 Gary Avenue","address2": null ,"
city":"Menlo Park","state":"CA","zipcode":"94025","phone":"415-356-
1123"},{"customer_num":116,"fname":"Jean","lname":"Parmelee","company":"
Olympic City","address1":"1104 Spinosa Drive","address2": null ,"city":"
Mountain View","state":"CA","zipcode":"94040","phone":"415-534-8822"},
{"customer_num":117,"fname":"Arnold","lname":"Sipes","company":"Kids
Korner","address1":"850 Lytton Court","address2": null ,"city":"Redwood
City","state":"CA","zipcode":"94063","phone":"415-245-4578"},
{"customer_num":118,"fname":"Dick","lname":"Baxter","company":"Blue
Ribbon Sports","address1":"5427 College","address2": null ,"city":"
Oakland","state":"CA","zipcode":"94609","phone":"415-655-0011"},
{"customer_num":119,"fname":"Bob","lname":"Shorter","company":"The
Triathletes Club","address1":"2405 Kings Highway","address2": null ,"
city":"Cherry Hill","state":"NJ","zipcode":"08002","phone":"609-663-
6079"},{"customer_num":120,"fname":"Fred","lname":"Jewell","company":"
Century Pro Shop","address1":"6627 N. 17th Way","address2": null ,"
city":"Phoenix","state":"AZ","zipcode":"85016","phone":"602-265-8754"},
{"customer_num":121,"fname":"Jason","lname":"Wallack","company":"City
Sports","address1":"Lake Biltmore Mall","address2":"350 W. 23rd
Street","city":"Wilmington","state":"DE","zipcode":"19898","phone":"302-
366-7511"},{"customer_num":122,"fname":"Cathy","lname":"O'Brian","
company":"The Sporting Life","address1":"543 Nassau Street","address2":
null ,"city":"Princeton","state":"NJ","zipcode":"08540","phone":"609-
342-0054"},{"customer_num":123,"fname":"Marvin","lname":"Hanlon","
company":"Bay Sports","address1":"10100 Bay Meadows Ro","address2":"
Suite 1020","city":"Jacksonville","state":"FL","zipcode":"32256","
phone":"904-823-4239"},{"customer_num":124,"fname":"Chris","lname":"
Putnum","company":"Putnum's Putters","address1":"4715 S.E. Adams Blvd","
address2":"Suite 909C","city":"Bartlesville","state":"OK","zipcode":"
74006","phone":"918-355-2074"},{"customer_num":125,"fname":"James","
lname":"Henry","company":"Total Fitness Sports","address1":"1450
Commonwealth Av","address2": null ,"city":"Brighton","state":"MA","
zipcode":"02135","phone":"617-232-4159"},{"customer_num":126,"fname":"
Eileen","lname":"Neelie","company":"Neelie's Discount Sp","address1":"
2539 South Utica Str","address2": null ,"city":"Denver","state":"CO","
zipcode":"80219","phone":"303-936-7731"},{"customer_num":127,"fname":"
Kim","lname":"Satifer","company":"Big Blue Bike Shop","address1":"Blue
Island Square","address2":"12222 Gregory Street","city":"Blue Island","
state":"NY","zipcode":"60406","phone":"312-944-5691"},{"customer_num":
128,"fname":"Frank","lname":"Lessor","company":"Phoenix University","
address1":"Athletic Department","address2":"1817 N. Thomas Road","
city":"Phoenix","state":"AZ","zipcode":"85008","phone":"602-533-1817"}
3) Query by a single record:
curl -X GET -i http://127.0.0.1:30001/stores/customer?query={customer_num:101}
OR
curl -X GET -i http://127.0.0.1:30001/stores/customer?query={customer_num:"101"}
BOTH received error as follow :
Inst_1: curl -X GET -i http://127.0.0.1:30001/stores/customer?query={customer_num:101}
HTTP/1.1 500 Internal Server Error
Server: Apache-Coyote/1.1
Access-Control-Allow-Credentials: true
Access-Control-Expose-Headers: cursorid
Set-Cookie: informixRestListener.sessionId=gs83rAl8zncLq5M+wpq5ytNIFoAuR1mLUEM22AIoO4MMV139NeDze8q5pMBLcMo0; HttpOnly
Transfer-Encoding: chunked
Date: Tue, 19 Jan 2016 03:50:54 GMT
Connection: close
{"err":"internal error","errmsg":"\ncustomer_num:101\n^","ok":false}
Checking on the log file(/home/informix/logs/jsonListener-rest.log) found the following :-
{ "date": "2016-01-18 21:50:54.070" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.ibm.nosql.server.rest.RestListener" , "message": "CLIENT_DISCONNECTED" }
{ "date": "2016-01-18 21:50:54.070" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "source": "c.ibm.nosql.server.rest.RestListener" , "message": "CLIENT_DISCONNECTED" }
{ "date": "2016-01-18 21:50:54.080" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "ERROR" , "source": "c.i.n.s.rest.AbstractRestServlet" , "message": "Unexpected exception:
{ "date": "2016-01-18 21:50:54.081" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "source": "c.i.n.s.rest.AbstractRestServlet" , "message": "Unexpected exception: automatically logging diagnostics" }
{ "date": "2016-01-18 21:50:54.086" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.i.n.i.c.d.LogDiagnosticsCommand" , "message": "listener diagnostic data" , "data": { "diagnostics_id" : 1 , "name" : "serverStatus" , "data" : [ { "listenerId" : 1 , "serverStatus" : { "host" : "localhost" , "version" : "1.2.0-SNAPSHOT" , "process" : "http" , "pid" : 1 , "uptime" : 401 , "uptimeMillis" : 401230 , "uptimeEstimate" : 401 , "localTime" : { "$date" : "2016-01-19T03:50:54.083Z" } , "asserts" : { "regular" : 0 , "warning" : 0 , "msg" : 0 , "user" : 0 , "rollovers" : 0 } , "backgroundFlushing" : { "flushes" : 0 , "total_ms" : 0 , "average_ms" : 0 , "last_ms" : 0 , "last_finished" : { "$date" : "1970-01-01T00:00:00.000Z" } } , "connections" : { "current" : 1 , "available" : -1 , "totalCreated" : 1 } , "cursors" : { "totalOpen" : 0 , "clientCursors_size" : 0 , "timedOut" : 0 } , "network" : { "bytesIn" : 0 , "bytesOut" : 0 , "numRequests" : 0 } , "opcounters" : { "command" : 0 , "delete" : 0 , "getmore" : 0 , "insert" : 0 , "killcursors" : 0 , "query" : 0 , "update" : 0 } } } ] } }
{ "date": "2016-01-18 21:50:54.088" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.i.n.i.c.d.LogDiagnosticsCommand" , "message": "listener diagnostic data" , "data": { "diagnostics_id" : 1 , "name" : "listenerInfo" , "data" : [ { "listenerId" : 1 , "threadName" : "RestListener-1" } ] } }
{ "date": "2016-01-18 21:50:54.090" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.i.n.i.c.d.LogDiagnosticsCommand" , "message": "listener diagnostic data" , "data": { "diagnostics_id" : 1 , "name" : "sessionsInfo" , "data" : [ { "sessionId" : 1 , "remoteAddress" : "127.0.0.1" , "listenerId" : 1 , "currentThread" : "23" , "lastUsed (milliseconds)" : 0 , "lastDatabase" : null , "status" : { "asserts" : { "regular" : 0 , "warning" : 0 , "msg" : 0 , "user" : 0 , "rollovers" : 0 } , "backgroundFlushing" : { "flushes" : 0 , "total_ms" : 0 , "average_ms" : 0 , "last_ms" : 0 , "last_finished" : { "$date" : "1970-01-01T00:00:00.000Z" } } , "connections" : { "current" : 0 , "available" : 0 , "totalCreated" : 0 } , "cursors" : { "totalOpen" : 0 , "clientCursors_size" : 0 , "timedOut" : 0 } , "network" : { "bytesIn" : 0 , "bytesOut" : 0 , "numRequests" : 0 } , "opcounters" : { "command" : 0 , "delete" : 0 , "getmore" : 0 , "insert" : 0 , "killcursors" : 0 , "query" : 0 , "update" : 0 } } , "openDatabases" : [ ] } ] } }
{ "date": "2016-01-18 21:50:54.091" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.i.n.i.c.d.LogDiagnosticsCommand" , "message": "listener diagnostic data" , "data": { "diagnostics_id" : 1 , "name" : "preparedStatementInfo" , "data" : [ { "sql" : "SELECT trim(both from dbs_collate) as locale FROM SYSDBSLOCALE WHERE dbs_dbsname = ?" , "closed" : false , "currentResultIsNull" : false , "url" : "jdbc:informix-sqli://ifmx-server:49000/sysmaster:INFORMIXSERVER=dbserver_tcp;USER=informix;PASSWORD=password;INFORMIXCONTIME=15" } ] } }
{ "date": "2016-01-18 21:50:54.098" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.i.n.i.c.d.LogDiagnosticsCommand" , "message": "listener diagnostic data" , "data": { "diagnostics_id" : 1 , "name" : "configuration" , "data" : [ { "listenerId" : 1 , "properties" : { "ENABLE_TYPE_CACHE" : "true" , "FET_BUF_SIZE" : "16384" , "IFX_AUTOFREE" : "0" , "IFX_LOCK_MODE_WAIT" : "10" , "IFX_USEPUT" : "1" , "LOGINTIMEOUT" : "1000" , "OPTOFC" : "1" , "authentication.enable" : "false" , "authentication.localhost.bypass.enable" : "true" , "collection.cache.enable" : "true" , "collection.descriptor.factory" : "static" , "collection.informix.options" : "" , "collection.informix.options.validate" : "true" , "command.blacklist" : "" , "command.eval.enable" : "false" , "command.listDatabases.sizeStrategy" : "{ estimate: 1000 }" , "compatible.maxBsonObjectSize.enable" : "false" , "compression.enable" : "false" , "configuration.source" : "file:/opt/informix_12_1xc6/etc/jsonListener-rest.properties" , "connectivity.verification.enable" : "false" , "database.buffer.enable" : "true" , "database.cache.enable" : "true" , "database.connection.strategy" : "informix" , "database.create.enable" : "true" , "database.dbspace" : "rootdbs" , "database.locale.default" : "en_US.819" , "database.log.enable" : "true" , "database.onException.errorCodes" : "{closePools:[-79716, -79730, -79735], disposeOfConnection:[-349], removeCollectionFromCache:[-710, -206], reprepareStatement:[-208, -267, -285, -79716]}" , "database.share.assertions.enable" : "false" , "database.share.close.enable" : "true" , "database.share.enable" : "true" , "db.authentication" : "MONGODB-CR" , "db.authorization" : "mongo24" , "dbManager.type.default" : "informix" , "dbspace.strategy" : "autolocate" , "delete.preparedStatement.cache.enable" : "true" , "document.id.index.enable" : "true" , "document.id.index.type" : "$string" , "documentIdAlgorithm" : "ObjectId" , "fragment.count" : "0" , "include" : "" , "index.cache.enable" : "true" , "index.cache.update.interval" : "120" , "informix.version.override" : "" , "insert.batch.enable" : "true" , "insert.batch.queue.enable" : "false" , "insert.batch.queue.flush.interval" : "100" , "insert.cursor.close.enable" : "true" , "insert.preparedStatement.cache.enable" : "true" , "jdbc.afterNewConnectionCreation" : "" , "jdbc.transaction.isolation.default" : "1" , "listener.admin.ipAddress" : "127.0.0.1" , "listener.authentication.timeout" : "0" , "listener.commands.enable" : "true" , "listener.hostName" : "localhost" , "listener.http.accessControlAllowCredentials" : "true" , "listener.http.accessControlAllowHeaders" : "[ \"accept\" , \"cursorId\" , \"content-type\" ]" , "listener.http.accessControlAllowMethods" : "[ \"GET\" , \"PUT\" , \"POST\" , \"DELETE\" , \"OPTIONS\" ]" , "listener.http.accessControlAllowOrigin" : "{ \"$regex\" : \".*\" }" , "listener.http.accessControlExposeHeaders" : "[ \"cursorId\" ]" , "listener.http.accessControlMaxAge" : "0" , "listener.http.cookie.domain" : "" , "listener.http.cookie.httpOnly" : "true" , "listener.http.cookie.length" : "64" , "listener.http.cookie.name" : "informixRestListener.sessionId" , "listener.http.cookie.path" : "" , "listener.http.cookie.secure" : "false" , "listener.http.headers" : "" , "listener.http.nonSsl.redirected.port" : "0" , "listener.idle.timeout" : "60000" , "listener.input.buffer.size" : "8192" , "listener.mbean.enable" : "false" , "listener.memoryFiller.enable" : "false" , "listener.memoryFiller.size" : "10 MiB" , "listener.memoryFiller.sleep" : "1000" , "listener.memoryMonitor.allPoint" : "80.0" , "listener.memoryMonitor.diagnosticPoint" : "99.0" , "listener.memoryMonitor.enable" : "true" , "listener.memoryMonitor.zeroPoint" : "95.0" , "listener.onException" : "reply" , "listener.output.buffer.size" : "8192" , "listener.pool.admin.enable" : "false" , "listener.pool.keepAliveTime" : "60" , "listener.pool.queue.size" : "0" , "listener.pool.size.core" : "128" , "listener.pool.size.maximum" : "1024" , "listener.port" : "30001" , "listener.socket.accept.timeout" : "1024" , "listener.socket.backlog" : "100" , "listener.socket.read.timeout" : "1024" , "listener.ssl.algorithm" : "" , "listener.ssl.ciphers" : "" , "listener.ssl.enable" : "false" , "listener.ssl.key.alias" : "" , "listener.ssl.key.password" : "" , "listener.ssl.keyStore.file" : "" , "listener.ssl.keyStore.password" : "" , "listener.ssl.keyStore.type" : "JKS" , "listener.ssl.protocol" : "TLS" , "listener.start.enable" : "true" , "listener.type" : "rest" , "mongo.api.version" : "2.4" , "query.preparedStatement.cache.enable" : "true" , "response.documents.count.default" : "100" , "response.documents.count.maximum" : "1000" , "response.documents.size.maximum" : "1048576" , "response.documents.size.minimum" : "65536" , "sasl.iterationCount" : "10000" , "schema.validate.enable" : "false" , "security.sql.passthrough" : "true" , "sharding.enable" : "false" , "sharding.parallel.query.enable" : "false" , "stop.wait" : "10" , "threadStatistics.enable" : "false" , "timeSeries.extent.first" : "512 KiB" , "timeSeries.extent.next" : "512 KiB" , "update.client.strategy" : "updatableCursor" , "update.mode" : "client" , "update.one.enable" : "false" , "update.preparedStatement.cache.enable" : "true" , "url" : "jdbc:informix-sqli://ifmx-server:49000/sysmaster:INFORMIXSERVER=dbserver_tcp;USER=informix;PASSWORD=password;INFORMIXCONTIME=15" } } ] } }
{ "date": "2016-01-18 21:50:54.099" , "thread": "http-nio-127.0.0.1-30001-exec-1" , "level": "INFO " , "listenerId": 1 , "sessionId": 1 , "source": "c.ibm.nosql.server.rest.RestListener" , "message": "CLIENT_DISCONNECTED" }
Questions
1) Why the wireless listener accepting connection from the local host(127.0.0.1) instead of ifmx-server(127.0.0.2) ?
2) Why I can not query by a single record(in test 3), anything wrong with the syntax or setting or the wireless config file ?
Seeking quick respond on this matter.
Thanks
