DB Port Change: Possible?

Having trouble installing serendipity?
Post Reply
genesis
Regular
Posts: 28
Joined: Wed Jun 11, 2008 5:26 pm

DB Port Change: Possible?

Post by genesis »

I have a desire to use an aggregator for Postgres called "pgpool"; this requires that I change the connection port for Seredipity from its standard.

The change is transparent to the application other than the need for a custom port number.

I don't see a port field in the configuration area, however.

Is there a way to specify this, do I need to do it by hand, and if the latter, where would that be in the configuration files?

Thanks in advance!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: DB Port Change: Possible?

Post by garvinhicking »

Hi!

Usually you should be able to simply specify something like "localhost:4711" into the hostname, so that you can append the portnumber there.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
genesis
Regular
Posts: 28
Joined: Wed Jun 11, 2008 5:26 pm

Re: DB Port Change: Possible?

Post by genesis »

Nope; in serendipity_config_local.inc.php I have:

$serendipity['dbHost'] = 'genesis.denninger.net:55432';

and what I get back is:

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not translate host name "genesis.denninger.net:55432" to address: hostname nor servname provided, or not known in /usr/local/apache2/htdocs/market-ticker/include/db/postgres.inc.php on line 64
serendipity error: unable to connect to database - exiting.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: DB Port Change: Possible?

Post by garvinhicking »

Hi!

Have you tried the PDO-PostgreSQL layer instead, maybe?

Also, using "genesis.denninger.net port=55432" might work.

(I'm not experience with PSQL, so I only speak with mysql knowledge, sorry)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
genesis
Regular
Posts: 28
Joined: Wed Jun 11, 2008 5:26 pm

Re: DB Port Change: Possible?

Post by genesis »

Got it - "genesis.denninger.net port=55432" worked.
Post Reply