Setting up a VPN for an iphone using server 2003 PPTP and then connecting to Qlikview Server

So needed to setup some sort of a VPN for our iphones to be able to get to our qlikview server.

Basically you just need to turn on routing services for the server 2003, setup your access rules (create a group something like VPN access) allow dial in and add then to the vpn group in there NT profile. This post lays it out well http://articles.techrepublic.com.com/5100-10878_11-5805260.html

The fun part (if you don’t have your server on the outside/DMZ) is getting your isp to set up port forwarding. I told them this

We are setting up a PPTP VPN (point to point tunneling protocol)

We need port 1723 forwarded to our server at ______ fill in your server address.

We also need to enable the GRE IP protocol (This is protocol 47)

And that seemed to do the trick. On the iphone navigate to the VPN area, choose PPTP, use your NT username and password, and put in the public IP of your server.

Then for qlikview you just install the qlikview app, and then add your server (for some reason DNS doesn’t seem to resolve so I used the ip address, maybe figure this out in the future)

Having a VPN on your phone is very nifty since you can install remote control software as well! Mocha soft seems to be doing very well in this market and I can recommend their telnet lite, vnc lite, and the best remote desktop lite http://www.mochasoft.dk/iphone_rdp.htm

This has me jazzed since I really got used to this functionality on my cingular 8525.

I ran into this bug /usr/sbin/mysqd: Error writing file ‘/var/lib/mysql/hostname.pid` (Errcode: 28) Can’t start server: can’t create PID file: No space left on device

As reported here, http://bugs.mysql.com/bug.php?id=16264

To fix delete all of the access_logs in var/log/httpd grrr….. that was annoying.

Using active directory to push out Power Configuration to your users power.adm

Got the .adm from here

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/XP/Q_21074765.html

But need to add a blank line at the end!!!!!!!!!!!!!!

CLASS MACHINE
CLASS USER
CATEGORY “Control Panel”
CATEGORY “Power Schemes”
KEYNAME “Control Panel\Powercfg”
POLICY “Power Configuration – User Setting”
PART “Power Schemes” DROPDOWNLIST
REQUIRED
KEYNAME “Control Panel\PowerCfg”
VALUENAME “CurrentPowerPolicy”
ITEMLIST
NAME “Max Battery”
VALUE “5″
NAME “Home/Office Desk”
VALUE “0″
NAME “Portable/Laptop”
VALUE “1″
NAME “Presentation”
VALUE “2″ DEFAULT
NAME “Always On”
VALUE “3″
NAME “Minimal Power Management”
VALUE “4″
END ITEMLIST
END PART
END POLICY
END CATEGORY
END CATEGORY

Save this as an .adm. Open up group policy management on your server. Right click edit one of your policies. Under user configuration there is administrative templates. Right click and go add/remove templates. Add the above created .adm if you get an error about CATEGOR you need to add a blank line to the end of the .adm

Now click into control panel, power schemes. THEN OPEN up View, click filtering AND UNCHECK Only show policy settings that can be fully managed.

Now you should see power configuration – user setting. Enable it and then change to your desired scheme.

WickBrick NonProvisional Patent filed!

So those of you needing brain damage here is some light reading….

The spcifications

http://sites.google.com/site/mellerbeck/Home/Specifications_new.pdf?attredirects=0

The Drawings

http://sites.google.com/site/mellerbeck/Home/Drawings.pdf?attredirects=0

The Claims

http://sites.google.com/site/mellerbeck/Home/Claims.pdf?attredirects=0

I’m sure I have made a mistake or two, but it was a very interesting (and time consuming process) hopefully the patent examiner will be kind to me.

Curry Bistro – Cuisine of India, Menu

the-ip-address-you-have-entered-is-already-assigned

http://windowsitpro.com/article/articleid/74161/jsi-tip-2842-the-ip-address-you-have-entered-is-already-assigned.html

When you enter the IP Address on a NIC, you receive:


   The IP address <XXX.XXX.XXX.XXX> you have entered for this network
   adapter is already assigned to another adapter <Name of adapter>.
   <Name of adapter> is hidden from the network and Dial-up Connections
   folder because it is not physically in the computer or is a legacy adapter
   that is not working. If the same address is assigned to both adapters and
   they become active, only one of them will use this address. This may result
   in incorrect system configuration. Do you want to enter a different IP
   address for this adapter in the list of IP addresses in the advanced dialog box?

Where <XXX.XXX.XXX.XXX> is the IP address that you are trying to set and <Name of adapter> is the name of the network adapter that is present in the registry but hidden in Device Manager.If you press Yes, you can change the IP Address. If you press No, your NIC and the ghosted NIC have the same address. This is not normally a problem as the driver for the ghosted NIC is disabled.

This problem is genrally caused by moving the NIC to a different PCI slot.

To fix the problem:

1. Open a CMD prompt.

2. Type:

set devmgr_show_nonpresent_devices=1

3. Type:

Start DEVMGMT.MSC

4. Press View and Show Hidden Devices.

5. Expand the Network Adapters tree.

6. Right-click the ghosted NIC and press Uninstall.

10 Tips for improving ESX

http://www.scribd.com/doc/4891406/Tips-to-Improve-Performance-of-Guest-Server-in-Esx-Server

I didn’t notice that you should use the vmxnet driver for increased performance.

Using Altova Mapforce to Create Wikipedia Articles from an ERP backend.

So I wanted to create stub articles and useful charts to flesh out our internal wiki. I of course grabbed the amazing Altova Mapforce and made short work of generating pages and charts and then imported them into our wiki using pywikipedia http://meta.wikimedia.org/wiki/Using_the_python_wikipediabot

Here is what I came up with

http://sites.google.com/site/mellerbeck/Home/usingAltovaMapforcetoCreateWikipediaArticles.pdf?attredirects=0

Here is a quick flash video of the process as well.

http://sites.google.com/site/mellerbeck/Home/wiki.swf?attredirects=0

setting default browser from the command line

shmgrate.exe OCInstallReinstallIE shmgrate.exe OCInstallReinstall

Using Conary to install ghostscript

So I was fighting trying to get ghostscript to install on my rpath media wiki appliance. Now I know nothing about Conary so this was a bit over my head but I eventually got it. But don’t trust any of this you have been warned.

What I needed to do was to update my /etc/conaryrc so

vi /etc/conaryrc

and add conary.rpath.com@rpl:2 after the installLabelPath mediawiki.rpath.org@wm:mediawiki-1.x

I think what this does is allow it to resolve its dependencies?

So then run the command

conary updtae ghostscript –resolve

And that looked to have done the trick.