Open link in a new tab

Content

Expand project menu

Ticket notification via e-mail

Hello,

we use the 4.2.0 Alpha.

Generally e-mail sending works. We get new account mails.

But ticket notifications are not send send.

I set it up for the user, in the ticket the e-mail notification is also activated.

Any idea where i can search to resolve this issue ?

Best wishes

Niels

Message actions

this time it made some progress
I found that in logs:
2015-06-09T10:16:25+0200: [Worker(delayed_job host:openproject pid:14695)] DeliverWorkPackageUpdatedJob failed with OpenSSL::SSL::SSLError: hostname “localhost” does not match the server certificate - 9 failed attempts

That’s look normal because is an self-signed certificate but i can send test e-mails from configuration menu.
I will take a look and come back

Message actions

It still complaint about certificate.
This is (i hope) the relevant part of configuration.yml
we use apache with passenger, after each change in config i restart apache2, that’s correct?

cat config/configuration.yml
production:

email_delivery_method: “smtp”
smtp_address: ‘myserver’

  1. smtp_enable_starttls_auto: ‘false’
  2. smtp_ssl: ‘false’
    smtp_authentication: :login
    smtp_openssl_verify_mode: ‘none’
    smtp_user_name: “myuser”
    smtp_password: “mypass”
    smtp_domain: ‘mydomain’

Still
9:42 +0200>, <From: openproject@sf-solutions.net>, <To: np@sf-solutions.net>, <Message-ID: <openproject.work_package-6-3.20150609083453@sf-solutions.net>>, <References: <openproject.work_package-6-3.20150607082335@sf-solutions.net>>, <Subject: [SF-Admin-Work - Feature #3] Create sieverule on mailserver>, <Mime-Version: 1.0>, <Content-Type: multipart/alternative; boundary=“—==_mimepart_5576a64e80ba2_396794732014201d”; charset=UTF-8>, <Content-Transfer-Encoding: 7bit>, <X-OpenProject-Project: sf-admin-work>, <X-OpenProject-Issue-Id: 3>, <X-OpenProject-Issue-Author: niels>, <X-OpenProject-Type: WorkPackage>, <X-OpenProject-Issue-Assignee: mbadici>, <X-Mailer: OpenProject>, <X-OpenProject-Host: pm.sf-solutions.net>, <X-OpenProject-Site: SF-Solutions Project Management>, <Precedence: bulk>, <Auto-Submitted: auto-generated>>>): hostname “localhost” does not match the server certificate
2015-06-09T10:39:42+0200: [Worker(delayed_job host:openproject pid:14695)] DeliverWorkPackageUpdatedJob failed with OpenSSL::SSL::SSLError: hostname “localhost” does not match the server certificate - 5 failed attempts
2015-06-09T10:39:42+0200: [Worker(delayed_job host:openproject pid:14695)] 4 jobs processed at 7.3988 j/s, 4 failed …

Message actions

Din on google and found i need to run ./script/delayed_job .
It works after restart.
Many thanks!

Message actions

I think I’m having this same problem…however, I used the packaged installer for openproject-ce (Debian Wheezy) and the paths are all different.

I’ve tried various combinations, but none have worked, even on the command line.

Running this on the command line:
cd /opt/openproject-ce; /opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake jobs:workoff

returns:
/usr/bin/env: ruby: No such file or directory

Please Help :)

Thanks
Kendell

Message actions

Also, running “openproject-ce run check” returns:

[ok] MySQL configuration is working
[ok] Web server is running
[ok] openproject server is running
[ok] openproject background job worker is running
sending test email using SMTP…
[ok] test email sent to administrator@epiworks.com

I do receive the email, so I’m pretty confident the config is correct…it’s just a cron thing.

Message actions

Hi Kendell,

it looks as if ruby is not part of your PATH environment variable. If so you need to specify it in your .bashrc or .profile. Can you please post the result of

which ruby

Kind regards

Jens

Message actions

“which ruby” runs, but returns nothing at all…just jumps to the next command line.

a “locate ruby” finds a bunch of stuff at:
/opt/openproject-ce/vendor/ruby-2.1.5/lib/ruby/2.1.0/

Maybe that’s where I should be pointing?

Again, this was installed using the packaged installer…there are no instructions on the directions for that for setting up a cron job.

Thanks!
Kendell

Message actions

Hi Kendell,

let’s try this differently. My colleagues informed me that you need to call ruby via openproject-ce so

openproject-ce run ruby --version

should work.

That would mean that you should try running:

cd /opt/openproject-ce; openproject-ci run /opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake jobs:workoff

Does this help?

Message actions

Result from “openproject-ce run ruby —version”:
ruby 2.1.5p273 (2014-11-13 revision 48405) [x86_64-linux]

Ran the following from the command line:
cd /opt/openproject-ce; openproject-ce run /opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake jobs:workoff

Result:

require ‘rails/all’… 0.450s
Bundler.require… 1.840s
DEPRECATION WARNING: You have Rails 2.3-style plugins in vendor/plugins! Support for these plugins will be removed in Rails 4.0. Move them out and bundle them in your Gemfile, or fold them in to your app as lib/myplugin/* and config/initializers/myplugin.rb. See the release notes for more on this: http://weblog.rubyonrails.org/2012/1/4/rails-3-2-0-rc2-has-been-released. (called from <top (required)> at /opt/openproject-ce/Rakefile:35)
DEPRECATION WARNING: You have Rails 2.3-style plugins in vendor/plugins! Support for these plugins will be removed in Rails 4.0. Move them out and bundle them in your Gemfile, or fold them in to your app as lib/myplugin/* and config/initializers/myplugin.rb. See the release notes for more on this: http://weblog.rubyonrails.org/2012/1/4/rails-3-2-0-rc2-has-been-released. (called from <top (required)> at /opt/openproject-ce/Rakefile:35)
Application.initialize!… [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message.
/opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake: No such file or directory - git
2.620s
[Worker(host:openproject pid:3751)] Starting job worker
[Worker(host:openproject pid:3751)] No more jobs available. Exiting

Message actions

Great, we are getting somewhere.

Now do the same with

cd /opt/openproject-ce; openproject-ce run /opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake RAILS_ENV=production jobs:workoff

RAILS_ENV=production added.

If that actually sends out your missing mail then you can configure this in your crontab.

Message actions

I think we’re closer, but I think there’s still an issue with git:

require ‘rails/all’… 0.440s
Bundler.require… 1.850s
DEPRECATION WARNING: You have Rails 2.3-style plugins in vendor/plugins! Support for these plugins will be removed in Rails 4.0. Move them out and bundle them in your Gemfile, or fold them in to your app as lib/myplugin/* and config/initializers/myplugin.rb. See the release notes for more on this: http://weblog.rubyonrails.org/2012/1/4/rails-3-2-0-rc2-has-been-released. (called from <top (required)> at /opt/openproject-ce/Rakefile:35)
DEPRECATION WARNING: You have Rails 2.3-style plugins in vendor/plugins! Support for these plugins will be removed in Rails 4.0. Move them out and bundle them in your Gemfile, or fold them in to your app as lib/myplugin/* and config/initializers/myplugin.rb. See the release notes for more on this: http://weblog.rubyonrails.org/2012/1/4/rails-3-2-0-rc2-has-been-released. (called from <top (required)> at /opt/openproject-ce/Rakefile:35)
Application.initialize!… [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message.
fatal: Not a git repository (or any of the parent directories): .git
2.640s
[Worker(host:openproject pid:6256)] Starting job worker
[Worker(host:openproject pid:6256)] No more jobs available. Exiting


I have “git version 1.7.10.4” which I just installed using apt-get.

Message actions

Hm, I have no clue why git would join the game here. It shouldn’t.

My colleagues tell me that the openproject-ce bundled version should have a procfile that also starts jobs:workoff. Can you please try this approach?

Message actions

I’d be happy to try what you ask, but I have no idea what you’re talking about - procfile?

Message actions

OK. I think I found the procfile. What do I do with it?

Message actions

Is there any movement on this? I need to get this working.

Message actions

Hi Kendell,

can you please post the command you are issuing to receive the stack trace?

Kind regards

Jens

Message actions

cd /opt/openproject-ce; openproject-ce run /opt/openproject-ce/vendor/bundle/ruby/2.1.0/gems/rake-10.4.2/bin/rake RAILS_ENV=production jobs:workoff

Message actions

The command you posted and the console output you showed both look good. Therefore, I think that this part works. Can you please try to do the following:

1) Go into OpenProject -> “My Account” verify your mail address and uncheck “I don’t want to be notified about changes that I make myself”
2) Go to “Administration” -> “Settings” -> “Email notifications” and click the “Send a test email” link.

Do you receive a test mail then?

Message actions

Don’t ask me how, but email notifications just started working for me. Weird.

Message actions

Glad to hear that, Kendell.