# Genesys PGR - Gateway to genetic resources

**Note:** This is the source code of the Genesys PGR Portal implementation running at <https://www.genesys-pgr.org>

These instructions will help you run a copy of the Genesys portal (without the data) for testing and development purposes.

## Running genesys2-server with Docker

```shell
docker run dockerhub.croptrust.org/genesys-pgr/genesys-server:2.3
```

The genesys container can be configured via environment variables (`-e` docker flag).

## Running genesys2-server with maven

- Clone genesys2-server to your computer
- Create a blank mysql database
- Configure genesys2-server database connection settings
- Start Jetty with `mvn -Dspring.profiles.active=dev jetty:run`

### Creating a mysql database

Connect to your mysql instance and create a new blank database **genesys**:

```sql
-- Create database
CREATE DATABASE genesys DEFAULT CHARSET UTF8;

-- Create user genesys with password pwd
GRANT ALL ON genesys.* TO 'genesys'@'localhost' IDENTIFIED BY 'pwd';
```

Change the settings in `src/main/resources/spring/spring.properties`:

```.properties
# genesys2 with mysql database
db.url=jdbc:mysql://localhost/genesys?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
db.driverClassName=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
db.username=genesys
db.password=pwd
db.showSql=false
# Allow hibernate to update database (development/testing mode only)
db.hbm2ddl=update
```