ChiliProject is not maintained anymore. Please be advised that there will be no more updates.

We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.

[HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ?

Added by Chili Fan at 2012-03-29 11:17 pm

Dear ChiliProject Members

I am New To ChiliProject and Managed to Install/Setup Basic Steps Explained Here
at Wiki/Installation, I run Webrick as test example at Wiki Succesfull just Awesome!

Now i want to take next step and Installed Nginx as a service Succefull

I am complete stuck at How to Configure "nginx.conf" File or something I believe, to hook Nginx To ChiliProject

I try
http://www.redmine.org/projects/redmine/wiki/HowTo_configure_Nginx_to_run_Redmine
https://www.chiliproject.org/projects/chiliproject/wiki/HowTo_configure_Nginx_to_run_ChiliProject
but it don't make me sense how exactly i should edit this "nginx.conf" File or maybe there is other way to hook up Nginx To ChiliProject ?

Thanks InAdvance

=======================================================================================
Thanks for all help Please report any Improvements and Problems about this in the forum

Install Guide ChiliProject with SQLite3 and Thin under SubURL as Windows Service
https://www.chiliproject.org/boards/1/topics/1420?r=1971#message-1971

Install Guide ChiliProject with SQLite3 and Tomcat under SubURL as Windows Service
https://www.chiliproject.org/boards/1/topics/1420?r=2044#message-2044 =======================================================================================


HowTo Install ChiliProject with SQLite and Appache Tomcat Configuration ?
https://www.chiliproject.org/boards/1/topics/1420

Installation notes for ChiliProject 3.0.0 with PostgreSQL on Windows 2008 as Windows Service
https://www.chiliproject.org/boards/1/topics/1212?r=1862#message-1862

Thin Server and Chiliproject trouble (changed the title bcuz I was asked nicely ) :)
https://www.chiliproject.org/boards/1/topics/1898?r=1943#message-1943


Replies (31)

RE: Nginx and ChiliProject Server Configuration HowTo ? - Added by Chili Fan at 2012-04-07 05:02 pm

Still no step futher :(, anybody good give me a pointer
or an example of different Application Server for ChiliProject

Thanks

RE: Nginx and ChiliProject Server Configuration HowTo ? - Added by Felix Schäfer at 2012-04-07 09:43 pm

Well, passenger works mostly well and relatively problem-free and can be integrated either with apache, or (I think) nginx, or with passenger standalone with pretty much any web frontend you'd like, have you had a look at it already?

RE: Nginx and ChiliProject Server Configuration HowTo ? - Added by Chili Fan at 2012-04-08 12:05 pm

Yesterday i had seen Passenger by google, thanks for explain the Passenger combo's or passenger standalone, i am on windows platform additonal i would like have a service running rather then a console (like test example webrick) if possible, i go lookup passenger

I go give this a try First, i found a Step by Step guide "By Zach" for second part of ChiliProject setup ApplicationServer,
This Apache Tomcat sounds good to me, lets see if i can get it installed otherwise i take Phusion Passenger route ;)

http://attackofzach.com/?p=52 (Deploying ChiliProject on Tomcat By zach)
http://tomcat.apache.org/index.html
http://tomcat.apache.org/tomcat-7.0-doc/windows-service-howto.html

OffTopic (An idea to increase width of Subject column and decrease width of Last Message column for better and nice overall view)

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-10 10:14 pm

I am stuck at Tomcat getting Internal Server page displayed when Browse at 15, but Test Ruby WEBrick works
maybe configuration.yml or database.yml (due to missing user account) or Setup warbler or Create warFile (i readed somewhere that symlink information could being corrupted by warbler), is mistaken or going wrong, maybe it is possible to deploy without warbler i don't know just as test

Platform Windows x86
01  Install  rubyinstaller-1.9.3-p125.exe Selected Checkboxes 2 and 3 to a folder "ruby" 
02  Extract  sqlite-dll-win32-x86-3071100.zip to folder "ruby"\bin\
03  Extract  sqlite-shell-win32-x86-3071100.zip to folder "ruby"\bin\
04  Install  DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe to a folder "devkit" 
05  Extract  chiliproject-3.0.0.zip Subfolder contents to a folder "chili" 
06  Install  java ensure tomcat uses this java install path
07  Install  apache-tomcat-7.0.27.exe to a folder "tomcat" 

08  Create   File "chili"/config/configuration.yml as provided example one
09  Create   File "chili"/config/database.yml as this one
# sqlite3 (default setup).

production:
  adapter: sqlite3
  database: db/production.sqlite3

development:
  adapter: sqlite3
  database: db/development.sqlite3

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: sqlite3
  database: db/test.sqlite3


09  Open command prompt from folder "devkit" 
    Perform  ruby dk.rb init
    Perform  ruby dk.rb install

10  Open command prompt from folder "chili" 
    Perform  gem update --system
    Perform  gem install bundler
    Perform  bundle install --without=mysql mysql2 postgres rmagick
    Perform  set RAILS_ENV=production
    Perform  bundle exec rake generate_session_store
    Perform  bundle exec rake db:migrate
    Perform  bundle exec rake redmine:load_default_data

11  Test Ruby WEBrick
    Open command prompt from folder "chili" 
    Perform  bundle exec ruby script/server -e production
    Browse   http://localhost:3000/

12  Stop Apache Tomcat
    Perfom  Apache Tomcat service Stop

13  Setup warbler
    Open command prompt from folder "chili" 
    Perform  gem install -r warbler
    Perform  warble config
    Edit   File "chili"/config/warble.rb as this one (left out commented for better overview)
Warbler::Config.new do |config|
  config.dirs = %w(app config lib log vendor tmp)
  config.jar_name = "chili" 
  config.webxml.jruby.compat.version = "1.9" 
end


14  Create WarFile
    Open command prompt from folder "chili" 
    Perform  warble

15  Deploy WarFile
    Copy  File from folder "chili"/chili.war
    To    Folder "tomcat"/webapps/
    Perfom  Apache Tomcat service start (wait a while warFile will be extracted now)
    Browse  http://localhost:8080/chili/
    Browse  http://localhost:8080

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Ishita Tailor at 2012-04-11 10:10 am

Hi ChiliProject Team Members,

Any updates on this?
Is any one able to deploy chiuliproject on Tomcat in windows?
Please reply :(

Chili Fan wrote:

Dear ChiliProject Members[...]I am New To ChiliProject and Managed to Install/Setup Basic Steps Explained Here
at Wiki/Installation, I run Webrick as test example at Wiki Succesfull just Awesome!

Now i want to take next step and Installed Nginx as a service Succefull

I am complete stuck at How to Configure "nginx.conf" File or something I believe, to hook
Nginx To ChiliProject

I try [[http://www.redmine.org/projects/redmine/wiki/HowTo_configure_Nginx_to_run_Redmine]]
and [[https://www.chiliproject.org/projects/chiliproject/wiki/HowTo_configure_Nginx_to_run_ChiliProject]]
but it don't make me sense how exactly i should edit this "nginx.conf" File or maybe there is other way to hook up Nginx To ChiliProject ?[...]For TCPIP i am complete new, is it possible help to setup an example to hook up Nginx To ChiliProject at a single PC ?[...]Thanks InAdvance

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Felix Schäfer at 2012-04-12 06:41 pm

Ishita Tailor wrote:

Any updates on this?
Is any one able to deploy chiuliproject on Tomcat in windows?

I don't know of any of the core devs working on tomcat, so we don't have experience with this sort of setup, sorry. If you can find out what error you get we might be able to help, but just "there's and internal error page" is not very helpful, sorry.

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-12 06:46 pm

Ishita Tailor, could you edit Your reply ?
please remove my Quote about Nginx to have a more nice cleaner view at this Topic,
and check watch button above to stay in watch for any updates

Thanks

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-12 10:55 pm

Hello Felix

I try again soon on Tomcat Okay, see if i can get a better Problem Description but in first glance log folder stays empty, or try Passenger first

i think the setup of "my" warble.rb is Incorrect, 
i don't know if the Set Of Folders specified is correct this means:
config.dirs = %w(app config lib log vendor tmp)
There is also a line for db folder deploy i think:
config.includes = FileList["db"]

Should i use iine: at warble.rb ? ( "sqlite" is added don't if that is correct, and maybe "jruby-openssl" can be left out )

config.gems += ["sqlite", "jruby-openssl", "i18n", "rack"]

I am beginner is it possible to straight copy the Right Set Of Folders straight into webapps chili folder at Tomcat as test
to skip warbler, rather then use Created war File by warbler ?
Is it allowed to have no user and password specified at database.yml ?

Thanks

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Ishita Tailor at 2012-04-13 05:11 am

Hi,

I am successfully able to deploy chiliproject on tomcat and with tomcat we can deploy the application on https as well.
Apache 6.0 already contains the bundles with secured server layer connection.

Thanks for all the replies & help.. :)

Ishita

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-13 06:26 am

Hi Ishita Tailor,

That is good news! Please could you let know your Steps taken to Accomplish ChiliProject Deploy at Tomcat ahnd https ?
Additional i think ChiliProject will pick it up as a Guide

Thanks

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-14 02:25 pm

Hello Felix

I get this Fail Message From 500.html, i try both Tomcat7 and Tomcat6 still no show up same 500 Message of CP,
I found the log folder at root of Tomcat I attached a snippet of local log which i have reduced,

Seems gems are missing but i run a clean install follow my steps above complete and a few warning
which i could solve by warble.rb file adjusting configure min max i guess

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your ChiliProject administrator for assistance.

If you are the ChiliProject administrator, check your log files for details about the error.

Back

Fail-01-AtTomcat.zip - Fail-01-AtTomcat (1.7 kB)

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Felix Schäfer at 2012-04-17 05:51 am

As you have surmised it's a problem with bundler in the warble package not finding gems, but as I don't use warble (nor does any of the other devs as far as I know) I can't help you with that, sorry. The warbler community might be better able to help you.

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-17 07:29 pm

No Sorry thanks for your help, i go try Passenger and Nginx now i looked at their website see if that could shines a light as Application Server, I go ReInstall everything using latest CP and addtional install jruby along ruby, i let know then

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-17 10:33 pm

I ReInstalled everyting but Passenger gem installed but don't what should be next step to get CP Deployed at Passenger thing
For Tomcat this Topic at Ruby looks like simular i deal with http://www.ruby-forum.com/topic/169717
after reading their reply still don't understand which steps to take

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-18 08:24 pm

Just a Mind Spin, Seems Latest CP is working correctly didn't seen any error when install everything and webrick CP is launching

Therefore i think the WarFile creation is missing something or uncomplete by incorrect warble.rb config, or unpacking deploy WarFile by Tomcat went wrong due deployed folder WEB-INF\gems\gems contains less "gems" vs folder gems contents at CP Ruby local contains a lot more gems

This is why i think it reports missing gems at Tomcat log, maybe somebody can let know if WarFile warble.rb mentioned earlier is configured right maybe i should add more "gems" there or point to warble.rb to GemFile of CP

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-04-21 03:08 pm

Due i am new to Ruby and CP still not able to setup an Application Server for a windows sqlite CP, anybody knows any step by step guide how to accomplish or should i run Linux or stick at webrick, passenger i give it a shot but hard for new ones,

Thanks for any help to setup install a Application Server for ChiliProject

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Jim McAleer at 2012-05-23 12:31 pm

Just following up on your comment on my post. I'm using the windows platform however, I prefer, due to known issues with windows etc to run a virtual machine that automatically boots on startup on my windows machine using VirtualBox. You can use the redmine version and switch it to chili. If you get stuck I'll send you my scripts or export my vitual machine for you. I'm currently working with Turnkey Linux to provide installer(s), stack or virtual machines with Chili pre-install and a working svn. Got to http://www.turnkeylinux.org/redmine.

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-05-24 04:30 pm

Hello I go try VirtualBox approach and installer of Turnkey Redmine just to see honestly i had Bitnami Redmine on windows installed as a reference good to know of Turnkey, Next go futher try to install ChiliProject on windows go try mongrel as a service i will let know

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-05-28 02:40 pm

I made some progress by using Application Server for ChiliProject found here
http://stackoverflow.com/questions/877943/how-to-configure-a-rails-app-redmine-to-run-as-a-service-on-windows

I managed only WEBrick to work as a Windows Service, still failing to setup mongrel or tomcat or nginx or other solutions,
Hope to find an other solution as Application Server for ChiliProject to work on windows

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-07-24 03:07 am

References
http://articles.slicehost.com/2008/5/27/ubuntu-hardy-nginx-rails-and-thin
http://code.macournoyer.com/thin/usage/

I just get Thin installed by

  gem install eventmachine --pre
  gem install thin

But failing to get it configured for ChiliProject i try to generate config file but stuck on that one, i think i should manual create a config file as from sample nginx config file example at Thin WebSite and looked at thin --help

Still stuggle by setup a production server for ChiliProject, but thin installed at least keep trying

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-07-25 02:01 pm

These are my steps so far to get ChiliProject Sqlite3 based running at Windows without application server

Platform Windows x86
00  Create   Folders and Content At
----------------------------------------------------------------------------------------------------
|root:\
|  rootchili
|    installers
|      http://rubyforge.org/frs/download.php/76054/rubyinstaller-1.9.3-p194.exe
|      http://www.sqlite.org/sqlite-dll-win32-x86-3071300.zip
|      http://www.sqlite.org/sqlite-shell-win32-x86-3071300.zip
|      https://github.com/downloads/oneclick/rubyinstaller/DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe
|      https://www.chiliproject.org/attachments/download/361/chiliproject-3.3.0.zip
|    ruby
|    rubydevkit
|    chiliproject
----------------------------------------------------------------------------------------------------
01  Install  rubyinstaller-1.9.3-p194.exe Selected Checkboxes 2 and 3 to a folder "ruby" 
02  Extract  sqlite-dll-win32-x86-3071300.zip to folder "ruby"\bin\
03  Extract  sqlite-shell-win32-x86-3071300.zip to folder "ruby"\bin\
04  Install  DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe to a folder "rubydevkit" 
05  Extract  chiliproject-3.3.0.zip Subfolder contents to a folder "chiliproject" 

06  Create   File "chiliproject"/config/configuration.yml as provided example one
07  Create   File "chiliproject"/config/database.yml as this one
----------------------------------
|# sqlite3 (default setup).
|
|production:
|  adapter: sqlite3
|  database: db/production.sqlite3
|
----------------------------------
08  Open command prompt from folder "rubydevkit" 
    Perform  "root:\rootchili\ruby\bin\ruby" dk.rb init
    Perform  "root:\rootchili\ruby\bin\ruby" dk.rb install
09  Open command prompt from folder "chiliproject" 
    Perform  "root:\rootchili\ruby\bin\ruby" -S gem update --system
    Perform  gem install sqlite3
    Perform  "root:\rootchili\ruby\bin\ruby" -S gem install bundler

10  Perform  "root:\rootchili\ruby\bin\ruby" -S bundle install --without=mysql mysql2 postgres rmagick
    Perform  set RAILS_ENV=production
    Perform  "root:\rootchili\ruby\bin\ruby" -S rake generate_session_store RAILS_ENV=production
    Perform  "root:\rootchili\ruby\bin\ruby" -S rake db:migrate RAILS_ENV=production
    Perform  "root:\rootchili\ruby\bin\ruby" -S rake redmine:load_default_data RAILS_ENV=production

11  Perform  "root:\rootchili\ruby\bin\ruby" -S script/server -p 3000 -e production RAILS_ENV=production
    CheckAt  http://localhost:3000/

http://rubyforge.org/frs/download.php/76054/rubyinstaller-1.9.3-p194.exe
http://www.sqlite.org/sqlite-dll-win32-x86-3071300.zip
http://www.sqlite.org/sqlite-shell-win32-x86-3071300.zip
https://github.com/downloads/oneclick/rubyinstaller/DevKit-tdm-32-4.5.2-20111229-1559-sfx.exe
https://www.chiliproject.org/attachments/download/361/chiliproject-3.3.0.zip
-
http://localhost:3000/

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-07-26 05:41 pm

At the moment i give Thin a try to run ChiliProject but it fails

thin -p 3000 -e production -A rails start

lib/thin/backends/tcp_server.rb:16:  in `connect':
 cannot load such file -- thin/connection (MissingSourceFile)

I also try rack and manual created a file config.ru but it fails the same
------------------------------------------------------------
|#root:\rootchili\chiliproject\config.ru
|
|require File.expand_path("../config/environment", __FILE__)
|#require File.dirname(__FILE__) + '/config/environment'
|
|run ActionController::Dispatcher.new
|
------------------------------------------------------------

thin -p 3000 -e production -A rack start

lib/thin/backends/tcp_server.rb:16:  in `connect':
 cannot load such file -- thin/connection (MissingSourceFile)

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Chili Fan at 2012-07-26 06:52 pm

From these References it mentioned Thin needs to be added to Gemfile therfore big chance to solve this
http://www.redmine.org/boards/2/topics/31912
https://github.com/macournoyer/thin/issues/115
https://www.chiliproject.org/boards/1/topics/1331 By Felix Schäfer

At root:\rootchili\chiliproject\ there are two files
Gemfile
Gemfile.lock

What is correct way to Add Thin to Gemfile and update the Gemfile.lock ?
are any other steps need to be Repeated and Perform from above posted Install Step list ?


OffTopic Replacing WEBrick by Thin as default
http://stackoverflow.com/questions/7047496/how-to-set-thin-as-default-in-rails-3

RE: [HowTo] Install ChiliProject with SQLite and Appache Tomcat Configuration ? - Added by Felix Schäfer at 2012-07-26 08:38 pm

Chili Fan wrote:

-What is correct way to Add Thin to Gemfile and update the Gemfile.lock ?
are any other steps need to be Repeated and Perform from above posted Install Step list ?

You can add gems you need locally on your install to a Gemfile.local file and run bundle install.

1 2 Next » (1-25/31)