Share IT Experience

Thursday, November 1, 2012

Set Timeout value for a mysql Connection

Due to bad handing of mysql connections (Not properly closed the connections ) there will be several already used open mysql connections waiting to close. By default the connection waiting timeout and the interactive time out values are 8 hours (28800 seconds).
Times set in your mysql server can be observed using following commands;

mysql> show variables like "%timeout%";

It will list down several timeout settings including interactive_timeout and wait_timeout

If you want to set these values according to your requirement edit your my.cnf (Default location is /etc/my.cnf) and add following setting under mysqld.

[mysqld]
interactive_timeout=3360
wait_timeout=3360

As given above I have set the value to 3360 ( which is 1 hour)

Then restart the service and it will effect the new connections.

Good reference:
http://stackoverflow.com/questions/4284194/terminating-idle-mysql-connections
http://dba.stackexchange.com/questions/1558/how-long-is-too-long-for-mysql-connections-to-sleep

Tuesday, October 30, 2012

Localizing ownCloud

We thought of installing ownCloud as a file/media/calendar sharing system and it was very easy to install it by just following the given instructions available at ownCloud itself.

While using the system we wanted to localized it to our own languages (si_LK - Sinhala- Sri Lanka, ta_LK - Tamil- Sri Lanka). As given in the instructions we created 2 projects at https://www.transifex.com and started translations on .po files. During the translation process it was required to view them on the installed ownCloud system. I followed several links and referred documentations but failed to make it. Finally, I used the following method to get it done.

1. Download all translated .po files for the required language;
As transifex allowed to download all kinds of .po files related to the language, I was able to collect all .po for si_LK

2. Create a folder with the language name inside the l10n folder at the document root of the ownCloud installation
In my case I create a folder si_LK at /var/www/html/owncloud/l10n

3 Place all translated .po files in to the language folder and change the ownership of the folder to web server user (e.g. apache, www-data )

4. Visit to 'core/l10n' folder at the document root (var/www/html/owncloud/core/l10n in my case) and there will be several locales ( uk.php, th_TH.php etc) available for your owncloud installation.

5. Create a locale file for your language
In my case I created si_LK.php ( Just copy an existing .php file as si_LK.php). The name of the file should be identical to the folder created at l10n.

6. Run the script available at l10n folder at the document root.
perl l10n.pl read
perl l10n.pl write

Now login to the ownCloud system and under the settings--> personal you will be able to select newly created locale as your language.

Sunday, June 17, 2012

Eleminate PHP Header Information Warning

In some instances we need to set header information inside the <body> section.
E.g. Redirecting to other page according to a condition.
Example code:

If ($a = "Yes")

header("location:ok.php");

It may gives a warning and code will stop at run time displaying a warning "Warning: Cannot modify header information - headers already sent by (output started at location) in /page on line xyz)"

Edit php.ini in your apache server and modify as "output_buffering = On"
To stop this warning and allow to add header information at to send header lines (including cookies) even after you send body content.