Last modified: 2010-05-15 15:38:14 UTC
I created a mediawiki installation. All went well. Then I tried to create a second installation. I copied the files from the original tarball, set the permissions, set the database owner as before, used a different prefix for the tables... and got an error that the user root had no access. So I removed the root mySqL password and got faryther, but with an error that the transcache table could not be created (and suddenly my db user did not have create access). So I set the password for root again and got farther. All tables created (I think) and the message # Finished update checks. Creating LocalSettings.php... Installation successful! Move the config/LocalSettings.php file into the parent directory, then follow this link to your wiki. Except that there is no such file config/LocalSettings.php So I copied the one from the previous installation tree and manually edited the lines that differ. but I am REALLY CONFUSED :-(
Oops. Sorry. I DO have the LocalSettings file. All the rest was a prolem but I do have the file.
Read the installer page a little more carefully. If the database user does not exist or have access to create tables, MediaWiki will attempt to use a specified superuser account. To indicate that this should not be the case, leave the superuser password set to -, which is the default. Closing WORKSFORME.
He says, hitting the wrong button...reopening to correct resolution.
You're missing the point. I read the page very carefully. MySQL did not read the instructions at all. The database existed. I therefore didn't set the root password. Everything worked up to the point opf the transcache table and then, suddenly, my user stopped having authorization. It was a right royal mess.
In otherwords, following the instructions didn't work because MySQL kept blowing up
mySQL complained that the user used to connect to the database didn't have create permissions? Had the installer attempted to create tables prior to that point? Did said user, in fact, have those permissions?
That's the weird part. As I said in the original report, I created a mediawiki installation. All went well. Then I tried to create a second installation. I used the same MySQL user (created by the previous installation) and the same database (created by the previous installation) with a different table prefix. The first time I tried this, "root" didn't have privs. I tried again w/o root. The second time, the user worked fine until it was time to create the transcache table; then, suddenly and inexplicably, the user no longer had create table privs. I tried again with root. This time all went through to the end. I never meant to imply this was an easy problem with a quick solution :-) Did the user have permission? Yes, until it no longer had permission. Don't ask me why the privs went away; I haven't a cluse. The database, the user, and the GRANT Privileges etc... were all performed by the mediawiki installation (the first one).
I don't reall y care if it works for you. Here's a sample in a Brand New installation First, it ran like this: MediaWiki 1.5.6 installation Checking environment... * PHP 4.3.9: ok * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP is configured with no memory_limit. * No zlib support. * Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions * GNU diff3 not found. * Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be enabled if you enable uploads. * Installation directory: /ad4/ENV/cfcl/usr_local/Server/WWW/web/technofile/mediawiki * Script URI path: /mediawiki * Connecting to tf_wikidb on localhost as root...success. * Connected to 4.1.7-standard; using enhancements for mySQL 4. * Created database tf_wikidb * Creating tables... using MySQL 3/4 table defs... done. * Initializing data...A database error has occurred Query: SELECT user_id FROM `tf_user` WHERE user_name = 'WikiSysop' LIMIT 1 Function: User::idFromName Error: 1142 select command denied to user 'wikiuser'@'localhost' for table 'tf_user' (localhost) Backtrace: GlobalFunctions.php line 451 calls wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php line 347 calls databasemysql::reportqueryerror() Database.php line 723 calls databasemysql::query() Database.php line 742 calls databasemysql::select() User.php line 150 calls databasemysql::selectrow() User.php line 74 calls user::idfromname() index.php line 645 calls user::newfromname() Then I tried again: Checking environment... * PHP 4.3.9: ok * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP is configured with no memory_limit. * No zlib support. * Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions * GNU diff3 not found. * Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be enabled if you enable uploads. * Installation directory: /ad4/ENV/cfcl/usr_local/Server/WWW/web/technofile/mediawiki * Script URI path: /mediawiki * Connecting to tf_wikidb on localhost as root...success. * Connected to 4.1.7-standard; using enhancements for mySQL 4. * Database tf_wikidb exists * There are already MediaWiki tables in this database. Checking if updates are needed... * DB user account ok ...hitcounter table already exists. ...querycache table already exists. ...objectcache table already exists. ...categorylinks table already exists. ...logging table already exists. ...validate table already exists. ...user_newtalk table already exists. Creating transcache table...ok ...trackbacks table already exists. ...have ipb_id field in ipblocks table. ...have ipb_expiry field in ipblocks table. ...have rc_type field in recentchanges table. ...have rc_ip field in recentchanges table. ...have rc_id field in recentchanges table. ...have rc_patrolled field in recentchanges table. ...have user_real_name field in user table. ...have user_token field in user table. ...have user_email_token field in user table. ...have log_params field in logging table. ...have ar_rev_id field in archive table. ...have ar_text_id field in archive table. ...have page_len field in page table. ...have rev_deleted field in revision table. ...have img_width field in image table. ...have img_metadata field in image table. ...have img_media_type field in image table. ...have val_ip field in validate table. ...have ss_total_pages field in site_stats table. ...have iw_trans field in interwiki table. ...already have interwiki table ...indexes seem up to 20031107 standards Already have pagelinks; skipping old links table updates. ...image primary key already set. The watchlist table is already set up for email notification. ...user table does not contain old email authentication field. Logging table has correct title encoding. ...page table already exists. revision timestamp indexes already up to 2005-03-13 ...rev_text_id already in place. ...page_namespace is already a full int (int(11)). ...ar_namespace is already a full int (int(11)). ...rc_namespace is already a full int (int(11)). ...wl_namespace is already a full int (int(11)). ...qc_namespace is already a full int (int(11)). ...log_namespace is already a full int (int(11)). ...already have pagelinks table. No img_type field in image table; Good. Already have unique user_name index. ...user_groups table already exists. ...user_groups is in current format. Initialising "MediaWiki" namespace... A database error has occurred Query: SELECT page_title,page_is_new,rev_user_text FROM `tf_page`, `tf_revision` WHERE page_namespace=8 AND rev_page=page_id AND page_title IN('1movedto2','1movedto2_redir','Monobook.css','Monobook.js','About','Aboutpage','Aboutsite','Accesskey-compareselectedversions','Accesskey-diff','Accesskey-minoredit','Accesskey-preview','Accesskey-save','Accesskey-search','Accmailtext','Accmailtitle','Acct_creation_throttle_hit','Actioncomplete','Addedwatch','Addedwatchtext','Addgroup','Addgrouplogentry','Addsection','Administrators','Allarticles','Allinnamespace','Alllogstext','Allmessages','Allmessagescurrent','Allmessagesdefault','Allmessagesname','AllmessagesnotsupportedDB','AllmessagesnotsupportedUI','Allmessagestext','Allnonarticles','Allnotinnamespace','Allpages','Allpagesfrom','Allpagesnext','Allpagesprev','Allpagessubmit','Alphaindexline','Already_bureaucrat','Already_steward','Already_sysop','Alreadyloggedin','Alreadyrolled','Ancientpages','And','Anontalk','Anontalkpagetext','Anonymous','Apr','April','Article','Articleexists','Articlepage','Aug','August','Autoblocker','Badaccess','Badaccesstext','Badarticleerror','Badfilename','Badfiletype','Badipaddress','Badquery','Badquerytext','Badretype','Badtitle','Badtitletext','Blanknamespace','Blockedtext','Blockedtitle','Blockip','Blockipsuccesssub','Blockipsuccesstext','Blockiptext','Blocklink','Blocklistline','Blocklogentry','Blocklogpage','Blocklogtext','Bold_sample','Bold_tip','Booksources','Booksourcetext','Brokenredirects','Brokenredirectstext','Bugreports','Bugreportspage','Bureaucratlog','Bureaucratlogentry','Bydate','Byname','Bysize','Cachederror','Cancel','Cannotdelete','Cantrollback','Categories','Categoriespagetext','Category','Category_header','Categoryarticlecount','Categoryarticlecount1','Changed','Changegrouplogentry','Changepassword','Changes','Clearyourcache','Columns','Compareselectedversions','Confirm','Confirmdelete','Confirmdeletetext','Confirmemail','Confirmemail_body','Confirmemail_error','Confirmemail_invalid','Confirmemail_loggedin','Confirmemail_send','Confirmemail_sendfailed','Confirmemail_sent','Confirmemail_subject','Confirmemail_success','Confirmemail_text','Confirmprotect','Confirmprotecttext','Confirmunprotect','Confirmunprotecttext','Contextchars','Contextlines','Contribs-showhideminor','Contribslink','Contribsub','Contributions','Copyright','Copyrightpage','Copyrightpagename','Copyrightwarning','Copyrightwarning2','Couldntremove','Createaccount','Createaccountmail','Createarticle','Created','Creditspage','Cur','Currentevents','Currentevents-url','Currentrev','Currentrevisionlink','Data','Databaseerror','Dateformat','Dberrortext','Dberrortextcl','Deadendpages','Debug','Dec','December','Default','Defaultns','Defemailsubject','Delete','Delete_and_move','Delete_and_move_reason','Delete_and_move_text','Deletecomment','Deletedarticle','Deletedrev','Deletedrevision','Deletedtext','Deleteimg','Deleteimgcompletely','Deletepage','Deletesub','Deletethispage','Deletionlog','Dellogpage','Dellogpagetext','Destfilename','Developertext','Developertitle','Diff','Difference','Disambiguations','Disambiguationspage','Disambiguationstext','Disclaimerpage','Disclaimers','Doubleredirects','Doubleredirectstext','Eauthentsent','Edit','Edit-externally','Edit-externally-help','Editcomment','Editconflict','Editcurrent','Editgroup','Edithelp','Edithelppage','Editing','Editingcomment','Editingold','Editingsection','Editsection','Editthispage','Editusergroup','Email','Emailauthenticated','Emailconfirmlink','Emailflag','Emailforlost','Emailfrom','Emailmessage','Emailnotauthenticated','Emailpage','Emailpagetext','Emailsend','Emailsent','Emailsenttext','Emailsubject','Emailto','Emailuser','Emptyfile','Enotif_body','Enotif_lastvisited','Enotif_mailer','Enotif_newpagetext','Enotif_reset','Enotif_subject','Enterlockreason','Error','Errorpagetitle','Exbeforeblank','Exblank','Excontent','Excontentauthor','Exif-aperturevalue','Exif-artist','Exif-bitspersample','Exif-brightnessvalue','Exif-cfapattern','Exif-colorspace','Exif-colorspace-1','Exif-colorspace-ffff.h','Exif-componentsconfiguration','Exif-componentsconfiguration-0','Exif-componentsconfiguration-1','Exif-componentsconfiguration-2','Exif-componentsconfiguration-3','Exif-componentsconfiguration-4','Exif-componentsconfiguration-5','Exif-componentsconfiguration-6','Exif-compressedbitsperpixel','Exif-compression','Exif-compression-1','Exif-compression-6','Exif-contrast','Exif-contrast-0','Exif-contrast-1','Exif-contrast-2','Exif-copyright','Exif-customrendered','Exif-customrendered-0','Exif-customrendered-1','Exif-datetime','Exif-datetimedigitized','Exif-datetimeoriginal','Exif-devicesettingdescription','Exif-digitalzoomratio','Exif-exifversion','Exif-exposurebiasvalue','Exif-exposureindex','Exif-exposuremode','Exif-exposuremode-0','Exif-exposuremode-1','Exif-exposuremode-2','Exif-exposureprogram','Exif-exposureprogram-0','Exif-exposureprogram-1','Exif-exposureprogram-2','Exif-exposureprogram-3','Exif-exposureprogram-4','Exif-exposureprogram-5','Exif-exposureprogram-6','Exif-exposureprogram-7','Exif-exposureprogram-8','Exif-exposuretime','Exif-filesource','Exif-filesource-3','Exif-flash','Exif-flashenergy','Exif-flashpixversion','Exif-fnumber','Exif-focallength','Exif-focallengthin35mmfilm','Exif-focalplaneresolutionunit','Exif-focalplaneresolutionunit-2','Exif-focalplanexresolution','Exif-focalplaneyresolution','Exif-gaincontrol','Exif-gaincontrol-0','Exif-gaincontrol-1','Exif-gaincontrol-2','Exif-gaincontrol-3','Exif-gaincontrol-4','Exif-gpsaltitude','Exif-gpsaltituderef','Exif-gpsareainformation','Exif-gpsdatestamp','Exif-gpsdestbearing','Exif-gpsdestbearingref','Exif-gpsdestdistance','Exif-gpsdestdistanceref','Exif-gpsdestlatitude','Exif-gpsdestlatituderef','Exif-gpsdestlongitude','Exif-gpsdestlongituderef','Exif-gpsdifferential','Exif-gpsdirection-m','Exif-gpsdirection-t','Exif-gpsdop','Exif-gpsimgdirection','Exif-gpsimgdirectionref','Exif-gpslatitude','Exif-gpslatitude-n','Exif-gpslatitude-s','Exif-gpslatituderef','Exif-gpslongitude','Exif-gpslongitude-e','Exif-gpslongitude-w','Exif-gpslongituderef','Exif-gpsmapdatum','Exif-gpsmeasuremode','Exif-gpsmeasuremode-2','Exif-gpsmeasuremode-3','Exif-gpsprocessingmethod','Exif-gpssatellites','Exif-gpsspeed','Exif-gpsspeed-k','Exif-gpsspeed-m','Exif-gpsspeed-n','Exif-gpsspeedref','Exif-gpsstatus','Exif-gpsstatus-a','Exif-gpsstatus-v','Exif-gpstimestamp','Exif-gpstrack','Exif-gpstrackref','Exif-gpsversionid','Exif-imagedescription','Exif-imagelength','Exif-imageuniqueid','Exif-imagewidth','Exif-isospeedratings','Exif-jpeginterchangeformat','Exif-jpeginterchangeformatlength','Exif-lightsource','Exif-lightsource-0','Exif-lightsource-1','Exif-lightsource-10','Exif-lightsource-11','Exif-lightsource-12','Exif-lightsource-13','Exif-lightsource-14','Exif-lightsource-15','Exif-lightsource-17','Exif-lightsource-18','Exif-lightsource-19','Exif-lightsource-2','Exif-lightsource-20','Exif-lightsource-21','Exif-lightsource-22','Exif-lightsource-23','Exif-lightsource-24','Exif-lightsource-255','Exif-lightsource-3','Exif-lightsource-4','Exif-lightsource-9','Exif-make','Exif-make-value','Exif-makernote','Exif-maxaperturevalue','Exif-meteringmode','Exif-meteringmode-0','Exif-meteringmode-1','Exif-meteringmode-2','Exif-meteringmode-255','Exif-meteringmode-3','Exif-meteringmode-4','Exif-meteringmode-5','Exif-meteringmode-6','Exif-model','Exif-model-value','Exif-oecf','Exif-orientation','Exif-orientation-1','Exif-orientation-2','Exif-orientation-3','Exif-orientation-4','Exif-orientation-5','Exif-orientation-6','Exif-orientation-7','Exif-orientation-8','Exif-photometricinterpretation','Exif-photometricinterpretation-1','Exif-photometricinterpretation-6','Exif-pixelxdimension','Exif-pixelydimension','Exif-planarconfiguration','Exif-planarconfiguration-1','Exif-planarconfiguration-2','Exif-primarychromaticities','Exif-referenceblackwhite','Exif-relatedsoundfile','Exif-resolutionunit','Exif-rowsperstrip','Exif-samplesperpixel','Exif-saturation','Exif-saturation-0','Exif-saturation-1','Exif-saturation-2','Exif-scenecapturetype','Exif-scenecapturetype-0','Exif-scenecapturetype-1','Exif-scenecapturetype-2','Exif-scenecapturetype-3','Exif-scenetype','Exif-scenetype-1','Exif-sensingmethod','Exif-sensingmethod-1','Exif-sensingmethod-2','Exif-sensingmethod-3','Exif-sensingmethod-4','Exif-sensingmethod-5','Exif-sensingmethod-7','Exif-sensingmethod-8','Exif-sharpness','Exif-sharpness-0','Exif-sharpness-1','Exif-sharpness-2','Exif-shutterspeedvalue','Exif-software','Exif-software-value','Exif-spatialfrequencyresponse','Exif-spectralsensitivity','Exif-stripbytecounts','Exif-stripoffsets','Exif-subjectarea','Exif-subjectdistance','Exif-subjectdistance-value','Exif-subjectdistancerange','Exif-subjectdistancerange-0','Exif-subjectdistancerange-1','Exif-subjectdistancerange-2','Exif-subjectdistancerange-3','Exif-subjectlocation','Exif-subsectime','Exif-subsectimedigitized','Exif-subsectimeoriginal','Exif-transferfunction','Exif-usercomment','Exif-whitebalance','Exif-whitebalance-0','Exif-whitebalance-1','Exif-whitepoint','Exif-xresolution','Exif-xyresolution-c','Exif-xyresolution-i','Exif-ycbcrcoefficients','Exif-ycbcrpositioning','Exif-ycbcrsubsampling','Exif-yresolution','Expiringblock','Explainconflict','Export','Exportcuronly','Exporttext','Externaldberror','Extlink_sample','Extlink_tip','Faq','Faqpage','Feb','February','Feedlinks','Filecopyerror','Filedeleteerror','Filedesc','Fileexists','Fileinfo','Filemissing','Filename','Filenotfound','Filerenameerror','Files','Filesource','Filestatus','Fileuploaded','Formerror','Friday','Geo','Getimagelist','Go','Googlesearch','Group-admin-desc','Group-admin-name','Group-anon-desc','Group-anon-name','Group-bureaucrat-desc','Group-bureaucrat-name','Group-loggedin-desc','Group-loggedin-name','Group-steward-desc','Group-steward-name','Groups','Groups-addgroup','Groups-already-exists','Groups-editgroup','Groups-editgroup-description','Groups-editgroup-name','Groups-editgroup-preamble','Groups-existing','Groups-group-edit','Groups-lookup-group','Groups-noname','Groups-tableheader','Guesstimezone','Headline_sample','Headline_tip','Help','Helppage','Hide','Hidetoc','Hist','Histfirst','Histlast','Histlegend','History','History_copyright','History_short','Historywarning','Hr_tip','Ignorewarning','Illegalfilename','Ilsubmit','Image_sample','Image_tip','Imagelinks','Imagelist','Imagelistall','Imagelisttext','Imagemaxsize','Imagepage','Imagereverted','Imgdelete','Imgdesc','Imghistlegend','Imghistory','Imglegend','Immobile_namespace','Import','Importfailed','Importhistoryconflict','Importinterwiki','Importnofile','Importnosources','Importnotext','Importsuccess','Importtext','Importuploaderror','Infiniteblock','Info_short','Infobox','Infobox_alert','Infosubtitle','Internalerror','Intl','Invalidemailaddress','Invert','Ip_range_invalid','Ipaddress','Ipadressorusername','Ipb_expiry_invalid','Ipbexpiry','Ipblocklist','Ipblocklistempty','Ipboptions','Ipbother','Ipbotheroption','Ipbreason','Ipbsubmit','Ipusubmit','Ipusuccess','Isbn','Isredirect','Italic_sample','Italic_tip','Iteminvalidname','Jan','January','Jul','July','Jun','June','Laggedslavemode','Largefile','Last','Lastmodified','Lastmodifiedby','Lineno','Link_sample','Link_tip','Linklistsub','Linkprefix','Linkshere','Linkstoimage','Linktrail','Listform','Listingcontinuesabbrev','Listusers','Loadhist','Loadingrev','Localtime','Lockbtn','Lockconfirm','Lockdb','Lockdbsuccesssub','Lockdbsuccesstext','Lockdbtext','Locknoconfirm','Log','Login','Loginend','Loginerror','Loginpagetitle','Loginproblem','Loginprompt','Loginreqtext','Loginreqtitle','Loginsuccess','Loginsuccesstitle','Logout','Logouttext','Logouttitle','Lonelypages','Longpages','Longpagewarning','Mailerror','Mailmypassword','Mailnologin','Mailnologintext','Mainpage','Mainpagedocfooter','Mainpagetext','Maintenance','Maintenancebacklink','Maintnancepagetext','Makesysop','Makesysopfail','Makesysopname','Makesysopok','Makesysopsubmit','Makesysoptext','Makesysoptitle','Mar','March','Markaspatrolleddiff','Markaspatrolledlink','Markaspatrolledtext','Markedaspatrolled','Markedaspatrolledtext','Matchtotals','Math','Math_bad_output','Math_bad_tmpdir','Math_failure','Math_image_error','Math_lexing_error','Math_notexvc','Math_sample','Math_syntax_error','Math_tip','Math_unknown_error','Math_unknown_function','May','May_long','Media_sample','Media_tip','Mediawarning','Metadata','Metadata_page','Minlength','Minoredit','Minoreditletter','Mispeelings','Mispeelingspage','Mispeelingstext','Missingarticle','Missingimage','Missinglanguagelinks','Missinglanguagelinksbutton','Missinglanguagelinkstext','Monday','Moredotdotdot','Mostlinked','Move','Movearticle','Movedto','Movelogpage','Movelogpagetext','Movenologin','Movenologintext','Movepage','Movepagebtn','Movepagetalktext','Movepagetext','Movereason','Movetalk','Movethispage','Mw_math_html','Mw_math_mathml','Mw_math_modern','Mw_math_png','Mw_math_simple','Mw_math_source','Mycontris','Mypage','Mytalk','Namespace','Namespacesall','Navigation','Nbytes','Nchanges','Newarticle','Newarticletext','Newbies','Newimages','Newmessages','Newmessageslink','Newpage','Newpageletter','Newpages','Newpassword','Newtitle','Newusersonly','Newwindow','Next','Nextdiff','Nextn','Nextpage','Nextrevision','Nlinks','Noarticletext','Noconnect','Nocontribs','Nocookieslogin','Nocookiesnew','Nocreativecommons','Nocredits','Nodb','Nodublincore','Noemail','Noemailprefs','Noemailtext','Noemailtitle','Nogomatch','Nohistory','Noimage','Noimages','Nolinkshere','Nolinkstoimage','Noname','Nonefound','Nonunicodebrowser','Nospecialpagetext','Nosuchaction','Nosuchactiontext','Nosuchspecialpage','Nosuchuser','Nosuchusershort','Notacceptable','Notanarticle','Notargettext','Notargettitle','Note','Notextmatches','Notitlematches','Notloggedin','Nov','November','Nowatchlist','Nowiki_sample','Nowiki_tip','Nstab-category','Nstab-help','Nstab-image','Nstab-main','Nstab-media','Nstab-mediawiki','Nstab-special','Nstab-template','Nstab-user','Nstab-wp','Numauthors','Number_of_watching_users_RCview','Number_of_watching_users_pageview','Numedits','Numtalkauthors','Numtalkedits','Numwatchers','Nviews','Oct','October','Ok','Oldpassword','Orig','Orphans','Othercontribs','Otherlanguages','Others','Pagemovedsub','Pagemovedtext','Pagetitle','Passwordremindertext','Passwordremindertitle','Passwordsent','Passwordtooshort','Perfcached','Perfdisabled','Perfdisabledsub','Personaltools','Popularpages','Portal','Portal-url','Postcomment','Poweredby','Powersearch','Powersearchtext','Preferences','Prefs-help-email','Prefs-help-email-enotif','Prefs-help-realname','Prefs-misc','Prefs-personal','Prefs-rc','Prefslogintext','Prefsnologin','Prefsnologintext','Prefsreset','Preview','Previewconflict','Previewnote','Previousdiff','Previousrevision','Prevn','Print','Printableversion','Printsubtitle','Protect','Protectcomment','Protectedarticle','Protectedpage','Protectedpagewarning','Protectedtext','Protectlogpage','Protectlogtext','Protectmoveonly','Protectpage','Protectsub','Protectthispage','Proxyblocker','Proxyblockreason','Proxyblocksuccess','Pubmedurl','Qbbrowse','Qbedit','Qbfind','Qbmyoptions','Qbpageinfo','Qbpageoptions','Qbsettings','Qbspecialpages','Randompage','Randompage-url','Range_block_disabled','Rchide','Rclinks','Rclistfrom','Rcliu','Rcloaderr','Rclsub','Rcnote','Rcnotefrom','Rcpatroldisabled','Rcpatroldisabledtext','Readonly','Readonly_lag','Readonlytext','Readonlywarning','Recentchanges','Recentchanges-url','Recentchangesall','Recentchangescount','Recentchangeslinked','Recentchangestext','Redirectedfrom','Remembermypassword','Removechecked','Removedwatch','Removedwatchtext','Removingchecked','Renamegrouplogentry','Resetprefs','Restorelink','Restorelink1','Restrictedpheading','Resultsperpage','Retrievedfrom','Returnto','Retypenew','Reupload','Reuploaddesc','Reverted','Revertimg','Revertmove','Revertpage','Revhistory','Revisionasof','Revisionasofwithlink','Revnotfound','Revnotfoundtext','Rfcurl','Rights','Rightslogtext','Rollback','Rollback_short','Rollbackfailed','Rollbacklink','Rows','Saturday','Savearticle','Savedprefs','Savefile','Savegroup','Saveprefs','Saveusergroups','Scarytranscludedisabled','Scarytranscludefailed','Scarytranscludetoolong','Search','Searchdisabled','Searchfulltext','Searchquery','Searchresults','Searchresultshead','Searchresulttext','Sectionlink','Selectnewerversionfordiff','Selectolderversionfordiff','Selflinks','Selflinkstext','Selfmove','Sep','September','Servertime','Sessionfailure','Set_rights_fail','Set_user_rights','Setbureaucratflag','Setstewardflag','Shareddescriptionfollows','Sharedupload','Shareduploadwiki','Shortpages','Show','Showbigimage','Showdiff','Showhideminor','Showingresults','Showingresultsnum','Showlast','Showpreview','Showtoc','Sidebar','Sig_tip','Sitenotice','Sitestats','Sitestatstext','Sitesubtitle','Sitesupport','Sitesupport-url','Sitetitle','Siteuser','Siteusers','Skin','Skinpreview','Sorbs','Sorbs_create_account_reason','Sorbsreason','Sourcefilename','Spamprotectionmatch','Spamprotectiontext','Spamprotectiontitle','Speciallogtitlelabel','Specialloguserlabel','Specialpage','Specialpages','Spheading','Sqlhidden','Statistics','Storedversion','Stubthreshold','Subcategories','Subcategorycount','Subcategorycount1','Subject','Subjectpage','Successfulupload','Summary','Sunday','Sysoptext','Sysoptitle','Tableform','Tagline','Talk','Talkexists','Talkpage','Talkpagemoved','Talkpagenotmoved','Talkpagetext','Templatesused','Textboxsize','Textmatches','Thisisdeleted','Thumbnail-more','Thumbsize','Thursday','Timezonelegend','Timezoneoffset','Timezonetext','Titlematches','Toc','Tog-editondblclick','Tog-editsection','Tog-editsectiononrightclick','Tog-editwidth','Tog-enotifminoredits','Tog-enotifrevealaddr','Tog-enotifusertalkpages','Tog-enotifwatchlistpages','Tog-externaldiff','Tog-externaleditor','Tog-fancysig','Tog-hideminor','Tog-highlightbroken','Tog-justify','Tog-minordefault','Tog-nocache','Tog-numberheadings','Tog-previewonfirst','Tog-previewontop','Tog-rememberpassword','Tog-shownumberswatching','Tog-showtoc','Tog-showtoolbar','Tog-underline','Tog-usenewrc','Tog-watchdefault','Toolbox','Tooltip-compareselectedversions','Tooltip-diff','Tooltip-minoredit','Tooltip-preview','Tooltip-save','Tooltip-search','Tooltip-watch','Trackback','Trackbackbox','Trackbackdeleteok','Trackbackexcerpt','Trackbacklink','Trackbackremove','Tryexact','Tuesday','Uclinks','Ucnote','Uctop','Unblockip','Unblockiptext','Unblocklink','Unblocklogentry','Uncategorizedcategories','Uncategorizedpages','Undelete','Undelete_short','Undelete_short1','Undeletearticle','Undeletebtn','Undeletedarticle','Undeletedrevisions','Undeletedtext','Undeletehistory','Undeletepage','Undeletepagetext','Undeleterevision','Undeleterevisions','Underline-always','Underline-default','Underline-never','Unexpected','Unit-pixel','Unlockbtn','Unlockconfirm','Unlockdb','Unlockdbsuccesssub','Unlockdbsuccesstext','Unlockdbtext','Unprotect','Unprotectcomment','Unprotectedarticle','Unprotectsub','Unprotectthispage','Unusedcategories','Unusedcategoriestext','Unusedimages','Unusedimagestext','Unwatch','Unwatchthispage','Updated','Upload','Upload_directory_read_only','Uploadbtn','Uploadcorrupt','Uploaddisabled','Uploadedfiles','Uploadedimage','Uploaderror','Uploadlink','Uploadlog','Uploadlogpage','Uploadlogpagetext','Uploadnewversion','Uploadnologin','Uploadnologintext','Uploadscripted','Uploadtext','Uploadvirus','Uploadwarning','Usenewcategorypage','User_rights_set','Usercssjsyoucanpreview','Usercsspreview','Userexists','Userjspreview','Userlogin','Userlogout','Usermailererror','Userpage','Userrights','Userrights-editusergroup','Userrights-groupsavailable','Userrights-groupshelp','Userrights-groupsmember','Userrights-logcomment','Userrights-lookup-user','Userrights-user-editname','Userstats','Userstatstext','Val_add','Val_article_lists','Val_clear_old','Val_del','Val_details_th','Val_details_th_user','Val_form_note','Val_iamsure','Val_list_header','Val_merge_old','Val_my_stats_title','Val_no','Val_no_anon_validation','Val_noop','Val_of','Val_page_validation_statistics','Val_percent','Val_percent_single','Val_rev_for','Val_rev_stats','Val_revision','Val_revision_changes_ok','Val_revision_number','Val_revision_of','Val_revision_stats_link','Val_show_my_ratings','Val_stat_link_text','Val_tab','Val_table_header','Val_this_is_current_version','Val_time','Val_topic_desc_page','Val_total','Val_user_stats_title','Val_user_validations','Val_validate_article_namespace_only','Val_validate_version','Val_validated','Val_validation_of','Val_version','Val_version_of','Val_view_version','Val_votepage_intro','Val_warning','Val_yes','Validate','Variantname-zh','Variantname-zh-cn','Variantname-zh-hk','Variantname-zh-sg','Variantname-zh-tw','Version','Versionrequired','Versionrequiredtext','Viewcount','Viewprevnext','Views','Viewsource','Viewtalkpage','Wantedpages','Watch','Watchdetails','Watcheditlist','Watchlist','Watchlistall1','Watchlistall2','Watchlistcontains','Watchlistsub','Watchmethod-list','Watchmethod-recent','Watchnochange','Watchnologin','Watchnologintext','Watchthis','Watchthispage','Wednesday','Welcomecreation','Whatlinkshere','Whitelistacctext','Whitelistacctitle','Whitelistedittext','Whitelistedittitle','Whitelistreadtext','Whitelistreadtitle','Wikipediapage','Wlheader-enotif','Wlheader-showupdated','Wlhide','Wlhideshowown','Wlnote','Wlsaved','Wlshow','Wlshowlast','Wrong_wfQuery_params','Wrongpassword','Yourdiff','Yourdomainname','Youremail','Yourlanguage','Yourname','Yournick','Yourpassword','Yourpasswordagain','Yourrealname','Yourtext','Yourvariant') Function: Error: 1142 select command denied to user 'wikiuser'@'localhost' for table 'tf_page' (localhost) Backtrace: GlobalFunctions.php line 451 calls wfbacktrace() Database.php line 397 calls wfdebugdiebacktrace() Database.php line 347 calls databasemysql::reportqueryerror() InitialiseMessages.inc line 140 calls databasemysql::query() InitialiseMessages.inc line 72 calls initialisemessagesreal() updaters.inc line 670 calls initialisemessages() index.php line 606 calls do_all_updates() All of a sudden with no reason, my user has no access to do a select on a table?? What give?
I went into mysql as user root from the cpommand line and ran GRANT ALL PRIVILEGES ON my_wikidb.* to wikiuser@localhost IDENTIFIED BY 'wikipassword' WITH GRANT OPTION; I then re-ran the MediaWiki installation, setting the root password to '-' and got to the end successfully Initialising "MediaWiki" namespace... Clearing message cache...Done. # Finished update checks. Creating LocalSettings.php... Installation successful! Move the config/LocalSettings.php file into the parent directory, then follow this link to your wiki. I don't mind having to do this, but I think if the installer is supposed to be able to do everything for me it ought to work.
Did you specify superuser information at the bottom of the installation form? It defaults to assuming the user has the permissions granted if you don't.
I've made this all very clear in the report. Yes I specify the root password. Yes the user has privileges (until they are mysteriously lost halfway through the installation). Some tables are cfreated. Others are not (and there is an error). Again, if this were simple I wouldn't be filing the repoort. It's not simple. It's mysterious, occasional, and different every time.
I believe that this is a problem that only happens on new installations of MediaWiki on Mac OS X 10.4.X using the preinstalled mysql. >Error: 1142 select command denied to user 'wikiuser'@'localhost' for table The problem is that the wikiuser you define tries to connect to localhost, which is not the default hostname in 10.4. The solution is to look in the user table in the mysql database, and change the host_name for wikiuser to <computer_name>.local where computer name is the name of your host. This fixed the problem for me. I have no idea why Apple changed this.
Odd - OSX 10.4.7 (at least) seems to know about localhost: % ping localhost PING localhost (127.0.0.1): 56 data bytes 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.093 ms 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.073 ms
This installation of MediaWiki is installed on FreeBSD 4.7. It is not installed on Mac OS X. localhost is well understood on FreeBSD and none of my otherMySQL databases have any problems.
Apparebtly the bug reporting software made inappropriate guesses based on my Web browser configuration and I did not see that.
(In reply to comment #13) > Odd - OSX 10.4.7 (at least) seems to know about localhost: While this is true, it's unrelated because comment #12 does not apply to this installation.
How much of this is still happening? I recall (how could I forget?) the rather ridiculous security bug I introduced some time before 1.5.6 (messed about with MySQL's root password) which *might* explain the permissions funkiness here. If other problems are still occurring with the latest version, it might be an idea to relist those, or close this bug in favour of new ones separating any reproducable issues.
Going to assume that the fixes to the installer a couple versions back solved this, closing WORKSFORME.