ELEVENTH WEEK

 ENDIKA SANCHEZ


In Database Management we are working with Triggers. These triggers are small programs which are executed when a certain action (update, insert, create, delete, drop…) is started. The hard part isn’t the trigger itself because are quite simple to create, the hard thing is the actual programming inside the trigger because we haven’t learned much TRANSACT-SQL which is the language it uses.

 

In Operative System Management we are using NFS and SAMBA protocols. These protocols are used to share resources within your domain. NFS is used in unix based OS and SAMBA in the other hand, is used for Linux to Windows resource sharing.

In Internet and Network Services we are almost done with our mail server. The basic setting is quite simple, but we installed a spam filter and an antivirus, these two services where pretty confusing to configure because you have to edit many configuration files and you have to be careful with the order in which you write the specific rules for each service in these files.



In Security and High Availability, we are using IPTABLES, which is a firewall for linux Operative Systems. The rules must be carefully written because if it finds a math for a specific machine-port, it won’t read any other rule for that IP address which can be a huge security issue.



In Web Application Deployment we have an exam next week. In this exam we will have to create a MariaDB database and write a code to:

·         Login

·         Add a product

·         Delete a product

·         Show a product list

·         A product browser

·         Modify a product

·         Upload a file

In just 2 hours… we will have to do 3-4 of the above but still, the time will be very limited.


IKER LOPEZ

First of all, in this week, with Javi we have been working with triggers. The triggers are programs that they execute when an action happens.

Also we are working with NFS and Samba, which are tools to share files between different computers.

With Ricardo we are working with IPTABLES. IPTABLES is basically the firewall that Linux uses.
So is something more difficult than the windows´s firewall because you have to configure all by your own and using commands, nothing graphic, because we are using Debian, and Debian has not a graphical interface.

Also we have done with our mail server.

TENTH WEEK

 ENDIKA SANCHEZ


In Database Management we started with synonyms, views and schemas. Synonyms are just an alias for our objects. Views can store queries, so we don’t have to write them every time we want to use them, these are very useful. Lastly, schemas are the most complex ones, these are used to grant, revoke or deny permissions over users and database objects, because of this, you can mess up really badly and we have to be careful when editing schemas.



In Operative System Management we are still working on remote access software and I use my spare time to finish tasks from other subjects.


In Internet and Network Services we are configuring a mail server, I’m using dovecot, postfix and rainloop. While dovecot and postfix were easy to configure, rainloop is taking too much time because I can’t get it to show the main configuration page on a browser, I guess I’ll have to create it as an Apache2 virtual host.
 

In Security and High Availability, we are configuring a VPN to our Windows 10 computer. It’s very simple as you only have to follow the assistant to complete the installation.


In Web Application Deployment we are working on improvements for our web page. We added a field to upload images and we are modifying our database to add a column to store those files. We also changed the way to check sessions and roles. We still have many things to improve I guess but it’s difficult to find and fix security issues.


IKER LOPEZ

On this week with Javi we started working with schemas, views and synonyms. Those thing are related to the Database management.
On the other hand, we still working with the remote access on Operative System Management hours.

With Ricardo we still working on VPN on Windows 10.
Also we are configuring the mail server using tools like postfix, dovecot and rainloop.

Finally on Xabi´s hours we are still working on our web. Now we are improving it and adding some new thing to it.

NINTH WEEK

 ENDIKA SANCHEZ

This week has been quite boring, we finished the challenge last week and they haven’t introduced the new challenge yet, so we are just planning the remaining weeks.


In Database Management we haven’t started with anything new, so we are just using these hours to work in other subjects.


In Operative System Management we started with SSH, telnet, VNC and Webmin services, which can be used to manage a server remotely. We are configuring each service in our Ubuntu 17.04 OS and connecting from our windows clients. SSH and Telnet are pretty straightforward while Webmin and VNC are quite harder to install and configure.

 

In Internet and Network Services we saw some information about mail servers, but we haven’t done anything yet. The teacher said it’s going to be a bit harder than other services because it has more configuration options and more files.

 
In Security and High Availability we are learning about VPN (Virtual Private Network). This service is used to open an encrypted tunnel over a public network, so we can work from our home as if we were on our company network.



In Web Application Deployment we are going to see some improvements that can be done to our current web. We will have an exam in which we’ll have to connect to our database and create a page which can be either a formulary to add a product to our database or a list which shows every product or even a product browser which is probably the longest one since you have to create more variables and queries.

IKER LOPEZ

Last week we finished the first challenge so this one was a little more relaxed.

With Javi we started learning things about the remote access between operative systems.
We use tools like VNC, SSH, Webmin and Telnet.

We are working with 2 computers using Ubuntu and one more with Windows installed.
The objective is to connect the machines between each other using the different tools we have mentioned before.

With Ricardo we started knowing things about mail services, but we havent seen anything yet.
Also we are learning about VPN (Virtual Private Networks).
VPN essencially is like a tunnel between computers to establish a secure connection between them.