When trying to import large SQL dump, you often get the above message. Remedy for this issue is to increase the packet size of MySQL's daemon by setting a packet size of max_allowed_packet. Sudo to your account and set the following root $ mysql -u admin -p mysql> set global net_buffer_length=1000000; mysql> set global max_allowed_packet=1000000000; In the command line, issue the command $ mysql --max_allowed_packet=128M -uUSER -pPASSWORD database < database.sql.dump

After VPS reboot, you may encounter this issue and the fix is simple. Follow these stops to prevent this error. $ service mysqld stop $ mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak $ service mysqld start

Apache server is installed by default on Mac. Access the configuration settings for Apache by going to $ cd /etc/apache2/ $ vi httpd.conf To enable php, edit httpd.conf and uncomment the line #LoadModule php5_module libexec/apache2/libphp5.so Uncomment other lines that you may want to load in your system. As you are enabling PHP in your system, you may want to change the DirectoryIndex to DirectoryIndex index.php index.html Default group/user settings inside Apache on Mac is _www:_www (more…)

When we began creating an application using Struts2 framework with Hibernate and MySQL, we ran into a problem which was related to MySQL timing out its connection after a span of 8 hours when left unused. It conceived a lot of time at our end but we were able to nail down the issue at the end. Steps that we had taken to correct the issue related to Hibernate MySql connection timeout problem are listed below - Download Hibernate C3P0 and copy .jar files - Set c3p0.properties - Make changes to hibernate.cfg.xml - Test MySQL connection timeout - Hibernate, MySQL connection timeout related error messages (more…)

List the listening ports and check if mysql is listed on it. $ netstat -tln | grep mysql If you cannot find the port number for mysql view my.cnf file to see if you can find the port number. If you see a line "skip-networking" try commenting out the line and then restart mysql daemon. $ vi /etc/my.cnf [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-networking [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid $ service mysqld restart

For this tutorial we will be using Ruby 1.9.3 and Rails 3.2.1 First thing update $ sudo apt-get update Next, we are going to install git, RVM which is essential for the build $sudo apt-get install build-essential git-core curl RVM stands for Ruby Version Manager that is used for installing and managing multiple versions of Ruby at one point of time. (more…)