MYSQL server change

zippytech · Post by **zippytech** » Tue Jun 12, 2007 1:40 pm

i have cacti installed for a few months, i run mysql on a dif server 00.00.00.01

i want to change the mysql server to 00.00.00.2

ran mysqldump

set new mysql server same version up and imported data

make connection and all devices are listed but no graphs.

tried a debug and i got RRDTool Says:GRAPH ACCESS DENIED

any ideas where the change need to be added

i can even switch back to the old server and every thing works find, just cannot see any settings that might mess with it

Thanks again

Post by **gandalf** » Tue Jun 12, 2007 2:39 pm

Seems to be a permission problem for the webserver gaining access to the rrd files
Reinhard

zippytech · Post by **zippytech** » Tue Jun 12, 2007 3:29 pm

what i cannot figure is why it don't' do it on mysql server A
but does do it on B server

the only change is the mysql server address in config.php

Post by **rony** » Tue Jun 12, 2007 3:42 pm

What version of mysql to what version of mysql?

What version of Cacti?

Post by **gandalf** » Tue Jun 12, 2007 3:45 pm

Does the webserver's user has read access to the mysql tables? MySQL is picky on hostnames
Reinhard

zippytech · Post by **zippytech** » Tue Jun 12, 2007 3:45 pm

Server version: 5.0.41 FreeBSD port: mysql-server-5.0.41 NEW

Server version: 5.0.1-alpha on old server

zippytech · Post by **zippytech** » Tue Jun 12, 2007 3:50 pm

Version 0.8.6d

Post by **rony** » Tue Jun 12, 2007 3:54 pm

Um... Wow, Upgrade your Cacti..... Seriously... So many issues.

zippytech · Post by **zippytech** » Tue Jun 12, 2007 3:56 pm

gandalf wrote:Does the webserver's user has read access to the mysql tables? MySQL is picky on hostnames
Reinhard

yes

Cacti

MYSQL server change

MYSQL server change

well

servers

version

Who is online