I’ve used following documentation
http://lurker.dyndns.org/Cacti%20Installation%20on%20Fedora%2010.pdf
Few commands is incorrect like mysql -u <username> -p <dbname>
Configuration is at /usr/share/cacti/include or /var/www/html/cacti/
Some parts from following link helped as well
http://kezhong.wordpress.com/2011/07/15/installing-cacti-on-fedora-14/