{"comment":{"created_at":"2011-10-19T18:01:38Z","body":"I have been playing around with it, and I finally got the service to install by dropping in some stuff from the apache tomcat7 distribution. Saiku starts up just fine, and I can log in as well. \r\n\r\nHowever when I run as a service, it no longer recognizes my database (local postgres install running as a service). \r\n\r\nI think there are a few possibilities:\r\n1) The service doesn't have the correct permissions to access the database\r\n2) When running as a service there are some relative path changes and it can no longer find the correct configuration files\r\n3) As a service, it uses Tomcat7.exe instead of catalina.bat to start up. There might be a difference in how these two handle the database connections or relative paths. \r\n\r\nDoes anybody have any ideas? \r\n\r\nBut these are \r\n","updated_at":"2011-10-19T18:01:38Z","url":"https://api.github.com/repos/OSBI/saiku/issues/comments/2459040","id":2459040,"user":{"avatar_url":"https://secure.gravatar.com/avatar/25199e62f237de469990311c048764c3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"25199e62f237de469990311c048764c3","url":"https://api.github.com/users/master-and-commander","id":1130320,"login":"master-and-commander"}},"action":"created","issue":{"number":68,"created_at":"2011-10-18T17:53:19Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"First of all, thank you so much for this software. It is absolutely amazing. I'm not a Java developer, and I only know a little about front end Javascript, but if there are any other ways that I can help the project, let me know. \r\n\r\nBut the issue I wanted to bring up was that I would like to be able to install Tomcat as a Windows Service with the Saiku-Server already packaged in Tomcat. I have tried figuring out a way to do this myself using a Tomcat distribution straight from Apache, but I still can't figure out how to get it to work right. \r\n\r\nFor anyone that knows Tomcat very well, this shouldn't be too hard to do. Pentaho's BI-Server can be installed just fine, and I don't think this would be too different. \r\n","comments":1,"title":"Method to install Tomcat as a service","updated_at":"2011-10-19T18:01:38Z","url":"https://api.github.com/repos/OSBI/saiku/issues/68","id":1960039,"assignee":null,"milestone":null,"closed_at":"2011-10-19T18:01:38Z","user":{"avatar_url":"https://secure.gravatar.com/avatar/25199e62f237de469990311c048764c3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"25199e62f237de469990311c048764c3","url":"https://api.github.com/users/master-and-commander","id":1130320,"login":"master-and-commander"},"html_url":"https://github.com/OSBI/saiku/issues/68","labels":[],"state":"closed"},"legacy":{"issue_id":1960039,"comment_id":2459040}}