Advertisement:

Author Topic: Missing Database dropdown selection in installer  (Read 4544 times)

Offline interiorfamily

  • Newbie
  • *
  • Posts: 4
Missing Database dropdown selection in installer
« on: December 20, 2016, 05:52:58 AM »
Hello everyone!  I've downloaded  two different versions (2-0-12 tarball and 2-0-12 zip) with the same result.  I have created a PostgreSQL database and user.  When I get to step 3 (attached screenshot) the database type drop down list is MISSING!! So, it is seems to be detecting mysql but doesn't detect my PostgreSQL installation which does exist.  I don't know if this is a bug however without the dropdown I can't use PostgreSQL.  Hopefully someone can assist me with this issue as I really do want to use this forum system for my businesses! :)

 

Offline ziycon

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,692
  • Gender: Male
Re: Missing Database dropdown selection in installer
« Reply #1 on: December 20, 2016, 06:55:17 AM »
Are you sure that your PHP configuration is picking up PostgreSQL configuration, if you run phpinfo(); do you see PostgreSQL listed?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,498
  • Gender: Male
    • Kindred-999 on GitHub
Re: Missing Database dropdown selection in installer
« Reply #2 on: December 20, 2016, 09:31:25 AM »
Also, out of curiosity  it you have mySQL, why are you trying to use PostgreSQL?

(Although supported by the core product, some mods will not work on Postgre and mySQL receives better, overall, support)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline albertlast

  • Development Contributor
  • Full Member
  • *
  • Posts: 589
Re: Missing Database dropdown selection in installer
« Reply #3 on: December 20, 2016, 10:20:34 AM »
Here the short information:
when smf 2.0 find only one database driver (like pg_connect) it doesn't  show the selected database
when you use not the default port(5432) of pg than you need to change code in Subs-Db-postgresql.php line 56 and 58:
password=\'' . $db_passwd . '\'');
->
password=\'' . $db_passwd . '\' port=\'<your_port>\'');


a good reason for pg it's run with php 7.0+

but to be honest the big support for pg is coming with smf 2.1

Offline interiorfamily

  • Newbie
  • *
  • Posts: 4
Re: Missing Database dropdown selection in installer
« Reply #4 on: December 20, 2016, 11:07:34 PM »
I realize the issue now.  I had installed PostgreSQL in a manner in which PHP was not detected.  In a real sense I am glad I see the error of my way, on the other hand This does bring me back to questioning myself.  This install is temporarily suspended until either I resolve the PostgreSQL issue or simply install with a MySQL database.  Decisions...

After reading everyone's responses.. I will use a MySQL db for the fora (what I am calling my forums...)

Thank you  all for your responses.
   

Offline interiorfamily

  • Newbie
  • *
  • Posts: 4
Re: Missing Database dropdown selection in installer
« Reply #5 on: December 22, 2016, 06:29:14 PM »
Hello! I decided to use my mariaDb/MySQL and installed my Board!  It is up and running.  I do have a few things to work out now that I overcame some frustrations.

Offline interiorfamily

  • Newbie
  • *
  • Posts: 4
Re: Missing Database dropdown selection in installer
« Reply #6 on: December 23, 2016, 04:51:14 PM »
I want to thank everyone graciously for their valuable input on this topic.  My whole issue was that I installed PostgreSQL outside of my cPanel and I have added PostgreSQL to cPanel what I failed to do and still haven't done is add PostgreSQL to PHP.  So to work around this, I chose to add a mariadb (mySQL) database and user through my cPanel and was able to complete my now operational forum.  If anyone is interested and I don't violate the forum rules, I will link that here or I can post that elsewhere or a mod can edit this post and move that to an appropriate place. 

My forum (aka The Interior Family Fora) is hxxp:interiorfamily.net/forahere [nonactive]

Thank you again,

Interior Family