Topic on Project:Support desk

1.23.15 - install.php with postgres

4
Haroun al Mouwahid (talkcontribs)

Hello all (again ^^)

I have had a problem during the packaging of the last MW 1.23.15 LTS. I have dl the 1.23.15 and the 1.26.2 in /opt :

/opt/mediawiki-1.23.15

/opt/mediawiki-1.26.2

and their apache conf :

/etc/apache2/conf.d/mediawiki123.conf (/mediawiki123)

/etc/apache2/conf.d/mediawiki126.conf (/mediawiki126)

.

Posgres is installed and works properly

dpkg -l | grep -E "postgres|pgsql"

php5-pgsql 5.4.34-1+deb.sury.org~precise+2

postgresql 9.1+129ubuntu1

postgresql-9.1 9.1.7-0ubuntu12.04

postgresql-client-9.1 9.1.7-0ubuntu12.04

postgresql-client-common 129ubuntu1

postgresql-common 129ubuntu1

.

Then I did

sudo -u postgres createuser -S -D -R -P -E wikiuser 'wikiuserpass'

sudo -u postgres createdb -O wikiuser wikidb123

sudo -u postgres createdb -O wikiuser wikidb126

.

When I attempt to install MW 1.23.15 (URL : https://my-server.com/mediawiki123/mw-config/index.php) I select :

DBType : PostgreSQL

Database host : localhost

Database port : 5432

Database name : wikidb123

Schema for Mediawiki : mediawiki

Database username : wikiuser

Database password : wikiuserpass

If I try to use the postgres account with no password, I have got this message:

Please enter a password for the new database user: postgres. While it may be possible to create users with no passwords, it is not secure.

.

When I click on continue, I have got a blank page (URL : https://my-server.com/mediawiki123/mw-config/index.php?page=DBConnect) !! Impossible to continue !!

.

With MW 1.26.2 (URL : https://my-server.com/mediawiki126/mw-config/index.php) I select the same options and it's working !!

.

So I tried an automatic install via /opt/mediawiki-1.23.15/maintenant/install.php

php install.php --server localhost --dbuser wikiuser --dbpass wikiuserpass --dbname wikidb123 --dbtype pgsql --dbport 5432 --installdbuser wikiuser --installdbpass wikipass --pass (password of which account is it please ?) --scriptpath /mediawiki123 my-server WikiSysop

PHP 5.4.34-1+deb.sury.org~precise+2 is installed.

Warning: Could not find APC, XCache or WinCache.

Object caching is not enabled.

Found GD graphics library built-in.

Image thumbnailing will be enabled if you enable uploads.

Found the Git version control software: /usr/bin/git.

Using server URL "my-server/mediawiki123".

Warning: Your default directory for uploads (/opt/mediawiki-1.23.15/images/) is not checked for vulnerability

to arbitrary script execution during the CLI install.

Warning: The intl PECL extension is not available to handle Unicode normalization, falling back to slow pure-PHP implementation.

If you run a high-traffic site, you should read a little on Unicode normalization.

The environment has been checked.

You can install MediaWiki.

PHP Fatal error:  Class 'PgsqlInstaller' not found in /opt/mediawiki-1.23.15/includes/installer/Installer.php on line 493

If I try "--dbtype postgres" , same message but at the end :

PHP Fatal error: Class 'Database' not found in /opt/mediawiki-1.23.15/includes/installer/PostgresInstaller.php on line 161

Sorry but could you help me again ? I have to use a 1.23.15 because it's a LTS or do you think a can use the 1.26.2 (or 1.26.4, works fine as well) ??

87.123.33.228 (talkcontribs)

You are trying to install MediaWiki 1.23.15, but in the Installer when you provide PostgreSQL as your database type, you are getting a blank screen.

According to your error

PHP Fatal error: Class 'PgsqlInstaller' not found in /opt/mediawiki-1.23.15/includes/installer/Installer.php on line 493

and to the code, you have type=Pgsq. This value is wrong. You have to use type=postgres instead, then it will at least point to an existing PHP file.

For the error

Class 'Database' not found in /opt/mediawiki-1.23.15/includes/installer/PostgresInstaller.php on line 161

I am not sure currently. I guess that this class should be there as it should get autoloaded...

Haroun al Mouwahid (talkcontribs)

I did already test postgres or pgsql with --dbtype. Thank you anyway for your response :)

87.123.33.228 (talkcontribs)
Reply to "1.23.15 - install.php with postgres"