New Instance - Database Connector - Fails database/status Test

November 06, 2015 22:01

Hello!

I've been slogging through the literature for a few hours now, but am still getting a 404 error code when I try to run the very simple http://localhost:8082/database/status test.

I have access to the forms system at large, no problem, and the config.xml.default file seems to point right at my configuration file, and it is not modified.

I seem to have dotted every 'I' and crossed every 'T', but no go.

SO, given all that, what do you think?

Thanks!

Comments

12 comments

Prajakta November 06, 2015 22:08

Hi Chris,

Have you checked the tomcat log files to see if there are any error details logged in there?

0

Comment actions Permalink
Chris McFarland November 06, 2015 22:45

Now, in my previous work I've seen the context.xml.default file in the catalina directory just called context.xml. If I make that change I get this in the logs:

Nov 06, 2015 4:41:47 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\GlobalForms6\tomcat\conf\Catalina\localhost\context.xml
Nov 06, 2015 4:41:47 PM org.apache.catalina.core.StandardContext resourcesStart
SEVERE: Error starting static Resources
java.lang.IllegalArgumentException: Document base C:\GlobalForms6\tomcat\webapps\context does not exist or is not a readable directory
   at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:136)
   at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:5089)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5269)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:670)
   at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1839)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

Not sure if that help...

Thanks!

0

Comment actions Permalink
Prajakta November 09, 2015 14:41

The file must be named context.xml.default. Just context.xml will not work.

Are you installing the DB Connector on a Windows machine? If yes, then the frevvo.connectors.database.configuration parameter should be configured like this:

<Parameter name="frevvo.connectors.database.configuration"
value="E:/dbconfig/configuration.xml" override="false"/>

Notice that the path has backward slashes in it.

Can you confirm if your config matches with this?

0

Comment actions Permalink
Chris McFarland November 09, 2015 14:55

Hello!

Yes, I've changed the file back to context.xml.default, so that's good now...

Here's what I have in in that file, with the path indicated being correct, on the C Drive:

<Context swallowOutput="true" unloadDelay="40000">
        <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false">
                <Store className="org.apache.catalina.session.FileStore"/>
        </Manager>
       <Parameter name="frevvo.connectors.database.configuration" value="c:/GlobalForms6/dbconfig/configuration.xml" override="false"/>
</Context>

Thanks!

0

Comment actions Permalink
Chris McFarland November 09, 2015 15:07

Oh, and yes, I'm installing to a Win 7 box.

Thanks!

0

Comment actions Permalink
Chris McFarland November 09, 2015 15:25

Things can't be all bad, as I do get this working in my favor...

0

Comment actions Permalink
Prajakta November 09, 2015 15:38

Did you restart frevvo after you corrected the name to context.xml.defalut? After the restart, do you see any error in catalina.log or frevvo.log file when you browse the status URL?

0

Comment actions Permalink
Chris McFarland November 09, 2015 15:55

Yes, I've been stopping and restarting it after all actions via the batch files.

I've attached the logs to the ticket, too, fresh from a restart.

Thanks!

catalina.2015-11-09.log
frevvo.log
BrowserError.PNG

0

Comment actions Permalink
Prajakta November 09, 2015 16:02

Are there any other log files that got updated when you browsed the status URL?

0

Comment actions Permalink
Chris McFarland November 09, 2015 16:05

Only this line in the localhost_access_log:

0:0:0:0:0:0:0:1 - - [09/Nov/2015:10:04:04 -0600] "GET /database/status HTTP/1.1" 404 981 "-" "-" [http-nio-8082-exec-7 52A1F0FC22F4DBE1C14AA8EFBF1AD82B]

0

Comment actions Permalink
Prajakta November 09, 2015 16:12
Can you try these steps once:
1. Stop frevvo
2. Delete everything inside <frevvo-install-dir>\frevvo\tomcat\temp directory
3. Delete the <frevvo-install-dir>\frevvo\tomcat\webapps\database directory
4. Delete the <frevvo-install-dir>\frevvo\tomcat\webapps\frevvo directory (if it exists)
5. Start frevvo
6. See if your frevvo and DB connector applications work
7. If not then attach your latest log files here
0

Comment actions Permalink
Chris McFarland November 09, 2015 16:39

Hey, IT WORKED!!!!!!!!!!!

Thank You for the Great Support!

Moving ON!!!

0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?