This is something that had eluded me in the past so I wanted to write a very quickly documentation on the subject.
(In the past, I always thought the issue was purely firewall related.)
For MySQL running on an Ubuntu 14 server, the change is extremely simple to allow for incoming DB connections.
Here’s a quick guide for configuring a Firewall for Ubuntu 14.
The source of this guide is: https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-with-ufw-on-ubuntu-14-04
And I’d highly recommend checking it out.
Frankly the guide posted here is meant for personal use, but it may prove useful to others.
This documentation/guide is for how to modify Ubuntu 14’s Apache PHP5 so that a larger file size can be uploaded.
In this example, I modified the file size limit of 2mb to 4mb, as well as increased the max_execution_time so that there’s enough time to actually upload the larger file size to the server.
The process can be achieved several ways.
The easiest method is to modify php.ini.
sudo nano /etc/php5/apache2/php.ini
Modify the following lines:
upload_max_filesize = 4M post_max_size = 8M #default max_execution_time = 300
After saving the file, restart apache:
sudo service apache2 restart
This guide is intended to work for systems running Ubuntu 14.04 LTS, and PHP 5.5.9-1ubuntu4.19.
Installing Oracle DB access is pretty tricky, there are even Github repositories set aside to provide up to date python scripts to do this.
But it’s just as possible to do this manually. So here we go…
Here’s where the fun begins. We’re going to start by installing Apache and some other packages. To do this its begin with entering:
sudo bash
This means we’re not having to type sudo each time we run a command. When you’ve done this, enter the following:
apt-get install apache2 apache2-doc apache2-utils
This shouldn’t take long. Once we’ve done that we’re going to install a few support packages including PHP. Once complete, enter the following command:
apt-get install libapache2-mod-php5 php5 php-pear php5-xcache
This too shouldn’t take too long. Follow up with installing the support package for database connectivity:
apt-get install php5-mysql
Now we’re going to install MySQL server. Do this by entering the following command:
apt-get install mysql-server mysql-client
As part of the installation, you’ll be asked to set a root password. Enter a password and then confirm it when prompted in the blue screen.
THEN!
sudo apt-get install libapache2-mod-php5 sudo nano /etc/apache2/apache2.conf
#At the end of the file add: (if it’s not there)
AddType application/x-httpd-php .php
For reasons related to work, I will soon begin learning Delphi and Pascal.
Lately I’ve been using Ubuntu more often than my Windows 8.1 OS.
As such, I decided to see if I could compile and run my first Pascal code snippet in Ubuntu.
And well… here’s how to do just that!
One of the most complicated things I encountered while learning Haskell and Erlang (in particularly, Erlang) had to do with the area server example and understanding it in order to apply it to an homework assignment.
First I watched this video here: https://vimeo.com/37921309
It was extremely helpful in being able to understand the concepts behind setting up a spawned process and referencing it.
Below is the code for the area_server.erl example we (the class) were provided…
sudo apt-get install haskell-platform
