- librenms@librenms:~$ mysql -u librenms -p
- Enter password:
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 45871
- Server version: 10.3.25-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04
- Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> use librenms;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- MariaDB [librenms]> select * from ports where device_id = 97;
- +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
- | port_id | device_id | port_descr_type | port_descr_descr | port_descr_circuit | port_descr_speed | port_descr_notes | ifDescr | ifName | portName | ifIndex | ifSpeed | ifSpeed_prev | ifConnectorPresent | ifPromiscuousMode | ifHighSpeed | ifHighSpeed_prev | ifOperStatus | ifOperStatus_prev | ifAdminStatus | ifAdminStatus_prev | ifDuplex | ifMtu | ifType | ifAlias | ifPhysAddress | ifHardType | ifLastChange | ifVlan | ifTrunk | ifVrf | counter_in | counter_out | ignore | disabled | detailed | deleted | pagpOperationMode | pagpPortState | pagpPartnerDeviceId | pagpPartnerLearnMethod | pagpPartnerIfIndex | pagpPartnerGroupIfIndex | pagpPartnerDeviceName | pagpEthcOperationMode | pagpDeviceId | pagpGroupIfIndex | ifInUcastPkts | ifInUcastPkts_prev | ifInUcastPkts_delta | ifInUcastPkts_rate | ifOutUcastPkts | ifOutUcastPkts_prev | ifOutUcastPkts_delta | ifOutUcastPkts_rate | ifInErrors | ifInErrors_prev | ifInErrors_delta | ifInErrors_rate | ifOutErrors | ifOutErrors_prev | ifOutErrors_delta | ifOutErrors_rate | ifInOctets | ifInOctets_prev | ifInOctets_delta | ifInOctets_rate | ifOutOctets | ifOutOctets_prev | ifOutOctets_delta | ifOutOctets_rate | poll_time | poll_prev | poll_period |
- +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
- | 16588 | 97 | NULL | NULL | NULL | NULL | NULL | lo | lo | NULL | 1 | 10000000 | 10000000 | false | false | 10 | 10 | up | up | up | up | NULL | 65536 | softwareLoopback | lo | NULL | NULL | 0 | | NULL | 0 | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 100 | 100 | 0 | 0 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9078 | 9078 | 0 | 0 | 9078 | 9078 | 0 | 0 | 1604511721 | 1604511653 | 68 |
- +---------+-----------+-----------------+------------------+--------------------+------------------+------------------+---------+--------+----------+---------+----------+--------------+--------------------+-------------------+-------------+------------------+--------------+-------------------+---------------+--------------------+----------+-------+------------------+---------+---------------+------------+--------------+--------+---------+-------+------------+-------------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+---------------+--------------------+---------------------+--------------------+----------------+---------------------+----------------------+---------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+-----------------+------------------+-----------------+-------------+------------------+-------------------+------------------+------------+------------+-------------+
- 1 row in set (0.001 sec)
mysql log
From bumbo, 4 Years ago, written in Plain Text.
Embed