Advertisement:

Author Topic: Problem choosing Database Type!  (Read 14880 times)

Offline blessid

  • Newbie
  • *
  • Posts: 3
Problem choosing Database Type!
« on: June 01, 2011, 12:44:15 PM »
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

Offline SlammedDime

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 10,280
  • School of Air Ride
    • matt.zuba on Facebook
    • @mattzuba on Twitter
    • ZubaFitness
Re: Problem choosing Database Type!
« Reply #1 on: June 01, 2011, 12:54:27 PM »
I believe SMF only supports PostgreSQL version 8.
SlammedDime
Former Lead Customizer
BitBucket Projects
GeekStorage.com Hosting
                      My Mods
SimpleSEF
Ajax Quick Reply
Sitemap
more...
                     

Offline blessid

  • Newbie
  • *
  • Posts: 3
Re: Problem choosing Database Type!
« Reply #2 on: June 01, 2011, 01:12:57 PM »
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...

Offline blessid

  • Newbie
  • *
  • Posts: 3
Re: Problem choosing Database Type!
« Reply #3 on: June 01, 2011, 09:57:11 PM »
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

~

Offline Oldiesmann

  • Lead Developer
  • SMF Super Hero
  • *
  • Posts: 24,278
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Problem choosing Database Type!
« Reply #4 on: June 14, 2011, 01:03:04 AM »
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.

Offline yha

  • Newbie
  • *
  • Posts: 1
Re: Problem choosing Database Type!
« Reply #5 on: May 26, 2013, 11:58:07 AM »
I'm having the same issue. PHP *is* configured with PostgreSQL support, but step 2 of the installer doesn't show me an option to choose my DB type at all. If I enter my PostgreSQL database information (username, password, etc), SMF gives me a "Critical Error" with "No such file or directory". I've tried this with both PG 8.x and 9.x. No go.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 63,571
Re: Problem choosing Database Type!
« Reply #6 on: May 26, 2013, 03:29:57 PM »
How do you know it 'is' configured? Does the pg_connect command exist? Considering there are multiple ways it might be configured...
And his eyes have all the seeming of a demon's that is dreaming,
And the lamp-light o'er him streaming throws his shadow on the floor

Offline Oldiesmann

  • Lead Developer
  • SMF Super Hero
  • *
  • Posts: 24,278
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Problem choosing Database Type!
« Reply #7 on: May 27, 2013, 03:26:34 PM »
If SMF isn't giving you an option to choose PostgreSQL, then that likely means the actual (native) PostgreSQL extension is not installed/configured. Remember - SMF will not work with PDO.