Yetiforcecrm: Not emailing contact or login credentials

[ghost]

Issue

system is not emailing clients login data to portal. I have followed all manuals, cron is running, smtp is working and test works. portal is setup and config.inc / config and api.php have all been set correctly.

**In location Software configuration > Automation > Workflows

Generate customer login details (All tasks 1) (Active tasks 0)
Send customer login details (All tasks 2) (Active tasks 0)**

After I clicked the checkbox to the right it became

Generate customer login details (All tasks 1) (Active tasks 1)
Send customer login details (All tasks 2) (Active tasks 2)

But still no emails sent

In config.inc

`// url for customer portal (Example: https://portal.yetiforce.com/)
$PORTAL_URL = 'https://myportal.mysite.com';

// helpdesk support email id and support name (Example: '[email protected]' and 'yetiforce support')
$HELPDESK_SUPPORT_NAME = 'LOFD Client Portal';
$HELPDESK_SUPPORT_EMAIL_REPLY = '[email protected]';`

In api.php

$enabledServices = [ //'mobile', 'yetiportal', //'dav', //'webservices', //'webservice',

In

CRM config.php

$vtiger_path = "https://CRM.mywebsite.com";

Cron lines

/5* sh /home/litafire/portal.litonfire.design/cron/vtigercron.sh
/5* >/home/litafire/portal.litonfire.design/cache/logs/cron.log

Permissions set to 755 for all folders and files in /cron

Cron is working

SMTP is working

Actual Behavior

Create contact, system creates. No emails received by contact.

Expected Behavior

Send Emails, find contacts again via search

How to trigger the error

1.create contact
2.contact is made
3.no emails sent even with cron running and smtp on and working.

Your Environment

• 3.4.0
• All Web browsers
• linux (version unknown but probably latest)

NOTE: in Software configuration > Logs > Server configuration > Start It is showing that ZIP library and LBL_SOAP_LIBRARY are not installed. But I installed both "archive zip" and "soap" for php on my server... why would this be this way? am I missing some files?

[skramanzia]

Hi @slater101 you have to enable workflow to send email. In workflow -> Contacts

[ghost]

I have clicked on send customer login details, then whent through the process and see that a condition is "if permission to send emails is set to yes" but How do I set permission?

I can't find where I turn the permission to send emails on.

Thanks for the help @skramanzia

Thanks,
Kyle

[skramanzia]

@slater101 is a check in the contact module when you select a contact.

[ghost]

@Skramanzi,

I have done this the whole time with all of my testing.

This does not fix the issue.

I have also tested with user set to active, user set inactive and many other options with always having "permission to send emails"

Regards.
Kyle

[skramanzia]

Are you enable active task in Workflow?, Can test again creating a new contact?. Email only send the first time. You can check if user create in database table "w_yf_portal_users"

[ghost]

Yes in workflow it is set to active for all tasks related to contacts.

I have tested again with new contact.

No email sent.

Will check if database user created now, will respond with table info.

Thanks.
Kyle

[ghost]

@skramanzia

w_yf_portal_users is not there?

I have no tables that even start with a W_

EDIT: I was wrong, its there.

Thanks,
Kyle

[skramanzia]

In my system the table is correct. I am not use portal in this environment, but the information save iit in the table.

[ghost]

@skramanzia I did find w_yf_portal_users, sorry.

It is empty, no rows.

What could cause it to not create ?

Fresh install using softoculous, so it is a clean install of newest version.

Thanks,
Kyle

[ghost]

Could this be why?

NOTE: in Software configuration > Logs > Server configuration > Start It is showing that ZIP library and LBL_SOAP_LIBRARY are not installed. But I installed both "archive zip" and "soap" for php on my server... why would this be this way? am I missing some files?

What is LBL_SOAP_LIBRARY? I cannot find anything on google, I thought it was SOAP for PHP so I activated it in my PHP environment and also Activated "Archive ZIP" for php environment but Yeti still says both missing.

[ghost]

Is there an example setup of how custom .htaccess should be? I saw it on the knowledgebase but cannot find it now. I think its my database timeout.

Thanks,
Kyle

[skramanzia]

@slater101 The two libraries you mention are mandatory to use Yetiforce. what's your S.O? and php version?

[ghost]

@skramanazia

Apache Version 2.4.18
PHP Version 5.6.17
MySQL Version 10.0.27-MariaDB-cll-lve

What exactly is LBL_SOAP? If its a php module, I have installed it already .

I have installed php modules "Archive_Zip 0.1.2"
and "SOAP 0.13.0"

Thanks,
Kyle

[skramanzia]

Ok, check the Web server requirement to apply all the recommendation.

https://yetiforce.com/en/implementer/installation-updates/103-web-server-requirements.html

However you can install missing libraries like this (if you use centos for example). after download epel.

yum install php-soap

For ZIP, you can install php-pecl-zip or install php common. If you compile php remember add "--enable-zip" to enable zip library.

[ghost]

@skramanzia I installed php SOAP via pear, does Yetiforce work with Pear installs?

If so, where can I put the put ini_set("include_path", '/home/litafire/php:' . ini_get("include_path") );
Thanks

[skramanzia]

Install SOAP via pear is not the same. I tried this in other time, but only works when install php-soap. It's important check in Logs > Server configuration to confirm the correct instalation of library

[ghost]

Ok, thanks so much @skramanzia I have asked my server admins to handle this since I do not have access to root.

You have been super helpful hopefully this will fix the issue,

I have also asked them to increase timeouts to the following

max_execution_time 600
max_input_time 600 -1
default_socket_timeout 600
mysql.connect_timeout 600
innodb_lock_wait_timeout 600

I am on shared hosting though so I dont know if they will do it.

Regards,
Kyle

[ghost]

@skramanzia

I have fixed everything with the php settings and it is all working now, but I am still not getting any rows created in w_yf_portal_users. Im not sure why :(

EDIT: Wait, I just saw that innodb_lock_wait_timeout is set to 50 and not 600, maybe thats it?

Will change and see.

Thanks.
Kyle

[ghost]

@skramanzia in vtigercron.sh If, export USE_PHP=/usr/local/bin/php was wrong would it have anything to do with it?

Or should export USE_PHP=/usr/local/bin/php be commented out?

Thanks,
Kyle

[skramanzia]

innodb_lock_wait_timeout is a MySQL parameters, check all parameters before go ahead, is too important. Msql and PHP.

Check this example.

vtigercron.sh like this.

Crontab like this to run every five minutes
*/5 * * * * sh /var/www/yetiforce/cron/vtigercron.sh

[ghost]

Ok I had vtigercron.sh wrong I had this

export VTIGERCRM_ROOTDIR=dirname "$0"/..
export USE_PHP=php
export USE_PHP=/usr/local/bin/php

export USE_PHP=/usr/local/php56/bin/php56

How can I set innodb_lock_wait_timeout via htaccess? I have tried every option I know.

innodb_lock_wait_timeout 600

Tried setting this in htaccess but couldn't get the following to work.

php_value innodb_lock_wait_timeout "600"
or
innodb_lock_wait_timeout "600"
or
innodb_lock_wait_timeout = 600

[skramanzia]

innodb_lock_wait_timeout and max_allowed_packet are mysql parameters, you need to set in /etc/my.cnf.

Comment this
export USE_PHP=/usr/local/bin/php
You can only have one USE_PHP

[ghost]

Ok,

I have done everything except innodb_lock_wait_timeout 600, Since I am waiting on my server admin to handle it I wanted to see if that was the cause.

Testing showed that without innodb_lock_wait_timeout 600 set to 600, currently "50" and tigercron.sh fixed, that my system did not make any rows in w_yf_portal_users still.

So basically if after that is fixed and set to innodb_lock_wait_timeout 600 and it works, we will know that was the cause of this issue. Just wanted to add this in for anyone that googles this problem in the future and trouble shoots all of the above steps.

Will update if innodb_lock_wait_timeout 600 fixes my issue and allows Yetiforce to create rows in table w_yf_portal_users.

Regards,
Kyle

[skramanzia]

Great, please after set parameters, test with create a new Contact and then set check in "portal user"

You can see internal Workflow email queue in "com_vtiger_workflowtask_queue" table.

Good luck.

[ghost]

They will not set it for me because I am on shared hosting. :-(

Might get dedicated IP to fix the issue.

What are some recommended hosts that Yetiforce works well on? Something that uses Cpanel.

Thanks
Kyle

[ghost]

Seems like with those requirements would have to have a VPS to make this work.

Might get a vps.

Will see really want to use this app.

For now, thanks for all the help and take care @skramanzia

[ABaumruck]

Hello slater101!
I would recommend that you use a dedicated VPS or root server which allows you to install your preffered linux OS and you have full control over all settings including the "cron" job which normally is a killer criteria for simple hosting environments.

After a several month long journey I ended up with netcup.de and I am using their "RS 1000 G7 SE" root server. The reason why I found it to be the best is:

• you can upload your own images
  (I used ubuntu with VirtualBox to test YF 3.4 on my local computer, the I exported the VM converted the file to qcow2 format and uploded it to my root server. This worked nearly flawlessly exept for this)
• you are able to make snapshots of your server (in case you are trying some updates/changes and you are not sure how it behaves)
• and it is good value for the money

If you need some further explanation on the required YF settings you might also like to read this. It explains some of the poorly documented parts from the YetiForce webserver requirements
To be honest, this still not covers everything (no Portal, no webdav, ...)

Let me add one more thing. If you cannot get the "innodb_lock_wait_timeout = 600" setting correct before you install YetiForce there is a good chance that not all the db-tables are set up correctly. And my strong advise is to reinstall YetiForce.
For example I noticed that when I had set it badly:

• the YF installation routine did not give a "finished" message
• I was unable to save some of the basic settings (like language, etc)
• And I was unable to configure some of the modules (aka add custom fields)

But the really odd thing was that YetiForce still "kind of" worked.

I hope this will help to shorten your journey to a proper YF installation
BR Andreas

[ghost]

@Abaumruck

Thanks so much for the great details.

Wow netcup.de has amazing servers for the price!

I have chosen a VPS server, and srarted learning linnux, I have been doing webdesign professionally for years but have only scratched the surface on server setup and maintenance, this is because most of my clients prefer a fully managed service wich I have never had the time to provide to them. But now that I am transitioning over to full setup, I have to say, its alot of fun! I love linnux, so powerful, easy, and I find learning the commands and operation is incredibly fast. Linnux is quite amazing. I am starting with the basics for now, practicing safe setup and standard security measure, have done a full lamp, multiple times now and getting better. Had issues running centos7 with php 5.6 and phpmyadmin, but am working the kinks of where I whent wrong. Might just go to centos6 for stability, but prefer going with the newest stuff first, so will see. Once I get my full lamp, plan to snapshot it, then explore how to configure everything. The host im using is very nice and great customer support so it has been perfect for the process of learning. They always help right away from livechat and are always willing to help out.

Thanks for all the notes and pointers, when I get there, I will make sure to have requirements set before I progress to installing.

Yetiforce is awesome, so awesome that I have decided to learn all of this just because of yetiforce.

I still havnt got to see what the inside of the client portal looks like but I trust that it is as awesome.

Can I run yetoforce and the portal on 2 different donmains? That is the plan.

Because I have my website on a cloud host since it is just html / css and like the speed, then I run my file and cloud management (subdomains) on a shared host for the space I am given since it does not require tons of speed and yeti on the vps for the power I need. I think this gives me the best (bang for the buck) plus keeps each piece of my website seperated for easy managment and flexibility.

Thanks for the help!

Regards,
Kyle

[ghost]

@skramanzia @ABaumruck

Not going to believe this, I built a server from the ground up on Centos7 Minimum, Had all requirements met before install.

Everything flawless, running fine... Still not creating any tables in w_yf_portal_users!

I don't know what it is?

Have all requirements met, cron running perfect, smtp works fine. Activated "Generate customer login details" and " Send customer login details" by setting them to "active" in workflows.

Selected "portal user" and "allowed to send emails"

Do I have to checkbox also "active"?

Do I have to "register" my yeti?

Nothing, no users in tables?

What else could it be?

Please help, just spent two full days getting it all set up from scratch to be right back where I started...

Thanks,
Kyle

[ghost]

@skramanzia @ABaumruck Look at this, the setting is right, but it is still showing up red... What does that mean?

I have it set to 10M in my .cnf and it is showing correct here but highlighted red...

Also, why on the website does it say recommended version of PHP is 5.6 but in yeti it says 5.5?
Should I instal 5.5?

Have reinstalled 2x and this still is like this.

[ghost]

Almost got it!

The user account works and they can log in, but it doesnt create any tables for them in the mysql database, also when they create tickets etc... it doent create them, just reloads.

Somehow I broke cron and cannot fix it now

NOTE: fixed cron, read next comment for reason it was not running.

Regards,
Kyle

[ABaumruck]

@slater101
Had a look at your "cron job" entry, not sure that this will help you, but here is mine.

Sudo crontab -e
*/5 * * * * sh /var/www/html/yourYetiForce/cron/vtigercron.sh &>/var/www/html/yourYetiForce/cache/logs/cron.log

You have to keep in mind that

• I am running YF on Ubuntu 16.04 LTS, so you might have a different installation path
• the commands might be different as well
• As long as I understand this is the one and only cronjob you need to setup for YetiForce CRM. There is a chance that you will need another cronjob for the YetiForce portal (sorry I cannot help you much with the portal, since now I've never used it).

In terms of the "max_allowed_packet" I set this in the php.ini and I still get the same "red" failure message. For the moment I assume that to be a "minor bug" in YetiForce

On my VPS I am currently running PHP 5.6.29-1 without a (noticable) problem

Regards,
Andreas

[ghost]

@ABaumruck

Your line worked, Thanks!
I was running it out of the crontab file, but this is better. cleaner.

But for some reason cron only runs 1 time for me, then I have to reinstall php, retry, have been messing with the php executable location. cant seem to find the issue.

EDIT- Got cron working properly with adding
export USE_PHP=/usr/bin/php
to the vtigercron.sh

As far as yeti goes, its running fine. But when it comes to users in the portal. It doesn't create any rows for them in the user tables.

[kpaulaha]

Creating/sending login data do not need cron. You can test it by adding a task e.g. notification to that workflow and edit contact. I have a couple installations sending login info without cron at all on that server.

[ghost]

@kpaulaha

Im aware,
But cron just ended up being one of my many issues during this journey to solving my issue with the portal. So I got sidetracked,

To end the story, I got it to send login credentials one time by changing the path to my php executable file, but when I did that, it broke everything. Portal didnt function and the user was never created in the table in mysql but was somehow able to log in? Not sure how. But couldn't post tickets or see any projects.

Oh well.

Taking a break for a while lol, but I will be back and find out why its not working for me.

When I do, Ill share it here and hopefully one day someone that has the same issue will google it and get resolved.

Regards,
Kyle

[KatarzynaUlichnowska]

Hello,
probably there is still something wrong with your configuration and it requires an individual approach. We can help you with that but it will be paid support. Here are support packages available in our store: https://shop.yetiforce.com/en/17-support

[ldgbc]

@slater101 Hi Slater, how is your journey? I'm trying to play with Yetiforce and eventually founded your issue here. You seem to share quite a lot of similarity with my issue and @PercyP. Perhaps we can learn from each other somehow.

You say that you want "newest stuff first". Just wanted to know if you test out the Developer version? Are you able to get it to work with default setting (Apache httpd.conf in particular)