Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

app.ERROR: <"Admin User" <admin@example.com>>: "@" or "." expected after ""Admin User"" #313

Closed
RZ24 opened this issue Oct 10, 2017 · 11 comments
Labels
Milestone

Comments

@RZ24
Copy link

RZ24 commented Oct 10, 2017

Hello
i use version eventum-3.3.0-6-gca0f4a39 on Debian 9 with PHP 7
If i start eventum/bin/process_mail_queue.php, i see this Message and no Mail go out

app.ERROR: <"Admin User" <admin@example.com>>: "@" or "." expected after ""Admin User""  {"traceFile":"/var/www/eventum/var/log/zf-mail-59dcd41e559a8.json","exception":"[object] (Zend\\Mail\\Protocol\\Exception\\RuntimeException(code: 0): <\"Admin User\" <admin@example.com>>: \"@\" or \".\" expected after \"\"Admin User\"\"\r\n at /var/www/eventum/vendor/zendframework/zend-mail/src/Protocol/AbstractProtocol.php:327)"} {"file":"/var/www/eventum/src/Mail/MailTransport.php","line":66,"class":"Eventum\\Mail\\MailTransport","function":"send","memory_usage":"6 MB","memory_peak_usage":"6 MB","version":"3.3.0-6-gca0f4a39","usr_id":""}
Mail_Queue: issue #: Can't send mail 1: <"Admin User" <admin@example.com>>: "@" or "." expected after ""Admin User""

Thanks
Andre

@glensc
Copy link
Member

glensc commented Oct 10, 2017

this is clearly due address being ill formatted.

please provide more information:

select maq_recipient, maq_subject, maq_message_id, maq_headers from mail_queue where maq_id=1\G

you may also provide (obfuscated at your will) contents of the "traceFile":"/var/www/eventum/var/log/zf-mail-59dcd41e559a8.json"

@glensc glensc added this to the 3.3.2 milestone Oct 10, 2017
@RZ24
Copy link
Author

RZ24 commented Oct 11, 2017

Hello,
it is a fresh installtion on Debian 9 with php 7.

select maq_recipient, maq_subject, maq_message_id, maq_headers from mail_queue where maq_id=1

Admin User admin@example.com Eventum: User account information updated MIME-Version: 1.0
Content-Type: text/plain;
cha...
The content of traceFile":"/var/www/eventum/var/log/zf-mail-59dcd41e559a8.json":
[""Admin User" admin@example.com",{"MIME-Version":"1.0","Content-Type":"text/plain; charset="UTF-8"","Content-Transfer-Encoding":"8bit","From":"projekte@rz-24.de","To":"Admin User admin@example.com","Subject":"Eventum: User account information updated","Message-ID":"eventum.md5.12w9gvtflfw0ow4.1d1w47lsmrkzv@projekt.rz-24.de","Precedence":"bulk","Auto-Submitted":"auto-generated","Date":"Tue, 10 Oct 2017 15:34:41 +0200"},"Your user account has been updated in Eventum.\n\nYour account information as it now exists appears below.\n\n----------------------------------------------------------------------\n Full Name: Admin User\n Email Address: admin@example.com\n Group: \nAssigned Projects: Default Project: Administrator\n\n----------------------------------------------------------------------\n\nhttp:\/\/projekt.rz-24.de\/\n"]

And a other log file:
[""Admin User" admin@rz-24.de",{"MIME-Version":"1.0","Content-Type":"text/plain; charset="UTF-8"","Content-Transfer-Encoding":"8bit","Message-ID":"eventum.md5.5cebkxybc.1qw16fg17yzne@projekt.rz-24.de","From":""projekt-test@projekt.rz-24.de" projekt-test@projekt.rz-24.de","To":"Admin User admin@rz-24.de","Subject":"[#1] New Issue Assigned: adf","X-Eventum-Type":"new_issue","X-Eventum-Assignee":"admin@rz-24.de","X-Eventum-Category":"","X-Eventum-Project":"test","X-Eventum-Priority":"test","Precedence":"bulk","Auto-Submitted":"auto-generated","Date":"Wed, 11 Oct 2017 10:11:16 +0200"},"This is an automated message sent at your request from Eventum.\n\nA new issue was just created in the system.\n\nTo view more details of this issue, or to update it, please visit the\nfollowing URL: http://projekt.rz-24.de/view.php?id=1\n\n----------------------------------------------------------------------\n ID: 1\n Summary: adf\n Project: test\n Reported By: Admin User\n Assignment: Admin User\n Priority: test \n Description:\n----------------------------------------------------------------------\nadf\n----------------------------------------------------------------------\n\n\nPlease Note: If you do not wish to receive any future email\nnotifications from Eventum, please change your account preferences by\nvisiting the URL below: http://projekt.rz-24.de/preferences.php\n"]

@glensc
Copy link
Member

glensc commented Oct 11, 2017

while this is not the issue here, but php 7 is not supported: #299

but seems your problem is you have filled somewhere username with quotes:
"Admin User" instead of as is: Admin User. try to recollect what have you done, explain it here, to be able to reproduce this.

please fix your note, attach as fenced code block or as attachments. can't make heads or tails of your note.

also mysql statement i asked to use \G terminator for better readability than ; --

$ mysql eventum -s -e "SQL HERE\G" > output.txt

@RZ24
Copy link
Author

RZ24 commented Oct 11, 2017

I install a new Debian9 Server. Install the needed Add ons. Take the latest Version of Eventum eventum-3.3.0-6-gca0f4a39 and configure the smtp. Change the email Adresse of the default admin User and create a new User. To test the SMTP login, i execute the process_mail_queue.php script. I change no other configuration.
Andre

@RZ24
Copy link
Author

RZ24 commented Oct 11, 2017

I see the folowing on the database

Database | Collation |

  | eventum | latin1_swedish_ci

is this correct?

@glensc
Copy link
Member

glensc commented Oct 11, 2017

you have ignored my previous comments. and no, Collation is not related.

@RZ24
Copy link
Author

RZ24 commented Oct 11, 2017

OK. I have no Quotas in the User Name. It is the default admin User and all new User. I attached a SQL Export from my Database

eventum.zip

@cpinfold
Copy link
Contributor

cpinfold commented Oct 12, 2017 via email

@glensc
Copy link
Member

glensc commented Oct 14, 2017

debugged the database dump with smtp-sink and mail-sink and i see that RCPT TO: "Admin User" <admin@example.com> which should be probably just RCPT TO: "Admin User" <admin@example.com>

X-Helo-Args: localhost
X-Mail-Args: <projekte@rz-24.de>
X-Rcpt-Args: <"Admin User" <admin@example.com>>

my SMTP server (postfix-2.11) allows this, but i guess reporter uses smtp server that disallows such violation. what is your smtp server name/version?

ps: @RZ24 you should probably change your passwords, because you included them when you provided full database dump.

@glensc
Copy link
Member

glensc commented Oct 14, 2017

#317 should fix this.

to test:

@RZ24
Copy link
Author

RZ24 commented Oct 17, 2017

Hello glensc,
the patch work fine. Thanks for support

Andre

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

3 participants