Hi all i have that problem. When i try tu use Secure Data Connector in a
spreadsheet using importData command,the cell result is #N/A. I tested the
importData command in the spreadsheet appendend "?...Debux=text" and the
response is NO CLIENT CONNECTED. I report the error i have in agent.log file
also.
How i can solve my problem?
Thank u in advance
*******************************************************************
Date: Thu Jun 23 12:36:38 CEST 2011
Config directory:
Runtime directory: /home/checco/Scrivania/data-connector-agent
PID file: /home/checco/Scrivania/data-connector-agent/agent.pid
args =
Password file =
/home/checco/Scrivania/data-connector-agent/config/mypassword
Run: /usr/bin/java -Djava.net.preferIPv4Stack=true -jar
/home/checco/Scrivania/data-connector-agent/lib/sdc-agent.jar
-localConfigFile
"/home/checco/Scrivania/data-connector-agent/config/localConfig.xml"
-rulesFile
"/home/checco/Scrivania/data-connector-agent/config/resourceRules.xml"
-log4jPropertiesFile
"/home/checco/Scrivania/data-connector-agent/config/log4j.properties"
-passwordFile
"/home/checco/Scrivania/data-connector-agent/config/mypassword"
log4j:ERROR Could not find value for key log4j.appender.A.layout
23 Jun 2011 10:36:39,540 [main] INFO
com.google.dataconnector.client.SdcConnection - Connecting to SDC server
23 Jun 2011 10:36:39,542 [main] INFO
com.google.dataconnector.util.SSLSocketFactoryInit - Using SSL for client
connections.
Setting iddle timeout to 60000 ms.
Setting accept timeout to 60000 ms.
Setting udp timeout to 600000 ms.
23 Jun 2011 10:36:39,552 [com.google.dataconnector.client.JsocksStarter]
INFO com.google.dataconnector.client.JsocksStarter - Starting JSOCKS
listener thread on port 1080
23 Jun 2011 10:36:39,555 [com.google.dataconnector.client.JsocksStarter]
INFO net.sourceforge.jsocks.socks.ProxyServer - Starting SOCKS Proxy
on:127.0.0.1:1080
23 Jun 2011 10:36:40,674 [main] INFO
com.google.dataconnector.client.SdcConnection - Sending initial handshake
msg
23 Jun 2011 10:36:40,674 [main] INFO
com.google.dataconnector.client.SdcConnection - Attemping login
23 Jun 2011 10:36:41,231 [main] INFO
com.google.dataconnector.client.SdcConnection - Successful login
23 Jun 2011 10:36:41,237 [main] INFO
com.google.dataconnector.registration.v4.Registration - Sending resources
info
agentId: "sdc1-client"
socksServerPort: 1080
healthCheckPort: 65535
resourceKey {
ip: "62.149.175.93"
port: 80
key: -3480276187164863579
}
resourcesXml: *etc..*.
23 Jun 2011 10:36:41,237 [main] INFO
com.google.dataconnector.util.SdcKeysManager - Adding rule for
Pair[62.149.175.93, 80]
23 Jun 2011 10:36:41,243 [main] INFO
com.google.dataconnector.client.SdcConnection - Starting hearbeat/ health
check thread.
23 Jun 2011 10:36:41,243 [main] INFO
com.google.dataconnector.client.SdcConnection - starting a thread to watch
resources file
23 Jun 2011 10:36:41,244
[com.google.dataconnector.client.HealthCheckHandler] INFO
com.google.dataconnector.client.HealthCheckHandler - healthcheck config is
not yet received from the SDC server. will check again in 5 sec
23 Jun 2011 10:36:41,491 [main] FATAL
com.google.dataconnector.client.Client - Connection failed.
com.google.dataconnector.util.ConnectionException:
com.google.dataconnector.protocol.FramingException: Unexpected frame start
read
at
com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:213)
at
com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119)
at com.google.dataconnector.client.Client.main(Client.java:178)
Caused by: com.google.dataconnector.protocol.FramingException: Unexpected
frame start read
at
com.google.dataconnector.protocol.FrameReceiver.readFrame(FrameReceiver.java:109)
at
com.google.dataconnector.protocol.FrameReceiver.startDispatching(FrameReceiver.java:75)
at
com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:209)
... 2 more
23 Jun 2011 10:36:41,492 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.ResourcesFileWatcher
23 Jun 2011 10:36:41,492 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.JsocksStarter
23 Jun 2011 10:36:41,492 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.protocol.FrameSender
23 Jun 2011 10:36:41,492 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.HealthCheckHandler
java.net.SocketException: Socket closed
23 Jun 2011 10:36:41,492 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.SdcConnection
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166)
at
com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105)
23 Jun 2011 10:36:41,492 [com.google.dataconnector.protocol.FrameSender]
INFO com.google.dataconnector.protocol.FrameSender - Sending frames
shutting down
java.lang.InterruptedException
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown
Source)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown
Source)
at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source)
at
com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148)
23 Jun 2011 10:36:41,492
[com.google.dataconnector.client.HealthCheckHandler] WARN
com.google.dataconnector.client.HealthCheckHandler - Health check sender
interrupted. Exiting.
23 Jun 2011 10:36:41,492
[com.google.dataconnector.client.ResourcesFileWatcher] INFO
com.google.dataconnector.client.ResourcesFileWatcher - Shutting down.
java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method)
at com.google.dataconnector.util.SystemUtil.sleep(SystemUtil.java:34)
at
com.google.dataconnector.client.ResourcesFileWatcher.run(ResourcesFileWatcher.java:171)
23 Jun 2011 10:36:41,493
[com.google.dataconnector.client.ResourcesFileWatcher] INFO
com.google.dataconnector.client.ResourcesFileWatcher - FileWatcher thread
exiting. Any changes in resources file will require restarting agent
manually.
23 Jun 2011 10:36:43,494 [main] INFO
com.google.dataconnector.client.Client - Starting agent after 1
unsuccessful attempts. Next connect in 2000 milliseconds.
23 Jun 2011 10:36:43,507 [main] INFO
com.google.dataconnector.client.SdcConnection - Connecting to SDC server
23 Jun 2011 10:36:43,507 [main] INFO
com.google.dataconnector.util.SSLSocketFactoryInit - Using SSL for client
connections.
Setting iddle timeout to 60000 ms.
Setting accept timeout to 60000 ms.
Setting udp timeout to 600000 ms.
23 Jun 2011 10:36:43,512 [com.google.dataconnector.client.JsocksStarter]
INFO com.google.dataconnector.client.JsocksStarter - Starting JSOCKS
listener thread on port 1080
23 Jun 2011 10:36:43,513 [com.google.dataconnector.client.JsocksStarter]
INFO net.sourceforge.jsocks.socks.ProxyServer - Starting SOCKS Proxy
on:127.0.0.1:1080
23 Jun 2011 10:36:44,216 [main] INFO
com.google.dataconnector.client.SdcConnection - Sending initial handshake
msg
23 Jun 2011 10:36:44,217 [main] INFO
com.google.dataconnector.client.SdcConnection - Attemping login
23 Jun 2011 10:36:44,765 [main] INFO
com.google.dataconnector.client.SdcConnection - Successful login
23 Jun 2011 10:36:44,767 [main] INFO
com.google.dataconnector.registration.v4.Registration - Sending resources
info
agentId: "sdc1-client"
socksServerPort: 1080
healthCheckPort: 65535
resourceKey {
ip: "62.149.175.93"
port: 80
key: -4809391524834404346
}
resourcesXml: *etc..*
23 Jun 2011 10:36:44,767 [main] INFO
com.google.dataconnector.util.SdcKeysManager - Adding rule for
Pair[62.149.175.93, 80]
23 Jun 2011 10:36:44,767 [main] INFO
com.google.dataconnector.client.SdcConnection - Starting hearbeat/ health
check thread.
23 Jun 2011 10:36:44,769 [main] INFO
com.google.dataconnector.client.SdcConnection - starting a thread to watch
resources file
23 Jun 2011 10:36:44,769
[com.google.dataconnector.client.HealthCheckHandler] INFO
com.google.dataconnector.client.HealthCheckHandler - healthcheck config is
not yet received from the SDC server. will check again in 5 sec
23 Jun 2011 10:36:45,019 [main] FATAL
com.google.dataconnector.client.Client - Connection failed.
com.google.dataconnector.util.ConnectionException:
com.google.dataconnector.protocol.FramingException: Unexpected frame start
read
at
com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:213)
at
com.google.dataconnector.client.Client.parseFlagsValidateAndConnect(Client.java:119)
at com.google.dataconnector.client.Client.main(Client.java:178)
Caused by: com.google.dataconnector.protocol.FramingException: Unexpected
frame start read
at
com.google.dataconnector.protocol.FrameReceiver.readFrame(FrameReceiver.java:109)
at
com.google.dataconnector.protocol.FrameReceiver.startDispatching(FrameReceiver.java:75)
at
com.google.dataconnector.client.SdcConnection.connect(SdcConnection.java:209)
... 2 more
23 Jun 2011 10:36:45,019 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.ResourcesFileWatcher
23 Jun 2011 10:36:45,019 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.JsocksStarter
23 Jun 2011 10:36:45,020
[com.google.dataconnector.client.ResourcesFileWatcher] INFO
com.google.dataconnector.client.ResourcesFileWatcher - Shutting down.
java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method)
at com.google.dataconnector.util.SystemUtil.sleep(SystemUtil.java:34)
at
com.google.dataconnector.client.ResourcesFileWatcher.run(ResourcesFileWatcher.java:171)
23 Jun 2011 10:36:45,020
[com.google.dataconnector.client.ResourcesFileWatcher] INFO
com.google.dataconnector.client.ResourcesFileWatcher - FileWatcher thread
exiting. Any changes in resources file will require restarting agent
manually.
23 Jun 2011 10:36:45,020 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.protocol.FrameSender
java.net.SocketException: Socket closed
23 Jun 2011 10:36:45,020 [main] INFO
com.google.dataconnector.util.ShutdownManager - Issuing shutdown for
com.google.dataconnector.client.HealthCheckHandler
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.PlainSocketImpl.accept(Unknown Source)23 Jun 2011
10:36:45,020 [main] INFO com.google.dataconnector.util.ShutdownManager -
Issuing shutdown for com.google.dataconnector.client.SdcConnection
at java.net.ServerSocket.implAccept(Unknown Source)
at java.net.ServerSocket.accept(Unknown Source)
at net.sourceforge.jsocks.socks.ProxyServer.start(ProxyServer.java:166)
at
com.google.dataconnector.client.JsocksStarter.run(JsocksStarter.java:105)
23 Jun 2011 10:36:45,020 [com.google.dataconnector.protocol.FrameSender]
INFO com.google.dataconnector.protocol.FrameSender - Sending frames
shutting down
java.lang.InterruptedException
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(Unknown
Source)
at
java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(Unknown
Source)
at java.util.concurrent.LinkedBlockingQueue.take(Unknown Source)
at
com.google.dataconnector.protocol.FrameSender.run(FrameSender.java:148)
23 Jun 2011 10:36:45,020
[com.google.dataconnector.client.HealthCheckHandler] WARN
com.google.dataconnector.client.HealthCheckHandler - Health check sender
interrupted. Exiting.
