Mac OS Forge Migration update

[Ryan Schmidt]

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
>> 
>> 
>>> On Mar 13, 2014, at 18:08, Shreeraj Karulkar <skarulkar at apple.com> wrote:
>>> 
>>> Hello All
>>> 
>>> Following issues are still pending.
>>> 
>>> 1. data.macports.org has been inaccessible since yesterday 03/12/2014  around 7.30 PM or so when Ryan Schmidt first reported failure on trac.macports. Apparently a change was put in yesterday while took the entire Macports Internal VLAN off limits.
>>> A ticket was opened last night and and they are supposed to fix it this evening around 7 PM PST. <exp2://Ticket/18428970> DC Network Internal: VLAN connectivity to Mac OS Forge servers
>>> 
>>> 2. Build-slaves could not be moved to the new VLAN due to lack of resources on the Xerves and and request as been put to open ports on the old VLAN.  The original ETA was for tomorrow 3/14/2014 but I just checked that they will be doing this tonight as well. <exp2://Ticket/18420429> FireWall Rules for Mac OS Forge (Macports Build-Slaves)
>>> 
>>> If you see other issues related to the migration please reply to this email chain. I would appreciate if you  can forward this email to people who are not on this list but may need to know. 
>>> Thanks.
>>> 
>>> Shree