SMF Development > Bug Reports

No support for PostgreSQL running on nonstandard port

(1/1)

c2h5oh:
smf_db_initialize does not take into account that PostgreSQL might be running on nonstandard port.
To get through setting up the db during the installation you have to smuggle port parameter in db hostname - 'hostname port=your_port', but it makes installer fail on setting up the admin account for some reason, despite db being populated in a step before and the forum itself working. this part is me being blind (failed to notice db password field in the form), but the main issue remains the same - it still requires a fix or at least a very large, visible notification during installation: you can't expect user to know pg_connect parameter syntax to be able to be able to install SMF.

N. N.:
Thank you for the report. Indeed, the installer does not support specifying the port, for any database system, in an user-friendly way. While for MySQL that may be less of an issue, since the syntax is well known, for other database systems it may be more relevant.

c2h5oh:
MySQL uses a de facto standard syntax for host & port pair - exactly the same as with urls: host:port - this is relatively easy to guess for those moderately computer literate. In case of PostgreSQL I was only able to do it because I know pg_connect syntax and only after I have checked what is done with host variable in code - was it validated in any way I would have been forced to hack around the code (I am pretty sure validation would drop anything with a space inside..)

I really recommend port field to be added to the installer.

Joshua Dickerson:
Anyone know if this was reported? Seems like an easy fix.

Navigation

[0] Message Index