True Light Designs Blog

#Change the default user password
sudo passwd postgres
#type and confirm password

#Change the Postgres admin password
Open a terminal window.
Change to the postgres user.
Log in to the postgres prompt.
Issue the command \password postgres.
Enter (and verify) the new password.
Exit the prompt with the command \q.

#Create your first database
Open a terminal window.
Change to the postgres user.
Log in to the postgres prompt.
Issue the command CREATE DATABASE testdb;
#make sure it was created \l

#Create users
Open a terminal window.
Change to the postgres user.
Log in to the postgres command prompt.
Issue the command CREATE USER username; (where username is the name of the user you want to create).

#Grant Privileges
Open a terminal window.
Change to the postgres user.
Log in to the postgres prompt (using the testdb database) with the command psql testdb.
Issue the command GRANT ALL PRIVILEGES ON DATABASE testdb TO user; (where user is the actual username to be given privileges).

#Change the default user password

sudo passwd postgres

#type and confirm password

#Change the Postgres admin password

Open a terminal window.

Change to the postgres user.

Issue the command \password postgres.

Enter (and verify) the new password.

Exit the prompt with the command \q.

#Create your first database

Open a terminal window.

Change to the postgres user.

Issue the command CREATE DATABASE testdb;

#make sure it was created \l

#Create users

Open a terminal window.

Change to the postgres user.

Issue the command CREATE USER username; (where username is the name of the user you want to create).

#Grant Privileges

Open a terminal window.

Change to the postgres user.

Issue the command GRANT ALL PRIVILEGES ON DATABASE testdb TO user; (where user is the actual username to be given privileges).

#install Supervisor
yum install python-setuptools
easy_install supervisor

#check install
supervisord --version

#create config File and directory to hold them
mkdir /etc/supervisor/conf.d
echo_supervisord_conf > /etc/supervisor/supervisord.conf

#create script to give service controls
nano /etc/init.d/supervisord

#paste into file
#!/bin/bash
 
. /etc/init.d/functions
 
DAEMON=/usr/bin/supervisord
PIDFILE=/var/run/supervisord.pid
 
[ -x "$DAEMON" ] || exit 0
 
start() {
        echo -n "Starting supervisord: "
        if [ -f $PIDFILE ]; then
                PID=`cat $PIDFILE`
                echo supervisord already running: $PID
                exit 2;
        else
                daemon  $DAEMON --pidfile=$PIDFILE -c /etc/supervisor/supervisord.conf
                RETVAL=$?
                echo
                [ $RETVAL -eq 0 ] && touch /var/lock/subsys/supervisord
                return $RETVAL
        fi
 
}
 
stop() {
        echo -n "Shutting down supervisord: "
        echo
        killproc -p $PIDFILE supervisord
        echo
        rm -f /var/lock/subsys/supervisord
        return 0
}
 
case "$1" in
    start)
        start
        ;;
    stop)
        stop
        ;;
    status)
        status supervisord
        ;;
    restart)
        stop
        start
        ;;
    *)
        echo "Usage:  {start|stop|status|restart}"
        exit 1
        ;;
esac
exit $?

#save file then make sure it is executable
chmod 755 /etc/init.d/supervisord

#create supervisor config file for laravel
nano /etc/supervisor/conf.d/laravel-worker.conf

#paste contents making changes for your setup
[program:laravel-worker]
process_name=%(program_name)s_%(process_num)02d
command=php /home/forge/app.com/artisan queue:work sqs --sleep=3 --tries=3
autostart=true
autorestart=true
user=forge
numprocs=8
redirect_stderr=true
stdout_logfile=/home/forge/app.com/worker.log

#update main supervisor config to include all configs inside conf.d dir
nano /etc/supervisor/supervisord.conf

#uncomment files area
[include]
files = conf.d/*.conf

#add supervisor to chkservd
nano /etc/chkserv.d/supervisord
service[supervisord]=x,x,x,/etc/init.d/supervisord restart,supervisord,root|supervisord
 
#Add this line to /etc/chkserv.d/chkservd.conf
supervisord:1
 
#If you need to /scripts/restartsrv_tailwatchd as chkservd is now a part of tailwatch

#useful commands
service supervisord start
service supervisord stop
service supervisord status
service supervisord restart

#reread config
supervisorctl reread

#update reread
supervisorctl update

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

#install Supervisor

yum install python-setuptools

easy_install supervisor

#check install

supervisord --version

#create config File and directory to hold them

mkdir /etc/supervisor/conf.d

echo_supervisord_conf > /etc/supervisor/supervisord.conf

#create script to give service controls

nano /etc/init.d/supervisord

#paste into file

#!/bin/bash

. /etc/init.d/functions

DAEMON=/usr/bin/supervisord

PIDFILE=/var/run/supervisord.pid

[ -x "$DAEMON" ] || exit 0

start() {

echo -n "Starting supervisord: "

if [ -f $PIDFILE ]; then

PID=`cat $PIDFILE`

echo supervisord already running: $PID

exit 2;

else

daemon $DAEMON --pidfile=$PIDFILE -c /etc/supervisor/supervisord.conf

RETVAL=$?

echo

[ $RETVAL -eq 0 ] && touch /var/lock/subsys/supervisord

return $RETVAL

}

stop() {

echo -n "Shutting down supervisord: "

echo

killproc -p $PIDFILE supervisord

echo

rm -f /var/lock/subsys/supervisord

return 0

}

case "$1" in

start)

start

;;

stop)

stop

;;

status)

status supervisord

;;

restart)

stop

start

;;

echo "Usage: {start|stop|status|restart}"

exit 1

;;

esac

exit $?

#save file then make sure it is executable

chmod 755 /etc/init.d/supervisord

#create supervisor config file for laravel

nano /etc/supervisor/conf.d/laravel-worker.conf

#paste contents making changes for your setup

[program:laravel-worker]

process_name=%(program_name)s_%(process_num)02d

command=php /home/forge/app.com/artisan queue:work sqs --sleep=3 --tries=3

autostart=true

autorestart=true

user=forge

numprocs=8

redirect_stderr=true

stdout_logfile=/home/forge/app.com/worker.log

#update main supervisor config to include all configs inside conf.d dir

nano /etc/supervisor/supervisord.conf

#uncomment files area

[include]

files = conf.d/*.conf

#add supervisor to chkservd

nano /etc/chkserv.d/supervisord

service[supervisord]=x,x,x,/etc/init.d/supervisord restart,supervisord,root|supervisord

#Add this line to /etc/chkserv.d/chkservd.conf

supervisord:1

#If you need to /scripts/restartsrv_tailwatchd as chkservd is now a part of tailwatch

#useful commands

service supervisord start

service supervisord stop

service supervisord status

service supervisord restart

#reread config

supervisorctl reread

#update reread

supervisorctl update

Setup PostGres DB/USER

Recursive Chmod Files and Directories

Zip and compress a folder for downloading on Command Line

Add Supervisor to Centos/cPanel Server w/chkservd

Categories

Recent Posts