Page History

...

Saqib plans to get 2-3 undergraduate students in a month or so and plans to look at Android PingER.

SLAC

• The new version of Linux CentOS7, does not appear to support the following modules that are used by the PingER analysis.
  
  • The Oracle database interface. PingER uses Oracle so there could be a problem. 
    
  • The perl statistics module
  • I will restrict the PingER analysis jobs to the earlier version of Linux (RHEL6) to avoid these problems. I am working with the systems folks at SLAC and looking into when the current version of Linux at SLAC (RHEL6) will no longer be supported and following SLAC's planning on how or whether to address the issues.
    • Rhel6 has full support until Nov 30, 2020. It then goes on "extended" support until June 2024. I expect SLAC will continue to use it during the extended support phase, at least for a couple of years.
    • Umar did some research and found:
      • I did a cursory search and it appears that in addition to having the Oracle database server, we would also need the items listed at the bottom. 
        If I were to test, I'd consider setting up a VirtualBox VM on my laptop and install CentOS7, Oracle database, instant client, Perl, and Perl driver for Oracle and test in the VM. I also searched to see if I could find some reference of "Oracle driver not available for CentOS7", but I couldn't find any. 
        I would recommend testing in an isolated VM so that we don't break the existing setup.
        1) Oracle instant client
        https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
        2) Oracle DBD - last updated in 7/2019
        https://metacpan.org/pod/DBD::Oracle
        https://metacpan.org/source/MJEVANS/DBD-Oracle-1.80/README
        Here is a good breakdown that explains the relevant pieces (ignore the references to MySQL here). With testing we'll be sure what works and what doesn't.
        https://stackoverflow.com/questions/1958069/what-is-the-difference-between-dbi-and-dbd
        May be I am missing something, but I do not understand why there won't be a perl driver for Oracle on CentOS7.

Umar 

State of MAs.

• Bebo posed the question of whether PingER can identify changes in Internet responsiveness as measured by PingER as a result of the impact of the Covid-19 virus.
• The first attempts looking et PingER statistics and see if there were any noticeable changes in performance attributable to Covid-19 interventions (e.g. shutting down schools,  social distancing, gathering cancellations, lockdowns), were not very successful (see PingER and COVID-19). See https://covid19-interventions.com/ for interventions in European, and some Asian countries.
• Another attempt to correlate the impacts might be to use a tool such as Google Motion Charts to look for correlations between say Covid-19 cases (cases, hospital admissions, deaths etc) and PingER metrics as a function of time, by country, continent, plus population or density of population. Unfortunately Google Motion metrics relies on Flash and is no longer supported .
  • A possible alternative is Charta.ca
  • I have therefore put together a Perl script (chart-covid.pl) to take daily PingER metrics for the last 120 days together with up-to-date raw data on the coronavirus from Johns Hopkins from their GitHub site: https://github.com/CSSEGISandData/COVID-19, for various countries with their population, area, population density and cast the data in a format suitable for Charta.ca.

Umar 

State of MAs.

Next Meeting

Next meeting:  There will be a Doodle poll, for  2020 at 9 pm Pacific time; a day later 9:00 am Pakistan time; 9:30 am India time; 12:00 pm Malaysian & Guangzhou time;  1:00 pm Thailand time; 6:00 am Jordan time. 5:00am Turkey time.  

...

Next Meeting

Next meeting:  There will be a Doodle poll, for  2020 at 9 pm Pacific time; a day later 9:00 am Pakistan time; 9:30 am India time; 12:00 pm Malaysian & Guangzhou time;  1:00 pm Thailand time; 6:00 am Jordan time. 5:00am Turkey time.  

...

Old information

SLAC moved here 4/13/2020.

The new version of Linux CentOS7, does not appear to support the following modules that are used by the PingER analysis.

• The Oracle database interface. PingER uses Oracle so there could be a problem. 
  
• The perl statistics module
• I will restrict the PingER analysis jobs to the earlier version of Linux (RHEL6) to avoid these problems. I am working with the systems folks at SLAC and looking into when the current version of Linux at SLAC (RHEL6) will no longer be supported and following SLAC's planning on how or whether to address the issues.
  • Rhel6 has full support until Nov 30, 2020. It then goes on "extended" support until June 2024. I expect SLAC will continue to use it during the extended support phase, at least for a couple of years.
  • Umar did some research and found:
    • I did a cursory search and it appears that in addition to having the Oracle database server, we would also need the items listed at the bottom. 
      If I were to test, I'd consider setting up a VirtualBox VM on my laptop and install CentOS7, Oracle database, instant client, Perl, and Perl driver for Oracle and test in the VM. I also searched to see if I could find some reference of "Oracle driver not available for CentOS7", but I couldn't find any. 
      I would recommend testing in an isolated VM so that we don't break the existing setup.
      1) Oracle instant client
      https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
      2) Oracle DBD - last updated in 7/2019
      https://metacpan.org/pod/DBD::Oracle
      https://metacpan.org/source/MJEVANS/DBD-Oracle-1.80/README
      Here is a good breakdown that explains the relevant pieces (ignore the references to MySQL here). With testing we'll be sure what works and what doesn't.
      https://stackoverflow.com/questions/1958069/what-is-the-difference-between-dbi-and-dbd
      May be I am missing something, but I do not understand why there won't be a perl driver for Oracle on CentOS7.

Umar moved here 1/10/2020

...