topic Re: Install on existing Postgresql in Alfresco Archive

Install on existing Postgresql

kvram25 — Wed, 24 Sep 2014 08:38:20 GMT

Hi,I have downloaded community latest version 64 bit installer.I already have a postgresql installed on my pCIn spite of the Wiki docs and other web resources I am unable to configure and setup Alfresco CE.Can you please tell how this is to be done in a scenario where postgresql is already running o

Re: Install on existing Postgresql

lementree — Wed, 24 Sep 2014 09:56:39 GMT

Hi,

With the installer you cant install with exsting tomcat, but you can install with exsting postgres.
for that uncheck postgres from advanced installation, then give the database name that you have created for alfresco in exsting postgres.

Re: Install on existing Postgresql

kvram25 — Wed, 24 Sep 2014 12:11:23 GMT

Hi Sagar,

I tried installing the installer in another PC which did not have POSTGRESQL but had a TOMCAT installed.
So using Advance Installation option I changed the default ports for TOMCAT from 8xxx to 9xxx. for example port 8080 I set to 9080 and so on. Then installation proceeded smoothly.
But When I try to log-in using url http://localhost:9080/Alfresco then the home page does not load. Neither do i get an error message. The rotating Waiting logo in the browser keep rotatiing endlessly. Nothis happens beyond that.
The question is if this is a correct way to set up Alfresco's own Tomcat instance with different port.
The second question is Now If I want to use MYSQL as backend database instead of Posrgresql, what to do to change the configuration.

Pls advise.

Ram

Re: Install on existing Postgresql

kvram25 — Wed, 24 Sep 2014 12:20:02 GMT

Hi,

Please let me know detailed process for downloading ZIP while and then manually configuring the WAR files to existing TOMCAT server and establishing connection to MYSQL database

Ram

Re: Install on existing Postgresql

mrogers — Wed, 24 Sep 2014 12:48:37 GMT

Have you read any of the documentation? This is well documented.

To change your database simply change the database settings in alfresco-global.properties

e.g.
{code}
db.name=alf_fivezero
db.username=alf_fivezero
db.password=alf_fivezero

db.host=localhost
db.port=3306

#
# MySQL connection
#————-
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}

{code}

You will need to create an empty schema on your database and account for alfresco to use
create database alf_fivezero DEFAULT CHARACTER SET utf8;
grant all on alf_fivezero.* to 'alf_fivezero'@'localhost' identified by 'alf_fivezero' with grant option;
grant all on alf_fivezero.* to 'alf_fivezero'@'localhost.localdomain' identified by 'alf_fivezero' with grant option;

Re: Install on existing Postgresql

mrogers — Wed, 24 Sep 2014 12:55:58 GMT

Here's my create script for postgreql.   Although I used the pgadmin tool to create the database and connection.

{code}
CREATE DATABASE alf_fourone
WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'English_United Kingdom.1252'
       LC_CTYPE = 'English_United Kingdom.1252'
       CONNECTION LIMIT = -1;

CREATE ROLE alf_fourone LOGIN
ENCRYPTED PASSWORD 'md5a963ed7949076827a104ff5522bc496f'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

GRANT ALL ON DATABASE alf_fourone TO public;
GRANT ALL ON DATABASE alf_fourone TO postgres;
GRANT ALL ON DATABASE alf_fourone TO alf_fourone;
{code}

Here are my properties from alfresco-global.properties

{code}
db.name=alf_fourone
db.username=alf_fourone
db.password=alfresco

#
# PostgreSQL connection
#————-
db.driver=org.postgresql.Driver
db.url=jdbcostgresql://${db.host}/${db.name}
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
{code}

Re: Install on existing Postgresql

kvram25 — Wed, 24 Sep 2014 14:28:41 GMT

I have read the WIKI docs but could not succeed in spite of following instructions.
Please let me have the link to a updated doc which covers manual installation on existing TOMCAT and also manually configuring MYSQL
As advised by you the alfresco-global.properties file has all lines commented out except one line which says "alfresco.rmi.services.host=0.0.0.0"
Do I need to remove comments on certain lines based on DB type etc?

Pls advise.
Regards,
Ram

Re: Install on existing Postgresql

amitabhandari1 — Tue, 18 Nov 2014 06:12:42 GMT

Hi

I have 2 Alfresco (version 4.2.2) installed where in one Alfresco instance - complete installation done including java , tomcat and postgres and other instance is just pointing to installed postgres and java.

While installing another Alfresco instance I just want to configure database with Advance install option through Alfresco Installer.

My concern is I am unable to create database using pgadmin tool. All privileges of create DB and role are assigned to SYSTEM user. This user was created while installing first Alfresco instance .

How do I assign createDB role to alfresco User.
Where is password for SYSTEM user store?

Thanks