Subversion authz, passwd and svnserve.conf

I wanted to configure my subversion/svn server so that I can checkout or commit file with a specific user name and password. This type of authentication depends on three files. These are authz, passwd and svnserve.conf. Which are located in the corresponding repositories conf directory.

When we create a repository, these tree files are created automatically with default values. We have to add/edit some configurations to make work the repository properly.


I want to use a password file for authentication. So, I uncomment the following line to use the default password file.

password-db = passwd

I want  to use the default authorization file. So,

authz-db = authz

I also have to define anonymous access in my repository. I don’t want anyone to have read or write access to my repository.



This password file contains the user name and password of authorized access in the repo.

So, I added my credentials.



This authorization file contains the

Increase MySQL max_connections for ‘too many connection error’

mysql -uroot -p


mysql> SHOW VARIABLES like ‘max_connections’;
| Variable_name | Value |
| max_connections | 100 |
1 row in set (0.00 sec)


mysql> set global max_connections=500;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES like ‘max_connections’;
| Variable_name | Value |
| max_connections | 500 |
1 row in set (0.00 sec)

WordPress Version Update

Get the latest WordPress zip (or tar.gz) file.
Unpack the zip file that you downloaded.
Deactivate plugins.
Delete the old wp-includes and wp-admin directories on your web host (through your FTP or shell access).
Using FTP or your shell access, upload the new wp-includes and wp-admin directories to your web host, in place of the previously deleted directories.
Upload the individual files from the new wp-content folder to your existing wp-content folder, overwriting existing files. Do NOT delete your existing wp-content folder. Do NOT delete any files or folders in your existing wp-content directory (except for the one being overwritten by new files).
Upload all new loose files from the root directory of the new version to your existing wordpress root directory.

Windows 7 Bootable USB Install

Insert Your USB flash drive.

Run cmd.exe as administrator. Read more of this post

SVN / Subversion Backup and Restore

My svn repo was at, now I want to sift it to

Previous one was hosted on Ubuntu platform, where subversion from was installed.

The newer one is Red Hat linux and subversion is from

Both are the same source but version is different. Read more of this post

Installing PostgreSQL 9.2 contrib extension in RedHat Linux

I had a table view in PostgreSQL DB, which uses ‘crosstab‘ function.

But my PostgreSQL wouldn’t let me use it, as it requires some extensions.

Crosstab function requires ‘tablefunc‘ extension.

When I tried


It gave me

ERROR: could not open extension control file “/usr/pgsql-9.2/share/extension/tablefunc.control”: No such file or directory

********** Error **********

ERROR: could not open extension control file “/usr/pgsql-9.2/share/extension/tablefunc.control”: No such file or directory
SQL state: 58P01

Read more of this post

Oracle JDBC Connection – Moving from Oracle Single Instance to Oracle RAC Grid

Our core oracle database has been moved to oracle single instance to Oracle RAC Grid.

I had some old Java systems, which were using JDBC connection to connect Oracle. When system moved to RAC, my systems wasn’t working. Now, I need to change my OS host file and JDBC connection string. FYI, is my Oracle RAC’s scan ip.

For Windows,

go to C:\Windows\System32\Drivers\etc\hosts and the following entry ORACLE-RAC

for Linux,

go to /etc/hosts and add the following entry ORACLE-RAC

Done for OS part. Now the connection String.

Read more of this post

the 61-member group shot of TTL for BIF-5… how it was done….


24 April 2013

TTL Group Photo - Processed

probably should’ve come up with this post several days back, but circumstances led me to wait a bit more than I would’ve liked…. anyway, there’s always a time for everything, and perhaps this is the time for this post…. “Bangladesh in Frames V” (BIF) came to an end last night (23rd April 2013) making us feel a bit empty…. this group photo that we’re talking about was on display outside Drik Gallery for five days during the exhibit…. those who are wondering why a group shot like this is so special to us, can visit our previous two posts on group shots of this nature…. the one for BIF-3 (2011) and the one for BIF-4 (2012) set a standard for “Through the Lens: Bangladesh” (TTL) and made our work harder…. this meant that every year we have to produce something ever more creative and ever…

View original post 1,066 more words

2012 in review

The stats helper monkeys prepared a 2012 annual report for this blog.

Here’s an excerpt:

600 people reached the top of Mt. Everest in 2012. This blog got about 8,900 views in 2012. If every person who reached the top of Mt. Everest viewed this blog, it would have taken 15 years to get that many views.

Click here to see the complete report.

PosgreSql 9.0.x replication on CentOS 5.5 x64

For Postgresql replication database system consists of two servers, one is master server and another is slave server. CentOS 5.5 x64 is installed in both of the servers. Following steps are applicable in both of the servers. I issued all the commands as root. For our demo I used as master and as slave.

  • Installing Postgresql server.


rpm -ivh pgdg-centos90-9.0-5.noarch.rpm

yum install postgresql90-server.x86_64

Read more of this post