[#CONTRIB-340] MRBS block: add support for Postgresql database

Issue Details (XML | Word | Printable)

Key:	CONTRIB-340
Type:	New Feature
Status:	Resolved
Resolution:	Fixed
Priority:	Major
Assignee:	Anthony Borrow
Reporter:	Anthony Borrow
Votes:	1
Watchers:	1

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Non-core contributed modules

MRBS block: add support for Postgresql database

Created: 19/Mar/08 04:27 AM Updated: 10/Aug/08 02:35 AM

Return to search

Component/s:

Block: Mrbs

Affects Version/s:

1.8

Fix Version/s:

None

Database:	PostgreSQL
Participants:	Anthony Borrow and Stephen Bourget
Security Level:	None
QA Assignee:	Stephen Bourget
Resolved date:	10/Aug/08
Affected Branches:	MOODLE_18_STABLE

Description

« Hide

It would be nice to make the MRBS block support usage of the postgresql database (requested by Barbara Lawrence).

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

Stephen Bourget added a comment - 10/Aug/08 01:23 AM

I think this may have been resolved by ~~CONTRIB-623~~, since the install.xml will create the DB structures under postgresql, and $CFG->dbtype will tell MRBS that it is using postgresql

-Steve

[ Permalink | « Hide ]

Anthony Borrow added a comment - 10/Aug/08 01:32 AM

Yep, I would still ideally like to see that we could get rid of the various database files mysql.php, mysqli.php and pgsql.php; however, I suspect that project will have to wait until my next break. Peace - Anthony

arborrow committed 2 files to 'Contrib CVS' - 10/Aug/08 02:32 AM

~~CONTRIB-340~~ - enable postgres support for MRBS block including support for customized ports, renamed MRBS pgsql.php to Moodle's postgres7.php

ADD	plugins/blocks/mrbs/web/postgres7.php		Rev. 1.1		(+0 -0 lines)
DEL	plugins/blocks/mrbs/web/Attic/pgsql.php		Rev. 1.4		(+0 -0 lines)

[ Permalink | « Hide ]

Anthony Borrow added a comment - 10/Aug/08 02:35 AM

Steve - OK, I managed to test it with postgres and it seems to be working with the latest commit. I renamed pgsql.php to postgres7.php since that is the driver name that Moodle uses. I also added in some checks to see if there was a custom port which in my case there was so I think it is working and will go ahead and resolve this. Peace - Anthony

Anthony Borrow made changes - 10/Aug/08 02:35 AM

Field	Original Value	New Value
QA Assignee		sbourget
Status	Open [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

All content on this web site is made available under the GNU General Public License, unless otherwise stated.