[Wp-mirror-list] Attempting to mirror on laptop

[wp mirror]

Dear Benjamin,

0) Preamble.

When you configure MediaWiki, the database WIKIDB is created.  WIKIDB
contains 41 tables that initially are (nearly) empty.

WP-MIRROR dumps WIKIDB to
/usr/share/mediawiki/maintenance/template.sql.  This template is then
loaded for each language in listed in /etc/wp-mirror/local.conf.  This
saves you the effort of configuring MediaWiki repeatedly (once for
each language).  In your case this template should have been loaded
into SIMPLEWIKI.

>From the diagnostics that you kindly provided, it is clear that
something went wrong during the creation of SIMPLEWIKI.

Let us manually fix SIMPLEWIKI, and then run an additional diagnostic.

To that end, please show me your output to the following commands:

1) MySQL

shell> mysql --host=localhost --user=root --password
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
<snip>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| simplewiki         |
| wikidb             |
| wpmirror           |
+--------------------+
5 rows in set (0.00 sec)

mysql> drop database `simplewiki`;
Query OK, 0 rows affected (1.62 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| wikidb             |
| wpmirror           |
+--------------------+
4 rows in set (0.00 sec)

mysql> create database `simplewiki`;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| simplewiki         |
| wikidb             |
| wpmirror           |
+--------------------+
5 rows in set (0.00 sec)

mysql> GRANT ALL ON `simplewiki`.* TO address@hidden;
Query OK, 0 rows affected (0.03 sec)

mysql> quit;
Bye

2) MySQL

root-shell> rm /usr/share/mediawiki/maintenance/template.sql

shell> mysqldump --host=localhost --user=root --password wikidb >
/usr/share/mediawiki/maintenance/template.sql
Enter password:

shell> mysql --host=localhost --user=root --password
--database=simplewiki < /usr/share/mediawiki/maintenance/template.sql
Enter password:

shell> ls -l /usr/share/mediawiki/maintenance/template.sql
-rw-r--r-- 1 root root 49775 Aug  8  2012

3) MySQL

shell> mysql --host=localhost --user=root --password
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
<snip>
mysql> show tables from simplewiki;
+----------------------+
| Tables_in_simplewiki |
+----------------------+
| archive              |
| category             |
| categorylinks        |
| change_tag           |
| externallinks        |
| filearchive          |
| hitcounter           |
| image                |
| imagelinks           |
| interwiki            |
| ipblocks             |
| job                  |
| langlinks            |
| logging              |
| math                 |
| objectcache          |
| oldimage             |
| page                 |
| page_props           |
| page_restrictions    |
| pagelinks            |
| protected_titles     |
| querycache           |
| querycache_info      |
| querycachetwo        |
| recentchanges        |
| redirect             |
| revision             |
| searchindex          |
| site_stats           |
| tag_summary          |
| templatelinks        |
| text                 |
| trackbacks           |
| transcache           |
| updatelog            |
| user                 |
| user_groups          |
| user_newtalk         |
| valid_tag            |
| watchlist            |
+----------------------+
41 rows in set (0.76 sec)

4) MediaWiki

root-shell> /usr/bin/php5
/usr/share/mediawiki/maintenance/update_farm.php simple.mediawiki.site

PHP Notice:  Undefined index: HTTP_USER_AGENT in
/usr/share/fckeditor/fckeditor_php5.php on line 37
MediaWiki 1.15.5-2squeeze4 Updater

Going to run database updates for simplewiki
<snip>
Done
Checking site_stats row...ok.
Purging caches...done.
Done.

Sincerely Yours,
Kent