Giter Site home page Giter Site logo

Comments (72)

e-gaulue avatar e-gaulue commented on July 28, 2024 5

Just to inform 6 versions were built this week-end. It would be really hard to build 2 packages when two versions have been released the same day. Anyway, changelog is the same. Only the last one is build.

@sgiehl We should reorganize this repository since it's only use for Debian for more than a year now. Accept pull requests. Remove scripts and maybe archives directories. Change README.md to link to https://github.com/matomo-org/matomo-package/tree/master/debian#readme...

Regards,

from matomo-package.

BenSturmfels avatar BenSturmfels commented on July 28, 2024 2

PS. This is still live in the docs:

How do I install Matomo on Debian GNU/Linux servers?
https://matomo.org/faq/how-to-install/#faq_17844

Perhaps this is a good place to explain that the Debian package is no longer supported?

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 2

For those interesting in testing a beta package of matomo 4.5.0 (as of today), you can try the one in the current pull request waiting for validation.

Here is a cook book for Bullseye (maybe also good for Buster):

  1. Set up your gpg credential to build the package, if you don't already have any
echo 'DEBEMAIL="[email protected]"
DEBFULLNAME="Your Name"
export DEBEMAIL DEBFULLNAME
' | tee -a ~/.bashrc
  1. Get the building dependancies
sudo apt install gnupg2 lintian debhelper devscripts build-essential fakeroot
  1. Get the sources and check for virus/trojan: this will show what I've changed from the official repo.
cd
git clone https://github.com/e-gaulue/matomo-package.git
cd matomo-package
git log
git show
  1. Import the matomo signature as the packager start with downloading the sources and checking them.
cd
wget http://builds.matomo.org/signature.asc
gpg --import signature.asc
  1. Compile: You can put whatever you want in the changelog file, as this will be YOUR package anyway.
cd matomo-package
make release
  1. Install
cd
sudo dpkg -i matomo_4.5.0-3_all.deb
  1. If the previous command complains about dependencies you can install them with
sudo apt install -f

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 2

Hi all,

It should be ready by the end of this week ! I manage the full stack now. Just have to provide main stable version since 4.0.0 one by one. It's on the way.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 2

@colans Should be online right now!

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 2

This post to inform Debian matomo v5 package is out.

Please report any issues whose resolution could/should be included in this package.

from matomo-package.

Dreamsorcerer avatar Dreamsorcerer commented on July 28, 2024 1

Not sure it makes sense to close all the other issues. If there is a new maintainer, then many of those issues probably need to be reopened.

from matomo-package.

BenSturmfels avatar BenSturmfels commented on July 28, 2024 1

@nomandera thanks for the note! the blog post now redirects to the official non-debian installation guide, to remove any possibly confusion.

@mattab just wanted to note that I found the redirection from the Debian repo to the installation guide quite confusing! Would it be possible to redirect to a paragraph explaining that the Debian repository is no longer supported? I don't think the redirection alone communicates this effectively - I very nearly opened an issue about the redirection heh.

Thanks for all your work on Matomo - I've been a happy user for many years! Thanks @aureq too!

from matomo-package.

BenSturmfels avatar BenSturmfels commented on July 28, 2024 1

Thanks @mattab! I still feel it would have been helpful to me to have a more direct statement in that FAQ answer such as "The previous Debian package repository is no longer actively maintained. We recommend migrating to the our standard installation approach." Thanks again.

from matomo-package.

mattab avatar mattab commented on July 28, 2024 1

@BenSturmfels we've just updated the page at https://debian.matomo.org/ - hope it's more clear. i'll leave the FAQ as is I think as people would easily find https://debian.matomo.org/ if they search 👍

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024 1

OK we are definitely making progress but we are not there yet.

The instructions

To install Matomo on Debian:

    your system can meet the requirements
    then proceed to install Matomo by following the instructions in our Matomo Installation Guide.

is fine for a new install but if you were to follow this as-is for an exiting apt install you would end up with a Frankensteins monster of two installs.

I would suggest we should be looking at an initial backup phase (of what I cant say) and then an apt remove or even and apt purge of apache2 matomo.

WARNING: untested please anyone following this thread dont just try this without being able to recover.

So what actually

  • needs backed up beyond config/config.ini.php and the database?
  • How closely do the apt and manual install versions os Matomo need to be (remember everyone on apt is almost a year out of date)

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024 1

Create a backup of everything (Matomo files and Database) is always a good thing.

In theory nothing needs to be backed up (even config/config.ini.php can be regenerated by going through the installer again).
But there are a few things that will be lost:

  • installed Plugins (not their settings)
  • GeoIP database (you can find them in misc/)
  • custom logos and favicons (also in misc/)
  • salt (in not copying the config) which means password resets, things like this and maybe logged in sessions will be lost

You can download every release of Matomo from https://builds.matomo.org/ which would allow you to migrate to the identical version and afterwards update. In theory you can do both things at once, but I think doing them separately is easier.

Things you also need to set up, that the debian package included:

Also I noticed that an apt remove deletes the Matomo directory so maybe copy it somewhere else first.

from matomo-package.

sgiehl avatar sgiehl commented on July 28, 2024 1

The Matomo team is currently not able to provide an official support any longer as we don't have someone who is familiar enough with the topic and don't have enough capacity to handle that.

@e-gaulue would you commit to provide required updates/changes needed for future releases? If so we could maybe reconsider the decision to drop official support.

from matomo-package.

mattab avatar mattab commented on July 28, 2024 1

Hi @colans Thanks for your message. i have now been in contact with @e-gaulue and i invite you to wait a bit more time as we may have an update to post in the next few weeks: to be confirmed soon.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 1

Hi all,

For those interested in trying the "new" repository, you can add "next" to the classical https://debian.matomo.org/ URL.

Be careful, this documentation has been written as if it was already the production repository. So do not forget to add next to the URL in the source.list. And remember you'll have to remove it as soon as this site will be in production.

I don't see any reason why it would not work for you, but I believe there are hundreds of different configurations, so we never know. Feel free to discuss here any point that could be improved regarding this package availability and installation.

If most of you reports success, this "next" alias will be removed to become the production URL at the beginning of April.

Best regards,

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024 1

I hoped to do it last week-end, but I didn't get the time. I'll try to find the time, one of this night (not next for sure), before next week-end. It won't take long. I'll will just change the link to have the site in production and add a warning regarding those core dumps happening during core:update. I will mention the link provided by @mattab and maybe the github issues page.

If really a problem, we can go back to a package where core:update is not run by the package as a default, so we just get a warning message requesting us to do it. But, I remember, I often didn't see it or forgot to run it, so I was happy when this option has appeared a few year ago.

from matomo-package.

mattab avatar mattab commented on July 28, 2024 1

Great work @e-gaulue - Thank you for your contributions to Matomo Debian package 💪 🎉

from matomo-package.

MatthiasKuehneEllerhold avatar MatthiasKuehneEllerhold commented on July 28, 2024 1

I noticed that the latest version of matomo on https://debian.matomo.org is 4.13.3-1 ...
Are these scripts here used for the packages in this repo? Is this repo still in use and will it get new versions or should I build the packages myself?

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

I just updated the title to make it clear this is about the debian packages as this repository also contains build-package.sh which is the main way all Matomo releases are created and is updated for this all the time.

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Yes thank you that is a worthy and important clarification to make.

from matomo-package.

mattab avatar mattab commented on July 28, 2024

Thanks @nomandera for your interest. I've talked to the previous maintainer and I can confirm that he is not going to maintain the Debian package anymore.

So at this point we have two options:

  • Deprecate the package, close it, make it clear that it won't be maintained anymore
  • Find a new maintainer, who uses this package in production, and who could own this package (and eventually help us automate the debian package release using github actions)

Is there maybe anyone reading this who would be interested to take over the debian package for Matomo?

we do have quite solid docs and scripts that @aureq created, but it does need some work and knowledge of Debian.

from matomo-package.

mattab avatar mattab commented on July 28, 2024

@Dreamsorcerer Most issues seem really low impact, and hadn't been commented/touched for years. Trying to be pragmatic and have a clean slate for whoever comes next (if we're lucky to find a new maintainer...)

from matomo-package.

Dreamsorcerer avatar Dreamsorcerer commented on July 28, 2024

No problem, I guess just a "reopen if this still affects you" then. I do see that some of them appear to have been fixed, although probably need some documentation.

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Is there any option for Team Matomo to step in and take over even if it is a temporary measure?

During my initial research of install options the official announcement and apt repository left no doubt that the project was backed by Team Matomo.

image

Sorry if this seems negative, just feeling a bit left out in the rain here given that the very first time we need the Matomo team to maintain the Debian Matomo repository the response it to twilight the project and call for the community to step in or it will be closed.

from matomo-package.

mattab avatar mattab commented on July 28, 2024

@nomandera thanks for the note! the blog post now redirects to the official non-debian installation guide, to remove any possibly confusion.

we've also redirected https://debian.matomo.org/ for now, to make sure nobody else could get false expectations.

FYI Looking at some basic server logs stats, we can see that Since Jan 1st 2020 there were only 244 downloads of the release matomo_3.10.0-1_all.deb. So it looks to me like Debian package is not a very popular installation method.

Big thanks and kuddos to @aureq for his work all these years maintaining the package! 👏

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Since it is looking likely that the repository will be gone now forever could instructions on how to migrate to a supported install be provided as a sign of good faith from Matomo?

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

@nomandera If I can find some time in the next days, I'll write something. As I never used the package and can't reliably test it, this would be more of a community wiki for everyone to contribute to.

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

I very much appreciate the efforts @Findus23 as currently we are all feeling pretty annoyed at Matomo over here.

We followed the official install guide, purchased and renewed several addons during the subsequent years, contributed time and effort in this project and for our troubles we are now left with a a load of completely unmaintainable installs in the Douglas Adams style of "So long and thanks for all the fish".

This is what happens if a project just kills a repo:

Reading package lists... Done  
E: Failed to fetch http://debian.matomo.org/dists/piwik/InRelease  Clearsigned file isn't valid, got 'NOSPLIT' (does the network require authentication?)
E: The repository 'http://debian.matomo.org piwik InRelease' is no longer signed.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.

from matomo-package.

mattab avatar mattab commented on July 28, 2024

@BenSturmfels Thanks for the note the FAQ has been fixed

Thanks for the hint @nomandera - we restored the website at https://debian.matomo.org/ so it still works for now. (i hadn't realised setting a redirect would have broken the system...)

To install Matomo on Debian:

  1. your system can meet the requirements
  2. then proceed to install Matomo by following the instructions in our Matomo Installation Guide.

And when you install Matomo using these steps, you can enter the DB credentials of your existing database (the one that was managed by Debian before, you will find the DB credentials in the config/config.ini.php file), so your database will be reused and no data be lost.

Maybe @Findus23 will provide more details, or you can write here any questions or issues, we will help you migrate

from matomo-package.

BenSturmfels avatar BenSturmfels commented on July 28, 2024

Thanks @mattab

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Just to confirm.

Is Matomo going to provide a set of upgrade instructions to port apt existing users to a mechanism that is still supported or is this on the community?

I ask because I have been tasked with pulling this off here and I dont want to forge ahead trying to work this out on the fly if an correct/official methodology is forthcoming.

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

@nomandera
As noone asked here anymore, I assumed the steps explained above were enough.

But if you have any questions, I can answer them when they arise.

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Thanks for the follow up. I just assumed that since apt was an official install method and since it has now been officially removed that some guide to port would be forthcoming.

There is a big difference between a series of tips and a official supplied and tested migration document.

Please realise that those of us with this in commercial production are now in a situation of having to build, R&D and test this procedure. This is unplanned cost and not an easy sell.

It is what it is I suppose but Matomo did not shine here. Far from it.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Hi all,

The wave is going to rise as admins will move from Buster to Bulleyes.

@Findus23
You can download every release of Matomo from https://plugins.matomo.org/ which would allow you to migrate to the identical version and afterwards update. In theory you can do both things at once, but I think doing them separately is easier.

Where? Following this link, it's far to be clear for me. Most of us will look for 3.14.1, the last that was provided.

Has the installer changed a lot between 3.14.1 and now? I mean file location and permission. If not, my proposal is to get this 3.14.1 installer package. Then install. This should result in having 2 matomo installation. Then, I'll try either to migrate old data in new install, or keep old package parts : logrotate, cron... Then ugrade

I can provide the shell command I used. I was on a classical Buster and move to a classical Bulleyes. But I need the 3.14.1 installer.

Regards,

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

@e-gaulue You are right, I mistyped the URL. I meant https://builds.matomo.org/

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Debian admins are used to have obsolete packages as long as they are stable and secured. Those interested in newer packages can move to solution (Matomo, phpmyadmin, wordpress, ...) team own Debian packages.

Could anyone bring me to matomo team recommandations regarding apache configuration. I googled and found lots of people saying: "here is the way I installed it", but I did not find the team recommandations. I know we are on the border and one could say: "that's not the matomo job but the apache admin one to secure it".

For instance, in https://github.com/matomo-org/matomo-package/blob/master/debian/conf/apache.conf, we have a kind of partial proposal which aim is to secure installation. Is it still good? Could we have a better one for >=4 version?

By the way, it would be a shame to throw this Debian packaging stuff, as it doesn't look so unusable. I'm really sorry I do not have any time to spend on it (and I'm not a Debian package expert), but looking at it, it would take really few time for one of them to refresh this code.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Hi all,

I did manage to move from debian package to matomo classical install, but debian package was great: easy to install, easy to upgrade, easy to backup, easy to trust... So I looked at the files in the debian directory of this current git repository and I didn't find any reason why building 4.5.0 as a debian package would break. So I cloned the project. I made really few changes and got my matomo_4.5.0-3_all.deb package.

Of course, when you try to install it, it complains, but it's really easy to change and correct.

I'm in a situation I can say: "it works for me", but I need help if you want something considered stable.

I'm working with debian for 20 years now, but I don't consider myself as an expert. And regarding Matomo, I'm just a sys admin, not a user. I've got the experience of other web application (wordpress), so I think I understand most of its architecture.

If ever I can help, what is the real need? Get deb packages for which Matomo version and to which Debian destination? buster, bulleyes...

Regards,

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

Could anyone bring me to matomo team recommandations regarding apache configuration.

I don't know Apache well (I never used it), so take this with a grain of salt.
But I think the only Apache setup things that are related to Matomo are handled by the .htaccess files that Matomo generates.
So the only recommendation on how to set up your Apache instance that is exclusive to Matomo is: Make sure you have .htaccess files enabled in your config.

In nginx this is of course different and one can't generate config files. That's why I published https://github.com/matomo-org/matomo-nginx/ which should be enough to secure an nginx Matomo setup

from matomo-package.

nomandera avatar nomandera commented on July 28, 2024

Superb work.

I am extremely interested in this but I have a worry. The APT install method has been officially dropped as a supported install type which leaves me at a critical decision point.

If I commit to testing this I will incur an associated internal cost and then when ready a subsequent deployment cost.

However if the package is not official, tested and released in a timely manner, potentially stalling again in the future due to it being a "one man show not backed by Matomo Inc" I will be back to where we started.

Not to take away from your excellent work but...

could we have an official position statement from Matomo if they plan to back this and commit to keeping it maintained should community efforts need bolstering.

At home/fun/FOSS none of this matters but this now I am managing a bunch of commercial production installs which are stuck.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Well, my sight is to consider matomo has an opensource project. As far as I understand, matomo can also be used as a paid service.

On the opensource side, there is a community, on the other side, there is a company. According to me, the interactions between them are important: both are needed. If you use the community version, you know you take your own risk: you won't be able to complain to anybody and won't get any money back in case of trouble (will you with the paid version?). If you use the community version, you must report and try to help, that's the way opensource projects live.

As far as I understand, the Debian package is offered by the community side.

I wouldn't say there was a great effort to provide a wonderful Debian package. Being a web application, this usually ends to shell scripts. Those I worked on were rather classical: I mean there was nothing magic that could lead anybody to use the debian package instead of the tar.gz one. But:

  • installation/upgrade is simple
  • backup is simple (because I just have to backup all /etc and my db)
  • depends are automatically updates
  • some matomo recommandations are directly applied
  • some security concerns are already handle
  • the debian recommandations are applied (/etc, /usr/share/doc, /var, apache & cron configuration...)

Regarding updates/changes for futur release, as far as matomo structure is not fully modified from one version to another, I think you just need one hour to provide a new deb package. It will take more time for a migration from one Debian version two another (I would say 2 days).

So, I can follow motomo version as long as it's not fully modified, with a few days delay. But, I can't say the same with a Debian version change. My delay would be 4-6 months (presently Bullseye is here since the end of august). After, if we are on the community side and people are rather helpful, we could even get it better.

In one word, the answer is Yes if you accept those delays (welcome to the Debian world).

Regards,

from matomo-package.

sgiehl avatar sgiehl commented on July 28, 2024

@e-gaulue Thanks for your feedback. As I'm not very familiar with building Debian packages or have any clue about the effort that would be required on our side to publish such packages, I'm not able to make any decisions here.
maybe @mattab @tsteur or @Findus23 are able to help making an official decision on that.

from matomo-package.

Findus23 avatar Findus23 commented on July 28, 2024

@e-gaulue I agree that if there is someone familiar with how Debian packaging works, then keeping the package updated to a new Matomo version should not be a lot of work (as Matomo updates don't affect how the package looks like).

I can always help with the "getting Matomo to work on Debian" part of the issue as I'm a Debian user on all of my devices. But I am not familiar with the packaging part and therefore don't want to maintain it myself.

Apart from changing PHP versions even upgrades between major Debian versions shouldn't be that much work and Matomo should always support the PHP version of the current Debian stable, so as long as people don't want packages for old Debian versions (without newer PHP versions from deb.sury.org), things should be fine there too.

So if you are interested in helping here, I'm really not against creating a new Matomo debian package.
But semi-related: I think then, we should move the debian related things out of this repository and only use it for build-package.sh as those two things are not really related (I think the debian package should use the built matomo.zip as a source).

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

I totally agree.

I lost time trying to understand if there was relationship between build-package.sh and the Debian package Makefile. And at first sight, I did even not understand why the Debian package was dead if there are still commits.

But the Debian package totally depends on the result of build-package.sh, so some Lintian recommandations should directly be implemented in it. That's why I made two different pull requests. After, it's just a question of documentation for the developers. But, my last pull request assume the first one has been/will be validated.

from matomo-package.

sgiehl avatar sgiehl commented on July 28, 2024

We actually could also move the build-package.sh away from this repo. We are currently preparing an automated github action for building a release. So we could also move that script to the main repo within that change and use this repo for the debian package only

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

I've worked again on the old debian scripts. I did just validate all the Makefile actions were executable. So it gives few new commits.

I've seen pull requests were still not merge. One of them focus on build-package.sh because we get lintian errors or warnings. Lintian is a 'lint' tool for checking debian packages. It has got plenty of rules regarding what looks strange in them. Reason why we have one of this pull request. While not corrected, I will still get those messages. It's not really a problem now. But if we want to move to some automations like: if no Litian error is found, directly push the package to servers, it will be a break.

For the second pull request, I can pull it again with last changes and a better commit message.

I will have a bit of time during this end of year. How could we work on the last stage of the package generation: its upload on the server? I'd like to provide 4.5.0, 4.6.0, 4.6.1 and 4.6.2.

Regards,

from matomo-package.

sgiehl avatar sgiehl commented on July 28, 2024

Hi @e-gaulue. Thanks for the update. Unfortunatelly I can't be of much help with all that stuff. Maybe @tsteur or @mattab can say more on that.
But regarding the build-package.sh I'm able to say, that it most likely will get removed here, once matomo-org/matomo#17594 is finished.

from matomo-package.

mattab avatar mattab commented on July 28, 2024

Hi @e-gaulue Thank you for your message and offer to contribute! That's great to hear. Would you mind sending us an email via https://matomo.org/contact/ and i'll get back to you in the next week or two? Wishing you all happy end of year!

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Hi @mattab, I did send an email, but I still have no answer, any news about this?

from matomo-package.

colans avatar colans commented on July 28, 2024

@e-gaulue Until you're able to connect with the maintainers, would you be able to set up a PPA or something similar on your own, making whatever assumptions are necessary for now?

This would have several advantages:

  1. Those of us who are waiting could start testing it and provide feedback.
  2. We'd have something temporary to use in the interim.
  3. The maintainers would be able to review what you've set up and report any problems.

To state my bias, my Ansible role is the most popular one on Galaxy and it depends on the unmaintained Debian repository. I can't plan for what to do next until I see where this is going. (Do I rewrite the code to do installations the "official" way, or wait until there's a maintained Debian repo? I don't want to do a bunch of work on it if I can simply wait a bit.)

from matomo-package.

colans avatar colans commented on July 28, 2024

@e-gaulue So, instead of https://debian.matomo.org/, use https://debian.matomo.org/next before April 1st?

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

@colans Yes, exactly, I just wanted to avoid this URL to be referenced by search engines. I added noindex,nofollow.

from matomo-package.

colans avatar colans commented on July 28, 2024

Seems to work fine when upgrading from an old DB, even though I got this error (which didn't affect anything):

[...Lots of DB updates...]
Matomo has been successfully updated!
Segmentation fault (core dumped)
dpkg: error processing package matomo (--configure):
installed matomo package post-installation script subprocess returned error exit status 139

It killed my terraform apply, but then I re-ran it without problems.

So I'd say this is a success. Thank you! 🚀

from matomo-package.

tombreit avatar tombreit commented on July 28, 2024

Same here:
Quoting @colans : Seems to work fine when upgrading from an old DB, even though I got this error (which didn't affect anything):

[...]
Matomo database will be upgraded from version 3.14.1 to the new version 4.7.1.
[...]
Matomo has been successfully updated!

Segmentation fault
dpkg: error processing package matomo (--configure):
 installed matomo package post-installation script subprocess returned error exit status 139
Errors were encountered while processing:
 matomo
E: Sub-process /usr/bin/dpkg returned an error code (1)

Thank you for bringing this package back to life.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

That's the second time this point is underline. I will look at it.

from matomo-package.

WhilelM avatar WhilelM commented on July 28, 2024

Segmentation fault here too, but during tables update.

Matomo database will be upgraded from version 3.14.1 to the new version 4.7.1.

[...]
Executing UPDATE piwik_archive_numeric_2019_09 SET name = 'done' WHERE name = 'done.';... Done. [265 / 537]
Executing UPDATE piwik_archive_numeric_2019_10 SET name = 'done' WHERE name = 'done.';... Done. [266 / 537]
Executing UPDATE piwik_archive_numeric_2019_11 SET name = 'done' WHERE name = 'done.';... Done. [267 / 537]
Executing UPDATE piwik_archive_numeric_2019_12 SET name = 'done' WHERE name = 'done.';... Done. [268 / 537]

Installation is interrupted. Lost message mentionning that's the table piwik_segment that was in update at the segfault.

In kern.log got this

Mar 28 12:22:23 server kernel: [12925988.725592] php[32306]: segfault at 17 ip 00007f8ce4e15dc7 sp 00007ffd11a95d50 error 4 in pdo.so[7f8ce4e0d000+c000]
Mar 28 12:22:23 server kernel: [12925988.725647] Code: 9f 73 ff ff 48 89 ef e8 e7 79 ff ff e9 42 fe ff ff 66 90 4c 89 f8 48 8b 7c 24 08 4d 8b 06 48 c1 e0 05 48 03 43 18 48 8b 0c 38 <0f> b6 41 18 3c 39 0f 8e d9 07 00 00 48 89 ea 48 89 ce 4c 89 c7 e8

I restored a backup of database to give it another try, followed by apt install -f. New segfault, at the same point.

Executing UPDATE piwik_archive_numeric_2022_01 SET name = 'done' WHERE name = 'done.';... Done. [294 / 541]
Executing UPDATE piwik_archive_numeric_2022_02 SET name = 'done' WHERE name = 'done.';... Done. [295 / 541]
Executing UPDATE piwik_archive_numeric_2022_03 SET name = 'done' WHERE name = 'done.';... Done. [296 / 541]
Executing ALTER TABLE piwik_segment ADD COLUMN hash CHAR(32) NULL AFTER definition;... Done. [297 / 541]
Segmentation fault
dpkg: erreur de traitement du paquet matomo (--configure) :
installed matomo package post-installation script subprocess returned error exit status 139
Des erreurs ont été rencontrées pendant l'exécution :
matomo
E: Sub-process /usr/bin/dpkg returned an error code (1)

[...]

In kern.log got this

Mar 28 17:14:00 server kernel: [ 8222.154096] php[11785]: segfault at 17 ip 00007faa2a822dc7 sp 00007ffd6d160220 error 4 in pdo.so[7faa2a81a000+c000]
Mar 28 17:14:00 server kernel: [ 8222.154149] Code: 9f 73 ff ff 48 89 ef e8 e7 79 ff ff e9 42 fe ff ff 66 90 4c 89 f8 48 8b 7c 24 08 4d 8b 06 48 c1 e0 05 48 03 43 18 48 8b 0c 38 <0f> b6 41 18 3c 39 0f 8e d9 07 00 00 48 89 ea 48 89 ce 4c 89 c7 e8

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

@WhilelM

If the trouble is just in the database upgrade process, this means new matomo script files are already here. I would just reset the database to the backup and go to the back office admin update page or invoke /usr/bin/php /usr/share/matomo/console core:update. Maybe you will get more information as it will be interactive.

You can also stop package installation to automatically run core:update as non interactive by doing: sudo dpkg-reconfigure matomo.

Regards

from matomo-package.

mattab avatar mattab commented on July 28, 2024

The segmentation fault we document here: https://matomo.org/faq/troubleshooting/faq_131/
The solution is typically to "update PHP" or update other bits of the system.

I have a question: although it failed with this error, is the Matomo actually working or not?
It's possible that it errored, but actually everything worked and there is no impact.
If that's the case then maybe the error can be ignored for now?
or is it a blocking issue?

from matomo-package.

colans avatar colans commented on July 28, 2024

@e-gaulue @mattab Do you folks have a new ETA for when the new site will go to Prod (as it doesn't seem to be the beginning of April anymore)? We have some infrastructure work planned, which is depending on this, but can't start it until that happens. Thanks for getting this up & running again!

from matomo-package.

WhilelM avatar WhilelM commented on July 28, 2024

Hello, how things are going for this repository ? I'm not able to find updates for months.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

You are right, I'm going to build new debs in the next days.

Building those deps with a production skill is rather fastidious. The best I found is to build them all twice a year (3 to 6 versions each time). It's something like 1 hour for the first and 10 minutes for the next ones if everything is OK. It's sometimes worse depending on the changes in the sources.

Regards,

from matomo-package.

sgiehl avatar sgiehl commented on July 28, 2024

@e-gaulue Do you see any possibility to maybe automate that process using a github action? We could then trigger that action after each release

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

Well, it's always the same with Debian. Fast package distribution has never been in its scope.

Package building is closely linked with lintian. If almost nothing change, we are in the 10 minutes process I spoke. If ever lintian complains you have to analyse the reasons: new/rename files/directory, missing licence file, providing library while a Debian package already exists... I discover new ones as long as I build some, that happens every 2/3 building process.

I've already changed scripts to detect filename changes before lintian, but to go to a full automation looks to me hard. Moreover, it's not this way Debian would like things to be done. It hopes package builders to look as much as they can to the content they provide. I mean when lintian fail, most of the time it's because you have to make a decision.

There are two kind of changes in the commits I pulled. Some are needed by the core of the Debian building process (rare) and the other are just here to satisfy lintian.

Regards,

from matomo-package.

mattab avatar mattab commented on July 28, 2024

Thanks for the feedback @MatthiasKuehneEllerhold
@e-gaulue Maybe you have some feedback about this, or could it be that you maybe don't have time anymore to maintain this project? in which case we could look for a new maintainer maybe, or find someone to help..

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

@MatthiasKuehneEllerhold and @mattab

I'll look at it this week-end. I should be able to produce new versions till 4.15.0 (7 versions). Just notice that Debian Bookworm is out for 3 months now. I still haven't migrate my own servers to this system, so I may need more time to have a package working with Bookworm, or not... Package may be installable, but the building process mays be broken. Everything is possible.

For Matomo 5, depending on the size of the changes, it may also require more time.

Lots of people use snap nowadays. It looks easier to install, update and it's more portable (all linux platforms). As an admin sys, I'm not so fond of it, as it's often not tested as much as Debian packages are. There are pros and cons. But maybe Matomo could provide this kind of snap for those not so concerned by security and reliability and who want new version as soon as possible.

from matomo-package.

e-gaulue avatar e-gaulue commented on July 28, 2024

@mattab

I've build the first package, but I can't connect to matomo.org server anymore. Is there new protocol?

I need to build every package and upload them sequentially, in order the process to work normally.

Regards,

from matomo-package.

mattab avatar mattab commented on July 28, 2024

@e-gaulue thanks for your quick answer!
can you maybe reach out on slack and I can help resolve the issue with permission?

from matomo-package.

MatthiasKuehneEllerhold avatar MatthiasKuehneEllerhold commented on July 28, 2024

My system just updated to 4.14.1. Im eagerly awaiting further packages! Thank you very much.

My 2 cents regarding snap vs dpkg:
Were not using snap at all atm, so that would be a completely new system I'd have to familiarize myself with. So ... I'd like to keep installing the dpkg version but wouldnt be opposed to snaps. IDK if thats helpful for you or not ;-)

from matomo-package.

vostorga avatar vostorga commented on July 28, 2024

Matomo debian package has not been updated since 4.15.1

from matomo-package.

mattab avatar mattab commented on July 28, 2024

Thanks @vostorga for the heads up. Sorry about the delay with the release. I've reached out to @e-gaulue to discuss our next steps. Hope to have an update within 2-3 weeks.

from matomo-package.

vostorga avatar vostorga commented on July 28, 2024

Thank you very much for your fast reply

from matomo-package.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.