So it looks like the user needed to be the postgres DB user, not the
wiki user. That got me to problem #2 running dumpBackup.php...
From the backtrace...
C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki
\maintenance>..\..\..\..\php\php.exe dumpBackup.php --logs
PHP Warning: pg_query(): Query failed: ERROR: relation "revision"
does not exist
LINE 1: ...LECT /* BackupDumper::dump */ MAX(rev_id) FROM
revision ...
^ in C:
\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes\db
\DatabasePost
gres.php on line 580
A database error has occurred
Query: SELECT MAX(rev_id) FROM revision LIMIT 1
Function: BackupDumper::dump
Error: 1 ERROR: relation "revision" does not exist
LINE 1: ...LECT /* BackupDumper::dump */ MAX(rev_id) FROM
revision ...
^
Backtrace:
#0 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes
\db\Database.php(616): DatabasePostgres->reportQueryError('ERROR:
relatio...',
1, 'SELECT MAX(rev...', 'BackupDumper::d...', false)
#1 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes
\db\Database.php(1026): Database->query('SELECT MAX(rev...',
'BackupDumper::d.
..')
#2 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki\includes
\db\Database.php(943): Database->select('revision', 'MAX(rev_id)',
'',
'BackupD
umper::d...', Array)
#3 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki
\maintenance\backup.inc(231): Database->selectField('revision', 'MAX
(rev_id)', '', 'Back
upDumper::d...')
#4 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki
\maintenance\backup.inc(184): BackupDumper->initProgress(8)
#5 C:\Program Files\BitNami WAPPStack\apache2\htdocs\mediawiki
\maintenance\dumpBackup.php(69): BackupDumper->dump(8)
#6 {main}
Any pointers to resolving. It appears the first few tables have _revid
fields. Thx
On Dec 16, 2:29 am, Mike <mikelisa...(a)gmail.com> wrote:
I did not make any PHP configuration changes from the
Bitnami WAPP
stack. I looked at the PHP configuration which loads php_pgsql.dll,
but didn't see separate configurations for CLI and CGI you ask about.
I'm not certain how I tell if the pgsql mod is being loaded for a CLI
usage, except to say the reported error message appears to indicate an
attempt to make a DB connection.
Somebody else seamed to indicate the user/password for this function
was that of the postgres server and not the wiki user. Was that the
right track?
On Dec 16, 1:11 am, Q <overlo...(a)gmail.com> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Mike wrote:
> I'm new to MediaWiki and tried the dumpBackup.php on a WAPP stack
> install. I've set AdminSettings.php user and password to match those
> in LocalSettings.php as described in the manual. I receive the
> following error when executing the script:
> DB connection error: Postgres functions
missing, have you compiled PHP
> with the --with-pgsql option?
> MediaWiki was installed with compiling and
source; strictly dropping
> its source php and running the install scripts from html.
> Is this a well-known installation error? The
MediaWiki is operating as
> expected from the html server.
> Thanks for any pointers.
Does your PHP install have separate configs for
CLI and CGI? Is the
pgsql module being loaded for both?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org/
iEYEAREIAAYFAksoefkACgkQ69PBoSWyJd7+GgCbBe85n5FBFuH7/3YV1niS9dUY
X6MAnisI+4bt0wnPuXEKMS4vZ5dOKhN3
=g8ZG
-----END PGP SIGNATURE-----
_______________________________________________
MediaWiki-l mailing list
MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l