Page History

Archiva On GlassFish with MySQL

General server configuration

• Ensure that the property appserver.base is set. Archiva uses this to locate log files.

Glassfish web configuration

...

• Create the two needed databases:
  CREATE DATABASE users;
  CREATE DATABASE archiva;
• Create account to access them:
  GRANT ALL PRIVILEGES ON users.* TO 'users'@'*' IDENTIFIED BY 'users' WITH GRANT OPTION;
  GRANT ALL PRIVILEGES ON archiva.* TO 'archiva'@'*' IDENTIFIED BY 'archiva' WITH GRANT OPTION;

Note: the tables should be latin1 character set. If you use UTF8 you ran out of max key length:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

Glassfish file configuration

...

• Set appserver.base and appserver.home properties

  Ensure that the property appserver.base is set. Archiva uses this to locate log files.

  Code Block
  ... <java-config ... <jvm-options>-Dappserver.base=${com.sun.aas.installRoot}/domains/domain1</jvm-options> <jvm-options>-Dappserver.home=${com.sun.aas.installRoot}/domains/domain1</jvm-options> ...

...