Setting up drupal 7 with MariaDB on Fedora

1. Edit file /etc/my.cnf.d/mariadb-server.cnf and add these 3 lines to the [mysqld] section: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true This will enable usage of Multi-byte (in particular – 4-byte) UTF-8 support in Drupal 7. 2. mysqli: If you have problems with mysqli/mysql change the mysqli to mysql (or vice versa – whatever works for you) in /sites/default/settings.php. Alternatively […]

Continue reading


Using curl and POST requests to automate data retrieval from a website

Problem: A site contains data which is of interest to us. The data is uniformly structured and available for examination by the general public (i.e. no login required) but is not automatically accessible, i.e. viewing it requires repetitive user interaction (such as setting a date range, clicking a ‘submit’ button, etc). In addition, usually the […]

Continue reading


Setting up multi web site developer testbeds/sandboxes on localhost

Scenario —————————————————————— You are maintaining several web-sites (site1.com, site2.org, etc…). Having just one web-site at localhost with all files (DocumentRoot) at /var/www/html is not an option for you. You need to be able to test all of them and to access them in a convenient way. Solution Setup apache with Virtual Hosts, give your sites […]

Continue reading