Unable to run Alfresco V1.2.0 for the very first time!

[traja47]

We have already pre-installed on our machine:

C:\Program Files\Java\jdk1.5.0_03
C:\apache-tomcat-5.5.16
C:\Program Files\MySQL\MySQL Server 5.0
C:\mysql-connector-java-3.1.12

We've downloaded:
alfresco-war-1.2.0.zip

and copied file alfresco.war to
C:\apache-tomcat-5.5.16\webapps

a) MySQL is already running as a service
b) We start manually tomcat by typing
C:\apache-tomcat-5.5.16\bin\startup.bat

When we try to access alfresco by launching a web browser
http://localhost:8080/alfresco

We get a blank page

HTTP Status 404 - /alfresco/

type Status report

message /alfresco/

description The requested resource (/alfresco/) is not available.
Apache Tomcat/5.5.16

Any ideas???

thanks

Trajano

[gavinc]

Ah, there's the problem! You are not getting a successful connection to MySQL.

As it worked in the bundle I presume you have MySQL installed and running. Therefore the likely problem is that you do not have the MySQL connector in your pre-installed Tomcat.

Copy mysql-connector-java-3.1.12-bin.jar from <alfresco>/projects/3rd-party/lib (or download it from mysql.com) to <tomcat>/common/lib and restart Tomcat.

[davidl]

Sorry, I probably shouldn't have said that I have it exactly like the original poster.   However, I got the basically the same symptoms.

I only had MySql already installed on my machine.   Everything else I either downloaded (JDK1.5) or it came with the bundle already (Tomcat).   The Tomcat installation already had the JConnector class in the directory (specifically; C:\alfresco\tomcat\common\lib). 

I've checked MySql and was able to log in as the alfresco user.  Queried for table and got an empty set.  Is there, perhaps, a port on the MySql server that Alfresco is looking for?  I.e., I recall a port selection being something to the extent of 3306 as default.  Although I changed my to 3308. 

Other than that I'm not quite sure what else it could be.

Thanks,
-dl

[steve]

Hello,

If you have changed the port that MySQL is running on you will have to modify the Alfresco database configuration to use this port.

The base configuration for this is within 'repository.properties' within the tomcat\webapps\alfresco\WEB-INF\classes\alfresco directory.
Look for the line 'db.url=jdbc:mysql:///${db.name}'

Create yourself a configuration file in the extensions location to override this value (see the wiki on how to do this).

The syntax for the connection string can be found on the MySQL website here: http://dev.mysql.com/doc/refman/4.1/en/cj-configuration-properties.html

Hope this helps,

Steve

[davidl]

Steve,

Thanks for the help.  I just saved myself some time and reinstalled MySql with the default port setting (especially since Wiki says it's not recommended to override the configuration).

After reinstalling it has worked correctly.

Thanks!

-dl