hours, status changed; resolution, totalhours set

chris — Thu, 02 Mar 2017 19:08:38 GMT

hours changed from 0 to 0.25
status changed from new to closed
resolution set to fixed
totalhours set to 0.25

sudo -i
cd /var/www
vi piwik/config/config.ini.php
export PIWIK="3.0.2"
wget "https://builds.piwik.org/piwik-$PIWIK.tar.gz"
wget "https://builds.piwik.org/piwik-$PIWIK.tar.gz.asc"
gpg --verify piwik-$PIWIK.tar.gz.asc
cp piwik/config/config.ini.php .
tar -zxvf piwik-$PIWIK.tar.gz
cp config.ini.php piwik/config/
chown -R piwik:piwik /var/www/piwik/
php /var/www/piwik/console core:update
vi piwik/config/config.ini.php

Checking the web intrerface and it now lists files to be deleted and provides the needed command:

rm "/var/www/piwik/libs/jquery/jquery.smartbanner.js" "/var/www/piwik/libs/jquery/MIT-LICENSE-smartbanner.txt" "/var/www/piwik/libs/jquery/stylesheets/jquery.smartbanner.css" "/var/www/piwik/plugins/CoreHome/images/bg_header.jpg" "/var/www/piwik/plugins/CoreHome/images/bullet1.gif" "/var/www/piwik/plugins/CoreHome/images/bullet2.gif" "/var/www/piwik/plugins/CoreHome/images/googleplay.png" "/var/www/piwik/plugins/CoreHome/images/more_date.gif" "/var/www/piwik/plugins/CoreHome/images/more_period.gif" "/var/www/piwik/plugins/CorePluginsAdmin/images/paypal_donate.jpg" "/var/www/piwik/plugins/DevicesDetection/images/brand/3Q.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Acer.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Alcatel.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Apple.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Archos.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Asus.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Audiovox.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Avvio.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/BangOlufsen.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Barnes_Noble.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/BBK.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Becker.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Beetel.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/BenQ.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/bq.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Cat.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Celkon.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Cherry_Mobile.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/CnM.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Compal.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Compaq.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/ConCorde.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Coolpad.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/CreNova.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Cricket.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Crius_Mea.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Crosscall.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Danew.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Dell.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Denver.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/DMM.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/DoCoMo.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Easypix.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Ericsson.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/eTouch.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Evertek.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Fly.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Fujitsu.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Gemini.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Gigabyte.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Gigaset.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Gionee.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Google.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Gradiente.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Grundig.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Haier.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/HP.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/HTC.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Huawei.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Humax.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Hyundai.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/iBerry.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Ikea.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/i-mobile.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/INQ.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Intek.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Inverto.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Jolla.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Karbonn.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/KDDI.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Kindle.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Kyocera.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Lanix.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Lenovo.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Le_Pan.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/LG.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/LGUPlus.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Loewe.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Manta_Multimedia.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/MediaTek.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Medion.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Metz.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/MicroMax.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Microsoft.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Mio.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Mitsubishi.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Motorola.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/MSI.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/MyPhone.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/NEC.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Nexian.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/NGM.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Nikon.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Nintendo.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Nokia.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/O2.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Onda.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/OnePlus.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/OPPO.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Orange.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Panasonic.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Pantech.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/PEAQ.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Philips.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Polaroid.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/PolyPad.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Quechua.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/RIM.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sagem.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Samsung.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sanyo.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sega.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Selevision.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sencor.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/SFR.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sharp.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Siemens.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Smartfren.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Smart.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Softbank.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sony_Ericsson.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Sony.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Spice.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/TCL.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/TechniSat.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/TechnoTrend.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Tecno_Mobile.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Telefunken.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Telit.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/teXet.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Thomson.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/TiPhone.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/T-Mobile.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Tolino.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Toshiba.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Tunisie_Telecom.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Unknown.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Vertu.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Vestel.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Videocon.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Videoweb.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/ViewSonic.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Voxtel.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Wiko.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Wolder.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Woxter.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Xiaomi.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Yarvik.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Yuandao.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Zonda.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/Zopo.ico" "/var/www/piwik/plugins/DevicesDetection/images/brand/ZTE.ico" "/var/www/piwik/plugins/DevicesDetection/images/screens/console.gif" "/var/www/piwik/plugins/DevicesDetection/images/screens/dual.gif" "/var/www/piwik/plugins/DevicesDetection/images/screens/mobile.gif" "/var/www/piwik/plugins/DevicesDetection/images/screens/normal.gif" "/var/www/piwik/plugins/DevicesDetection/images/screens/unknown.gif" "/var/www/piwik/plugins/DevicesDetection/images/screens/wide.gif" "/var/www/piwik/plugins/Live/images/pause.gif" "/var/www/piwik/plugins/Live/images/play.gif" "/var/www/piwik/plugins/Live/images/returningVisitor.gif" "/var/www/piwik/plugins/Live/images/unknown_avatar.jpg" "/var/www/piwik/plugins/Live/images/visitor_profile_background.jpg" "/var/www/piwik/plugins/MobileMessaging/angularjs/delegate-mobile-messaging-settings/delegate-mobile-messaging-settings.controller.js" "/var/www/piwik/plugins/MobileMessaging/angularjs/manage-mobile-phone-numbers/manage-mobile-phone-numbers.controller.js" "/var/www/piwik/plugins/MobileMessaging/angularjs/manage-sms-provider/manage-sms-provider.controller.js" "/var/www/piwik/plugins/Morpheus/images/calendar.gif" "/var/www/piwik/plugins/Morpheus/images/collapsed_arrows.gif" "/var/www/piwik/plugins/Morpheus/images/ecommerceAbandonedCart.gif" "/var/www/piwik/plugins/Morpheus/images/ecommerceOrder.gif" "/var/www/piwik/plugins/Morpheus/images/expanded_arrows.gif" "/var/www/piwik/plugins/Morpheus/images/icon-calendar.gif" "/var/www/piwik/plugins/Morpheus/images/li_dbl_gray.gif" "/var/www/piwik/plugins/Morpheus/images/link.gif" "/var/www/piwik/plugins/Morpheus/images/paypal_subscribe.gif" "/var/www/piwik/plugins/MultiSites/images/arrow_asc.gif" "/var/www/piwik/plugins/MultiSites/images/arrow_desc.gif" "/var/www/piwik/plugins/Referrers/images/searchEngines/xx.gif" "/var/www/piwik/plugins/SEO/images/majesticseo.png"

So that was run and all looks good apart from the issues we have had for a while:

LOAD DATA INFILE

Using LOAD DATA INFILE will greatly speed Piwik's archiving process up. To make it available to Piwik, try updating your PHP & MySQL software and make sure your database user has the FILE privilege. If your Piwik server tracks high traffic websites (eg. > 100,000 pages per month), we recommend to try fix this problem. Error: LOAD DATA INFILE failed... Error was: Try #1: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 1290 The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I'll have another go at fixing that when I get a chance.

CRIN Trac: Ticket #101: Piwik 3.0.2

hours, status changed; resolution, totalhours set