phpBB QuickInstall

Broken install with postgreSQL, unable to view documents - phpBB QuickInstall

Broken install with postgreSQL, unable to view documents

by Lady_G » Tue Mar 21, 2017 3:03 am

Installing as localhost for the first time, I encountered an error installing a phpBB 3.2.0 test board.

Code: Select all

The pgsql dbms is either not supported, or the php extension for it could not be loaded.

BACKTRACE

FILE: [ROOT]/includes/qi_functions.php
LINE: 533
CALL: trigger_error()

FILE: [ROOT]/modules/qi_manage.php
LINE: 75
CALL: db_connect()

FILE: [ROOT]/includes/functions_module.php
LINE: 52
CALL: qi_manage->__construct()

FILE: [ROOT]/index.php
LINE: 296
CALL: module_handler->load()
The connection is working, as I am running separate phpBB 3.1.10 and 3.2.0 databases on this same PC with postgreSQL and unique database names. I am also unable to delete this board due to the same error.

Separately, I am unable to view the "Documentation" and "About" tabs, which display these errors:

Code: Select all

[QI Debug] PHP Warning: in file /var/www/html/quickinstall-1.2.4/modules/qi_about.php on line 27: include(./includes/ParseDown.php): failed to open stream: No such file or directory
[QI Debug] PHP Warning: in file /var/www/html/quickinstall-1.2.4/modules/qi_about.php on line 27: include(): Failed opening './includes/ParseDown.php' for inclusion (include_path='.:/opt/remi/php56/root/usr/share/pear:/opt/remi/php56/root/usr/share/php:/usr/share/pear:/usr/share/php')
[QI Debug] PHP Warning: in file /var/www/html/quickinstall-1.2.4/modules/qi_about.php on line 28: qi_about::__construct(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone.
My PHP 5.6 installation is from a separate Fedora repo, but it works fine with my other phpBB installs.

Environment info:

Code: Select all

PostgreSQL 9.5.6 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit
PHP Version 5.6.29
`boards/`, `cache/` and `settings/` are writable by my web server. apache is the owner with write permissions.

How can this be debugged?
Lady_G
Registered User
Posts: 204
Joined: Fri Jun 08, 2012 12:38 pm
Location: US
Contact:

Re: Broken install with postgreSQL, unable to view documents

by VSE » Tue Mar 21, 2017 6:00 am

As far as postgresql goes, it's a disaster. Use MySQL instead if you can.

The other issue can and will be fixed later.
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4710
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: Broken install with postgreSQL, unable to view documents

by Lady_G » Wed Mar 22, 2017 1:15 am

Yes, I have MySQL. After some experimentation, I was able to create a populated board. As I am unable to view the Documentation tab, I assume it contains the contents of the readme.md file.

I had some difficulty to follow the control panel text descriptions. I created my board by:

1. Create the database as 'database prefix_' + database name. For example, qi_phpbb320.
2. Create a user and grant all rights to this database.
3. In the Boards tab, enter the database name only. For example, phpbb320.

Can you please modify the text descriptions?

The Boards tab entry of Board database and directory name:* is asking for two items in a single field. Can this be changed to:

Code: Select all

Board database name:*
Enter the database name without the prefix.
In the Profiles tab, can Database prefix:* be changed from:

Code: Select all

Database prefix:*
This is added before all database names to avoid overwriting databases not used by QuickInstall.
To:

Code: Select all

Database prefix:*
This is added before all database names to avoid overwriting databases not used by QuickInstall. A database will be created using this prefix. For example, qi_phpbb. The database user must have all rights to this database.
Let me know if you'd like this submitted as a github issue.
VSE wrote: As far as postgresql goes, it's a disaster. Use MySQL instead if you can.

The other issue can and will be fixed later.
The disaster is documented: No connection to postgreSQL database

If the other issue will be fixed (broken Documentation and About tabs), I won't submit an issue.
Lady_G
Registered User
Posts: 204
Joined: Fri Jun 08, 2012 12:38 pm
Location: US
Contact:

Re: Broken install with postgreSQL, unable to view documents

by VSE » Wed Mar 22, 2017 5:50 am

Board database name and directory name are not 2 separate things, they are the same thing for quickinstall.
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4710
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: Broken install with postgreSQL, unable to view documents

by Lady_G » Thu Mar 23, 2017 2:08 am

If this is interpreted for the quickinstall environment, then I am missing a basic concept. Can you please provide an example?

I interpret this as "Enter a board database name" AND "Enter a directory name".

====================

The Documentation and About tabs started working when I downloaded your Fix postgresql failures #77 pull request.

On-going discussion is in No connection to postgreSQL database #75
Lady_G
Registered User
Posts: 204
Joined: Fri Jun 08, 2012 12:38 pm
Location: US
Contact: