Inventory Management Systems for Shopify

What options exist for Inventory Management Systems for Shopify?

One of the things that cost clients a lot of time and money is keeping up to date with all of the various shippers they want to use in their shopping cart or dealing with back office inventory management systems. Some of these are older legacy desktop applications that do not connect easily to their online stores.

In terms of shipping, often these back-end systems are responsible for moving the product through an order process (receiving, fulfillment, shipping, etc) that is specific to the merchant’s business.…

How to fix CVE-2016-6662 on cPanel / WHM

CVE-2016-6662 – Remote Root Code Execution / Privilege Escalation (0day exploit)

A new 0-day exploit has been announced for MySQL that can result in remote code execution or privilege escalation.

Apparently, this exploit was announced to Oracle, the owners of MySQL more than 40 days ago and a fix has not yet been released.

You can read about it in greater detail from these sources:

This affects the following MySQL and MySQL “clones”: (excerpted from “LegalHackers.com”)

This exploit / bug works because if the malloc-lib configuration variable is set, the wrapper script mysqld_safe (which runs as root) will preload a user designated shared library before starting the server.…

How to use SMTP to send CS-Cart email

This one will be quick – and it is not usually limited to just CS-Cart users. We see this on Joomla! and certain WordPress plugins as well.

The need:

“I want to be able to send email from my cart using SMTP and a full-fledged email account.”

Should be easy right? Not necessarily. The hosting platform you are on needs to be able to send email outbound from the port you are trying to connect to. This would be your SMTP server.…

How to restrict zone transfers for PCI compliance in WHM – CVE-1999-0532

Recently we had to assist a client with a server that needed to become PCI compliant. One of the issues was: DNS Zone Transfer Allowed, CVE-1999-0532 and the server was running Centos 6 and WHM / cPanel.

Scanning vendors fail this because “unrestricted zone transfers” violate PCI DSS and are considered automatic failing conditions.

Now, there is not a control for this inside of WHM / cPanel so you will need to edit the named.conf file directly.

Here is how to do it:

Adding the following…

allow-transfer {“none”;};
version “”;

to the following section…

options {
allow-recursion { none; };
allow-transfer {“none”;};
version “”;
};

…within the /etc/named.conf file and then restart the named service.…

SSH command for backing up MySQL Databases using a CRON job

Need to dump your databases on a daily hourly basis? How about hourly or every 15 minutes? We have you covered.

How to backup all databases for all users via SSH in Linux (using root) and gzip the output

 

15 2 * * * root mysqldump -u root -p[YOURPASSWORD] –all-databases | gzip > /mnt/disk2/database_data ' %m-%d-%Y'.sql.gz

Note – p[YOURPASSWORD] = -p123456 where your password is “123456”.

How to backup a single database for a single user via SSH in Linux (no compression)

mysqldump -u[USERNAME] -p[PASSWORD] DATABASE > your_backup.sql

 …

How to find large files on a server via SSH

Continuing our series on handy commands to know os one that helps you find large files on your server via SSH.

SSH command for finding files larger than a certain file size

The command for this is quite easy, for our example we will assume you want to find all files that are larger than 1 GB in size and geta list you can use.

Step one: Go into your SSH session and type:

find / -type f -size +1048576k -exec ls -lh {} \; 2> /dev/null | awk ‘{ print $NF “: ” $5 }’  | sort -nrk 2,2

Done!…

How to white list an IP address in Mod Security

Often you will have a ruleset in Mod_Security that you want to override for a specific IP address or within a certain path in a website or an application.

To do this you need to locate or create your Mod_Security white list file, then add this line:

…where

is the ID of the rule you want to override.…

How to create an up-sell feature in Shopify

Shopping cart up-sell feature (using Bold Up-sell App):

The shopping cart up-sell features App allows for special offers to be shown to users when they add a particular product or dollar amount into their cart.

IMPORTANT – this is NOT a discount module. It WILL NOT allow you to specify a discount. This is probably because Shopify doesn’t want conflicts to easily occur in discounting.

This means that you CREATE a discounted product first that is hidden ..  and let it “up-sell” the product at a lower price (or not).…

Cannot connect Outlook 2010 to Office 365

Here’s the first thing to look at for a fix for this issue:

Your Office 365 connection may be failing on IPv6

Things are changing quickly with the adoption of IPv6 addressing. At nearly every step along the way between the seat you sit in and where you ultimately need to connect there’s a lot that may or may not be fully compatible with the IPv6 protocol.

e.g. Network adapters, routers, switches, ISPs, servers, etc.

It is possible that trying to connect over the IPv6 network is most likely the reason your Outlook (2007 – current) is having connection problems.…