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.

svnserve.conf

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.

anon-access=none

passwd

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

So, I added my credentials.

fahmi=password

authz

This authorization file contains the

Advertisements

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 172.17.1.62, now I want to sift it to 172.17.1.127

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

The newer one is Red Hat linux and subversion is from apache.org

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

CREATE EXTENSION tablefunc;

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,  172.17.1.236 is my Oracle RAC’s scan ip.

For Windows,

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

172.17.1.236 ORACLE-RAC

for Linux,

go to /etc/hosts and add the following entry

172.17.1.236 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….

Ideas_R_Bulletproof

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 WordPress.com 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 172.20.1.88 as master and 172.20.1.89 as slave.

  • Installing Postgresql server.

wget http://yum.postgresql.org/9.0/redhat/rhel-5.0-x86_64/pgdg-centos90-9.0-5.noarch.rpm

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

yum install postgresql90-server.x86_64

Read more of this post