trouble installing track+

Hey guys.

I've tried to install track+ to no avail. it goes through the installation and says it was successful but a further examination of the file dump shows that it couldn't create the database or something. it's exactly the same problem in this old thread here

http://www.trackplus.com/forum/posts/list/71.page

i get the same things. i uninstalled track+ and firebird. reinstalled firebird and ran it as an application and then reinstalled track+. everything in the installation log seemed fine but when i try and run track+ i get a browser error saying the resource has been moved or modified.

noone? thought this was a support forum..

The installer creates a file called install.log in the folder the installer was executed from. Please post this file and the Tomcat logs to us.

This message was edited 2 times. Last update was at 03/02/2010 00:38:31

Track+ Support 3 wrote:The installer creates a file called install.log in the folder the installer was executed from. Please post this file and the Tomcat logs to us.

Here is the install.log from track+ and the tomcat log. hopefully this will help.

When i try and open track+ i get a webpage with this

Not Found
The requested URL /track was not found on this server.

i then change the port from 8080 in tomcat as per instructions from the readme to something else. i then try and load track+ again and i get this

HTTP Status 404 - /track/

--------------------------------------------------------------------------------

type Status report

message /track/

description The requested resource (/track/) is not available.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.28

I see two possible reasons for the problem:

1. install.log: It seems that you have an older Tomcat (Tomcat 5.0) installed on your machine. The actual version of track+ works only with Tomcat5.5. or Tomcat6.0. The track+ installer contains an installer for Tomcat6.0 but it is installed only if no other Tomcat is found. If so please uninstall the old Tomcat5.0 and reinstall the track+.

2. stdout.log: It seems that the standard Tomcat port (8080) and the standard http port (80) is already used by another application (maybe a second Tomcat) instance. If the first solution does not solves the problem be sure that the ports are not used already by some another (web) server.

This message was edited 2 times. Last update was at 03/02/2010 23:35:45

Track+ Support 3 wrote:I see two possible reasons for the problem:

1. install.log: It seems that you have an older Tomcat (Tomcat 5.0) installed on your machine. The actual version of track+ works only with Tomcat5.5. or Tomcat6.0. The track+ installer contains an installer for Tomcat6.0 but it is installed only if no other Tomcat is found. If so please uninstall the old Tomcat5.0 and reinstall the track+.

2. stdout.log: It seems that the standard Tomcat port (8080) and the standard http port (80) is already used by another application (maybe a second Tomcat) instance. If the first solution does not solves the problem be sure that the ports are not used already by some another (web) server.

Thanks for the reply,

i uninstalled Tomcat and then re-ran the Track+ installation and it came up with messages saying that port 8080 and 80 were already in use.

i remove tomcat and track+ completely and i can see (using netstat -ao) that there are items using port 80 and 8080. i removed KTApache which was using port 8080. but port 80 is listed as listening. i believe this is because my server (windows 2003) is running IIS. how do i solve this?

EDIT:

when reinstalling Track+ it installs tomcat. then it continues on and track+ appears to work. i can get to the login page.
this is the install.log

im a bit concerned about all the CREATE database lines...

I believe there are two problems:

1. The dreaded Windows 2003 server Firebird install problem (on some machines)
2. The port conflict with IIS on port 80.

Let me summarize my understanding of where you are:

You installed an up-to-date version of Firebird by hand, but you installed it as running in application mode, not service.
You removed any previous versions of Tomcat and ran the Track+ installer.

Good.

I believe there is not much left to do to get this running:

1. Before you run the Track+ installer again, stop your IIS.
2. Before you run the Track+ installer again, start the Firebird server manually.

From your logs I can see two problems: the installer cannot start Firebird (as a service), which is allright since you did not install it as a service. The installer ignores this, and tries to use the Firebird server nonetheless. However, it can't. So I assume it is not running.

The second problem as you already noticed is the port conflict on port 80, which we could temporarily get rid of by shutting off IIS (or any other server on that port). You can later move Tomcat to a different port, and you could even run Tomcat behind IIS, if you wanted to. But to get started, let's turn IIS off.

Let us know of your success (or failure). If you don't succeed, we can assist you online in a screen sharing session (send us a contact e-mail to support at trackplus dot com).

thanks so much for all the help.

i've got track+ working now (without restarting IIS or anything) so is it necessary to do those steps?
i've noticed that i need to have firebird running as an application in the backgroun otherwise i can't connect through track+ (as i would expect)> can i switch firebird over to service now or does it need to be application mode all the time from now on in?

Well, great you got it running.

No, you don't have to stop IIS if you are satisfied with the port the installer has reverted Tomcat to. But I guess it is not the http default port 80, so people would have to type in the port number when connecting to the Track+ server.

And yes, try to install the Firebird net service manually, this may be more convenient when the machine is rebooted. Maybe this link: http://www.ehow.com/how_5328671_install-service-windows.html can help you.

This message was edited 1 time. Last update was at 04/03/2010 04:09:25

Hi Guys,

so we're back to square one again.

the server was re-booted and now track+ isn't working anymore. i think it's because i had firebird running as an application and this got whiped out when the server got re-booted?

i just tried kicking firebird back up using fbserver -a but i get the usual "cannot find webpage" when trying to get to track+. was there something else i need to set up?

EDIT: i just started tomcat manually and now when trying to goto localhost/track/ it just hangs there loading forever.

EDIT:

now it comes up with a tomcat exception.

this is the first few lines of the error.

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.tiles.impl.CannotRenderException: ServletException including path '/tiles/layouts/ClassicLayout2.jsp'.
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:702)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:654)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:332)
org.apache.struts2.views.tiles.TilesResult.doExecute(TilesResult.java:105)

root cause

org.apache.tiles.util.TilesIOException: ServletException including path '/tiles/layouts/ClassicLayout2.jsp'.
org.apache.tiles.servlet.context.ServletUtil.wrapServletException(ServletUtil.java:164)
org.apache.tiles.servlet.context.ServletTilesRequestContext.forward(ServletTilesRequestContext.java:225)
org.apache.tiles.servlet.context.ServletTilesRequestContext.dispatch(ServletTilesRequestContext.java:204)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:69

org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:654)
org.apache.tiles.impl.BasicTilesContainer.render(BasicTilesContainer.java:332)
org.apache.struts2.views.tiles.TilesResult.doExecute(TilesResult.java:105)
org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)

looks like the DB is not working or something?

Yes, it seems to be a DB problem. Be sure that the Firebird server is up and running before Tomcat is started. (Starting the database server after Tomcat is up is not an option bacause the database initialization code runs only once, at application startup). If this doesen't solves the problem please post the Tomcat's logs here.

Hi,

yes i've started the firebird application using fbserver -a before start tomcat through the gui by using tomcat6w.

still comes up with the tomcat errors. here is the log.

[ERROR] IDBroker - Could not open a connection to the database track <org.apache.torque.TorqueException: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null>org.apache.torque.TorqueException: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:919)
at org.apache.torque.Torque.getConnection(Torque.java:314)
at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:237)
at org.apache.torque.oid.IDBroker.<init>(IDBroker.java:203)
at org.apache.torque.map.DatabaseMap.startIdBroker(DatabaseMap.java:351)
at org.apache.torque.map.TableMap.setPrimaryKeyMethod(TableMap.java:584)
at com.aurel.track.persist.map.TTrailMapBuilder.doBuild(TTrailMapBuilder.java:67)
at org.apache.torque.TorqueInstance.initialize(TorqueInstance.java:179)
at org.apache.torque.TorqueInstance.init(TorqueInstance.java:486)
at org.apache.torque.Torque.init(Torque.java:152)
at com.aurel.track.dbase.StartServlet.initTorque(StartServlet.java:456)
at com.aurel.track.dbase.StartServlet.init(StartServlet.java:129)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:405

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4371)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:57

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.catalina.startup.Bootstrap.start(Bootstrap.java:28

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:122)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:749)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool(SharedPoolDataSource.java:202)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:159)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:912)
... 38 more

2010-03-05 09:26:11,042 ERROR com.aurel.track.dbase.StartServlet - Torque init failed with org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null
Reason: I/O error for file CreateFile (open) "C:/Program Files (x86)/Track+/Database/track.gdb"
Error while trying to open file
null

Something went wrong here. Most likely the database connection does not work.
Please check if the user name, password and JDBC URL in the
WEB-INF/Torque.properties file are set correctly.
Please check that you have only one Database type enabled in the
Torque.properties file. Please also check that the database server
is running and is accessible from this machine. If the database server is
running on a different machine, check that there are no firewall issues.
Please also check that you have run all SQL scripts to set up the database.

For your information, your settings in Torque.properties are:
Database user name: friedj
Database password: tissi
Database type: firebird
Database JDBC driver: org.firebirdsql.jdbc.FBDriver
Database connection URL: jdbc:firebirdsql://localhost/C:/Program Files (x86)/Track+/Database/track.gdb?charSet=UTF-8
Exiting...

Does the C:/Program Files (x86)/Track+/Database/track.gdb file exists and if yes, can you access it with a firebird administration tool, for example flamerobin (http://www.flamerobin.org/)?

No it does not exist - at which stage does it get created?

The database file is created during installation (if it does not exist already).
If I understand correctly the track+ worked previously right? That means that the database file was created and was used at least for a while (if you ever have logged in successfully you can be sure that the database was created). But how can be that the database file simply disappeared? The Track+ never deletes the database file.