Installation on JBoss

[tsukanov]

Dear Colleagues,

I have some problem with installation Alfresco on JBoss-4.2.3. I tried version 2.9 and received the next error:

Error creating bean with name 'usageQuotaProtector' defined in class path resource [alfresco/usage-services-context.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection Caused by: org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at   org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

Then I tried the version 2.1 and again have the next error but with another bean:

Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]:  Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback:
org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@11a9435

I will appreciate it very much if someone will help me to solve this problem.

                                          Alexander Tsukanov

[tsukanov]

Maybe it is connected with version of Tomcat? JBoss 4.2.3 uses version 6.* and Alfresco works with Tomcat 5.5.

[tsukanov]

I did the next steps in the process of installation
1. I created the directory c:\Jboss-Alfresco.
2. I installed JBoss-4.2.3GA in this directory.
3. I created file start.bat with the next context:
   
@echo off
cd bin
run.bat –c default

4. I created file stop.bat with the next context:

@echo off
cd bin
shutdown.bat –S

5. I changed parameter Hibernate Bytecode in the file \jboss\server\default\deploy\ejb3.deployer\META-INF\persistence.properties
on the next 
hibernate.bytecode.provider=cglib .

6. I added parameter JAVA_OPTS in file ../bin/run.but

      set JAVA_OPTS=%JAVA_OPTS% -XX:MaxPermSize=128m

7. I added the next lines in file alfresco.war\WEB-INF\web.xml:

<context-param>
  <param-name>org.jboss.jbossfaces.WAR_BUNDLES_JSF_IMPL</param-name>
  <param-value>true</param-value>
</context-param>

    8. I checked the server with console  JMX. (http://localhost:8080/jmx-console) .
OK
9. I installed MySQL – OK
10. I created DB Alfresco
   mysql -u root -p <db_setup.sql – OK

11. I changed the file ..\default\deploy\ hsql-ds.xml on file mysql-ds.xml with the next context:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
      <local-tx-datasource>
           <jndi-name>JbpmDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/alfresco</connection-url>
                 <driver-class>com.mysql.jdbc.Driver</driver-class>
                 <user-name>root</user-name>
                 <password>alex</password>
                         <min-pool-size>10</min-pool-size>
                      <max-pool-size>100</max-pool-size>
                 <idle-timeout-minutes>5</idle-timeout-minutes>
       <metadata>
               <type-mapping>MySQL</type-mapping>
       </metadata>
    </local-tx-datasource>
</datasources>

Here “root” – name of administrator of MySQL and  “alex” - psw
12. I copied JDBC driver  mysql-connector-java-5.0.3-bin.jar in  …/server/default/lib.

13. I copied the file 'imconvert.exe' from 'C:\alfresco\bin'  in system directory 'C:\windows\system32'.

14. I copied file alfresco.war in  …\server\default\deploy

15. I created in  server/default/conf/ new directory  alfresco/.

16. I copied in this directory extension and  messages from …/war/extensions .

17. I changed hibernate-dialect in the file custom-hibernate-dialect.properties on  MySQL

org.hibernate.dialect.MySQLInnoDBDialect.

18. I created directories
C:/Jboss-Alfresco/alf_data
C:/Jboss-Alfresco/alf_data/lucene-indexes

19. I changed file custom-repository.properties in  ..server/default/conf/ alfresco/

#
# Sample custom content and index data location
#
dir.root=C:/Jboss-alfresco/alf_data
dir.indexes=C:/Jboss-alfresco/alf_data/lucene-indexes
…
…
#
# HSQL connection
#
#db.driver=org.hsqldb.jdbcDriver
#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;

…
…

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


#
# MySQL connection
#
mysql#db.driver=com.mysql.jdbc.Driver
mysql#db.url=jdbc:mysql://localhost:3306/alfresco

20.    I connected  OpenOffice with  Alfresco
- created directory
C:\JBoss-Alfresco\oouser
- changed file  openoffice-startup-context.xml in server\default\conf\alfresco\extension\bootsrap\ with next context:


<entry key=".*">
                  <value><![CDATA["C:/Program Files/OpenOffice.org 2.3/program/soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file:///C:/Jboss-Alfresco/oouser" -nologo -headless -nofirststartwizard -nocrashrep -norestore]]></value>
              </entry>

After that I tried to start JBoss and again have error with deployment!
What is wrong?

[tsukanov]

I changed the file alfresco.bat with the next rows:

set ALF_HOME=%~dp0
…

set JAVA_OPTS=%JAVA_OPTS% -XX:CompileCommand=exclude,org/apache/lucene/index/IndexReader$1,doBody -XX:CompileCommand=exclude,org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger,mergeIndexes -XX:CompileCommand=exclude,org/alfresco/repo/search/impl/lucene/index/IndexInfo$Merger,mergeDeletions

Again deleted and satrted DB Mysql and Alfresco 2.9 is working.

But deploing process has one the next error:

11:51:33,203 INFO  [STDOUT] 11:51:33,203 Userystem ERROR [alfresco.smb.protocol] CIFS server configuration error, NetBIOS SMB, TCP/IP SMB or Win32 NetBIOS must be enabled
org.alfresco.error.AlfrescoRuntimeException: NetBIOS SMB, TCP/IP SMB or Win32 NetBIOS must be enabled

I tried to add the file win32netbios.dll in the different directories, but deploing process failed again.