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.