True Light Designs Blog

Install PostGres 9 on cPanel Server

Tuesday, 02 May 2017 02:08

Tim Ramsey

0 Comments

I currently installed v9.6 1. Add it to repo

yum install http://yum.postgresql.org/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm

1	yum install http://yum.postgresql.org/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm

2. Install Packages

yum install postgresql96-server.x86_64 postgresql96-devel.x86_64 postgresql96.x86_64

1	yum install postgresql96-server.x86_64 postgresql96-devel.x86_64 postgresql96.x86_64

3. Add to exclude from yum update – edit /etc/yum.conf

#add the following to the end of "exclude="
postgresql*

1 2	#add the following to the end of "exclude=" postgresql*

3.a Create symlinks where cPanel Expects to find it

ln -s /var/lib/pgsql/9.6/data /var/lib/pgsql
ln -s /var/lib/pgsql/9.6/backups /var/lib/pgsql

1 2	ln -s /var/lib/pgsql/9.6/data /var/lib/pgsql ln -s /var/lib/pgsql/9.6/backups /var/lib/pgsql

4. Install postGres in cPanel

/scripts/installpostgres

1	/scripts/installpostgres

There is more information about back-up/etc here – https://documentation.cpanel.net/display/CKB/Install+or+Update+PostgreSQL+on+Your+cPanel+Server 5. Install symlinks

cd /usr/pgsql-9.6/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done
cd /var/lib/pgsql; ln -s 9.6/backups; ln -s 9.6/data; ln -s 9.6/pgstartup.log

1 2	cd /usr/pgsql-9.6/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done cd /var/lib/pgsql; ln -s 9.6/backups; ln -s 9.6/data; ln -s 9.6/pgstartup.log

6. Initialize and configure to run at startup

service postgresql-9.6 initdb
chkconfig postgresql-9.6 on
/etc/init.d/postgresql-9.6 start

service postgresql-9.6 initdb

chkconfig postgresql-9.6 on

/etc/init.d/postgresql-9.6 start

7. Configure in WHM

WHM > Configure PostgreSQL > Install Config
WHM > Configure PostgreSQL > Create Users
WHM > Configure PostgreSQL > Change password (Generate new one)

WHM > Configure PostgreSQL > Install Config

WHM > Configure PostgreSQL > Create Users

WHM > Configure PostgreSQL > Change password (Generate new one)

8. Install/Update phpPgAdmin

/usr/local/cpanel/bin/updatephppgadmin

1	/usr/local/cpanel/bin/updatephppgadmin

9. Restart

/etc/init.d/postgresql-9.6 restart

1	/etc/init.d/postgresql-9.6 restart

10. Add to /etc/chkserv.d

postgresql:1

1	postgresql:1

11.Restart tailwatchd

/scripts/restartsrv_tailwatchd

1	/scripts/restartsrv_tailwatchd

Get around M2E “The only common (presented in all Attribute sets) “Text Field” or “Dropdown” Attributes available for selection.”

Thursday, 30 March 2017 14:14

Tim Ramsey

0 Comments

Change function around line 170 in app\code\community\Ess\M2ePro\Helper\Magento\Attribute.php from:

private function _getGeneralFromAttributeSets(array $attributeSetIds)
    {
        if (count($attributeSetIds) > 50) {
            throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 50");
        }

        $attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')
            ->addVisibleFilter()
            ->setInAllAttributeSetsFilter($attributeSetIds)
            ->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

        return $attributeCollection->getAllIds();
    }

private function _getGeneralFromAttributeSets(array $attributeSetIds)

{

if (count($attributeSetIds) > 50) {

throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 50");

}

$attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')

->addVisibleFilter()

->setInAllAttributeSetsFilter($attributeSetIds)

->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

return $attributeCollection->getAllIds();

}

to:

private function _getGeneralFromAttributeSets(array $attributeSetIds)
    {
        if (count($attributeSetIds) > 500) {
            throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 500");
        }

        $attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')
            ->addVisibleFilter()
            ->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

        return $attributeCollection->getAllIds();
    }

private function _getGeneralFromAttributeSets(array $attributeSetIds)

{

if (count($attributeSetIds) > 500) {

throw new Ess_M2ePro_Model_Exception("Attribute sets must be less then 500");

}

$attributeCollection = Mage::getResourceModel('catalog/product_attribute_collection')

->addVisibleFilter()

->setOrder('frontend_label', Varien_Data_Collection_Db::SORT_ORDER_ASC);

return $attributeCollection->getAllIds();

}

Setup PostGres DB/USER

Thursday, 16 March 2017 23:00

Tim Ramsey

0 Comments

#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).

Recursive Chmod Files and Directories

Thursday, 09 March 2017 22:38

Tim Ramsey

0 Comments

#directories
find magento/ -type d -exec chmod 755 {} \;

#files
find magento/ -type f -exec chmod 644 {} \;

#directories

find magento/ -type d -exec chmod 755 {} \;

#files

find magento/ -type f -exec chmod 644 {} \;

Page 7 of 12

Install PostGres 9 on cPanel Server

Get around M2E “The only common (presented in all Attribute sets) “Text Field” or “Dropdown” Attributes available for selection.”

Setup PostGres DB/USER

Recursive Chmod Files and Directories

Categories

Recent Posts