Friday, July 31, 2009

Linksys VPN

Q: When setting up a tunnel between two Linksys Router, what ports would you open if you need to send that tunnel through a 3rd party router? 

A: 500/udp   &    4500/udp

Dell Studio Laptop Integrated Webcam

Customer called in with the complaint that video didn't work inside Skype.

Long story short
1) Dell Customer service had disabled almost everything in her startup & still not fixed the problem.
2) it was infected with reva.vba entries in the autorun
3) It had an application Called Fast Access or faster access?

Fast Access appears to be an application that uses the webcam to determine your face and sign you into your PC. However, it never seems to let go of the webcam. I killed the .exe & the monitor service started it back up. I stopped the service then all three FAS... executables - suddenly the webcam started working.

windows xp outlook 2003 "messaging interface has returned an unknown error"

Customer has Windows XP SP3 Running Outlook 2003.
Outlook 2003 was attached to Hotmail (pre-connector) and it worked until very recently.
When it stopped working the hotmail profile was removed & the Outlook connector was installed. Suddenly they could now access hotmail but their local pop3 account stopped to function.

the message we see begins when you click new, once outlook is open, "The Messaging interface has returned an unknown error"

So far i've tried:
1) repairing outlook
2) remove contents of MAPI32 folder & allowing Outlook to rebuild it
3) Register ole32.dll
4) Perform all pending updates
5) Uninstall Outlook Hotmail Connector

Friday, July 17, 2009

PHP IIS 2k3 Server 2003 OCILogon Error

Fatal error: Call to undefined function OCILogon() in D:\wwwroot\testdb.php on line 3

We received this message on a server running Server 2003, IIS, PHP attempting to attach to an Oracle Server.

Some Prelims

1) Make a new app pool (we made one called PHP)

2) instead of an Isapi.dll simply edit the configuration (directory) on the properties of the site/virtual directory.

3) click configuration, add an extension mapping for the location of your isapi "D:\PHP\php5isapi.dll"

4) change the app pool of this site/virtual directory - to use the PHP app pool from #1.  Supposedly this allows you to right- click on the app pool, click recycle & it will reload your php.ini file without taking down everything.  In reality though, this didn't work & we still had to run (to get it to update):

net stop http /y

net start w3svc

5) Make sure PHP is in your allowed Web Service Extensions.  This script (test.php) will confirm PHP is working:

<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php phpinfo(); ?>
</body>
</html>

2) check the 6th row in the above script's output

Configuration File (php.ini) Path                C:\WINDOWS

3) This tells us PHP is looking to c:\windows for the php.ini.  The second we copied our php.ini to that folder - everything started working.

4) use this script (testdb.php) to test your oracle connection:

<?php

if ($conn=OCILogon("username", "password", "DSN")) {
echo "Successfully connected to Oracle using OCI extension.\n";
OCILogoff($conn);
} else {
$err = OCIError();
echo "Error in connecting to the Oracle." . $err[text];
}
?>

But really, the bottom line was copying the php.ini file from d:\php to c:\windows.

Monday, July 13, 2009

Outlook 2007 Indexing Status Disabled

My Windows XP box has Windows Search 4.0 and Outlook 2007. Outlook 2007 stopped indexing my messages.  When I checked, the indexing locations it only had Outlook Express, not Outlook.  I closed Outlook , changed this registry key from 1 to 0, then restarted Outlook.  Whaaaaa la!  Spent 4 hours looking for this yesterday & then found it in 3 minutes this morning.

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Windows Search

"PreventIndexingOutlook"=dword:00000000

This was set to 1 (supposedly by google sync).

Sunday, July 12, 2009

Windows Search 4.0

Issue: Windows Search is not functioning properly / is corrupt.

Solution: Re-install it. We tried to simply re-install it but nothing.

To repair
  1. Delete the following Reg Keys:
    1. "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Windows XP\SP3\KB940157"
    2. "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\KB940157"
  2. Then re-install the app WindowsSearch-KB940157-XP-x86-enu.exe
  3. Then you can run the uninstall app: C:\Windows\$NtUninstallKB940157$\spuninst\spuninst.exe
  4. Reboot
  5. Re-install the app (again) WindowsSearch-KB940157-XP-x86-enu.exe.
  6. Reboot.

Google Hosted Apps Notes

I use Google Hosted Apps for my email and calendars - okay it's out there.

I also use an 8gb iPhone to manage my life.  I have it syncing with my Google Hosted Apps for calendars.  These are my notes on the process.

m.google.com:443/sync/settings/a/lazyjeff.com/iconfig/setchosencalendars

Update:  I've spent this morning confirming the new Color Scheme for Google Hosted Apps Calendars

  1. From what I could tell, the color assignment was previously rather random.  At one time I had three calendars with a teal color with white text that was all but unreadable.

  2. This morning I added 9 calendars (one by one) using the link above via my iPhone.

  3. After each addition I switched over to my iPhone Calendar app and documented the change.

  4. First of all - the local account appears to be Green & unchangeable.  The pattern is below- but by default you cannot deselect your own calendar (POPPY COCK).

  5. The Pattern appears to be: GREEN, RED, ORANGE, BLUE, PURPLE.

  6. You can add more calendars, but it just repeats from there.

Friday, July 10, 2009

Using SQL Reporting Services against Oracle


  1. Start with a functioning SRS Server

  2. Install the Full Oracle Admin Client with your custom TNSnames file

  3. Create a Data Source, Select Oracle as the Connection Type & Set the Connection String to "data source=(name from tnsnames file)"

  4. select (X) credentials stored securely in the report server & enter a username & password then save.

  5. if you get this error - follow the "Solution Description" below:

An error has occurred during report processing.

Cannot create a connection to data source 'oracletes'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Solution Description
--------------------

Oracle 9.2 Client software requires that you give the Authenticated User
privilege to the Oracle Home by following these steps:

1. Log on to Windows as a user with Administrator privileges.

2. Launch Windows Explorer from the Start Menu and and navigate to the
ORACLE_HOME folder. This is typically the "Ora92" folder under the
"Oracle" folder (i.e. D:\Oracle\Ora92).

3. Right-click on the ORACLE_HOME folder and choose the "Properties" option
from the drop down list. A "Properties" window should appear.

4. Click on the "Security" tab of the "Properties" window.

5. Click on "Authenticated Users" item in the "Name" list (on Windows XP
the "Name" list is called "Group or user names").

6. Uncheck the "Read and Execute" box in the "Permissions" list under the
"Allow" column (on Windows XP the "Permissions" list is called
"Permissions for Authenticated Users").

7. Re-check the "Read and Execute" box under the "Allow" column (this is
the box you just unchecked).

8. Click the "Advanced" button and in the "Permission Entries" list make
sure you see the "Authenticated Users" listed there with:

Permission = Read & Execute
Apply To = This folder, subfolders and files

If this is NOT the case, edit that line and make sure the "Apply onto"
drop-down box is set to "This folder, subfolders and files". This
should already be set properly but it is important that you verify this.

9. Click the "Ok" button until you close out all of the security properties
windows. The cursor may present the hour glass for a few seconds as it
applies the permissions you just changed to all subfolders and files.

10. Reboot your computer to assure that these changes have taken effect.