[chiliproject]Installation, mysql

Applications, problèmes de configuration réseau
Tucky
Daikyu
Messages : 85
Inscription : dim. 18 oct. 2009, 11:55

[chiliproject]Installation, mysql

Message par Tucky »

Bonjour,

j’ai installé chiliproject à partir du PKGBUILD venant de aur que j’ai modifié pour correspondre à la dernière version.

Je suis les indications de la page officielle.

Code : Tout sélectionner

$ cd /var/lib/chiliproject
$ sudo bundle install --without=test development sqlite postgres mysql
Using rake (10.0.3) 
[…]
Using bundler (1.2.2) 
Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed.

Code : Tout sélectionner

$ --> mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.5.29-log Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> create database chiliproject character set utf8;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| chiliproject       |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

mysql> create user 'chiliproject' identified by 'my_password';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT USER FROM mysql.user;
+--------------+
| USER         |
+--------------+
| chiliproject |
| root         |
| root         |
| root         |
+--------------+
4 rows in set (0.00 sec)

mysql> grant all privileges on chiliproject.* to 'chiliproject'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
Mon fichier database.yml (le fichier configuration.yml n’a pas été touché):
# MySQL (default setup).

production:
adapter: mysql2
database: chiliproject
host: localhost
username: chiliproject
password: my_password
encoding: utf8
Et maintenant, le moment fatidique:

Code : Tout sélectionner

$ sudo bundle exec rake generate_session_store
$ sudo RAILS_ENV=production bundle exec rake db:migrate
rake aborted!
Access denied for user 'chiliproject'@'localhost' (using password: YES)
/var/lib/chiliproject/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:218:in `quoted_left_column_name'
/var/lib/chiliproject/vendor/plugins/awesome_nested_set/lib/awesome_nested_set.rb:94:in `acts_as_nested_set'
/var/lib/chiliproject/app/models/issue.rb:33:in `<class:Issue>'
/var/lib/chiliproject/app/models/issue.rb:15:in `<top (required)>'
/var/lib/chiliproject/vendor/plugins/engines/lib/engines/rails_extensions/dependencies.rb:133:in `require_or_load_with_engine_additions'
<internal:prelude>:10:in `synchronize'
/var/lib/chiliproject/config/environment.rb:45:in `<top (required)>'
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)
Et ce que je ne comprends pas non-plus, c’est:

Code : Tout sélectionner

$ mysql -u chiliproject -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'chiliproject'@'localhost' (using password: YES)
Si quelqu’un veut bien éclairer ma lanterne, je lui en serai reconnaissant.
Avatar de l’utilisateur
benjarobin
Maître du Kyudo
Messages : 17632
Inscription : sam. 30 mai 2009, 15:48
Localisation : Lyon

Re: [chiliproject]Installation, mysql

Message par benjarobin »

Le create user ne va pas, il faut faire :

Code : Tout sélectionner

create user 'chiliproject'@'localhost' identified by 'my_password';
Mais personnellement je préfère utiliser phpmyadmin :D
Zsh | KDE | PC fixe : AMD Ryzen 9900X, Radeon RX 7700 XT
Titre d'un sujet : [Thème] Sujet (état) / Règles du forum
Tucky
Daikyu
Messages : 85
Inscription : dim. 18 oct. 2009, 11:55

Re: [chiliproject]Installation, mysql

Message par Tucky »

Merci benjarobin, ce n’est pas la première fois que tu m’es d’une aide précieuse!
(au passage, ça veut dire que leur wiki n’est pas correct?)

Maintenant que c’est installé, ben ça ne fonctionne pas:

Code : Tout sélectionner

sudo bundle exec script/server -e production
/usr/lib/ruby/gems/1.9.1/gems/activesupport-2.3.15/lib/active_support/inflector.rb:3:in `<top (required)>': iconv will be deprecated in the future, use String#encode instead.
=> Booting WEBrick
=> Rails 2.3.15 application starting on http://0.0.0.0:3000
NOTE: Gem.source_index is deprecated, use Specification. It will be removed on or after 2011-11-01.
Gem.source_index called from /usr/lib/ruby/gems/1.9.1/gems/rails-2.3.15/lib/rails/gem_dependency.rb:21.
=> Call with -d to detach
=> Ctrl-C to shutdown server
[2013-01-09 15:40:06] INFO  WEBrick 1.3.1
[2013-01-09 15:40:06] INFO  ruby 1.9.3 (2012-12-25) [x86_64-linux]
[2013-01-09 15:40:06] INFO  WEBrick::HTTPServer#start: pid=16185 port=3000


Processing WelcomeController#index (for 127.0.0.1 at 2013-01-09 15:40:09) [GET]
  Parameters: {"controller"=>"welcome", "action"=>"index"}

SystemStackError (stack level too deep):
  

Rendering rescues/layout (internal_server_error)
Quand je vais sur http://localhost:3000/:
SystemStackError in WelcomeController#index
stack level too deep

RAILS_ROOT: /var/lib/chiliproject
Application Trace | Framework Trace | Full Trace
/usr/lib/ruby/gems/1.9.1/gems/activerecord-2.3.15/lib/active_record/transactions.rb:217
Request

Parameters:
None


Show session dump
---
...
Response

Headers:
{"Cache-Control"=>"no-cache",
"Content-Type"=>""}
Et si je tente avec thin, il semble qu’essaie avec l’environement de developpement:

Code : Tout sélectionner

sudo thin start
>> Using rails adapter
/usr/lib/ruby/gems/1.9.1/gems/activesupport-2.3.15/lib/active_support/inflector.rb:3:in `<top (required)>': iconv will be deprecated in the future, use String#encode instead.
NOTE: Gem.source_index is deprecated, use Specification. It will be removed on or after 2011-11-01.
Gem.source_index called from /usr/lib/ruby/gems/1.9.1/gems/rails-2.3.15/lib/rails/gem_dependency.rb:21.
/usr/lib/ruby/gems/1.9.1/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/connection_specification.rb:62:in `establish_connection': development database is not configured (ActiveRecord::AdapterNotSpecified)
        from /usr/lib/ruby/gems/1.9.1/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/connection_specification.rb:55:in `establish_connection'
        from /usr/lib/ruby/gems/1.9.1/gems/rails-2.3.15/lib/initializer.rb:438:in `initialize_database'
        from /usr/lib/ruby/gems/1.9.1/gems/rails-2.3.15/lib/initializer.rb:141:in `process'
[…]
Répondre