Opened 11 years ago

Closed 8 years ago

#40579 closed enhancement (fixed)

convert ports.php and PortIndex2MySQL to PostgreSQL

Reported by: elelay (Eric Le Lay) Owned by: macports-tickets@…
Priority: Normal Milestone:
Component: website Version:
Keywords: haspatch Cc: skarulkar@…, ryandesign (Ryan Carsten Schmidt), mkae (Marko Käning), cooljeanius (Eric Gallager), nerdling (Jeremy Lavergne), raimue (Rainer Müller)
Port:

Description

It has been mentioned in macports-dev that ports.php should move to postgresql.

I've converted trunk/base/portmgr/jobs/PortIndex2MySQL.tcl to PortIndex2PGSQL.tcl. It's been tested and works against postgresql93.

I've converted trunk/www/ports.php and its dependencies to PostgreSQL but not tested it (and I should add that I'm not familiar with php). The localized/xx still contain mysql code but they don't seem to be active so I left them alone.

Attachments (2)

convert_to_postgresql.patch (5.5 KB) - added by elelay (Eric Le Lay) 11 years ago.
switch_ports_php_to_pg.sql (14.5 KB) - added by elelay (Eric Le Lay) 11 years ago.

Download all attachments as: .zip

Change History (15)

Changed 11 years ago by elelay (Eric Le Lay)

Attachment: convert_to_postgresql.patch added

Changed 11 years ago by elelay (Eric Le Lay)

Attachment: switch_ports_php_to_pg.sql added

comment:1 Changed 11 years ago by ryandesign (Ryan Carsten Schmidt)

Cc: ryandesign@… added

Cc Me!

comment:2 Changed 11 years ago by jmroot (Joshua Root)

Cc: wsiegrist@… added
Version: 2.2.0

comment:3 Changed 11 years ago by mkae (Marko Käning)

Cc: mk@… added

Cc Me!

comment:4 Changed 11 years ago by cooljeanius (Eric Gallager)

Cc: egall@… added

Cc Me!

comment:5 Changed 11 years ago by raimue (Rainer Müller)

Cc: raimue@… added

Cc Me!

comment:6 Changed 11 years ago by jmroot (Joshua Root)

Cc: skarulkar@… added

comment:7 Changed 10 years ago by mf2k (Frank Schima)

Owner: changed from jmpp@… to macports-tickets@…

jmpp is no longer active. See #44809.

comment:8 Changed 10 years ago by nerdling (Jeremy Lavergne)

Cc: snc@… added

Another patch includes using transactions and atomic renames: #46111.

comment:9 Changed 10 years ago by jmroot (Joshua Root)

I checked in PortIndex2PGSQL.tcl to portmgr/jobs in r128996.

Shree, could we work on getting this deployed? Some way to test the website changes without pushing them live would be helpful too.

comment:10 Changed 10 years ago by wsiegrist@…

Cc: wsiegrist@… removed

Cc Me!

comment:11 Changed 8 years ago by raimue (Rainer Müller)

Cc: raimue removed

comment:12 Changed 8 years ago by raimue (Rainer Müller)

Cc: raimue added

comment:13 Changed 8 years ago by raimue (Rainer Müller)

Resolution: fixed
Status: newclosed

In 4150e65/macports-www:

Switch to Postgres DB

The authentication is automatically granted based on the UNIX account
running the webserver. No username, password or database name are
required.

Closes #40579

Note: See TracTickets for help on using tickets.