SMF Support > PostgreSQL and SQLite Support

Problem choosing Database Type!

(1/1)

blessid:
Environment:

Gentoo 10.1 64bit linux
PHP 5.3.6
PostgreSQL 9.0.3
SMF 2.0 RC5


Everything goes smoothly until it needs to connect to the db.
In the install.php script i get to Step 3: Database Settings

It asks for:
Server name
Username
Password
Database name
Table prefix

There is no way to set Database Type: PostgreSQL
(Docs say there should be a dropdown here..?)

If i enter the info and click next i get:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
(Of course, because I'm not using MySQL)..

I tried to edit Settings.php and change $db_type = 'postgresql'; but it automatically changes back to 'mysql' if i run the install.php script again.

Only info i can find says it should be an obvious dropdown, and editing the settings doesn't do anything.  Is PostgreSQL really supported?


-blessid

SlammedDime:
I believe SMF only supports PostgreSQL version 8.

blessid:
I will be happy to downgrade and report my findings, but this recommendation does not address my issue of being unable to choose a Database Type...

blessid:
The downgrade did not, in fact, change my condition of not being able to select PostgreSQL.  For this project i have gone with another forum software, but SMF works well with MySQL and i will continue to enjoy running my other SMF implementations

Thanks for the help regardless

~

Oldiesmann:
Do you have PHP configured with PostgreSQL support? SMF determines whether or not PostgreSQL support is available based on whether or not the pg_connect function exists (and also the PostgreSQL version, but that shouldn't be an issue).

Any version of PostgreSQL 8 or 9 should work fine with SMF.

Navigation

[0] Message Index