ULYSSIS documentation - User contributions [en]

Using MySQL

2018-11-05T11:41:33Z

Andreas: /* Linux, Mac OSX */

==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. Then you just click ''Create user'' and you are ready to go.

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

==Using MySQL for your website or application==
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>

==Managing MySQL with PHPMyAdmin==
Using your username and password you can easily manage your MySQL databases, tables and records on https://phpmyadmin.ulyssis.org

==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.

=== 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]]

=== Linux, Mac OSX ===
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.

Using PostgreSQL

2018-11-05T11:37:37Z

Andreas: /* Accessing PostgreSQL from outside of our network */

= 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

= Connecting to the database =

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

Note that some CMSs will assume that you use "localhost" as the host, and will hide the host option under advanced settings in the installation process. If you can't find anywhere to enter the hostname, look under advanced settings.

== Connection string ==

If you are programming your application yourself, PostgreSQL often uses the following connection format:
host=$host user=$username password=$password db=$dbname

Where you replace the parts starting with <code>$</code> with the above connection details.

== pg_connect ==

If you are using PHP's [http://www.php.net/manual/en/function.pg-connect.php pg_connect] to connect to the
database, and your username is "foo", your password is "password" and your database name is "foo":
<syntaxhighlight lang="php">
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
</syntaxhighlight>
== PDO ==

If you want to connect using [http://be2.php.net/manual/en/intro.pdo.php PDO], your username is "foo", your password is "password" and your database is "foo":
<syntaxhighlight lang="php">
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
</syntaxhighlight>

=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

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.

= 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.

Overview

2017-02-01T21:41:48Z

Andreas:

<div style="background:#f9f9f9;border:1px solid #ddd;font-size:95%;padding:1.5em;">
Welcome to our documentation website. Many of the common procedures and issues our users experience are described here. If you still encounter problems we haven't covered or you just can't seem to get things to work, even though you followed one of our manuals, be free to contact us on ulyssis@ulyssis.org for personal support.</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== Account ==
* [[Registering a new account]]
* [[Renewing your account]]
* [[Transferring your account]]
* [[Resetting your password]]
* [[Help, my account has been disabled]]
* [[Why do I have to pay 0.00 euro and how?]]
</div><div style="width:45%;float:left">
== Files ==
* [[Accessing your files]]
* [[Transferring files over SFTP]]
* [[Using SSHFS]]
* [[Making Backups]]
</div>
<div style="clear:both;"></div>
</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== Webserver ==
* [[Webserver changes summer 2016]]
* [[Using your webspace]]
* [[Using (Fast)CGI for non-PHP websites]]
* [[Getting Apache logs]]
* [[Managing PHP errors]]
* [[Setting PHP options]]
* [[Adding domain names|Adding domain names (.be, .com, .org, ...)]]
* [[Getting SSL|Getting SSL (https-security)]]
* [[Shibboleth|Shibboleth (Centrale KU Leuven Login)]]
* [[Basic authentication|Basic authentication in PHP]]
</div><div style="width:45%;float:left">

== Databases ==
* [[Using PostgreSQL]]
* [[Using MySQL]]
* [[Using PHPMyAdmin]]
</div>
<div style="clear:both;"></div>
</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== CMSs ==
* [[Setting up Wordpress]]
* [[Setting up Drupal]]
* [[Setting up Joomla]]
* [[Setting up MediaWiki]]
</div><div style="width:45%;float:left">

== Security & anti-spam ==
* [[Regular updates on a CMS]]
* [[Preventing spam on Wordpress]]
* [[Preventing spam on Joomla]]
* [[Preventing spam on Drupal]]
* [[Preventing spam on MediaWiki]]
* [[Anti-spam policies]]
</div>
<div style="clear:both;"></div>
</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">

== Mail ==
* [[ULYSSIS mail]]
* [[Forwarders]]
* [[Using a forwarder as an alias]]
* [[Add an alias in Gmail]]
* [[Add an alias in Hotmail/Outlook]]
* [[Add an alias in Thunderbird]]
* [[Fetch your KU Leuven email into another email address]]
</div><div style="width:45%;float:left">

== Shell ==
* [[Accessing your files]]
* [[Transferring files over SFTP]]
* [[Accessing shell servers over SSH]]
* [[ULYSSIS public IRC]]
* [[Useful Linux Commands]]
</div>
<div style="clear:both;"></div>
</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== Versioning ==
* [[Subversion]]
* [[GitLab]]
</div><div style="width:45%;float:left">

== ULYSSIS Public Services ==
* [[ULYSSIS public IRC]]
* [[ULYSSIS public FTP]]
</div>
<div style="clear:both;"></div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== Development ==
* [[Local web development]]
</div><div style="width:45%;float:left">

== LaTeX ==
* [[Using the kulemt package]]
</div>
<div style="clear:both;"></div>
</div>

__NOTOC__

Setting up Joomla

2015-09-03T19:00:17Z

Andreas:

==Installing Joomla on our servers is definitely easy==

Installing Joomla on our servers is deffinately easy.

You download the install components from the http://joomla.org joomla-site.

Here you get a compressed file (.zip) which you have to extract..

You get a folder with files, those files (so no the folder) you copy via filezilla or an other ftp programme to your www-map on your shellaccount.

Afterwards you go to your account, I.E username.ulyssis.be, here you get a notification telling you your needs to be configured. The fist part is the "main configuration" which will be individual for every user.

Afterwards click on ''Next'' which will prompt you for your database credentials & information:

*'''Databasetype: ''' Select ''MySQL'' from the dropdown.
*''''Hostname: ''' this is the location of the database server, use <code>mysql.ulyssis.org</code>.
*''''Username: ''' this is the name you gave during the creation of your mysql account, often this is the same as your username with ULYSSIS.
*'''password: ''' the password hat you gave during the creation of your mysql account
* You don't change the last two fields

When you're done click on “Next” twice since ftp is already configured. Here you can see the last few details.

Afterwards the install will run by it own and thats it, you installed Joomla.

==Setting up multiple instances of Joomla==

If you want to have multiple instances of a Joomla site then you the create a new folder in your homedir from your shell account. You need a new virtual host, you can send us an [mailto:ulyssis@ulyssis.org email] and we will create one for you.

After your new virtual host is ready, you need to do all the same steps as for a regular Joomla installation.

Another option is to use the Joomla [https://docs.joomla.org/Multiple_Domains_and_Web_Sites_in_a_single_Joomla!_installation multisite] option.

Setting up Joomla

2015-09-03T18:58:13Z

Andreas:

Setting up WordPress

2015-09-03T18:55:49Z

Andreas: /* Setting up multiple instances of Wordpress */

==Installing wordpress on our servers is definitely easy==

Installing wordpress on our servers is deffinately easy.

You download the install components from the http://wordpress.org wordpress-site.

Here you get a compressed file (.tar.gz or .zip) which you have to extract..

You get a folder with files, those files (so no the folder) you copy via filezilla or an other ftp programme to your www-map on your shellaccount.

Afterwards you go to your account, I.E username.ulyssis.be, here you get a notification telling you your <code>wp-config.php</code> has to be created, the easiest way is to follow the wizard, so click on “Create a Configuration File”.

Afterwards on ''Let's go!'' which will prompt you for your database credentials:

*'''Database Name: ''' if you haven't created a mysql database or user on UCC then you have to create it there. The default database is: username_username.
*''''User Name: ''' this is the name you gave during the creation of your mysql account, often this is the same as your username with ULYSSIS.
*'''Password: ''' the password hat you gave during the creation of your mysql account
*'''Database Host: ''' this is <code>mysql.ulyssis.org</code>
* You don't change the last field

When you're done click on “Run the install” Here you can give the last few details.

Afterwards the install will run by it own and thats it, you installed wordpress.

==Setting up multiple instances of Wordpress==

If you want to have multiple instances of a Wordpress site then you the create a new folder in your homedir from your shell account. You need a new virtual host, send us an email and we will create one for you.

After your new virtual host has been configured, you need to do al the same steps as for a regular wordpress installation.

You could also use the Wordpress [https://codex.wordpress.org/Create_A_Network multisite] option. You can find more help about the multisite option [https://wordpress.org/support/forum/multisite here].

Setting up WordPress

2015-09-03T18:54:22Z

Andreas: /* Setting up multiple instances of Wordpress */

==Installing wordpress on our servers is definitely easy==

Installing wordpress on our servers is deffinately easy.

You download the install components from the http://wordpress.org wordpress-site.

Here you get a compressed file (.tar.gz or .zip) which you have to extract..

You get a folder with files, those files (so no the folder) you copy via filezilla or an other ftp programme to your www-map on your shellaccount.

Afterwards you go to your account, I.E username.ulyssis.be, here you get a notification telling you your <code>wp-config.php</code> has to be created, the easiest way is to follow the wizard, so click on “Create a Configuration File”.

Afterwards on ''Let's go!'' which will prompt you for your database credentials:

*'''Database Name: ''' if you haven't created a mysql database or user on UCC then you have to create it there. The default database is: username_username.
*''''User Name: ''' this is the name you gave during the creation of your mysql account, often this is the same as your username with ULYSSIS.
*'''Password: ''' the password hat you gave during the creation of your mysql account
*'''Database Host: ''' this is <code>mysql.ulyssis.org</code>
* You don't change the last field

When you're done click on “Run the install” Here you can give the last few details.

Afterwards the install will run by it own and thats it, you installed wordpress.

==Setting up multiple instances of Wordpress==

If you want to have multiple instances of a Wordpress site then you the create a new folder in your homedir from your shell account. You need a new virtual host, send us an email and we will create one for you.

After your new virtual host has been configured, you need to do al the same steps as for a regular wordpress installation.

You could also use the Wordpress [https://wordpress.org/support/forum/multisite multisite] option.

Setting up WordPress

2015-09-03T18:52:22Z

Andreas:

==Installing wordpress on our servers is definitely easy==

Installing wordpress on our servers is deffinately easy.

You download the install components from the http://wordpress.org wordpress-site.

Here you get a compressed file (.tar.gz or .zip) which you have to extract..

You get a folder with files, those files (so no the folder) you copy via filezilla or an other ftp programme to your www-map on your shellaccount.

Afterwards you go to your account, I.E username.ulyssis.be, here you get a notification telling you your <code>wp-config.php</code> has to be created, the easiest way is to follow the wizard, so click on “Create a Configuration File”.

Afterwards on ''Let's go!'' which will prompt you for your database credentials:

*'''Database Name: ''' if you haven't created a mysql database or user on UCC then you have to create it there. The default database is: username_username.
*''''User Name: ''' this is the name you gave during the creation of your mysql account, often this is the same as your username with ULYSSIS.
*'''Password: ''' the password hat you gave during the creation of your mysql account
*'''Database Host: ''' this is <code>mysql.ulyssis.org</code>
* You don't change the last field

When you're done click on “Run the install” Here you can give the last few details.

Afterwards the install will run by it own and thats it, you installed wordpress.

==Setting up multiple instances of Wordpress==

If you want to have multiple instances of a Wordpress site then you the create a new folder in your homedir from your shell account. You need a new virtual host, send us an email and we will create one for you.

After your new virtual host has been configured, you need to do al the same steps as for a regular wordpress installation.

You could also use the Wordpress https://wordpress.org/support/forum/multisite multisite option.

Setting up WordPress

2015-09-03T18:43:44Z

Andreas: