Changes between Version 127 and Version 128 of ESGFNodeInstallation


Ignore:
Timestamp:
Aug 5, 2014 12:50:02 PM (7 years ago)
Author:
terryk
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ESGFNodeInstallation

    v127 v128  
    457457[[NoteBox(note, The procedure (including all the queries) is reported in the [attachment:is-enes2_statistics.txt] file )]]
    458458
    459 
    460 1) Create a 'stats' directory
    461    {{{
    462    #!sh
    463    $ cd stats
    464    }}}
    465 
    466 1.1)
    467    {{{
    468    #!sh
    469    $ psql esgcet -U dbsuper -c "select distinct remote_addr from esgf_node_manager.access_logging" > ip_addresses.txt
    470    }}}
    471 
    472 1.2) Open the file ip_addresses.txt and cleanup the first two rows and the last one at the end of the file
     4591) Create a 'stats' directory (if not exists)
     460{{{
     461#!sh
     462$ mkdir stats
     463$ cd stats
     464}}}
     4651.1.
     466{{{
     467#!sh
     468$ psql esgcet -U dbsuper -c "select distinct remote_addr from esgf_node_manager.access_logging" > ip_addresses.txt
     469}}}
     4701.2. Open the file ip_addresses.txt and cleanup the first two rows and the last one at the end of the file
    473471
    4744722)
     
    478476}}}
    479477
    480 3) Creation of a support table in the esgf_dashboard namespace
    481 3.1)
     4783) Creation of a support table in the esgf_dashboard namespace [[BR]]
     4793.1.
    482480{{{
    483481#!sh
    484482$ psql esgcet -U dbsuper -c "drop table esgf_dashboard.stats_support_table;"
    485483}}}
    486 
    487 3.2)
     4843.2.
    488485{{{
    489486#!sh
     
    5175148) Execute query stats:
    518515   
    519    Generate a query_stats_[NUMBER].sql for each statistics queries in attachment:is-enes2_statistics.txt and execute:
    520 
    521    {{{
    522    #!sh
    523    $ psql esgcet -U dbsuper -e < query_stats_1.sql > query_stats_1.result
    524    }}}
     516Generate a query_stats_[NUMBER].sql for each statistics queries in [attachment:is-enes2_statistics.txt] and execute:
     517
     518{{{
     519#!sh
     520$ psql esgcet -U dbsuper -e < query_stats_1.sql > query_stats_1.result
     521}}}
    525522
    5265239) Generate a zip