Nectar Report ''New Report'' Sent Successfully - NOT

[MrGRTuk]

Hello,
Sorry for this being my first post.
Been using Cacti for close to 3 years now but just decided to install the Settings and Nectar plugin with the aim of sending email reports daily.

The Test email is working but sending the report via the "Send Report" link in Nectar is not even though it shows "Nectar Report ''New Report'' Sent Successfully".

I've tried different settings and different email destinations and always end up with the same result; an apparently successfully sent report that doesn't arrive anywhere.

I've took a tcpdump and all looks successful. Let me know what kind of information you'd like to see to help me.

Cacti version: 0.8.8f
Ubuntu 12.04 LTS

Report.jpg (287.48 KiB) Viewed 4485 times

Thanks

[MrGRTuk]

Looks like the problem is that Cacti is adding the simple quotes in the Nectar Tab.

[MrGRTuk]

The issue is indeed cacti adding the single quotes every time the Nectar report is saved. This occurs on Cacti 0.8.8f but not in 0.8.8c

[djamp42]

Does anyone have a fix for this, Cacti is adding single quotes around my fields too.

Thanks,

[mgeb2003]

Hello,
I have the same problem, is there a solution to fix it or a way around the problem.

Thank you

cacti 0.8.8f
nectar0.35a

[ubertinador]

Hi,

In the last version of Cacti, they changed 2 functions :
- sql_sanitize
- sql_save

I guess it did not work out for the plugin nectar...

All you have to do, is to change the file *cacti folder*\lib\database.php by the one in a previous version (0.8.8c).
For me, everything works like a charm.

Someone, point it out : http://forums.cacti.net/viewtopic.php?f=21&t=54909

[GlueGuy]

I think the problem is the way the components (CentOS, php, and mysql) have changed in later revisions.

On my system (CentOS 6.7, php 5.3.3, and mysql 5.1.73), it turns out that the $_POST automatically fixes the outer quotes. So I just removed sql_sanitize() everywhere it occurred. Unfortunately, that broke embedded single quotes (and other characters) that were within a text field (e.g. ' became \' ).

What I discovered turned out to be relatively simple. I just replaced "sql_sanitize()" with "stripslashes()" wherever it occurred. For example, the following line

Code: Select all

$save['name']                   = sql_sanitize(form_input_validate($_POST['name'], 'name', '', false, 3));

became

Code: Select all

$save['name']                   = stripslashes(form_input_validate($_POST['name'], 'name', '', false, 3));

stripslashes is a built-in php function.

[markcasera]

I tried your solution man. my whole cacti went down. im getting error 500. lol

[aftershocks]

bump... i'm having this issue too.. stupid quotes!

anyone with a solution?