|
1 |
PHP Fatal error: Call to undefined function: hex2bin() in |
|
1 2 3 4 5 6 7 8 9 10 |
if (!function_exists('hex2bin')){ function hex2bin($h) { if (!is_string($h)) return null; $r = ''; for ($a = 0; $a < strlen($h); $a += 2) { $r .= chr(hexdec($h{$a}.$h{($a + 1)})); } return $r; } } |
|
1 |
yum install http://yum.postgresql.org/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm |
|
1 |
yum install postgresql96-server.x86_64 postgresql96-devel.x86_64 postgresql96.x86_64 |
|
1 2 |
#add the following to the end of "exclude=" postgresql* |
|
1 2 |
ln -s /var/lib/pgsql/9.6/data /var/lib/pgsql ln -s /var/lib/pgsql/9.6/backups /var/lib/pgsql |
|
1 |
/scripts/installpostgres |
|
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 |
|
1 2 3 |
service postgresql-9.6 initdb chkconfig postgresql-9.6 on /etc/init.d/postgresql-9.6 start |
|
1 2 3 |
WHM > Configure PostgreSQL > Install Config WHM > Configure PostgreSQL > Create Users WHM > Configure PostgreSQL > Change password (Generate new one) |
|
1 |
/usr/local/cpanel/bin/updatephppgadmin |
|
1 |
/etc/init.d/postgresql-9.6 restart |
|
1 |
postgresql:1 |
|
1 |
/scripts/restartsrv_tailwatchd |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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(); } |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
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(); } |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
#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). |