ops issueshttps://lab.civicrm.org/infra/ops/-/issues2023-10-10T15:03:32Zhttps://lab.civicrm.org/infra/ops/-/issues/947Stats cron should be managed by Jenkins2023-10-10T15:03:32ZbgmStats cron should be managed by JenkinsRelated to #944, when the stats cron fails we do not get a notification about it.
Currently stats.civicrm.org has this cron running as root:
```
0 1 * * * cd /var/www/stats.civicrm.org; ./bin/civicrm-statistics.sh > ./log/civicrm-stati...Related to #944, when the stats cron fails we do not get a notification about it.
Currently stats.civicrm.org has this cron running as root:
```
0 1 * * * cd /var/www/stats.civicrm.org; ./bin/civicrm-statistics.sh > ./log/civicrm-statitics.log 2>&1
```
It had been failing for a while, but we were not getting a notification.https://lab.civicrm.org/infra/ops/-/issues/560INFRA-190 Display extension statistics on extension pages2020-08-14T12:58:35ZlegacyINFRA-190 Display extension statistics on extension pages[~nganivet] is working on INFRA-189, which will provide JSON files with statistics per extension. We should build a mechanism to display this data on each extension page on civicrm.org
The current vision is to use JavaScript to fetch th...[~nganivet] is working on INFRA-189, which will provide JSON files with statistics per extension. We should build a mechanism to display this data on each extension page on civicrm.org
The current vision is to use JavaScript to fetch the correct JSON file for the extension, parse the data, and display it on the page, as it is the simplest approach that will get us to the stated goal. Richer functionality later on may require a different approach, but we're aiming for useful results sooner rather than later.
Original author: allenshawhttps://lab.civicrm.org/infra/ops/-/issues/917Export of blog nodes needed2019-11-25T13:36:41ZcivideskExport of blog nodes neededWould anyone please perform an export of the blog nodes on c.o for me including the date posted, title, category and publication status? I would like to run some stats on this data.
Thanks,
--Nicolas.Would anyone please perform an export of the blog nodes on c.o for me including the date posted, title, category and publication status? I would like to run some stats on this data.
Thanks,
--Nicolas.https://lab.civicrm.org/infra/ops/-/issues/804Usage on civicrm.org extension pages is stale2019-10-23T23:54:40ZKarinGUsage on civicrm.org extension pages is stalestats.civicrm.org has iATS Extension at 478 - but https://civicrm.org/extensions/iats-payments was stuck at 219stats.civicrm.org has iATS Extension at 478 - but https://civicrm.org/extensions/iats-payments was stuck at 219https://lab.civicrm.org/infra/ops/-/issues/569INFRA-181 CiviCRM stats underreport popularity of MariaDB2018-02-14T15:09:12ZxurizaemonINFRA-181 CiviCRM stats underreport popularity of MariaDBhttps://stats.civicrm.org/json/active-sites-server-mysql.json currently shows 187 (161+26) sites running MySQL v10.x. I'm not aware of any MySQL versions > 5.7 (?) so I think these will be MariaDB (which does have v10.x).
I don't see a ...https://stats.civicrm.org/json/active-sites-server-mysql.json currently shows 187 (161+26) sites running MySQL v10.x. I'm not aware of any MySQL versions > 5.7 (?) so I think these will be MariaDB (which does have v10.x).
I don't see a bug in https://github.com/civicrm/civicrm-statistics/blob/master/pingback/generate.inc.php#L84
Guessing we scan the submitted System.get result (== "SELECT VERSION()") for a match of /mariadb/ and some distro which doesn't include -MariaDB- in the MySQL version string.
Proposed fix: add result of "SHOW VARIABLES LIKE 'version_comment'" to the reported information, handle this additional info in the CiviCRM.org stats reporting process.https://lab.civicrm.org/infra/ops/-/issues/779Stats.civicrm.org2017-08-04T14:44:03ZdaniellaStats.civicrm.orgThe stats have been down a while now - do we know when this will be back up and running?
Thanks ![Screen_Shot_2017-06-28_at_12.38.21](/uploads/026dae710c837a9c059b037a5ee7cefd/Screen_Shot_2017-06-28_at_12.38.21.png)The stats have been down a while now - do we know when this will be back up and running?
Thanks ![Screen_Shot_2017-06-28_at_12.38.21](/uploads/026dae710c837a9c059b037a5ee7cefd/Screen_Shot_2017-06-28_at_12.38.21.png)