Graph Problem SQL Error Nr. 1045

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
dscratch
Posts: 1
Joined: Thu Mar 08, 2012 8:13 pm

Graph Problem SQL Error Nr. 1045

Post by dscratch »

Installed Cacti using the Windows installer on a XP machine. Graphs are not showing up and RRD folders are not being created in the directory /cacti/rra/. I looked all over and cannot find an answer.
SQL Log shows this error:

Creating Windows service entry.
Service name: "MySQL"
Parameters: "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\\my.ini" MySQL.
Windows service MySQL installed.
Service started successfully.
The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)

RRDTool Command:

C:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Conway - Traffic - 10.10.237.34" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes per second" \
--slope-mode \
--font TITLE:10: \
--font AXIS:7: \
--font LEGEND:8: \
--font UNIT:7: \
DEF:a="C\:/Inetpub/wwwroot/cacti/rra/13/19.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Inetpub/wwwroot/cacti/rra/13/19.rrd":traffic_out:AVERAGE \
AREA:a#00CF00FF:"Inbound" \
GPRINT:a:LAST:" Current\:%8.2lf %s" \
GPRINT:a:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:a:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"Total In\: 0 bytes\n" \
LINE1:b#002A97FF:"Outbound" \
GPRINT:b:LAST:"Current\:%8.2lf %s" \
GPRINT:b:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:b:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"Total Out\: 0 bytes\n"

RRDTool Says:

SCHEDULER LOG
"Cacti.job" (php.exe) 3/8/2012 3:20:00 PM ** ERROR **
The attempt to retrieve account information for the specified task failed; therefore, the task did not run. Either an error occurred, or no account information existed for the task.
The specific error is:
0x8004130f: No account information could be found in the Task Scheduler security database for the task indicated.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: Graph Problem SQL Error Nr. 1045

Post by BSOD2600 »

Looks like you have several issues occurring.

What version of the installer did you use, cacti 0.8.7i?

1) Mysql error is odd because the installer always specified a password when it configured settings, yet the error message states none was used.
2) scheduler error is more troubling, since it would appear you have larger issues at hand with the OS that the task is corrupted.
musangbeku
Posts: 5
Joined: Tue Jul 23, 2013 8:47 pm

Re: Graph Problem SQL Error Nr. 1045

Post by musangbeku »

Hello.

I've been encountering some error.
And I using cacti 0.8.8.a installer.

Previously I tried to install cacti with that installer and it worked fine, and then I uninstall it and tried to uninstall cacti with xampp and it doesn't work for me since I'm a total beginner in this aspect.

Now, I'm trying to install it again with the 0.8.8.a installer, and there is that error.

So, what can I do to configure it?
What can I do to help you troubleshoot it?

Bunch of thanks for helping me! :D


Regards.
musangbeku
Posts: 5
Joined: Tue Jul 23, 2013 8:47 pm

Re: Graph Problem SQL Error Nr. 1045

Post by musangbeku »

Okay I already know how to solve it.

Just delete your previously mySQL folder at C:/Users/All User/MySQL :D

Thanks.


Regards.
Ludwigrhysy
Posts: 1
Joined: Wed Aug 28, 2013 3:48 am

Re: Graph Problem SQL Error Nr. 1045

Post by Ludwigrhysy »

I've saved it into a file, and inside it looks like a valid PNG file - but it can't be opened by any program, they all say that file structure is invalid.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests