Legacy MSSQL DB migration

Saturday, we migrated an MSSQL7 DB to MSSQL2K. We also have MSSQL2005 but our VB6 front-end could not handle the newer version. Today its rolled into production. It was a non-event but the power interruptions spoiled the fun.

WAP enabled Blogger or S60 App

I hope Blogger will come out with a WAP enabled site or an S60 app for those who think as fast as his thumb can type! My last post was also done on my phone...

Globe Tattoo Mobile in GenSan

just tested my usb dongle without using a cable at several locations in GenSan. At GensanVille Subd: with signal but no Internet. 50m from Laurel cor Bayabas Sts Globe cellsite: just GPRS/EDGE signal and slow Internet. Maybe one needs to use the usb cable to improve the signal or Globe is not yet ready for this product here. Hope this will improve soon!

Web Proxies

Today, a problem emerged when internal LAN users connect to http://xxx.xxx.xxx/xxx. They all get a blank page. I was able to trace this a badly configured proxy in another part of our network.

After deciding on several options, I decided to use our own proxy connected to our own gateway. Several questions came up, among which are:

1) How do you force a squid proxy to use a certain parent cache for a certain domain?

example answer: cache_peer_domain 172.16.1.57 .co.in
(see http://wiki.squid-cache.org/CategoryConfigExample)

2) How about making sure that requests for certail URL goes direct, instead of querying the cache:

ACL foo dstdomain .example.net
Always_Direct Allow foo

3)If you want to configure Apache as a proxy, use this as reference: http://httpd.apache.org/docs/2.2/mod/mod_proxy.html. Apache can be configured in both a forward and reverse proxy (also known as gateway) mode

These and other administrative functions occupied my day today...

C# to GMail

As a way to mark this date, when this blog was created, I am posting what is on my platter. I hope someone would stumble to this and lead me to the right direction...

Testing email sender


Exception Error: 504 5.3.3 AUTH mechanism LOGIN not available
at System.Net.Mail.SmtpClient.Authenticate (System.String Username, System.String Password) [0x00000] at System.Net.Mail.SmtpClient.PerformAuthentication () [0x00000] at System.Net.Mail.SmtpClient.Send (System.Net.Mail.MailMessage message) [0x00000] at emailtester.Page_Load (System.Object sender, System.EventArgs e) [0x00000]
SMTP HOST: localhost
SMTP PORT: 25
FROM: xxxxxx
USE FROM: xxxxxx
======================================================


RECEIVER TEST:

Exception Error: Read failure
at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, Int32 offset, Int32 size) [0x00000] at System.IO.StreamReader.ReadBuffer () [0x00000] at System.IO.StreamReader.ReadLine () [0x00000] at OpenPOP.POP3.POPClient.Connect (System.String strHost, Int32 intPort) [0x00000] at Emailer.Receiver.Connect () [0x00000] at Emailer.Receiver.TestPop3 () [0x00000] at emailtester.Page_Load (System.Object sender, System.EventArgs e) [0x00000]
System.Net.Sockets.SocketException: Operation timed out. at System.Net.Sockets.Socket.Receive (System.Byte[] buf, Int32 offset, Int32 size, SocketFlags flags) [0x00000] at System.Net.Sockets.NetworkStream.Read (System.Byte[] buffer, Int32 offset, Int32 size) [0x00000] POP3 HOST: pop.gmail.com
POP3 PORT: 995
POP3_USERNAME: xxxxxxxxxxx
POP3 PASSWORD: xxxxxxxxxxx

One more blogger joining the melee

I used to have doubts if I can sustain blogging, but after being initiated to Twitter, Friendfeed, Facebook, Yammer, etc...I decided I go the extra mile and go for a blog. What for? I don't know yet, but I figure I can share my insights, experiences, knowledge acquired, and inanities in general. So watch out for a noob on blogging