ULYSSIS documentation - User contributions [en]

Registering a new account TEST

2023-10-26T08:36:21Z

Erico:

To register an account, follow these steps:

# Go to https://ucc.ulyssis.org/accounts and log in using your Central KU Leuven Account.
# Select the kind of account you wish to register:
#* Most people will want to register a '''regular account''' for '''personal use'''.
#* If you are a '''recognised organisation''' by LOKO, the KU Leuven or another relevant entity, you may be entitled to an organisation account, which has a reduced price. You can use the following to verify if you are eligible:
#**The list of associations (vrije verenigingen) recognised by [http://loko.be/verenigingen/ LOKO].
#**KU Leuven research groups. Please email us on [mailto:ulyssis@ulyssis.org ulyssis@ulyssis.org] with a link to your faculty/department's list of research groups.
#**Organisations recognised by their faculty as an (optional) part of the curriculum and that have a permanent character. For example the [https://iiw.kuleuven.be/studeren/opleidingen/techinvent/ventures-teams teams] of the Postgraduate Tech Innovations in Ventures & Teams at Group T.
#**If you are a daughter organisation of one or multiple faculty unions (kringen), for example a fakbar.
#**Organisations outside of Campus Leuven, but within the KU Leuven association, are considered on an indivual basis. Feel free to send us more details on [mailto:ulyssis@ulyssis.org ulyssis@ulyssis.org] and we will review your particular situation.
#*If you are a recognised '''faculty union''' (kring), assembly organisation (overkoepelende organisatie), or '''faculty consultative body''' (facultair overlegorgaan) you are entitled to a free account. You can use the following to verify if you are eligible:
#**The list of recognised faculty unions (kringen) from LOKO on http://loko.be/verenigingen/.
#** The list of recognised assembly organisations (overkoepelende organisaties) on the [https://kennisdatabank.loko.be/index.php/Studentenorganisaties_in_Leuven#Overkoepelende_organisaties LOKO knowledge database].
#**The list of recognised faculty consultative bodies from the Studentenraad KU Leuven on https://www.sturakuleuven.be/onze-werking/facultaire-overlegorganen/.
# After picking your account type you have to choose which options you want, as well as a username and a language.
# Accept the ULYSSIS terms of use and confirm your order.
# An email will be sent to your KU Leuven email address to confirm your order alongside a request for payment.
# As soon as we have received and processed your payment, your account will be activated and you will receive instructions to set a password.

Registering a new account TEST

2023-10-26T08:35:36Z

Erico: Created page with "To register an account, follow these steps: # Go to https://ucc.ulyssis.org/accounts and log in using your Central KU Leuven Account. # Select the kind of account you wish to..."

To register an account, follow these steps:

# Go to https://ucc.ulyssis.org/accounts and log in using your Central KU Leuven Account.
# Select the kind of account you wish to register:
#* Most people will want to register a '''regular account''' for '''personal use'''.
#* If you are a '''recognised organisation''' by LOKO, the KU Leuven or another relevant entity, you may be entitled to an organisation account, which has a reduced price. You can use the following to verify if you are eligible:
#**The list of associations (vrije verenigingen) recognised by [http://loko.be/verenigingen/ LOKO].
#**If you are a daughter organisation of one or multiple faculty unions (kringen), for example a fakbar.
#**KU Leuven research groups. Please email us on [mailto:ulyssis@ulyssis.org ulyssis@ulyssis.org] with a link to your faculty/department's list of research groups.
#**Organisations recognised by their faculty as an (optional) part of the curriculum and that have a permanent character. For example the [https://iiw.kuleuven.be/studeren/opleidingen/techinvent/ventures-teams teams] of the Postgraduate Tech Innovations in Ventures & Teams at Group T.
#**Organisations outside of Campus Leuven, but within the KU Leuven association, are considered on an indivual basis. Feel free to send us more details on [mailto:ulyssis@ulyssis.org ulyssis@ulyssis.org] and we will review your particular situation.
#*If you are a recognised '''faculty union''' (kring), assembly organisation (overkoepelende organisatie), or '''faculty consultative body''' (facultair overlegorgaan) you are entitled to a free account. You can use the following to verify if you are eligible:
#**The list of recognised faculty unions (kringen) from LOKO on http://loko.be/verenigingen/.
#** The list of recognised assembly organisations (overkoepelende organisaties) on the [https://kennisdatabank.loko.be/index.php/Studentenorganisaties_in_Leuven#Overkoepelende_organisaties LOKO knowledge database].
#**The list of recognised faculty consultative bodies from the Studentenraad KU Leuven on https://www.sturakuleuven.be/onze-werking/facultaire-overlegorganen/.
# After picking your account type you have to choose which options you want, as well as a username and a language.
# Accept the ULYSSIS terms of use and confirm your order.
# An email will be sent to your KU Leuven email address to confirm your order alongside a request for payment.
# As soon as we have received and processed your payment, your account will be activated and you will receive instructions to set a password.

TEST Software Version Checker

2023-10-26T08:13:04Z

Erico: /* Ignoring specific software */

==Introduction==
Many of our users use the same popular software to run their website. However, as is common in popular and widespread software, various bugs or errors can occur in the program. These flaws can be exploited by hackers to gain access to websites or databases.

Whenever a new update is released for any popular software (e.g., WordPress, MediaWiki, Joomla) hackers will find out which security flaws have been patched, and using this knowledge, they try to find users who haven't updated their software, to gain access to the websites or databases. This is the reason why it is so critical to update the software itself, plugins, themes, or any related software as soon as the updates roll out. To help facilitate this and prevent security breaches, we have created a tool, the Software Version Checker, to help you keep the most commonly used software up-to-date. Currently, this feature is only active if you have an organization or student union account.
==What to do when you receive an e-mail==
When you receive an e-mail from the Software Version Checker, it is of utmost importance to update the software mentioned in the e-mail. It is also the best time to check if the other software you use is up-to-date. As mentioned below, our tool does not check all software.

You can find more information [[Updating WordPress|here]] on how to automate this for WordPress to save a lot of time and effort. Since updating MediaWiki can be a somewhat daunting process, we have made a more detailed guide available on [[Updating MediaWiki]].
==Supported Software==
Sadly not every piece of software can be supported. Because of this, we have decided to choose the most popular software, since they are more likely to get security breaches.
*Drupal (including modules and themes)
*Joomla (Plugins are not supported)
*MediaWiki (MediaWiki Extensions and Themes are not supported)
*phpBB (including plugins and styles)
*WordPress (including plugins and themes)
==Functionality of the Software Version Checker==
The Software Version Checker fulfills the following functions :
*Scan relevant files, detect supported software, and store in database
*Check the version and validity of outdated software
*Notify accounts that are using outdated software
The Software Version Checker does this once every day.

==Ignoring specific software==
The Software Version Checker allows specified paths to be excluded from its search. If you believe you have software that should be ignored (for example certain custom plugins or themes), you are free to e-mail a request to ulyssis@ulyssis.org. Please list your account name, the location of the specific file(s), the nature of what is being detected, and a detailed description of the specific situation.
==Ignoring Organisations/Student Unions==
The Software Version Checker also allows our users to ignore specific Organisations or Student Unions entirely. This feature is possible on request, but only after extensive deliberation with ULYSSIS. Enabling this feature also has possible consequences; no more mails about software that is outdated, unless it is enabled on request, and no possible support if the user's account gets hacked. If the account does get hacked it will be suspend immediately.

Using MySQL

2022-10-01T13:28:49Z

Erico: remove SQL workbench

MySQL is one of the most popular databases for websites. It's used by most CMSes and other common web software, and many programming languages have support for it. ULYSSIS specifically uses MariaDB, which is a fork of MySQL with similar features and (almost) identical SQL syntax, but offers better performance and has less corporate interference in the development process.

== Managing MySQL ==
All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC], under the MySQL section.

===Creating a MySQL user===
To use MySQL on your ULYSSIS account, you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel, you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

===Creating a MySQL database===
After having created a MySQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

===Deleting a MySQL database===
If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Accessing MySQL ==
Our MySQL and PostgreSQL databases run on a separate database server, this means you may need to enter a specific host, together with the correct credentials, to access your database within a website or application. You may also wish to use a common tool such as PHPMyAdmin or access a database remotely. Details on how to do that are available in the sections below.

===Using MySQL for your website or application===
you can connect to the database with the following details:
Host: mysql.ulyssis.org
Username: your account's username
Password: the password you chose when you made the MySQL user
Database: the database name you chose, prefixed by your username

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:
<syntaxhighlight lang="php">$db = new mysqli('mysql.ulyssis.org', 'foobar', 'correct horse battery staple', 'foobar_website');</syntaxhighlight>
or
<syntaxhighlight lang="php">$db = new PDO('mysql:host=mysql.ulyssis.org;dbname=foobar_website', 'foobar', 'correct horse battery staple');</syntaxhighlight>

===Accessing MySQL with PHPMyAdmin or Adminer===
Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]].

===Accessing MySQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.

On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N

While this command is running, you can connect to the MySQL server with host 'localhost' and port '3300'.
To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep mysql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:mysql.ulyssis.org:5432 -N

We can then kill the process using kill with the pid we acquired:
kill 12657

[[Category:Databases]]

Using MySQL

2022-10-01T12:34:28Z

Erico: pgsql replaced with mysql in pgrep command

Using MySQL

2022-09-30T08:14:38Z

Erico: expanded SSH explanation

MySQL is one of the most popular databases for websites. It's used by most CMSes and other common web software, and many programming languages have support for it. ULYSSIS specifically uses MariaDB, which is a fork of MySQL with similar features and (almost) identical SQL syntax, but offers better performance and has less corporate interference in the development process.

== Managing MySQL ==
All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC], under the MySQL section.

===Creating a MySQL user===
To use MySQL on your ULYSSIS account, you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel, you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

===Creating a MySQL database===
After having created a MySQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

===Deleting a MySQL database===
If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Accessing MySQL ==
Our MySQL and PostgreSQL databases run on a separate database server, this means you may need to enter a specific host, together with the correct credentials, to access your database within a website or application. You may also wish to use a common tool such as PHPMyAdmin or access a database remotely. Details on how to do that are available in the sections below.

===Using MySQL for your website or application===
you can connect to the database with the following details:
Host: mysql.ulyssis.org
Username: your account's username
Password: the password you chose when you made the MySQL user
Database: the database name you chose, prefixed by your username

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:
<syntaxhighlight lang="php">$db = new mysqli('mysql.ulyssis.org', 'foobar', 'correct horse battery staple', 'foobar_website');</syntaxhighlight>
or
<syntaxhighlight lang="php">$db = new PDO('mysql:host=mysql.ulyssis.org;dbname=foobar_website', 'foobar', 'correct horse battery staple');</syntaxhighlight>

===Accessing MySQL with PHPMyAdmin or Adminer===
Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]].

===Accessing MySQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.

On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N

While this command is running, you can connect to the MySQL server with host 'localhost' and port '3300'.
To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep pgsql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

We can then kill the process using kill with the pid we acquired:
kill 12657

====MySQL Workbench====
While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
[[File:MySQL_Workbench_SSH.png]]

[[Category:Databases]]

Using PostgreSQL

2022-09-30T08:09:26Z

Erico: typos

== Creating a database ==

You can create one or more PostgreSQL databases in [https://ucc.ulyssis.org UCC].

The first database you create will have the same name as your username. Subsequent databases will be prefixed with "''username''_".

== Managing your database ==

* The easiest way to manage your database is using [https://phppgadmin.ulyssis.org phpPgAdmin].
* You can also access it via the [[Accessing shell servers over SSH|command line]] with:
psql -h pgsql.ulyssis.org

=== Creating a PostgreSQL user ===
To use PostgreSQL on you ULYSSIS account, you first need to create a PostgreSQL user on [https://ucc,ulyssis,org UCC]. In the PostgreSQL section of the panel, you will be suggested to click a link to create a user. Then fill in the password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

=== Creating a PostgreSQL database ===
After having created a PostgreSQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically will be prefixed by your username.

=== Deleting a PostgreSQL database ===
If you no longer need a database, you can easily remove it by clicking on ''PostgreSQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other content will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Using PostgreSQL for your website or application ==

You can connect to the database with the following details:

* Host: <code>pgsql.ulyssis.org</code>
* Login: your ULYSSIS username
* Password: the PostgreSQL password you chose in UCC
* Database: the database you created in UCC

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>or
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=== Accessing PostgreSQL with PHPPgAdmin or Adminer ===
Using your username and password you can easily manage your PostgreSQL databases, tables and records on https://phppgadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPPgAdmin]] and [[using Adminer]].

===Accessing PostgreSQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. SSH-tunneling makes an encrypted connection between 2 devices, which we will use to map a port on the database server onto a local port on your device, so it behaves and can be used like a local port.

On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

While this command is running, you can connect to the PostgreSQL server with host 'localhost' and port '5400', To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep pgsql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

We can then kill the process using kill with the pid we acquired:
kill 12657

== PostGIS ==
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at ulyssis@ulyssis.org and let us know you would like to get PostGIS enabled and on which specific database.

[[Category:Databases]]

Using PostgreSQL

2022-09-30T08:05:59Z

Erico: replace PHPMyAdmin with PHPPgAdmin

== Creating a database ==

You can create one or more PostgreSQL databases in [https://ucc.ulyssis.org UCC].

The first database you create will have the same name as your username. Subsequent databases will be prefixed with "''username''_".

== Managing your database ==

* The easiest way to manage your database is using [https://phppgadmin.ulyssis.org phpPgAdmin].
* You can also access it via the [[Accessing shell servers over SSH|command line]] with:
psql -h pgsql.ulyssis.org

=== Creating a PostgreSQL user ===
To use PostgreSQL on you ULYSSIS account, you first need to create a PostgreSQL user on [https://ucc,ulyssis,org UCC]. In the PostgreSQL section of the panel, you will be suggested to click a link to create a user. Then fill in the password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

=== Creating a PostgreSQL database ===
After having created a PostgreSQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically will be prefixed by your username.

=== Deleting a PostgreSQL database ===
If you no longer need a database, you can easily remove it by clicking on ''PostgreSQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other content will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Using PostgreSQL for your website or application ==

You can connect to the database with the following details:

* Host: <code>pgsql.ulyssis.org</code>
* Login: your ULYSSIS username
* Password: the PostgreSQL password you chose in UCC
* Database: the database you created in UCC

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>or
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=== Accessing PostgreSQL with PHPPgAdmin or Adminer ===
Using your username and password you can easily manage your PostgreSQL databases, tables and records on https://phppgadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPPgAdmin]] and [[using Adminer]].

===Accessing PostgreSQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. SSH-tunneling makes an encrypted connection between 2 devices, which we will use to map a port on the database server onto a local port on your device, so it behaves and can be used like a local port.

On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

While this command is running, you can connect to the PostgreSQL server with host 'localhost' and port '5400', To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep psgql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

Then we can then kill the process using kill with the pid we acquired:
kill 12657

== PostGIS ==
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at ulyssis@ulyssis.org and let us know you would like to get PostGIS enabled and on which specific database.

[[Category:Databases]]

Using PostgreSQL

2022-09-30T08:05:22Z

Erico: replace PHPMyAdmin with PHPPgAdmin

== Creating a database ==

You can create one or more PostgreSQL databases in [https://ucc.ulyssis.org UCC].

The first database you create will have the same name as your username. Subsequent databases will be prefixed with "''username''_".

== Managing your database ==

* The easiest way to manage your database is using [https://phppgadmin.ulyssis.org phpPgAdmin].
* You can also access it via the [[Accessing shell servers over SSH|command line]] with:
psql -h pgsql.ulyssis.org

=== Creating a PostgreSQL user ===
To use PostgreSQL on you ULYSSIS account, you first need to create a PostgreSQL user on [https://ucc,ulyssis,org UCC]. In the PostgreSQL section of the panel, you will be suggested to click a link to create a user. Then fill in the password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

=== Creating a PostgreSQL database ===
After having created a PostgreSQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically will be prefixed by your username.

=== Deleting a PostgreSQL database ===
If you no longer need a database, you can easily remove it by clicking on ''PostgreSQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other content will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Using PostgreSQL for your website or application ==

You can connect to the database with the following details:

* Host: <code>pgsql.ulyssis.org</code>
* Login: your ULYSSIS username
* Password: the PostgreSQL password you chose in UCC
* Database: the database you created in UCC

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>or
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=== Accessing PostgreSQL with PHPPgAdmin or Adminer ===
Using your username and password you can easily manage your PostgreSQL databases, tables and records on https://phppgadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[Using PHPPgAdmin|using PHPMyAdmin]] and [[using Adminer]].

===Accessing PostgreSQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. SSH-tunneling makes an encrypted connection between 2 devices, which we will use to map a port on the database server onto a local port on your device, so it behaves and can be used like a local port.

On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

While this command is running, you can connect to the PostgreSQL server with host 'localhost' and port '5400', To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep psgql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

Then we can then kill the process using kill with the pid we acquired:
kill 12657

== PostGIS ==
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at ulyssis@ulyssis.org and let us know you would like to get PostGIS enabled and on which specific database.

[[Category:Databases]]

Using PostgreSQL

2022-09-30T08:03:36Z

Erico:

== Creating a database ==

You can create one or more PostgreSQL databases in [https://ucc.ulyssis.org UCC].

The first database you create will have the same name as your username. Subsequent databases will be prefixed with "''username''_".

== Managing your database ==

* The easiest way to manage your database is using [https://phppgadmin.ulyssis.org phpPgAdmin].
* You can also access it via the [[Accessing shell servers over SSH|command line]] with:
psql -h pgsql.ulyssis.org

=== Creating a PostgreSQL user ===
To use PostgreSQL on you ULYSSIS account, you first need to create a PostgreSQL user on [https://ucc,ulyssis,org UCC]. In the PostgreSQL section of the panel, you will be suggested to click a link to create a user. Then fill in the password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

=== Creating a PostgreSQL database ===
After having created a PostgreSQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically will be prefixed by your username.

=== Deleting a PostgreSQL database ===
If you no longer need a database, you can easily remove it by clicking on ''PostgreSQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other content will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Using PostgreSQL for your website or application ==

You can connect to the database with the following details:

* Host: <code>pgsql.ulyssis.org</code>
* Login: your ULYSSIS username
* Password: the PostgreSQL password you chose in UCC
* Database: the database you created in UCC

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>or
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=== Accessing PostgreSQL with PHPMyAdmin or Adminer ===
Using your username and password you can easily manage your PostgreSQL databases, tables and records on https://phppgadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[Using PHPPgAdmin|using PHPMyAdmin]] and [[using Adminer]].

===Accessing PostgreSQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. SSH-tunneling makes an encrypted connection between 2 devices, which we will use to map a port on the database server onto a local port on your device, so it behaves and can be used like a local port.

On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

While this command is running, you can connect to the PostgreSQL server with host 'localhost' and port '5400', To terminate the port forwarding, press ctrl-C in the terminal.

If you prefer the command to be run in the background, you can add <code>-f</code> to your command. To close this background process, you can use pgrep to acquire the pid of the process:
pgrep --list-full ssh | grep psgql.ulyssis.org
12657 ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

Then we can then kill the process using kill with the pid we acquired:
kill 12657

== PostGIS ==
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at ulyssis@ulyssis.org and let us know you would like to get PostGIS enabled and on which specific database.

[[Category:Databases]]

Using MySQL

2022-09-29T14:31:01Z

Erico: Accessing MySQL aangepast zoals uitgelegd in wikipagina documentatie herschrijven, nog wat meer nodig bij ssh

MySQL is one of the most popular databases for websites. It's used by most CMSes and other common web software, and many programming languages have support for it. ULYSSIS specifically uses MariaDB, which is a fork of MySQL with similar features and (almost) identical SQL syntax, but offers better performance and has less corporate interference in the development process.

== Managing MySQL ==
All common management tasks can be performed through our control panel [https://ucc.ulyssis.org UCC], under the MySQL section.

===Creating a MySQL user===
To use MySQL on your ULYSSIS account, you first need to create a MySQL user on [https://ucc.ulyssis.org UCC]. In the MySQL section of the panel, you will be suggested to click a link to create a user. Then fill in a password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

===Creating a MySQL database===
After having created a MySQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically be prefixed by your username.

===Deleting a MySQL database===
If you no longer need a database, you can easily remove it by clicking on ''MySQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other contents will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Accessing MySQL ==
Our MySQL and PostgreSQL databases run on a separate database server, this means you may need to enter a specific host, together with the correct credentials, to access your database within a website or application. You may also wish to use a common tool such as PHPMyAdmin or access a database remotely. Details on how to do that are available in the sections below.

===Using MySQL for your website or application===
you can connect to the database with the following details:
Host: mysql.ulyssis.org
Username: your account's username
Password: the password you chose when you made the MySQL user
Database: the database name you chose, prefixed by your username

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:
<syntaxhighlight lang="php">$db = new mysqli('mysql.ulyssis.org', 'foobar', 'correct horse battery staple', 'foobar_website');</syntaxhighlight>
or
<syntaxhighlight lang="php">$db = new PDO('mysql:host=mysql.ulyssis.org;dbname=foobar_website', 'foobar', 'correct horse battery staple');</syntaxhighlight>

===Accessing MySQL with PHPMyAdmin or Adminer===
Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]].

===Accessing MySQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH tunnel. In many MySQL management tools this is already supported.

On Linux, Mac OSX and other Unix-like Operating Systems it is also easily possible to use the following command to create a tunnel to a local port (in this case 3300)
ssh username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N

While this command is running, you can connect to the MySQL server with host 'localhost' and port '3300'.
To terminate the port forwarding, press ctrl-C in the terminal.

You can use "ssh -f username@ssh2.ulyssis.org -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.

==== MySQL Workbench ====
While [https://www.mysql.com/products/workbench/ MySQL Workbench] might not fully support our MySQL database, all commonly used operations work perfectly. You can connect to our database using MySQL Workbench by creating a connection as follows ([username] should be replaced by your username, of course):
[[File:MySQL_Workbench_SSH.png]]

[[Category:Databases]]

Using PostgreSQL

2022-09-29T14:30:29Z

Erico: Changes zoals uitgelegd op wikipagina documentatie herschrijven, nog wat meer nodig bij ssh

== Creating a database ==

You can create one or more PostgreSQL databases in [https://ucc.ulyssis.org UCC].

The first database you create will have the same name as your username. Subsequent databases will be prefixed with "''username''_".

== Managing your database ==

* The easiest way to manage your database is using [https://phppgadmin.ulyssis.org phpPgAdmin].
* You can also access it via the [[Accessing shell servers over SSH|command line]] with:
psql -h pgsql.ulyssis.org

=== Creating a PostgreSQL user ===
To use PostgreSQL on you ULYSSIS account, you first need to create a PostgreSQL user on [https://ucc,ulyssis,org UCC]. In the PostgreSQL section of the panel, you will be suggested to click a link to create a user. Then fill in the password for the database user. It is highly recommended that this password differs from the password you use for your account. Finally, click ''Create user'' and you are ready to go.

=== Creating a PostgreSQL database ===
After having created a PostgreSQL user, you can click ''Add database'' in [https://ucc.ulyssis.org UCC] and enter the name for your new database. It will automatically will be prefixed by your username.

=== Deleting a PostgreSQL database ===
If you no longer need a database, you can easily remove it by clicking on ''PostgreSQL'' in [https://ucc.ulyssis.org UCC] and then pressing on ''Remove database'' next to the database you would like to delete. After confirming, the database and all its tables and other content will be gone. For security reasons, you can't remove databases using an SQL query like DROP DATABASE, but have to go through UCC.

== Using PostgreSQL for your website or application ==

You can connect to the database with the following details:

* Host: <code>pgsql.ulyssis.org</code>
* Login: your ULYSSIS username
* Password: the PostgreSQL password you chose in UCC
* Database: the database you created in UCC

For example, if my username is foobar, I made a database called website and I were to create a PHP website I would use something like:<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>or
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=== Accessing PostgreSQL with PHPMyAdmin or Adminer ===
Using your username and password you can easily manage your PostgreSQL databases, tables and records on https://phpmyadmin.ulyssis.org and https://adminer.ulyssis.org. Documentation is also available to aid in [[using PHPMyAdmin]] and [[using Adminer]].

===Accessing PostgreSQL from outside of our network===
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel.

On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

While this command is running, you can connect to the PostgreSQL server with host 'localhost' and port '5400', To terminate the port forwarding, press ctrl-C in the terminal.

You can use "ssh -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N": the f-argument will put the command in the background.

== PostGIS ==
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at ulyssis@ulyssis.org and let us know you would like to get PostGIS enabled and on which specific database.

[[Category:Databases]]

File:Uploads-permissions.png

2022-08-15T14:51:15Z

Erico: Erico uploaded a new version of File:Uploads-permissions.png

uploads permissions cyberduck

Secure file permissions

2022-08-15T14:49:26Z

Erico: updating to use cyberduck

PHP code is run with PHP-FPM as your ULYSSIS user. This means you can tighten up you website's security by denying other users the permission to read your PHP files. However, due to the way the Apache webserver works, it must be able to determine the existence of your PHP files. Non-PHP files in your www directory must remain readable by other users, because Apache reads these as it's own user.

=== Recommended permissions ===

* www directory (and other directories from where websites are served), including subdirectories: <code>0705/drwxr-xr-x</code>
* Static website files (css, images, html, ...): <code>0604/-rw-r--r--</code>
* Configuration files containing secrets/passwords: <code>0600/-rw-------</code>
* Other directories and files that are not part of a website: <code>0600/-rw-------</code> or <code>0700/-rwx------</code>

=== Securing database login info ===

Suppose you have a file called <code>config.php</code>, containing login information for your database. To secure this information, you can make it readable and writeable by only you, and nobody else using <code>chmod 600 config.php</code>. In Cyberduck, you can do this by right-clicking on the config file, clicking on "Info", clicking on the "Permissions" tab, and changing the permissions according to the following screenshots:

[[File:Config-php-dropdown.png]]

[[File:Config-php-permissions.png]]

=== Securing uploads directory ===

Also, if there are directories that you made writeable by others, e.g. an uploads folder, this is no longer necessary. If this directory is called <code>uploads</code>, you can remove write rights for others with <code>chmod go-w uploads</code>. In Cyberduck, you can do this by right-clicking on the config file, clicking on "Info", clicking on the "Permissions" tab, and changing the permissions according to the following screenshots:

[[File:Uploads-dropdown.png]]

[[File:Uploads-permissions.png]]

[[Category:Files]]

[[Category:Security & anti-spam]]

File:Uploads-permissions.png

2022-08-15T14:48:10Z

Erico:

uploads permissions cyberduck

File:Uploads-dropdown.png

2022-08-15T14:47:34Z

Erico:

uploads dropdown cyberduck

File:Config-php-permissions.png

2022-08-15T14:44:06Z

Erico: Erico uploaded a new version of File:Config-php-permissions.png

config.php permissions cyberduck

File:Config-php-permissions.png

2022-08-15T14:40:21Z

Erico:

config.php permissions cyberduck

File:Config-php-dropdown.png

2022-08-15T14:38:41Z

Erico:

config.php dropdown cyberduck