Voicemails are not getting emailed

[mrbnet]

I have configured voicemails to be sent via email. Voicemails are not being sent and are not in the queue.

I am seeing the following error in the logs:

2022-11-02 20:53:14.829786 95.03% [ERR] switch_cpp.cpp:1465 [database] can not bind parameter: undefined parameter: email_from
2022-11-02 20:53:14.829786 95.03% [INFO] switch_cpp.cpp:1465 [send_mail] Email added to the queue as email_queue_uuid = 0be5c0a5-fc39-4f7b-94e7-ed2266644508

Running FusionPBX 5.0.5 d3ee2562869b078d52640b3ef94985ad44d64465

 

[dbbrito]

Advanced>>>Default settings>>> Email: smtp_from >> and configure it with your sending email, or in most cases your provider's user email.

 

[mrbnet]

That value is set already. FWIW: I can send a successful test email from Status >> Email Logs and Status >> Email Queue.

I'm using an external SMTP server.

There is also a `smtp_from` field in the voicemail category which is set.

 

[UCtech]

If you upgraded from 4.x to 5.x, you will need to install the email queue. This was covered in a few other threads like this one:

transcription stop working after upgrade to v5

Hello All, After upgrading to Version 5 from 4.5 my transcription email stopped working. I get a voicemail to email with an attachment with Transcription ${message_text} in the end of the email . When I enable the Email queue my email sending stop working. when the email queue is disabled my...

www.pbxforums.com

Here is the link on how to install the service:

Email Queue — FusionPBX Docs documentation

docs.fusionpbx.com

Here are instructions including how to install the services for email & fax in the upgrade instructions:

Version Upgrade — FusionPBX Docs documentation

docs.fusionpbx.com

That's what worked for me!

 

[firmfoit]

I'm getting the same error on a new install, version 5.0.5 b620b36f28f828dd9a9951b73983af667a5adb51, Deb 11.

2022-11-09 11:32:59.139487 95.37% [ERR] switch_cpp.cpp:1465 [database] can not bind parameter: undefined parameter: email_from
2022-11-09 11:32:59.139487 95.37% [INFO] switch_cpp.cpp:1465 [send_mail] Email added to the queue as email_queue_uuid = 376fdafb-3eb2-4999-89b6-eff907584ca4

 

[mrbnet]

@firmfoit Are you seeing emails actually get delivered? I am still getting the same messages as you. I never actually see an email landing in the queue though.

 

[firmfoit]

No, my symptoms are identical to yours; the test email works fine, but doesn't appear in the logs; there is nothing hitting the queue or the logs when a voicemail is saved.

 

[mrbnet]

I tried setting the "email_from" parameter in the dialplan still without luck.

<action application="set" data="email_from=no-reply@example.com"/>

 

[firmfoit]

I haven't had a chance to get back to it sorry, will have to have another look probably early next week at this stage

 

[Scubadave112]

I hate to over simplify your situation but just curious did you turn it on/off, LoL.... I only mention this because I had this exact problem yesterday. I just did a git pull upgrade and then service email_queue restart, 10 seconds later queue went from trying to sent. I am running 5.0.5 and as mentioned above the latest commit from 16 hours ago as of writing this.

 

[firmfoit]

I haven't tried, but in my case I don't think things are even hitting the queue, the missing email_from parameter might be breaking the chain before it even gets that far. I might try an update tonight and see if anything has been changed.

 

[Nedo]

Same here, newely installed fusionpbx istance.
There is a way to show a debug log about this?

 

[Nedo]

I have update the source code and in log i see:
[database] can not bind parameter: undefined parameter: email_from

 

[UCtech]

For those with the missing email parameter issue, what do you have in Advanced--Default Settings--Email--smtp_from ? My working system has noreply@mydomain.com and Enabled is True. Curious if this setting is the issue or something else . . .

 

[mrbnet]

For those with the missing email parameter issue, what do you have in Advanced--Default Settings--Email--smtp_from ? My working system has noreply@mydomain.com and Enabled is True. Curious if this setting is the issue or something else . . .

On my instance the `smtp_from` field has a custom address set of `support@thedomain.com` and Enabled is set at true.

There is an `email_from` parameter there which I *think* I added from troubleshooting with a `no-reply@` address.

Still no luck here.

 

[mrbnet]

Still no luck on FusionPBX 5.0.6.

 

[mrbnet]

I am guessing that I don't have a default setting correct. If I hardcode the email_from address at the following line, it works. https://github.com/fusionpbx/fusion...scripts/resources/functions/send_mail.lua#L45

 

[mrbnet]

The following setting does not seem to load anything and still results in "nil".

email_from = settings:get('email', 'smtp_from', 'text');

That setting is set, however.

 

[socialboh]

same problem here:

[database] can not bind parameter: undefined parameter: email_from

FusionPBX 5.0.6

 

[Nedo]

I am guessing that I don't have a default setting correct. If I hardcode the email_from address at the following line, it works. https://github.com/fusionpbx/fusion...scripts/resources/functions/send_mail.lua#L45

Can you please post an example of modified code by you, i dont understand where put the value that are you saying.

I opened a bug ticket for this, they replied that everything works correctly and to make sure that the email_queue service is active and to disable the email_from item in the settings. I've done everything, fax emails work (they worked before) but voicemail still doesn't go with the usual error, if I want further support I have to upgrade to blue member, imho I don't think there is any interest from them to fix the problem.