# Joplin Server pre-release is now available

**URL:** https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605
**Category:** Development
**Created:** [4 January 2021 16:01 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605 "2021-01-04T16:01:53Z")
**Posts on this page:** 20
**Page:** 7

<div class="post-metadata">

### Author: ![Paulmicha](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/paulmicha/32/7242_2.png) [@Paulmicha](https://discourse.joplinapp.org/u/Paulmicha)
#### Post date: [16 February 2021 18:31 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/123 "2021-02-16T18:31:09Z")

</div>

I'm contemplating having a Joplin Server set up along a Drupal instance for automatically migrating Joplin user accounts + contents in order to benefit from the existing ecosystem of Drupal modules for access rights management, Solr / Tika indexing, student group works, and eventually web publishing.

It seems very impractical because apparently the only table with content is `files`, and the column with the relevant data is in binary format... Worst case scenario, it would be possible to parse those contents in a preliminary step. But unless I'm missing something, the relationships between tags and notes seem absent.

1. Is there a way to get some more details in the Joplin Server database ?
2. Or would we have to use a client-side plugin to "enrich" the contents with additional metadata ?
3. Or, more radically, could we sync the entire local sqlite file ?

---

<div class="post-metadata">

### Author: ![Muwahhidun](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/muwahhidun/32/7191_2.png) [@Muwahhidun](https://discourse.joplinapp.org/u/Muwahhidun)
#### Post date: [16 February 2021 21:12 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/124 "2021-02-16T21:12:24Z")

</div>

Install Portainer, and make a Recreate to upgrade manually. If automatically, you need to set up Watchtower.

---

<div class="post-metadata">

### Author: ![fourstepper](https://avatars.discourse-cdn.com/v4/letter/f/c68b51/32.png) [@fourstepper](https://discourse.joplinapp.org/u/fourstepper)
#### Post date: [18 February 2021 09:27 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/125 "2021-02-18T09:27:51Z")

</div>

You don't have to install anything, nor do you have to run docker-compose down when upgrading containers.

```auto
# Pull new images
docker-compose pull

# run docker-compose up and remove all images that
# aren't currently defined in docker-compose.yml
docker-compose up -d --remove-orphans

# remove old containers
docker image prune

```

---

<div class="post-metadata">

### Author: ![tessus](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/tessus/32/13_2.png) [@tessus](https://discourse.joplinapp.org/u/tessus)
#### Post date: [18 February 2021 17:48 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/126 "2021-02-18T17:48:52Z")

</div>

Maybe I'm missing something, but as soon as the container is gone, the data is gone, since the docker files do not contain persistent storage directives (as I mentioned before in this topic).  
Thus upgrading your containers will delete all your data.

IMO the docker-compose file in the Joplin repo should not be used for production environments. Unless you want to lose data.

---

<div class="post-metadata">

### Author: ![sevent](https://avatars.discourse-cdn.com/v4/letter/s/b9e5f3/32.png) [@sevent](https://discourse.joplinapp.org/u/sevent)
#### Post date: [20 February 2021 15:37 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/127 "2021-02-20T15:37:09Z")

</div>

Hi all. I'm used to using Volumes in my docker-compose files to expose files written by the container to disk (to allow for easy backups).

Other than the postgres DB, how would you define the Volumes for the app in docker-compose?

Thanks !

---

<div class="post-metadata">

### Author: ![tessus](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/tessus/32/13_2.png) [@tessus](https://discourse.joplinapp.org/u/tessus)
#### Post date: [21 February 2021 02:08 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/128 "2021-02-21T02:08:22Z")

</div>

> [@sevent](#):
>
> Other than the postgres DB, how would you define the Volumes for the app in docker-compose?

Afaik everything is in the DB, thus I don't think there's need for that. I haven't been able to run any tests with the server yet, but a few people in this thread certainly have. They should be able to tell you more.

---

<div class="post-metadata">

### Author: ![nokoa77](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/nokoa77/32/3207_2.png) [@nokoa77](https://discourse.joplinapp.org/u/nokoa77)
#### Post date: [21 February 2021 20:44 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/129 "2021-02-21T20:44:15Z")

</div>

Hi @sevent,  
My understanding is that, to make data persistent for Joplin Server, you added this "volumes:" line to the docker-compose file :

```auto
[...]
    db:
        image: postgres:13.1
        ports:
            - "5432:5432"
        restart: unless-stopped
        volumes: ./postgres-data:/var/lib/postgresql/data
        environment:
            - APP_PORT=22300
[...]

```

Is that it ? My understanding is that it also allows to upgrade the PostgreSQL Docker Image (eg. from 13.1 to 13.2) without losing data. Is that it ?  
Thanks,  
Bruno  
PS : sorry I don't have the answer to your specific question ! But I'm interested too in the future answer from the people who tested the server yet.

---

<div class="post-metadata">

### Author: ![plamola](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/plamola/32/7110_2.png) [@plamola](https://discourse.joplinapp.org/u/plamola)
#### Post date: [22 February 2021 06:32 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/130 "2021-02-22T06:32:33Z")

</div>

Yes, that is it. Mapping the postgres data directory to the host file system will ensure the data will not be lost after a restart.

In order to backup the data in postgres, I've also added a container which makes backups of the the postgres db, since you can't backup the postgres data files while the database is running.

An example of the docker-compose file which I'm currently using can be found [here](https://gist.github.com/plamola/a8f2d700435b9155d8dc4b14f25ab793).  
Only the domain name has been changed in this example.

---

<div class="post-metadata">

### Author: ![nokoa77](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/nokoa77/32/3207_2.png) [@nokoa77](https://discourse.joplinapp.org/u/nokoa77)
#### Post date: [22 February 2021 08:04 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/131 "2021-02-22T08:04:50Z")

</div>

Double Thank you @plamola, I didn’t know for the backup limits while running, your config will be very useful !

---

<div class="post-metadata">

### Author: ![alexander-lamdan](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/alexander-lamdan/32/7407_2.png) [@alexander-lamdan](https://discourse.joplinapp.org/u/alexander-lamdan)
#### Post date: [27 February 2021 07:00 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/132 "2021-02-27T07:00:37Z")

</div>

Its really awesome, but I might think that Joplin need to have an server. Like OneNote, and other note cloud based programms.

Joplin based server, not self-hosting, just an VPS server will be great.

If you think, you can't afford this option, make it an premium cost option with 2-6$ from user.

Joplin needed urgent server for herself.

---

<div class="post-metadata">

### Author: ![Javierenrique00](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/javierenrique00/32/7414_2.png) [@Javierenrique00](https://discourse.joplinapp.org/u/Javierenrique00)
#### Post date: [27 February 2021 19:37 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/133 "2021-02-27T19:37:18Z")

</div>

Hello, I installed the server in docker to make a test. It synchronized ok. But I don´t understand if the share note or share notebook functionality is implemented ?

---

<div class="post-metadata">

### Author: ![holm](https://avatars.discourse-cdn.com/v4/letter/h/e79b87/32.png) [@holm](https://discourse.joplinapp.org/u/holm)
#### Post date: [3 March 2021 14:12 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/134 "2021-03-03T14:12:23Z")

</div>

> [@laurent](#):
>
> **Long term** , the goal is to add collaboration features:
> 
> - Sharing a note with anyone, using a URL. When the note is changed, the content at the URL is changed too.
> - Sharing a notebook with a user on the same Joplin Server instance. For example, if you share a notebook with another user, that user will see this notebook in their desktop or mobile app, and will be able to edit the notes, etc.

At the beginning I also read over it. 😉

---

<div class="post-metadata">

### Author: ![wazabees](https://avatars.discourse-cdn.com/v4/letter/w/6a8cbe/32.png) [@wazabees](https://discourse.joplinapp.org/u/wazabees)
#### Post date: [8 March 2021 17:44 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/135 "2021-03-08T17:44:55Z")

</div>

Fantastic work - I've been wanting to get away from webdav. I'm wondering if there is a planned update to the terminal application to sync with Joplin Server? I couldn't see the option in the documentation. Thanks!

---

<div class="post-metadata">

### Author: ![fourstepper](https://avatars.discourse-cdn.com/v4/letter/f/c68b51/32.png) [@fourstepper](https://discourse.joplinapp.org/u/fourstepper)
#### Post date: [10 March 2021 18:02 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/136 "2021-03-10T18:02:15Z")

</div>

It would be great if one could specify the admin user and password directly in the .env (or any more users, for that matter)

---

<div class="post-metadata">

### Author: ![GreenLeaf](https://avatars.discourse-cdn.com/v4/letter/g/db5fbb/32.png) [@GreenLeaf](https://discourse.joplinapp.org/u/GreenLeaf)
#### Post date: [16 March 2021 00:26 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/137 "2021-03-16T00:26:11Z")

</div>

> [@nVir](#):
>
> You could export your data from Postgres with that command:
> 
> docker exec -u postgres -t joplin-server\_db\_1 pg\_dumpall -c -U joplin | gzip \> dump\_`date +%d-%m-%Y" *"%H* %M_%S`.sql.gz

When I export my database, the contents appear to be encoded somehow. The column appears to be something like `\\x436861...`. Is there a way to view this content in text format?

**[edit]** Looks like this is just stored as bytea. Using something like [Convert Bytes to UTF8 - Online UTF8 Tools](https://onlineutf8tools.com/convert-bytes-to-utf8) converts to text (after removing the leading \x).

---

<div class="post-metadata">

### Author: ![charles](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@charles](https://discourse.joplinapp.org/u/charles)
#### Post date: [16 March 2021 14:14 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/138 "2021-03-16T14:14:37Z")

</div>

A bit late to the party, but reading this thread now and very happy to see that there will be a paid option for those who prefer not to manage themselves.

Personally I prefer to manage it myself, but I also find that **really** good things come from open-source projects that offer a "We can host for you" revenue model. (See NabuKasa for Home Assistant)

Joplin has been fantastic for me. Thanks for all the work you do.

---

<div class="post-metadata">

### Author: ![dzusan](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dzusan](https://discourse.joplinapp.org/u/dzusan)
#### Post date: [22 March 2021 08:02 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/139 "2021-03-22T08:02:14Z")

</div>

Hello everyone. I decided to move from broken Evernote to amazing Joplin a few days ago. And just started Joplin server on my home server without testing other alternatives. All works right, but one thing.

I can sync with only default admin@localhost user. I changed admin@localhost password and can login wothout a problem. But if I create another user, I get errors:

on login:

```auto
Error: Invalid username or password
    at SessionModel.<anonymous> (/home/joplin/packages/server/src/models/SessionModel.ts:28:20)
    at Generator.next (<anonymous>)
    at fulfilled (/home/joplin/packages/server/dist/models/SessionModel.js:5:58)

```

on sync in Joplin app:

```auto
Error. Please check that URL, username, password, etc. are correct and that the sync target is accessible. The reported error was:
POST api/sessions: Unknown error (403): {"error":"Invalid username or password"} (Code 403)

```

I tried @kronan instructions, but it didn't help.

---

<div class="post-metadata">

### Author: ![tauceti82](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/tauceti82/32/7944_2.png) [@tauceti82](https://discourse.joplinapp.org/u/tauceti82)
#### Post date: [22 March 2021 15:23 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/140 "2021-03-22T15:23:01Z")

</div>

noob question: I try to run joplin server via the docker composer file but when I try to access the webpage I get:

| 2021-03-22 15:16:25: App: GET /joplin/login  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/login : Path not found: joplin/login  
app\_1 | 2021-03-22 15:16:25: App: GET /joplin/css/bulma.min.css  
app\_1 | 2021-03-22 15:16:25: App: GET /joplin/css/bulma-prefers-dark.min.css  
app\_1 | 2021-03-22 15:16:25: App: GET /joplin/css/main.css  
app\_1 | 2021-03-22 15:16:25: App: GET /joplin/css/fontawesome/css/all.min.css  
app\_1 | 2021-03-22 15:16:25: App: GET /joplin/js/main.js  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/css/bulma.min.css : Path not found: joplin/css/bulma.min.css  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/css/bulma-prefers-dark.min.css : Path not found: joplin/css/bulma-prefers-dark.min.css  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/css/main.css : Path not found: joplin/css/main.css  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/css/fontawesome/css/all.min.css : Path not found: joplin/css/fontawesome/css/all.min.css  
app\_1 | 2021-03-22 15:16:25: [error] App: 404: GET /joplin/js/main.js : Path not found: joplin/js/main.js

What do I have to install? I thought the docker image would contain everything?!

---

<div class="post-metadata">

### Author: ![MrKanister](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/mrkanister/32/20054_2.png) [@MrKanister](https://discourse.joplinapp.org/u/MrKanister)
#### Post date: [24 March 2021 08:24 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/141 "2021-03-24T08:24:34Z")

</div>

Ok, so it is really weird: I tried to reproduce your problem, so I added a new test user, typed in a password and - there you go - I got your exact errors...I fixed it by editing the mentioned user and giving him a new password (maybe even the old one would work). After that I was able to log in without problems. Maybe that one works out for you?

---

<div class="post-metadata">

### Author: ![MrKanister](https://yyz2.discourse-cdn.com/flex028/user_avatar/discourse.joplinapp.org/mrkanister/32/20054_2.png) [@MrKanister](https://discourse.joplinapp.org/u/MrKanister)
#### Post date: [24 March 2021 08:29 UTC](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605/142 "2021-03-24T08:29:43Z")

</div>

I don't really know, what's going on, how did you set up your Reverse-Proxy?  
And how did you edit the compose file (in which format did you put your URL in there)?

[Previous page](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605.md?page=6)

[Next page](https://discourse.joplinapp.org/t/joplin-server-pre-release-is-now-available/13605.md?page=8)
