Re: [IMPORTANT] Scheduling Maintenance for our Forum

[Dave Fisher]

There is a lot hiding behind that error message.

The FR forum has been remigrated. I’m finishing a long running fixup:

root@openoffice-vm1-lw-us:/x1/var_lib_phpBB/com337# php ./bin/phpbbcli.php 
--safe-mode fixup:update-hashes
 33772/39298 [>---]  85% 

That might help the attachment and avatar issues.

It looks like I need to reorganize the layout to make each forum much more like 
the phpBB standard.

That also might help the attachment and avatar issues

I’ll be doing the reorg in the morning.

Anyone care to comment on the order of migration?

ATB,
Dave

> On May 2, 2022, at 6:16 PM, David Robley  wrote:
> 
> Orphaned attachments is not available from the General panel in ACP - the 
> error message is:
> 
> General Error
> Module not accessible
> 
> BACKTRACE
> 
> FILE: (not given by php)
> LINE: (not given by php)
> CALL: msg_handler()
> 
> FILE: [ROOT]/includes/functions_module.php
> LINE: 565
> CALL: trigger_error()
> 
> FILE: [ROOT]/adm/index.php
> LINE: 81
> CALL: p_master->load_active()
> 
> Also there is a warning on the General tab of the ACP:
> The selected search backend does not have a search index.
> Please create the index for “MySQL Fulltext” in the search index 
> 
>  section.
> 
> Following the link returns the same error as above:
> 
> 
> General Error
> 
> Module not accessible
> 
> BACKTRACE
> 
> *FILE:* (not given by php)
> *LINE:* (not given by php)
> *CALL:* msg_handler()
> 
> *FILE:* [ROOT]/includes/functions_module.php
> *LINE:* 565
> *CALL:* trigger_error()
> 
> *FILE:* [ROOT]/adm/index.php
> *LINE:* 81
> *CALL:* p_master->load_active()
> 
> On 5/3/22 03:25, Dave Fisher wrote:
>> Hi -
>> 
>> ACP should now be available on EN and FR. Basically some ${lang} hacks from 
>> the old config.php no longer function.
>> 
>> I wonder about the attachments is it possible that ACP Orphaned Attachments 
>> screen can fix these up?
>> Could someone try more a few …
>> 
>> Thanks,
>> Dave
>> 
>>> On May 2, 2022, at 8:32 AM, Bidouille  wrote:
>>> 
 There is an issue with accessing the admin control panel, error is
 
 Access denied for user 'forumaoouser'@'127.0.0.1' to database
 'forumaoo_' [1044]
>>> +1
>>> 
>>> Some problems detected:
>>> Logo (left top) has been removed
>>> All avatars can be accessed
>>> Some pictures seems to be corrupted in many threads
>>> 
>>> This is a database issue with a bad update.
>>> 
>>> -
>>> To unsubscribe, e-mail:dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail:dev-h...@openoffice.apache.org
>>> 
>> 
>> -
>> To unsubscribe, e-mail:dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail:dev-h...@openoffice.apache.org
>> 
> 
> Cheers
> -- 
> David Robley
> 
> Almost went crazy. Would have been a real short trip.
> 

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[David Robley]

Orphaned attachments is not available from the General panel in ACP - 
the error message is:


General Error
Module not accessible

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/functions_module.php
LINE: 565
CALL: trigger_error()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Also there is a warning on the General tab of the ACP:
The selected search backend does not have a search index.
Please create the index for “MySQL Fulltext” in the search index 
 
section.


Following the link returns the same error as above:


 General Error

Module not accessible

BACKTRACE

*FILE:* (not given by php)
*LINE:* (not given by php)
*CALL:* msg_handler()

*FILE:* [ROOT]/includes/functions_module.php
*LINE:* 565
*CALL:* trigger_error()

*FILE:* [ROOT]/adm/index.php
*LINE:* 81
*CALL:* p_master->load_active()

On 5/3/22 03:25, Dave Fisher wrote:

Hi -

ACP should now be available on EN and FR. Basically some ${lang} hacks from the 
old config.php no longer function.

I wonder about the attachments is it possible that ACP Orphaned Attachments 
screen can fix these up?
Could someone try more a few …

Thanks,
Dave


On May 2, 2022, at 8:32 AM, Bidouille  wrote:


There is an issue with accessing the admin control panel, error is

Access denied for user 'forumaoouser'@'127.0.0.1' to database
'forumaoo_' [1044]

+1

Some problems detected:
Logo (left top) has been removed
All avatars can be accessed
Some pictures seems to be corrupted in many threads

This is a database issue with a bad update.

-
To unsubscribe, e-mail:dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail:dev-h...@openoffice.apache.org



-
To unsubscribe, e-mail:dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail:dev-h...@openoffice.apache.org



Cheers
--
David Robley

Almost went crazy. Would have been a real short trip.
 

Re: WebDAV module ported from serf to curl; curl using openssl and zlib (was: Re: Openssl, serf and curl)

[Dave Fisher]

> On May 2, 2022, at 1:28 PM, Arrigo Marchiori  wrote:
> 
> Hello All,
> 
> On Sat, Apr 30, 2022 at 10:31:33PM +0200, Arrigo Marchiori wrote:
> 
>> Replying to myself again...
>> 
>> On Sat, Apr 30, 2022 at 10:03:54PM +0200, Arrigo Marchiori wrote:
>> 
>>> Replying to myself...
>>> 
>>> On Sat, Apr 30, 2022 at 09:41:04PM +0200, Arrigo Marchiori wrote:
>>> 
 Hello Damjan,
 
 On Fri, Apr 29, 2022 at 04:53:59AM +0200, Damjan Jovanovic wrote:
>>> [...]
> When I run your Linux binaries, I also get that error.
> 
> One problem is libcurl -> openssl.
> 
> "ldd ./libcurl.so" shows:
>libssl.so.10 => not found
>libcrypto.so.10 => not found
>>> [...]
> 
> It connects and seems to begin the SSL negotiations, and then probably
> crashes while doing the verify_callback we set with SSL_CTX_set_verify().
> 
> I suspect the Curl and/or OpenSSL headers used to build AOO, and their
> libraries available at runtime, are incompatible.
> 
> What happens if you run AOO on the same machine it was built on?
>>> [...]
 As I wrote above, according to your suspects, it may be worthwile to
 bundle curl and openssl binaries. I will try to follow this path. It
 should be a matter of parameters to the configure script.
>>> 
>>> Curl and openssl are already bundled.
>>> 
>>> But Curl is not using the openssl from AOO, but rather from the
>>> system. In other words, it does not honor the environment variable
>>> SYSTEM_OPENSSL=NO set by the AOO build system.
>>> 
>>> Curl's configure script looks for the SSL headers and libraries either
>>> from pkgconfig or at a path provided with parameter --with-ssl
>>> 
>>> We do not support pkgconfig inside the solver, so we have to rely on
>>> the path.
>>> 
>>> But Curl's configure script expects to find a directory structure such as:
>>> - $PREFIX/include/openssl
>>> - $PREFIX/lib[64]
>>> whereas our $OUTDIR has openssl installed into different paths:
>>> - $OUTDIR/inc/external/openssl
>>> - $OUTDIR/lib
>>> 
>>> I believe this means we have to patch Curl's configure script.
>> 
>> Not only. We also have to actually bundle libssl.so and libcrypto.so
>> because they are not!
>> 
>> This means we have to patch:
>> 
>> - main/openssl/prj/d.lst to have them included into the solver;
>> 
>> - scp2/source/ooo/file_library_ooo.scp to have their Unix names
>> included.
>> 
>> This is a separate bug and will be worth its own pull request.
> 
> Here it is:
> https://github.com/apache/openoffice/pull/147
> 
> I suggest:
> 
> 1- we merge the above PR (I will on Friday, if no one vetoes and no
> issues are raised);
> 
> 2- we patch curl's configure script to use the bundled OpenSSL
> library, when requested.
> 
> Comments are always welcome.

Just so that you aren’t the only one here.

It will be important to write good release notes about these changes.

Users will need to understand clearly that updates to cURL and OpenSSL for CVEs 
won’t happen immediately unless they build with 2 on their own.

Regards,
Dave


> 
> Best regards,
> -- 
> Arrigo
> 
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
> 


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: WebDAV module ported from serf to curl; curl using openssl and zlib (was: Re: Openssl, serf and curl)

[Arrigo Marchiori]

Hello All,

On Sat, Apr 30, 2022 at 10:31:33PM +0200, Arrigo Marchiori wrote:

> Replying to myself again...
> 
> On Sat, Apr 30, 2022 at 10:03:54PM +0200, Arrigo Marchiori wrote:
> 
> > Replying to myself...
> > 
> > On Sat, Apr 30, 2022 at 09:41:04PM +0200, Arrigo Marchiori wrote:
> > 
> > > Hello Damjan,
> > > 
> > > On Fri, Apr 29, 2022 at 04:53:59AM +0200, Damjan Jovanovic wrote:
> > [...]
> > > > When I run your Linux binaries, I also get that error.
> > > > 
> > > > One problem is libcurl -> openssl.
> > > > 
> > > > "ldd ./libcurl.so" shows:
> > > > libssl.so.10 => not found
> > > > libcrypto.so.10 => not found
> > [...]
> > > > 
> > > > It connects and seems to begin the SSL negotiations, and then probably
> > > > crashes while doing the verify_callback we set with 
> > > > SSL_CTX_set_verify().
> > > > 
> > > > I suspect the Curl and/or OpenSSL headers used to build AOO, and their
> > > > libraries available at runtime, are incompatible.
> > > > 
> > > > What happens if you run AOO on the same machine it was built on?
> > [...]
> > > As I wrote above, according to your suspects, it may be worthwile to
> > > bundle curl and openssl binaries. I will try to follow this path. It
> > > should be a matter of parameters to the configure script.
> > 
> > Curl and openssl are already bundled.
> > 
> > But Curl is not using the openssl from AOO, but rather from the
> > system. In other words, it does not honor the environment variable
> > SYSTEM_OPENSSL=NO set by the AOO build system.
> > 
> > Curl's configure script looks for the SSL headers and libraries either
> > from pkgconfig or at a path provided with parameter --with-ssl
> > 
> > We do not support pkgconfig inside the solver, so we have to rely on
> > the path.
> > 
> > But Curl's configure script expects to find a directory structure such as:
> >  - $PREFIX/include/openssl
> >  - $PREFIX/lib[64]
> > whereas our $OUTDIR has openssl installed into different paths:
> >  - $OUTDIR/inc/external/openssl
> >  - $OUTDIR/lib
> > 
> > I believe this means we have to patch Curl's configure script.
> 
> Not only. We also have to actually bundle libssl.so and libcrypto.so
> because they are not!
> 
> This means we have to patch:
> 
>  - main/openssl/prj/d.lst to have them included into the solver;
> 
>  - scp2/source/ooo/file_library_ooo.scp to have their Unix names
>  included.
> 
> This is a separate bug and will be worth its own pull request.

Here it is:
https://github.com/apache/openoffice/pull/147

I suggest:

 1- we merge the above PR (I will on Friday, if no one vetoes and no
 issues are raised);

 2- we patch curl's configure script to use the bundled OpenSSL
 library, when requested.

Comments are always welcome.
 
Best regards,
-- 
Arrigo

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

[GitHub] [openoffice] ardovm opened a new pull request, #147: Fix including OpenSSL dynamic libraries on Unix

[GitBox]

ardovm opened a new pull request, #147:
URL: https://github.com/apache/openoffice/pull/147

   .so files were never copied.
   The logic needed two small changes IMHO. Here they are.
   
   These commits are meant to be squashed if we choose to merge them.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[Dave Fisher]

Hi -

ACP should now be available on EN and FR. Basically some ${lang} hacks from the 
old config.php no longer function.

I wonder about the attachments is it possible that ACP Orphaned Attachments 
screen can fix these up? 
Could someone try more a few …

Thanks,
Dave

> On May 2, 2022, at 8:32 AM, Bidouille  wrote:
> 
>> There is an issue with accessing the admin control panel, error is
>> 
>> Access denied for user 'forumaoouser'@'127.0.0.1' to database
>> 'forumaoo_' [1044]
> +1
> 
> Some problems detected:
> Logo (left top) has been removed
> All avatars can be accessed
> Some pictures seems to be corrupted in many threads
> 
> This is a database issue with a bad update.
> 
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
> 


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[Bidouille]

> There is an issue with accessing the admin control panel, error is
> 
> Access denied for user 'forumaoouser'@'127.0.0.1' to database
> 'forumaoo_' [1044]
+1

Some problems detected:
Logo (left top) has been removed
All avatars can be accessed
Some pictures seems to be corrupted in many threads

This is a database issue with a bad update.

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[casalva]

Logged into both as normal user / volunteer (I don't have administrator / 
moderator privileges on these versions). 
I only notice lack of attachments, but this is probably normal at this stage.

charlie
- Messaggio originale -
Da: "Dave Fisher" 
A: "dev" 
Inviato: Lunedì, 2 maggio 2022 9:58:25
Oggetto: Re: [IMPORTANT] Scheduling Maintenance for our Forum

The en and fr forums are available to test: 

https://openoffice-vm1-lw-us.apache.org/

Please test these forums.

Known work to do:
- Restore the Apache Open Office logo in the header
- Return the Apache and Get OpenOffice information in the footer
- Avatars have moved in 3.3.7 need to determine how to move them.

The automatic mySQL migration from 3.0.9 seems to work but takes quite some 
time.

ATB,
Dave

> On May 1, 2022, at 11:16 AM, Dave Fisher  wrote:
> 
> Apologies for the late communication.
> 
> The forums are being updated from phpBB 3.0.9 to 3.3.7. 
> 
> Differences so far:
> 1. The subsilver2 theme is no longer available.
> 2. Analytics are removed due to new ASF privacy policies. We can add back 
> analytics that are compliant in the next weeks.
> 3. Search Display code is changed and I could not see how add 
> ({NEW_POST_COUNT}) into styles/prosilver/template/index_body.html
> 4. /style.php is no longer included.
> 5. /app.php is new.
> 6. /includes/ucp/ucp_register.php will need to be tested on the French forum.
> 7. /feed.php is reorganized and it was not clear how to add the customized 
> rel=“alternate” to one of the links.
> 
> This doesn’t seem bad.
> Language packs were found and AOO customizations are added.
> 
> I expect to finish late tonight - when ready there will be a test url.
> 
> Once the forums are put into maintenance the following will happen:
> 
> 1. Make sure all the files and images that have been uploaded are copied.
> 2. Dumps of the mysql databases will be copied over.
> 3. Forum databases will be updated
> 4. Forum admins will have a chance to test.
> 5. Once live we’ll triage any issues.
> 
> Bidouille has access to the VM … any other forum admins who are already 
> OpenOffice committers may request access.
> 
> A warning - this same VM hosts the wiki and the mysql databases.
> 
> I’ll be offline for a few hours before returning to this work and to answer 
> any questions.
> 
> ATB,
> Dave
> 
>> On May 1, 2022, at 10:43 AM, Peter Kovacs  wrote:
>> 
>> 
>> Am 01.05.22 um 15:59 schrieb Rory O'Farrell:
>>> On Sun, 1 May 2022 15:53:47 +0200
>>> Peter Kovacs  wrote:
>>> 
 Hello all,
 
 
 please note, that we schedule a maintenance for the Forum in order to
 move database and content to a new machine. This maintenance tasks
 includes also a phpBB updates to a recent version, with all the Forum
 Modification ported.
 
 The downtime will take place from Monday, 2nd March 2022 1800 UTC until
 the end of the same day.
 
 
 All the best
 
 Peter
 
>>> Possible typo?  March in place of May?
>> Thanks Rory, It is May. My mistake.
>>> 
>>> Rory
>>> 
>> 
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>> 
>

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[David Robley]

There is an issue with accessing the admin control panel, error is

Access denied for user 'forumaoouser'@'127.0.0.1' to database 
'forumaoo_' [1044]


On 5/2/22 17:28, Dave Fisher wrote:

The en and fr forums are available to test:

https://openoffice-vm1-lw-us.apache.org/

Please test these forums.

Known work to do:
- Restore the Apache Open Office logo in the header
- Return the Apache and Get OpenOffice information in the footer
- Avatars have moved in 3.3.7 need to determine how to move them.

The automatic mySQL migration from 3.0.9 seems to work but takes quite some 
time.

ATB,
Dave


On May 1, 2022, at 11:16 AM, Dave Fisher  wrote:

Apologies for the late communication.

The forums are being updated from phpBB 3.0.9 to 3.3.7.

Differences so far:
1. The subsilver2 theme is no longer available.
2. Analytics are removed due to new ASF privacy policies. We can add back 
analytics that are compliant in the next weeks.
3. Search Display code is changed and I could not see how add 
({NEW_POST_COUNT}) into styles/prosilver/template/index_body.html
4. /style.php is no longer included.
5. /app.php is new.
6. /includes/ucp/ucp_register.php will need to be tested on the French forum.
7. /feed.php is reorganized and it was not clear how to add the customized 
rel=“alternate” to one of the links.

This doesn’t seem bad.
Language packs were found and AOO customizations are added.

I expect to finish late tonight - when ready there will be a test url.

Once the forums are put into maintenance the following will happen:

1. Make sure all the files and images that have been uploaded are copied.
2. Dumps of the mysql databases will be copied over.
3. Forum databases will be updated
4. Forum admins will have a chance to test.
5. Once live we’ll triage any issues.

Bidouille has access to the VM … any other forum admins who are already 
OpenOffice committers may request access.

A warning - this same VM hosts the wiki and the mysql databases.

I’ll be offline for a few hours before returning to this work and to answer any 
questions.

ATB,
Dave


On May 1, 2022, at 10:43 AM, Peter Kovacs  wrote:


Am 01.05.22 um 15:59 schrieb Rory O'Farrell:

On Sun, 1 May 2022 15:53:47 +0200
Peter Kovacs  wrote:


Hello all,


please note, that we schedule a maintenance for the Forum in order to
move database and content to a new machine. This maintenance tasks
includes also a phpBB updates to a recent version, with all the Forum
Modification ported.

The downtime will take place from Monday, 2nd March 2022 1800 UTC until
the end of the same day.


All the best

Peter


Possible typo?  March in place of May?

Thanks Rory, It is May. My mistake.

Rory


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org





Cheers
--
David Robley

Almost went crazy. Would have been a real short trip.
 



-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [IMPORTANT] Scheduling Maintenance for our Forum

[Dave Fisher]

The en and fr forums are available to test: 

https://openoffice-vm1-lw-us.apache.org/

Please test these forums.

Known work to do:
- Restore the Apache Open Office logo in the header
- Return the Apache and Get OpenOffice information in the footer
- Avatars have moved in 3.3.7 need to determine how to move them.

The automatic mySQL migration from 3.0.9 seems to work but takes quite some 
time.

ATB,
Dave

> On May 1, 2022, at 11:16 AM, Dave Fisher  wrote:
> 
> Apologies for the late communication.
> 
> The forums are being updated from phpBB 3.0.9 to 3.3.7. 
> 
> Differences so far:
> 1. The subsilver2 theme is no longer available.
> 2. Analytics are removed due to new ASF privacy policies. We can add back 
> analytics that are compliant in the next weeks.
> 3. Search Display code is changed and I could not see how add 
> ({NEW_POST_COUNT}) into styles/prosilver/template/index_body.html
> 4. /style.php is no longer included.
> 5. /app.php is new.
> 6. /includes/ucp/ucp_register.php will need to be tested on the French forum.
> 7. /feed.php is reorganized and it was not clear how to add the customized 
> rel=“alternate” to one of the links.
> 
> This doesn’t seem bad.
> Language packs were found and AOO customizations are added.
> 
> I expect to finish late tonight - when ready there will be a test url.
> 
> Once the forums are put into maintenance the following will happen:
> 
> 1. Make sure all the files and images that have been uploaded are copied.
> 2. Dumps of the mysql databases will be copied over.
> 3. Forum databases will be updated
> 4. Forum admins will have a chance to test.
> 5. Once live we’ll triage any issues.
> 
> Bidouille has access to the VM … any other forum admins who are already 
> OpenOffice committers may request access.
> 
> A warning - this same VM hosts the wiki and the mysql databases.
> 
> I’ll be offline for a few hours before returning to this work and to answer 
> any questions.
> 
> ATB,
> Dave
> 
>> On May 1, 2022, at 10:43 AM, Peter Kovacs  wrote:
>> 
>> 
>> Am 01.05.22 um 15:59 schrieb Rory O'Farrell:
>>> On Sun, 1 May 2022 15:53:47 +0200
>>> Peter Kovacs  wrote:
>>> 
 Hello all,
 
 
 please note, that we schedule a maintenance for the Forum in order to
 move database and content to a new machine. This maintenance tasks
 includes also a phpBB updates to a recent version, with all the Forum
 Modification ported.
 
 The downtime will take place from Monday, 2nd March 2022 1800 UTC until
 the end of the same day.
 
 
 All the best
 
 Peter
 
>>> Possible typo?  March in place of May?
>> Thanks Rory, It is May. My mistake.
>>> 
>>> Rory
>>> 
>> 
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>> 
>