avatar

Andres Jaimes

How to connect to MySQL from a remote server

In few words, you have to configure MySQL to allow remote connections, create a user for connecting and setup your firewall to allow it. You don’t have to do this if you are only connecting from a local application like WordPress. You need root permissions to perform the following commands.  Configuring MySQL Edit the MySQL configuration file. nano /etc/my.cnf Allow connections from all your network interfaces by commenting out the following line:

A divided sky

Right before the rain…

Installing MongoDB/PHP Driver on CentOS 6

Since the module is not included with the default PHP installation, you have to download it from the official repository: cd mkdir mongo-php-driver cd mongo-php-driver curl https://codeload.github.com/mongodb/mongo-php-driver/zip/master > mongo-php-driver-master.zip Unzip it unzip mongo-php-driver-master.zip cd mongo-php-driver-master You need _phpize _to build the module. You can install it from the remi repository: wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm rpm -Uvh remi-release-6.rpm yum --enablerepo=remi install php-devel Configure and build phpize ./configure make all sudo make install Make sure the installation directory is the same as the PHP extension directory by running:

Installing MongoDB on CentOS 6

The first step is to configure the repositories. Create the following file /etc/yum.repos.d/10gen.repo with the following contents: For 32-bit systems: [10gen] name=10gen Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/i686 gpgcheck=0 enabled=1 For 64-bit systems: [10gen] name=10gen Repository baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64 gpgcheck=0 enabled=1 Install Mongo yum install mongo-10gen mongo-10gen-server  Configure MongoDB You can configure Mongo by editing the following file: /etc/mongod.conf Set Mongo to autostart on system boot: chkconfig mongod on Start Mongo service mongod start Stop Mongo

Unresponsive iOS7 beta 2 touch screen

Since I installed iOS7 beta 2 version, my touch screen started to go unresponsive from time to time. After a couple hours of internet research this is what I found: iPhone unresponsiveness is mainly caused by notification messages being sent behind the lock screen. For example, when your battery reaches 20% you get a notification on your screen. There is a bug that may send those messages behind the lock screen giving you as a result an unresponsive screen – your iPhone is waiting for a response, but since you do not see the window because it is behind the lock screen, then you cannot respond… and well, you know.

Installing the PHP/MongoDB extension on Mac OSX 10.8

Installing PHP/MongoDB extension is a two steps task on OSX: Install the autoconf tool required for compiling the extension Install the Mongo extension You have to install autoconf in order to avoid the following error: Cannot find autoconf. Please check your autoconf installation and the $PHP_AUTOCONF environment variable. Then, rerun this script. ERROR: `phpize’ failed Enough talk, hands on work…  Step 1. Install the autoconf tool Download the latest source version:

When I was twelve…

When I was twelve I learned something that changed my life: 10 print "Hello" 20 goto 10

1000 song names SQL test data

This time I want to share a 1000 rows SQL table that you can use for text searches. It includes a table with 1 column, 1000 rows song title names. It is plain standard SQL so you can use it with any database manager. Download it here. Hope you find it useful.

How to create a Finder Alias on Mac

A Finder alias is a special kind of shortcut or link to a folder. You can place this alias anywhere, being the Desktop a common place. You can even create an alias from a shared folder on a server. To create an alias: Open Finder and look for the folder you want to create an alias for. Press Option + Command while you click and drag the folder to the desktop.

How many bytes does an "int" have in c++?

Well, that depends on several things, like your current processor and compiler. The best way to know it, is by using the sizeof operator. Copy the following code, compile it and run it: #include <iostream> using namespace std; int main() { cout << "char: " << sizeof(char) << endl; cout << "int: " << sizeof(int) << endl; cout << "long: " << sizeof(long) << endl; return 0; } Happy coding…