464851 - Manually trigger search indexing on support-stage

Status: VERIFIED FIXED

(support.mozilla.org :: Knowledge Base Software, task)

Description

[Nelson Ko [:nkoth]]

1. Execute /webroot/scripts/sphinx/indexer.php from the shell command line, e.g. php indexer.php

2. Execute /webroot/scripts/sphinx/indexer-forums.php from the shell command line, e.g. php indexer.php

3. Execute as the webserver user, this: /usr/local/sphinx/bin/indexer --all --rotate 

Report any errors to this bug.

Comment 1

[Nelson Ko [:nkoth]]

(In reply to comment #0)
> 1. Execute /webroot/scripts/sphinx/indexer.php from the shell command line,
> e.g. php indexer.php
> 
> 2. Execute /webroot/scripts/sphinx/indexer-forums.php from the shell command
> line, e.g. php indexer.php

obviously, the e.g. should be "php indexer-forums.php"
> 
> 3. Execute as the webserver user, this: /usr/local/sphinx/bin/indexer --all
> --rotate 
> 
> Report any errors to this bug.

Comment 2

[Nelson Ko [:nkoth]]

Upping to major - blocking testing and development.

Comment 3

[Phong Tran [:phong]]

-bash-3.2$ cd /data/www/support-stage.mozilla.com/scripts/sphinx/
-bash-3.2$ php indexer.php
PHP Warning:  require_once(tiki-setup.php): failed to open stream: No such file or directory in /data/www/support-stage.mozilla.com/scripts/sphinx/indexer.php on line 68
PHP Fatal error:  require_once(): Failed opening required 'tiki-setup.php' (include_path='.:/usr/share/pear:/usr/share/php') in /data/www/support-stage.mozilla.com/scripts/sphinx/indexer.php on line 68

Comment 4

[Nelson Ko [:nkoth]]

could you try running this from the /data/www/support-stage.mozilla.com/webroot folder? something like php ../scripts/sphinx/indexer.php

That should work.

However, if that does not work, is it possible to add /data/www/support-stage.mozilla.com/webroot to the php include path in php.ini? http://us3.php.net/manual/en/ini.core.php#ini.include-path But this is not a preferred solution if the first simply works.

Comment 5

[chizu]

From the webroot, it can't the db config.

[root@mrapp-stage02 webroot]# php ../scripts/sphinx/indexer.php
<b style="color:red;">local.php not found.</b><br /><br />Please run <a href=tiki-install.php>tiki-install.php</a>
[root@mrapp-stage02 webroot]# ls db/local.php
db/local.php

Comment 6

[Nelson Ko [:nkoth]]

I have added two scripts via r20230/r20231 that you should run. The process is now:

1. Execute "php manual_index.php" in webroot/ from the shell command line,

2. Execute "php manual_index_forums.php" in webroot/ from the shell command line,

3. Execute as the webserver user, this: /usr/local/sphinx/bin/indexer --all
--rotate

Comment 7

[David Tenser [:djst]]

Trevor, the code freeze for 0.7.3 was supposed to happen tonight; could you take a look at this asap please? Thanks!

Comment 8

[chizu]

Scripts run and index rotated without error.

Comment 9

[Stephen Donner [:stephend] Not actively reading bugmail]

Verified FIXED; http://support-stage.mozilla.org/tiki-newsearch.php?locale=en&q=folder&where=all&l=en&filter_lang=0&author=&filter_author=0&en_too=&type=0&answered=0&lastmodif=0 is returning results for Admins now.