search

inex / IXP-Manager

Full stack web application powering peering at over 200 Internet Exchange Points (IXPs) globally.
https://www.ixpmanager.org/
GNU General Public License v2.0
377 stars 161 forks source link

Search results have incorrect member IDs in listing #724

Closed digitalandrei closed 3 years ago

digitalandrei commented 3 years ago
ISSUE TYPE

Bug Report

OS

Ubuntu 20.04

VERSION
define( 'APPLICATION_VERSION', '6.0.0' );
define( 'APPLICATION_VERDATE', '2021071400' );
ENVIRONMENT
# php -v
PHP 8.0.8 (cli) (built: Jul  1 2021 15:26:46) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.8, Copyright (c) Zend Technologies
    with Zend OPcache v8.0.8, Copyright (c), by Zend Technologies

# dpkg -l | grep php
ii  libapache2-mod-php8.0                  8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        server-side, HTML-embedded scripting language (Apache 2 module)
ii  php-common                             2:80~exp2+ubuntu16.04.1+deb.sury.org+1                              all          Common files for PHP packages
ii  php-composer-ca-bundle                 1.2.6-1                                                             all          utility library to find a path to the system CA bundle
ii  php-composer-semver                    1.5.1-1                                                             all          utilities, version constraint parsing and validation
ii  php-composer-spdx-licenses             1.5.3-1                                                             all          SPDX licenses list and validation library
ii  php-composer-xdebug-handler            1.4.0-1                                                             all          Restarts a process without Xdebug
ii  php-ds                                 1.3.0-6+ubuntu20.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php-gettext                            1.0.12-0.1                                                          all          transitional dummy package for php-php-gettext
ii  php-json-schema                        5.2.9-1                                                             all          implementation of JSON schema
ii  php-memcache                           8.0+4.0.5.2+3.0.9~20170802.e702b5f9+-1+ubuntu20.04.1+deb.sury.org+2 amd64        memcache extension module for PHP
ii  php-memcached                          3.1.5+2.2.0-9+ubuntu20.04.1+deb.sury.org+1                          amd64        memcached extension module for PHP, uses libmemcached
ii  php-pear                               1:1.10.12+submodules+notgz-1+ubuntu16.04.1+deb.sury.org+1           all          PEAR Base System
ii  php-php-gettext                        1.0.12-0.1                                                          all          read gettext MO files directly, without requiring anything other than PHP
ii  php-psr-container                      1.0.0-2                                                             all          Common Container Interface (PHP FIG PSR-11)
ii  php-psr-log                            1.1.2-1                                                             all          common interface for logging libraries
ii  php-rrd                                2.0.1+1.1.3-14+ubuntu20.04.1+deb.sury.org+1                         amd64        PHP bindings to rrd tool system
ii  php-symfony-console                    4.3.8+dfsg-1ubuntu1                                                 all          run tasks from the command line
ii  php-symfony-filesystem                 4.3.8+dfsg-1ubuntu1                                                 all          basic filesystem utilities
ii  php-symfony-finder                     4.3.8+dfsg-1ubuntu1                                                 all          find files and directories
ii  php-symfony-process                    4.3.8+dfsg-1ubuntu1                                                 all          execute commands in sub-processes
ii  php-symfony-service-contracts          1.1.8-1                                                             all          Generic abstractions related to writing services
ii  php-yaml                               2.2.1+2.1.0+2.0.4+1.3.2-6+ubuntu20.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php5.6-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php5.6-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9-1+ubuntu16.04.1+deb.sury.org+1  amd64        memcache extension module for PHP
ii  php5.6-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php5.6-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php5.6-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php5.6-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php7.0-ds                              1.3.0-1+ubuntu16.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php7.0-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php7.0-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9-1+ubuntu16.04.1+deb.sury.org+1  amd64        memcache extension module for PHP
ii  php7.0-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php7.0-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php7.0-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php7.0-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php7.1-ds                              1.3.0-1+ubuntu16.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php7.1-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php7.1-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9-1+ubuntu16.04.1+deb.sury.org+1  amd64        memcache extension module for PHP
ii  php7.1-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php7.1-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php7.1-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php7.1-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php7.2-ds                              1.3.0-1+ubuntu16.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php7.2-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php7.2-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9-1+ubuntu16.04.1+deb.sury.org+1  amd64        memcache extension module for PHP
ii  php7.2-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php7.2-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php7.2-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php7.2-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php7.4-ds                              1.3.0-1+ubuntu16.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php7.4-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php7.4-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9-1+ubuntu16.04.1+deb.sury.org+1  amd64        memcache extension module for PHP
ii  php7.4-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php7.4-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php7.4-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php7.4-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php8.0                                 8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                all          server-side, HTML-embedded scripting language (metapackage)
ii  php8.0-bcmath                          8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Bcmath module for PHP
ii  php8.0-cgi                             8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        server-side, HTML-embedded scripting language (CGI binary)
ii  php8.0-cli                             8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        command-line interpreter for the PHP scripting language
ii  php8.0-common                          8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        documentation, examples and common module for PHP
ii  php8.0-curl                            8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        CURL module for PHP
ii  php8.0-ds                              1.3.0-1+ubuntu16.04.1+deb.sury.org+1                                amd64        PHP extension providing efficient data structures for PHP 7
ii  php8.0-gd                              8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        GD module for PHP
ii  php8.0-igbinary                        3.2.1+2.0.8-1+ubuntu16.04.1+deb.sury.org+1                          amd64        igbinary PHP serializer
ii  php8.0-intl                            8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Internationalisation module for PHP
ii  php8.0-mbstring                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        MBSTRING module for PHP
ii  php8.0-memcache                        8.0+4.0.5.2+3.0.9~20170802.e702b5f9+-1+ubuntu20.04.1+deb.sury.org+2 amd64        memcache extension module for PHP
ii  php8.0-memcached                       3.1.5+2.2.0-4+ubuntu16.04.1+deb.sury.org+4                          amd64        memcached extension module for PHP, uses libmemcached
ii  php8.0-msgpack                         2.1.2+0.5.7-1+ubuntu16.04.1+deb.sury.org+1                          amd64        PHP extension for interfacing with MessagePack
ii  php8.0-mysql                           8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        MySQL module for PHP
ii  php8.0-opcache                         8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Zend OpCache module for PHP
ii  php8.0-readline                        8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        readline module for PHP
ii  php8.0-rrd                             2.0.1+1.1.3-9+ubuntu16.04.1+deb.sury.org+4                          amd64        PHP bindings to rrd tool system
ii  php8.0-snmp                            8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        SNMP module for PHP
ii  php8.0-xml                             8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        DOM, SimpleXML, XML, and XSL module for PHP
ii  php8.0-yaml                            2.2.1+2.1.0+2.0.4+1.3.2-1+ubuntu16.04.1+deb.sury.org+1              amd64        YAML-1.1 parser and emitter for PHP
ii  php8.0-zip                             8.0.8-1+ubuntu20.04.1+deb.sury.org+1                                amd64        Zip module for PHP
CONFIGURATION
APP_DEBUG=false
APP_URL="https://ixpm...."
APP_TIMEZONE="Europe/Bucharest"
APP_LOG="single"
APP_LOG_LEVEL=info
IXP_RESELLER_ENABLED=true
IXP_AS112_UI_ACTIVE=true
IXP_FE_FRONTEND_DISABLED_LOGO=false
IXP_FE_FRONTEND_DISABLED_PEERING_MATRIX=false
GRAPHER_BACKENDS="mrtg|sflow|smokeping"
GRAPHER_CACHE_ENABLED=true
GRAPHER_BACKEND_MRTG_DBTYPE="rrd"
GRAPHER_BACKEND_MRTG_WORKDIR="/srv/mrtg"
GRAPHER_BACKEND_MRTG_LOGDIR="/srv/mrtg"
GRAPHER_BACKEND_SFLOW_ENABLED=true
GRAPHER_BACKEND_SFLOW_ROOT="http://sflow.../grapher-sflow"
GRAPHER_BACKEND_SMOKEPING_ENABLED=true
GRAPHER_BACKEND_SMOKEPING_URL="https://smokeping.../smokeping"
IXP_API_JSONEXPORTSCHEMA_PUBLIC=true
VIEW_SKIN=".."
CACHE_DRIVER=memcached
SESSION_LIFETIME=120
SESSION_DRIVER=file
DOCTRINE_PROXY_AUTOGENERATE=false
DOCTRINE_CACHE=memcached
DOCTRINE_CACHE_NAMESPACE=IXPMANAGERNAMESPACE
IXP_IRRDB_BGPQ3_PATH=/usr/bin/bgpq3
IXP_RPKI_RTR1_HOST=..
IXP_RPKI_RTR1_PORT=..
IXP_FE_FRONTEND_DISABLED_LOOKING_GLASS=false
LOOKING_GLASS_ENABLED=true
IXP_FE_CUSTOMER_DETAILS_PUBLIC=true
GRAPHER_ACCESS_IXP=0
GRAPHER_ACCESS_INFRASTRUCTURE=1
GRAPHER_ACCESS_SWITCH=1
GRAPHER_ACCESS_TRUNK=1
GRAPHER_ACCESS_VLAN=1
GRAPHER_ACCESS_CUSTOMER="1"
GRAPHER_ACCESS_P2P="own_graphs_only"
GRAPHER_ACCESS_LATENCY="own_graphs_only"
GRAPHER_CLI_TRAFFICDAILY_DELETE_OLD_DAYS="730"
AUTH_PEERINGDB_ENABLED=true
PEERINGDB_OAUTH_CLIENT_ID=".."
PEERINGDB_OAUTH_CLIENT_SECRET=".."
PEERINGDB_OAUTH_REDIRECT="https://ixpm.../auth/login/peeringdb/callback"
IXP_API_JSONEXPORTSCHEMA_EXCLUDE_SWITCH="model|software"
SUMMARY

When using the search box (top left, admin page), the listing that results afterwards has incorrect member IDs when hovering over the tabs that appear for each result (Overview, Ports, etc).

Additional info: IXP Manager was upgraded from 5.8.0 to 6.0.0, and also the OS from Ubuntu 16.04 to 18.04 to 20.04.

STEPS TO REPRODUCE
  1. Login as a superuser.
  2. Use the search box in the top left to wildcard search for a member name that exists.
EXPECTED RESULTS

Correct member IDs to be set in the result list.

ACTUAL RESULTS

Notice that the IDs (ex: https://ixpm..../customer/overview/XX - the XX ID is wrong) are different from the real member IDs.

IMPORTANCE

You can't reliably use the search box. Looking for members must be done from Members menu or from Jump to member.

RELEVANT LOGS

No errors appear.

nickhilliard commented 3 years ago

thx @digitalandrei, we noticed this already and have an internal issue open on it (https://github.com/islandbridgenetworks/IXP-Manager/issues/273).

digitalandrei commented 3 years ago

Thank you Nick. Just as an additional note, as it might be related: after opening a member page and trying to click on the magnifying glass on the right side, for "Aggregate Traffic Statistics”, it also returns a different member’s statistics page (https://ixpm.../statistics/member?id= https://ixpm.../statistics/member?id=XX), even though XX ID is correct.

Andrei DINU Technical Manager Digital IT Consulting

Mobile: Fax: Web:

+40 728 777 794 +40 314 050 150 http://www.digitalit.ro http://www.digitalit.ro/

Privileged/Confidential information may be contained in this message. If you are not in the addresses indicated in this message or responsible for delivery of the message to such person you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail.

On 3 Aug 2021, at 14:46, Nick Hilliard @.***> wrote:

thx @digitalandrei https://github.com/digitalandrei, we noticed this already and have an internal issue open on it (islandbridgenetworks/IXP-Manager#273 https://github.com/islandbridgenetworks/IXP-Manager/issues/273).

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/inex/IXP-Manager/issues/724#issuecomment-891779731, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIC3EWKB2FIJNS5CVGLBLDLT27JI7ANCNFSM5BORUB7A. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.

nickhilliard commented 3 years ago

Probably not the same. Can you open up an issue about this? Also, can you restart memcached and see if that resolves the problem?

digitalandrei commented 3 years ago

I’ll open an issue. I did restart memcached service and it behaves the same.

Andrei DINU Technical Manager Digital IT Consulting

Mobile: Fax: Web:

+40 728 777 794 +40 314 050 150 http://www.digitalit.ro http://www.digitalit.ro/

Privileged/Confidential information may be contained in this message. If you are not in the addresses indicated in this message or responsible for delivery of the message to such person you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail.

On 3 Aug 2021, at 14:56, Nick Hilliard @.***> wrote:

Probably not the same. Can you open up an issue about this? Also, can you restart memcached and see if that resolves the problem?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/inex/IXP-Manager/issues/724#issuecomment-891785960, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIC3EWM5BEKGE3QRUDSXWKDT27KO7ANCNFSM5BORUB7A. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.