Browsing All Posts filed under »Tietojenkäsittely«

Incomplete chunked encoding

April 19, 2016


There’s a form using php mail() to send HTML message. After clicking submit, variety of things will happen on server side, including email sending to submitter, to company and to me as a developer. For customer, it appears that nothing happens after click. However, all actions are performed just fine. While Firefox is not giving […]

Enable remote connection for MySQL, multiple connections

April 1, 2014


1. edit /etc/mysql/my.cnf and set bind-address to 2. if skip-networking is present, comment it out or remove it 3. restart and test: service mysql restart mysql -u remote_user_on_remote_system -pPASSWORD -h remote_system_url database_name Warning: your database security is compromised. Everyone could access it now, provided they’d know username and password. Lets limit this with firewall. […]

MySQL Federated connection, step-by-step

May 24, 2013


Federated engine can be used to push data from one database server to another. Lets say source server is called local server and target server will be remote. 1. Create table on remote server using a known engine. It is a good practice to define the engine here, although you might just use the default […]

Drupal 7 newsletter installation, step-by-step

May 10, 2013


Making HTML newsletter sender for Drupal 7 is something I keep forgetting how to do it. There are so many steps, all scattered around the system. I already wrote a guide about this, but here is the same in short. Download, install & enably these modules: Simplenews, Mime Mail, Mailsystem. Create first letter: Add content […]

#1030 – Got error 1 from storage engine

December 14, 2012


I was setting up a federated MySQL connection and had to fight through a lot of error messages from firewall settings to MySQL user synchronization. The last error I got before the setup was finally working was a real killer: “#1030 – Got error 1 from storage engine”. Try to search for this error and […]

Protect directory with .htaccess with Drupal installed

October 12, 2012


Want to use .htaccess to authorize your content, under a directory that has Drupal installed? Getting Page not found errors? Just add ErrorDocument 401 “Unauthorized” on your .htaccess file which you are trying to use for protection. Example: has Drupal 7 installed. I want to put some big files for distribution on Customer […]

Using Drupal 7 text filter (input format)

June 13, 2012


Simple example of how to do your own text filter (formally known as input format) module for Drupal 7. Documentation is not very clear, hence this posting. As starters, you have to create your new module files and directories, for example, myformat/ and so on. Check how to do that from your favourite Drupal guide […]