Error 500 while creating new user

[plantaxl]

Hello there!

New user of your CRM, I managaed to install and configure it for our needs.
But now I try to create a new user and inly face an error 500...

I searched for a time here and there, found a few leads (SMTP configuration, etc.), but this meanie error is still here...

The only expert in our company being absent for a couple of monthes, I'm now quite lost and don't know where to look...

Any advice?

[tanya]

Hello

At first check apache error log and espocrm log, please

[plantaxl]

Thanks for your response!

Here's the recent espocrm log :

[2017-08-18 09:27:40] Espo.ERROR: API [POST]:/:controller, Params:Array (     [controller] => User ) , InputData: {"firstName":"Jane","lastName":"Doe","isActive":true,"isSuperAdmin":false,"teams":{"teamsIds":[]},"gender":"","userName":"jane","salutationName":"","password":"*****","passwordPreview":"*****","passwordConfirm":"*****","title":"","emailAddressData":[],"emailAddress":null,"phoneNumberData":[],"phoneNumber":null,"isAdmin":false,"teamsIds":[],"teamsNames":{},"teamsColumns":{},"isPortalUser":false,"rolesIds":[],"rolesNames":{},"defaultTeamName":null,"defaultTeamId":null} -  [] []
[2017-08-18 09:27:40] Espo.ERROR: Display Error: , Code: 500 URL: /espocrm/api/v1/User [] []

And the last 3 entries from the Apache error log (the ones prior to them seem to be the booting of Apache) :

[Fri Aug 18 10:03:07.692871 2017] [mpm_winnt:notice] [pid 8544:tid 252] AH00418: Parent: Created child process 10472
[Fri Aug 18 10:03:08.333907 2017] [ssl:warn] [pid 10472:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Fri Aug 18 10:03:08.382910 2017] [mpm_winnt:notice] [pid 10472:tid 264] AH00354: Child: Starting 150 worker threads.

And a piece of info which may be useful (Caution : noob inside) :
I installed Espo on a Xampp solution, but I found an "old" PostGreSQL server installed and (maybe) running.
May there be some kind of conflict between them two?

[tanya]

these notices are even not at the same time...no useful information from log...

Did you try to create a user without email sending?

[plantaxl]

Yes, sorry about the times, didn't find any correspondance...

For the creation of the user - I feel I'll get scold - well... yes...

[tanya]

You can create any other records, except User, right?
Can you compose email to any email address from EspoCRM?

[plantaxl]

For the first question, yes.
I managed to create a new entity, to fill a lot of things, to import datas...

Concerning the email...
Yesterday, for my account as administrator, I were able to configure the email account and to test it.
Email were sent and received.

But today :

[2017-08-18 14:04:40] Espo.ERROR: Display Error: 5.7.0 Must issue a STARTTLS command first. 2sm4157849wrp.63 - gsmtp , Code: 500 URL: /espocrm/api/v1/Email [] []

[tarasm]

It seems like your SMTP server returned some error. Is it error for all emails, or just for specific emails?

[plantaxl]

Hello tarasm.

Well, in fact, for now there is only one email set up (because one user: me).
And sending emails is working... most of the time...

I don't have any problem with them today, but there's still this error 500 when I try to create a new user.

May I have messed the installation?

[tarasm]

Did you configure global SMTP settings via Administration » Outbound Emails?

[plantaxl]

Yes I did.

[tarasm]

Could you check an apache error log (/var/log/apache2/error.log depends on your system) and espocrm log (data/logs/espo-*.log) after creating a user.

[plantaxl]

Of course.

Here's the espocrm log :

[2017-08-22 13:58:43] Espo.ERROR: API [POST]:/:controller, Params:Array (     [controller] => User ) , InputData: {"firstName":"jane","lastName":"doe","isActive":true,"isSuperAdmin":false,"teams":{"teamsIds":[]},"gender":"","userName":"jane","salutationName":"Ms.","password":"*****","passwordPreview":"*****","passwordConfirm":"*****","emailAddressData":[{"emailAddress":"janedoe@gmail.com","primary":true,"optOut":false,"invalid":false,"lower":"janedoe@gmail.com"}],"emailAddress":"janedoe@gmail.com","sendAccessInfo":true,"teamsIds":["599566f9659a11239"],"teamsNames":{"599566f9659a11239":"Graphistes"},"teamsColumns":{"599566f9659a11239":{"role":null}},"defaultTeamName":"Graphistes","defaultTeamId":"599566f9659a11239","title":"","isAdmin":false,"isPortalUser":false,"phoneNumberData":[],"phoneNumber":null,"rolesIds":[],"rolesNames":{}} -  [] []
[2017-08-22 13:58:43] Espo.ERROR: Display Error: , Code: 500 URL: /espocrm/api/v1/User [] []

And the apache error log (yup, time doesn't match, but it's the whole log for today...) :

[Tue Aug 22 08:39:29.696572 2017] [ssl:warn] [pid 5816:tid 252] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 22 08:39:29.758972 2017] [mpm_winnt:notice] [pid 5816:tid 252] AH00455: Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 configured -- resuming normal operations
[Tue Aug 22 08:39:29.758972 2017] [mpm_winnt:notice] [pid 5816:tid 252] AH00456: Apache Lounge VC11 Server built: Dec 20 2016 13:02:04
[Tue Aug 22 08:39:29.758972 2017] [core:notice] [pid 5816:tid 252] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Tue Aug 22 08:39:29.758972 2017] [mpm_winnt:notice] [pid 5816:tid 252] AH00418: Parent: Created child process 6584
[Tue Aug 22 08:39:30.148973 2017] [ssl:warn] [pid 6584:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 22 08:39:30.726174 2017] [ssl:warn] [pid 6584:tid 264] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 22 08:39:30.835374 2017] [mpm_winnt:notice] [pid 6584:tid 264] AH00354: Child: Starting 150 worker threads.

[tarasm]

Perhaps, windows rejects some some requests. Try to add these code in <espocrm-directory>/.htaccess:

Allow from 127.0.0.1
Allow from ::1

[plantaxl]

Tarasm, know it, you're my hero.

I had to create a .ftaccess file in the espocrm folder, and now everything's working just fine!

Thanks a lot to you and Tanya for your help and your time!