Databases and Web Servers | Wydział Elektroniki, Telekomunikacji i Informatyki Politechniki Gdańskiej

Treść strony

Databases and Web Servers

Currently available deployment servers

  • WWW servers - NO LONGER AVAILABLE!
    • All web sites should be dockerized, they will be exposed via Reverse Proxy
  • Database engines
    • MariaDB 10.6.12
    • PostgreSQL 9.2.14 - DEPRECATED, WILL BE DISABLED SOON!

All servers are run in 64-bit operating systems in English versions.

Apache

Each desXY.kask workstation has Apache with PHP installed. To host web pages during the laboratories you can create public_html directory in your home, set proper permissions so that apache is able to access it and see your pages using http://localhost/~<username> address. Apache needs to be able to enter your home directory and the public_html directory. It also needs to be able to read the files in the public_html directory. You can set home directory permissions form the command line using the following commands: chmod o+x /home/home_dir_name.

Gitlab

Projects needing repositories or software support can use locally installed Gitlab instance. Further information can be found in HOWTO.

MySQL/MariaDB

MySQL/MariaDB is installed both on db.eti.pg.gda.pl and workstations running Linux and Windows. In all cases the database runs on default 3306 port. On workstations access is anonymous (any login) with "mysql" password. Access is allowed only from eti.pg.gda.pl domain. Such anonymous user has admin rights. For databases on the db.eti.pg.gda.pl server please conatact me via e-mail.

On workstations you can edit /etc/mysql/mariadb.cnf file and restart the database via sudo:

sudoedit /etc/mysql/mariadb.cnf

sudo systemctl reload mysql

PostgreSQL - OBSOLETE

PostgreSQL is installed on db.eti.pg.gda.pl. It listens on default port 5432. The database is used only for legacy project and is no longer supported.