Thursday, January 06, 2011

iphone 4 ipod touch Change Delete Edit Update wifi wireless key wireless password wireless connection wireless network

So I had this problem today where the wireless key had changed for one of the wireless networks I have setup on my iphone 4. So question is how do you Edit or Update or Delete the old wireless key?

Here is what I ended up doing.

1. Go the Settings, Click on Wi-Fi
2. It will take you to Wi-FI Networks screen. On top you will have Wi-Fi as ON. Just below it you will have Choose a Network... option
3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other...
4.On the Other Network screen, I entered the name of the wireless network, under security, I made it WEP (mine was WEP,yours could be different), and then I got screen for password or wireless key rather, where I typed in the *new wireless key*. Thats it. I was able to join my existing wireless connection again.

Few other suggestions I found over the net.

1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try this because the message says, this will make sure iphone doesnt automatically connects to your wireless network everytime it see's it.

2. The other one I found was to reset *only the network settings*. Now in my case I had already setup 3-4 wireless networks and I didnt want to erase them and start over again. So I didnt go this route.

Try it and let me know if it works for you.

Updated on Jan 18 2011. It seems suggestion no.1 i.e. forget this network also works. You do that and next time click on network name to connect and iphone / ipod touch will ask you for the network key password.

Thanks,

Wednesday, January 05, 2011

iphone 4 ipod touch Change Delete Edit Update Delete wifi wireless key wireless password wireless connection

So I had this problem today where the wireless key had changed for one of the wireless networks I have setup on my iphone 4. So question is how do you Edit or Update or Delete the old wireless key?

Here is what I ended up doing.

1. Go the Settings, Click on Wi-Fi
2. It will take you to Wi-FI Networks screen. On top you will have Wi-Fi as ON. Just below it you will have Choose a Network... option
3. In my case, since I had to enter the new key for wireless network that was already setup before, I clicked on Other...
4.On the Other Network screen, I entered the name of the wireless network, under security, I made it WEP (mine was WEP,yours could be different), and then I got screen for password or wireless key rather, where I typed in the *new wireless key*. Thats it. I was able to join my existing wireless connection again.

Few other suggestions I found over the net.

1. Go to WiFi Networks and click on arrow next to the wireless network name and choose Forget this network. I didnt try this because the message says, this will make sure iphone doesnt automatically connects to your wireless network everytime it see's it.

2. The other one I found was to reset *only the network settings*. Now in my case I had already setup 3-4 wireless networks and I didnt want to erase them and start over again. So I didnt go this route.

Try it and let me know if it works for you.

Updated on Jan 18 2011. It seems suggestion no.1 i.e. forget this network also works. You do that and next time click on network name to connect and iphone / ipod touch will ask you for the network key password.

Thanks,

Wednesday, March 31, 2010

Java Keytool Export Private Key, PKCS#12 or .p12 export or conversion from java keystore

So, I had to create a PKCS#12 type or .p12 extension certificate from a java keystore which was created using java keytool. FYI, I have jdk 1.4.2. I came to know that using keytool you cannot export the private key.

I tried various options available in keytool i.e. create a keystore of type PKCS#12 to begin with instead of the default JKS (java keystore). -storetype PKCS12.

All this didnt work and on further search on google, I came across 2 free products which can help you a lot in terms of handling the keystore, generate keystore, export private key and so on.

You can download these free products from here.

The tools are portecle-1.5 http://sourceforge.net/projects/portecle/

KeyTool IUI – GUI http://www.icewalkers.com/download/KeyTool-IUI/3073/adl/

For my needs, i.e. generate a PKCS#12 certificate from an existing java keystore, portecle-1.5 worked just fine and it was very easy to use.

I also tried the KeyTool IUI – GUI just for testing the tool and it helped me to export the private key of my RSA key pair. The reason I wanted my private key in a seperate file is to use this online site which allows conversion of certificate types online. The url is https://www.sslshopper.com/ssl-converter.html.

Hope this helps someone. :-)

Helpful Links/Tutorial for keytool, PKCS#12 :

Cryptography Tutorials - Herong's Tutorial Notes

Keytool to OpenSSL Conversion tips

Exporting the Private Key from a JKS keystore

Exporting keystore private key with WSAS

Exporting Private Keys

Good Luck. :-)

Wednesday, February 24, 2010

SQL Server Exists Not Exists dont work with min max Aggregate functions

In my last post, I mentioned how @@ROWCOUNT gets affected when MIN, MAX i.e. aggregate functions are used.

Today, I had similar issues while using EXISTS and NOT EXISTS. I was using NOT EXISTS and records were showing up when really it should have removed the results.

select col1 from tbl1 where not exists (select min(something) from tbl2 where tbl2.col9 = tbl1.col2)

select col1 from tbl1 where not exists (select distinct something from tbl2 where tbl2.col9 = tbl1.col2)

Hope this helps.

Friday, December 04, 2009

SQL Server @@ROWCOUNT returns 1 if Min Max used in query

Hi,

I came across this crazy issue today. You expect @@Rowcount to return number of rows returned by query right. But in my case it was returning 1 for 0 rows returned.
Here is an example.

SELECT *
FROM yourtable WHERE 1 = 2

SELECT @@ROWCOUNT -- THIS GIVES 0

But if you have MIN function being used, the result will be different

declare @company_id int

SELECT @company_id = min(company_id)
FROM yourtable WHERE 1 = 2

SELECT @@ROWCOUNT -- THIS GIVES 1

Apparently, since NULL was the result set, @@rowcount was giving 1 as the count.

I hope this helps someone.

Thursday, October 29, 2009

SQL Server Insert Into Identity Column

We all know that if you have an identity column and if you try to insert a value in the identity column, you will get an error. Here is how you can avoid the error

First thing to do here is to set Identity to ON on the tblname you want to insert row in.

SET IDENTITY_INSERT tblname ON

INSERT tblname (ID,colname) VALUES(5,'ajas')

SET IDENTITY_INSERT tblname OFF

Do not forget to set IDENTITY_INSERT to off once you are done with inserting the record because you dont want it to be off if you have an application where developers will be working on it.

Hope this Helps.