I’ve decided to utilize project management software to keep track of the work I will need to do in my Linux data acquisition system and to have a better timeline for the project. I think a more formal process will be good motivation for me to work on tasks and have an actual sense of time for when I will have a working system. This also serves as good documentation as it associates the code I’ve written across multiple classes into a task objective.
I wanted to use free, open-source software and it looks like the most popular choices for this are Redmine and OpenProject. I decided to go with OpenProject as it seemed like a more useable interface and my needs are simple. I installed it locally in my WSL2 Ubuntu installation on my Windows 11 computer using this guide.
I’m running Ubuntu 20.04 as shown below
After installing OpenProject and running the configuration script: sudo openproject configure I received the following error: “E: The repository 'https://apt.postgresql.org/pub/repos/apt focal-pgdg Release' does not have a Release file.“
When I ran “sudo apt-get update” I got some more context with the addition of this error : “Err:9 https://apt.postgresql.org/pub/repos/apt focal-pgdg Release“
Certificate verification failed: The certificate is NOT trusted. The certificate chain uses expired certificate. Could not handshake: Error in the certificate verification.
To get around the expired certificate I just used the http site instead of the https. Below is the original repository source with https that was throwing the expired certificate.
Here is the repository source with the address changed.
This worked OK but when I reconfigured OpenProject it just overwrote the file with the https source and the same error resulted.
The correct solution was to install the “ca-certificates” package which was missing from my system. The problem wasn’t that the server had an expired certificate, it was that I didn’t have a valid certificate from an authority. Installing the “ca-certificates” package provided my system with the necessary certificates to authenticate the connection to the https source and allowed me to proceed with the installation of OpenProject.
After fixing this problem I encountered another when I tried to re-run the configure command for OpenProject. The following error was reported: “could not read file "/var/lib/postgresql/13/main/postmaster.opts"
Starting Over…
Because my intention was to evaluate openproject locally then install it on a native Linux system I decided to stop trying to install it on WSL and just put it on a native Linux system. I wanted to install SSL certs but the ppa for certbot was quite old so I found this installer which worked fine.
When I tried installing it on a server with 512MB of RAM the installation throughout this error: “/usr/share/openproject/installer/addons/openproject/bin/postinstall: line 94: 3045 Killed” I upgraded to a system with 4GB of RAM and it worked. Who would have thought a system below minimum requirements wouldn’t work. 😛
${CLI} run rake "${rake_commands} packager:postinstall
After some struggling, I have a better sense of the structure of an Apache server. I’ve moved my static profile over to the main server so I don’t have all these subdomains. I will likely move this blog over to the same server so I can run everything off one system; but that is for another time 🙂
To get the apache server to host both my openprojects app and my static portfolio website, I decided to just delete all HTML files in the root HTML directory for the openprojects app and place the static website in that. Not the best practice, but for my purposes, it will work well enough. A nice benefit of doing it like this is that it allows me to eventually write a more unified theme if I so desired. As it stands, some of the fonts and things for the openproject app are taken from my static website.