sábado, 24 de julio de 2021

Solución: GNS3 - Private Vlan - non-operational - Cisco

Situación:

  En resumen: no te funcionan las private VLAN en GNS3 (IOU - VIRL).


Solución:

  Utiliza IOU i86bi-linux-l2-adventerprisek9-15.2d.bin


Test:

IOU3#show vlan private-vlan 


Primary Secondary Type              Ports

------- --------- ----------------- ------------------------------------------

500     501       community         Et0/1, Et0/2, Et1/0

500     502       isolated          Et0/0, Et0/3, Et1/0


Suerte!,



jueves, 1 de julio de 2021

Super sencillo script en python3 para optimizar las tablas de MYSQL

#!/usr/bin/python3.3

#The objetive of this script is to find all tables in a MYSQL DB and opmitize all of them

import dbconnect

import time

from datetime import datetime



## // VARIABLE DECLARATION ##//

startTime = datetime.now()

conn = dbconnect.dbconnect()

conn.autocommit(True)

cur = conn.cursor()


print ("Starting time: ", startTime)


SQLQUERY=("SHOW TABLES") #Find every table in the DB

cur.execute(SQLQUERY)

tables = cur.fetchall()



if len(tables)>0: #Prevent there are not tables in the list

  for table in tables:  #For every table in the DB

    try:

      SQLQUERY="OPTIMIZE TABLE "+ table[0]  #Construct the SQL QUERY

      print ("   Optimizing", table[0])

      cur.execute(SQLQUERY)

    except:

      pass


print ("Script execution time:",datetime.now()-startTime)

print ("Ending time: ", datetime.now())

print ("******** ****** ")

Solución: GNS3 - Private Vlan - non-operational - Cisco

Situación:   En resumen: no te funcionan las private VLAN en GNS3 (IOU - VIRL). Solución:   Utiliza IOU i86bi-linux-l2-adventerprisek9-15.2d...