onedev/server

Docker - Unable to work with MySQL (OD-2268)

مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ opened 11 months ago

Hello folks,

I'm trying to get OneDev to work with MySQL, but it doesn't seem to work for me. Perhaps I am doing something wrong. Any help would be appreciated - thank you.

Docker compose file

services:
  app:
    image: 1dev/server:11.6.13
    links:
      - mysql
    depends_on:
      - mysql
    env_file:
      - .env
    ports:
      - "8080:6610"
      - "6611:6611"
    volumes:
      - ./onedev/data:/opt/onedev
    privileged: true
    container_name: app

  mysql:
    image: mysql:8
    env_file:
      - .env
    container_name: mysql
    volumes:
      - ./mysql/data:/var/lib/mysql
    ports:
      - "3306:3306"

The .env file

# onedev
hibername_dialect="org.hibernate.dialect.MySQL5InnoDBDialect"
hibernate_connection_driver="com.mysql.cj.jdbc.Driver"
hibernate_connection_username="onedev"
hibernate_connection_password="onedev"
hibernate_connection_url="jdbc:mysql://mysql:3306/onedev?serverTimezone=UTC&allowPublicKeyRetrieval=true&useSSL=false&disableMariaDbDriver=true"

# MYSQL
MYSQL_ROOT_PASSWORD="root"
MYSQL_USER="onedev"
MYSQL_PASSWORD="onedev"
MYSQL_DATABASE="onedev"

The database exists. I've even been able to connect to it using the mysql cli.

For hibername_dialect I've also tried MySQL57InnoDBDialect and MySQL5DBDialect, but with no luck.

This is what I always get, the famous NullPointer Exception from Java 🙂 :

app    | --> Wrapper Started as Console
app    | Java Service Wrapper Standard Edition 64-bit 3.5.51
app    |   Copyright (C) 1999-2022 Tanuki Software, Ltd. All Rights Reserved.
app    |     http://wrapper.tanukisoftware.com
app    |   Licensed to OneDev for Service Wrapping
app    |
app    | Launching a JVM...
app    | WrapperManager: Initializing...
app    | INFO  - Launching application from '/app'...
app    | INFO  - Starting application...
app    | INFO  - Successfully checked /opt/onedev
app    | INFO  - Stopping application...
app    | <-- Wrapper Stopped
app    | --> Wrapper Started as Console
app    | Java Service Wrapper Standard Edition 64-bit 3.5.51
app    |   Copyright (C) 1999-2022 Tanuki Software, Ltd. All Rights Reserved.
app    |     http://wrapper.tanukisoftware.com
app    |   Licensed to OneDev for Service Wrapping
app    |
app    | Launching a JVM...
app    | WrapperManager: Initializing...
app    | 10:45:50 INFO  i.onedev.commons.bootstrap.Bootstrap - Launching application from '/opt/onedev'...
app    | 10:45:50 INFO  i.onedev.commons.bootstrap.Bootstrap - Cleaning temp directory...
app    | 10:45:50 INFO  io.onedev.commons.loader.AppLoader - Starting application...
app    | 10:45:51 ERROR i.onedev.commons.bootstrap.Bootstrap - Error booting application
app    | java.lang.NullPointerException: null
app    | 	at io.onedev.server.persistence.PersistenceUtils.callWithTransaction(PersistenceUtils.java:44)
app    | 	at io.onedev.server.persistence.PersistenceUtils.callWithLock(PersistenceUtils.java:97)
app    | 	at io.onedev.server.ee.clustering.DefaultClusterManager.start(DefaultClusterManager.java:103)
app    | 	at io.onedev.server.OneDev.start(OneDev.java:140)
app    | 	at io.onedev.commons.loader.DefaultPluginManager.start(DefaultPluginManager.java:44)
app    | 	at io.onedev.commons.loader.AppLoader.start(AppLoader.java:60)
app    | 	at io.onedev.commons.bootstrap.Bootstrap.main(Bootstrap.java:200)
app    | 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
app    | 	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
app    | 	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
app    | 	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
app    | 	at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:349)
app    | 	at java.base/java.lang.Thread.run(Thread.java:829)
app    | 10:45:51 INFO  io.onedev.commons.loader.AppLoader - Stopping application...
app    | <-- Wrapper Stopped

Thank you again for thehelp!

Activities

Robin Shen commented 11 months ago

Please remove quotes in the .env file to see if it works.
مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago

Thanks @robin. Just tried but no joy, I'm afraid!
Robin Shen commented 11 months ago

Miss spelling here: hibername_dialect should be hibernate_dialect instead

مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago

Great catch. I so hoped that would solve it but it still doesn't. Same error. Even deleted all the containers and recreated them. New env file:

# onedev
hibernate_dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate_connection_driver=com.mysql.cj.jdbc.Driver
hibernate_connection_username=onedev
hibernate_connection_password=onedev
hibernate_connection_url=jdbc:mysql://mysql:3306/onedev?serverTimezone=UTC&allowPublicKeyRetrieval=true&useSSL=false&disableMariaDbDriver=true

# MYSQL
MYSQL_ROOT_PASSWORD="root"
MYSQL_USER="onedev"
MYSQL_PASSWORD="onedev"
MYSQL_DATABASE="onedev"

مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago

Okay, I got it working.

I checked the conf/hibernate.properties file in the volume. That does not populate with the information in the env vars for some reason and still had the h2 DB settings activated. Once I popped the DB details there it works.

Probably something to look into?
مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago
And thank you for building a really great project.

I have a couple of questions (unrelated to this issue, but not sure if I should just open another issue to ask them):

Is there a way to just remove the builds section. We won't be using it because we have Concourse setup with 100s of jobs and it works really well.

Is there somewhere we can donate (not quite at the Enterprise stage yet).

Thank you.
Robin Shen commented 11 months ago

Is there a way to just remove the builds section. We won't be using it because we have Concourse setup with 100s of jobs and it works really well

The builds section will always be there

Is there somewhere we can donate (not quite at the Enterprise stage yet

Since we have enterprise edition, the donation channel is not necessary currently. Nevertheless, thanks a lot for willing to help.
مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago

I realise that didn't sound right now that I read it. I meant more like disabling it because we won't use it (well, not for now, at least).
Robin Shen commented 11 months ago

I realise that didn't sound right now that I read it. I meant more like disabling it because we won't use it (well, not for now, at least).

Added an improvement request for this as OD-2270
Robin Shen commented 11 months ago

Another error in your .env:

hibernate_connection_driver should be hibernate_connection_driver_class
مِيزَانُ الْدِّينْ عَبْدُ ذِيْ الْجَلَالِ وَ الْإِكْرَامِ commented 11 months ago

OK, that actually fixes it. Thank you and I'm sorry for the false alarm. I need to improve my copying and pasting skills.

Thanks for all your help!
Robin Shen changed state to 'Closed' 11 months ago
Previous Value Current Value
Open

Closed
Robin Shen commented 11 months ago

No problem
Login to comment

Previous Value	Current Value
Open	Closed

Type	Question
Priority	Normal
Assignee	Robin Shen
Labels	No labels

Issue Votes (0)

Watchers (2)

Reference

OD-2268