Mailing List Archive

Did you make sure that in the AdminSettings.php file $wgDBadminuser and $wgDBadminpassword were set correctly for your database user?


-----Original Message-----
From: Baeckeroot alain [mailto:al2.baeckeroot@laposte.net]
Sent: Thursday, December 02, 2004 1:38 PM
To: mediawiki-l@Wikimedia.org
Subject: [Mediawiki-l] Newbie : full text search


Hi

I have read here that i must run maintenance/rebuildtextindex.php for
fulltext search.

My wikipedia is functional and works smoothly :)

Well, i installed a php client ;) and then run the script.
- First it complains about AdminSettings.php that i hade forgotten
so i copy Adminsettings.sample to it and run again

- it says (in french) that
"for technical reasons, it is impossible for the moment
to connect the database"

the wiki is nice and running, the database also !
What did i miss ? (i setup my first apache / sql server a few days ago, just
for wikipedia :)

thanks in advance. Regards
Alain
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

Le Jeudi 2 Décembre 2004 20:45, Adam Edwards a écrit :
>
> Did you make sure that in the AdminSettings.php file $wgDBadminuser and
$wgDBadminpassword were set correctly for your database user?

I guess that is the problem. AFAIK i put the good name/passwd , _but_
i was asked so many admin/passwd (apache, sql, mediawiki) that i'm not
sure i put the right username. (for the passwd i put the same
everywhere ;) I left the default names everywhere (on debian sarge)
here i said :
$wgDBadminuser = "mysql";
$wgDBadminpassword = XXXXX

is that the good user ?

thanks
alain

If you look in LocalSettings.php, the mysql password the wiki uses is in the variables $wgDBuser and $wgDBpassword. You should be able to use those.

-----Original Message-----
From: Baeckeroot alain [mailto:al2.baeckeroot@laposte.net]
Sent: Thursday, December 02, 2004 2:53 PM
To: mediawiki-l@Wikimedia.org
Subject: Re: [Mediawiki-l] Newbie : full text search


Le Jeudi 2 Décembre 2004 20:45, Adam Edwards a écrit :
>
> Did you make sure that in the AdminSettings.php file $wgDBadminuser and
$wgDBadminpassword were set correctly for your database user?

I guess that is the problem. AFAIK i put the good name/passwd , _but_
i was asked so many admin/passwd (apache, sql, mediawiki) that i'm not
sure i put the right username. (for the passwd i put the same
everywhere ;) I left the default names everywhere (on debian sarge)
here i said :
$wgDBadminuser = "mysql";
$wgDBadminpassword = XXXXX

is that the good user ?

thanks
alain
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

Le Jeudi 2 Décembre 2004 21:56, Adam Edwards a écrit :
> If you look in LocalSettings.php, the mysql password the wiki uses is
in the variables $wgDBuser and $wgDBpassword. You should be able to use
those.

Thanks , the example said "wikiadmin" and the default seems to be
"wikiuser" !!!

With that i go one step further :

Dropping index...
A database error has occurred
Query: ALTER TABLE searchindex DROP INDEX si_title, DROP INDEX si_text
Function: dropTextIndex
Error: 1142 alter command denied to user: 'wikiuser@localhost' for table
'searchindex'

Backtrace:
Database.php line 201, in wfdebugdiebacktrace()
rebuildtextindex.inc line 16, in database::query()
rebuildtextindex.php line 11, in droptextindex()

I think i should reinstall all from scratch, and write all login/passwd
now that i understand better how the whole thing works :)

Thanks a lot
Alain

> Thanks , the example said "wikiadmin" and the default seems to be
"wikiuser" !!!

First. You have to put the database username, say wikibase, and the database
name, say, wikibase_fr, the same you put when creating your particular
database. Make sure that they have all necessary permissions.

Second. If intending to run php rebuildtextindex.php, take into account that
the process is extremely CPU intensive, especially its second part. After
creating the redirect, etc. links, and counting over 500, the real full-text
indexing starts with the message "Rebuild the index..." Here is where I
failed twice. First, because I've run short of disk space (/var was allotted
only 6.9 GB), second, because I didn't realise the process will take more
than 30 hours, so killed the beast, run repare db and all links (about 12
mln) disappeared.:-(

Well, repetitio mater studiorum est. :-)

Plamen

On Dec 2, 2004, at 1:57 PM, Plamen Gradinarov wrote:
> Here is where I failed twice. First, because I've run short of disk
> space (/var was allotted only 6.9 GB), second, because I didn't
> realise the process will take more than 30 hours, so killed the beast,
> run repare db and all links (about 12 mln) disappeared.:-(

Incidentally, fulltext index building is *much* slower in MySQL 3.x
than it is in 4.x. If you're running 3.x because that's what your Linux
distribution shipped, I highly recommend upgrading to 4.0.22 and using
that instead. (Avoid 4.1 unless you really need it; it's broken
backwards compatibility for a number of things and there are some nasty
pitfalls.)

If you're already running 4.x, well, take heart. It would be *even
worse* on 3.x. ;)

-- brion vibber (brion @ pobox.com)

From: "Brion Vibber" <brion@pobox.com>
> If you're already running 4.x, well, take heart. It would be *even
> worse* on 3.x. ;)

That's a consolation, thank you. :-)
The machine is running 4.0.22 on RHE3. The present indexing rate is 40 MB
per hour which makes 16 hours for Wiki De, and at least two times more for
Wiki En.

I've heard PHP 5 is much faster than 4, but it makes impossible the use of
Turck mmcache. On the other hand, Turck is not updated since November 2003
and D. Stogov is said to have joined Zend. (?)

Plamen

On Dec 2, 2004, at 7:26 PM, Plamen Gradinarov wrote:
> From: "Brion Vibber" <brion@pobox.com>
>> If you're already running 4.x, well, take heart. It would be *even
>> worse* on 3.x. ;)
>
> That's a consolation, thank you. :-)
> The machine is running 4.0.22 on RHE3. The present indexing rate is 40
> MB per hour which makes 16 hours for Wiki De, and at least two times
> more for Wiki En.

You might want to see about memory and I/O usage here. If MySQL's
memory usage settings are too low, it may be using the disk
inefficiently; if it's too high, it may be thrashing swap.

> I've heard PHP 5 is much faster than 4, but it makes impossible the
> use of Turck mmcache. On the other hand, Turck is not updated since
> November 2003 and D. Stogov is said to have joined Zend. (?)

Well, Zend's accelerator/optimizer/whatever will probably do as good a
job. Unlike PHP itself these aren't free software (though some of it
may be available gratis, I'm not sure).

I haven't done any direct PHP4 vs PHP5 speed comparisons. I should
probably check sometime, if I can manage to get two separate
installations on the same machine.

-- brion vibber (brion @ pobox.com)

On Fri, 3 Dec 2004 05:26:18 +0200, Plamen Gradinarov
<plamen@orientalia.org> wrote:
> I've heard PHP 5 is much faster than 4, but it makes impossible the use of
> Turck mmcache. On the other hand, Turck is not updated since November 2003
> and D. Stogov is said to have joined Zend. (?)

But PHPTAL is broken (last I heard) in PHP5, which means you can't use
the MonoBook (default) skin. If you can get it to work, besides that,
then go with it!

-- Jamie
-------------------------------------------------------------------
http://endeavour.zapto.org/astro73/
Thank you to JosephM for inviting me to Gmail!

MediaWiki v1.4 has been recently modified to no longer use PHPTAL. The
monobook skin now works with PHP5.

-- Zigger

On Sat, 4 Dec 2004 21:24:41 -0500, Jamie Bliss wrote:
> ...
> But PHPTAL is broken (last I heard) in PHP5, which means you can't use
> the MonoBook (default) skin. If you can get it to work, besides that,
> then go with it!
> ...

> On Fri, 3 Dec 2004 05:26:18 +0200, Plamen Gradinarov
> <plamen@orientalia.org> wrote:
>> I've heard PHP 5 is much faster than 4, but it makes impossible the
>> use of
>> Turck mmcache. On the other hand, Turck is not updated since November
>> 2003
>> and D. Stogov is said to have joined Zend. (?)

I've done a quick test and found PHP 5.0.3rc1 to be slightly slower
than 4.3.8 (with no acceleration modules installed on either). The
additional overhead seems to be in parsing of the PHP script files;
runtime of other functions is comparable.

http://meta.wikimedia.org/wiki/MediaWiki_1.4_benchmarks#Addendum:_PHP5

I recommend staying away from PHP5 for now unless you really require it
for something else.

On Dec 4, 2004, at 6:24 PM, Jamie Bliss wrote:
> But PHPTAL is broken (last I heard) in PHP5, which means you can't use
> the MonoBook (default) skin. If you can get it to work, besides that,
> then go with it!

MonoBook in MediaWiki 1.4 no longer requires PHPTal. (You can
optionally use PHPTal skins with 1.4 on PHP 5 if you install a PHPTal
1.0.0 development snapshot.)

-- brion vibber (brion @ pobox.com)