A Redmine plugin which manages your gitosis configuration based on your projects and memberships in Redmine. Includes Public Key management views (extracted from http://plan.io).
Home Page: http://plan.io
It seems you're using integers for boolean values, which is ok with mysql, but it makes postgres angry. Here's the output from my production logs:
Processing GitosisPublicKeysController#index (for 10.96.2.8 at 2010-06-15 17:14:47) [GET]
Parameters: {"action"=>"index", "controller"=>"gitosis_public_keys"}
ActiveRecord::StatementInvalid (PGError: ERROR: operator does not exist: boolean = integer
LINE 1: ... FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND (...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT * FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND ("gitosis_public_keys".user_id = 4) ORDER BY active DESC, created_at DESC):
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:188:in log' /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:503:inexecute'
/vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:1000:in select_raw' /vendor/rails/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:987:inselect'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in select_all_without_query_cache' /vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:62:inselect_all'
/vendor/rails/activerecord/lib/active_record/base.rb:635:in find_by_sql' /vendor/rails/activerecord/lib/active_record/base.rb:1490:infind_every'
/vendor/rails/activerecord/lib/active_record/base.rb:589:in find' /vendor/rails/activerecord/lib/active_record/base.rb:609:inall'
/vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:370:in send' /vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:370:inmethod_missing'
/vendor/rails/activerecord/lib/active_record/base.rb:2005:in with_scope' /vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:202:insend'
/vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:202:in with_scope' /vendor/rails/activerecord/lib/active_record/associations/association_collection.rb:366:inmethod_missing'
/vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:17:in index' /vendor/rails/actionpack/lib/action_controller/base.rb:1256:insend'
/vendor/rails/actionpack/lib/action_controller/base.rb:1256:in perform_action_without_filters' /vendor/rails/actionpack/lib/action_controller/filters.rb:617:incall_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in perform_action_without_benchmark' /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:inperform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in measure' /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:inperform_action_without_rescue'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:136:in perform_action' /vendor/rails/actionpack/lib/action_controller/base.rb:524:insend'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in process_without_filters' /vendor/rails/actionpack/lib/action_controller/filters.rb:606:inprocess_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in process_without_test' /vendor/rails/actionpack/lib/action_controller/test_process.rb:18:inprocess'
/vendor/rails/actionpack/lib/action_controller/base.rb:392:in process' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:184:inhandle_request'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:112:in dispatch_unlocked' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:125:indispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:124:in synchronize' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:124:indispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:134:in dispatch_cgi' /vendor/rails/actionpack/lib/action_controller/dispatcher.rb:41:indispatch'
/usr/lib/ruby/1.8/mongrel/rails.rb:76:in process' /usr/lib/ruby/1.8/mongrel/rails.rb:74:insynchronize'
/usr/lib/ruby/1.8/mongrel/rails.rb:74:in process' /usr/lib/ruby/1.8/mongrel.rb:159:inprocess_client'
/usr/lib/ruby/1.8/mongrel.rb:158:in each' /usr/lib/ruby/1.8/mongrel.rb:158:inprocess_client'
/usr/lib/ruby/1.8/mongrel.rb:285:in run' /usr/lib/ruby/1.8/mongrel.rb:285:ininitialize'
/usr/lib/ruby/1.8/mongrel.rb:285:in new' /usr/lib/ruby/1.8/mongrel.rb:285:inrun'
/usr/lib/ruby/1.8/mongrel.rb:268:in initialize' /usr/lib/ruby/1.8/mongrel.rb:268:innew'
/usr/lib/ruby/1.8/mongrel.rb:268:in run' /usr/lib/ruby/1.8/mongrel/configurator.rb:282:inrun'
/usr/lib/ruby/1.8/mongrel/configurator.rb:281:in each' /usr/lib/ruby/1.8/mongrel/configurator.rb:281:inrun'
/usr/bin/mongrel_rails:129:in run' /usr/lib/ruby/1.8/mongrel/command.rb:212:inrun'
/usr/bin/mongrel_rails:282
Rendering /usr/share/redmine/public/500.html (500 Internal Server Error)
Clicking Public keys under My Account results in
ActiveRecord::StatementInvalid (PGError: ERROR: operator does not exist: boolean = integer
LINE 1: ... FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND (...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT * FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND ("gitosis_public_keys".user_id = 3) ORDER BY active DESC, created_at DESC):
vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:17:in `index'
I've spent a ridiculous amount of time trying to get this to work. This time through I wrote down every single step. My current problem recreation steps:
git push origin masterAnd I get prompted for a password. I have verified that I have the private key in my ~/.ssh directory and that Redmine has the correct public key listed under http://redmine/my/public_keys. When I enter text at the prompt or just hit enter, it prompts again until it quits. Each time creates an entry in /var/log/auth.log:
pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=192.168.191.240 user=gitosis
Aug 17 13:13:15
... sshd[2542]: Failed password for gitosis from 192.168.1.2 port 56278 ssh2
What else can I do to diagnose the problem? Thank you so much!
My installation steps (Ubuntu 11.04):
#!/bin/bash
# first argument: server name (redmine.example.com)
apt-get install git-core
mkdir /var/www
cd /var/www
git clone git://github.com/edavis10/redmine.git
cd redmine
git checkout -b 1.2-stable
apt-get install -y ruby ruby1.9.1-dev libgemplugin-ruby libgemplugin-ruby1.8 mysql-server apache2-mpm-prefork wget libruby-extras libruby1.8-extras rake apache2-prefork-dev libapache-dbi-perl libapache2-mod-perl2 libdigest-sha1-perl libmysqlclient15-dev build-essenti\
al libcurl4-openssl-dev cron librmagick-ruby1.8
echo "CREATE DATABASE redmine CHARACTER SET utf8;
CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'my_password';
GRANT ALL privileges ON redmine.* TO 'redmine'@'localhost';
" | mysql -u root -p
cd redmine
echo "production:
adapter: mysql
database: redmine
host: localhost
username: redmine
password: my_password
encoding: utf8
" > config/database.yml
tail -n 30 config/database.yml.example >> config/database.yml
apt-get install -y rubygems1.8
gem install rails -v=2.3.11
gem install rack -v=1.1.1
gem install mysql
gem install -v=0.4.2 i18n
chown -R www-data:www-data .
chmod -R 755 files log tmp
cp Rakefile tmpR
head -n 6 tmpR > Rakefile
echo "
require 'rake/dsl_definition'
" >> Rakefile
tail -n 4 tmpR >> Rakefile
rm tmpR
rake generate_session_store
RAILS_ENV=production rake db:migrate
RAILS_ENV=production rake redmine:load_default_data
apt-get install -y libapache2-mod-passenger
echo '
<VirtualHost *:80>
ServerName $1
DocumentRoot /var/www/redmine/public
PassengerDefaultUser www-data
RailsEnv production
RailsBaseURI /redmine
SetEnv X_DEBIAN_SITEID "default"
<Directory /var/www/redmine/public>
Order allow,deny
Allow from all
</Directory>
</VirtualHost>
' > /etc/apache2/sites-available/redmine
echo "
Include /etc/apache2/mods-available/passenger.conf
" >> /etc/apache2/apache2.conf
ln -s /etc/apache2/sites-available/redmine /etc/apache2/sites-enabled/redmine
rm /etc/apache2/sites-enabled/000-default
gem install inifile
apt-get install -y libnet-ssh-ruby1.8 python-setuptools
gem install lockfile net-ssh
apt-get install -y gitosis git-daemon-run acl
/etc/init.d/apache2 restart
Activate acl for my partition, reboot, then:
#!/bin/bash
sudo -H -u gitosis ssh-keygen -t dsa
sudo -u gitosis cat /srv/gitosis/.ssh/id_dsa.pub | sudo -H -u gitosis gitosis-init
sudo sed -i.orig 's:/var/cache:/srv/gitosis:g' /etc/sv/git-daemon/run
setfacl -m user:www-data:r-x,mask:r-x /srv/gitosis/.ssh
setfacl -m user:www-data:r--,mask:r-- /srv/gitosis/.ssh/id_dsa
cd /var/www/redmine
script/plugin install git://github.com/xdissent/redmine_gitosis.git
sudo -u www-data X_DEBIAN_SITEID=default RAILS_ENV=production rake db:migrate:plugins
/etc/init.d/apache2 restart
Why does this plugin disable any other SCM?
Running the redmine-gitosis plugin on Gentoo, with thin, I get this error when I go the the "/my/public_keys" page.
NameError (uninitialized constant GitosisPublicKeysController::ARCondition): vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:15:inindex'
thin (1.2.11) lib/thin/connection.rb:84:in pre_process' thin (1.2.11) lib/thin/connection.rb:82:incatch'
thin (1.2.11) lib/thin/connection.rb:82:in pre_process' thin (1.2.11) lib/thin/connection.rb:57:inprocess'
thin (1.2.11) lib/thin/connection.rb:42:in receive_data' eventmachine (0.12.10) lib/eventmachine.rb:256:inrun_machine'
eventmachine (0.12.10) lib/eventmachine.rb:256:in run' thin (1.2.11) lib/thin/backends/base.rb:61:instart'
thin (1.2.11) lib/thin/server.rb:159:in start' thin (1.2.11) lib/thin/controllers/controller.rb:86:instart'
thin (1.2.11) lib/thin/runner.rb:185:in send' thin (1.2.11) lib/thin/runner.rb:185:inrun_command'
thin (1.2.11) lib/thin/runner.rb:151:in run!' thin (1.2.11) bin/thin:6 /usr/bin/thin:8:inload'
/usr/bin/thin:8`
How can I solve that?
Best regards,
Samuel.
Hi
As noticed here :
http://www.redmine.org/boards/3/topics/13901
The redmine-gitosis-xxx folder in /tmp/ exist but remains empty when trying to create a new redmine project with gitosis plugin activated.
Hi guys. Sorry about use this way to contact you.
I've instaled redmine-gitosis but I don't know why it doesn't work.
Redmine report this:
Processing GitosisPublicKeysController#index (for 189.123.192.43 at 2010-05-23 15:08:49) [GET]
Parameters: {"action"=>"index", "controller"=>"gitosis_public_keys"}
ActiveRecord::StatementInvalid (SQLite3::SQLException: no such table: gitosis_public_keys: SELECT * FROM "gitosis_public_keys" WHERE (1=1 AND (active=1)) AND ("gitosis_public_keys".user_id = 3) ORDER BY active DESC, created_at DESC):
vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:17:in index' /dh/passenger/lib/phusion_passenger/rack/request_handler.rb:92:inprocess_request'
/dh/passenger/lib/phusion_passenger/abstract_request_handler.rb:207:in main_loop' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:400:instart_request_handler'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:351:in handle_spawn_application' /dh/passenger/lib/phusion_passenger/utils.rb:184:insafe_fork'
/dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:349:in handle_spawn_application' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:insend'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in main_loop' /dh/passenger/lib/phusion_passenger/abstract_server.rb:196:instart_synchronously'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:163:in start' /dh/passenger/lib/phusion_passenger/railz/application_spawner.rb:209:instart'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:262:in spawn_rails_application' /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:126:inlookup_or_add'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:256:in spawn_rails_application' /dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:80:insynchronize'
/dh/passenger/lib/phusion_passenger/abstract_server_collection.rb:79:in synchronize' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:255:inspawn_rails_application'
/dh/passenger/lib/phusion_passenger/spawn_manager.rb:154:in spawn_application' /dh/passenger/lib/phusion_passenger/spawn_manager.rb:287:inhandle_spawn_application'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:352:in __send__' /dh/passenger/lib/phusion_passenger/abstract_server.rb:352:inmain_loop'
/dh/passenger/lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Using redmine to create the repositorie gives the same error: "no such table"
Thanks and sorry for annoying you guys
Hi,
we are using your git plugin in our redmine (0.9.6) and got some file locking error recently. It is no longer possible for our users (students) to login since the Gitosis plugin tries to get a lock (in lib/gitosis.rb:21) which obviously sometimes fails.
Not related to that specific problem when trying to find the error we came over the GitosisObserver (app/models/gitosis_observer.rb), more specifically line 14. Is it correct that you call the update_repositories method there instead of the destroy_repositories method? We observed that the plugin does not delete the repositories (*.git) in the filesystem and as a workaround wrote a script that does it. But if this might be the cause why it doesn't delete them it might be a much better fix.
I'd appreciate any comment.
Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your redMine administrator for assistance.
Processing ProjectsController#add (for 192.168.0.11 at 2008-10-02 23:18:26) [POST]
Parameters: {"enabled_modules"=>["issue_tracking", "time_tracking", "news", "documents", "files", "wiki", "repository", "boards"], "commit"=>"Save", "action"=>"add", "authenticity_token"=>"fE5nAN4b8fuCUGalwpKOvY2yK8QgQlN4C+3mQQDT61Q=", "project"=>{"name"=>"new project test", "tracker_ids"=>["1", "2", "3", ""], "homepage"=>"", "parent_id"=>"", "is_public"=>"1", "description"=>"", "identifier"=>"monkey"}, "controller"=>"projects"}
Errno::ENOENT (No such file or directory - /tmp/redmine-gitosis-1223000306/gitosis/gitosis.conf):
inifile (0.3.0) lib/inifile.rb:67:in initialize' inifile (0.3.0) lib/inifile.rb:67:inopen'
inifile (0.3.0) lib/inifile.rb:67:in write' /usr/lib/ruby/1.8/lockfile.rb:284:inlock'
/usr/lib/ruby/1.8/lockfile.rb:539:in attempt' /usr/lib/ruby/1.8/lockfile.rb:539:incatch'
/usr/lib/ruby/1.8/lockfile.rb:539:in attempt' /usr/lib/ruby/1.8/lockfile.rb:539:inloop'
/usr/lib/ruby/1.8/lockfile.rb:539:in attempt' /usr/lib/ruby/1.8/lockfile.rb:210:inlock'
/usr/lib/ruby/1.8/lockfile.rb:199:in initialize' /usr/lib/ruby/1.8/lockfile.rb:559:innew'
/usr/lib/ruby/1.8/lockfile.rb:559:in Lockfile' vendor/plugins/redmine_gitosis/app/models/gitosis_observer.rb:21:inupdate_repositories'
vendor/plugins/redmine_gitosis/app/models/gitosis_observer.rb:13:in after_save' /usr/lib/ruby/1.8/observer.rb:185:innotify_observers'
/usr/lib/ruby/1.8/observer.rb:184:in each' /usr/lib/ruby/1.8/observer.rb:184:innotify_observers'
app/controllers/projects_controller.rb:78:in add' passenger (2.2.11) lib/phusion_passenger/rack/request_handler.rb:92:inprocess_request'
passenger (2.2.11) lib/phusion_passenger/abstract_request_handler.rb:207:in main_loop' passenger (2.2.11) lib/phusion_passenger/railz/application_spawner.rb:418:instart_request_handler'
passenger (2.2.11) lib/phusion_passenger/railz/application_spawner.rb:358:in handle_spawn_application' passenger (2.2.11) lib/phusion_passenger/utils.rb:184:insafe_fork'
passenger (2.2.11) lib/phusion_passenger/railz/application_spawner.rb:354:in handle_spawn_application' passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:352:insend'
passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:352:in main_loop' passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:196:instart_synchronously'
passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:163:in start' passenger (2.2.11) lib/phusion_passenger/railz/application_spawner.rb:213:instart'
passenger (2.2.11) lib/phusion_passenger/spawn_manager.rb:262:in spawn_rails_application' passenger (2.2.11) lib/phusion_passenger/abstract_server_collection.rb:126:inlookup_or_add'
passenger (2.2.11) lib/phusion_passenger/spawn_manager.rb:256:in spawn_rails_application' passenger (2.2.11) lib/phusion_passenger/abstract_server_collection.rb:80:insynchronize'
passenger (2.2.11) lib/phusion_passenger/abstract_server_collection.rb:79:in synchronize' passenger (2.2.11) lib/phusion_passenger/spawn_manager.rb:255:inspawn_rails_application'
passenger (2.2.11) lib/phusion_passenger/spawn_manager.rb:154:in spawn_application' passenger (2.2.11) lib/phusion_passenger/spawn_manager.rb:287:inhandle_spawn_application'
passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:352:in __send__' passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:352:inmain_loop'
passenger (2.2.11) lib/phusion_passenger/abstract_server.rb:196:in `start_synchronously'
Rendering /home/railsapps/redmine.eximbiz.com.br/public/500.html (500 Internal Server Error)
I suppose I am the first to try this as a plugin? Perhaps just the first to try and report back.
lib/gitosis.rb:
# commands
- ENV['GIT_SSH'] = SSH_WITH_IDENTITY_FILE = File.join(RAILS_ROOT, 'vendor/plugins/redmine_gitosis/extra/ssh_with_identity_file.sh')
+ ENV['GIT_SSH'] = SSH_WITH_IDENTITY_FILE = File.join(RAILS_ROOT, 'vendor/plugins/redmine-gitosis/extra/ssh_with_identity_file.sh')
That's the directory it will end up in by default for us since that's how your git repo is named. Other than that I believe I can say it works just fine in a clean environment. A few short words in the readme about configuration would make it an entirely painless install I think.
Hi all.
name of key files consists of user.login.underscore, title.underscore and id, but id is not defined yet
therefore file naming seems to be broken :
username-title-
username-title2-
...
Had anyone faced this problem?
We have an existing gitosis setup, and as far as I can tell from the code we'd have to start from scratch by using this. It would be great if we could have a script to read the keydir, try to map keyfiles to users (by filename, in our case) and do an initial key setup.
The recently released version 1.2.0 of Redmine introduced a new per project setting "Report last commit for files and directories" for displaying git repositories (see http://www.redmine.org/issues/8365). The new setting is editable in the project settings repository pane.
When the redmine_gitosis plugin is installed, that option is no longer visible and selectable in the repository pane of the project settings.
In "app/models/gitosis_public_key.rb", the lines:
STATUS_ACTIVE = 1
STATUS_LOCKED = 0
are problematic when used with PostgreSQL. The following changes fix it:
STATUS_ACTIVE = TRUE
STATUS_LOCKED = FALSE
But I'm not sure if this will work for other databases too.
Platform: GNU/Linux, ruby 1.8.7, rails 2.3.5, redmine 1.0.0, postgresql-8.4
On link from profile (http://localhost:3000/my/public_keys) I get such error: "undefined method `gitosis_public_keys' for #User:0x7f220c19a958"
Little part of a traceback:
/home/srv/redmine/vendor/rails/activerecord/lib/active_record/attribute_methods.rb:260:in method_missing' /home/srv/redmine/vendor/plugins/redmine_gitosis/app/controllers/gitosis_public_keys_controller.rb:17:inindex'
Migration was successful, gitosis_public_keys table was created.
I tried some other methods, as gitosis_public_keys/new. It creates entry in db, but after that redirects to http://localhost:3000/my/public_keys, and crashes.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.