topic Re: Installing on linux debian, with jboss and postgree..... in Alfresco Archive

Installing on linux debian, with jboss and postgree.....

hsp — Wed, 04 Jan 2006 14:26:07 GMT

Helio, I'm very glad with the possibility to test Alfresco.But I'm in trouble with the installation on this configuration.I've had followed the instructions about postgree and jboss but not sucessfuly.Coud anyone send me a step by step to do Alfresco works on the configuration on the subject above?P

Re: Installing on linux debian, with jboss and postgree.....

hsp — Fri, 06 Jan 2006 16:43:58 GMT

Well, I did it work…..by the way, bymyself. Thanks.
These instructions will be usefull to anyone who find trouble in installation Alfresco with jboss, postgre, debian.
The following steps are needed:

Find the file 'postgres-driver.jar' and place it in the folder /opt/alfresco/jboss/server/default/lib/

Edit the file repository.properties, located in …/WEB-INF/classes/alfresco/
# Database configuration para PostgreSQL

db.driver=org.postgresql.Driver

db.name=alfresco

db.url=jdbcostgresql://localhost/alfresco

db.username=alfresco

db.password=alfresco

Edit the file WEB-INF/classes/alfresco/hibernate-context.xml
change: org.hibernate.dialect.MySQLDialect
to: org.hibernate.dialect.PostgreSQLDialect

To install postgreSql:
apt-get update
apt-get install postgre

after installed, do:
look for the file /etc/postgresql/pg_hba.conf, and uncoment the line content:
host    all         all         127.0.0.1         255.255.255.255
ident sameuser

In the file /etc/postgresql/postgresql.conf add the line: tcpip_socket = true

To configure postgre:
a)su - postgres
b)createuser -W
   You will be asked if the user can create databases, answer yes
   You will be asked if the user can create other users, answer no
   I used a username of alfresco

c)createdb -O alfresco alfresco (that is an O for Owner)

d) psql -d alfresco
e) \du

              List of database users
User name | User ID |         Attributes
————————————————–
alfresco        |     100 | create database
postgres |       1 | superuser, create database

So, go to the directory where the alfresco.sh is, and run: ./alfresco.sh start

http://localhost:8080/portal

user and password: admin.

It must be enough.

Now I'm trying to deploy it to jboss 4 (no portal).

Re: Installing on linux debian, with jboss and postgree.....

kevinr — Fri, 06 Jan 2006 17:59:41 GMT

Glad to hear you have got it working, we haven't yet tried Postgres internally so that's great to hear it works ok on that database.

Yes Alfresco works in JBoss (with a WAR file - very similar to TomCat as it uses TomCat internally as it's Servlet container) or JBossPortal.

Thanks,

Kevin

Re: Installing on linux debian, with jboss and postgree.....

hsp — Wed, 11 Jan 2006 11:27:52 GMT

By the way…..
I'm not sure how to configure the eclipse environment to deploy the alfresco in it, to run with jboss 4. I'd tryed many times, in different ways, but without sucess.
If I create a J2EE Web Project in eclipse, where must I place the alfresco's source files?
Could someone help me with this?

We are getting to develop a web solution for company's documents repository with your alfresco as a engine. We think it is possible, and we'll feed back the community with knowledges we obtained in this period.

Tks
Helio
Curitiba - Brazil

Re: Installing on linux debian, with jboss and postgree.....

davidc — Wed, 11 Jan 2006 11:33:07 GMT

Hi,

Within the source bundle, you will find that we provide the Eclipse project files that we use for development. There are several of them, which all need to be imported into Eclipse. You can find each of them in the sub-directories of /projects e.g. /projects/3rd-party/.project.

Hope that helps.

Re: Installing on linux debian, with jboss and postgree.....

ajr — Wed, 11 Jan 2006 21:34:19 GMT

Upon trying to switch to postgres, we are getting the following error. Seems to have something to do with the dialect:

The dialect was setup correctly in the hibernate-cfg.properties

hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
‍‍

Here is some proof of dialect in the log file:

2006-01-11 16:00:03,871 DEBUG [org.hibernate.cfg.Configuration] dialect=org.hibernate.dialect.PostgreSQLDialect
‍‍

Here is the error:


16:00:38,799 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
16:00:38,799 ERROR [JDBCExceptionReporter] Batch entry 0 insert into node_status (change_txn_id, deleted, protocol, identifier, guid) values (1137013237154:508f4893-82e5-11da-a637-d5cdb3fd5489, 0, system, system, 5102a3d4-82e5-11da-a637-d5cdb3fd5489) was aborted.  Call getNextException to see the cause.
16:00:38,799 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: 42804
16:00:38,799 ERROR [JDBCExceptionReporter] ERROR: column "deleted" is of type bit but expression is of type boolean
16:00:38,803 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:200)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:169)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2033)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2410)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍