Hello <at> all,
I don't no where the issue is, but i hope you can help me.
The problem is that the subagent dos not submit the collected data's to the snmp agent, but i don't no why :(
I can see in tcpdump (see below), that the subagent collect the Data from the MySQL Database.
If i would set one of the Parameters from mysqlMIB i become the Errormessage NotWritable (see below)
I have read many pages, but find not the issue, you are my last hope.
The SNMP 5.4 package was Compiled with following parameters:
<-- SNIP -->
./configure --enable-mib-config-checking \
--enable-ucd-snmp-compatibility \
--without-rpm \
--with-mibdirs="/usr/share/snmp/mibs" \
--with-mibfiles="/usr/share/snmp/mibs/SNMPv2-SMI.txt:/usr/share/snmp/mibs/SNMPv2-TC.txt:/usr/share/snmp/mibs/NET-SNMP-MIB.txt" \
--with-mibs="IP-MIB:IF-MIB:TCP-MIB:UDP-MIB:SNMPv2-MIB:RFC1213-MIB:SNMPv2-SMI:SNMPv2-TC:NET-SNMP-MIB:RFC1213-MIB" \
--with-agentx-socket="localhost:705" \
--with-logfile="/var/log/snmpd.log" \
--with-mib-modules="mibII snmpv3mibs ucd_snmp agent_mibs agentx notification target utilities disman/event disman/schedule host ucd-snmp/diskio examples/example examples/ucdDemoPublic ip-mib/ipv4InterfaceTab
le smux ucd-snmp/extensible agent/extend" \
--prefix="/usr" \
--sysconfdir="/etc/snmp" \
--with-persistent-directory="/var/net-snmp" \
--with-sys-contact="s.mikuszeit <at> syzygy.de" \
--with-sys-location="Bad Homburg|1. OG|Server Room" \
--with-default-snmp-version="2" \
--enable-testing-code \
--enable-local-smux
<-- SNIP -->
My snmpd.conf
<-- SNIP -->
com2sec local localhost secret
com2sec local localhost private
com2sec local localhost public
com2sec mynetwork 10.43.0.0/24 secret
com2sec mynetwork 10.43.0.0/24 private
com2sec mynetwork 10.43.0.0/24 public
com2sec mynetwork 10.42.0.0/24 secret
com2sec mynetwork 10.42.0.0/24 private
com2sec mynetwork 10.42.0.0/24 public
group MyRWGroup v1 local
group MyRWGroup v2c local
group MyRWGroup usm local
group MyROGroup v1 mynetwork
group MyROGroup v2c mynetwork
group MyROGroup usm mynetwork
view all included .1
view system included .iso.org.dod.internet.mgmt.mib-2.system
access MyROGroup "" any noauth exact all none none
access MyRWGroup "" any noauth exact all all none
trapsink 10.43.0.84
trap2sink 10.43.0.84
informsink 10.43.0.84
trapcommunity public
authtrapenable 1
exec enterprises.ucdavis.50.100.1 /bin/sh /tmp/shtest
disk /boot 100000
disk /data 1000000
disk /home 1000000
disk /tmp 100000
disk /usr 100000
disk /var 100000
disk / 100000
load 12 12 12
disablePerl false
<-- SNIP -->
My snmp.conf
<-- SNIP -->
mibfile /usr/share/snmp/mibs/SNMPv2-SMI.txt
mibfile /usr/share/snmp/mibs/SNMPv2-TC.txt
mibfile /usr/share/snmp/mibs/NET-SNMP-MIB.txt
mibs +SNMPv2-SMI
mibs +SNMPv2-TC
mibs +NET-SNMP-MIB
mibfile /usr/share/snmp/mibs/MYSQL-MIB.txt
mibs +MYSQL-MIB
mibdirs /usr/share/snmp/mibs
mibs +ALL
<-- SNIP -->
My Start-Stop-Script
<-- SNIP -->
#!/bin/sh
# /etc/init.d/snmpd: start snmp daemon.
test -x /usr/sbin/snmpd || exit 0
#test -x /usr/sbin/snmptrapd || exit 0
LD_PRELOAD=libwrap.so.0.7.6
export LD_PRELOAD
# Defaults
export SNMP_PERSISTENT_FILE=/dev/null
export MIBDIRS=/usr/share/snmp/mibs
export MIBS="+SNMPv2-SMI +SNMPv2-TC +NET-SNMP-MIB +MYSQL-MIB +NET-SNMP-TUTORIAL-MIB +ALL"
SNMPDRUN=yes
SNMPDOPTS='-Ls DAEMON -Lf /var/log/snmpd.log -u root -p /var/run/snmpd.pid -x tcp:localhost:705 -c /etc/snmp/snmpd.conf'
TRAPDRUN=no
TRAPDOPTS='-Lsd -p /var/run/snmptrapd.pid'
# Reads config file (will override defaults above)
[ -r /etc/default/snmpd ] && . /etc/default/snmpd
AGENTDIR=/usr/lib/net-snmp/agents
# Cd to / before starting any daemons.
cd /
# Create compatibility link to old AgentX socket location
if [ "x$SNMPDCOMPAT" = "xyes" ]; then
ln -sf /var/agentx/master /var/run/agentx
fi
case "$1" in
start)
# echo -n "Starting SNMP AgentX services:"
# start-stop-daemon --quiet --start --exec $AGENTDIR/mysql_agent.pl
# echo "";
agents=""
agentargs="-x /var/run/agentx/master"
agentsInAGENTDIR=`ls /usr/lib/net-snmp/agents`
for agent in $agentsInAGENTDIR; do
test -x "/usr/lib/net-snmp/agents/$agent" || continue
echo -n "Starting AgentX:"
start-stop-daemon --quiet --start --exec /usr/lib/net-snmp/agents/$agent -- $agentsargs &
echo -n " $agent"
echo "."
done
echo -n "Starting network management services:"
if [ "x$SNMPDRUN" = "xyes" -a -f /etc/snmp/snmpd.conf ]; then
start-stop-daemon --quiet --start --exec /usr/sbin/snmpd \
-- $SNMPDOPTS
echo -n " snmpd"
fi
if [ "x$TRAPDRUN" = "xyes" -a -f /etc/snmp/snmptrapd.conf ]; then
start-stop-daemon --quiet --start --exec /usr/sbin/snmptrapd \
-- $TRAPDOPTS
echo -n " snmptrapd"
fi
echo "."
;;
stop)
echo -n "Stopping network management services:"
start-stop-daemon --quiet --stop --exec /usr/sbin/snmpd
echo -n " snmpd"
start-stop-daemon --quiet --stop --exec /usr/sbin/snmptrapd
echo -n " snmptrapd"
echo "."
agents=""
agentargs="-x /var/run/agentx/master"
agentsInAGENTDIR=`ls /usr/lib/net-snmp/agents`
for agent in $agentsInAGENTDIR; do
test -x "/usr/lib/net-snmp/agents/$agent" || continue
echo -n "Stopping AgentX:"
start-stop-daemon --quiet --stop --exec /usr/lib/net-snmp/agents/$agent \
echo -n " $agent"
echo "."
done;
;;
restart|reload|force-reload)
echo -n "Restarting network management services:"
start-stop-daemon --quiet --stop --exec /usr/sbin/snmpd
start-stop-daemon --quiet --stop --exec /usr/sbin/snmptrapd
agents=""
agentargs="-x /var/run/agentx/master"
agentsInAGENTDIR=`ls /usr/lib/net-snmp/agents`
for agent in $agentsInAGENTDIR; do
test -x "/usr/lib/net-snmp/agents/$agent" || continue
echo -n "Stopping AgentX:"
start-stop-daemon --quiet --stop --exec /usr/lib/net-snmp/agents/$agent \
echo -n " $agent"
echo "."
done
# Allow the daemons time to exit completely.
sleep 2
agents=""
agentargs="-x /var/run/agentx/master"
agentsInAGENTDIR=`ls /usr/lib/net-snmp/agents`
for agent in $agentsInAGENTDIR; do
test -x "/usr/lib/net-snmp/agents/$agent" || continue
echo -n "Starting AgentX:"
start-stop-daemon --quiet --start --exec /usr/lib/net-snmp/agents/$agent -- $agentsargs &
echo -n " $agent"
echo "."
done
if [ "x$SNMPDRUN" = "xyes" -a -f /etc/snmp/snmpd.conf ]; then
start-stop-daemon --quiet --start --exec /usr/sbin/snmpd -- $SNMPDOPTS
echo -n " snmpd"
fi
if [ "x$TRAPDRUN" = "xyes" -a -f /etc/snmp/snmptrapd.conf ]; then
# Allow snmpd time to start up.
sleep 1
start-stop-daemon --quiet --start --exec /usr/sbin/snmptrapd -- $TRAPDOPTS
echo -n " snmptrapd"
fi
echo "."
;;
*)
echo "Usage: /etc/init.d/snmpd {start|stop|restart|reload|force-reload}"
exit 1
esac
exit 0
<-- SNIP -->
My Subagent Perlscript
<-- SNIP -->
#!/usr/bin/perl --
use NetSNMP::OID (':all');
use NetSNMP::agent(':all');
use NetSNMP::ASN(':all');
use DBI;
my $dsn = "DBI:mysql:host=127.0.0.1;port=3306";
my $user = "root";
my $pass = "SK8Yyr9t";
# set to 1 to get extra debugging information
$debugging = 1;
$subagent = 0;
$refresh_interval = 30;
$global_status = ();
$global_last_refresh = 0;
###
### Called automatically now and then
### Refreshes the $global_status and $global_variables
### caches.
###
sub refresh_status {
my $now = time();
# Check if we have been called quicker than once every $refresh_interval
if (($now - $global_last_refresh) < $refresh_interval) {
# if yes, do not do anything
#print STDERR "Not refreshing\n" if ($debugging);
return;
}
# Connect database
my $dbh = DBI->connect($dsn, $user, $pass);
my $cmd = "show /*!50002 GLOBAL */ status";
# Get status info
my $sth = $dbh->prepare($cmd);
$sth->execute();
# 'status_data' becomes mysqlStatusData
my $oldname = "";
while (my $ref = $sth->fetchrow_hashref()) {
my $name = $ref->{'Variable_name'};
$name =~ s!_(.)!\U\1\E!g;
$name = "mysql$name";
$global_status{$name}{'value'} = $ref->{'Value'};
$global_status{$oldname}{'next'} = $name if ($oldname ne "");
$oldname = $name;
}
# No next for the last
$global_status{$name}{'next'} = '';
# Fixes
$global_status{'mysqlMIB'}{'value'} = "0";
$global_status{'mysqlMIB'}{'next'} = "mysqlMIBOBjects";
$global_status{'mysqlMIBObjects'}{'value'} = "0";
$global_status{'mysqlMIBObjects'}{'next'} = "mysqlStatus";
$global_status{'mysqlStatus'}{'value'} = "0";
$global_status{'mysqlStatus'}{'next'} = "mysqlAbortedClients";
$dbh->disconnect();
$global_last_refresh = $now;
#print STDERR "Refreshed at $now ", time()-$now, "\n" if ($debugging);
return;
}
my $regOID = new NetSNMP::OID("mysqlMIB");
if (!$agent) {
$agent = new NetSNMP::agent('Name' => 'mysql_snmp', # reads mysqlsnmp.conf
'AgentX' => 1); # make us a subagent
$subagent = 1;
#print STDERR "started us as a subagent ($agent)\n" if ($debugging);
}
$agent->register("mysql_snmp", $regOID, &mysql_snmp_handler);
if ($subagent) {
# We need to perform a loop here waiting for snmp requests. We
# also check for new STATUS data.
$SIG{'INT'} = &shut_it_down;
$SIG{'QUIT'} = &shut_it_down;
$running = 1;
while($running) {
refresh_status();
$agent->agent_check_and_process(1); # 1 = block
}
$agent->shutdown();
}
sub shut_it_down {
$running = 0;
#print STDERR "shutting down\n" if ($debugging);
}
sub mysql_snmp_handler {
my ($handler, $registration_info, $request_info, $requests ) = <at> _;
my ($request);
# print STDERR "refs: ",join(", ", ref($handler), ref($registration_info), ref($request_info), ref($requests)),"\n" if ($debugging);
for ($request = $requests; $request; $request = $request->next()) {
# Process request for $oid (e.g. mysqlUptime)
my $oid = $request->getOID();
my $mode = $request_info->getMode();
my $value;
my $next;
#print STDERR "- asking for oid $oid (mode $mode)\n" if ($debugging);
if ($mode == MODE_GET) {
$value = $global_status{$oid}{'value'};
$request->setValue(ASN_OCTET_STR, "$value");
#print STDERR " - GET handling ($oid = $value)\n" if ($debugging);
}
if ($mode == MODE_GETNEXT) {
$next = $global_status{$oid}{'next'};
if ($next ne "") {
$value = $global_status{$next}{'value'};
$request->setOID($next);
$request->setValue(ASN_OCTET_STR, "$value");
} else {
$request->setOID($oid);
}
#print STDERR " - GETNEXT handling ($oid: $next = $value)\n" if ($debugging);
}
}
#print STDERR "- finished processing\n" if ($debugging);
}
<-- SNIP -->
My MYSQL-MIB.txt file
<--SNIP -->
MYSQL-MIB DEFINITIONS ::= BEGIN
IMPORTS
MODULE-IDENTITY, OBJECT-TYPE
FROM SNMPv2-SMI
TEXTUAL-CONVENTION, DisplayString
FROM SNMPv2-TC
netSnmpPlaypen
FROM NET-SNMP-MIB;
mysqlMIB MODULE-IDENTITY
LAST-UPDATED "200704240000Z"
ORGANIZATION "Stefan Mikuszeit"
CONTACT-INFO
"WG-email: S DOT Mikuszeit AT syzygy DOT de"
DESCRIPTION
"MySQL SNMP table"
REVISION "200610270000Z"
DESCRIPTION
"This is a MySQL SNMP MIB File"
::= { netSnmpPlaypen 1767 }
mysqlMIBObjects OBJECT IDENTIFIER ::= { mysqlMIB 1 }
mysqlStatus OBJECT IDENTIFIER ::= { mysqlMIBObjects 1 }
mysqlAbortedClients OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlAbortedClients"
::= { mysqlStatus 1 }
mysqlAbortedConnects OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlAbortedConnects"
::= { mysqlStatus 2 }
mysqlBytesReceived OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlBytesReceived"
::= { mysqlStatus 3 }
mysqlBytesSent OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlBytesSent"
::= { mysqlStatus 4 }
mysqlComAdminCommands OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComAdminCommands"
::= { mysqlStatus 5 }
mysqlComAlterTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComAlterTable"
::= { mysqlStatus 6 }
mysqlComAnalyze OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComAnalyze"
::= { mysqlStatus 7 }
mysqlComBackupTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComBackupTable"
::= { mysqlStatus 8 }
mysqlComBegin OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComBegin"
::= { mysqlStatus 9 }
mysqlComChangeDb OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComChangeDb"
::= { mysqlStatus 10 }
mysqlComChangeMaster OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComChangeMaster"
::= { mysqlStatus 11 }
mysqlComCheck OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCheck"
::= { mysqlStatus 12 }
mysqlComCommit OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCommit"
::= { mysqlStatus 13 }
mysqlComCreateDb OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCreateDb"
::= { mysqlStatus 14 }
mysqlComCreateFunction OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCreateFunction"
::= { mysqlStatus 15 }
mysqlComCreateIndex OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCreateIndex"
::= { mysqlStatus 16 }
mysqlComCreateTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComCreateTable"
::= { mysqlStatus 17 }
mysqlComDelete OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDelete"
::= { mysqlStatus 18 }
mysqlComDeleteMulti OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDeleteMulti"
::= { mysqlStatus 19 }
mysqlComDropDb OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDropDb"
::= { mysqlStatus 20 }
mysqlComDropFunction OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDropFunction"
::= { mysqlStatus 21 }
mysqlComDropIndex OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDropIndex"
::= { mysqlStatus 22 }
mysqlComDropTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComDropTable"
::= { mysqlStatus 23 }
mysqlComFlush OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComFlush"
::= { mysqlStatus 24 }
mysqlComGrant OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComGrant"
::= { mysqlStatus 25 }
mysqlComHaClose OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComHaClose"
::= { mysqlStatus 26 }
mysqlComHaOpen OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComHaOpen"
::= { mysqlStatus 27 }
mysqlComHaRead OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComHaRead"
::= { mysqlStatus 28 }
mysqlComInsert OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComInsert"
::= { mysqlStatus 29 }
mysqlComInsertSelect OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComInsertSelect"
::= { mysqlStatus 30 }
mysqlComKill OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComKill"
::= { mysqlStatus 31 }
mysqlComLoad OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComLoad"
::= { mysqlStatus 32 }
mysqlComLoadMasterData OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComLoadMasterData"
::= { mysqlStatus 33 }
mysqlComLoadMasterTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComLoadMasterTable"
::= { mysqlStatus 34 }
mysqlComLockTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComLockTables"
::= { mysqlStatus 35 }
mysqlComOptimize OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComOptimize"
::= { mysqlStatus 36 }
mysqlComPurge OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComPurge"
::= { mysqlStatus 37 }
mysqlComRenameTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComRenameTable"
::= { mysqlStatus 38 }
mysqlComRepair OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComRepair"
::= { mysqlStatus 39 }
mysqlComReplace OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComReplace"
::= { mysqlStatus 40 }
mysqlComReplaceSelect OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComReplaceSelect"
::= { mysqlStatus 41 }
mysqlComReset OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComReset"
::= { mysqlStatus 42 }
mysqlComRestoreTable OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComRestoreTable"
::= { mysqlStatus 43 }
mysqlComRevoke OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComRevoke"
::= { mysqlStatus 44 }
mysqlComRollback OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComRollback"
::= { mysqlStatus 45 }
mysqlComSavepoint OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComSavepoint"
::= { mysqlStatus 46 }
mysqlComSelect OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComSelect"
::= { mysqlStatus 47 }
mysqlComSetOption OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComSetOption"
::= { mysqlStatus 48 }
mysqlComShowBinlogEvents OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowBinlogEvents"
::= { mysqlStatus 49 }
mysqlComShowBinlogs OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowBinlogs"
::= { mysqlStatus 50 }
mysqlComShowCreate OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowCreate"
::= { mysqlStatus 51 }
mysqlComShowDatabases OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowDatabases"
::= { mysqlStatus 52 }
mysqlComShowFields OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowFields"
::= { mysqlStatus 53 }
mysqlComShowGrants OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowGrants"
::= { mysqlStatus 54 }
mysqlComShowInnodbStatus OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowInnodbStatus"
::= { mysqlStatus 55 }
mysqlComShowKeys OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowKeys"
::= { mysqlStatus 56 }
mysqlComShowLogs OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowLogs"
::= { mysqlStatus 57 }
mysqlComShowMasterStatus OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowMasterStatus"
::= { mysqlStatus 58 }
mysqlComShowNewMaster OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowNewMaster"
::= { mysqlStatus 59 }
mysqlComShowOpenTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowOpenTables"
::= { mysqlStatus 60 }
mysqlComShowProcesslist OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowProcesslist"
::= { mysqlStatus 61 }
mysqlComShowSlaveHosts OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowSlaveHosts"
::= { mysqlStatus 62 }
mysqlComShowSlaveStatus OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowSlaveStatus"
::= { mysqlStatus 63 }
mysqlComShowStatus OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowStatus"
::= { mysqlStatus 64 }
mysqlComShowTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowTables"
::= { mysqlStatus 65 }
mysqlComShowVariables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComShowVariables"
::= { mysqlStatus 66 }
mysqlComSlaveStart OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComSlaveStart"
::= { mysqlStatus 67 }
mysqlComSlaveStop OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComSlaveStop"
::= { mysqlStatus 68 }
mysqlComTruncate OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComTruncate"
::= { mysqlStatus 69 }
mysqlComUnlockTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComUnlockTables"
::= { mysqlStatus 70 }
mysqlComUpdate OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComUpdate"
::= { mysqlStatus 71 }
mysqlComUpdateMulti OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlComUpdateMulti"
::= { mysqlStatus 72 }
mysqlConnections OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlConnections"
::= { mysqlStatus 73 }
mysqlCreatedTmpDiskTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlCreatedTmpDiskTables"
::= { mysqlStatus 74 }
mysqlCreatedTmpFiles OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlCreatedTmpFiles"
::= { mysqlStatus 75 }
mysqlCreatedTmpTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlCreatedTmpTables"
::= { mysqlStatus 76 }
mysqlDelayedErrors OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlDelayedErrors"
::= { mysqlStatus 77 }
mysqlDelayedInsertThreads OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlDelayedInsertThreads"
::= { mysqlStatus 78 }
mysqlDelayedWrites OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlDelayedWrites"
::= { mysqlStatus 79 }
mysqlFlushCommands OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlFlushCommands"
::= { mysqlStatus 80 }
mysqlHandlerCommit OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerCommit"
::= { mysqlStatus 81 }
mysqlHandlerDelete OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerDelete"
::= { mysqlStatus 82 }
mysqlHandlerReadFirst OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadFirst"
::= { mysqlStatus 83 }
mysqlHandlerReadKey OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadKey"
::= { mysqlStatus 84 }
mysqlHandlerReadNext OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadNext"
::= { mysqlStatus 85 }
mysqlHandlerReadPrev OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadPrev"
::= { mysqlStatus 86 }
mysqlHandlerReadRnd OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadRnd"
::= { mysqlStatus 87 }
mysqlHandlerReadRndNext OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerReadRndNext"
::= { mysqlStatus 88 }
mysqlHandlerRollback OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerRollback"
::= { mysqlStatus 89 }
mysqlHandlerUpdate OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerUpdate"
::= { mysqlStatus 90 }
mysqlHandlerWrite OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlHandlerWrite"
::= { mysqlStatus 91 }
mysqlKeyBlocksUsed OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlKeyBlocksUsed"
::= { mysqlStatus 92 }
mysqlKeyReadRequests OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlKeyReadRequests"
::= { mysqlStatus 93 }
mysqlKeyReads OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlKeyReads"
::= { mysqlStatus 94 }
mysqlKeyWriteRequests OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlKeyWriteRequests"
::= { mysqlStatus 95 }
mysqlKeyWrites OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlKeyWrites"
::= { mysqlStatus 96 }
mysqlMaxUsedConnections OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlMaxUsedConnections"
::= { mysqlStatus 97 }
mysqlNotFlushedDelayedRows OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlNotFlushedDelayedRows"
::= { mysqlStatus 98 }
mysqlNotFlushedKeyBlocks OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlNotFlushedKeyBlocks"
::= { mysqlStatus 99 }
mysqlOpenFiles OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlOpenFiles"
::= { mysqlStatus 100 }
mysqlOpenStreams OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlOpenStreams"
::= { mysqlStatus 101 }
mysqlOpenTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlOpenTables"
::= { mysqlStatus 102 }
mysqlOpenedTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlOpenedTables"
::= { mysqlStatus 103 }
mysqlQcacheFreeBlocks OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheFreeBlocks"
::= { mysqlStatus 104 }
mysqlQcacheFreeMemory OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheFreeMemory"
::= { mysqlStatus 105 }
mysqlQcacheHits OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheHits"
::= { mysqlStatus 106 }
mysqlQcacheInserts OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheInserts"
::= { mysqlStatus 107 }
mysqlQcacheLowmemPrunes OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheLowmemPrunes"
::= { mysqlStatus 108 }
mysqlQcacheNotCached OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheNotCached"
::= { mysqlStatus 109 }
mysqlQcacheQueriesInCache OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheQueriesInCache"
::= { mysqlStatus 110 }
mysqlQcacheTotalBlocks OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQcacheTotalBlocks"
::= { mysqlStatus 111 }
mysqlQuestions OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlQuestions"
::= { mysqlStatus 112 }
mysqlRplStatus OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlRplStatus"
::= { mysqlStatus 113 }
mysqlSelectFullJoin OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSelectFullJoin"
::= { mysqlStatus 114 }
mysqlSelectFullRangeJoin OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSelectFullRangeJoin"
::= { mysqlStatus 115 }
mysqlSelectRange OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSelectRange"
::= { mysqlStatus 116 }
mysqlSelectRangeCheck OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSelectRangeCheck"
::= { mysqlStatus 117 }
mysqlSelectScan OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSelectScan"
::= { mysqlStatus 118 }
mysqlSlaveOpenTempTables OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSlaveOpenTempTables"
::= { mysqlStatus 119 }
mysqlSlaveRunning OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSlaveRunning"
::= { mysqlStatus 120 }
mysqlSlowLaunchThreads OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSlowLaunchThreads"
::= { mysqlStatus 121 }
mysqlSlowQueries OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSlowQueries"
::= { mysqlStatus 122 }
mysqlSortMergePasses OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSortMergePasses"
::= { mysqlStatus 123 }
mysqlSortRange OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSortRange"
::= { mysqlStatus 124 }
mysqlSortRows OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSortRows"
::= { mysqlStatus 125 }
mysqlSortScan OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlSortScan"
::= { mysqlStatus 126 }
mysqlTableLocksImmediate OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlTableLocksImmediate"
::= { mysqlStatus 127 }
mysqlTableLocksWaited OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlTableLocksWaited"
::= { mysqlStatus 128 }
mysqlThreadsCached OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlThreadsCached"
::= { mysqlStatus 129 }
mysqlThreadsConnected OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlThreadsConnected"
::= { mysqlStatus 130 }
mysqlThreadsCreated OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlThreadsCreated"
::= { mysqlStatus 131 }
mysqlThreadsRunning OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlThreadsRunning"
::= { mysqlStatus 132 }
mysqlUptime OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-write
STATUS current
DESCRIPTION "MySQL SHOW STATUS LIKE mysqlUptime"
::= { mysqlStatus 133 }
END
<-- SNIP -->
My Loggings:
tcpdump -i lo -vvv
tcpdump: listening on lo, link-type EN10MB (Ethernet), capture size 96 bytes
14:36:39.778735 IP (tos 0x0, ttl 64, id 27644, offset 0, flags [DF], proto: TCP (6), length: 60) localhost.localdomain.47955 > localhost.localdomain.mysql: S, cksum 0xf52d (correct), 3259179356:3259179356(0) win 32767 <mss 16396,sackOK,timestamp 2751416992 0,nop,wscale 2>
14:36:39.778985 IP (tos 0x0, ttl 64, id 0, offset 0, flags [DF], proto: TCP (6), length: 60) localhost.localdomain.mysql > localhost.localdomain.47955: S, cksum 0x3152 (correct), 3256423185:3256423185(0) ack 3259179357 win 32767 <mss 16396,sackOK,timestamp 2751416992 2751416992,nop,wscale 2>
14:36:39.779013 IP (tos 0x0, ttl 64, id 27646, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.47955 > localhost.localdomain.mysql: ., cksum 0xfa70 (correct), 1:1(0) ack 1 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779185 IP (tos 0x8, ttl 64, id 22962, offset 0, flags [DF], proto: TCP (6), length: 95) localhost.localdomain.mysql > localhost.localdomain.47955: P 1:44(43) ack 1 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779273 IP (tos 0x8, ttl 64, id 27648, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.47955 > localhost.localdomain.mysql: ., cksum 0xfa45 (correct), 1:1(0) ack 44 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779355 IP (tos 0x8, ttl 64, id 27650, offset 0, flags [DF], proto: TCP (6), length: 74) localhost.localdomain.47955 > localhost.localdomain.mysql: P, cksum 0xfe3e (incorrect (-> 0xd5bd), 1:23(22) ack 44 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779417 IP (tos 0x8, ttl 64, id 22964, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.mysql > localhost.localdomain.47955: ., cksum 0xfa2f (correct), 44:44(0) ack 23 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779498 IP (tos 0x8, ttl 64, id 22966, offset 0, flags [DF], proto: TCP (6), length: 61) localhost.localdomain.mysql > localhost.localdomain.47955: P, cksum 0xfe31 (incorrect (-> 0xf51a), 44:53(9) ack 23 win 8192 <nop,nop,timestamp 2751416992 2751416992>
14:36:39.779657 IP (tos 0x8, ttl 64, id 27652, offset 0, flags [DF], proto: TCP (6), length: 73) localhost.localdomain.47955 > localhost.localdomain.mysql: P, cksum 0xfe3d (incorrect (-> 0xb9b4), 23:44(21) ack 53 win 8192 <nop,nop,timestamp 2751416993 2751416992>
14:36:39.779761 IP (tos 0x8, ttl 64, id 22968, offset 0, flags [DF], proto: TCP (6), length: 61) localhost.localdomain.mysql > localhost.localdomain.47955: P, cksum 0xfe31 (incorrect (-> 0xf4fb), 53:62(9) ack 44 win 8192 <nop,nop,timestamp 2751416993 2751416993>
14:36:39.779938 IP (tos 0x8, ttl 64, id 27654, offset 0, flags [DF], proto: TCP (6), length: 87) localhost.localdomain.47955 > localhost.localdomain.mysql: P 44:79(35) ack 62 win 8192 <nop,nop,timestamp 2751416993 2751416993>
14:36:39.780135 IP (tos 0x8, ttl 64, id 22970, offset 0, flags [DF], proto: TCP (6), length: 3330) localhost.localdomain.mysql > localhost.localdomain.47955: P 62:3340(3278) ack 79 win 8192 <nop,nop,timestamp 2751416993 2751416993>
14:36:39.785331 IP (tos 0x8, ttl 64, id 27656, offset 0, flags [DF], proto: TCP (6), length: 57) localhost.localdomain.47955 > localhost.localdomain.mysql: P, cksum 0xfe2d (incorrect (-> 0xdaa4), 79:84(5) ack 3340 win 12383 <nop,nop,timestamp 2751416998 2751416993>
14:36:39.785341 IP (tos 0x8, ttl 64, id 27658, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.47955 > localhost.localdomain.mysql: F, cksum 0xdcab (correct), 84:84(0) ack 3340 win 12383 <nop,nop,timestamp 2751416998 2751416993>
14:36:39.785428 IP (tos 0x8, ttl 64, id 22972, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.mysql > localhost.localdomain.47955: F, cksum 0xed04 (correct), 3340:3340(0) ack 85 win 8192 <nop,nop,timestamp 2751416998 2751416998>
14:36:39.785434 IP (tos 0x8, ttl 64, id 27660, offset 0, flags [DF], proto: TCP (6), length: 52) localhost.localdomain.47955 > localhost.localdomain.mysql: ., cksum 0xdca5 (correct), 85:85(0) ack 3341 win 12383 <nop,nop,timestamp 2751416998 2751416998>
Errors at snmpset
root <at> HOM21DB:~# snmpset -c public -v2c localhost mysqlMIB.1 s test
Error in packet.
Reason: notWritable (That object does not support modification)
Failed object: MYSQL-MIB::mysqlMIBObjects
root <at> HOM21DB:~# snmpset -c public -v2c localhost mysqlMIB.mysqlMIBObjects s test
Error in packet.
Reason: notWritable (That object does not support modification)
Failed object: MYSQL-MIB::mysqlMIBObjects
root <at> HOM21DB:~# snmpset -c public -v2c localhost mysqlMIBObjects s test
Error in packet.
Reason: notWritable (That object does not support modification)
Failed object: MYSQL-MIB::mysqlMIBObjects
root <at> HOM21DB:~# snmpset -c public -v2c localhost mysqlMIBObjects.1 s test
Error in packet.
Reason: notWritable (That object does not support modification)
Failed object: MYSQL-MIB::mysqlStatus
root <at> HOM21DB:~# snmpset -c private -v2c localhost mysqlStatus s 1
Error in packet.
Reason: notWritable (That object does not support modification)
Failed object: MYSQL-MIB::mysqlStatus
Regards
Stefan
Stefan Mikuszeit
System Administrator
Tel: +49 (0)6172 9488-124
Fax: +49 (0)6172 9488-270
ISDN: +49 (0)6172 9488-281
mailto:s.mikuszeit <at> syzygy.net
http://www.syzygy.de
-------------------------------
Syzygy Deutschland GmbH
Im Atzelnest 3
D-61352 Bad Homburg
Geschäftsführer:
Prof. Wolfgang Henseler
Marco Seiler
Frank Wolfram
Registergericht Bad Homburg HRB 6009
Sitz der Gesellschaft ist Bad Homburg
------------------------------
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, dann informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
RSS Feed