Re: Hu Forum woes

[Chris Lambertus]

> On Aug 9, 2017, at 3:35 PM, Andrea Pescetti  wrote:
> 
> On 08/08/2017 Reizinger Zoltán wrote:
>> I as admin of Hungarian Forum deleted nearly all post in Hungarian
>> forum, during maintenance.
>> Can anybody restore the forum database to yesterday status?
> 
> Database backups for https://forum.openoffice.org/ are managed by Infra, 
> since we use a shared cluster. CCing the Infra list. I assume we will 
> coordinate through a JIRA ticket to restore the status of the database at the 
> last backup we had when the incident happened (can you be more precise about 
> date and time?), but at least Infra is informed that those backups must be 
> kept.
> 
> An important note: if I recall correctly, we have several forum installations 
> (one per language) sharing the same database. Please let's coordinate, since 
> restoring the old database is not a solution (it would restore the Hungarian 
> forum but also delete recent activity from all other forums). I think we will 
> need to only filter tables with a certain prefix.


Infra would need to know exactly what point in time this occurred (UTC) and 
what objects would need to be restored. There is a forumooo_hu database which 
is the likely target for restoration. Please include those details in an infra 
Jira ticket.

-Chris



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

There may not be anything we can do about this until phpBB is upgraded.

I put the wiki database move on hold until I can look into it more.


> On Jan 4, 2018, at 2:42 PM, Andrea Pescetti <pesce...@apache.org> wrote:
> 
> CCing Chris for the two messages below. Maybe a SQL version issue?
> Regards,
>  Andrea.
> 
> On 04/01/2018 21:59, Hagar Delest wrote:
>> Note: same for the other languages (Italian anf French tested).
>> 
>> The DISTINCT 3065 thing seems a common one:
>> 
>> In French forum:
>> Erreur générale
>> SQL ERROR [ mysqli ]
>> 
>> Expression #1 of ORDER BY clause is not in SELECT list, references
>> column 'forumaoo_fr.t.topic_last_post_time' which is not in SELECT list;
>> this is incompatible with DISTINCT [3065]
>> 
>> And in Italian:
>> SQL ERROR [ mysqli ]
>> 
>> Expression #1 of ORDER BY clause is not in SELECT list, references
>> column 'forumaoo_it.t.topic_last_post_time' which is not in SELECT list;
>> this is incompatible with DISTINCT [3065]
>> 
>> Hagar
>> 
>> 
>> Le 04/01/2018 à 21:33, Hagar Delest a écrit :
>>> Hi,
>>> 
>>> Since the move, we noticed that when performing an advanced search
>>> that should display the results as topics, then we get an error:
>>> 
>>> General Error
>>> SQL ERROR [ mysqli ]
>>> 
>>> Expression #1 of ORDER BY clause is not in SELECT list, references
>>> column 'forumaoo_en.t.topic_last_post_time' which is not in SELECT
>>> list; this is incompatible with DISTINCT [3065]
>>> 
>>> SQL
>>> 
>>> SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM phpbb_en_topics t,
>>> phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST
>>> ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
>>> t.topic_last_post_time DESC LIMIT 250
>>> 
>>> The same search is fine when set to display results as posts.
>>> 
>>> Could you have a look please?
>>> Thanks
>>> 
>>> Hagar
>>> 
>>> 
>>> Le 04/01/2018 à 03:30, Chris Lambertus a écrit :
>>>>> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <c...@apache.org> wrote:
>>>>> 
>>>>> Hi folks,
>>>>> 
>>>>> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice
>>>>> PHPBB forum databases to a new server. The forums will be offline
>>>>> during this process, and is expected to take about 2 hours.
>>>>> 
>>>>> -Chris
>>>>> ASF Infra
>>>>> 
>>>>> 
>>>> 
>>>> Hi all,
>>>> 
>>>> This move has been completed. Spot checks on the forums look good.
>>>> 
>>>> -Chris
>>>> 
>>> 
>> 
>> 
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>> 
>> 



signature.asc
Description: Message signed with OpenPGP

ooo-wiki downtime

[Chris Lambertus]

> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <c...@apache.org> wrote:
> 
> Hi folks,
> 
> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
> forum databases to a new server. The forums will be offline during this 
> process, and is expected to take about 2 hours.



Hi folks,

We also need to perform this operation on the ooo-wiki site. This is only 
moving the MySQL database backend by updating the server IP in /x1/LocalDB.php. 
There will be no other changes to the application or app server. I will be 
performing this work tonight at 0100 UTC. The outage should be shorter as there 
is only one database that needs to move.


-Chris



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

All,

There is monitoring for ooo-forums. As I stated, this outage did not trip the 
monitors. The duration was likely too short. If the duration was noted to be 
longer than 5 minutes or so, it’s possible there is a problem with the 
monitoring that needs to be looked into, but when I took the forums down for 
the database move, the monitors did, in fact, work.



-Chris




> On Jan 10, 2018, at 9:48 AM, Andrea Pescetti  wrote:
> 
> On 10/01/2018 Greg Stein wrote:> status.apache.org reports services that are 
> *down*, rather than individual
>> bugs/problems.
> 
> Just to be clear, we had two different issues here:
> 
> 1. Some advanced search options broke due to incompatibility with the new SQL 
> server (and this is fixed, which is great). This is indeed just a bug.
> 
> 2. Forum being offline (no DB connection, error on all pages). This is 
> equivalent to the service being down.
> 
> I wasn't able to see issue 2 either, so it probably lasted just for a very 
> short period. But I think we all agree that monitoring should catch this, at 
> least when it extends for several minutes (not necessarily this case).
> 
> Regards,
>  Andrea.



signature.asc
Description: Message signed with OpenPGP

Re: Forums outage

[Chris Lambertus]

By the time we saw this message, it was working fine. It doesn’t appear to have 
tripped our monitors. It would be helpful to have a UTC time of the start of 
the problem and the duration for this outage.

Thanks,
Chris
ASF Infra


> On Jan 8, 2018, at 1:00 AM, FR web forum  wrote:
> 
> Since this morning, very slow and now, we got an error:
> SQL ERROR [ mysqli ]
> Can't connect to MySQL server on 'mysql1-lw-us.apache.org' (110) [2003]
> An sql error occurred while fetching this page. Please contact an 
> administrator if this problem persists.



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

I’ve pushed a change which fixes this on the database side. I also saw the 
email about the forum being down yesterday, but it was a transient problem. It 
would be helpful for me to know what the start time and duration was for any 
future reports of slowness or outages.

-Chris







> On Jan 4, 2018, at 5:49 PM, Chris Lambertus <c...@apache.org> wrote:
> 
> 
> There may not be anything we can do about this until phpBB is upgraded.
> 
> I put the wiki database move on hold until I can look into it more.
> 
> 
>> On Jan 4, 2018, at 2:42 PM, Andrea Pescetti <pesce...@apache.org> wrote:
>> 
>> CCing Chris for the two messages below. Maybe a SQL version issue?
>> Regards,
>> Andrea.
>> 
>> On 04/01/2018 21:59, Hagar Delest wrote:
>>> Note: same for the other languages (Italian anf French tested).
>>> 
>>> The DISTINCT 3065 thing seems a common one:
>>> 
>>> In French forum:
>>> Erreur générale
>>> SQL ERROR [ mysqli ]
>>> 
>>> Expression #1 of ORDER BY clause is not in SELECT list, references
>>> column 'forumaoo_fr.t.topic_last_post_time' which is not in SELECT list;
>>> this is incompatible with DISTINCT [3065]
>>> 
>>> And in Italian:
>>> SQL ERROR [ mysqli ]
>>> 
>>> Expression #1 of ORDER BY clause is not in SELECT list, references
>>> column 'forumaoo_it.t.topic_last_post_time' which is not in SELECT list;
>>> this is incompatible with DISTINCT [3065]
>>> 
>>> Hagar
>>> 
>>> 
>>> Le 04/01/2018 à 21:33, Hagar Delest a écrit :
>>>> Hi,
>>>> 
>>>> Since the move, we noticed that when performing an advanced search
>>>> that should display the results as topics, then we get an error:
>>>> 
>>>> General Error
>>>> SQL ERROR [ mysqli ]
>>>> 
>>>> Expression #1 of ORDER BY clause is not in SELECT list, references
>>>> column 'forumaoo_en.t.topic_last_post_time' which is not in SELECT
>>>> list; this is incompatible with DISTINCT [3065]
>>>> 
>>>> SQL
>>>> 
>>>> SELECT DISTINCT SQL_CALC_FOUND_ROWS t.topic_id FROM phpbb_en_topics t,
>>>> phpbb_en_posts p WHERE MATCH (p.post_subject, p.post_text) AGAINST
>>>> ('+solved ' IN BOOLEAN MODE) AND t.topic_id = p.topic_id ORDER BY
>>>> t.topic_last_post_time DESC LIMIT 250
>>>> 
>>>> The same search is fine when set to display results as posts.
>>>> 
>>>> Could you have a look please?
>>>> Thanks
>>>> 
>>>> Hagar
>>>> 
>>>> 
>>>> Le 04/01/2018 à 03:30, Chris Lambertus a écrit :
>>>>>> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <c...@apache.org> wrote:
>>>>>> 
>>>>>> Hi folks,
>>>>>> 
>>>>>> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice
>>>>>> PHPBB forum databases to a new server. The forums will be offline
>>>>>> during this process, and is expected to take about 2 hours.
>>>>>> 
>>>>>> -Chris
>>>>>> ASF Infra
>>>>>> 
>>>>>> 
>>>>> 
>>>>> Hi all,
>>>>> 
>>>>> This move has been completed. Spot checks on the forums look good.
>>>>> 
>>>>> -Chris
>>>>> 
>>>> 
>>> 
>>> 
>>> -
>>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>> 
>>> 
> 



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

Unfortunately, some slowdowns are inevitable. We cannot keep the old database 
hardware alive, and this is a necessary transition step until we can move the 
ooo-forums phpBB software to a new host.




> On Jan 10, 2018, at 2:49 PM, Hagar Delest  wrote:
> 
> Hi,
> 
> Thanks for the bug fix related to the search by topics, this is a great news.
> 
> The forum still lags compared to before the server switch.
> Have tried to clean the cookies but no change.
> 
> Hagar
> 
> 
> Le 10/01/2018 à 18:48, Andrea Pescetti a écrit :
>> On 10/01/2018 Greg Stein wrote:> status.apache.org reports services that are 
>> *down*, rather than individual
>>> bugs/problems.
>> 
>> Just to be clear, we had two different issues here:
>> 
>> 1. Some advanced search options broke due to incompatibility with the new 
>> SQL server (and this is fixed, which is great). This is indeed just a bug.
>> 
>> 2. Forum being offline (no DB connection, error on all pages). This is 
>> equivalent to the service being down.
>> 
>> I wasn't able to see issue 2 either, so it probably lasted just for a very 
>> short period. But I think we all agree that monitoring should catch this, at 
>> least when it extends for several minutes (not necessarily this case).
>> 
>> Regards,
>>   Andrea.
>> 
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>> 
> 



signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

> On Jan 1, 2018, at 2:24 PM, Chris Lambertus <c...@apache.org> wrote:
> 
> Hi folks,
> 
> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
> forum databases to a new server. The forums will be offline during this 
> process, and is expected to take about 2 hours.
> 
> -Chris
> ASF Infra
> 
> 


Hi all,

This move has been completed. Spot checks on the forums look good.

-Chris



signature.asc
Description: Message signed with OpenPGP

ooo-forums downtime

[Chris Lambertus]

Hi folks,

At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
forum databases to a new server. The forums will be offline during this 
process, and is expected to take about 2 hours.

-Chris
ASF Infra




signature.asc
Description: Message signed with OpenPGP

Re: ooo-forums downtime

[Chris Lambertus]

> On Jan 1, 2018, at 2:46 PM, Andrea Pescetti <pesce...@apache.org> wrote:
> 
> Chris Lambertus wrote:
>> At 0100 UTC on Thursday January 4th, I will be moving the OpenOffice PHPBB 
>> forum databases to a new server.
> 
> Can you elaborate more, or tell us what the best place for further 
> discussions is?


This is ONLY to move the back-end MySQL database onto a new box. The 
application server itself won’t be touched except for a one-line change in 
/var/lib/phpBB/com309/localDB.php to change the IP address of the MySQL 
back-end.  The software and server itself won’t be changed otherwise. There is 
still a project in the works to migrate and upgrade the machine as you stated 
in https://issues.apache.org/jira/browse/INFRA-13281. That hasn’t changed, and 
is completely unrelated to the database move on Thursday. Gavin or someone else 
from the Infra team will be in communication with you once we are ready to move 
forward with that aspect of the system move.

-Chris



signature.asc
Description: Message signed with OpenPGP

Re: Wiki website Warning: Potential Security Risk Ahead

[Chris Lambertus]

> On Apr 3, 2019, at 3:22 AM, FR web forum  wrote:
> 
> https://wiki.services.openoffice.org/
> The certificate presented by the website is not valid 
> Error: SSL_ERROR_BAD_CERT_DOMAIN


This machine is the responsibility of the OpenOffice project.

-Chris



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

Fwd: Revieving documentaion

[Chris Lambertus]

Not acked


> Begin forwarded message:
> 
> From: Sharon Jameson 
> Subject: Revieving documentaion
> Date: November 30, 2019 at 12:40:03 PM PST
> To: "webmas...@apache.org" 
> 
> Dear Sirs, 
> 
> I created a document on Open Office and my computer crashed. When I 
> reinstalled the program on my new computer I lost all of my projects that I 
> had created on Open Office on my old computer.  The only one that really 
> concerns me is a document titled Prescription List which lists my husbands 
> prescription, hospital visits  and list of his doctors.  Is there any way at 
> all that you can retrieve this information?  I love your product and with my 
> husbands bad health it has proven itself to be invaluable. 
> 
> Thank you so much
> 
> Mary Jamson
> 1737 Maple St
> Granite City Il 62040

translate.apache.org updates

[Chris Lambertus]

All,

In cooperation with the OpenOffice project, Infra has deployed an updated 
version of the Pootle translate system. The official translate.apache.org 
 site will be transitioning to this new system 
approximately 1600 UTC 24 March. Please contact Infra if any issues arise with 
the system after the transition tomorrow.

Special thanks to Mechtilde Stehmann, Ariel Constenla-Haile, and Matthias 
Seidel from OpenOffice for their patience and assistance in this upgrade and 
transition process.

-Chris
ASF Infra