TurnKey Linux Virtual Appliance Library

How to Install MySQL to Standalone Tomcat Appliance

Christos Pras - Wed, 2010/03/24 - 15: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!!!!

 

‹ configuration of zimbra Noob fileserver implementation questions ›
Jeremy Davis's picture

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

OR

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!

Alon Swartz's picture

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

Thank you so much Alon

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

Thank you so much Alon Swartz!!!

Everything is in place now!!

 

Guest's picture

When I run this command:   

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

Run apt-get update

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

Try running

apt-get update

first. If that errors too, check network connections.

Guest's picture

Doing the "apt-get update"

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

reason why

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

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)