MilesWeb Hosting Forum

Hi Members,

By default the temporary directory for your MySQL server is set to /tmp folder. When you perform any queries, repair the tables, perform tasks on the database, etc; the temporary files are stored in this directory.

Just in case, if the /tmp partition is running out of space you can either delete these files OR create a new directory with large disk space. Assign this directory as temporary directory for MySQL server.

Open MySQL configuration file in your favorite editor

vi /etc/my.cnf

Add the line below & save the file.

tmpdir = /home/mysql-tempdir

Create the folder on your server and set ownership and permissions as below.

chown mysql.mysql  /home/mysql-tempdir
chmod 1777 /home/mysql-tempdir

Restart MySQL service & you have successfully changes the temporary directory.

Cross check it with the command below.

mysqladmin variables | grep tmpdir

Feel free to reply this thread if you face any other issues.

When I tried starting a OpenVZ container on our node, I faced this error below.

Can't umount : Device or resource busy

Make sure if you have any other SSH connections open, or any other connection that may be causing the problem. most of the time it’s just an SSH connection you still have open.

If that doesn't working, perform the steps below.

Shutdown the VPS/container by logging into it OR from the node/host.

By logging into the VPS

# shutdown -h now

By logging in the node

# vzctl stop 999

Now, try to unmount it with command below.

# vzctl umount 999

Finally, check if the VPS is in mounted state

# cat /proc/mounts | grep 999

If it shows to be mounted, umount the directories that shows in the output.

Note: Make sure you replace 999 with actual container ID.

When tying to start iptables on a server, you receive an error as below. Further checking, I found that the required modules for iptables to work are installed/enabled. Still this error.

iptables: Applying firewall rules: FATAL: Module ip_tables not found.
iptables-restore v1.4.7: iptables-restore: unable to initialize table 'nat'

Error occurred at line: 2
Try `iptables-restore -h' or 'iptables-restore --help' for more information.

I had a check at the rules and there were few rules due to which iptables was unable to start. Try flushing the iptables rules OR remove the ones which are incorrectly set.

Try starting iptables & it should work properly.

While accessing the Magento admin panel you receive the error below.

cache_dir must be a directory

Magento stores temporary files in tmp folder, under your website's root directory. To fix the error above, login to your FTP OR File Manager & create directory tmp under website's root directory. Set permissions to 777 on tmp & try accessing Magento Admin Panel.

Looking for quality Magento hosting? Look no further than MilesWeb's Best Magento Hosting plans.

Hi Members,

Recently, I have had this strange issue where one of the table under the database was missing. Here is the error which kept flashing on the website.

SQLSTATE[42S02]: Base table or view not found: 1146 Table '.log_visitor' doesn't exist

I was fortunate that the backups were configured & I restored the database table. But, what if you do not have the backup ? Below is the SQL query you should execute to fix it.

Access phpMyAdmin and select the database. Click on the SQL tab and enter the query below under Run SQL query/queries on database

CREATE TABLE IF NOT EXISTS `log_visitor` (
  `visitor_id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Visitor ID',
  `visitor_type` varchar(1) NOT NULL COMMENT 'Visitor Type',
  `remote_addr` bigint(20) NOT NULL COMMENT 'Remote Address',
  `first_visit_at` timestamp NULL default NULL COMMENT 'First Visit Time',
  `last_visit_at` timestamp NULL default NULL COMMENT 'Last Visit Time',
  `customer_id` int(10) unsigned default NULL COMMENT 'Customer ID',
  `last_url` varchar(255) default NULL COMMENT 'Last URL',
  PRIMARY KEY  (`visitor_id`),
  KEY `IDX_LOG_VISITOR_ONLINE_VISITOR_TYPE` (`visitor_type`),
  KEY `IDX_LOG_VISITOR_ONLINE_FIRST_VISIT_AT_LAST_VISIT_AT` (`first_visit_at`,`last_visit_at`),
  KEY `IDX_LOG_VISITOR_ONLINE_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Log Visitor Online Table'

Click on Go and you table gets created. You should be able to access the website now.

Now that's the reason we say backup plans are important. They come handy if you land in such a mess.

Looking for quality Magento hosting? Look no further than MilesWeb Magento Hosting.

Hi Members,

When trying to add any rule in iptables on your VPS with OpenVZ virtualization, you might receive an error below.

iptables: No chain/target/match by that name

You will have to enable few modules on the node and then for the VPS. On the node, execute commands below.

[root@server ~]#modprobe xt_tcpudp
[root@server ~]#modprobe ip_conntrack
[root@server ~]#modprobe xt_state

If you want to use stateful firewall rules (and you should!) you will also need to make sure that 'ipt_state' is in the 'IPTABLES' option in your vz.conf file

IPTABLES="ipt_REJECT ipt_tos ipt_limit ipt_multiport iptable_filter iptable_mangle ipt_TCPMSS ipt_tcpmss ipt_ttl ipt_length ipt_state"

Restart your container & then try adding the iptables rule. It would work as expected.

Hi All,

When trying to restart the nrpe service (nagios client), you receive an error as below.

nrpe: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory
nrpe: error while loading shared libraries: libcrypto.so.6: cannot open shared object file: No such file or directory

This is because the required libraries for nrpe to function do not exist on the server. A workaround is to copy the current libraries to the one which are required by nrpe.

To check the available libraries, use the command below.

root@server [/usr/local/src]# ls /usr/lib64/libssl*
libssl3.so        libssl.so         libssl.so.10      libssl.so.1.0.1e

root@server [/usr/local/src]# ls /usr/lib64/libcrypto.so*
libcrypto.so         libcrypto.so.10      libcrypto.so.1.0.1e

The above command shows the available ones. Now, copy the libssl.so.10 to libssl.so.6 & libcrypto.so.10 to libcrypto.so.6 with command

root@server [/usr/local/src]# cp -af /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.6
root@server [/usr/local/src]# cp -af /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6

Now, try starting the nrpe service and it should start without any errors.