Mac OS Forge Migration update

[Ryan Schmidt]

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