update plugin not working

[Dacob9906]

I installed the update plugin, and well... nothing happened. I have several other plugins installed, some are working, others are having problems.

These are the install instructions for update plugin:

Extract the archive
Move the extracted folder to your plugins driectory
Add the database mysql cacti < update.sql
Add $plugins[] = 'update'; to the $plugins = array(); section in include/config.php
Check the Check for Updates box under User Management-> Realm Permissions
Set the Update Scan Interval under Settings-> Misc

I'm not sure what the bolded line means?? I assume I didn't do something correctly. Thoughts? Thanks!

[egarnel]

It means that you have to modify the cacti database with the new statements.
By doing the "mysql cacti < update.sql" mysql adds the mods for you.
Always backup the cacti db before adding/changing it.
If you were to view update.sql, you would see a bunch of mysql statements that could be cut & pasted into mysql as well, but you would be better off doing it the 1st way.

I have not worked with a windows Cacti install, so I do not know if the CLI is the same. I can only assume that mysql on windows has similar CLI functionality.

[Dacob9906]

ok, I guess I stated my question wrong... I knew what it wanted me to do, I just didn't know how to do it. Is the bolded lin a command that I can type into the cmd prompt from within the update directory?? Sorry for the confusion...

[egarnel]

As long as your path environment includes the directory where the executable, in this case, mysql, is located, and you specify the location of the .sql file, it doesn't really matter.
If you run the command from within the update directory, you will not have to specify the location of the .sql file.. For example, you were 2 levels up, you would run the command as mysql cacti < /plugings/update/update.sql
(unix syntax in the example)

[Dacob9906]

OK, got ya, thanks a bunch! I'll give it a try.

[Dacob9906]

ok, when I try to do this, this is what I get:

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>cd c:\inetpub\wwwroot\cacti\plugins\upda
te

C:\Inetpub\wwwroot\cacti\plugins\Update>mysql cacti < update.sql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)

C:\Inetpub\wwwroot\cacti\plugins\Update>

not sure what this means??

[egarnel]

Code: Select all

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O) 

that means that you have to supply a password.

The syntax would be mysql -u <user? -p<password> cacti < update.sql
At least that is what it looks like in Linux, should be similar in windows

[Dacob9906]

ok, so I did that and got it to run without giving me any errors, but the "check for updates" box isn't appearing in the realms under usermanagement.

[egarnel]

did you add it to include/config.php?

[Dacob9906]

Yep sure did