PDA

View Full Version : Does Sphinx need updates if forum database password is changed?


hilaryl
01-14-2018, 11:30 PM
I'm undertaking a security update and want to change the password for our forum database.

I've done this before, with no issue, and have just updated this line in the config.php file

$config['MasterServer']['password']

We now use Sphinx as our forum search. Does anyone know if I need to change or do anything extra now when I update that password?

I did try it, forum looked ok, but the search and things like 'new posts' that use the Sphinx search had an error.

Anyone know?
TIA

Edit to add: We're using vbulletin 4.x; linux server

snakes1100
01-15-2018, 11:03 AM
Yes, you'll need to change the db passwd in the one of the two locations & then you can run a cmd from your ssh terminal to force a new index & rotate them

Im assuming your using digitalpoints mod, so change the db passwd in sphinx.conf.ini

If u dont use digitalpoints mod, then you need to modify sphinx.conf

path to index as it will most likely differ on your system

cmds to run:

updatedb
locate indexer
/path/to/indexer --rotate --all

if that dont show updated threads/posts, do this below:
then HUP/restart searchd

hilaryl
01-16-2018, 03:49 AM
Thanks - that's great. :)