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.
Share this post:
Responses (10)
-
Accepted Answer
-
Accepted Answer
Is it this one in clearos-updates-testing? If so it is taking its time to sync.
I've taken a flyer and installed it.[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 -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
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. -
Accepted Answer
-
Accepted Answer
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 -
Accepted Answer
Mine are the same. I don't know the underlying mechanism so can't really investigate. I've submitted bug 13671. -
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »