Nectar problem : unable to add a report

[ArcThemaster]

Hello everyone.

I'm trying to find a little help here about a problem with nectar. I installed cacti 0.8.8a on a Red Hat EL5 a couple of days ago, and after I installed nectar. My problem occurs when I try to add a report : after filling-in all required fields I click on "create" nevertheless nothing is done. No report is created and all fields become blank. You can see this result on the first snapshot.

page to create a new report

Capture.PNG (84 KiB) Viewed 1788 times

Morever, I saw in the cacti log file a lot of errors related to the nectar plugin. It's always the same error as you can see below.

multiple errors visible on the cacti log file

Capture1.PNG (169.23 KiB) Viewed 1788 times

For my part, I don't have any idea about my issue but I guess that my issue would be related to a MySQL dysfunction. Have you ever seen a problem like this one before? If yes, how can I solve it?

Thanks for your help.

ArcThemaster

[ArcThemaster]

Hello,

A lot of time passed since my last post and my problem is still not solved.

To remind the initial subject, I am not able to create a report with nectar. When I am trying to create a new report, the page loads and nothing happens. All fields which I filled in become blank or take a default value.

I still have the error 1146 which is visible in my logs as below:

error in the log file

Capture2.PNG (47.44 KiB) Viewed 1687 times

To help, here are the specs of my system and installed plugins versions:

Cacti Version: 0.8.8a
Plugin Architecture Version: 3.1
Plugin Settings Version: 0.71
Plugin Nectar Version: 0.35a

I would appreciate a little help, maybe I am not the only one with this issue.

Thanks

ArcThemaster

[phalek]

Does the table "plugin_nectar" exists ?

[ArcThemaster]

I was looking for the table "plugin_nectar" this morning after reading a post about SQL row failed.

Unfortunately, the table doesn't exists. Why the table was not created dynamically as the others plugin (settings for example) ?

I tried to reinstall nectar several times but the issue was still present. So, what can I do to?

ArcThemaster

[ArcThemaster]

Nobody had this problem before and can help me?

I installed Cereus too and I had the same issue: no tables were created. I think U am doing something wrong but what?...

ArcThemaster

[phalek]

Hi

Did you do a "Grant All" when creating the cacti user ?

[ArcThemaster]

Hello phalek,

Aie I didn't do that inline command.

So after your feedback I did

Code: Select all

 
GRANT ALL ON *.* TO pcacti01;
flush privileges;

I restarted the server and reinstalled my plugins after that. Unfortunately, It's always impossible to create a report on nectar. Tables were not created.
Maybe I can create tables manually to solve the problem? (I don't think this is the best way but if it's the only way...)

ArcThemaster

[ArcThemaster]

Finally my problem was solved. After few minutes after the reboot and also a restart of the deamon httpd, tables were dynamically created.

As a conclusion, my Nectar is functional and that's great. Thank you for your help Phalek.

ArcThemaster

PS : subject closed

[phalek]

still kinda odd ...