486301 - Run import script on SUMO prod

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[David Tenser [:djst]]

In the SUMO 1.0 push last night, we forgot to add a note that the import script in bug 481304 needs to be run. Please do this asap as the key feature in SUMO 1.0 depends on it. Thanks!

Comment 1

[Dave Miller [:justdave]]

I can't quite follow bug 481304... I'm assuming this is like bug 484809 comment 3?  Same URL that it fetches from?

Comment 2

[Dave Miller [:justdave]]

I'm going back to sleep.  Reassign this back to [e-mail] again when you have instructions for me and it'll page me.

Comment 3

[Dave Miller [:justdave]]

Cww said on irc that it is indeed pulling from the same url...  attempted to run and got this:

PHP Warning:  require_once(../webroot/lib/init/initlib.php): failed to open stream: No such file or directory in /mnt/netapp/support.mozilla.org-scripts/tiki_script_base.php on line 10
PHP Fatal error:  require_once(): Failed opening required '../webroot/lib/init/initlib.php' (include_path='.:/usr/share/pear:/usr/share/php') in /mnt/netapp/support.mozilla.org-scripts/tiki_script_base.php on line 10

My guess is php is dereferencing the symlink so the relative path doesn't work...

> lrwxrwxrwx  1 root root    40 Dec 26 17:00 scripts -> /mnt/netapp/support.mozilla.org-scripts/
> drwxr-xr-x 31 root root 28672 Mar 31 19:13 webroot

Comment 4

[Dave Miller [:justdave]]

I replaced all of the ".." with full paths in tiki_script_base.php, and now it dies with:

PHP Fatal error:  Class 'Memcache' not found in /data/php5/www/support.mozilla.com/webroot/lib/cache/memcachelib.php on line 39

Comment 5

[Dave Miller [:justdave]]

> Installed: php-pecl-memcache.x86_64 0:2.2.3-1.el5.rf
> Complete!
> [root@mradm02 scripts]# php fetch_sumo_lists.php http://dm-sumotools01.mozilla.org/exports/export.txt
> PHP Fatal error:  Call to a member function getID() on a non-object in /data/php5/www/support.mozilla.com/webroot/lib/setup/prefs.php on line 544

Comment 6

[Dave Miller [:justdave]]

I'm through messing with this until someone who knows the code is around.  Do the reassignment thing as mentioned in comment 2 to page me when someone's here to help.

Comment 7

[David Tenser [:djst]]

Sorry Dave, I was assuming this would be straightforward. 

Eric or Laura: your help desperately needed here!

Comment 8

[Laura Thomson :laura]

It sounds like PHP's include_path must be different on stage versus prod, which is why it's not finding the files.  Dave, can you tell me what it's set to in php.ini on stage and prod?

Comment 9

[Dave Miller [:justdave]]

OK, final diagnosis...  the symlink onto the netapp basically hoses everything.  I've removed it and made it a local directory within the docroot again, the script ran successfully.  It's been added to cron to run every Monday at noon.

CCing some people who might know why the directory was symlinked in the first place in case it was important... it's all code as far as I can tell, so I've no idea why it needs to be.

Comment 10

[Reed Loden [:reed]]

Which directory exactly?

Comment 11

[Laura Thomson :laura]

/scripts