FUDforum: Plugins and Code Hacks » Database host:port support

Home » FUDforum Development » Plugins and Code Hacks » Database host:port support

Show: Today's Messages :: Polls :: Message Navigator

Database host:port support [message #163964]

Fri, 17 December 2010 12:57

mguillaume

Messages: 13
Registered: December 2010

Karma:

Junior Member

Right now we don't have support for non-standard db ports (at least in PostgreSQL) though the GLOBALS_HELP suggest we should be able to use the "host:port" notation for the db host.

Suggestion: in data/sql/pgsql/db.inc, replace:

if ($GLOBALS['DBHOST']) {
    $connect_str .= 'host='. $GLOBALS['DBHOST'];
}

with:

if ($GLOBALS['DBHOST']) {
    $hostport=explode(":",$GLOBALS['DBHOST']);
    if (count($hostport)==1) {
        $connect_str .= 'host='. $GLOBALS['DBHOST'];
    } else {
        $connect_str .= 'host='.$hostport[0].' port='.$hostport[1];
    }
}

Note that this probably should be improved upon to support IPv6 addresses (which include ':' in their notation).

Report message to a moderator

[Message index]

		Database host:port support By: mguillaume on Fri, 17 December 2010 12:57
		Re: Database host:port support By: naudefj on Sat, 18 December 2010 23:19
		Re: Database host:port support By: Ernesto on Sun, 19 December 2010 04:46
		Re: Database host:port support By: naudefj on Sun, 19 December 2010 05:09
		Re: Database host:port support By: naudefj on Sun, 19 December 2010 14:17

Previous Topic:	Suggestion for the "rebuild search index" page
Next Topic:	Logging Group Manager actions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 17 16:12:59 GMT 2025

Total time taken to generate the page: 0.18477 seconds