Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-1073

ERROR 1364 (HY000): Field 'bgpPeerState' doesn't have a default value

    XMLWordPrintable

Details

    • Bug
    • Resolution: Incomplete
    • Major
    • None
    • None
    • Discovery
    • Linux, Configured Observium for Juniper MX10 devices

    Description

      My BGP tab does not come up on its own. I populated the mysql bgpPeers table manually and then it was populated because of which the BGP tabs showed up. Also encountered 2 errors :

      mysql> INSERT INTO `bgpPeers` (`device_id`,`bgpPeerIdentifier`,`bgpPeerRemoteAddr`,`bgpPeerLocalAddr`,`bgpPeerRemoteAS`,`astext`,`reverse_dns`) VALUES ('8','10.10.11.3 ','10.10.11.3','10.10.11.5','100','FMC-CTC - FMC Central Engineering Laboratories,US','');
      ERROR 1364 (HY000): Field 'bgpPeerState' doesn't have a default value
      mysql> INSERT INTO `bgpPeers` (`device_id`,`bgpPeerIdentifier`,`bgpPeerRemoteAddr`,`bgpPeerLocalAddr`,`bgpPeerRemoteAS`,`astext`,`reverse_dns`,`bgpPeerState`) VALUES ( '8','10.10.11.3','10.10.11.3','10.10.11.5','100','FMC-CTC - FMC Central Engineering Laboratories,US','','UP');
      ERROR 1364 (HY000): Field 'bgpPeerAdminStatus' doesn't have a default value

      Attachments

        Activity

          People

            adama Adam Armstrong
            manjiri.kurutkar@serro.com Manjiri Kurutkar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: