Issue With Jiwa Email  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

Issue With Jiwa Email

Postby SBarnes » Wed Apr 17, 2019 4:07 pm

We are getting an issue with Jiwa's email system when we use the smtp plugin whith TLS where if the user is not in the Administrators group we are getting an error about the name of the mail server not being able to be resolved.

If the user is in the administrators group everything works as expected which leads me to believe its a permissions issue, has anyone come across something like this before?

By the way nslookup resolves the name of the mail server with no issue.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Issue With Jiwa Email

Postby pricerc » Wed Apr 17, 2019 4:10 pm

Is that the JIWA or Windows Administrators group?
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 504
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 20

Re: Issue With Jiwa Email

Postby Scott.Pearce » Wed Apr 17, 2019 4:12 pm

Put in a System.Diagnostics.Debugger.Break() at the start of EmailSendBefore() in the plugin and have a look at the values you are getting. You could also wrap the contents of that function in a try catch to see if it is tripping out at some point.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Issue With Jiwa Email

Postby SBarnes » Wed Apr 17, 2019 4:12 pm

Hi Ryan

Windows administrator group, the Jiwa user doesn't matter.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Issue With Jiwa Email

Postby SBarnes » Wed Apr 17, 2019 4:17 pm

Thanks Scott a screen shot of the error is here
Attachments
emailerror.jpg
emailerror.jpg (10.6 KiB) Viewed 866 times
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Issue With Jiwa Email

Postby pricerc » Wed Apr 17, 2019 4:47 pm

does

Code: Select all
nslookup smtp.sendgrid.net


work for non-admin users?
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 504
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 20

Re: Issue With Jiwa Email

Postby pricerc » Wed Apr 17, 2019 4:50 pm

Also, if you have a telnet client on the PC (Window Feature option), you can try
Code: Select all
telnet smtp.sendgrid.net 25
(or whatever your TLS port is). You can just disconnect straight away, but it might also help diagnose the problem.
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 504
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 20

Re: Issue With Jiwa Email

Postby Scott.Pearce » Wed Apr 17, 2019 4:56 pm

Try using a normal email client to test the environment.
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 742
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Issue With Jiwa Email

Postby Mike.Sheen » Wed Apr 17, 2019 6:26 pm

pricerc wrote:Also, if you have a telnet client on the PC (Window Feature option), you can try
Code: Select all
telnet smtp.sendgrid.net 25
(or whatever your TLS port is). You can just disconnect straight away, but it might also help diagnose the problem.


+1 to this, and also Scott's suggestion if Telnet yields nothing useful to try an email client.

If the DNS resolves, but the connection cannot be established then either something is blocking the outbound (firewall perhaps) or the inbound at the other end (IP blacklisted by the sendgrid network for instance).

SPF, DNSSec and friends probably aren't your issue (would have thought if SPF or DNSSec was a factor you'd get a different sort of error - we just report what the .NET SMTP client throws) - but those might also be a factor - with services like Sendgrid they might be doing something funky outside the RFC standards for SMTP which occurs at the connection level and may explain connection issues also.

EDIT: But given members of the Administrators windows group don't have the issue, then it must be a policy or something on the machine sending - firewall rules should be your first line of inquiry.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: Issue With Jiwa Email  Topic is solved

Postby SBarnes » Thu Apr 18, 2019 9:34 am

Hi Guys

Thanks for all the suggestions unfortunately we are now not able to replicate the issue, which leads me to believe it may have been caused by a networking issue.

We are waiting to see if the original user who reported the issue is still getting it.
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175


Return to Technical and or Programming

Who is online

Users browsing this forum: Google [Bot] and 4 guests

cron