Fix and install Windows 10 2022 Update | Version 22H2

Posted at 12:23:07 AM in Installations (48)

 Use this link

Written by Leonard Rogers on Saturday, February 4, 2023 | Comments (0)

Vostro 3550 Laptop update from Windows 7 to Windows 10

Posted at 2:08:49 AM in Installations (48)

When I first started working on this laptop, the hard drive had problems when the person tried to update it to Windows 10. It got stuck in a loop that wouldn't allow them to restore the laptop in anyway. They couldn't continue and they couldn't revert to the original install. In fact, they couldn't even use the restore partition to wipe out the drive and reinstall the original system. So, I installed a new drive and reinstalled the Windows 7. After that was complete, I went to the Dell site and downloaded all of the drivers using the Dell utilities to load all the drivers. Believing the laptop was up-to-date on all the drivers I went to upgrade it to Windows 10. Failed.

It turns out that the BIOS driver that the Dell utility provided was only A09, which when updated to Windows 10, refused to show the screen info on the laptop. I was able to see the screen for a few seconds on an external monitor before it went black. This was enough for me to run the task manager and run the BIOS updates which I found and installed from the Dell site version A11. Everyone said this fixed their problem. I could now see my cursor on the laptop screen, but the screen would still black out leaving only the cursor. I then found that there was yet another BIOS update to A12 that others said fixed their problem, but again, my screen blanked out after a few seconds after logging in.

When I pressed control-alt-del, I would get the lock, change password menu and I could see that without a problem. When I launched the tax manager from that screen, I could see the task manager from but everything else was blank. I launched the control panel from the task manager (File / run new task) and then type in "control panel" and after looking at device issues, I finally looked at the event log and found that every time I launched explorer.exe, it crashed due to the IDT audio driver. So I uninstalled the IDT audio driver and launched explorer.exe from the tax manager and my desktop came back to life. Rebooting the laptop, installed some generic High definition audio drivers and my screen worked with out a problem afterwards.


Written by Leonard Rogers on Saturday, October 10, 2015 | Comments (0)

Setting up Email delivery for Voicemails in FreePBX

Posted at 2:32:41 AM in Installations (48)

The email system in FreePBX distro as of this date does not have the email interface built into the web GUI. I'm using Asterisk 10, FreePBX

The email engine is Postfix.

Setting up email is pretty straight forward, but requires you to edit files using an editor. Hardcore Linux users would prefer Vi, but I use nano. If your version of the FreePBX system has the java SSH package installed, you can get into the line prompts there, or use putty.exe or your choice of SSH software. Connect to your Asterisk box as root.

Change directories to /etc/postfix (cd /etc/postfix)

edit (nano

scroll down or search (^w) for INTERNET HOST AND DOMAIN NAMES (note: Linux is case sensitive)

remove the pound site (#) from the front of the line that starts with #myhostname (copy the line before removing the pound symbol in order to keep the defaults) and enter the hostname for your system. This should be a Fully Qualified Domain Name (FQDN), but it does not have to be valid. However, if you make it the same as your email host, email will never leave the Asterisk server because making these two match makes postfix think it is the mail server. So if your mail server is, then you could make myhostname

Look for #mydomain and set it to the actual mail domain, such as

Then look for relayhost

This will be the actual mail relay with the port number. This must match the settings we will create in the password file for authentication: i.e.

Lastly, add these lines

smtpd_sasl_auth_enable = yes
smtpd_sasl_path = smtpd
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd
smtp_sasl_type = cyrus
smtp_sasl_auth_enable = yes

smtp_sasl_security_options = noanonymous

Now we need to create the hash. Either create a new file or edit the file that's there: i.e. nano sasl_passwd (this assumes you are in the /etc/postfix directory). Then add your mail server and port just exactly as you entered it into then a space then your username and password in this format: username:password

an example would be:

Then save the file.

Make a hash file: postmap hash:sasl_passwd

Test your entry type:

postmap -q sasl_passwwd

This should return your email and password.

This will begin delivery of your voicemails, but the reply address will be in correct. Once these files have been setup, you center the reply address in the FreePBX GUI. 

Login to FreePBX, Select the Settings button and then Voicemail Admin. On the system View Links: select Settings. Near the bottom enter the email address that matches the domain your emailing from into the field serveremail.

Then you should be ready to go.



Written by Leonard Rogers on Tuesday, October 29, 2013 | Comments (3)

Outlook 2007 IMAP subfolder synchronization

Posted at 10:59:15 PM in Installations (48)

My previous post turned out to be more bogus that I thought. It is, at best, an interesting observation, but not the fix for folder synchronization. The problem for this issue was actually on Gmail and what Outlook 2007 expects for IMAP to work. Gmail is case sensitive and Outlook always submits the root folder in Caps by default. Actually this is also coming from an ignorant point of view. All I know is that it fixed it.

I read in several places that some program setup outlook with a bad root folder, instead of mixed case, INBOX is all upper case, but Gmail has inbox in mixed case, so after the default installation, Gmail has the folders InBox\test where Outlook has it INBOX\text and the two are not the same. I could not find anywhere in Outlook to correct this. Though I didn't test this extensively, but if I add a folder after Outlook is connected to Gmail, it seems that the folder is functional. I can delete that folder and copy emails into it, but if the folder is imported during the account setup, it will not work. Can't delete the folder and can't copy emails into it. The fact that I can't do it manually also means that the emails on the server won't copy into the correct folder either. Funny, after everything is setup and the inbox is loaded with email, when you try to connect to one of those folders Outlook doesn't complain at all. It only complains when you try to manipulate the folder claiming it doesn't exist.

This is the error I was getting when I tried to copy email into one of those folders created during setup "Cannot move the items. The serve responded: 'No Folder INBOX/folder (Failure)'." On investigating that issue, I discovered that Outlook 2007 uses all capital. Seeing as I didn't know where to fix this in Outlook, I did find that it can be changed on Gmail rather easily...

Sign into your Gmail account. Click on the gear and select Settings. On the settings page, there is a link at the top which says Labels. Don't mess with the system labels. I don't know if you can, but it's not necessary. Scroll down until you see a button that says Create New Labels. All the labels or folders under the inbox are shown there and they will probably all be in mixed case. There is a link at the right which says edit. Click that and change InBox to INBOX and leave the \label that is already there just like it is. 

There is no need to restart. As soon as the case is changed, Outlook will have access to the folder and all the emails in that folder will download.

Written by Leonard Rogers on Friday, September 27, 2013 | Comments (0)

Outlook 2007 IMAP subfolder synchronization (Fix Failed)

Posted at 8:18:44 PM in Installations (48)

Many of my customers want to use IMAP, even though they use Outlook (which doesn't do a very good job of handling that protocol). Several of them keep huge subfolders under the inbox, but they do not get synchronized even though the folder is subscribed. They will show me the folders on Gmail and then the empty folder in Outlook. The folder structure is there, but not the items.

I believe this wouldn't be a problem if the Outlook client was the main source of email distribution. In other words, if my clients used Outlook to put an email in a subfolder, then Outlook would see it and Gmail would see it, but if they moved the email in Gmail, then Outlook would do nothing.

I'm sure this works the same way in all version of Outlook, but the steps I explain here are for Outlook 2007.

In the send and receive settings found under Tools/Options then the Mail Setup tab under the button Send/Receive, you will find a button to Edit the Group Name for All Accounts. In the Receive mail items subsection, there are three radio button. The first two are default actions which don't offer much. I think the idea is Microsoft doesn't want to synchronize all the subfolders and you will see what I mean if you select "Use the custom behavior defined below"

For the Inbox and subfolders under it, there are not check boxes in any of the folders below inbox. For each box you can select to download headers or download complete emails. Selecting a top level folder does not automatically select the lower level folders, consequently, they don't get synchronized.

I selected headers for the subfolders in order to reduce overhead and time. If customer wants to see the actual email, it will download when they try to open it, but at least they can see the emails.

Written by Leonard Rogers on Friday, September 27, 2013 | Comments (0)

RTP300-VD firmware unlock

Posted at 5:08:31 PM in Installations (48)

Several RTP300-VD VoIP routers are showing up on eBay which are brand new in the box and still locked.

The firmware version I got was 1.00.37 and trying the simple ping hack did not work. The router never connected to my tftp server. After some research, I remembered I had to upgrade the firmware first and then the ping hack.

To upgrade the firmware requires access to another area of the router management web site which is also locked by a password that may or may not be known. A lot of web posts indicate the user is user and the password is tivonpw, but that didn't work for me. That's where cyt3xx comes in. Actually, I think it's cyt4xx.exe now, but the program has hard to find.

I have a copy of cyt39c.exe which works fine on this particular Linksys RTP300 router. The steps I used ...

connect laptop to LAN port on the router.

Run cyt39c  - it will automatically find the router. 

Press the key to reset the passwords. Let it run until it says it's finished. It will set the username and passwords for Admin and User.

Connect to the router at

login as admin / admin

change the router address to point to

login as user / user

Then you will have access to the update firmware dialog. Update to the Vonage firmware (updating the firmware from 1.00.37, which doesn't have wget or tftp capabilities, to a version that does will allow you to install a completely new firmware changing the device from a RTP300-VD to a RTP300-NA) The firmware I used is RTP300-NA - 3.1.24

Actually, I didn't have to do the PING hack this way.

Written by Leonard Rogers on Thursday, September 12, 2013 | Comments (0)

MSI g51 laptop WiFi and Webcam Stopped working

Posted at 3:33:37 PM in Installations (48)

Recently I had a MSI G51 laptop that lost it's WiFi signal. No switches on the side and no Alternate Fn keys that would turn the WiFi on. Even worse, I assumed the webcam was broken on it though I had just purchased it, so we never used the webcam.

There are 4 labels on the laptop up by the power button, which I never paid any attention too. They are positioned next to what appears to be indicators, but they are actually switches. The WiFi switch appears to be a radio antenna, but it's not what I'm use to seeing as a WiFi icon which look like this  or this . The one on the laptop doesn't match any I've seen. 

Well, as I was pressing around, I decided to check the the webcam switch and the camera turned on as well. The WiFi also turned on, so apparently, someone accidentally turned it off and didn't know it. I have yet to figure out what P1 and Eco are for.

Written by Leonard Rogers on Tuesday, June 18, 2013 | Comments (2)

Connecting Allworx 6x to FreePBX

Posted at 5:05:04 PM in Installations (48)

I have not had a chance to do any trunk to trunk PBX connecting before. A client wanted setup his Allworx 6x and had previously had it setup with POTS lines. He had ordered POTS lines to get the same config as he had in a previous office but that order didn't come through. I suggested we try getting him setup using SIP instead of the POTS lines.

I was unfamiliar with Allworx and tried to find a way to reconfigure the IP phones that came with the system, but quickly found out that wouldn't work. After researching a little about Allworx, I found their systems were SIP 2.0 capable and decided to forage ahead and set that up. It took 2 days. Hopefully this will help anyone needed to setup a similar configuration.

First off, I set this up to be a SIP to SIP trunk (Allworx to FreePBX). The FreePBX was the only source for public telephone access. This information will not address routing extensions between the two PBX systems. They needed 2 DIDs, 5 lines and those 2 DIDs needed to route through the FreePBX. SIP to SIP trunking described here routes calls from the outside to an inside PBX through a FreePBX system and vice versa. The FreePBX system doesn’t know anything about the extensions being used in the hosted PBX box. It would be possible to make the two systems aware of each other, but that would require renumbering the extensions.

The issues I had were:

  1. Creating a network connection
  2. Administer the Allworx PBX system remotely
  3. Establishing a SIP to SIP trunk
  4. Configuring outbound calls
  5. Routing inbound fax numbers to their analog port
  6. Ensuring their Caller ID worked on outbound calls.

Note: The Allworx Software Version is The installed features which may or may not have an impact on this setup are: Internet Call Access and Multi-site Branch.

I did not want to worry about port forwarding through a router, so I set up the Allworx 6x box to act as a router as shown in the attached picture.

 When I started, the Allworx system was set to LAN Host. That setting disables the WAN port and makes the appliance work on the network as a host separate from the internet. NAT/Firewall allowed me to access the appliance directly for admin and routing. The DHCP server on this box is a little flaky. I rebooted my router and effectively disconnected the Allworx box. It didn't bother trying to get another IP address until I could get to it and power cycle the unit.

Once the Allworx box  was connected, I needed remote administration. I tried connecting from the WAN side, but that didn't work. The Allworx appliance comes with one VPN PPTP connection. To enable the PPTP username and password, select an user account and at the bottom of the user account page is an option to enable that account to use PPTP and to enter a password. I used the admin account, I'm not sure if that was necessary or not. The password has to be 14 characters long and is separate from the actual user's password. Once a PPTP connection was established from the WAN side, I could connect to the admin console via the server address at port 8080. i.e. There is only a login password on that screen, no user name.

To connect the trunk, I used SIP Proxies under Home > Phone System > Outside Lines. I kept the Trunk name and username the same in my FreePBX trunk setup. The same name was then entered in the outside lines page in the Allworx box for the Description, User ID and Login ID. The address of the SIP server and port number should be pretty straight forward. The password in the SIP registration just needs to match the password in the PEER details on SIP server SIP Trunk setup.

The following link shows the information on the FreePBX box in the SIP Trunk setup... here:

There is nothing in the Incoming settings on FreePBX. As soon as I set this up, the Allworx connected and all I had to do was set up the inbound routes on FreePBX to this trunk and it worked. On the inbound screen, I modified Set Destination to Trunks and the picked the SIP truck that I created.

The problem with the outbound routes was the context. I used Friend Pairing as found on this site. The setup this provided was to allow extension calls to route down the trunks to the other PBX. And each PBX had its own outbound routes for all other calls. My problem was that the Allworx PBX had no route. It needed something that would allow SIP to SIP transfer, but there is nothing apparent in FreePBX to set that up. You will note at the top of the SIP Trunk setup, there is a warning that no outbound routes are using this trunk. However, when I changed the context in the example from the Friend Pairing site from from-trunk to from-internal, all the outbound calls automatically started routing.

I will get to the fax setup last. My outbound Caller ID was setup correctly on Allworx as can be seen in the link for Outside Lines. For some reason, FreePBX was dropping the Caller ID and replacing it with the trunk default Caller ID. I had tried several options, but the one I used that worked for me was to create a new outbound route using the Caller ID that was getting dropped to make the dial pattern unique and then put the dropped Caller ID in Route CID to override Caller ID on the trunk. Of course, this would be cumbersome if there was a large number of DIDs that needed to be routed.

To accomplish this task, I just duplicated the existing route and added the caller ID that was coming from Allworx. The pattern matched and the new Route CID replaced the trunk default CID.


The Fax problem was all in Allworx. There are 2 ports available on the Allworx 6x (port 7 and port 8) for analog lines. My outside lines configuration had the DID for regular calls and for the FAX calls to come in on separate Routing plans, but I could not find where to associate the physical port with the number.

To fix this, I added a new extension. In the attached picture, you will see the First connection attempt section of Call route. Click add a destination. When I used the pull down, I didn't notice that the slider bar was at the bottom, obscuring the other ports at the top. I was looking for port 07 and port 08, but couldn't find it at first. I scrolled up. They are both at the top of the list. Once I had an extension, I could go back to the routing plan and add the inbound route to the extension and in and outbound faxing started working.


Written by Leonard Rogers on Thursday, March 28, 2013 | Comments (0)

Connecting Copfilter's SpamAssassin to Gmail's IMAP folders for Bayes Scoring

Posted at 2:06:51 PM in Installations (48)

 I had an issue connecting my copfilter to gmail's folders in an effort to setup bayes scoring. Initially, the problem was with the need for a secure connection. Previous to V2, we could not use SSL. After upgrading to V2, I was still having issues connecting.

I was able to connect with these settings:


  • IMAP server:
  • Require SSL: Yes
  • User name: your Gmail account name
    • The account name is what precedes "" in your Gmail address. If your Gmail address is "", for example, the corresponding account name is "nospam".
  • Password: your Gmail password (no special characters in the password - there's still a problem with that)

Here is a screen shot including the folder names which are called labels in Gmail. These folders are top level labels.


Written by Leonard Rogers on Tuesday, March 19, 2013 | Comments (4)

AVG 2013 Free Edition Freezes PC

Posted at 11:31:29 AM in Installations (48)

Just an observation. I believe I saw this in the paid edition also, but when AVG updates, the entire PC seems to freeze. This is just a download and patch to their databases. I cannot imagine what it is that it's doing that would cause such a problem, except that the program is not sharing the CPU which is just plain bad programming.

Written by Leonard Rogers on Wednesday, February 13, 2013 | Comments (0)

HP Officejet Pro 8500 910A Server 2003 install FAIL

Posted at 9:48:18 PM in Installations (48)

One of the great frustrations of IT is chasing one's tail around and around in circles. Nothing drives me up a wall more that starting a simple job and then because of poor support from the vendor, I have to try every machination to try and get something done. Such is the case with the HP Officejet Pro 8500 910A install. It was just a simple network install. Nothing to it, right?

Well, the problem is, if you pick the server 2003 driver for this printer, it isn't the right driver. Well, it is, but the executable won't let you install it. I get a pop up after downloading the 45Meg file and running the install, it says computer does not meet the following system requirement(s). Hogwash! I just selected the OS I wanted the driver for, but noooo. HP had to give you a driver that doesn't work for Server 2003. You have to install it for XP, Vista or Windows 7, but not server 2003. I tried downloading the driver for server 2008 WS32, but it's the same driver. I'd bet that it won't install on that server either (if there is such a server).

Finally, I just created a port for the IP address that printer is on and then located the driver inf in the temp location where previous failed attempts stored the file with the "have disk" button and installed the driver that way. The system took it. But it's retarded that a job that should only take 15 minutes took over an hour.

Written by Leonard Rogers on Saturday, September 15, 2012 | Comments (0)

Clamwin Anti-virus Review

Posted at 10:43:11 AM in Installations (48)


This Anti-Virus has a very small foot print. From what I can tell, it has no real-time protection from virus' that might find their way onto your computer through the network or through web browsing. Certainly, it doesn't work for files that you download and install through your web browser. There is an option when you install it that has plug-ins for Internet Explorer and Outlook. I've seen it stop virus' in outlook, but it didn't stop it from coming, the pop up alert and virus prevention was from an email that the person had already downloaded via email and was attempting to forward it to me for examination because it looked suspicious. Installing this anti-virus requires a lot of work for admins. I installed it to run every day and notify me of virus' via email. That works fine, but there are so many false positives that I don't trust it to clean the virus, so I have to review the messages (which now come in from all of my PCs) and determine if the threat is real. Even when submitting a false positive, they free support team doesn't always remove or repair the issue. I am still getting false positive alerts from a chrome.dll that indicated the virus, but has since been replaced by a newer version from chrome, but now the alerts are coming from the very same file that's stored in system restore.

There are several add-ons to this software by other well-meaning public domain who attempt to close the gaps in Clamwin. One of these gaps is that Clamwin is not recognized by Windows. This isn't really an issue, but becomes one when the antivirus is out of date. No alert from windows lets the user know there is an issue. You do get a pop-up from Clamwin itself. All updates to this software requires manual installation and sometime a reboot. Most of my users won't do any updates because they don't know what to trust.

On the plus side, it's free, it has a small memory foot print, it rarely interferes with the normal course of business (this later item is the reason I wanted to try it),

I had a client installation that was sending me emails on a virus it found it the FixTDSS quarantine everyday. Really annoying, right? Problem was there was a rootkit, a javascript virus in the Google chrome path and a virus in the Adobe downloader that never got reported. The adobe downloader virus took forever to find, AVG couldn't find it either and the ESET online virus scanner couldn't find it. To really drill down the Clamwin team is going to need to have the signature transmitted to them automatically just like all the other free scanners do, so they can investigate the reported problems and better identify the false positives.

Written by Leonard Rogers on Saturday, July 14, 2012 | Comments (0)

AsteriskNOW Install - 10 Second disconnect extension to extension

Posted at 11:22:14 PM in Installations (48)

I discovered more important information on the proper network setup. I was getting disconnected on calls to voice mail, attempting to record greetings, echo test or just calling another extension. I believed it was caused by one of the upgrades to FreePBX or Asterisk addons. I ended up installing AsteriskNOW 3 times before I found the problem.

1. VERBOSE settings in CLI will not give the error. I also discovered that the extra v's you see after the -r sets the level of verbosity. The default is level 3. By typing asterisk -rvvvvv you will see a message on the CLI screen that indicates the old verbosity and the new level which I believe the above would give level 4. But again, it doesn't show the problem in CLI. 

What I saw was "Spawn extension (from-internal, *43, 4) exited non-zero on 'SIP/1014-00000000" and then the steps to hang up the call. These fired about 10 seconds after the call was started.

I finally ran tail -f /var/log/asterisk/full which added two lines just before this spawn from hell.


[Feb 12 00:30:29] WARNING[4357] chan_sip.c: Maximum retries exceeded on transmission 50ac34bf-32b2571f@ for seqno 102 (Critical Response) -- See doc/sip-retransmit.txt

[Feb 12 00:30:29] WARNING[4357] chan_sip.c: Hanging up call 50ac34bf-32b2571f@ - no reply to our critical packet (see doc/sip-retransmit.txt).

I did a Google search on chan_sip Maximum retries exceeded on transmission and found the solution. ( This guy actually had to come back an answer his own question after much searching. His solution was to edit the sip.conf file which I had already explained in a separate entry that FreePBX maintain that file so we can't put anything in it if we don't want it to be overwritten. So I had to find how to do it in FreePBX.

In order to get to the SIP settings in FreePBX, the Asterisk SIP settings Module needs to be installed from the Module menu.

Then you should have a screen like this: 


What I didn't realize was the need to include all of the subnets that my phones have to pass through. I also mentioned before that the outside address is Nat'd through a IPCOP firewall, and that's the local network address I originally used. However, my office is on the GREEN network which has a different subnet and I'm also behind a router. Each subnet needed to be added by clicking the Add Local Network Field. Once it was submitted at applied, the disconnects on my calls ceased!



Written by Leonard Rogers on Saturday, February 11, 2012 | Comments (0)

AsteriskNOW Install - Network

Posted at 8:45:34 PM in Installations (48)

One thing to note. Changes to the OS don't take effect immediately. I'm sure there is a command to run that will install the changes, but I'm not a Linux guru. Namely, the IP address assigned to the network card. It doesn't register until after a reboot. 

When I first setup my AsteriskNOW PBX server, I used an internal network address. However, when it came time to install the SIP trunks, that setup proved to be impossible to work with. My router is behind several routers, so port forwarding was out of the question. I ended up moving my AsteriskNOW server to a position behind one firewall (IPCOP - orange network) and port forwarding UDP 5060 and UDP's 10000 - 20000 to the IP address of the AsteriskNOW server. Installing the SIP truck still has an issue if the outbound IP address is different than the public IP address assigned. As with most routers that allow you to put multiple public IP addresses on the WAN port, the inbound and port forwarded packets will reach the correct server, but all transmitted packets will have the IP address of the router which can differ from the extra one assigned.

I used a post routing command on the firewall in the IPCOP machine to masquerade the correct IP address if it was coming from that server. The only problem I had then was in passing the firewall test. I found that by changing the ports for RTP, in /etc/asterisk/rtp.conf, from rtpstart=10000, to rtpstart=10001. I was able to pass the test. During the first days of trail and error, I read that the ports to forward were 10001-20000. I don't know why those ports were listed that way as it should be 10000-20000, but since I set my firewall to start with 10001, the firewall test failed until I changed rtpstart.

On a plus side, you can get these settings to register by restarting asterisk...

amportal restart

Written by Leonard Rogers on Saturday, February 11, 2012 | Comments (0)

Joomla 2.5.1 Still no PostgreSQL option available

Posted at 11:26:37 AM in Installations (48)

 I've been checking the Joomla multi database support ever since an article came out in Jan 2012. This is one example:,-search-support

So, I went to the Joomla web site and installed it on my PHP server with PostgreSQL extensions installed. I checked all the requirements and pgsql and pdo_pgsql show as registered in php_info(). But PostgreSQL does not show as an option for database install. I posted request specifically to this issue on their forum but got no replies (except for my own replies where I posted additional information). 

This page (!topic/joomlabugsquad/4RLnsIvDCVY) indicated that 2.5.1 was coming out soon to fix many problems. There was no specific mention of PostgreSQL, but the non-tracker specific mention of database updates led me to believe that maybe the promised support would be there.  It is not. So I posted again but I doubt I will get any replies.

Written by Leonard Rogers on Friday, February 3, 2012 | Comments (2)

AsteriskNOW Install

Posted at 6:29:02 PM in Installations (48)

Just recently installed AsteriskNOW 1.7.1 32-bit ISO Image This is my first installation and was done as a test while I'm investigating options for a client request. I should keep better notes, but my style of investigation leaves little for education for others. However, I will try to document what I've found so far.

I originally found Asterisk on while looking for telephony solutions. When I downloaded the ISO image, I had no idea I was also getting FreePBX with it.

The system is not ready out of the box. Several preliminary steps need to be taken. It's not even ready to run test local phone extensions. Apparently an upgrade is needed, plus; you may find your spending hours trying to figure out why the phone extension won't register. I thought a firewall was blocking port 5060, but discovered after a lot of work that Asterisk doesn't start listening on port 5060 until an extension is installed and you have rebooted or restarted with amportal restart (which is run at the root prompt, not inside the Asterisk OS). 

After the initial installation, the login screen says to connect to the server at the IP address, which brings FreePBX. The instructions on the web site, state to edit sip.conf and extension.conf. But when you open those files, there is a message at the top that says don't edit these files, FreePBX will edit the files.

I'm releasing this now because of the on going FreePBX setup. Needless to say, I found numerous mis directions during the setup. My guess is the person was writing the manual setup procedures while someone else was writing the FreePBX interface updates.

The other thing I discovered is the need for license purchases. The fax module won't work until you install the license. Even after you install the license, you get an error message that indicates that other items need to be installed in order to get it to work. The first license can be free if you want, but you can't be moving it all around. I decided not to install it on my first junk server because I was running into problems along the way and thought I might have to re-install and that'd really mess things up. 

I started running in to a problem where I could get inbound calls, but I couldn't call even the echo test on the server without getting disconnected. I'd listen to 10 seconds of recording and then it'd cut me off. No SIP or firewall involved. I searched every answer I could find on it. It seemed as though everyone who reported a problem on disconnects was for outgoing calls. A few had problems with connecting to the server, but it was obvious it was the device they were connecting with. I decided to ignore the issue and wait for my new server.

Well, the new server arrived. I was quickly installed (due to all the trial and error learning). And also quickly back at the same problem with the disconnect. Unfortunately, I bought a codec g729 and I installed the Free Fax for Asterisk. Then, in an effort to fix the problem, I kept upgrading FreePBX. I got it up to version 1.9 and still had the disconnect problem. Then on the way to FreePBX 2.10, I discovered that Asterisk 1.8 needed to be installed. It seemed odd to me to be pulling the core function out from under the Web page, then install a new core function and the web page would know it had the right version. I had to lookup how to do it and of course, it didn't work. I got error all along the way. I still ran the 2.10 upgrade even though Asterisk would start. That only destroyed the web interface. 

So, now I'm reinstalling everything from scratch again. Great. Gotta love GNU stuff.

Written by Leonard Rogers on Thursday, February 2, 2012 | Comments (0)

RDP printing from Windows XP and Microsoft 2008 R2 servers

Posted at 3:14:39 PM in Installations (48)

Easy Print RDP printing

Well, it's suppose to be easy. On my Windows XP clients, the printers were all showing up on the server as remote printers with the session ID attached to the end just like they were suppose to, but nothing would print. Nothing showed up in the print queue. Print jobs just vaporized. After much research, I discovered this happens when you install the Remote Desktop Host Role on the Domain Controller. Microsoft recommends against it. They suggest you install RDP Host on a separate server and most companies I see this done, will use Hyper-V services and install the DC and the RDP host servers on the same box, but as virtual servers. I'm not sure if there is a licensing issue with this and I prefer not to play around with it. I don't like virtual servers anyway as problems with one server DO affect the other virtual servers on the same machine. So, one server, multiple roles... What do we do?

One of the frequent indicators is a system log message indicating that a print job was rejected with an error stating access was denied. This apparently is on the print spool folder. Microsoft suggested using Cacls.exe, but that program is deprecated in Server 2008 R2 and it's replacement Icacls.exe didn't work. Apparently a method that does work is to modify the security rights with Windows Explorer and grant the user group Everyone full access (instead of just the change rights suggested by Microsoft).

I found one site that had this suggestion, but one contributor suggested this has it's problems and recommended changing the print spool directory and granting access rights to that directory on the domain controller. This is the option I chose and it worked. I haven't been able to find the contributor's web page and if I find it, I'll post it here. But these are the procedures I followed:

On the domain controller:

  1. Create a folder on the root of the drive.
  2. Grant Authenticated Users modify rights to that folder.
  3. Open the Printers and Devices control and highlight a printer (any printer. This shows additional options on the options bar at the top of the window).
  4. Select Print Server Properties.
  5. Select Advanced tab.
  6. Enter the folder name  you created on the root of the drive (there is no browse button).
  7. Click okay. This will pop up a window indicating that the changes will take affect immediately and to ensure no jobs are printing. No reboot is required.

The minimum requirements for Windows XP to properly use Easy Print are Service Pack 3, .Net 3.0 (I assume or above) and RDP 6.1. My machines have SP3 and .net 3.5 sp1 and the correct RDP (found here). I thought it a bit odd that the download states version RDP 7.0, but there's no where to identify that version in the client software. I right clicked on the short cut in order to find the mstsc.exe file that is the executable for RDP. Selected find target. Right-clicked on mstsc.exe and selected properties. Then looked in the program version info. It says the product version is 6.1.7600.16385. Which meets the requirements of Easy Print, but I don't know where the 7.0 is suppose to show up. I also noticed that the remote printers sometimes take a bit of time to start populating the printers and devices on the RD server. If they aren't there right away, check back in a few minutes and they should show.

Tags: Remote Desktop Printing, Easy Print RDP printing, DC and Remote Desktop Host Role on same Server

Site research articles:

Note: In the above article, they say to use Cacls.exe, but in Microsoft Server 2008 R2, if you run that command an error message comes up that states Cacls.exe is depreciated and to use iCacls.exe. However, the command line arguments are not valid for iCacls.exe. They should translate to icacls.exe PRINTER /grant users:M. The /e was to keep the existing creditials, which is not needed. If you want to replace the current creditials you would at an :r to the /grant portion. It would appear as /grant :r users:M (see here for complete explanation of options). The previous C was to allow grant the user the change rights. That would not be M for modify rights. However, when I ran this, it did not work. Apparently, if you are on a domain controller, there are certain file protections installed that prevent granting user rights to this folder.

Written by Leonard Rogers on Thursday, January 12, 2012 | Comments (1)

Adding Win XP printer share to Win 7 64 Bit OS

Posted at 5:33:31 PM in Installations (48)

 Excellent information on how to do this on this page

Copied here.

I found the answer here:-

This post says:-

The 32bit driver name is different than the 64bit driver name.  You will need to create a Local Port which will basically copy the print formated data to the xpmachine share.

Here's the KB how to perform this task

on Windows 7
Add Printer
Local Printer
Add Local Port
XPMACHINEprintersharename    (Make the share name one word or you have to "" quote the whole thing)

Select the driver installed when you connected the device to USB

complete the wizard

print test page.

Other items that I had to look up was getting an error when trying: cannot connect to printer 0x00004005


Written by Leonard Rogers on Wednesday, November 30, 2011 | Comments (0)

Peachtree freezes on pop-up message for end-of-year wizard

Posted at 3:58:53 PM in Installations (48)

Peachtree Quantum 2012 freezes when Peachtree starts when the user gets a message that the end of the year is approaching requesting if the user would like to run the end-of-year accounting audit wizard.

The PC was Windows XP SP3. The problem was the PC did not have IE 8 (Internet Explorer 8) installed. I twas still using IE 6. Another message also popped up indicating that the screens could not be displayed properly because the version of Internet Explorer needed to be upgraded. However, because the user could get past this screen and continue working, they never bothered to mention that problem. When I corrected the version of Internet  Explorer, the freezing problem went away.

Written by Leonard Rogers on Thursday, November 17, 2011 | Comments (0)

Clam Antivirus and Clam Sentinel

Posted at 4:47:55 PM in Installations (48)

I'm a recent convert to Clam AV. Mostly because it has a small resource usage foot print and the design focuses on virus checking. I used AVG before, but in 2011's version, the software hogged up so much memory and resources that programs were really running slow. Then on the upgrade to 2012, I ran into a lot of problems with programs and network devices hanging up. Outlook wouldn't retrieve email. The PC that had the AVG network admin software installed on it started losing it's network connection after the AVG client was installed. But the main reason I removed it was because it was taking up to 250Meg of RAM which would tax some old systems to the point that they no longer functioned well.

When I downloaded Clam AV, I saw an internet ad for Clam Sentinel which uses the Clam AV database. In fact, they say you have to have Clam AV installed for it work. Clam AV in it's default config, only scans email and office documents through a plug-in option and checks for and downloads virus definition updates. You have to manually configure Clam AV to scan your hard drives or it will never scan. I didn't feel comfortable with that and thought Clam Sentinel would be a nice add on, however; it's configurable options are extremely lacking. There are a lot of options to select  what not to scan, but none on when to scan. I found the Clam Sentinel scanning quite frequently, I'm assuming on access. But it also scan's at least once a day... that is according to the log files it creates. I get the impression that it's scanning the entire hard drive several times a day, but I can't be sure because I can't tell when or what it's scanning. I assumed the entire harddrive. It bothers me that I can't schedule that. It's also redundant because I can schedule Clam AV to scan the hard drives. With Sentinel doing it automatically, creates a problem if I schedule a scan in Clam AV.

Clam Sentinel apparently is very aggressive locking files for testing. Clam Sentinel locked up the tmp files that Outlook makes when it's synchronizing the a public Exchange server causing Outlook to hang which is almost the same problem I had with AVG. It also interfered with online game play eating up so much resource that graphics would be "glitchy" or sluggish. Sentinel had to go.

I currently have Clam AV scanning once a week and only reporting the findings, not actually removing them. I set up the email alerts so I don't need to go to each PC and check the reports.

Written by Leonard Rogers on Thursday, October 27, 2011 | Comments (6)

Acronis server image on Dell T310

Posted at 12:48:29 PM in Installations (48)

I just recently bought 2 T310 servers from Dell. Nice servers with fast SATA drives. I wanted to make a backup image of the server in case I screwed something up during the install, however; Acronis couldn't see the SATA drive. I checked for updates and applied them, but still not luck. This I found this post on from back in 2008 that still works today! Check out the post at

Use safe mode and you can see the SATA drive. I kept using the Full version because the software claimed that the safe mode doesn't support USB or SATA, but in fact it does. It supports both.  I'm not sure what the difference is, but it worked. 

Written by Leonard Rogers on Monday, October 24, 2011 | Comments (0)

Wordpress with PostreSQL

Posted at 11:36:14 AM in Installations (48)

I noticed a few things after my installation of Wordpress with PostgreSQL as the data backend. I used pg4wp, found on this site. I downloaded the latest version 1.2.2 but got errors during the installation, but Wordpress indicated it had installed successfully, so I didn't worry about it too much. Then as I was trying to add categories, the new categories wouldn't show up. I had enabled PG4WP_DEBUG and reviewed the log files. 

The first problem was a duplicate key which violated the unique constraint on the table ??_terms. (?? is modified to whatever you set your name prefix to in the wp-config.php file.) The first thing I noticed is that the table is used to terms from different areas of Wordpress. It holds the category of posts and well as the category of links. This table is initially populated with uncategorized and Blogroll. Apparently during installation, the sequence tracker stopped at 2 and the number being assigned is the number currently held by the tracker. So a new record wanted to be id number 2 but 2 was already in the table. To fix this, I just went into the sequence tracker (??_terms_seq) and set the next number to assign to 3 and the problem was solved.

I only recently started working with users. I thought it was odd that the user counts would work, but I could see the actual user records. The page always had the message "No matching users were found!". Even after I added users, it gave me the same message. Oddly enough, there are two meta tables associated with the users table and apparently, the counts come from ??_users, but the actual display comes from one of the meta tables. Again, I looked in the error log. This message was the cause:

SELECT DISTINCT(wp_users."ID" ) FROM wp_users WHERE 1=1 ORDER BY user_login LI$
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

This is apparently a common problem in the pg4wp, but isn't addressed on their web site. I found a solution here. I just installed it and I can now see the users. I haven't fully tested it yet. I tried to add the line he said would fix the problem, but it broke the home page. I downloaded his driver_pgsql.php and installed it in place of the one provided by pg4wp and was able to get to the users. The install of course changed the ownership and file rights which I had to manually change after uploading the file.

Two changes:

chown www-data:root driver-pgsql.php 

chmod 777 driver-pgsql.php

This is my second site on the same server. I found that sub domains and/or sub-folders is not what I needed. Networks or WordpressMU (multi site) wasn't the answer.

Written by Leonard Rogers on Monday, October 24, 2011 | Comments (0)

Setting up Wordpress on Ubuntu

Posted at 3:01:02 PM in Installations (48)

Extremely frustrating.

Wordpress boasts an easy install. However, I find that after a week of work, I still don't have a fully functioning Wordpress site.

My installation started from scratch. I'm mostly an IIS asp classic type designer and... I'm mostly backend. My artistic flair leaves a lot to be desired. The desire to get Wordpress installed came from a client who was trying to compete with Godaddy's offering. He designs web sites, but they are still bland in comparison to todays "flash"y colorful and functional web sites. I could see right away that the site hosted by Godaddy was a Wordpress site with most of it's emphasis on content and not blogging. The visual appeal of the new site was like going from black and white TV to HD TV. The new site was beautiful. So, how to compete.

I could see it was finally time for me to start thinking PHP. I already use Linux systems, but only for firewall, backups and name services. I never checked out the Apache server because they couldn't support asp classic and certainly not ASP.NET. And I really dislike (actually, that's too kind, I hate) MySQL. The interface for admin for MySQL doesn't exist. I understand there is a phpAdmin which administers MySQL, but that requires... uhmmm... PHP. Since I was looking into setting up a LAMPS (Linux, MySQL and PHP) server, I looked at my current server which is CentOS being hosted at my server farm. It's old. It wouldn't support any of the required versions of PHP, Apache or MySQL. Looking into upgrading was a scary option and replacing the server would drive the price up. The only viable option was to look at Ubuntu which is a virtual server offering from my server farm provider.

Just a word about searching out options. I checked out a lot of cloud offerings. It seems that current trend is to provide server space by the hour, including an estimated about of bandwidth. If you need more memory or hard drive space, then the price per hour goes up. I found the base amount which would provide you a server that wouldn't work was very expensive. Usually the entry rate was about $50 to $60 per month. I know that's not a lot, but remember, that config would not provide a usable server. I have a server already set up on a cloud which costs me about $95.00 per month running on Microsoft Server 2008 Enterprise with 1 CPU, 60Gig hard Drive space and 3Gig of Ram and 50,000 Gig of data transfer per month. That's a good price. I found on the Microsoft servers setup as a virtual server, there is no such thing as cache memory. When your programs run out of RAM, it doesn't swap the the hard drive. It crashes the server.

All of the providers that I checked doubled that price on their hourly rate and did not provide even a tenth of the bandwidth. I currently pay 49.95 a month for a dedicated Linux server, the upgrade to a new server from the same provider is now 89.95 a month. Since Ubuntu is offered on their virtual server platform, I could configure a Linux Ubuntu for 39.95 and probably get most of what I need. Thus the need to experiment with Ubuntu.

I set up my own server since I didn't want to pay for someone else to host Ubuntu and then find other things taking me away from that work and being left to pay for a server that I'm not using. The installation of Ubuntu went rather well. They recommend a 64bit install, but I only have 32bit machines to test on. I selected the LAMPS and tomcat service items during the installation. That meant that my PHP, MySQL and Apache would all get installed. No problem there except I don't want to use MySQL. Luckily, there is a Wordpress drop-in that allows you to use Postgresql, which I installed... the drop-in. Postgresql is already installed on a separate server.

When I first tried to install Wordpress, I went to the Wordpress site and downloaded their copy. I did their 5 minute install, which has very simple steps, but found I could not get the install to work. That may have been because the root account is locked and everything in Ubuntu has to be done from sudo commands. I finally broke that lock, but the installation simply would not go. Then I found that Wordpress can be installed with apt-get. That, however; installs a debian styled version of Wordpress which has the theory that uploads from the web site are bad and therefore put everything in locked out directories.

In order to get Wordpress to be somewhat functional, I had to chmod -R 777 wp-content. Everyone says that's bad and I suppose it can be, but I don't think a dynamic web site should installed in locked directory. It may go against the debian mind set, but really... how can you have a dynamic web site and not allow uploads. It's an oxymoron.

Ubuntu or debian seems to have created another problem which took me several days to figure out. There are a lot of posts on the internet about errors when inserting a picture into a post in Wordpress. Most of the solutions was simply getting rid of all the capitalization in the url name. Another was that some plug-in was causing the problem. And, after a lot of research, it is even possible that the theme could be a cause of the problem. Wordpress uses a lot of jquery and specifically, they use thickbox which is part of jquery, so potentially, if someone created a theme or a plug-in that also included with it a version of thickbox, that could cause a problem. However, my issue didn't have any plug-ins and I was using the default theme. All of my URLs were consistent and lower case letters, so none of those could be the problem.

I did fix the problem and I have a running Wordpress site on Ubuntu. I will address the insert picture problem in a separate post. My next goal for Wordpress is to install a second site on the same box.

Written by Leonard Rogers on Saturday, October 22, 2011 | Comments (0)

Win 7 login issues to Windows 2000 workgroup share

Posted at 1:13:30 PM in Installations (48)

Windows 7 is here and we have to learn how to connect it to old legacy systems. I have several old MS 2000 servers running in workgroup mode and need to connect the Windows 7 machine to those PCs.

In order to find the server, I had to go into advance settings in the Network and Sharing Center panel (found on the control panel) and change the settings to allow shares. These are the settings

  • Turn on network discovery
  • Turn on file and printer sharing
  • Turn off Public folder sharing (may need to be turned on if you want to share the folders on the windows 7 PC)
  • Media streaming - didn't touch
  • File sharing connections - didn't touch - set  to 128-bit encryption
  • Turn on password protected sharing
  • Allow windows to manage homegroup connections

This allowed me to find the name of the server in the windows explorer, but still couldn't connect. A system window pops up and asks for a username and password. The domain always defaults to the name of the computer windows 7 is installed on. Using domain/user name will change the domain name, but that didn't help either.

The solution that worked for the connection and I didn't have to reboot for it to work was to go to control panel / Administrative Tools / Local Security Policy / local Policies / Security Options  and find Network security: LAN manager authentication level. It is set to "Not defined" by default which I believes means that Windows 7 will use it's new authentication level of NTLMv2. Edit this and set it to "Send LM & NTLM - use NTLMv2 when negotiated." Click the share and presto, you're in without the system window.

Written by Leonard Rogers on Wednesday, August 17, 2011 | Comments (0)

Windows 7 Printer install error 0x0000001c

Posted at 6:46:26 PM in Installations (48)

I just finished a windows 7 printer installation and at first got an error 0x0000001c. I wasn't able to find any good information. I did find an error wiki site, but after reviewing it, it appears to only be a gimmick to sell an error checker.

In any case, I had downloaded the driver for another windows 7 PC and had no problems installing it. My printer is a networked Sharp copier/printer MX-M503N. The problem I found was that I was installing a 64bit driver on a 32bit PC. Once I attempted this install, Windows 7 remembered the attempt to install to that port address and every subsequent attempt bypassed the opportunity to pick the correct driver. I was able to over come this problem by selecting print server properties, selecting the ports tab and removing the port identified by the IP address I was installing the printer too. I also found that every attempt to install the printer created a new port entry with and underscore followed by a number incremented for each attempt.

Once I removed the old ports, I was able to install the printer with the correct 32 bit driver without errors.

One final note on this model of printer and the installation process. Windows update did not have the driver required for this printer. I had to find it on the manufacturer's web site. It listed the Windows 7 driver, but when extracted, the program name indicates the driver is for a Winxp/Vista/server2003. I'm can't remember if I was able to install the drivers using "have disk" and selecting the location. I used the setup.exe in the root folder to install the drivers for this printer. Sharp creates their own named port, but those ports don't look any different that the generic port that you can create from the windows driver itself. 

Written by Leonard Rogers on Tuesday, August 9, 2011 | Comments (0)

Outlook, IMAP and Gmail google

Posted at 10:33:51 PM in Installations (48)

I had a problem today where Outlook 2007 kept giving an access error for a gmail account on both the SMTP and IMAP connections.  The error message always popped up requesting the password be entered again and a message indicating that the user should login to their gmail web interface. Calling the company that setup the account didn't do any good. They could see no problems and said they didn't change anything. We didn't get a chance to call Google about the issue.

The user was able to login to the web account, and we check the settings to ensure that IMAP was set up properly. We changed the password anyway because we thought the password strength wasn't strong enough as indicated might be the problem on the Google trouble page.  That didn't do anything to fix the problem. The the user connected using a different computer and had no problems. This ruled out the internet connection, gmail and her account settings.

Microsoft's implementation of IMAP in Outlook is sad at best. The plus side is that deleting the account and reinstalling it won't hurt anything because the email is managed at the server. After rebooting, turning off the firewall and other useless activities, I uninstalled the account and re-installed it again. Apparently some configuration setting associated with the account was corrupt and setting up the account again fixed it. 

Written by Leonard Rogers on Monday, August 1, 2011 | Comments (0)

Microsoft Office 2010 Beta and the Q drive

Posted at 10:32:37 PM in Installations (48)

I just found out that Microsoft office 2010 Beta takes over the Q drive. It doesn't matter that it's already mapped to a network drive. Once the software is installed, the local assignment takes over that drive letter and suddenly all applications that depended on the Q drive network map will no longer function. This is similar to Microsoft taking over the M drive for Microsoft Mail. That didn't go over too well either.

I personally like to assign the Q drive to my quickbooks applications. When one laptop installed Office 2010, I had troubles getting the only machine in the office setup to access the Q drive differently. I took a stab in the dark and did a google search for Q drive issues and found the problem. Hopefully this will help others. I found one procedure that made the Q drive disappear, but it still didn't show up in the network mappable drives.

The Q drive is suppose to be used for online updates. I believe they call it, click and go and acts as a virtual hard drive to Microsoft servers to update Office components.

Written by Leonard Rogers on Tuesday, July 19, 2011 | Comments (0)

Office Move

Posted at 6:52:55 AM in Installations (48)

Well, the move is almost complete. The move consisted of 38 phone stations and 45 network devices. Of those devices 8 were servers and I also moved the mail server. Argosoft was finally not meeting up the the standards I needed so I upgraded to hmailserver. I am having one problem with that. It seems the POP accounts are getting locked by iPhones accessing the same mail accounts as Mac Operating systems. One of those devices checks every minute and ignores the request to check less often.

The biggest problem was moving the phones. We were not able to get the PRI in before our move in date so we had to get a temporary solution and get 12 POTS lines in hunt.  However, the main line only has one top path consequently only one call makes it to our switchboard, everyone else gets busy signals. The phone vendor is Telepacific. They have been less than helpful through the entire move. Part of our issue with them is an outstanding T1 circuit which was never connected, but they had been billing us for it even though we told them not to install it. In a company of this size, the IT department doesn't review the bills. It wasn't until a review that the extra circuit was discovered. After pointing out the issue, our relationship with them deteriorated pretty quick. At first they refused to call forward the PRI lines to the new numbers until 2 weeks after out move in date. Part of that problem was that they kept rejecting the Controller's signature as an authorized agent to make such a move. Now that we have the calls forwarded, they used 2 wrong numbers of the 4 we wanted forwarded and I can't seem to get the person taking the order to understand what a top path is. When I talk to the repair department, they have no problem understanding what I want, but won't do it unless the order is submitted via the order department.

I have a 10:00am meeting today to see about just dropping the call forwarding altogether as a fix, but this won't help because our customers will continue calling the old number for quite sometime. It's been 3 days that I've been trying to get these top paths taken care of.

Written by Leonard Rogers on Friday, July 8, 2011 | Comments (0)

Peachtree Registration Page

Posted at 12:12:39 PM in Installations (48)

Peachtree has changed it's registration page. It use to be and this link shows on installation software up through Peachtree 2011.  When I tried to re-register my older version of Peachtree I also found that my customer number no longer worked. Sage software is going through some consolidation and all the old customer numbers have now been replaced with 10 digit customer numbers. In any case, the right location to register your Peachtree products is:

Written by Leonard Rogers on Wednesday, June 22, 2011 | Comments (0)

Cannot connect to NumberCruncher

Posted at 5:56:14 PM in Installations (48)
We connect to a Remote Desktop (RDP) to use NumberCruncher (NC) and Quickbooks (QB).  In order to use NumberCruncher the way we have it set up, requires that QB be open. Even with this is done, sometimes you have to find the NC data connector description file and then find the QBW file via a wizard inside NC. The RDP connections worked fine, but QB and NC were being opened for the very first time and required some setup. QB gave numerous welcome screens and those had to be addressed before NC would connect to QB's data file.
There was a couple of problems.
1) The license was not activated on NumberCruncher. That is resolved now.
2) If any dialog shows up in QB, NC will not connect. The error message will state that you have to close the dialog and finish connecting to QB.
3) There was no xxxx1 or xxxx2 user in NumberCruncher. There was only yyyy1 and yyyy2. We added xxxx1 and xxxx2 with the same rights as yyyy1 and yyyy2. We attempted to login 3 times and it locked us out. NC doesn't say the login was invalid, it just sits there and lets to click the button 3 times and then says you failed. 
4) Connecting the NC to the QB file is odd. It shows you directory information for directories that you are not connected to. For future information, the top of the dialog will say to find the QBW file for your company. It will start in the NC data directory. In order to find the QBW file, you need to click into the QBData directory then Click back to the Root directory and then the QBW file will show. (Note: this would probably not be an issue if the QBW file is in the same directory as NC's NCD and the SQL files. It is my preference to put the data in separate directories).

Written by Leonard Rogers on Thursday, June 16, 2011 | Comments (0)

Validity Sensors DDK

Posted at 7:49:47 PM in Installations (48)

Just got a new Dell Vostro 3550 Laptop which comes with pre-installed software and "new-age" gadgets.  Validity Sensors DDK is one of those programs and appears to be part of the computers finger print security which the name seems to imply.

The name of the company that supposedly produces this product is Software Informer, Inc. But a visit to their web site gives absolutely no information (see  They claim 4903 people use the product which makes me wonder how they got that info. Does the driver access the internet site and provide info hence the name software informer??? The write up states that a review will be coming soon from their "informers" which appears to mean the user community, but why would the company that produced the software rely on their users to write a review? Shouldn't the company describe the software and then let the users write reviews on the description? How are the users going to write a review on a gadet that that they don't even know what it is or what it's suppose to do?

After much research I found one site that indicated that it's a driver for biometric devices. I uninstalled the software and found no adverse effects. I'm sure it has a use in some circles, but for the average user, it's just a toy which I find annoying.

Written by Leonard Rogers on Tuesday, May 17, 2011 | Comments (3)

VPN between RV042 and RVS4000 routers

Posted at 5:37:14 PM in Installations (48)

I followed the instructions on the Cisco web site on setting up the VPN between these two routers.  The biggest area of concern for me was a change in description in setting up the IPSec portion of the VPN.

The IP address info in the Local Group Setup and the Remote Group Setup is very straight forward.  In the IPSec Setup, the Phase1 DH Group, and the Phase2 DH Group on the RV042 simply say, Group1, Group2 and Group5.  There isn't much description on what those groups actually represent.  In the RVS4000 however, these Groups have 786-bit, 1024-bit and 2048-bit.  For me, I found Group1 equaled 786-bit. I didn't check out the other two groups.

Aside from that, everything else matched, so there wasn't a problem, right? Wrong. I included a space in the Tunnel Name (something I thought was a visual clue for me and had nothing to do with the tunnel).  That space caused the tunnel to fail. Oddly enough, the RV042 said it was connected while the RVS4000 said the connection was down. However it wouldn't ping from the RV042 side so it was actually down also.  After I removed the space in the tunnel name, everything connected without a problem.

I didn't actually want to use the RVS4000 router.  I wanted Gigabit throughput and I wanted wireless.  The RVS4000 router has the throughput but is not wireless.  The router that has both is the WRVS4400N. I could order the item online, but I went to Fry's.  They stopped stocking this item and instead stocked the RVS4000 and the Cisco Access point WAP4410N.  The WRVS4400N runs at around 200.00 in the store.  The RVS4000 router costs 120.00 in the store.  The WAP4410N costs 189.00 in the store so it's easy to see that adding an access point to achieve the same system as the WRVS4400N is not cost effective.  But you don't need to use the Cisco access point to get wireless to your customer's laptops.  The wireless N access points from Hawking cost about $80.00 and will do the job fine.

I just don't  understand why Cisco did that... or Fry's did that.

Written by Leonard Rogers on Thursday, May 12, 2011 | Comments (0)

Server Room Temperature Monitor

Posted at 5:39:21 PM in Installations (48)

I spent a couple of days researching computer room temperature monitor solutions and found many and varied solutions. What drove my crazy was the ridiculous pricing. The prices started at about $200 and went up as high as $800. Most of the products on gave were only thermometers that couldn't record any history. They would however notify you if the temperature exceeded a certain level. The higher end recorders were self contained and would record the temperature on a round paper disk that you had to remove every day. Otherwise  you'd be overwriting the previous days history.

These were way too costly for me and required way too much involvement on my part. So I went to sourceforge to see if anyone wrote any software that would extract the temperature from any of these devices and maintain a data file or histogram of the information and found one that read the data from a USB attached Oregon Scientific Weather station. I had problems nailing this one down because the model numbers couldn't be found; not the exact model numbers anyway.

All the different components that did show up made the process a little confusing. I wasn't sure what item went with what item or even what items had a computer connection.  I researched this site: and did a search on USB which gave me a small list of devices that used USBs which were all weather stations.  The one I picked was an RMS300 which comes with one remote sensor that measures both temperature and humidity. It also comes with software that measures and records the temperature info that I can read from my PC and see the history and I can print out any of that information.  So I ended up with a solution that worked for my computer room for only 39.95 plus tax and shipping. What a deal. :)

Written by Leonard Rogers on Thursday, May 5, 2011 | Comments (0)

Repairs to gotomypc printer after messing around with the manual install

Posted at 8:41:14 AM in Installations (48)

After the problems that I was checking with gotomypc printers in the last post. The customer was not able to print at all.  I looked on the remote desktop and found that the gotomypc driver was there, but it wasn't loading when the user connected via gotomypc.  After some research, the only solution was to reinstall gotomypc on the host computer again.  I'm not sure if there is a work around for this, but it did repair the problem. 

Btw, this is when I noticed that the waiting state is normal for gotomypc printers. I thought the printer which showed in a waiting state would not work because of it's state. However, it worked fine. I also noticed on the gotomypc troubleshooting site that their screen shot of the printers status' showed the gotomypc printer in a waiting state.

Written by Leonard Rogers on Sunday, April 17, 2011 | Comments (1)

HP Laserjet 1020-1022 series printer and Gotomypc

Posted at 3:28:02 PM in Installations (48)

I have a customer that recently wanted to print documents from her remote PC via gotomypc.  Her local printer was an HP Laserjet 1020 printer.  While I was investigating this issue, I discovered that the gotomypc printer on the remote PC was hung in a waiting state.  (Note: the "waiting" state is normal for the gotomypc printer.  I found that it sits in a waiting state when the printer works, so this isn't unusual.)  All the print jobs would just disappear unless she chose to print on one of the PCs attached to her remote PC. She does not have a HP Laserjet 1020 at the remote location.

So I tried the manual steps here.  According to gotomypc's web site, this process allows for any special formating that printing checks might require which cannot be handled by a generic printer translator. This didn't fix the problem either.

I installed the driver from the HP web site at this location. But had problems with the plug-n-play. The first 2 options were small and provided plug-n-play features that bungled the installation. I only wanted the drivers as the printer is not really at the remote location.  Those two links downloaded software that insisted that I plug the printer into a usb port before it'd continue. There is a network version the HP Laserjet 1022n which shouldn't require a USB printer to be plugged in, but when I downloaded that driver, I found it was an exact duplicate of the driver for the HP laserjet 1020. I finally downloaded the HP LaserJet Host Based Print Driver Package which did not require the printer to be plugged into a usb port.

After completing the manual install of a gotomypc printer, I found I still had the printer status show as waiting.  All print jobs just disappeared.  The problem appears that it would be like this with any "host based" printer.  These type of printers require the computer to do all the rendering.  That shouldn't be a problem, but it appears that the drivers for the HP Laserjet 1020 are looking for a response from the actual printer before the status will change to ready.  With no printer physically attached, the printer is never ready and will not print.

After hunting around, I determined that this hardware will not work with gotomypc.  I have seen a lot of people having trouble getting this printer to work with any remote device such as a network print server.  It also has problems with Windows 7 and Windows 2008 server.  

This printer apparently is best used in a standalone usb connected environment.

Written by Leonard Rogers on Friday, April 8, 2011 | Comments (0)

Peachtree 2009 SR5 Update

Posted at 12:39:38 AM in Installations (48)

Well Sage software did it again.  They released a tax update to download automatically into Peachtree 2009 Complete accounting (also Quantum 2009) but didn't download the required SR update to go along with the Tax update.  When I went to the menu option, Services/Check for updates, I got nothing.

So we are forced to go to a link that only shows up in the Tax update completion screen and if you don't get it there, you'll have to hunt for it.

Here's the link:

You just need to select the Peachtree software you are using to install SR5.  

If your company data is on a network drive, you will be directed to update the server first.  Once that's done, when you come back to the workstation, you'll find that SR4 is still installed on the workstation.  Running the update manually which worked on the server, will not work on the workstation.  You get a message indicating that your company data is on a shared drive and that you need to upgrade the server first.

I seem to remember this happened before and there is some way to "trick" Peachtree into installing the SR on the workstations.  I'll have to call Peachtree and leave this info here when I have it.   Monday...

This page had a lot of good info, but found that a file what was missing in our server's peachtree directory.  The file name: SRVerInfo.ini.  

The contents:


Note: I did not have to change anything in the registry.  We just changed verinfo.ini and srverinfo.ini

Written by Leonard Rogers on Saturday, March 12, 2011 | Comments (0)

More on Blackberry to iPhone contacts transfer

Posted at 8:57:14 AM in Installations (48)

I got ahold of both the Blackberry and iPhone yesterday to perform the transfer.  We did have to go back to the Verizon store so they could activate the Blackberry phone again.  On the Blackberry, I just needed to direct the browser to and install the Google Sync software.  The page contains an link for all the Google mobile apps and then individual links for the separate Google apps so you can download and install them one at a time.  The app installed without a problem.  I set up the gmail account and attempted to Synchronize everything.  However, I found that if you have no calendar items, the synchronization just hangs.   When I deselected the calendar items, the transfer of all the contacts worked fine.

I attempted to check gmail at the store to ensure the contacts went copied up fine, but we only had an iPad with it's gimped Safari browser, so I couldn't find the contacts at all.  We decided to go ahead and activate the iPhone again and attempt the contact download.  The odd thing about synchronizing with the iphone is the gmail account has to be setup as an Exchange Server.  The contacts immediately showed up.  We didn't need to synchronize at all.

Mission accomplished.

Written by Leonard Rogers on Tuesday, March 8, 2011 | Comments (0)

pgAdmin 3 installation error 0xc0150002

Posted at 5:22:27 PM in Installations (48)

Installed pgAdmin on a newly setup Windows XP Pro machine.  I kept getting this error with pgAdmin 3 version 1.10.4, which I had just downloaded from the pgAdmin site.  I tried downloading and installing their most recent version 1.12.2.  That version gave an error which indicated that a reinstall might fix it.  

This site had the fix.  Apparently, pgAdmin needs to have the Microsoft C++ 2005 distribution package installed.

Written by Leonard Rogers on Wednesday, March 2, 2011 | Comments (0)

Google voice

Posted at 3:05:20 PM in Installations (48)

I just setup Google voice to pick up my voice mail for my cell phone instead of the standard that Verizon offers.  My issues with with the standard voicemail is the limited storage, limited days they keep the message, the abrupt notification when you go to check new messages that it’s going to delete the expired messages, the fact that there’s no date and time stamp on the message until you are forced to delete the message.

The pluses on Google voice is their storage.  You delete messages from the web interface, not on the phone.  When you press 7 (normally  used to delete the verizon messages), the message is archived.  This removes it from the new message list.  The messages are also transcribed and sent to you via email, so you have a date stamp.  The transcription isn’t the best, but people slur words and are hard to understand.  Accents are especially hard to transcribe.


There are 2 flavors of Google voice.  One gives you a phone number where you can be contacted.  Log in at any pc with a mic and speakers and people can call you there.  If you don’t answer, the message gets transcribed and emailed to you and a text message to your phone (all customizable).  It’s also recorded so you can pick it up and play it later.  It can also be setup to call you at your regular phone and from what I understand, it can call any number of phones you supply, so you can forward the calls to your work number or cell phone or another away phone.  I have a friend who uses this so her kids can call her from any phone in their local area and it will forward to her cell phone.  She does this to avoid them having to call collect or incur charges since her cell phone and work are long distance from home.

The second flavor is voice mail for cell phones.  I don’t know if they can provide the service for all cell phone providers, but for Verizon, they give you a code to type into your phone and from that point on, all voice mail goes to Google voice.  You can create separate greetings for groups of phone numbers based on your address book, so you can leave a separate greeting for friends and one for business.   You can even make a call from the Google voice, but the phone number is not recognizable to the receiving end.  My calls tend to come from the 760 area code.   This comes in handy if you are at a computer with a mic and speakers, you can call back a number without having to use your cell phone.

A sample message from Google voice:


Hey lender date for or if I was out of company. Gimme a shout back when you get a chance wanted to touch base

Actual message:

Hey <name> this is <name> from <name of company> company.  Give me a shout back when you get a chance.  Just want to touch base.

The calling number is always listed, but it does not translate if that number is on your address book.  I could tell who it was, because I was on the phone at the time the call came in and saw the caller id.  Of course, hearing the actual message helps a lot too.



Written by Leonard Rogers on Tuesday, March 1, 2011 | Comments (0)

Blackberry to iPhone contacts transfer

Posted at 2:17:25 PM in Installations (48)

I have a client that went with the Verizon iPhone after his Blackberry umbilical cord broke.  It appears that it might be in the phone side, because it won’t charge, it won’t backup or synchronize or update.  Now the problem was how to get the contacts out of the blackberry and into the iPhone. 

My client told me that the people at the Verizon store were no help.  I have always thought that they would have all the gadgets needed to perform these tasks, but apparently not.  Or at least, they might not have enough expertise to address the “unusual” situation. 

I thought they’d at least replace the cable.  That’s an assumption on my part, but my client was in Virginia so I didn’t want to grill him on his store experience.  Nothing like going back to the same place that couldn’t help you and asking them to try something else when they should have exhausted all the options first.

I suggested replacing the battery with a fully charged battery and then backing up the address book to the internet, which he didn’t think of at the time and neither did the Verizon store tech.  However, they did sell him an iPhone in it’s place.

My concern is if they deactivated his Blackberry phone, then we’re probably screwed without them.  I found an app that can be installed in the Blackberry phone that would backup the address book and calendar from the Blackberry and save it on their web site and they also have the same app for iPhone.  The provider? Google.

I suggested he go back to the store and make these recommendations.  Install Google Sync on both phones… for the Blackberry and for the iphone.  I told him to create an account at gmail and provide the store with the info and see if they could get it done.  This should work as I can’t activate the old phone, they can.


Written by Leonard Rogers on Tuesday, March 1, 2011 | Comments (0)

Verizon USB 727 broadband modem Novatel Wireless

Posted at 3:47:57 PM in Installations (48)

I just finished reinstalling a laptop and needed to install the Verizon cellular modem.  I found the drivers online at which lists several models.  The one for the USB727 was downloaded and installed, but every step of the way, I got pop ups that indicated it couldn't find some part of the hardware.  I have always installed USB device software first, then inserted the USB device.  However, this time, that apparently doesn't work.

I'm not sure if it would have recoginized the installation if the usb727 was inserted or not, but after it was all installed, It still didn't recognize the device.  I looked at the device manager and found 4 items under other that were not recognized.  They were data ports. 

After researching I found this site: which had basically the same problem I had.  I right clicked each unrecognized item in other and selected the auto install.  It found the drivers and installed it for each one.  There are 4 separate dataports. 

And, no, there is not software on the USB for this model.


Written by Leonard Rogers on Wednesday, February 23, 2011 | Comments (0)

Cargowise EDI SQL server upgrade from 2005 to 2008

Posted at 2:56:49 PM in Installations (48)

Cargowise has a split in upgrade paths depending on the SQL server you are running.  We were left out of a new upgrade because we were using SQL 2005, so we decided to make the switch.  The instructions from Cargowise EDI for the migration simply are:

  1. backup the database
  2. copy the backup files to the new server
  3. Install 2008 R2
  4. restore the database
  5. Re deploy the Controller and web interface.

Their instructions start with installing 2008 server first.  These didn't work very well for me because I'm limited on servers and I didn't want to install SQL 2008 on a server that already has SQL 2005 installed on it.  I rearranged the steps to those listed above, but added to uninstall SQL 2005 after the backup was done.

The backup software used to backup Cargowise is the one provided by Cargowise.  It's found on the SQL server in the C:Program FilesCargoWise ediediEnterprise ServerDistributionApplication directory.  To correctly access the database, the server/instance had to be provided in order to list the databases.  It shows all of the tables in the database, but there are no instructions on which table to backup.  So I selected the main table, in this case enterprise.  It performed a backup of every table.

I had severe problems uninstalling SQL 2005 because the original install path was missing.  I had archived the installation files for Cargowise after the installation was complete.  Once the uninstall started, it did not role back after the abort and left me with a half uninstalled SQL 2005.  I couldn't reinstall it from a new download of SQL 2005 because the installation was still looking for the original install path.  So I had to go through and manually remove the components of the old server.  The installation for SQL 2005 exposed the installation log which showed the conflicting key.  Removing those keys only made the installation worse.  After further reading, I found that the reverse of the first portion of the key also needed to be removed.  So if the key was {432832-43233d32f4-2342234}, I had to find the keys that started with 238234.  I checked the folder to make sure I was removing the same information as the original key problem and that info matched.  I also removed the parent folder where ever I found either key.

 Once the SQL 2005 was uninstalled, I was able to install SQL 2008.  However, there were several pre-requisites that I needed to install before I could continue with the 2008 install.  One was an updated installer and the other was powershell which I don't know why it wasn't included in the SQL 2008 installation package.

After installing the database, I restored from the backup.  It went farily smooth, however; I changed the name of the main table from enterprise to edienterprise.  That became a real problem because no one could connect.  I thought when I specified the table to restore that I was entering the instance name.  To fix that problem, I had to go to ediload.ini and change the name of the table there.  On the server it was located at: C:Program FilesCargoWise ediediEnterprise Server.  It was in a slightly different location on the local network.  Once this was done everyone could get back.  

The final steps were to re-install the Controller, though I probably wouldn't need to do this if I kept the database name the same.  re-installing the controller is done at the workstation that has this service installed.  Go to the Admin menu and select scheduled tasks.  In the upper portion of the screen where you normally restart the controller task, you will see those options greyed out.  The only option is install.  I didn't want to press that because everything should have been the same.  Installing it again actually put two enteries on my services list, one as controller for the old database and one for the new.  Only one was running.

Then I went to the web server and ran ediload.exe -web deploy, but that wasn't enough.  I later had to go into the IIS settings and into the folder we setup for track and trace.  Select properties and then select the ASP.NET tab, then click Edit Configuration...  In application settings, the lower window has the database name in it.  Double click it and correct the name.

To-date, we stil have one major problem.  The backups are not running.  Everynight I get an error that says the user cannot login (it was the same error when I was trying to connect before the database name was changed, but the database name here is correct.)  As soon as I get more info I'll correct this post.

Written by Leonard Rogers on Friday, February 11, 2011 | Comments (0)

Cargowise EDI shared printer setup

Posted at 2:49:43 PM in Installations (48)

The Controller PC manages all the print jobs in Cargowise EDI.  Printers that are directly connected to the Controller PC are available to all the workstations.  The printers do not have to be setup on each workstation.  Cargowise EDI has it's own interface for selecting the printer.  If you have a shared network printer, it will not automatically be seen by Cargowise EDI.  The Controller software runs as a service.  In order for the printers to be seen, they need to run with the same permissions as the Controller service.  I'm not sure you can setup printers up to work in the Local Service user group, so what we did was make the Administrator account the one that runs the Controller service.  Then to add a printer to Cargowise, we just log in as the Administrator on the Controller PC and add the printer to that account.  Then log out and reconnect with the regular users creditials.  If  you haven't rebooted to make this switch, you will need to restart the Controller service.  Then when you print a job from Cargowise, you will see the newly added printer.


Written by Leonard Rogers on Friday, February 11, 2011 | Comments (2)

Cargowise EDI setup for SQL database at remote location

Posted at 10:18:34 PM in Installations (48)

The database engine behind Cargowise is MS SQL.  We installed the 2005 Express package that came with Cargowise's installation package.  The ideal software installation wants everything on the same network.  This becomes important when setting up file locations in the admin section of Cargowise.  These file locations are processed by the Controller (which is a PC that communicates with the SQL server to run jobs such as FTP, email and print jobs).  The file locations are always relative to the computer that runs the job.  In the case of FTP, it is relative to the Controller.  However, in the case of SQL database backups, it is relative to the SQL Server.  In our installation this becomes a problem, since our installation houses the SQL database off site.  We set the backup path originally on the P drive.  The P drive is common to the workstations and Controller, but not to the SQL Server so the backups wouldn't run.  We had to change that drive to one that the SQL Server could see.  This naturally also creates a problem when upgrading the software.

Once we had all of the workstations installed and the server installed at the remote location, we couldn't get the two to talk.  Cargowise's techical support was very helpful here.  To access the server, we had to run a SQL helper utility called cliconfg.exe.  It ships with Windows XP, I’m not sure about Vista or Windows 7.  This application allows you to set an alias that will provide the IP address to the server.  (see:  This allowed us to give an alias name to the server.  But it would not make the connection unless the alias name also contained the instance name as well.  In this case it was server/edienterprise.  Then we were able to make the connection and finish the setup.

Upgrades need to be performed on the SQL server first.  The workstation client is also installed there to perform admin functions like upgrades.  Once the server is upgraded, we copy the shared upgrade folder to a common location on the local network and then update the clients and controller from that shared location.

Written by Leonard Rogers on Monday, January 31, 2011 | Comments (0)

Apache server not responding on any IP or port

Posted at 3:14:18 PM in Installations (48)

After installing a minimum install Fedora 14 text mode, I yum'd httpd and started the service.  I could not get it to respond on any IP address.  I ran

netstat -tun | grep 80

and found that httpd was running and listening on port 80.  After searching around, I found that iptables and ip6tables had been installed as part of the minimum install package and I'm sure they were setup as a workstation which wouldn't have a web server.  I ran  

service iptables stop

and checked the web server again and it worked.

Now to figure out how to configure iptables in text mode. 

Written by Leonard Rogers on Wednesday, January 26, 2011 | Comments (0)

Fedora 14 Install experiences

Posted at 2:44:54 PM in Installations (48)

I have been trying to get Fedora 14 to install over the network.  Everything I did failed all around the missing repomd.xml.  The only installation that worked was using the DVD.  I'm updating an old server that doesn't have much memory which are all problems and I didn't want the graphics client installed.  I did the network install because it allowed the use of a kickstart file.  Once I started using the kickstart file, it refused to look back at the CD for the repository.

To get a text based server installed, I used the second menu option from the install screen, then pressed tab to add options and typed text at the end of that line and pressed enter.  The install was minimal.  It did not install any graphic desktop files.  I believe the total package count was 195.

Once the setup was done, I was able to boot and login, but had no network connection.  NetworkManager was not installed and setup use to provide a text menu to configure the network but neither of those are installed.  So how to get my network card working???

After researching, I found that I had to edit the ifcfg-ethx files.  I have two cards and from all the network installs I was trying to do, I was able to easily determine which one was attached to my router and could be assigned a dynamic IP address.  The other network card requires a static IP address which I will figure out how to setup first.

First thing, I needed an editor.  vi apparently comes with all of the Linux / Unix installs, but my favorite is nano.

My dynamic IP address would be assigned on eth1, so I used vi to edit ifcfg-eth1 and set the type to BOOTPROTO=dhcp and changed onboot=yes.  There was a line that wasn't in any of the example files so I removed it.  I appeared to be related to NetworkManager even though that wasn't installed on the minimal text install.

The resulting ifcfg-eth1 file looked like this:


I restarted the network service: service network restart 
I also used dhclient to cause the dhcp service to acquire an address.  Without that, we could not get the network card to acquire an IP address, so we weren't on the network.

eth0 needed to be static, but I needed to start installing yum updates.  After I finished the updates, I changed eth1 to a static address also.  The above ifcfg file stayed pretty much the same it is listed below:




Written by Leonard Rogers on Friday, January 21, 2011 | Comments (0)

repomd.xml repository installation file used by yum

Posted at 11:01:36 AM in Installations (48)

Many Linux installations (my favorite is Fedora though I'm not sure why) use yum to update their program files and libraries.  During recent installation attempts with Fedora 14, I kept getting error messages saying repomd.xml could not be found which is a very important file used by yum to perform it's upgrades.  I discovered that this file is normally found in a directory called repodata off the base directory provided.  So if you are trying to provide the location for this file and it is located on an HTTP server or FTP server, you would specify the base url as http://host/os where the os directory on the host has a folder named repodata which contains repomd.xml

I will be making several entries regarding my Fedora 14 install.  I've been at it for over 24 hours and it has been a terrifically difficult process.

Written by Leonard Rogers on Friday, January 21, 2011 | Comments (0)

Database conversion Postgresql

Posted at 10:09:14 PM in Installations (48)

I've been working on a postgresql version of Blog 9.0.  I'm in the testing phases now and will be looking at the other functions of this blog.

This has been an uphill course.  I manually converted all of the all of the database table and field names to lower case.  Postgresql is extremely case sensitive.  I didn't get all of the fields and found that as long as all the names are in lower case in the actual database, apparently the code can have whatever case structure it wants.  The ASP pages still find the correct tables and names.

I had a big issue with bigint and bigserial field types.  bigint is a 8 byte integer which gives an outrageous range on index keys.  I started out converting all of the field extractions from Int8 to cLng and that worked, but there was a lot of work to do to fix all of them.  I instead discovered that you can specify in ODBC to treat int8 as int4 which is the same as the integer used by MS SQL and visual basic.  After I made that change, I was able to view all of the screens with one exception.  I did not have a layout picked.  The database creation tool did not copy anything into that field and when I displayed the web pages, I got an error on invalid "/" or "" in query.  It turns out that I was submitting a null and as soon as I selected one of the valid templates, those errors went alway also.




Written by Leonard Rogers on Monday, December 20, 2010 | Comments (0)