If you receive an error message like
Error Table 'table.wp_wc_follow_users' doesn't exist, you may have inadvertently caused the problem by updating two plugins at the same time. I was updating the wp support and wp disquz tables, received an error, and afterwards started seeing this error.
To fix it, use the sql query below. When doing so, make sure you execute it on the correct database.
Continue reading WordPress Error Table ‘alertadigital.wp_wc_follow_users’ doesn’t exist
This post describes the process of forcing all HTTP traffic to HTTPs.
If we all lived in a perfect world, there would be no need for security. However, we don't, so there is.
One way you can help increase the security of your site and therefore your data, is to only implement ssl protocol in the server, or to block non ssl traffic via the firewall.
Continue reading Apache — Redirect all HTTP requests to HTTPS
Always drives me crazy, seems one day my Tivoli backups stop working and we have to enter the password again, this usually causes the service to stop working with the error that is the title of this article.
IF this occurs, do the following;
Continue reading ANS2050E TSM needs to prompt for the password but cannot prompt because the process is running in the background.
I occasionally get requests from users looking to determine DNS entries for a domain, but they are not sure of the name or ip address. (Trust me, this really does happen).To fulfill these requests, I generally need to list all domain entries and then review to find out the information.
To do this, it is slightly different on Linux and windows systems. Continue reading Nslookup to list all domain addresses
I recently had a database that was growing at an alarming rate. I needed to determine which table was consuming the space to see if I could do some pruning.
During my research I was able tl locate the following command which worked wonderfully for my purposes.
Note: for this command to work you need a MySQL instance of at least version 5.0.
Continue reading MySQL database too Large
Below is the process used to change the ip, interface and Tumbleweed (Secure Transport v5.1) settings to move server to new location.
It even includes the timeline.
It is expected that the new interface is setup prior to this process.
Modified /etc/sysconfig/network-scripts/ifcfg-em2, change “DEFROUTE=no” to “DEFROUTE=yes”.
Modified /etc/sysconfig/network-scripts/ifcfg-em1, change “DEFROUTE=yes” to “DEFROUTE=no”.
ifdown em2 && ifup em2 && ifdown em1
Modified /etc/hosts and commented out old ip, added new ip
Changed Setup->Allowed Server to new ip
I am unable to ping between edge and server. Dropped local firewalls and still unable to ping.
Noticed that firewall is natting xx.xxx.xxx.xxx to default hide.
Adding identity nat to ensure ip stays as internal when connecting to yyy.yyy.yyy.yyy.
Identity nat worked to correct the issue.
Old st2 ip. == ppp.ppp.ppp.ppp
Administrators of InnoDB databases will recognize that InnoDB tables grow in size...but never shrink.
Whether this is a bug or a feature has been heavily discussed in years past, check here or here for more information, but either way the problem is that an InnoDB will grow the ibdata file, but not shrink it.
Continue reading Shrinking a MySQL Database
In Linux, it is possible to delete a file that has been opened by multiple processes. If you stop one of the process and delete the file without stopping the other process, the system will still show the disk space as being used.
I recently had this happen, I had a MySQL database that was using 29GB of storage space. I stopped the database, deleted the files and recreated the database. Once complete, I noticed that I didn't reclaim any of the used space.
Continue reading Whats eating my disk space? (Invisible files)