True Light Designs Blog

Find Image name from Excel Cell

Monday, 23 October 2017 17:15

Tim Ramsey

0 Comments

The formula below will give you the image name from a cell string

=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

1	=SUBSTITUTE(REPLACE(A1,1,LOOKUP(2^15,FIND("/",A1,ROW(INDIRECT("1:"&LEN(A1))))),""),".jpg","")

Install Sphinxsearch 2.3.2-beta

Saturday, 16 September 2017 02:46

Tim Ramsey

0 Comments

Installing on a fresh DO instance.

cd /tmp
sudo apt-get install libmysqlclient-dev build-essential php7.0-cli
wget -q -O- https://github.com/sphinxsearch/sphinx/archive/2.3.2-beta.tar.gz | tar -xz -C .
cd sphinx-2.3.2-beta
./configure --prefix=/etc/sphinxsearch
make
sudo make install
cd ..
rm -rf sphinx-2.3.2-beta

mkdir /usr/local/etc/configs
mkdir /var/lib/sphinxsearch/data/sites
chmod 777 sites

cd /tmp

sudo apt-get install libmysqlclient-dev build-essential php7.0-cli

wget -q -O- https://github.com/sphinxsearch/sphinx/archive/2.3.2-beta.tar.gz | tar -xz -C .

cd sphinx-2.3.2-beta

./configure --prefix=/etc/sphinxsearch

make

sudo make install

cd ..

rm -rf sphinx-2.3.2-beta

mkdir /usr/local/etc/configs

mkdir /var/lib/sphinxsearch/data/sites

chmod 777 sites

Install Sphinx Search on cPanel

Monday, 11 September 2017 20:00

Tim Ramsey

0 Comments

Move into /tmp directory and get latest release. You can get the latest release from http://sphinxsearch.com/downloads/

cd /tmp
wget http://sphinxsearch.com/files/sphinx-2.3.2-beta.tar.gz

1 2	cd /tmp wget http://sphinxsearch.com/files/sphinx-2.3.2-beta.tar.gz

Uncompress

tar -zxf 'sphinx-2.3.2-beta.tar.gz'

1	tar -zxf 'sphinx-2.3.2-beta.tar.gz'

Create directory

mkdir /usr/local/sphinx

1	mkdir /usr/local/sphinx

Enter the Uncompressed directory

cd sphinx-2.3.2-beta

1	cd sphinx-2.3.2-beta

Configure to use the directory we created above and to use mysql and postgresql

./configure --prefix=/usr/local/sphinx --with-mysql --with-pgsql

1	./configure --prefix=/usr/local/sphinx --with-mysql --with-pgsql

Build

make
make install

1 2	make make install

Create Configuration File

cp -pr /usr/local/sphinx/etc/sphinx.conf.dist /usr/local/sphinx/etc/sphinx.conf

1	cp -pr /usr/local/sphinx/etc/sphinx.conf.dist /usr/local/sphinx/etc/sphinx.conf

Create Start-up Script

nano /etc/init.d/searchd

1	nano /etc/init.d/searchd

#!/bin/bash
case "${1:-''}" in
'start')
/usr/local/sphinx/bin/searchd
;;
'stop')
/usr/local/sphinx/bin/searchd --stop
;;
'restart')
/usr/local/sphinx/bin/searchd --stop && /usr/local/sphinx/bin/searchd
;;
*)
echo "Usage: $SELF start|stop|restart"
exit 1
;;
esac

#!/bin/bash

case "${1:-''}" in

'start')

/usr/local/sphinx/bin/searchd

;;

'stop')

/usr/local/sphinx/bin/searchd --stop

;;

'restart')

/usr/local/sphinx/bin/searchd --stop && /usr/local/sphinx/bin/searchd

;;

echo "Usage: $SELF start|stop|restart"

exit 1

;;

esac

Make Script Writable

chmod 755 /etc/init.d/sphinx

1	chmod 755 /etc/init.d/sphinx

Start the Service

/etc/init.d/searchd start

1	/etc/init.d/searchd start

Create chkservd file

nano /etc/chkserv.d/searchd
service[searchd]=x,x,x,/etc/init.d/searchd restart,searchd,root|searchd

1 2	nano /etc/chkserv.d/searchd service[searchd]=x,x,x,/etc/init.d/searchd restart,searchd,root\|searchd

Add to /etc/chkserv.d/chkservd.conf

searchd:1

searchd:1

Restart Tailwatch

/scripts/restartsrv_tailwatchd

1	/scripts/restartsrv_tailwatchd

Free SSL from cPanel for WHM Server/Services

Saturday, 22 July 2017 14:20

Tim Ramsey

0 Comments

WHM » Service Configuration » Manage Service SSL Certificates

click “Browse Certificates” and use “Browse Account: root”.

You should see a certificate for your ‘server.domain.com’ and the Issuer column should say: cPanel, Inc.

If you do not see this, and they all say Issuer: “Self signed”, then go into SSH and run the following command:

Code:

# /usr/local/cpanel/bin/checkallsslcerts

1	# /usr/local/cpanel/bin/checkallsslcerts

You may have to run it a few times as the first time you run it, it usually says about putting the SSL into queue until it runs again, so running

Code:

# /usr/local/cpanel/bin/checkallsslcerts

1	# /usr/local/cpanel/bin/checkallsslcerts

a second time, will have it actually generate the SSL.

Then go back to Manage Service SSL Certificates in WHM and select the cPanel, Inc issued SSL, and check the 4 services boxes and then click install.

Page 5 of 12

Find Image name from Excel Cell

Install Sphinxsearch 2.3.2-beta

Install Sphinx Search on cPanel

Free SSL from cPanel for WHM Server/Services

Categories

Recent Posts