[CWB] Upgrade of CQPweb server

[Uhrig, Peter]

Dear Stefan,

Just to add, because my memory is fresh on this one: We recently upgraded from 22.04 to 24.04. We had to change the Apache PHP module:
a2dismod php8.1
a2enmod php8.3

and re-install the new versions of the php-libraries (see Admin manual) and transfer the PHP config settings from /etc/php/8.1 to /etc/php/8.3

CQPweb 3.3 is now running again. 

Best wishes,
Peter

-----Ursprüngliche Nachricht-----
Von: CWB <cwb-bounces at sslmit.unibo.it> Im Auftrag von Stefan Fischer via CWB
Gesendet: Mittwoch, 19. November 2025 17:57
An: CWB mailing list <cwb at sslmit.unibo.it>
Cc: Stefan Fischer <stefan.fischer at uni-saarland.de>
Betreff: Re: [CWB] Upgrade of CQPweb server

Hi Stephanie,

> Our CQPweb server runs on Ubuntu 24.04.3. As far as I can remember, we didn't have any major issues during the OS upgrade. However, …

Thanks for looking up the release number. That's already reassuring.

> … we're still on CQPweb v3.2.44 because 3.3 is still considered unstable / incomplete and we didn't have the courage to upgrade. Did you upgrade your server from 3.2 to 3.3 at some point? And if so, did you have major issues due to the upgrade?

The earliest CQPweb version mentioned in our documentation is 3.2.31. So, I guess that we upgraded successfully from 3.2 to 3.3. However, that happened before I took over administration of the server. I found a short note that installing r1826 caused an issue related to "php upgrade-database.php". Apparently, this was fixed by removing some "saved_catqueries" for the corpus with id=0. I hope that helps.

After you mentioned upgrade issues, I had a closer look at our database. Luckily, all upgrade steps in upgrade-database.php were applied successfully. However, I noted that there are still some MyISAM tables. I guess, before any other upgrades, we should fix this by calling force-innodb.php?

> You could also simply install CWB from the .deb-package and cwb-perl from CPAN. Though it's always best to use the latest and least buggy versions from SVN, of course.

Thanks for mentioning the .deb and CPAN packages. I'd actually prefer these to a manual installation. However, r1826 (2022-10-15) seems to be a couple of months newer than the available .deb and CPAN versions. Could that downgrade cause any issues with a newer version CQPweb? That is, does the unstable version of CQPweb depend on minor bug fixes?

Best,
Stefan
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 7322 bytes
Desc: not available
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20251127/bd807d0e/attachment.p7s>