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.

Installation of chli 2.6.0 and database problem

Added by Marcin Garski at 2012-01-31 07:52 am

Hi,
I've installed chili in earlier version and there was no problem. When I tried to install it on Debian yesterday there was some problem with database. I don't know why chili wants to use mysql database. I got this error:
no such file to load -- mysql (MissingSourceFile)
I haven't got installed mysql server, just postgres.
Can anyone help me?
Gary


Replies (9)

RE: Installation of chli 2.6.0 and database problem - Added by Felix Schäfer at 2012-01-31 08:51 am

Hello Marcin,

Have you edited your config/database.yml file to reflect that you want to use postgres and not mysql?

RE: Installation of chli 2.6.0 and database problem - Added by Marcin Garski at 2012-01-31 08:55 am

Hey,
Yes, I have. I've checked the old version of chili I installed some time ago. It is 2.4.0, and there was no problem. I test my new chili with WEBrick server from scripts/ and there is no problem, it works perfectly.:/
I don't know why chili wants to use mysql adapter on production, it's strange.

RE: Installation of chli 2.6.0 and database problem - Added by Felix Schäfer at 2012-01-31 08:58 am

Indeed, could you post your database.yml?

RE: Installation of chli 2.6.0 and database problem - Added by Marcin Garski at 2012-01-31 09:01 am

Of course.
-------------------------

# MySQL (default setup).

production:
  adapter: postgresql
  database: chiliproject
  host: localhost
  username: chiliproject
  password: **_pasword_**
  port: 5432
  encoding: utf8

development:
  adapter: mysql
  database: chiliproject_development
  host: localhost
  username: root
  password:
  encoding: utf8

# 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: mysql
  database: chiliproject_test
  host: localhost
  username: root
  password:
  encoding: utf8

test_pgsql:
  adapter: postgresql
  database: chiliproject_test
  host: localhost
  username: postgres
  password: "postgres" 

test_sqlite3:
  adapter: sqlite3
  database: db/test.sqlite3

[Edit Holger Just: Fix formatting]

RE: Installation of chli 2.6.0 and database problem - Added by Marcin Garski at 2012-01-31 09:02 am

Sorry for formating, '#' sign must be different interpreted.

RE: Installation of chli 2.6.0 and database problem - Added by Holger Just at 2012-01-31 09:06 am

Marcin, I edited your post to fix the formatting.

As for your issue, are your sure you are running under production mode? Rails typically defaults to development. You have to tell it explicitly that you want production mode everytime by running setting RAILS_ENV=production

RE: Installation of chli 2.6.0 and database problem - Added by Marcin Garski at 2012-01-31 09:12 am

During installation I executed

RAILS_ENV=production bundle exec rake db:migrate

and
RAILS_ENV=production bundle exec rake redmine:load_default_data

Otherway I think test with WEBrick server could have some problems, or maybe I'm wrong

Also checked this:

root@ares:/srv/www/chiliproject# echo $RAILS_ENV
production

RE: Installation of chli 2.6.0 and database problem - Added by Holger Just at 2012-01-31 09:21 am

You also have to start your webrick like

RAILS_ENV=production script/server

or

script/server -e production

If that still doesn't work, please try to remove the config.ru file from your ChiliProject installation directory.

Note that for production use you should use a real application server like Passenger.

RE: Installation of chli 2.6.0 and database problem - Added by Marcin Garski at 2012-01-31 09:26 am

Wow, removing configu.ru fixed my problem, chili works.
Thanks for help!

(1-9/9)