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.
-----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?
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...@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
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...@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...@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
On 12/16/2009 02:50 AM, Mike wrote:
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...
No, it needs to run as the same user as in LocalSettings.php. That's almost certainly the cause of the latest error.
Greg,
The postgres DB connect fails without using the postgres DB user for dumpBackup.php. Its clear that this 2nd problem is not encountered until a DB connection is made during backup.
On Dec 16, 10:02 am, Greg Sabino Mullane g...@endpoint.com wrote:
On 12/16/2009 02:50 AM, Mike wrote:
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...
No, it needs to run as the same user as in LocalSettings.php. That's almost certainly the cause of the latest error.
-- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 0x14964AC8
signature.asc < 1KViewDownload
MediaWiki-l mailing list MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Mike wrote:
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...
Do you have $wgDBmwschema specified in LocalSettings.php?
Sean,
This defaulted to $wgDBmwschema = "mediawiki"; in LocalSettings.php and the wiki runs fine from the html server.
On Dec 16, 10:54 am, Sean McAfee smca...@collaborativefusion.com wrote:
Mike wrote:
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...
Do you have $wgDBmwschema specified in LocalSettings.php?
-- Sean McAfee Senior Systems Engineer
MediaWiki-l mailing list MediaWik...@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org