Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Stuck with...
 
Notifications
Clear all

[SOLVED] Stuck with sendmail and projeqtor

26 Posts
3 Users
0 Reactions
17.8 K Views
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 
[#5427]

hi there,

i tried a couple of month configure my projeqtor with our exchange server and finally i'm stuck. after read tons of articles and the whole forum 'bout sendmail i do not have any clue.

the exchange informations seems to be correct, so it states "email sent" in projeqtor. in the log (mail.log) the mail remains in status "queued".

in projeqtor i use phpmail. the recommende phpmailer seems to be errornous too ( if i leave the sendmail path empty it says error, if i put in any value or a sinlge character, it says "mail sent"). i tried different protocols and with or without sendmail path. i tried putting in the ip address instead of servername but it gets not better.

host and dns data are filled correct. telnet works. loggin only states that the mail is queued and it will not left the status.

i configured the php.ini with an static sendmail path and with "-r" parameter but it seems that nothing changed.

did anyone have a clue? i guess it is a short configure i did not recognize or any easy parameter.

projeqtor 7.2.2 (problem occurs since v6)
server ubuntu 16.04 lts (patched the days with recent updates)


 
Posted : 17 Sep 2018 11H37
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

I the log (mail.log) displays a "queued" message, it means projeqtor has correctly send message, and exchange correctly received it.
Now, it is an Exchenge issue : possibly the account you use is locked in Exchange, or not known ...


 
Posted : 17 Sep 2018 17H13
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

at first thank you for your support and patience.

you had a point but i guess there is another error and i do not know what exactly the problem is.

at least i tried to put in my gmail account settings. and it remains the same. in every case the testmail states "email sent" the mail.log file put it on "queued" and nothing happened.

i tried using my gmail account as sender (smtp settings) to send a test to my company account. -> queued

i tried the gmail account as sender and as recipient (so our sandbox can not stop the mail) and also queued.

maybe sendmail has a general problem?

the settings in the back-end of projeqtor are instant? i restart sendmail and cron via console, i dont know if every change is loaded directly.


 
Posted : 18 Sep 2018 11H19
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

maybe sendmail has a general problem?

ProjeQtOr does not systematically use sendMail
We use phpMailer library, which will use default mailing system.
It can be sendMail, postfix or else.
I think you have issue with your mailing system.
Did you try and send emails through other means than projeqtor ?

the settings in the back-end of projeqtor are instant? i

Yes.


 
Posted : 19 Sep 2018 2H06
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Additionnaly, try an external smtp server (gmail or else)


 
Posted : 19 Sep 2018 2H19
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

Hi - as stated above. i tried gmail as sender (smtp) and as receipient and both as the same time. so in fact i think my webserver for projeqtor has an issue. but i dont know where.

is there any config-file or ini which can cross the normal behaviour. should i reinstall the php mailing apps? or should i install postfix and configure to that?

the php mailing library needs a sendmail path? without it runs on a error. if filled (even with nonsense) it says email sent.

as the mailserver seems to be not the issue and projeqtor states he sends out the messages,there can only be some issue with interfaces or config files, am i right?

thank you for hustling with that


 
Posted : 19 Sep 2018 10H58
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi - as stated above. i tried gmail as sender (smtp) and as receipient and both as the same time. so in fact i think my webserver for projeqtor has an issue. but i dont know where.

Take care when using

smtp host = smtp.gmail.com

you must specify

smtp port = 587

and you absolutely need to use an valid gmail acocunt for user / password.

is there any config-file or ini which can cross the normal behaviour. should i reinstall the php mailing apps? or should i install postfix and configure to that?

Default uses phpMailer.
You can cange the "mailer Type" in global parameter to use PHPMail function of sockets connection

the php mailing library needs a sendmail path? without it runs on a error. if filled (even with nonsense) it says email sent.

It is required only if your select PHPMail as mailer and sendmail is not installed at deault location.

as the mailserver seems to be not the issue and projeqtor states he sends out the messages,there can only be some issue with interfaces or config files, am i right?

I think it is, but I'm not a specialist in email sending


 
Posted : 20 Sep 2018 20H19
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

ok we had several problems which are now solved.

sending mails will work from now on. imap is configured (correctly) - no error messages will be generated.

so from this point i have a question.

is there a log file which logs the email answers? imap seems to work, but no notes will be attached.

i searched the forum but did not receive an answer where to look for logs or to test the receiving of emails.

thank you for your help


 
Posted : 25 Jan 2019 14H21
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

is there a log file which logs the email answers? imap seems to work, but no notes will be attached.

No, you'll have to code it yourself.

Find code deling with reading imap and add

debugLog("your messge");

or

traceLog("your messge");

 
Posted : 25 Jan 2019 16H19
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

hi there its me again.

thank you for your help already given.

actually i point out my problem, but again i am stuck.

the connection to imap will work, and after a small test php it works fine and response the mails listet in the inbox. BUT the imap_open command from projeqtor will only response:

Mailbox is empty

I tried setting the conditions of searched mails from "unseen" to "all" but noc changes. also i tried every kind of inbox foldername but still the same.

for me it looks like he did not find the inbox Folder. and if imap open has a folder in the string which does not exist, he will always response "mailbox is empty". in my test.php "Inbox" is working fine, so i guess that projeqtor transforms the string not in the way he receives a working feedback.

also i tried sending a plaintext response, so that i am shure it is no converting problem. i am sorry that i can not provide any further logfile, because the only log i get is "Mailbox is empty".

do you have any clue which can send me in the right direction?


 
Posted : 12 Mar 2019 12H48
jmmbb
(@jmmbb)
Posts: 561
Contributor
 

Hello,

got the same problem with IMAP; No mail read from iINBOX...


 
Posted : 12 Mar 2019 17H34
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

First, take care of case when writing inbox name.
In most cases, Inbox must be written in uppercase (INBOX)

Be sure that the "reply to" parameter is corresponding to inbox account.

At least, when user replies to email, he must preserve the original message.
(and I'm not sure it will work is message uses a specific template)


 
Posted : 13 Mar 2019 17H52
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

hi there - thank you for your response.

the reply to address is exactly like the sender email. and inbox was written in any given ways, but still "Mailbox is empty". i wrote a short test.php which access the imap via the connection string and lists the inbox. and it works fine. in fact that "mailbox is empty" appears if i define any foldername (xxx or whatever) seems to me that the cron.php builds an errornous connection string. connection works, the connection string works manually written in a test.php. no error message appears.

the original mail was left, even with blank spaces and in several tests in rich text/html/plain text. nothing will work.

it driving me nuts


 
Posted : 13 Mar 2019 18H01
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Could you please explain this part :

in fact that "mailbox is empty" appears if i define any foldername (xxx or whatever)


 
Posted : 13 Mar 2019 18H10
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

in the connection string i can typ any name as folder and everytime "mailbox is empty" appears. for example

- }Inbox -> folder exists but "mailbox is empty" appears
- }ABCDEF -> folder did not exist but the message "maibox is empty" appears

so for me it seems that everytime the foldername is not correct and the folder did not exist the message "mailbox is empty" is in the log.

if i left the connection string without folder name - an error appears that the foldername is missing.

in my test php file, "Inbox" as foldername work fine. so i guessed that the cron eventually deforms the parameters out of the global parameters into an errornous string.

can you follow my explanations?


 
Posted : 13 Mar 2019 18H23
jmmbb
(@jmmbb)
Posts: 561
Contributor
 

Hello,

same issue for me.
Using Telnet, i'm able to connect to mailbox and listing folders...

But nothing's working via Projeqtor
2019-03-13 17:23:47.663 DEBUG Mailbox is empty
2019-03-13 17:28:48.338 DEBUG Mailbox is empty


 
Posted : 13 Mar 2019 19H30
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

did you configure MAILBOX name in upper case in the parameters ?


 
Posted : 13 Mar 2019 19H42
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

hi babynus,

thank you for your patience.

and yes, of course i did. i attached our configurations: screenshot 1 and 2

sending mail works fine. no matter what i tried in imap parameters i still get the log:

2019-03-14 08:10:05.694 ===== TRACE ===== Cron started at 14/03/2019 08:10:05
2019-03-14 08:10:15.749 ----- DEBUG ----- Mailbox is empty

the connect seems to work from this client. i wrote a test php (screen3 is the php-file) and the results of this php are in screen4.

as you also see in screen 4 is that i tried several formats of mails (plain, html, rich)

any further clues?

@jmmbb
i see that the most mails are tagged as "seen". but projeqtor only imports "unseen undeleted' mails. maybe you should try to have a look on this, if this is not already tested.


 
Posted : 14 Mar 2019 10H29
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Hi,

ProjeQtOr will treat only unread emails, and then mark them as read, to avoid treating several times same emails.
So issue may be there. Check that emails are not read in the mailbox.


 
Posted : 15 Mar 2019 11H10
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

did you replied to jmbb?

i knew this with the unread mails, informed the user.

see also my attachment no. 4 the "U" in the list in front of the output marks the "unread" mails.

im thankful for any hint


 
Posted : 18 Mar 2019 10H44
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Difficul to analyse wothout more information.
I would recommend to add some "debugLog("message");" in the code to trace what is happenning.
Possibly emails are read but rejected.


 
Posted : 18 Mar 2019 11H13
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

eureka.

just tried out the email functionality for receiving mails, and guess what, without changing anything, it works.

maybe any update between 8.0 and 8.1.5 has solved the issue or some magic happened. but at this point anything seems to be working.

at least, before closing this topic, i had one lil question i did not find answered in the manual:

which conditions are needed for an email to be attached as comment. are there any utf requirements? what is the minimum content which should be named in the subject? and which kind of elements are able to receive comments from emails.

thank you for your support and your tool which gets better and better in any existing minute.


 
Posted : 26 Sep 2019 15H10
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

which conditions are needed for an email to be attached as comment. are there any utf requirements?

You can add note (comment) only when manually sending emails. And note will store the message you enter, not the description of the item.
Automatic emails won't store notes.


 
Posted : 26 Sep 2019 18H17
henning telemann
(@4ce)
Posts: 56
Active Member
Topic starter
 

yeah i knew. what i can not figure out what is needed.

under which circumstances connects projeqtor the sended mail to any item? I guess the item ID is mandatory? is there more needed? some blank spaces in the subject or anything else? and is it possible that some utf-8 in the body is needed? i tested mails and if i create a blank email and put all the things in it, i think its needed for attaching the comment, then, for some reason, it works sometimes and sometimes not. if i reply to an automatic mail, no problems are there. so i try to name the requirements that projeqtor detects an email should be an attached comment.


 
Posted : 27 Sep 2019 10H03
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

OK, I understand now : you use email templates.
I guess answer from emails sent with templates won't be iodentified as answers, as we won't find necessary information, in expected format.
We planned an evolution to add a specofoc line in all cases, and this should fix this issue.


 
Posted : 27 Sep 2019 12H04
Page 1 / 2
Share:

Scroll to Top