My webserver crashed earlier this evening and when it came back, it's complaining that I need to set $wgDBservers in DefaultSettings.php. However, it's set, and set correctly. Database checks out OK with mysqlcheck, I can't figure out where the breakdown is.
Anyrate, exact error at http://ursine.dyndns.org/ I'm a little stumped on where to start even troubleshooting this.
On Dec 23, 2004, at 7:56 PM, Paul Johnson wrote:
My webserver crashed earlier this evening and when it came back, it's complaining that I need to set $wgDBservers in DefaultSettings.php. However, it's set, and set correctly. Database checks out OK with mysqlcheck, I can't figure out where the breakdown is.
Did you upgrade to 1.4 recently? Are you using DB server replication / load balancing?
$wgDBservers (plural) is an array used for multiple-server load balancing configuration, and its format has changed from 1.3 to 1.4.
$wgDBserver (singular) is a string with the hostname for a single db server to connect to.
-- brion vibber (brion @ pobox.com)
On Thursday 23 December 2004 8:13 pm, Brion Vibber wrote:
On Dec 23, 2004, at 7:56 PM, Paul Johnson wrote:
My webserver crashed earlier this evening and when it came back,
it's
complaining that I need to set $wgDBservers in DefaultSettings.php. However, it's set, and set correctly. Database checks out OK with mysqlcheck, I can't figure out where the breakdown is.
Did you upgrade to 1.4 recently? Are you using DB server replication / load balancing?
1.4beta3, yes. No load balancing or any DB voodoo.
$wgDBservers (plural) is an array used for multiple-server load balancing configuration, and its format has changed from 1.3 to 1.4.
$wgDBserver (singular) is a string with the hostname for a single db server to connect to.
I'm just running this on a single server.
On Dec 23, 2004, at 9:59 PM, Paul Johnson wrote:
On Thursday 23 December 2004 8:13 pm, Brion Vibber wrote:
On Dec 23, 2004, at 7:56 PM, Paul Johnson wrote:
complaining that I need to set $wgDBservers in DefaultSettings.php. However, it's set, and set correctly.
[snip]
$wgDBservers (plural) is an array used for multiple-server load balancing configuration, and its format has changed from 1.3 to 1.4.
$wgDBserver (singular) is a string with the hostname for a single db server to connect to.
I'm just running this on a single server.
In that case you probably should not be setting $wgDBservers (plural) at all. You would get the reported error if for instance you have this in LocalSettings.php:
$wgDBservers = array( 'localhost' );
Would you mind reproducing your LocalSettings.php here so we can take a look at what you're doing? (minus passwords and such sensitive material, naturally)
Make sure also that you don't have a mix of files from two versions. Check the include paths, etc.
-- brion vibber (brion @ pobox.com)
On Thursday 23 December 2004 10:59 pm, Brion Vibber wrote:
In that case you probably should not be setting $wgDBservers (plural) at all. You would get the reported error if for instance you have this in LocalSettings.php:
$wgDBservers = array( 'localhost' );
That's not the case here.
Would you mind reproducing your LocalSettings.php here so we can take a look at what you're doing? (minus passwords and such sensitive material, naturally)
Certainly!
Make sure also that you don't have a mix of files from two versions. Check the include paths, etc.
I don't carry over anything but images.
<?php
# This file was automatically generated by the MediaWiki installer. # If you make manual changes, please keep track in case you need to # recreate them later.
$IP = "/var/www/wiki"; ini_set( "include_path", ".:$IP:$IP/includes:$IP/languages" ); require_once( "includes/DefaultSettings.php" );
# If PHP's memory limit is very low, some operations may fail. # ini_set( 'memory_limit', '20M' );
if ( $wgCommandLineMode ) { if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER ) ) { die( "This script must be run from the command line\n" ); } } elseif ( empty( $wgConfiguring ) ) { ## Compress output if the browser supports it if( !ini_get( 'zlib.output_compression' ) ) @ob_start( 'ob_gzhandler' ); }
$wgSitename = "Ursine";
$wgScriptPath = "/wiki"; $wgScript = "$wgScriptPath/index.php"; $wgRedirectScript = "$wgScriptPath/redirect.php";
## If using PHP as a CGI module, use the ugly URLs $wgArticlePath = "/$1"; # $wgArticlePath = "$wgScript?title=$1";
$wgStylePath = "$wgScriptPath/skins"; $wgStyleDirectory = "$IP/skins"; $wgLogo = "$wgStylePath/common/images/wiki.png";
$wgUploadPath = "$wgScriptPath/images"; $wgUploadDirectory = "$IP/images";
$wgEmergencyContact = "webmaster@ursine.dyndns.org"; $wgPasswordSender = "webmaster@ursine.dyndns.org";
$wgDBserver = "localhost"; $wgDBname = "wikidb"; $wgDBuser = "user"; $wgDBpassword = "password"; $wgDBprefix = "";
## To allow SQL queries through the wiki's Special:Askaql page, ## uncomment the next lines. THIS IS VERY INSECURE. If you want ## to allow semipublic read-only SQL access for your sysops, ## you should define a MySQL user with limited privileges. ## See MySQL docs: http://www.mysql.com/doc/en/GRANT.html # # $wgAllowSysopQueries = true; # $wgDBsqluser = "sqluser"; # $wgDBsqlpassword = "sqlpass";
# If you're on MySQL 3.x, this next line must be FALSE: $wgDBmysql4 = $wgEnablePersistentLC = true;
## Shared memory settings $wgUseMemCached = false; $wgMemCachedServers = array(); $wgUseTurckShm = function_exists( 'mmcache_get' ) && php_sapi_name() == 'apache';
## To enable image uploads, make sure the 'images' directory ## is writable, then uncomment this: $wgDisableUploads = false; $wgUseImageResize = true; $wgUseImageMagick = true; $wgImageMagickConvertCommand = "/usr/bin/convert";
## If you have the appropriate support software installed ## you can enable inline LaTeX equations: $wgUseTeX = true; $wgMathPath = "{$wgUploadPath}/math"; $wgMathDirectory = "{$wgUploadDirectory}/math"; $wgTmpDirectory = "{$wgUploadDirectory}/tmp";
$wgLocalInterwiki = $wgSitename;
$wgLanguageCode = "en"; $wgUseLatin1 = false;
$wgProxyKey = "key";
## Default skin: you can change the default skin. Use the internal symbolic ## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook': # $wgDefaultSkin = 'monobook';
## For attaching licensing metadata to pages, and displaying an ## appropriate copyright notice / icon. GNU Free Documentation ## License and Creative Commons licenses are supported so far. $wgEnableCreativeCommonsRdf = true; $wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright $wgRightsUrl = "http://www.gnu.org/copyleft/fdl.html"; $wgRightsText = "GNU Free Documentation License 1.2"; $wgRightsIcon = "${wgStylePath}/common/images/gnu-fdl.png"; # $wgRightsCode = "gfdl"; # Not yet used
?>
On Dec 23, 2004, at 11:39 PM, Paul Johnson wrote:
On Thursday 23 December 2004 10:59 pm, Brion Vibber wrote:
$wgDBservers = array( 'localhost' );
That's not the case here.
Would you mind reproducing your LocalSettings.php here so we can take a look at what you're doing? (minus passwords and such sensitive material, naturally)
Certainly!
I can't reproduce the error with the file you gave. (But I can reproduce it using the line I mention above.)
Make sure that your script files have not been corrupted, or replaced with alternate versions unbeknownst to you. Put in fresh copies of all files to be sure. If using an opcode cache (eg Turck), clear its temporary files if any.
-- brion vibber (brion @ pobox.com)
On Friday 24 December 2004 12:52 am, Brion Vibber wrote:
Make sure that your script files have not been corrupted, or replaced with alternate versions unbeknownst to you. Put in fresh copies of all files to be sure. If using an opcode cache (eg Turck), clear its temporary files if any.
Ah, that did it. rm -r /var/cache/turck-mmcache followed by a mkdir and a chown fixed it. Thank you, Brion, you've been great help!
mediawiki-l@lists.wikimedia.org