Thursday, December 29, 2011

Installing Microsoft SQL Server Management Studio Express in Windows Vista or Seven: Error 29506

Installing Microsoft SQL Server Management Studio Express in Windows Vista or Seven: Error 29506

This is a problem about privileges. Probably the installer performs the latests tasks without using elevation.

Solution is very simple: run the installer from an elevated command prompt.

Click Start.
Type cmd end press CTRL+SHIFT+ENTER and accept the elevation.
Execute the installer from there (just type path and filename).
This works on Windows Vista and, of course, on Windows 7.

If using a 64 bit version, please note you will have to use the 64 bit version of cmd.exe, which is located in c:\Windows\SysWoW64 instead on c:\Windows\System32, so just write c:\Windows\SysWoW64\cmd instead of just cmd (thanks to Pierre Boucher for this)


http://www.sugata.eu/2008/04/16/installing-microsoft-sql-server-management-studio-express-in-windows-vista-error-29506/

Friday, June 3, 2011

Tomcat Loadbalancing


#Install JDK
#Set Environment Variables
JAVA_HOME C:\Program Files\Java\jdk1.6.0_25

#Copy extracted Tomcat folder to
c:\Tomcat\

#Set Environment Variables
CATALINA_HOME C:\Tomcat\apache-tomcat-6.0.32

#Add following text to tomcat-users.xml
<role rolename="manager-gui"/>
<user username="admin" password="******" roles="manager-gui"/>

#Modify catalina.properties to add shared libraries
shared.loader=${catalina.home}/shared/lib,${catalina.home}/shared/lib/*.jar

#Copy C:\Tomcat\apache-tomcat-6.0.32
C:\Tomcat\node01-6.0.32

#Delete contents from the following subfolders
logs
temp
webapps
work

#Add startNode.bat on both nodes
set CATALINA_HOME=C:\Tomcat\apache-tomcat-6.0.32
set CATALINA_BASE=C:\Tomcat\node01-6.0.32
C:\Tomcat\node01-6.0.32\bin\startup.bat

#stopNode.bat
set CATALINA_HOME=C:\Tomcat\apache-tomcat-6.0.32
set CATALINA_BASE=C:\Tomcat\node01-6.0.32
C:\Tomcat\node01-6.0.32\bin\shutdown.bat

#installService.bat to install windows service
set CATALINA_HOME=C:\Tomcat\apache-tomcat-6.0.32
set CATALINA_BASE=C:\Tomcat\node01-6.0.32
C:\Tomcat\node01-6.0.32\bin\service.bat install NODE01

#uninstallService.bat to uninstall windows service
set CATALINA_HOME=C:\Tomcat\apache-tomcat-6.0.32
set CATALINA_BASE=C:\Tomcat\node01-6.0.32
C:\Tomcat\node01-6.0.32\bin\service.bat remove NODE01

#Modify server.xml to add jvmRoute
<Engine name="Catalina" defaultHost="localhost" jvmRoute="node01">

#Modify server.xml to change ports
<Server port="8006" shutdown="SHUTDOWN">
<Connector port="8081" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
<Connector port="8010" protocol="AJP/1.3" redirectPort="8443" />

#Install httpd-2.2.xx
#Uncomment following LoadModules from httpd.conf
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so

#Add the following settings to httpd.conf
<VirtualHost *>
<Proxy balancer://ajpCluster>
BalancerMember ajp://localhost:8010 route=node01 retry=60
#BalancerMember ajp://localhost:8011 route=node02 retry=60
</Proxy>

<Location />
Allow From All
ProxyPass balancer://ajpCluster/ stickysession=JSESSIONID nofailover=off
</Location>
</VirtualHost>

#To configure the instance
C:\Tomcat\apache-tomcat-6.0.32\bin>tomcat6w //ES//node01

Monday, October 18, 2010

WSADMIN


wsadmin.bat -lang jython -user -password

for app in AdminApp.list().split('\r\n'):
AdminApp.export(app, 'c:\\extras\\backup\\' + app + '.ear')

Tuesday, August 10, 2010

DB2 SQL COPY TABLE PROCEDURE

CREATE TABLE <ibrary>.<table> LIKE <library>.<table>

INSERT INTO <library>.<table> (SELECT * FROM <library>.<table>)

Wednesday, July 7, 2010

Cygwin SSH keygen (1024 bit, DSA)


$ ssh-keygen -t dsa -b 1024

Enter twice (empty for no passphrase)

Setting up Password-less Authentication

Client Machine
Default private key file : /home/<client-user>/.ssh/id_dsa
Default public key file : /home/<client-user>/.ssh/id_dsa.pub

Server Machine
Append the public key to the "/home/<server-user>/.ssh/authorized_keys" file (ubuntu server in this case)

Java SSH Client Code

//Set file system options
FileSystemOptions fsOptions = new FileSystemOptions();
SftpFileSystemConfigBuilder.getInstance().setStrictHostKeyChecking(fsOptions, "yes");
SftpFileSystemConfigBuilder.getInstance().setIdentities(fsOptions, new File[]{new File("C:\\cygwin\\home\\<client-user>\\.ssh\\id_dsa")});

FileSystemManager fsManager = VFS.getManager();
FileObject textFile = fsManager.resolveFile( "sftp://<server-user>@<server-name>/", fsOptions );
for(FileObject fObject : textFile.getChildren()) {
System.out.println( fObject.getName());
}

Friday, May 21, 2010

Java Code to Create a Buffered Image of TYPE_BYTE_BINARY


byte[] cMap = new byte[] {(byte)(255),(byte)(0)};
IndexColorModel colorModel = new IndexColorModel(1, 2, cMap, cMap, cMap);

BufferedImage combined = new BufferedImage(
buf1.getWidth(),
buf1.getHeight() + buf2.getHeight() ,
BufferedImage.TYPE_BYTE_BINARY );

byte[] data = ((DataBufferByte) src.getRaster().getDataBuffer()).getData();
for(int i = 0; i < data.length; i++) {
data[i] =(byte) (~data[i] & 0xff);
}

Friday, April 23, 2010

Create ISO images from CD, DVD & Folder

For Drives

dd if=/dev/dvd of=dvd.iso # for dvd
dd if=/dev/cdrom of=cd.iso # for cdrom
dd if=/dev/scd0 of=cd.iso # if cdrom is scsi


For Folders

sudo apt-get install genisoimage
mkisofs -allow-lowercase -o cd.iso image/