Op maandag 2 maart 2020 13:26:14 CET schreef Per Jessen:
As I will not make it on time for the meeting, maybe not at all - a quick update on the forums migration:
Last week we finally managed to get a database export. Part of the delay was really my fault, not enough space on the upload filesystem (although a compressed export would have easily fitted ...).
I have also agreed with Jared that he will make a new export whenever needed, so we can have the most current data for the finished migration.
I have the newest vBulletin software, it is installed on http://forum.infra.o.o.
The database is loaded on the galera cluster (thanks for your help Lars). I used innodb for all tables, I saw no complaints.
So far for the good news, now the less good:
- I am not yet able to actually run the vBulletin code - currently I get an HTTP 500, which I'm still trying to figure out.
- charset. vBulletin recommends is UTF8mb4, but our database is in Latin1. I think(!) this should be simple to convert with ALTER.
- stylesheets etc. Apparently this version of vBulletin uses a new setup, not compatible with the current one. I'd like some help here. I'm wondering if some of the current forum admins might want to lend a hand?
- authentication. The 'vb_user' table holds 40501 rows. The current system is tied in to the SSO setup in Provo, I don't know how or if this table is used.
- according to Marta, the contract with Provo expired on Feb29. MF-IT have agreed to keep running the forums for another week.
In summary - if I can solve the HTTP 500 and the database conversion/upgrade works "just like that", the only issue is really authentication. Per, are you using the version the current forums use? You may need that version, then upgrade. The upgrade scripts would make the necessary changes to the DB. Mind, it's years ago for me when I had to take that path, instead of going through all the code and look for DB changes.
-- Gertjan Lettink a.k.a. Knurpht openSUSE Forums Team -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org