Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 15 Jan 2018, 01:30
hilaryl hilaryl is offline
 
Join Date: Jan 2006
Does Sphinx need updates if forum database password is changed?

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

Last edited by hilaryl; 15 Jan 2018 at 01:48.
Reply With Quote
  #2  
Old 15 Jan 2018, 13:03
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
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
Reply With Quote
  #3  
Old 16 Jan 2018, 05:49
hilaryl hilaryl is offline
 
Join Date: Jan 2006
Thanks - that's great.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Userprofile Changed Date in Member Profile & recent changed on forumhome Marco van Herwaarden vBulletin 3.5 Add-ons 70 01 Apr 2008 20:34
Forum Home Enhancements UF - Forum Updates on Homepage! (Updates come from posts in a specified thread) alexgeek vBulletin 3.6 Add-ons 21 03 Feb 2008 17:47



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:55.

Layout Options | Width: Wide Color: