How to Install MySQL to Standalone Tomcat Appliance

Christos Pras - Wed, 2010/03/24 - 14:38

Hi there,

Can someone describe how can I install MySQL, phpmyadmin to the Standalone Tomcat Appliance.

I connect with putty bia ssh to the server and try to run the command "aptitude install mysql-server mysql-client libmysqlclient15-dev" but the server returns "bash: aptitude: command not found"

Any idea???? Please help me!!!!

Forum:

Support

Add new comment

2 options

Jeremy Davis - Fri, 2010/03/26 - 04:58

1) just use apt-get, eg:

apt-get install mysql-server mysql-client libmysqlclient15-dev

2) install aptitude first (followed by your above line) ie:

apt-get install aptitude
aptitude install mysql-server mysql-client libmysqlclient15-dev

Hi JedMeister, Firstly thank

Christos Pras - Fri, 2010/03/26 - 09:10

Hi JedMeister,

Firstly thank you for the prompt answer!

I want now to set the enviroment variables with the command "export" for "Apache Ant" , "Java JDK 6", "Apache Tomcat" as:

JAVA_HOME – The Java JDK (NOT the JRE) installation directory.

ANT_HOME – The Apache Ant installation directory.

CATALINA_HOME – The Apache Tomcat installation directory.

The problem is that I don't know where is the installation folders!

I need also the installation folder of the Java JDK in order to copy into MySQL Connector/J v3.1.14 JDBC driver , Sun JavaMail API (v1.4.X).

Please if someone knows the solutions help me!

Already set in /etc/environment?

Alon Swartz - Fri, 2010/03/26 - 09:43

I currently don't have a tomcat instance infront of me, but from my notes most of the variables should already be set in /etc/environment, for example:

CATALINA_HOME="/usr/share/tomcat5.5"
CATALINA_BASE="/var/lib/tomcat5.5"
CATALINA_OPTS="-server -Xms384M -Xmx512M -XX:MaxPermSize=256M"
JAVA_HOME="/usr/lib/jvm/java-6-sun"

BTW, you can perform a search for "package owned files" like this:

dpkg --search pattern ...

This should provide all the path information required. If you think the default installation configuration should include other variables, let us know.

Hi again Alon Swartz, I think

Christos Pras - Fri, 2010/03/26 - 11:20

Hi again Alon Swartz,

I think that the system should include also the "ANT_HOME" also....

Some other thinks that might be in the install could be the "Sun JavaMail API (v1.4.X)" and "MySQL Connector/J v3.1.14 JDBC driver" in case someone install the MySQL.....

Thanks