Forum: 
Support

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!!!!

 

Jeremy Davis's picture

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

1) just use apt-get, eg:

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

OR

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

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

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!

Alon Swartz's picture

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.

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

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

Thank you so much Alon Swartz!!!

Everything is in place now!!

 

Guest's picture

Guest - Thu, 2010/04/01 - 20:39

When I run this command:

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

I get this response:

  E: Couldn't find package mysql-server

 

 Any ideas?

Jeremy Davis's picture

Jeremy Davis - Fri, 2010/04/02 - 08:36

Try running

apt-get update

first. If that errors too, check network connections.

Guest's picture

Guest - Fri, 2010/04/02 - 18:31

Doing the "apt-get update" worked.  

The root of my problem was that DNS wasn't resolving when  VMWare Workstation was setup using a bridged network connection. 

Thanks!  These appliances are excellent!

Guest's picture

Guest - Sat, 2010/08/14 - 22:09

This is probably why DNS resolution didn't work in your VM (if you're using Shrew Soft VPN - connected or not)...

 

http://communities.vmware.com/message/1444260

Post new comment