Installing Oracle 11g XE and SQLDeveloper on Debian 8.5

Enrique Latorres

[multilanguage_switcher] First, let’s open a terminal and install the following packages: sudo apt-get install alien libaio1 Then download del installation file. Go to the Download page at Oracle. http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html In order to download the package, you must have a registered user at Oracle website. If you don’t, please do register and try again. At the time of this post, the following file was downloaded. http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip  If you click on this link you’ll be prompted for a user and password. Notice that the instalation file is an .rpm file. This is the…

Read More

Arduino I2C-LCD Display Project with Malpartida Library

Enrique Latorres

[multilanguage_switcher] When trying to connect an LCD Display to your Arduino project, a clever solution is to use an I2C-LCD adapter. In this case the FC-113 IIC/I2C serial interface adapter module for 1602 or 2004 LCD Display. This will decrease the number of pins used in your Arduino board, leaving place for other sensors and actuators. The connection between the LCD Display and the I2C Module is quite straight forward. simply connect pin n of LCD to pin n (1 to 1, 2 to 2, and so on) of Serial Module…

Read More

Cleaning heavy aluminum corrosion

Enrique Latorres

[multilanguage_switcher] While maintaining geophysical equipment placed out in the field, you may find some aluminum alloys are heavily corroded in case of contact with water (Or worst if battery leakage). That can be the case when you return for maintenance and revision, maybe months after last installation or visit. Pure aluminum is usually quite resistant to corrosion. But aluminum alloy castings are more susceptible of heavy corrosion. Aluminum alloys with other metals are meant to be stronger than pure aluminum. It depends on the type of alloy whether it is…

Read More

Testing Lolin NodeMCU V3 esp8266

Enrique Latorres

[multilanguage_switcher] I’m testing Lolin NodeMCU V3 esp8266. This is a tiny microcontroller with embeded wifi. The model we are trying has 1MB of flash ram plus 8k of dynamic ram. These are quite a lot for many purposes. I’m using Arduino just for ease. But it’s got a Lua framework, this is that you can make Lua scripts upload them to the NodeMCU, link it to the init.lua script and run. I’m not going to show the Lua example in this post, but the Arduino IDE example. The Arduino IDE…

Read More

How to use WordPress MySQL Database Reader to recover posts

Enrique Latorres

In order to recover your posts you need to recover your MySQL Database (through your utilities, like phpmyadmin, mysql workbench, console, etc.) or maybe you can connect directly to the database (some user:password@server:port, etc). In the first case assumes you can download a backup and were able to restore it at some other server, maybe your own desktop/laptop computer. In other cases like recovering from disk failure, server failure, etc, please read elsewhere in the Internet for directions or help. We assume a software failure. You may have to recover…

Read More