You can find all your apache logs (like the access.log and error.log) on all of our servers in the directory: /var/log/apache_user/''username''

So if your username is ''foobar'' then you can easily access your logs this way:
foobar@zap:~$ cd /var/log/apache_user/foobar

foobar@zap:/var/log/apache_user/foobar$ ls
foobar.ulyssis.be

foobar@zap:/var/log/apache_user/foobar$ cd foobar.ulyssis.be

foobar@zap:/var/log/apache_user/foobar/foobar.ulyssis.be$ ls
access-2014-05-07.log error-2014-05-07.log

foobar@zap:/var/log/apache_user/foobar/foobar.ulyssis.be$ tail error-2014-05-07.log
[Wed May 07 01:27:14 2014] [error] [client 10.0.0.1] File does not exist: /home/user/foobar/www/favicon.ico

If you can't find your username inside of <code>/var/log/apache_user</code>, don't worry. If you enter it with <code>cd foobar</code>, it will automatically appear.

==With FileZilla==

You can also access the log files with an SFTP client, like FileZilla. Just enter
<tt>/var/log/apache_user/''username''</tt> on the right hand side, where it says
"Remote site", and press <tt>Enter</tt>:

[[File:Logs.png]]

2014-08-30T17:05:41Z

2014-06-22T14:20:07Z

Rockinroel: /* Setting up multiple instance of Wordpress */

==Wordpress installeren gaat zeker gemakkelijk op onze servers==

Je downloadt het installatiebestand van de [http://wordpress.org wordpress-site].

Hierbij krijg je een gecomprimeerd bestand (.tar.gz of .zip) dit pak je uit.

Je krijgt dan een map met bestanden, deze bestanden (en dus niet de map) kopieer je via filezilla of een ander ftp programma naar je www-map op je shellaccount.

Hierna surf je naar je account, dus naar username.ulyssis.be, je krijgt hier een melding dat je je wp-config.php nog moet aanmaken, het gemakkelijkste is gewoon de wizard blijven volgen, klik dus op: ''Create a Configuration File''.

Daarna op ''Let's go!'' waarna je gegevens van je database gaat moeten invullen:

* '''Database Name: '''als je nog geen mysql database of user hebt aangemaakt op UCC dan moet je dat daar doen. De standaard database is dan: username_username.
* '''User Name: '''dit is de naam die je hebt opgegven tijdens het maken van je mysql account, vaak is deze hetzelfde als je gebruikersnaam bij ULYSSIS.
* '''Password: '''het wachtwoord dat je hebt opgegven bij de aanmaak van je mysql account
* '''Database Host: '''dit is <code>mysql.ulyssis.org</code>
* Het laatste veld verander je niet.

Vervolgens krijg je de volgende error: ''Sorry, but I can’t write the <code>wp-config.php</code> file.'' Maar geen paniek, de tekst die WordPress gemaakt heeft is hetgene wat we nodig hebben. Kopieer deze tekst, sla dit op in een bestand <code>wp-config.php</code>. Dit bestand zet je dan weer via Filezilla over naar je www-directory.

Klik hierna op ''Run The install.'' Hier kan je dan de laatste gegevens invullen.

Daarna zal de installatie zichzelf uitvoeren en voilà, je hebt wordpress geïnstalleerd.

==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 you shell account. Then you make a new virtual host for this directory in UCC.

Name: alias.username.ulyssis.be
Document root: /home/user/username/new_folder

From now on you do al the same steps as for a regular wordpress installation.

Overview

2014-06-18T19:40:24Z

Overview

2014-06-01T09:22:30Z

Rockinroel:

<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]]
* [[Help, my account has been disabled]]
</div><div style="width:45%;float:left">
== Files ==
* [[Accessing your files]]
* [[Transferring files over SFTP]]
* [[Using SSHFS]]
</div>
<div style="clear:both;"></div>
</div>

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

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

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

== Security & anti-spam ==
* [[Keeping your website secure]]
* [[Preventing spam on your website]]
</div>
<div style="clear:both;"></div>
</div>

<div>
<div style="width:45%;float:left;padding-right:10px;">
== Mail ==
* [[ULYSSIS mail]]
* [[Forwarders]]
* [[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 101]]
* [[GitLab]]
</div><div style="width:45%;float:left">

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

__NOTOC__

Using PostgreSQL

2014-05-11T10:16:45Z

Rockinroel: /* 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 -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N

Using PostgreSQL

2014-05-11T10:16:30Z

Rockinroel:

= 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 -f username@ssh2.ulyssis.org -L 5400:pgsql.ulyssis.org:5432 -N