Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.




log into MariaDB
librenms@librenms:~$ mysql -u librenms -p    
Enter password: [ default password with this ova file: D42nf23rewD ]
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 298
Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.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)]>
list the databases
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| librenms |
+--------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]>
use a databaselist 
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]>
show tables


Code Block
titleshow tables
collapsetrue
MariaDB [librenms]> show tables
    -> ;
+---------------------------+
| Tables_in_librenms        |
+---------------------------+
| access_points             |
| alert_device_map          |
| alert_group_map           |
| alert_location_map        |
| alert_log                 |
| alert_rules               |
| alert_schedulables        |
| alert_schedule            |
| alert_template_map        |
| alert_templates           |
| alert_transport_groups    |
| alert_transport_map       |
| alert_transports          |
| alerts                    |
| api_tokens                |
| application_metrics       |
| applications              |
| authlog                   |
| bgpPeers                  |
| bgpPeers_cbgp             |
| bill_data                 |
| bill_history              |
| bill_perms                |
| bill_port_counters        |
| bill_ports                |
| bills                     |
| callback                  |
| cef_switching             |
| ciscoASA                  |
| component                 |
| component_prefs           |
| component_statuslog       |
| config                    |
| customers                 |
| customoids                |
| dashboards                |
| dbSchema                  |
| device_graphs             |
| device_group_device       |
| device_groups             |
| device_mibs               |
| device_oids               |
| device_perf               |
| device_relationships      |
| devices                   |
| devices_attribs           |
| devices_group_perms       |
| devices_perms             |
| entPhysical               |
| entPhysical_state         |
| entityState               |
| eventlog                  |
| graph_types               |
| hrDevice                  |
| ipsec_tunnels             |
| ipv4_addresses            |
| ipv4_mac                  |
| ipv4_networks             |
| ipv6_addresses            |
| ipv6_networks             |
| juniAtmVp                 |
| links                     |
| loadbalancer_rservers     |
| loadbalancer_vservers     |
| locations                 |
| mac_accounting            |
| mefinfo                   |
| mempools                  |
| mibdefs                   |
| migrations                |
| mpls_lsp_paths            |
| mpls_lsps                 |
| mpls_saps                 |
| mpls_sdp_binds            |
| mpls_sdps                 |
| mpls_services             |
| mpls_tunnel_ar_hops       |
| mpls_tunnel_c_hops        |
| munin_plugins             |
| munin_plugins_ds          |
| netscaler_vservers        |
| notifications             |
| notifications_attribs     |
| ospf_areas                |
| ospf_instances            |
| ospf_nbrs                 |
| ospf_ports                |
| packages                  |
| pdb_ix                    |
| pdb_ix_peers              |
| perf_times                |
| plugins                   |
| poller_cluster            |
| poller_cluster_stats      |
| poller_groups             |
| pollers                   |
| ports                     |
| ports_adsl                |
| ports_fdb                 |
| ports_nac                 |
| ports_perms               |
| ports_stack               |
| ports_statistics          |
| ports_stp                 |
| ports_vlans               |
| processes                 |
| processors                |
| proxmox                   |
| proxmox_ports             |
| pseudowires               |
| route                     |
| sensors                   |
| sensors_to_state_indexes  |
| services                  |
| session                   |
| slas                      |
| state_indexes             |
| state_translations        |
| storage                   |
| stp                       |
| syslog                    |
| tnmsneinfo                |
| toner                     |
| transport_group_transport |
| ucd_diskio                |
| users                     |
| users_prefs               |
| users_widgets             |
| vlans                     |
| vminfo                    |
| vrf_lite_cisco            |
| vrfs                      |
| widgets                   |
| wireless_sensors          |
+---------------------------+
134 rows in set (0.00 sec)

MariaDB [librenms]>