Running test fails when Cisco AnyConnect VPN is active (connected)
585 views
Skip to first unread message
Jarek Andrzejewski
May 27, 2014, 4:32:40 PM5/27/14
to db...@googlegroups.com
Hi,
I started to use DbFit to make some tests on remote Oracle database (behind VPN).
When it's disconnected test starts and passes, but while VPN is active (connected) pressing "Test" immediately returns an error (the wiki test page is not even started).
I googled out that Cisco AnyConnect doesn't provide IPv6 services, so I switched off IPv6 in Windows completely (setting HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters\DisabledComponents to 0xffffffff in registry). It didn't help.
I addded "!define COMMAND_PATTERN {java -Djava.net.preferIPv4Stack=true -cp %p %m}" to the test page. It didn't help either.
I even got DbFit 2.20 and started Fitnesse using Java 6 JVM (also defined JVM 6 for COMMAND_PATTERN). Same error...
Do you think using 127.0.0.1 instead of machine name could help? How can I change the three parameters of fit.FitServer (host, port, ticket)?
Or maybe there is something else I can configure to run the tests while the VPN is active?
The error page:
Standard Error:
I started to use DbFit to make some tests on remote Oracle database (behind VPN).
When it's disconnected test starts and passes, but while VPN is active (connected) pressing "Test" immediately returns an error (the wiki test page is not even started).
I googled out that Cisco AnyConnect doesn't provide IPv6 services, so I switched off IPv6 in Windows completely (setting HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\TCPIP6\Parameters\DisabledComponents to 0xffffffff in registry). It didn't help.
I addded "!define COMMAND_PATTERN {java -Djava.net.preferIPv4Stack=true -cp %p %m}" to the test page. It didn't help either.
I even got DbFit 2.20 and started Fitnesse using Java 6 JVM (also defined JVM 6 for COMMAND_PATTERN). Same error...
Do you think using 127.0.0.1 instead of machine name could help? How can I change the three parameters of fit.FitServer (host, port, ticket)?
Or maybe there is something else I can configure to run the tests while the VPN is active?
The error page:
fit:fit.FitServer
| Date: | 10:16:31 PM (CEST) on wtorek, maj 27, 2014 |
| Test Page: | .TestProject.TestTmp |
| Command: | java -cp lib\fitnesse-standalone-20140317.jar;D:\CA\dbfit\lib\CommandLineFixture.jar;D:\CA\dbfit\lib\commons-codec-1.9.jar;D:\CA\dbfit\lib\commons-io-2.4.jar;D:\CA\dbfit\lib\commons-lang3-3.3.1.jar;D:\CA\dbfit\lib\dbfit-core-3.0.1.jar;D:\CA\dbfit\lib\dbfit-db2-3.0.1.jar;D:\CA\dbfit\lib\dbfit-derby-3.0.1.jar;D:\CA\dbfit\lib\dbfit-docs-3.0.1.jar;D:\CA\dbfit\lib\dbfit-hsqldb-3.0.1.jar;D:\CA\dbfit\lib\dbfit-mysql-3.0.1.jar;D:\CA\dbfit\lib\dbfit-oracle-3.0.1.jar;D:\CA\dbfit\lib\dbfit-postgres-3.0.1.jar;D:\CA\dbfit\lib\dbfit-sqlserver-3.0.1.jar;D:\CA\dbfit\lib\dom4j-1.6.1.jar;D:\CA\dbfit\lib\fitlibrary-20081102.jar;D:\CA\dbfit\lib\fitnesse-standalone-20140317.jar;D:\CA\dbfit\lib\guava-11.0.2.jar;D:\CA\dbfit\lib\javassist-3.16.1-GA.jar;D:\CA\dbfit\lib\jsr305-1.3.9.jar;D:\CA\dbfit\lib\jtds-1.2.2.jar;D:\CA\dbfit\lib\mysql-connector-java-5.1.6.jar;D:\CA\dbfit\lib\ojdbc6-11.2.0.3.0.jar;D:\CA\dbfit\lib\postgresql-9.3-1101-jdbc41.jar;D:\CA\dbfit\lib\reflections-0.9.9-RC1.jar;D:\CA\dbfit\lib\xml-apis-1.0.b2.jar;fitnesse.jar fit.FitServer MYMACHINE 51263 3863 |
| Exit code: | 1 |
| Time elapsed: | 1.029 seconds |
Standard Error:
Exception in thread "main" java.net.SocketException: Permission denied: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.<init>(Unknown Source) at java.net.Socket.<init>(Unknown Source) at fit.FitServer.establishConnection(FitServer.java:150) at fit.FitServer.establishConnection(FitServer.java:146) at fit.FitServer.run(FitServer.java:54) at fit.FitServer.main(FitServer.java:41)
Jake Benilov
May 27, 2014, 4:38:23 PM5/27/14
to db...@googlegroups.com
Have you tried also setting the preferIPv4Stack parameter in startFitnesse.bat too?
--
You received this message because you are subscribed to the Google Groups "dbfit" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dbfit+un...@googlegroups.com.
To post to this group, send email to db...@googlegroups.com.
Visit this group at http://groups.google.com/group/dbfit.
For more options, visit https://groups.google.com/d/optout.
Jarek Andrzejewski
May 27, 2014, 5:10:55 PM5/27/14
to db...@googlegroups.com
Hi, Jake, thanks for reply!
>Have you tried also setting the preferIPv4Stack parameter in startFitnesse.bat too?
yes.
I make a trick: I started a test with VPN disconnected - it started and was waiting for DB connection (DB is behind VPN). Then I connected VPN, test connected DB via VPN and passed "green".
Existing connection to FitServer works fine after VPN becomes active, it only can't be started.
Console output:
D:\CA\dbfit>cd /d D:\CA\dbfit\
D:\CA\dbfit>"D:\Program Files\Java\jre7\bin\java.exe" -Djava.net.preferIPv4Stack=true -cp "lib\dbfit-docs-3.0.1.jar;lib\fitnesse-standalone-20140317.jar" fitnesseMain.FitNesseMain -l d:\ca\dbfit\logs -v
Configured verbose logging
root page: fitnesse.wiki.fs.FileSystemPage at ./FitNesseRoot
logger: d:\ca\dbfit\logs
authenticator: fitnesse.authentication.PromiscuousAuthenticator
page factory: fitnesse.html.template.PageFactory
page theme: bootstrap
Starting FitNesse on port: 8085
WARNING: error registered in test system [FitClient: external process terminated before a connection could be established.]
java.lang.Exception: FitClient: external process terminated before a connectioncould be established.
at fitnesse.testsystems.fit.CommandRunningFitClient$OutOfProcessCommandRunner$EarlyTerminationRunnable.run(CommandRunningFitClient.java:203)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient: external process terminated before a connection could be established.]
java.lang.Exception: FitClient: external process terminated before a connectioncould be established.
at fitnesse.testsystems.fit.CommandRunningFitClient$OutOfProcessCommandRunner$EarlyTerminationRunnable.run(CommandRunningFitClient.java:203)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient was killed]
java.lang.InterruptedException: FitClient was killed
at fitnesse.testsystems.fit.FitClient.checkForPulse(FitClient.java:84)
at fitnesse.testsystems.fit.CommandRunningFitClient.waitForConnection(CommandRunningFitClient.java:67)
at fitnesse.testsystems.fit.CommandRunningFitClient.start(CommandRunningFitClient.java:45)
at fitnesse.testsystems.fit.FitTestSystem.start(FitTestSystem.java:39)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystem(MultipleTestsRunner.java:140)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystemAndExecutePages(MultipleTestsRunner.java:90)
at fitnesse.testrunner.MultipleTestsRunner.internalExecuteTestPages(MultipleTestsRunner.java:80)
at fitnesse.testrunner.MultipleTestsRunner.executeTestPages(MultipleTestsRunner.java:63)
at fitnesse.responders.run.TestResponder.performExecution(TestResponder.java:237)
at fitnesse.responders.run.TestResponder.doExecuteTests(TestResponder.java:95)
at fitnesse.responders.run.TestResponder$TestExecutor.execute(TestResponder.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.Template.merge(Template.java:356)
at org.apache.velocity.Template.merge(Template.java:260)
at fitnesse.html.template.HtmlPage.render(HtmlPage.java:81)
at fitnesse.responders.run.TestResponder.doSending(TestResponder.java:81)
at fitnesse.responders.ChunkingResponder.startSending(ChunkingResponder.java:70)
at fitnesse.http.ChunkedResponse.sendTo(ChunkedResponse.java:25)
at fitnesse.FitNesseExpediter.sendResponse(FitNesseExpediter.java:100)
at fitnesse.FitNesseExpediter.start(FitNesseExpediter.java:51)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:28)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:21)
at fitnesse.socketservice.SocketService$ServerRunner.run(SocketService.java:110)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient was killed]
java.lang.InterruptedException: FitClient was killed
at fitnesse.testsystems.fit.FitClient.checkForPulse(FitClient.java:84)
at fitnesse.testsystems.fit.CommandRunningFitClient.waitForConnection(CommandRunningFitClient.java:67)
at fitnesse.testsystems.fit.CommandRunningFitClient.start(CommandRunningFitClient.java:45)
at fitnesse.testsystems.fit.FitTestSystem.start(FitTestSystem.java:39)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystem(MultipleTestsRunner.java:140)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystemAndExecutePages(MultipleTestsRunner.java:90)
at fitnesse.testrunner.MultipleTestsRunner.internalExecuteTestPages(MultipleTestsRunner.java:80)
at fitnesse.testrunner.MultipleTestsRunner.executeTestPages(MultipleTestsRunner.java:63)
at fitnesse.responders.run.TestResponder.performExecution(TestResponder.java:237)
at fitnesse.responders.run.TestResponder.doExecuteTests(TestResponder.java:95)
at fitnesse.responders.run.TestResponder$TestExecutor.execute(TestResponder.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.Template.merge(Template.java:356)
at org.apache.velocity.Template.merge(Template.java:260)
at fitnesse.html.template.HtmlPage.render(HtmlPage.java:81)
at fitnesse.responders.run.TestResponder.doSending(TestResponder.java:81)
at fitnesse.responders.ChunkingResponder.startSending(ChunkingResponder.java:70)
at fitnesse.http.ChunkedResponse.sendTo(ChunkedResponse.java:25)
at fitnesse.FitNesseExpediter.sendResponse(FitNesseExpediter.java:100)
at fitnesse.FitNesseExpediter.start(FitNesseExpediter.java:51)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:28)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:21)
at fitnesse.socketservice.SocketService$ServerRunner.run(SocketService.java:110)
at java.lang.Thread.run(Unknown Source)
I make a trick: I started a test with VPN disconnected - it started and was waiting for DB connection (DB is behind VPN). Then I connected VPN, test connected DB via VPN and passed "green".
Existing connection to FitServer works fine after VPN becomes active, it only can't be started.
Console output:
D:\CA\dbfit>cd /d D:\CA\dbfit\
D:\CA\dbfit>"D:\Program Files\Java\jre7\bin\java.exe" -Djava.net.preferIPv4Stack=true -cp "lib\dbfit-docs-3.0.1.jar;lib\fitnesse-standalone-20140317.jar" fitnesseMain.FitNesseMain -l d:\ca\dbfit\logs -v
Configured verbose logging
root page: fitnesse.wiki.fs.FileSystemPage at ./FitNesseRoot
logger: d:\ca\dbfit\logs
authenticator: fitnesse.authentication.PromiscuousAuthenticator
page factory: fitnesse.html.template.PageFactory
page theme: bootstrap
Starting FitNesse on port: 8085
WARNING: error registered in test system [FitClient: external process terminated before a connection could be established.]
java.lang.Exception: FitClient: external process terminated before a connectioncould be established.
at fitnesse.testsystems.fit.CommandRunningFitClient$OutOfProcessCommandRunner$EarlyTerminationRunnable.run(CommandRunningFitClient.java:203)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient: external process terminated before a connection could be established.]
java.lang.Exception: FitClient: external process terminated before a connectioncould be established.
at fitnesse.testsystems.fit.CommandRunningFitClient$OutOfProcessCommandRunner$EarlyTerminationRunnable.run(CommandRunningFitClient.java:203)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient was killed]
java.lang.InterruptedException: FitClient was killed
at fitnesse.testsystems.fit.FitClient.checkForPulse(FitClient.java:84)
at fitnesse.testsystems.fit.CommandRunningFitClient.waitForConnection(CommandRunningFitClient.java:67)
at fitnesse.testsystems.fit.CommandRunningFitClient.start(CommandRunningFitClient.java:45)
at fitnesse.testsystems.fit.FitTestSystem.start(FitTestSystem.java:39)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystem(MultipleTestsRunner.java:140)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystemAndExecutePages(MultipleTestsRunner.java:90)
at fitnesse.testrunner.MultipleTestsRunner.internalExecuteTestPages(MultipleTestsRunner.java:80)
at fitnesse.testrunner.MultipleTestsRunner.executeTestPages(MultipleTestsRunner.java:63)
at fitnesse.responders.run.TestResponder.performExecution(TestResponder.java:237)
at fitnesse.responders.run.TestResponder.doExecuteTests(TestResponder.java:95)
at fitnesse.responders.run.TestResponder$TestExecutor.execute(TestResponder.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.Template.merge(Template.java:356)
at org.apache.velocity.Template.merge(Template.java:260)
at fitnesse.html.template.HtmlPage.render(HtmlPage.java:81)
at fitnesse.responders.run.TestResponder.doSending(TestResponder.java:81)
at fitnesse.responders.ChunkingResponder.startSending(ChunkingResponder.java:70)
at fitnesse.http.ChunkedResponse.sendTo(ChunkedResponse.java:25)
at fitnesse.FitNesseExpediter.sendResponse(FitNesseExpediter.java:100)
at fitnesse.FitNesseExpediter.start(FitNesseExpediter.java:51)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:28)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:21)
at fitnesse.socketservice.SocketService$ServerRunner.run(SocketService.java:110)
at java.lang.Thread.run(Unknown Source)
WARNING: error registered in test system [FitClient was killed]
java.lang.InterruptedException: FitClient was killed
at fitnesse.testsystems.fit.FitClient.checkForPulse(FitClient.java:84)
at fitnesse.testsystems.fit.CommandRunningFitClient.waitForConnection(CommandRunningFitClient.java:67)
at fitnesse.testsystems.fit.CommandRunningFitClient.start(CommandRunningFitClient.java:45)
at fitnesse.testsystems.fit.FitTestSystem.start(FitTestSystem.java:39)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystem(MultipleTestsRunner.java:140)
at fitnesse.testrunner.MultipleTestsRunner.startTestSystemAndExecutePages(MultipleTestsRunner.java:90)
at fitnesse.testrunner.MultipleTestsRunner.internalExecuteTestPages(MultipleTestsRunner.java:80)
at fitnesse.testrunner.MultipleTestsRunner.executeTestPages(MultipleTestsRunner.java:63)
at fitnesse.responders.run.TestResponder.performExecution(TestResponder.java:237)
at fitnesse.responders.run.TestResponder.doExecuteTests(TestResponder.java:95)
at fitnesse.responders.run.TestResponder$TestExecutor.execute(TestResponder.java:167)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.runtime.directive.Parse.render(Parse.java:260)
at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at org.apache.velocity.Template.merge(Template.java:356)
at org.apache.velocity.Template.merge(Template.java:260)
at fitnesse.html.template.HtmlPage.render(HtmlPage.java:81)
at fitnesse.responders.run.TestResponder.doSending(TestResponder.java:81)
at fitnesse.responders.ChunkingResponder.startSending(ChunkingResponder.java:70)
at fitnesse.http.ChunkedResponse.sendTo(ChunkedResponse.java:25)
at fitnesse.FitNesseExpediter.sendResponse(FitNesseExpediter.java:100)
at fitnesse.FitNesseExpediter.start(FitNesseExpediter.java:51)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:28)
at fitnesse.FitNesseServer.serve(FitNesseServer.java:21)
at fitnesse.socketservice.SocketService$ServerRunner.run(SocketService.java:110)
at java.lang.Thread.run(Unknown Source)
Jake Benilov
May 27, 2014, 5:14:43 PM5/27/14
to db...@googlegroups.com
Hmm, I'm not sure I could provide any more guidance on this...
This error is occurring at the Fitnesse level (the test framework underneath DbFit). You might have more luck raising this issue on the Fitnesse forums.
Yavor Nikolov
May 27, 2014, 5:16:07 PM5/27/14
to db...@googlegroups.com
Hi Jarek,
Are you able to reproduce the issue with something simpler - e.g. a Wiki Test page with just some text (no DbFit or other test fixtures - nor on the page nor in setup, nor in parent suite)?
Are you able to reproduce the issue with something simpler - e.g. a Wiki Test page with just some text (no DbFit or other test fixtures - nor on the page nor in setup, nor in parent suite)?
Have you tried with Java 8?
Jarek Andrzejewski
May 27, 2014, 5:33:16 PM5/27/14
to db...@googlegroups.com
On Tuesday, May 27, 2014 11:14:43 PM UTC+2, Jake Benilov wrote:
Hmm, I'm not sure I could provide any more guidance on this...This error is occurring at the Fitnesse level (the test framework underneath DbFit). You might have more luck raising this issue on the Fitnesse forums.
OK, I understand. I'll try there.
On Tuesday, May 27, 2014 11:16:07 PM UTC+2, Yavor Nikolov wrote:
Hi Jarek,
Are you able to reproduce the issue with something simpler - e.g. a Wiki Test page with just some text (no DbFit or other test fixtures - nor on the page nor in setup, nor in parent suite)?
same error.
Have you tried with Java 8?
I didn't (yet).
--
Kind Regards,
Jarek Andrzejewski
--
Kind Regards,
Jarek Andrzejewski
Reply all
Reply to author
Forward
0 new messages