Mac OS Forge Migration update

[Shreeraj Karulkar]

Ryan

1) MySQL database: I have enabled access from the www.macports server and tested access successfully. Restarted mysqld on the data server and restarted httpd on the www server. I still can’t get to https://www.macports.org/ports.php. There is something missing that I can’t figure out.

2) Ping issue: I have reopened the ticket which IS&T had resolved earlier. <exp2://Ticket/18419273> 3/17 FireWall Rules for Mac OS Forge - ICMP . Will let you know as soon as I find out.

3) Buildbot/Slaves: While all the build-slaves seem to be compiling fine you are probably referring to the deploy_archives.sh is failing for Mavericks right? I have tried send a file via rsync with similar options (-rlDzv) from build.macports to rsync.macports and it went through successfully. I also did a su to user buildbot and sent a test file through successfully. It did prompt me to accept the RSA key though. Can you check if it has worked?
There is also a reference to use -e in the rsync options to pass ssh options like the "--ignore-existing” optionthat is being used in the script. However the script has not changed 2013 so I am not sure it thats an issue.

I am still working on this and would appreciate any clues from anyone, sorry for the delay in the resolution of these issues.
 
Shree

On Mar 17, 2014, at 5:58 AM, Ryan Schmidt <ryandesign at macports.org> wrote:

> Could we get a status update on these remaining migration issues:
> 
> * MySQL database for web site offline or inaccessible
> * Online http servers not responding to pings
> * Buildbot/buildslaves not working
> 
> Thanks.
> 
> -Ryan
> 
> 
> On Mar 15, 2014, at 06:10, Ryan Schmidt <ryandesign at macports.org> wrote:
> 
>> Thanks. The two pages are now responding without the 21-second delay, but still say the database is offline.
>> 
>> Also, we still have no responses to pings to distfiles.macports.org and packages.macports.org (though web services are functioning correctly).
>> 
>> 
>> On Mar 14, 2014, at 01:46, Shreeraj Karulkar <skarulkar at apple.com> wrote:
>> 
>>> Ryan 
>>> I have put a request for the MySQL ports. We missed those while focusing on PSQL ports. We should be good by tomorrow evening. 
>>> Shree
>>> 
>>> 
>>> Sent from my iPhone
>>> 
>>>> On Mar 13, 2014, at 11:14 PM, Ryan Schmidt <ryandesign at macports.org> wrote:
>>>> 
>>>> Shree:
>>>> 
>>>> A gentle reminder:
>>>> 
>>>> Another outstanding issue for us is the MySQL database on the web site.
>>>> 
>>>> It feeds the ports page at:
>>>> 
>>>> https://www.macports.org/ports.php
>>>> 
>>>> The database server is either not running or is not accessible to the web server, so the ports page displays only the message “Our database is currently unavailable. We hope to have it back soon!” It also waits 21 seconds before displaying that message, suggesting some kind of network timeout.
>>>> 
>>>> The database is also queried on the homepage to display the total number of ports in the database:
>>>> 
>>>> https://www.macports.org/
>>>> 
>>>> This too takes 21 seconds before giving up and finally loading the page without the count.
>>>> 
>>>> If getting the MySQL database back online will take some time, I can modify the homepage to remove the database connection to at least get our homepage displaying speedily again.
>>>> 
>>>> 
>>>> Note that work was already done to convert the MySQL database to PostgreSQL, as Bill had hinted we should do some time ago:
>>>> 
>>>> https://trac.macports.org/ticket/40579
>>>> 
>>>> I have also done some thus-far unpublished work in this area and would be happy to help with getting this online, if this would be easier than getting the old MySQL server running again.
>>>> 
>>>> -Ryan