Error:
4/7/2012 5:37:49 PM - CMDPHP: Poller [0] ERROR: SQL Cell Failed!, Error: '1017 ', SQL: "SELECT count (*) FROM polle
WHERE r_time poller_id = 0 AND end_time> '0000-00-00 00:00:00 '"
4/7/2012 5:38:34 PM - CMDPHP: Poller [0] ERROR: SQL Cell Failed!, Error: '1017 ', SQL: "SELECT count (*) FROM polle
r_time WHERE end_time = '0000-00-00 00:00:00 '"
Procedure:
If the file cacti.log you see the above error tt indicates a failure with poller_output mysql table.
In this respect, I have seem three different solutions, order from the less risky to the highest.
1) Repair mysql table with a php script that brings cacti
# php $PATH-TO-CACTI/cli/repair_database.php
2) Repair the table with mysql command:
# mysql> REPAIR TABLE poller_output;
If you do not know the user information for the mysql database, it can be found here:
$PATH-TO-CACTI/include/config.php
3) Remove the table and do it again (this solution despite being aggressive works perfectly and you do not lose the historic Cacti information). Just enters the mysql CLI and copy/paste the following:
-
- Table structure for table `poller_output`
-
DROP TABLE IF EXISTS `poller_output`;
CREATE TABLE `poller_output` (
MEDIUMINT local_data_id `` (8) unsigned NOT NULL default '0 ',
Rrd_name `` varchar (19) NOT NULL default'',
`Time` datetime NOT NULL default '0000-00-00 00:00:00 ',
`Output` text NOT NULL,
PRIMARY KEY (`local_data_id`, `rrd_name`, `time`)
) TYPE = MyISAM;
-
- Dumping data for table `poller_output`
-
Poller_output `LOCK TABLES` WRITE;
/ *! 40000 ALTER TABLE `poller_output` DISABLE KEYS * /;
/ *! 40000 ALTER TABLE `poller_output` ENABLE KEYS * /;
UNLOCK TABLES;
Ready!, Then you can wait for the poller runs 15 minutes and you will have something in your graphs. If you want to force the poller command is as follows:
# /usr/bin/php-q /var /www/miServer-cacti/poller.php -force
I hope it will be useful,
Site dedicated mainly to internetworking. The goal is to share experiences, teach IP, IPv6. Talk about Linux, IP services, servers, promote IPv6 adoption, routing protocols, security and in some cases just some thoughts. Keywords: linux, cisco, ospf, bgp, eigrp, ip, ipv6, sla, link, routers, routings, telco, telecommunications, security, ipv4
Saturday, January 12, 2013
Monday, January 7, 2013
Devede. One solutions for two different errors
Situation:
1) When creating a .iso image using Devede and creating subtitles in Spanish DeVeDe returns the error: "Failed to write to the destination directory. Check That You have privileges and free space there".
2) When you create a .iso using Devede and creating subtitles in Spanish Devede returns the error: "conversion failed. It Seems a bug of spumux"
Solution:
The problem is due to the subtitle file format, it must be a .srt and UTF-8 encoding
That is, the solution is to have the .srt with UTF-8 encoding. To do that you can use Microsoft Word, and follow the following procedure:
a) Open the subtitle file .srt with Microsoft Word
b) File -> Save As -> select Plain Text (. txt)
c) Click on save
d) A new window appears, select the option "Other encoding"
e) Select UTF-8 from the list on the right side.
Done!, re-create the ISO using Devede.
Digital Storytelling, Tech Trends blog amazon acronyms Data Is Sacred!
cybersecurity
specialty pharmaceutical company focused on commercializing branded and generic pharmaceuticals. buy hydrocodone 10mg online australia|order hydrocodone 10mg overnight delivery safely USA we offer the best services your security is our priority
Saturday, January 5, 2013
Disable / shutdown iptables on Linux
Introduction:
Sometimes it is necessary to "shutdown" or disable our Linux iptables,
the procedure depends on the Linux distribution you're using.
1) Procedure if you are using Redhat, Fedora, Mandriva / Mandrake or Centos, you just have to run the following:
# service iptables save
# service iptables stop
# chkconfig iptables off
or
# / etc /init.d/iptables stop
2) How to disable iptables on Debian or Ubuntu
a) Create a script called fw.stop with the following contents:
# /bin/sh
echo "Stopping firewall and Allowing everyone ..."
iptables -F
iptables -X
iptables -t nat -F
iptables -t nat -X
iptables -t mangle -F
iptables -t mangle -X
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -P OUTPUT ACCEPT
b) Give execute permission to the script:
# chmod + x / root / fw.stop
or
# chmod 755 fw.stop
c) You can run the scritp with the following command:
# ./fw.stop
More info at:
http://sources68.com/linux-disable-remove-the-iptables-firewall-1fa67761.html
# service iptables save
# service iptables stop
# chkconfig iptables off
or
# / etc /init.d/iptables stop
2) How to disable iptables on Debian or Ubuntu
a) Create a script called fw.stop with the following contents:
# /bin/sh
echo "Stopping firewall and Allowing everyone ..."
iptables -F
iptables -X
iptables -t nat -F
iptables -t nat -X
iptables -t mangle -F
iptables -t mangle -X
iptables -P INPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -P OUTPUT ACCEPT
b) Give execute permission to the script:
# chmod + x / root / fw.stop
or
# chmod 755 fw.stop
c) You can run the scritp with the following command:
# ./fw.stop
More info at:
http://sources68.com/linux-disable-remove-the-iptables-firewall-1fa67761.html
Friday, January 4, 2013
Cisco clear line does not work
Case:
When performing a "clear line" in a Cisco Router/Switch to disconnect a Telnet or SSH session does not work. The user still in the vty.
Example:
IMP# sh user
Line User Host (s) Idle Location
2 vty 0 idle 00:00:01 abcd aacosta
* 4 vty 2 idle 00:00:00 pepe xx.yy.zz.dd
We want to disconnect aacosta:
IMP# clear line vty 2
and still appearing:
IMP# who
Line User Host (s) Idle Location
2 vty 0 idle 00:00:39 abcd aacosta
* 4 vty 2 idle 00:00:00 pepe xx.yy.zz.dd
Procedure and solution:
There are two ways to do it:
a) Quickly and 99% sure it will works (and less likely to damage something else).
Instead of using "clear line vty" use "clear tcp line":
So (again to disconnect pepe):
IMP# clear tcp line 2
[Confirm]
[OK]
A website like https://dealectronic.com will provide you with the highest quality in the industry.
When performing a "clear line" in a Cisco Router/Switch to disconnect a Telnet or SSH session does not work. The user still in the vty.
Example:
IMP# sh user
Line User Host (s) Idle Location
2 vty 0 idle 00:00:01 abcd aacosta
* 4 vty 2 idle 00:00:00 pepe xx.yy.zz.dd
We want to disconnect aacosta:
IMP# clear line vty 2
and still appearing:
IMP# who
Line User Host (s) Idle Location
2 vty 0 idle 00:00:39 abcd aacosta
* 4 vty 2 idle 00:00:00 pepe xx.yy.zz.dd
Procedure and solution:
There are two ways to do it:
a) Quickly and 99% sure it will works (and less likely to damage something else).
Instead of using "clear line vty" use "clear tcp line":
So (again to disconnect pepe):
IMP# clear tcp line 2
[Confirm]
[OK]
b) And the second way more drastically:
We have to search for the TCP connections in the router at that time. We use the command "show tcp brief". We filter port 23 (Telnet) or 22 (SSH) as applicable.
For example:
IMP# show tcp brief | i \ 23 _
63820270 n.n.n.n.23 a.b.c.d.56691 ESTAB
637E1AC0 x.x.x.x.23 xx.yy.zz.dd.39431 ESTAB
The value on the left in the memory addrees within the TCB (TCP Block), this is precisely the TCP connection we will have to remove.
The command is:
IMP# clear tcp tcb 637E1AC0
NOTE: Please be sure of the value before deleting the TCP session, remember that the router may have HTTP, BGP, HTTPS and other important TCP connections.
Good luck, I hope it was useful,
A website like https://dealectronic.com will provide you with the highest quality in the industry.
Subscribe to:
Posts (Atom)