Re: [cacti] - add device with cacti

HI Muhammad,

before installing cacti I added the RPM/YUM repo:

rpm -Uhv 
http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/rpmforge-release-0.3.6-1.el5.rf.i386.rpm
rpm -Uvh 
http://download.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm

I have prepared the mysql database. example:

create database cacti;
GRANT ALL ON cacti.* TO cacti@localhost IDENTIFIED BY 'cacti';
flush privileges;
quit

and

mysql -u cacti -p cacti < /path/cacti.sql (In the version 0.8.8a the 
files installation are stored in /usr/share/cacti/)

I have modified the configuration file of cacti and I have applied che 
name db, username and password
I have restarted mysql

It's correct? Or mistake?

On 09/25/2012 05:53 PM, Muhammad El-Sergani wrote:
> Hi Paolo,
>
> I'm not sure actually, I have no plugins installed.
>
> But checking quickly, MySQL error 1146 means the table being queried
> doesn't exist.
>
> Have you installed through RPM/YUM or from source?
> Did you run the cacti.sql script during the installation (if from source),
> while MySQL was running?
>
> Thanks
> //M
>
>
>
> On Tue, Sep 25, 2012 at 5:43 PM, Paolo De Michele
> <[email protected]>wrote:
>
>> Hi Muhammad,
>>
>> I did basic installation
>> Where I can verify the plugins?
>>
>> Thanks in advance
>>
>> On 09/25/2012 05:36 PM, Muhammad El-Sergani wrote:
>>> No plugins installed, right?
>>>
>>> Thanks
>>> //M
>>>
>>>
>>>
>>> On Tue, Sep 25, 2012 at 4:31 PM, Paolo De Michele
>>> <[email protected]>wrote:
>>>
>>>> Hi everyone,
>>>>
>>>> I have a problem with cacti (version 0.8.8a)
>>>> I have installed the centos 5.8 virtual machine and I have configured
>>>> all services.
>>>>
>>>> when I add a device and press Save, have this error: Error: Save Failed.
>>>>
>>>>
>>>> I see that log:
>>>>
>>>> 09/25/2012 03:05:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!,
>>>> Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function  FROM
>>>> plugin_hooks AS ph  LEFT JOIN plugin_config AS pc  ON
>>>> pc.directory=ph.name  WHERE ph.status = 1 AND hook = 'poller_bottom'
>>>> AND ph.name IN ('settings', 'boost', 'dsstats')  UNION  SELECT pc.id,
>>>> ph.name, ph.file, ph.function  FROM plugin_hooks AS ph  LEFT JOIN
>>>> plugin_config AS pc  ON pc.directory=ph.name  WHERE ph.status = 1 AND
>>>> hook = 'poller_bottom'  AND ph.name NOT IN ('settings', 'boost',
>>>> 'dsstats')  ORDER BY id ASC"
>>>>
>>>> where is the problem?
>>>> thanks in advance
>>>> regards
>>>>
>>>>
>> ------------------------------------------------------------------------------
>>>> Live Security Virtual Conference
>>>> Exclusive live event will cover all the ways today's security and
>>>> threat landscape has changed and how IT managers can respond.
>> Discussions
>>>> will include endpoint security, mobile security and the latest in
>> malware
>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>> _______________________________________________
>>>> cacti-user mailing list
>>>> [email protected]
>>>> https://lists.sourceforge.net/lists/listinfo/cacti-user
>>>>
>> ------------------------------------------------------------------------------
>>> Live Security Virtual Conference
>>> Exclusive live event will cover all the ways today's security and
>>> threat landscape has changed and how IT managers can respond. Discussions
>>> will include endpoint security, mobile security and the latest in malware
>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>> _______________________________________________
>>> cacti-user mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/cacti-user
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>> _______________________________________________
>> cacti-user mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/cacti-user
>>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cacti-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/cacti-user
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/