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
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking [mysql.server] user=mysql
basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log
$ service mysqld restart
Below set of steps involve setting up Tomcat 6 on CentOS 5 with Java 1.6
Download Apache Tomcat
$ wget http://apache.parentingamerica.com/tomcat/tomcat-6/v6.0.36/bin/apache-tomcat-6.0.36.tar.gz
Go to opt/ folder and extract Tomcat
$ cd /opt
$ tar -xzf apache-tomcat-6.0.36.tar.gz
Create a tomcat user
$ useradd -d /opt/apache-tomcat-6.0.36/ tomcatuser
Change user permission on tomcat folder
$ chown -R tomcatuser:tomcatuser apache-tomcat-6.0.36
At the time of writing this article Java 6 (update 37) was available at http://www.java.com/en/download/manual_v6.jsp
First set up a folder where you want to install java
$ cd /opt
$ wget http://download.oracle.com/otn-pub/java/jdk/6u37-b06/jdk-6u37-linux-x64-rpm.bin
$ chmod +x jdk-6u37-linux-x64-rpm.bin
To check the current installation of java
$ rpm -qa | grep jre
$ rpm -qa | grep jdk
$ rpm -qa | grep openjdk
To remove the java installs
$ yum erase jre jdk openjdk
Fail2ban is a software used to ban IP’s which shows strange behavior. It can be configured to reject IP’s for a certain amount of time.
To install Fail2ban we need to download the application from the source. Login as the root user and go to /opt
$ cd /opt
$ wget http://downloads.sourceforge.net/project/fail2ban/fail2ban-stable/fail2ban-0.8.4/fail2ban-0.8.4.tar.bz2?use_mirror=transact
Next unzip the downloaded file
$ tar -xf fail2ban-0.8.4.tar.bz2
$ cd fail2ban-0.8.4
This error pops up when you try to stop the Tomcat server when the server has not started. If you restart the Tomcat server, the error vanishes.
Main is a static code block and to call a method within the same class you need to declare the other method also as static if you would want to execute the method during run time without instantiating it as an object.
Static methods are class methods and the methods without static keyword in them are instance methods.
– Buffered reader reads text from a character input stream and buffers those characters
– Buffered reader has a buffer size of 8 KB
– Buffered reader is synchronized and can be safely called from multiple threads
– To parse for primitive data types additional functions needs to be called
– Scanner breaks down input into tokens and translates individual tokens according to their data type
– Scanner has a buffer size of 1KB
– Scanner is not synchronized
– Scanner can parse for primitive types and strings using regular expressions
CSV is flat file with the data separated by commas. If we needn’t have to establish a relationship in the data presented in the CSV file, then we can go with storing the data as CSV and manipulate the content for display in the web pages.
XML allows hierarchical representation of data. Data in XML is more readable when it comes to presenting the data. Data can easily be validated with XSD and can be accessed with a couple of lines of code. Huge advantage of XML is its flexibility to establish relationship in data.
To setup Rails on windows after Ruby and Rails setup,
i) Edit hosts file in windows environment and set the server name in the hosts file to
In this example, i have used “myrails” as the server name for the project.
ii) Edit httpd configuration setting on WAMP to make sure proxy and proxy_http module is turned on (check if it those lines are not commented out)
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_http_module modules/mod_proxy_http.so