Install probs

sunebeermann — Wed, 25 Jul 2007 07:14:19 GMT

Hey I have installed Debian on my server. and Tomcat and the mysql server. now and the Database connector. but i cant get the alfresco server running, is there a better guide on how to get this to work? could anybody help me in getting this up and running?If i install the alfresco.war file with the

Re: Install probs

mikeh — Wed, 25 Jul 2007 08:51:53 GMT

Hi,

You'll have to give us more information in order to help you. What are the error(s) in the log files when you try to start the server?

Thanks,
Mike

Re: Install probs

sunebeermann — Thu, 26 Jul 2007 12:01:17 GMT

Sort of got it working. i installed the "quick way" install and it work okay, but with the hibernat database, and i want to use the mySQL database,

As it is explained in this form you will be prombted with the mysql information doing the install but i did not. how to i convert my install to MySQL afterwards?

http://wiki.alfresco.com/wiki/Linux_Quick_Install

Sune

Re: Install probs

mikeh — Thu, 26 Jul 2007 12:53:50 GMT

You should have a README_mysql_linux text file somewhere, but to save you hunting, here it is:

Optional Install of MySQL
————————-

Alfresco is pre-configured to use the HSQL database, but can easily be
configured to use other databases to use other databases, please visit
the forums and wiki at http://www.alfresco.com for guidelines.

Alfresco requires MySQL 4.1 or higher.

- Browse to http://dev.mysql.com/downloads
- Download the appropriate option (22-50M)
- Install once downloaded
- Use Typical setup type
- You may skip the MySQL.com sign-up
- Configure using options appropriate to required use
- generally, choose default selected options
- choose UTF8 Character set
- install as a Windows service if appropriate
- include MySQL in path
- Test MySQL is installed and running by opening a command prompt and entering:
'mysql -u root -p'
- When prompted, give the password you set during installation. If no errors
are reported, then it is installed and running. Enter 'quit' to exit.

MySQL Database Connector
————————

You may need to add or update the MySQL Java Connector library (required for WAR bundle):
- Download the MySQL Java Database Connector http://dev.mysql.com/downloads/connector/j/
- Copy the JAR file into <container>/common/lib or <container>/server/default/lib

Create Database
—————

Navigate to the '<alfresco>/extras/databases/mysql' folder.

Setup the Alfresco database and user manually by loading the 'db_setup.sql' file
into MySQL, for example, by running the command:
   mysql -u root -p <db_setup.sql

This creates a MySQL database named 'alfresco' with a user account and password
of 'alfresco'. If this fails, it may be because the MySQL service is not
running or that the mysql command cannot be found.

Configure Alfresco
——————

To convert the default installation to MySQL, you simple need to modify 2 files
from the tomcat/shared/classes/alfresco/extension directory that are set to use
HSQL. Those files are:

- custom-repository.properties
     - comment out the HSQL connection lines using #
     - uncomment the MySQL connection lines and adjust as appropriate
- custom-hibernate-dialect.properties
     - comment out the HSQL line using #
     - uncomment the MySQL line

Thanks,
Mike

Re: Install probs

sunebeermann — Thu, 26 Jul 2007 15:19:41 GMT

Its alive. Great the database working an stuff just loads as it should thank you

topic Re: Install probs in Alfresco Archive

Install probs

Re: Install probs

Re: Install probs

Re: Install probs

Re: Install probs