topic Re: Alfresco Installation on Ubuntu in Alfresco Archive

Alfresco Installation on Ubuntu

nigelevans — Sun, 29 Jun 2008 20:13:06 GMT

Hi FolksI'm trying (well, failing, mostly) to install Alfresco on Ubuntu. I've spent 2 days scouring web & forums for fixes, and have now got to the point where I don't get any error messages in any of the Alfresco/Tomcat logs when I do sudo ./alfresco.sh start‍ from /opt/alfresco. But when I tr

Re: Alfresco Installation on Ubuntu

spabla — Mon, 30 Jun 2008 23:55:58 GMT

The default http port is 8080, I see you used 8090. Another question what JDK/JVM version did you use? If you used 1.6x, then try 1.5x.

Sarvjit

Re: Alfresco Installation on Ubuntu

mikeh — Tue, 01 Jul 2008 06:57:12 GMT

Looks more like the database couldn't be contacted. Check it's listening on the default port and it's not firewalled off locally.

Mike

Re: Alfresco Installation on Ubuntu

nigelevans — Tue, 01 Jul 2008 08:37:40 GMT

Hi Sarvjit

Thanks for your prompt reply. I'm afraid I made a typo - I WAS using port 8080 (I have now edited my original post).

The default http port is 8080, I see you used 8090. Another question what JDK/JVM version did you use? If you used 1.6x, then try 1.5x.

Java reports the following version.

Java(TM) SE Runtime Environment (build 1.6.0_06-b02)‍

So I guess I need to try version 1.5.

Kind regards,
Nigel

Re: Alfresco Installation on Ubuntu

nigelevans — Tue, 01 Jul 2008 10:15:43 GMT

Hi Mike

Thanks for your post.

Looks more like the database couldn't be contacted. Check it's listening on the default port and it's not firewalled off locally.

I think MySQL is configured to listen on the default port 3306 (not sure how to verify this). I am using eBox, so I have created a network service for this port - that should prevent the firewall from blocking it. I then emptied out the alf_data directory, dropped the database, and created a fresh alfresco database. I then rebooted the server. However, I still get a timeout on :8080\alfresco, and I get the same error messages in catalina.log, as per my original post.

Kind regards,
Nigel

Re: Alfresco Installation on Ubuntu

matthewboh — Wed, 06 Aug 2008 13:05:24 GMT

Nigel - you still listening to this thread? I'm trying to install Alfresco on Ubuntu as well and starting to go through the steps.

Right now, I'm installing some of the other applications that are needed with alfresco - so I've installed hibernate, log4j, lucene, and imagemagick but trying right now to find out if the Bouncy Castle Cryptography Extension can be substituted for the Sun version since there's no package for Ubuntu hardy

So, so far I've done

sudo apt-get install libhibernate-commons-annotations-java liblucene2-java liblog4j1.2-java imagemagick‍

I'm going to try it with libgnucrypto-java and I'll keep updating this entry

Re: Alfresco Installation on Ubuntu

nigelevans — Wed, 13 Aug 2008 08:24:15 GMT

Hi matthew

Yes, I'm still here… And Alfresco still doesn't work on my system! I think the problem is that Tomcat can't connect to MySQL. I have seen several posts that suggest that the Alfresco installation will fail on systems that already have MySQL installed. Since I am installing on a LAMP server, then this may be the cause of the problem. But I can't find out why, or how to fix it.

Kind regards, Nigel

Re: Alfresco Installation on Ubuntu

matthewboh — Wed, 13 Aug 2008 11:09:35 GMT

I've actually given up - it ended up breaking everything else on my system that was running under Tomcat, so I think the idea is to either start with one of their distro's that they recommend or with a completely naked system.

It seems as though it's looking for certain files to be in certain places and I have a feeling that it takes over the Tomcat server on the box, so you can't have other applications running on it. I'll let you know if I try it on another box.

Re: Alfresco Installation on Ubuntu

nigelevans — Wed, 13 Aug 2008 12:08:25 GMT

Hi matthew

Thanks for your comments. I'm inclined to give up, too. Not just because I can't get the installation to work, but because I'm concerned that if the database ever got mangled, then it might prove impossible (or beyond me, at least) to recover the data. It looks like the boring old shared drive is here to stay!

Re: Alfresco Installation on Ubuntu

mikewaters — Wed, 13 Aug 2008 15:45:12 GMT

Bit late maybe, but I have been running 2.1CE and the trunk from a few months ago on Ubuntu Hardy with no insurmountable problems.

If MikeH is right and alfresco can't connect to the db then there are a few things to check

1. is mysql up and running? I guess so if you can log in and drop the db. To be sure try $ netstat -ln | grep 3306
2. make sure you have the mysql jar in the right place - mine is at ./common/lib/mysql-connector-java-5.0.3-bin.jar
3. double check the settings in custom-repository.properties and make sure you can log into the db with the alfresco username and password.
You have to uncomment the database section and the mysql section and make sure the username and password match what is set up in the db

# Sample database connection properties
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=100
‍‍‍‍‍‍

and

# MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco
‍‍‍‍‍

in
./tomcat/shared/classes/alfresco/extension/custom-repository.properties

4. were there any errors when you followed the instructions in README-mysql.txt?

good luck!

Re: Alfresco Installation on Ubuntu

nigelevans — Wed, 13 Aug 2008 16:34:44 GMT

Hi Mike

Thanks for trying to help. In response to your questions, I found the following…
1. If I do

netstat -ln | grep 3306‍

I get

tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN‍

Is that good, or bad?
2. the mysql jar is at ./common/lib/mysql-connector-java-5.0.3-bin.jar
3. I have gazillion checked the settings in custom-repository.properties, and they match the settings in the dB.
4. I can't find a file "README-mysql.txt" on my system, so I don't know what instructions to try.

Comments welcome…

Re: Alfresco Installation on Ubuntu

mikewaters — Wed, 13 Aug 2008 17:03:32 GMT

That's good. its showing that "something" is listening on port 3306.
I would check that you can telnet to this port. I'm sure theres a better way, but try $ telnet localhost 3306
If you get this after a few seconds then there is no firewall issue:

Trying 127.0.0.1…
Connected to localhost.
Escape character is '^]'.
@
5.0.51a-3ubuntu5.1 JiR>}|xe, p&h\rHQ@,XZ9Connection closed by foreign host.
‍‍‍‍‍‍

README_mysql.txt is in the root of the tarball alfresco-community-tomcat-2.9.0B.tar.gz
theres a README.txt too…That might have something new to try… it mentions that you have to
alter custom-hibernate-dialect.properties as well.

Re: Alfresco Installation on Ubuntu

mikewaters — Thu, 14 Aug 2008 09:00:51 GMT

Right now, I'm installing some of the other applications that are needed with alfresco - so I've installed hibernate, log4j, lucene, and imagemagick but trying right now to find out if the Bouncy Castle Cryptography Extension can be substituted for the Sun version since there's no package for Ubuntu hardy

Just a comment on Mattew's post up the thread a bit - I don't think you need to install all these packages - the jar files are shipped with alfresco.

Re: Alfresco Installation on Ubuntu

matthewboh — Sun, 17 Aug 2008 14:56:16 GMT

Does Alfresco want to take over the tomcat server?

I used to be able to go and get the Tomcat welcome page, but now that I've tried to install Alfresco, I get a binding error on port 8180 (which is the port I installed Tomcat 6 to)

Anyway, thanks for the help, but it looks like I have to pull everything back off and restart with the installation since Tomcat appears to be irrevocably broken! Aaaahhhh!

Dr. Waters - interesting business - here's mine - http://www.imparisystems.com - but I'm moving over to work with businesses.

Re: Alfresco Installation on Ubuntu

nigelevans — Mon, 18 Aug 2008 08:40:21 GMT

Hi Mike

Thanks for your help. I tried your suggestions with the following results…

[1] When I try

telnet localhost 3306 ‍

I (eventually) get

Trying 127.0.0.1…
Connected to localhost.
Escape character is '^]'.
@
5.0.51a-3ubuntu5.1GD`70-.@,88QkJnlUA'>CConnection closed by foreign host.
‍‍‍‍‍‍

[2] I found README_mysql.txt and README.txt (operator error ). I can't find any inconsistency between their contents and the way my system is set up.

Kind regards, Nigel

Re: Alfresco Installation on Ubuntu

andre_blum — Mon, 18 Aug 2008 20:05:14 GMT

Guys,

Contrary to what the comments in the properties file say, the mysql-connetor-<version>.jar file is not included in the distribution.
On a debian or ubuntu, you must therefore do:

apt-get install mysql-java‍

Then, the problem is that no java virtual machine can find jars in /usr/share/java. What I do to solve that is create a soft link to the endorsed directory:

ln -s /usr/share/java/mysql-connector-java.jar /opt/alfresco/tomcat/common/endorsed.‍

This should get you out of the mysql connection issues.

greetings
Andre

Re: Alfresco Installation on Ubuntu

matthewboh — Mon, 18 Aug 2008 22:08:25 GMT

Hi Andre,

Thanks, but that doesn't seem to do it for me. I'm trying to install Alfresco 3.0 Labs on an Ubuntu Hardy Heron 8.04 running Tomcat 6.0.18 and Java 6 - I think I'm just too far ahead of the times.

I did this twice today, and followed your instructions. BTW, it's libmysql-java for the apt-get install command - so it read like this -

sudo apt-get install libmysql-java‍

But both times, it hosed my Tomcat install so bad, that just deleting the .war file and removing the alfresco subdirectory from the Tomcat directory wouldn't fix it. The easiest way was to just delete the entire Tomcat directory and install from new.

Re: Alfresco Installation on Ubuntu

nigelevans — Tue, 19 Aug 2008 08:22:26 GMT

Hi Andre

Thanks for your suggestions. I did

sudo apt-get install libmysql-java
sudo ln -s /usr/share/java/mysql-connector-java.jar /opt/alfresco/tomcat/common/endorsed‍‍

but Alfresco still doesn't work, and I don't get any response from TomCat on localhost:8080.

Do you suppose I have to uninstall, and then reinstall everything, again?

Kind regards, Nigel

Re: Alfresco Installation on Ubuntu

mikewaters — Tue, 19 Aug 2008 14:10:49 GMT

Oh dear - still no luck?

Scraping the barrel here but try saving the following code as /opt/alfresco/tomcat/webapps/alfresco/test.jsp while tomcat is running

Then call http://localhost:8080/alfresco/test.jsp in a browser and see what you get. If you get an exception the stack trace should give us a clue…

but on the other hand if you can connect like this (and see "Hello Mike!") then I'm totally at a loss!

Note the code does not make any assumptions about any alfresco tables or data being there - I assume that alfresco never got as far as installing the schema…?

<%@page import="java.sql.*" %>
<%
Connection connection =
    DriverManager.getConnection("jdbc:mysql://localhost:3306/alfresco", "alfresco", "alfresco");
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("select 'Mike' from dual");
rs.next();
String  name = rs.getString(1);

statement.close();
connection.close();
%>
<HTML>
<BODY>

Hello <%=name%>!

</BODY>
</HTML>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Alfresco Installation on Ubuntu

matthewboh — Tue, 19 Aug 2008 14:17:55 GMT

Mike,

Just out of curiosity, which Tomcat / Java / Alfresco versions are you running?

Thanks!