Forums

Resolved
1 votes
I have the same issue on multiple systems running ClearOS 7.2 auto updates Since februari 24 there is no more logging of network and resources on the systems. The Network Report and Resource report give nothing to report only on the 30 day I get a figure with the 24 of februari as the last day.
Sunday, March 05 2017, 10:10 PM
Share this post:
Responses (10)
  • Accepted Answer

    Monday, March 13 2017, 09:00 PM - #Permalink
    Resolved
    0 votes
    Yup..that's the one Nick...Just updated my post (forgot the -core ending on the pkg name).

    B
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 13 2017, 08:12 PM - #Permalink
    Resolved
    0 votes
    Is it this one in clearos-updates-testing? If so it is taking its time to sync.

    [root@server ~]# yum list app-reports-d* --show-duplicates
    Loaded plugins: clearcenter-marketplace, fastestmirror
    ClearCenter Marketplace: fetching repositories...
    Loading mirror speeds from cached hostfile
    * clearos: ftp.nluug.nl
    * clearos-centos-verified: mirror1-frankfurt.clearos.com
    * clearos-contribs: ftp.nluug.nl
    * clearos-epel-verified: mirror1-frankfurt.clearos.com
    * clearos-fast-updates: download4.clearsdn.com
    * clearos-infra: ftp.nluug.nl
    * clearos-verified: mirror1-frankfurt.clearos.com
    * private-clearcenter-ad: download2.clearsdn.com:80
    * private-clearcenter-antimalware: download2.clearsdn.com:80
    * private-clearcenter-antispam: download2.clearsdn.com:80
    * private-clearcenter-business: download2.clearsdn.com:80
    * private-clearcenter-content-filter: download2.clearsdn.com:80
    * private-clearcenter-dyndns: download2.clearsdn.com:80
    * private-clearcenter-dynvpn: download2.clearsdn.com:80
    * private-clearcenter-ids: download2.clearsdn.com:80
    * private-clearcenter-master-slave: download2.clearsdn.com:80
    * private-clearcenter-rbs: download2.clearsdn.com:80
    * private-clearcenter-security-audit: download2.clearsdn.com:80
    * private-clearcenter-verified-updates: download2.clearsdn.com:80
    * private-clearcenter-wpad: download2.clearsdn.com:80
    private-clearcenter-verified-updates | 2.9 kB 00:00
    private-clearcenter-verified-updates/primary_db | 1.0 MB 00:00
    Installed Packages
    app-reports-database-core.noarch 1:2.3.1-1.v7 @clearos-updates-testing
    Available Packages
    app-reports-database-core.noarch 1:2.3.0-1.v7 clearos-verified
    app-reports-database-core.noarch 1:2.3.0-1.v7 private-clearcenter-verified-updates
    I've taken a flyer and installed it.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 13 2017, 03:58 PM - #Permalink
    Resolved
    0 votes
    Permanent fix heading to mirrors as "app-reports-database-core version 2.3.1".

    B
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 13 2017, 08:03 AM - #Permalink
    Resolved
    0 votes
    THank you Nick and Ben fot the help it was so annoing that it didn't work on several systems. I am still curous what caused the problem.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, March 12 2017, 04:00 PM - #Permalink
    Resolved
    2 votes
    Hi Ben, I've done as you suggest. Thanks

    BTW I did have a nice one liner to replace -p"xxxx" which I've just dug out. You can do
    -p`cut -f3 -d" " /var/clearos/system_database/reports`
    although I did not use it in this instance.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, March 12 2017, 03:34 PM - #Permalink
    Resolved
    1 votes
    If that worked, you'll also likely need to do the same for the other tables you may have in reports:


    /usr/clearos/sandbox/usr/bin/mysql -ureports -p"xxxx" reports < /usr/clearos/apps/resource_report/deploy/db_tables.sql
    /usr/clearos/sandbox/usr/bin/mysql -ureports -p"xxxx" reports < /usr/clearos/apps/proxy_report/deploy/db_tables.sql


    Wonder what caused the tables auto index and defaults to disappear?

    B.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, March 12 2017, 12:55 PM - #Permalink
    Resolved
    0 votes
    Hi Ben,
    That worked and I now have one point of data.
    Nick
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, March 12 2017, 12:50 PM - #Permalink
    Resolved
    2 votes
    Can you reset your network table in the reports database and see if that helps. Steps:

    1. Get database pw

    cat /var/clearos/system_database/reports


    2. Reset database schema (note, you will lose any old data)

    /usr/clearos/sandbox/usr/bin/mysql -ureports -p"xxxx" reports < /usr/clearos/apps/network_report/deploy/db_tables.sql


    Where xxxx is replaced with your password obtained in step 1.

    3. Force some data import

    /usr/sbin/network2db


    4. See if that resolves your issue by viewing the network reports section in Webconfig.

    B
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, March 12 2017, 08:25 AM - #Permalink
    Resolved
    0 votes
    Mine are the same. I don't know the underlying mechanism so can't really investigate. I've submitted bug 13671.
    The reply is currently minimized Show
  • Accepted Answer

    oldcolony
    oldcolony
    Offline
    Sunday, March 12 2017, 03:15 AM - #Permalink
    Resolved
    0 votes
    Column Timestamp in system mysql table "network" has only 0000-00-00 00:00:00 values.
    The reply is currently minimized Show
Your Reply