[Mediawiki-l] Converting links table to ID-ID... fails on Solaris - [reprise] with solution...

[Jeffery Cann]

> Brion Vibber brion at pobox.com wrote
>
> Tried digging into the code to add more output checks? 

The script dies on Line 48 when it's trying to get a database connection... 

./maintenance/convertLinks.php

     45     print " DEBUG:  extracting table names...\n";
     46     print " DEBUG:  getting database connection : DB_MASTER...\n";
     47    
 >>>>>    48     $dbw =& wfGetDB( DB_MASTER );   <<<<<  fails at this point
     49 
     50     print " DEBUG:  dbw: $dbw...\n";
     51     extract( $dbw->tableNames( 'cur', 'links', 'links_temp',
'links_backup' ) );
     52 
     53     print " DEBUG:  running SQL: SELECT l_from FROM $links
LIMIT 1 ...\n";
     54     $res = $dbw->query( "SELECT l_from FROM $links LIMIT 1" );
     55     print " DEBUG:  completed SQL: SELECT l_from FROM $links
LIMIT 1 ...\n";
     56 
     57     if ( $dbw->fieldType( $res, 0 ) == "int" ) {
     58         print "Schema already converted\n";
     59         return;

> Confirmed that the GRANTs on the database are correct? 

In a nutshell, despite the fact that I specified 'spapp7:3307' in the
wiki installation, I am unable to connect as wiki user when using
'spapp7' as the host:

  # Denied when using host 'spapp7':
  $  mysql -u wikiuser --host spapp7 --port 3307 --password wikidb
  Enter password: 
  ERROR 1045: Access denied for user: 'wikiuser at spapp7' (Using password: YES)

  # Allowed when using host 'localhost'
  $ mysql -u wikiuser --host localhost --port 3307 --password wikidb
  Enter password: 
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 91 to server version: 4.0.24-standard

To solve the problem, I issued the following grant statement to the
mysql server:

         grant all on wikidb.* to 'wikiuser'@'spapp7' identified by 'password';

I then reran the mediawiki install to success!

Thanks for the assistance.  

Should I report this as a bug?  My thought is that when the MySQL
server field name is not localhost, there should be a grant statement
issued for that host for the wikiuser.

Jeff