BitNami Redmine Windows Server Incoming emails from IMAP issue

Added by Mitch R over 8 years ago

Ive got Bitnami redmine setup on a windows server and im trying to make it so that we can send email to redmine and have it create a ticket. Right now ive got a test gmail imap account setup to test this out before going live with it with our imap server. I have pycron installed but I cant seem to figure out the script to get it to work correctly. It seems to check the mail and mark it as read but nothing shows up in redmine, like it just didnt do anything.

Anyhelp?

heres the script:

CALL C:\Program Files\BitNami Redmine Stack\scripts\setenv.bat
cd C:\Program Files\BitNami Redmine Stack/apps/redmine
CALL rake redmine:email:receive_imap RAILS_ENV="production" host=imap.gmail.com port=993 ssl=SSL
username= password=xxxxxxxxxxxxxxxx project=unsorted tracker=bug
allow_override=project,tracker,priority

Replies (9)

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Matt Connolly over 8 years ago

try running the rake task manually first to see if there are any error messages.

I saw a few imap errors cause the rake task to fail, resulting in symptoms like you describe.

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

So i just pasted:

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rake redmine:email:r
eceive_imap RAILS_ENV="production" host=imap.gmail.com port=993 ssl=SSL username
= password=xxxxxxxxxxxxx project=unsorted tracket=bug allow_ove
rride=project,tracker,priority
(in C:/Program Files/BitNami Redmine Stack/apps/redmine)

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

into command to run rake manually and it comes back with what you see above

I dont see any errors.

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

and when i run with trace this is the output, again don't see any errors:

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rake --trace redmine
:email:receive_imap RAILS_ENV="production" host=imap.gmail.com port=993 ssl=SSL
username= password=xxxxxxxxxxxx project=unsorted tracket=bug a
llow_override=project,tracker,priority
(in C:/Program Files/BitNami Redmine Stack/apps/redmine)
  • Invoke redmine:email:receive_imap (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Execute redmine:email:receive_imap

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

Anyone?

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

I found to put -f in so how about this:

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rake -f --trace redm
ine:email:receive_imap RAILS_ENV=production host=imap.gmail.com port=993 ssl=SSL
username= password=XXXXXXXXXXXXX project=unsorted tracket=bug
allow_override=project,tracker,priority
(in C:/Program Files/BitNami Redmine Stack/apps/redmine/scripts)
rake aborted!
Don't know how to build task 'redmine:email:receive_imap'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:1728:in `[]'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2050:in `invoke_task'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2029:in `top_level'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2029:in `each'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2029:in `top_level'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2023:in `top_level'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2001:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:2068:in `standard_exception_handling'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/li
b/rake.rb:1998:in `run'
C:/Program Files/BitNami Redmine Stack/ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/bi
n/rake:31
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19:in `load'
C:/Program Files/BitNami Redmine Stack/ruby/bin/rake:19

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

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

wow so restarting the box and running the script again it seems to get worse

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>imapjob.bat

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>CALL C:\Program File
s\BitNami Redmine Stack\scripts\setenv.bat
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>cd C:\Program Files\
BitNami Redmine Stack/apps/redmine

C:\Program Files\BitNami Redmine Stack\apps\redmine>CALL rake -f --trace redmine
:email:receive_imap RAILS_ENV=production host=imap.gmail.com port=993 ssl=SSL us
ername= password=xxxxxxxxxxxxxxxxxxxxx project=unsorted tracker=bug
allow_override=project,tracker,priority
'rake' is not recognized as an internal or external command,
operable program or batch file.

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

not sure if the above is related to this or not

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

OK, so i think I have it not generating any errors but when i send an email to it, it doesnt create a ticket, with the switch unknown_user=create it does create the user just to test that out and it does check the email and mark it as read but no ticket/issue creation. Am i forming the email incorrectly??

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Mitch R over 8 years ago

latest output and script any help?

SCRIPT:
CALL “C:\Program Files\BitNami Redmine Stack\scripts\setenv.bat”
cd C:\Program Files\BitNami Redmine Stack/apps/redmine
CALL rake -f “C:\Program Files\BitNami Redmine Stack\apps\redmine\Rakefile” redmine:email:receive_imap
RAILS_ENV=“production” host=imap.gmail.com port=993 ssl=1 username= password=XXXXXXXXXx
—trace project=testhelpdesk tracker=Bug status=open priority=Normal allow_override=project,tracker,priority

CMD RUNNING THE SCRIPT
C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>imapjob.bat

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>CALL “C:\Program Fil
es\BitNami Redmine Stack\scripts\setenv.bat”

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>set PATH=C:\Program
Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlit
e;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNami Re
dmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Pr
ogram Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Sta
ck/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNam
i Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\P
rogram Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmi
ne Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Fil
es\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagi
ck;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redm
ine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Pro
gram Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/
sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNa
mi Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;
C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmin
e Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\B
itNami Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin
;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami
Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Progra
m Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imag
emagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami
Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C
:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine S
tack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\
BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion
\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami R
edmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Fi
les\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\rub
y\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\Bit
Nami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\P
rogram Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack
/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\Bi
tNami Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\
bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redm
ine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program F
iles\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subve
rsion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitN
ami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Progr
am Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stac
k\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Program File
s\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd
;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine
Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Fil
es\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/m
ysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami
Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Prog
ram Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/
subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program Files
\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\
Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine
Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Program
Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/gi
t\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Red
mine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Progra
m Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmine St
ack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Files\Bi
tNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:
\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine S
tack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program
Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlit
e;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNami Re
dmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Pr
ogram Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Sta
ck/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNam
i Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\P
rogram Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmi
ne Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Fil
es\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagi
ck;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redm
ine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Pro
gram Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/
sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\BitNa
mi Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion\bin;
C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmin
e Stack/git\cmd;C:\Program Files\BitNami Redmine Stack/sqlite;C:\Program Files\B
itNami Redmine Stack/imagemagick;C:\Program Files\BitNami Redmine Stack\ruby\bin
;C:\Program Files\BitNami Redmine Stack/subversion\bin;C:\Program Files\BitNami
Redmine Stack/mysql\bin;C:\Program Files\BitNami Redmine Stack/git\cmd;C:\Progra
m Files\BitNami Redmine Stack/sqlite;C:\Program Files\BitNami Redmine Stack/imag
emagick;C:\Program Files\BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami
Redmine Stack/subversion\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C
:\Program Files\BitNami Redmine Stack/git\cmd;C:\Program Files\BitNami Redmine S
tack/sqlite;C:\Program Files\BitNami Redmine Stack/imagemagick;C:\Program Files\
BitNami Redmine Stack\ruby\bin;C:\Program Files\BitNami Redmine Stack/subversion
\bin;C:\Program Files\BitNami Redmine Stack/mysql\bin;C:\Windows\system32;C:\Win
dows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### GIT ENV ## ###

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### SQLITE ENV #####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### IMAGEMAGIC
K ENV #####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>set MAGICK_HOME=C:\P
rogram Files\BitNami Redmine Stack/imagemagick

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>set MAGICK_CODER_MOD
ULE_PATH=C:\Program Files\BitNami Redmine Stack/imagemagick\modules\coders

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>set MAGICK_CONFIGURE
_PATH=C:\Program Files\BitNami Redmine Stack/imagemagick\config

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### RUBY ENV # ####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>set RUBYOPT=rubygems

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### SUBVERSION
ENV #####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### MYSQL ENV #####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>rem ##### APACHE ENV #####

C:\Program Files\BitNami Redmine Stack\apps\redmine\scripts>cd C:\Program Files\
BitNami Redmine Stack/apps/redmine

C:\Program Files\BitNami Redmine Stack\apps\redmine>CALL rake -f “C:\Program Fil
es\BitNami Redmine Stack\apps\redmine\Rakefile” redmine:email:receive_imap RAILS
ENV=“production” host=imap.gmail.com port=993 ssl=1 username=XXXXXXXXX@gmail
.com password=XXXXXXXXXXXXXX —trace project=testhelpdesk tracker=Bug status=open prio
rity=Normal allowoverride=project,tracker,priority
(in C:/Program Files/BitNami Redmine Stack/apps/redmine)

Invoke redmine:email:receive_imap (first_time)
Invoke environment (first_time)
Execute environment
Execute redmine:email:receive_imap
C:\Program Files\BitNami Redmine Stack\apps\redmine>

RE: BitNami Redmine Windows Server Incoming emails from IMAP issue - Added by Tony Ordner over 8 years ago

I would check your setup for the roles of non-member and anonymous.... make certain they are set up with the rights to add issues. Especially the non-member role since you probably do not want to add every user to the incoming project.

I hope this helps.

thanks
wowsher

(1-9/9)