[SOLVED] win2k3 weathermap install permissions

MU-IT · Cacti User Joined: 06 Nov 2007 Posts: 55

I have seen some pretty sweet maps from this product and i'm pretty excited to show ours off... once it's working.

I've followed the install guidelines and got weathermap working on the test win2k3 server in vmware. I then tried to install the plugins on the live box.

Everything works fine, all the other plugins work fine.... with the $plugins[] = 'weathermap'; line commented out.

When I 'uncomment', enabling weathermap, this shows where the weathermap tab should be:

Can't create/write to file '#sql_644_0.MYD' (Errcode: 17)

I'm using 8.7.a with the plugin architecture in place, on a win2k3 box, with iis not apache. I've enabled permissions as i had on the virtual server that is working.

I assume I missed a detail somewhere... help?

Howie · Posted: Wed Nov 21, 2007 3:04 pm Post subject:

That looks like perhaps mysql doesn't have permission to create new table files?

One of the first things weathermap does when it runs for the first time is create a few extra tables in the cacti db. That seems to be a warning that the mysql process can't create the files it needs to.

I've never seen that before though, and I don't use Cacti or MySQL on Windows, so it's a guess.

MU-IT · Cacti User Joined: 06 Nov 2007 Posts: 55

That was my assumption as well. Where can I find the code pertaining to the tables that are needed?

I'd like to interrogate the mysql database and see what sort of problems arise if i create them manually.

Howie · Posted: Wed Nov 21, 2007 3:44 pm Post subject:

In setup.php there's a function called weathermap_setup_table() that does the work.

MU-IT · Cacti User Joined: 06 Nov 2007 Posts: 55

Could it also be a performance issue?

Oddly enough, all the tables were present. I then enabled the plugin and configured a pair of maps, and watched them for a bit.

then, rather suddenly, while adding devices to cacti, i got the error message again, and had to disable weathermap.

Howie · Posted: Wed Nov 28, 2007 9:13 am Post subject:

Googling around for "Can't create/write to file (Errcode: 17)" points to problems with permissions and the temporary folder configured within mysql. Perhaps something like - it creates a temp file for a transaction, is unable to delete the temp file, and then eventually has a filename clash with an existing file.

Actually, this might help: http://bugs.mysql.com/bug.php?id=9551

Anyway, the issue seems to be with mysql rather than weathermap or cacti... since that bug report specifically mentions 'SHOW...' commands, I guess it's when weathermap checks to see if the tables it needs already exist.

MU-IT · Cacti User Joined: 06 Nov 2007 Posts: 55

I'd gotten the same permissions issues when i did the errcode 17 google... and assumed i'd misconfigured weathermap, and stopped searching.

renaming the .myd file lets weathermap run, i don't know for how long.

I've disabled the McAfee On-Access Scanning so we'll see.

thanks for the footwork!

Howie · Posted: Wed Nov 28, 2007 10:54 am Post subject:

Seems that the actual solution they are talking about is setting up a seperate temporary folder for MySQL to use, so that McAfee doesn't interfere.

MU-IT · Cacti User Joined: 06 Nov 2007 Posts: 55

I'll probably end up just excluding the folder from mcafee.

Thanks for your help!