matomo issueshttps://git.coop/webarch/matomo/-/issues2023-09-28T08:01:44Zhttps://git.coop/webarch/matomo/-/issues/12Speed up loops through sites2023-09-28T08:01:44ZChris Croomechris@webarchitects.co.ukSpeed up loops through sitesPerhaps access the MariaDB database directly:
```sql
SELECT JSON_ARRAYAGG(JSON_OBJECT('idsite', idsite, 'main_url', main_url)) FROM matomo_site
```
Returns:
```json
[
{
"idsite": 1,
"main_url": "http://wsh.webarchitects.org....Perhaps access the MariaDB database directly:
```sql
SELECT JSON_ARRAYAGG(JSON_OBJECT('idsite', idsite, 'main_url', main_url)) FROM matomo_site
```
Returns:
```json
[
{
"idsite": 1,
"main_url": "http://wsh.webarchitects.org.uk"
},
{
"idsite": 2,
"main_url": "http://wiki.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"main_url": "http://www2.weblog.wsh.webarch.org.uk"
}
]
```
And:
```sql
SELECT JSON_ARRAYAGG(JSON_OBJECT('idsite', idsite, 'url', url)) FROM matomo_site_url
```
Returns:
```json
[
{
"idsite": 2,
"url": "http://wiki.mediawiki.wsh.webarchitects.org.uk"
},
{
"idsite": 2,
"url": "http://www.mediawiki.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"url": "http://weblog.wsh.webarch.org.uk"
},
{
"idsite": 3,
"url": "http://weblog.wsh.webarchitects.org.uk"
},
{
"idsite": 3,
"url": "http://www.weblog.wsh.webarch.org.uk"
},
{
"idsite": 3,
"url": "http://www.weblog.wsh.webarchitects.org.uk"
}
]
```Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/11Update GPG key2023-01-17T10:58:14ZChris Croomechris@webarchitects.co.ukUpdate GPG key```
wget https://github.com/matomo-org/matomo/releases/download/4.13.1/matomo-4.13.1.tar.gz
wget https://github.com/matomo-org/matomo/releases/download/4.13.1/matomo-4.13.1.tar.gz.asc
gpg --verify matomo-4.13.1.tar.gz.asc
gpg: assuming ...```
wget https://github.com/matomo-org/matomo/releases/download/4.13.1/matomo-4.13.1.tar.gz
wget https://github.com/matomo-org/matomo/releases/download/4.13.1/matomo-4.13.1.tar.gz.asc
gpg --verify matomo-4.13.1.tar.gz.asc
gpg: assuming signed data in 'matomo-4.13.1.tar.gz'
gpg: Signature made Mon 16 Jan 2023 13:13:28 GMT
gpg: using RSA key F529A27008477483777FC23D63BB30D0E5D2C749
gpg: Can't check signature: No public key
```
The [answer](https://github.com/matomo-org/matomo/issues/18924#issue-1166085917) is to update the public key:
```
gpg --keyserver hkps://keyserver.ubuntu.com --recv-keys F529A27008477483777FC23D63BB30D0E5D2C749
gpg: key 63BB30D0E5D2C749: public key "Matomo <hello@matomo.org>" imported
gpg: Total number processed: 1
gpg: imported: 1
gpg --verify matomo-4.13.1.tar.gz.asc
gpg: assuming signed data in 'matomo-4.13.1.tar.gz'
gpg: Signature made Mon 16 Jan 2023 13:13:28 GMT
gpg: using RSA key F529A27008477483777FC23D63BB30D0E5D2C749
gpg: Good signature from "Matomo <hello@matomo.org>" [unknown]
gpg: WARNING: This key is not certified with a trusted signature!
gpg: There is no indication that the signature belongs to the owner.
Primary key fingerprint: F529 A270 0847 7483 777F C23D 63BB 30D0 E5D2 C749
```Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/10Set variables in config/config.ini.php2022-05-16T13:42:16ZChris Croomechris@webarchitects.co.ukSet variables in config/config.ini.phpThese need to be set if they don't exist:
```[General]
force_ssl = "1"
salt = "LONG_RANDOM_STRING"
login_allow_logme = 1
```These need to be set if they don't exist:
```[General]
force_ssl = "1"
salt = "LONG_RANDOM_STRING"
login_allow_logme = 1
```Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/9Different matomo_first_user from matomo_user2021-03-14T15:57:08ZChris Croomechris@webarchitects.co.ukDifferent matomo_first_user from matomo_userIf the `matomo_user` and the `matomo_first_user` are not the same things don't work, it should be possible for them to be different.If the `matomo_user` and the `matomo_first_user` are not the same things don't work, it should be possible for them to be different.Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/8Matomo 42021-01-05T20:44:36ZChris Croomechris@webarchitects.co.ukMatomo 4Testing and a fix for [this change](https://matomo.org/changelog/matomo-4-0-0-b2/):
> Security: More secure storage of tokens: the `token_auth` and session ID are no longer stored in plain text in the database.
Will be needed see [this...Testing and a fix for [this change](https://matomo.org/changelog/matomo-4-0-0-b2/):
> Security: More secure storage of tokens: the `token_auth` and session ID are no longer stored in plain text in the database.
Will be needed see [this task](https://git.coop/webarch/matomo/-/blob/fc91fbd4fed5209e8d76970a8ebdc9d7737c5702/tasks/token_auth.yml#L16).Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/6Crontab2019-11-29T10:14:07ZChris Croomechris@webarchitects.co.ukCrontabSee: https://matomo.org/docs/setup-auto-archiving/See: https://matomo.org/docs/setup-auto-archiving/WSH Version 1.0Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/5Delete unneeded files from the git version2020-01-14T10:44:29ZChris Croomechris@webarchitects.co.ukDelete unneeded files from the git versionDue to [this issue](https://github.com/digitalist-se/extratools/issues/15) there is now an option to use [git to install Matomo](https://git.coop/webarch/matomo/blob/master/tasks/git.yml) but this results in lots of [un-needed files not ...Due to [this issue](https://github.com/digitalist-se/extratools/issues/15) there is now an option to use [git to install Matomo](https://git.coop/webarch/matomo/blob/master/tasks/git.yml) but this results in lots of [un-needed files not being deleted](https://github.com/matomo-org/matomo-package/blob/master/scripts/build-package.sh#L169) so these should either be deleted or `.htaccess` or Apache config could be used to deny access to them...WSH Version 1.0Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/4Add Login Fail plugin for fail2ban2019-09-24T10:16:51ZChris Croomechris@webarchitects.co.ukAdd Login Fail plugin for fail2banSee https://git.coop/webarch/fail2ban/issues/1See https://git.coop/webarch/fail2ban/issues/1Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.ukhttps://git.coop/webarch/matomo/-/issues/3Delete site2019-09-24T18:57:12ZChris Croomechris@webarchitects.co.ukDelete siteThere is no `deletesite.yml` yet because of [the missing command](https://github.com/digitalist-se/extratools/issues/7) in ExtraTools.There is no `deletesite.yml` yet because of [the missing command](https://github.com/digitalist-se/extratools/issues/7) in ExtraTools.Chris Croomechris@webarchitects.co.ukChris Croomechris@webarchitects.co.uk