Redmine

In both #7451 and this one, use of BCC is checked.

Could you try without BCC ?

Hi

Tried without Bcc , still no luck.

Thanks

Hi

What i observed is , when i do a fresh installation of Redmine on my computer , the Email Notifications are sent without any problem. However, when i do an import of the Redmine database of my existing production database , the database import is successful but the Email notifications stops working .

Is there any limitations in redmine ?

Thanks

Did you run the migration task after import ?

NO i didn't , since there is no change in version. If its necessary, could you please provide the link where i can find the steps in executing the same.

Simply run rake db:migrate from your redmine dir.

Hi, i got the following error

C:\Program Files\BitNami Redmine Stack\ruby\bin>rake db:migrate --trace
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2377:in `raw_load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:in `load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:in `load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19:in `load'
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19

Thanks

Run it from your redmine directory.

Hi

I am getting the following error when i run from :

C:\Program Files\BitNami Redmine Stack\apps\redmine>

"ruby.exe"' is not recognized as an internal or external command

Do i have to do something with the environmental variables before executing the command ?

Yes, add C:/Program Files/BitNami Redmine Stack/ruby/bin to your PATH.

Hi Added the path , unfortunately i am still getting the same error .

Did you open a new cmd window ?

Yes with a new CMD window.

I am executing the command from here :

C:\Program Files\BitNami Redmine Stack\apps\redmine\>

I was mistaken when I told you to add C:/Program Files/BitNami Redmine Stack/ruby/bin in your path, you should replace "/" with "\".

What does your PATH look like ?

Hi i configured correctly "\" in the first place ! The error is there with correct syntax.

What does your PATH contains and what command did you precisely type in ?

Hi

This is in the PATH :

C:\Program Files\BitNami Redmine Stack\ruby\bin

Hi

After changing the path , my redmine stopped working , when i check in the services , the redmine Apache service is down and when i start i am getting an error . From the event log the error message is :

The Apache service named  reported the following error:
>>> httpd.exe: Syntax error on line 127 of C:/Program Files/BitNami Redmine Stack/apache2/conf/httpd.conf: Cannot load C:/Program Files/BitNami Redmine Stack/apache2/modules/mod_dav_svn.so into server: The specified module could not be found.   

I did not save the previous path , can you let me know the correct path.

Thanks

Add a path to your PATH means you should append it to the end of the actual value, not replace it !

Here's mine :

D:\install\Ruby187\bin;C:\Program Files\Java\jdk1.7.0\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\TortoiseSVN\bin;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\PostgreSQL\9.0\bin;C:\Program Files\PostgreSQL\9.0\lib

Hi

Original settings worked :

C:\Program Files\BitNami Redmine Stack\subversion\bin

But , email still not working .

Don't understand, what do you call your original settings ? Do you alter your user or system PATH envvar ?

No , i didn't , its already like this before :

C:\Program Files\BitNami Redmine Stack\subversion\bin

But this is just a part of your PATH environment variable value, isn't it ?

Yes it is .

Can you please tell me where i can check , to figure out the problem with the email notification.

production.log has no errors !

I'd like to help you to get rake db:migrate done, but I don't understand how is installed the stack.

I don't get it : C:\Program Files\BitNami Redmine Stack\subversion\bin seems totally unrelated to the problem except if ruby executable is stored here ?!

Hi

I had done the default installation of Redmine.

Yes , the buby executables are stored in C:\Program Files\BitNami Redmine Stack\subversion\bin

I had added the C:\Program Files\BitNami Redmine Stack\apps\redmine\ in the path and i can run the rake db:migrate bu the folowwing error occurs

C:\Program Files\BitNami Redmine Stack\ruby\bin>rake db:migrate --trace
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2377:in `raw_load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2017:in `load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2016:in `load_rakefile'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2000:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19:in `load'
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19

Shaik Ahmed wrote:

Yes , the buby executables are stored in C:\Program Files\BitNami Redmine Stack\subversion\bin

Why so are you running rake from C:\Program Files\BitNami Redmine Stack\ruby\bin ?!?! Both executables should be in the same directory, subversion has nothing to do with ruby !

Moreover, I already told you to run db migration from redmine directory.

Please do exactly the following :

1. preprend your system PATH environment variable with C:\Program Files\BitNami Redmine Stack\ruby\bin and remove C:\Program Files\BitNami Redmine Stack\apps\redmine from it (PATH contains path to executable, there is no executable in redmine directory)

2. cd "C:\Program Files\BitNami Redmine Stack\apps\redmine" 
   set RAILS_ENV=production
   rake db:migrate
   

Hi

Thanks for the steps , that executed successfully . But still i am not getting any emails .

Output :

C:\Program Files\BitNami Redmine Stack\apps\redmine>rake db:migrate
(in C:/Program Files/BitNami Redmine Stack/apps/redmine)
==  ChangeUsersMailNotificationToString: migrating ============================
-- rename_column(:users, :mail_notification, :mail_notification_bool)
   -> 0.2188s
-- add_column(:users, :mail_notification, :string, {:null=>false, :default=>""})
   -> 0.0313s
-- remove_column(:users, :mail_notification_bool)
   -> 0.0156s
==  ChangeUsersMailNotificationToString: migrated (0.3438s) ===================

==  UpdateMailNotificationValues: migrating ===================================
==  UpdateMailNotificationValues: migrated (0.0000s) ==========================

==  AddIssuesNestedSetsColumns: migrating =====================================
-- add_column(:issues, :parent_id, :integer, {:default=>nil})
   -> 0.2188s
-- add_column(:issues, :root_id, :integer, {:default=>nil})
   -> 0.1719s
-- add_column(:issues, :lft, :integer, {:default=>nil})
   -> 0.2031s
-- add_column(:issues, :rgt, :integer, {:default=>nil})
   -> 0.1875s
==  AddIssuesNestedSetsColumns: migrated (1.0000s) ============================

==  AddIndexOnIssuesNestedSet: migrating ======================================
-- add_index(:issues, [:root_id, :lft, :rgt])
   -> 0.2031s
==  AddIndexOnIssuesNestedSet: migrated (0.2031s) =============================

==  ChangeChangesPathLengthLimit: migrating ===================================
-- change_column(:changes, :path, :text, {:null=>true, :default=>nil})
   -> 0.0781s
-- change_column(:changes, :path, :text, {:null=>false})
   -> 0.0313s
-- change_column(:changes, :from_path, :text)
   -> 0.0469s
==  ChangeChangesPathLengthLimit: migrated (0.1563s) ==========================

==  EnableCalendarAndGanttModulesWhereAppropriate: migrating ==================
==  EnableCalendarAndGanttModulesWhereAppropriate: migrated (0.2344s) =========

==  AddUniqueIndexOnMembers: migrating ========================================
-- add_index(:members, [:user_id, :project_id], {:unique=>true})
   -> 0.0781s
==  AddUniqueIndexOnMembers: migrated (0.2031s) ===============================

==  AddCustomFieldsVisible: migrating =========================================
-- add_column(:custom_fields, :visible, :boolean, {:null=>false, :default=>true})
   -> 0.0156s
==  AddCustomFieldsVisible: migrated (0.0313s) ================================

==  ChangeProjectsNameLimit: migrating ========================================
-- change_column(:projects, :name, :string, {:null=>false, :limit=>nil, :default=>""})
   -> 0.0625s
==  ChangeProjectsNameLimit: migrated (0.0625s) ===============================

==  ChangeProjectsIdentifierLimit: migrating ==================================
-- change_column(:projects, :identifier, :string, {:limit=>nil})
   -> 0.0469s
==  ChangeProjectsIdentifierLimit: migrated (0.0469s) =========================

Thanks

Forgot to mention , i encountered this error :

CORE_RL_magick_.ddl was not working 

However , clicking after clicking 'ok' db migrate resumed without any erros .

Thanks

Did you restart your server ?

Yes, i did !

Both http and ruby ?

Yes !

Now that the db has been migrated, could you please check again the user profile email notification settings and the system email notfication settings ?

And check the content of the log file once an issue has been modified ?

After Updating the issue and changing the assignee , the content of the production.log is :

Processing IssuesController#update (for 192.168.20.199 at 2011-03-09 10:28:24) [PUT]
  Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Submit", "notes"=>"", "action"=>"update", "_method"=>"put", "authenticity_token"=>"cbYgT56kGZX/Hk6NynWS8NkykfOCCXwULGFN5Pe+Bu8=", "id"=>"1086", "issue"=>{"start_date"=>"2011-03-08", "custom_field_values"=>{"6"=>"", "22"=>"", "9"=>"", "1"=>"123", "2"=>"", "4"=>"", "10"=>"", "5"=>""}, "estimated_hours"=>"", "priority_id"=>"6", "parent_issue_id"=>"", "lock_version"=>"1", "done_ratio"=>"0", "assigned_to_id"=>"3", "subject"=>"Atom Check", "category_id"=>"", "tracker_id"=>"1", "due_date"=>"", "status_id"=>"2", "description"=>"Atom Check"}, "controller"=>"issues", "attachments"=>{"1"=>{"description"=>""}}}
Sending email notification to: shaik2@navionicsindia.com
The following error occured while sending email notification: "550 5.1.1 User unknown
". Check your configuration in config/email.yml.
Redirected to http://onssrv4/redmine/issues/1086
Completed in 828ms (DB: 109) | 302 Found [http://onssrv4/redmine/issues/1086]

Processing IssuesController#show (for 192.168.20.199 at 2011-03-09 10:28:24) [GET]
  Parameters: {"action"=>"show", "id"=>"1086", "controller"=>"issues"}
Rendering template within layouts/base
Rendering issues/show.rhtml
Completed in 672ms (View: 484, DB: 141) | 200 OK [http://onssrv4/redmine/issues/1086]

Email Settings that was in use , note that the two settings specified below used to work before , but right now both of them are not working :

Settings 1 (email.yml) :

production:
  delivery_method: :smtp
  smtp_settings:
    address: mail.mymailserver.com
    port: 25
    domain: mymailserver.com  
    authentication: :login
    user_name: 
    password:

Settings 2 (email.yml)

production:
  delivery_method: :smtp
  smtp_settings:
    address: mail.mymailserver.com
    port: 25
    domain: mail.mymailserver.com  
    authentication: :plain

Googling around, it looks like this is not an authentication issue, the message means that the mailbox is not know by the SMTP server, check the validity of your domain / adress / mail adress values.

You can try to send a mail to this address with a classic MUA.

Hi

After changing the default port from 25 to another , it worked . However , there were no changes done at mail exchange .

The port 25 still works if i configure a new Redmine , however , when i import the database from my production system it stops working . Then when i change the email.yml with a different port , it works

I appreciate your support .

Thanks