OneBusAway / onebusaway

Parent module for all OneBusAway projects with common configuration information.
https://github.com/OneBusAway/onebusaway/wiki
Other
336 stars 72 forks source link

Fail: Configuration and Deployment Guide for v2.x #20

Open dancesWithCycles opened 2 years ago

dancesWithCycles commented 2 years ago

Hi folks, Thank you so much for providing this config and deploy Wiki page.

As mentioned on the Wiki page, I am following the recommended versions for Debian, Java, Tomcat and MySQL. However, the only difference is that I am working on a Debian 11 instead of a Debian 9 OS.

I get to the point where I install the MySQL Server. Everything is fine at this point.

sudo apt-get install gdebi-core
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
gdebi-core is already the newest version (0.9.5.7+nmu5).
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
gdebi mysql-apt-config_0.8.6-1_all.deb
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Reading state information... Done
Requires the installation of the following packages: dirmngr gnupg gnupg-l10n gnupg-utils gpg gpg-agent gpg-wks-client gpg-wks-server gpgconf gpgsm libassuan0 libksba8 libnpth0 lsb-release pinentry-curses 

Auto configuration for MySQL APT Repo.
 MySQL is a fast, stable and true multi-user, multi-threaded SQL database
 server. SQL (Structured Query Language) is the most popular database query
 language in the world. The main goals of MySQL are speed, robustness and
 ease of use.
Need to be root to install packages
sudo apt-get update
Hit:1 http://debian.tu-bs.de/debian bullseye InRelease
Hit:2 http://security.debian.org/debian-security bullseye-security InRelease
Hit:3 http://debian.tu-bs.de/debian bullseye-updates InRelease
Reading package lists... Done

However, I am stuck when I reach the actual installation instruction.

sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'mysql-server' has no installation candidate

Sometimes this package was called mysql-community-server, but it is no help right now.

sudo apt-get install mysql-community-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package mysql-community-server

I also followed this guide about how to install MySQL 8 on Debian 11 without success.

Does anyone has a helpful idea on how to solve this situation?

Does anyone has experience on how to setup OBA on Debian 11?

Does anyone know if it is worth the effort to get hold of hardware, install Debian 9 to host only a OBA instance?

Cheers,

Stefan

dancesWithCycles commented 2 years ago

Hi folks, Tripping over this issue, I found this guide enabling me to successfully installing mysql Ver 14.14 Distrib 5.7.37, for Linux (x86_64) using EditLine wrapper.

It is still confusing me how installing mysql version .8 using this instructions

sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb
sudo apt update
sudo apt install mysql-server

ends up in a CLI mysql tool showing on the mysql --version call this output.

mysql  Ver 14.14 Distrib 5.7.37, for Linux (x86_64) using  EditLine wrapper

I guess this is part of being a mysql noob.

Cheers!

dancesWithCycles commented 2 years ago

Hi folks, Thank you so much for providing this config and deploy Wiki page.

I am kind of exhausted, I hope there is an alternative and shorter setup path, but I ran all the way through this config and deploy Wiki page.

At the end, I am struggling with this line

Finally, to use your OneBusAway instance visit http://myoba.example.com:8080/routes

I reckon example.com is the domain name of my host.

Anyhow, what am I supposed to use as substitute for the subdomain myoba? Have I configured that along the way and now I am not aware of it anymore?

I appreciate each and every hint in the right direction.

Cheers!