We solve the tough problems so you don't have to...

Godaddy Hosting Websites In Other Directories

We have a customer with Deluxe hosting with Godaddy. They have several sites running on separate hosting packages and we were able to combine both websites on to one hosting package.

The big trick was directing the domain to the right folder in the Public HTML folder. In the CPanel navigate to Domains >> Addon Domains.

Next to the Domain name you want to change click the Pencil icon next to the Document Root. Here you can enter the name of the new directory/folder you want this site to live.

 

Let  us know if this helped you….

 

Solved – Excel “Function Not Valid”

We ran into an issue with a Excel spreadsheet where pasting text into a field was causing it make the text a formula.

The answer is not use the “@” symbol in the beginning of the text. Some people recommend using an apostrophe or something before the text.  The following link helped us solve this.

https://www.pcreview.co.uk/threads/function-not-valid-getting-rid-of-the-symbol.1763379/

Let us know if this helped you…

 

Godaddy Domain To Office 365

We recently had to move a domain from Wild West Domains to another Godaddy Reseller hosting account. This was able to be done in just a few minutes where a domain transfer usually takes a week to complete. We ran into issue when Godaddy moved the DNS in the background and then asked me what the MX record was. They didn’t explain to me that that we should have written it down, so now we had to start from scratch.

I logged into their Office 365 account as the Admin and went to Setup >> Domains.  We could see there were issues with the various records.

We clicked on the domain name with the issue and it lead us to some screens to fix the issue.

We clicked on the “click here to view”.

Clicking on “Fix my Records” took me to a Godaddy Login where it asked for authorization and then it would fix my records; however, I had already went in and manually updated the records. Their page gave me good instructions on what records to add.  It was broken up in sections and those sections had titles. Those title were the type of record I needed to add. In the image above you will see “MX Records” and CName Records”.

My final records were as follows:

Let us know if this helped you…

 

What Does GDPR Mean

The European Union has enacted the General Data Protection Regulation. It’s goal is to streamline the different privacy laws throughout the individual EU States. The benefits for the in the individuals or “data subjects” control over their personal data.

Personal data is any information relating to an individual, whether it relates to his or her private, professional, or public life. It can be anything from a name, a home address, a photo, an email address, bank details, posts on social networking websites, medical information, or a computer’s IP address.
the European Commission

This will allow individuals the right to access their data that any company has and give them the right to have this information erased. Companies also must make the consent process clear for the individual.

Here is a nice article from ConnectWise on how GDPR.

Let us know if this helped you….

 

Using Includes Within WAMP

While working on an older site that used Server Side Includes I found it hard because my WAMP server environment was tweaked enough to use the older include method. I could switch the whole site over to PHP and use that type of include; however, that would be way to much work.

I came across an article which suggested I add the following line to my Apache “httpd.conf” file found in the “C:\WAMP\bin\apache\apacheX.X.X\conf” directory.

Options +Indexes +FollowSymLinks +Includes

This  was located around line 273. This didn’t work. I found another article which gave the following suggestion.

Options Indexes FollowSymLinks Includes

When I dropped the “+” before the items my WAMP wouldn’t turn green anymore. I restarted the services but the WAMP icon in the tray never turned green. I added the “+” back and my WAMP turned green quickly; however, the includes still didn’t work.

The article also said to remove the comments from the following lines which I found around line 478.

AddType text/html .shtml
AddOutputFilter INCLUDES .shtml

This still didn’t work, but the article goes on to say use “.html” instead or “.shtml”. Changing the “.shtml” to “.html” did the trick. I can now use the old HTML “#include file=”somefile.html” “.

Let us know if this helped you…

 

Xerox ColorCube 9303 – SMTP Scan To Email Settings

A customer called in because the hard drive in their copier died and was replaced. Since it was replaced the settings were never the same and their “Scan-to-folder” and “scan-to-email” was no longer working.

I could see there was an attempt by someone to get this set up; however, they would get an error about failing to send because of SMTP authentication. In the web interface of the printer which I reached by typing the IP address of the printer into the browser window and supplying the default credentials of “admin” and password “1111”.

Go to the “Properties” tab and in the Menu on the left under “Services” go to “Email” and then “Setup”. Go to the “Required Information” tab. This group is using Office 365 to handle their email, so I needed the following settings:

  • SMTP Server: smtp.office365.com
  • Port: 587
  • Host Name:  check this box.
  • Device Email Address: I had to add a valid email address and password.

While still in the “SMTP (Email)” section go to the “SMTP Authentication” tab. Here is what we needed fixed. It should look like the following:

You can use the “test configuration” button to make sure it is working properly.

This YouTube video did help me get the connection to Active Directory working correctly.

Here is a link to Xerox’s support for the copier I was working on.

http://www.support.xerox.com/support/colorqube-9300-series/contact/enus.html?fileLanguage=en

Let us know if this helped you…

 

 

Phishing Attempts From Cheapfixerproperties.com

We had a customer complaining about emails stuck in the spam filter. They were getting an email with the subject line “(3) Incoming messages failed to sync”. In the email was a button to “Restore Messages”; however, when we hovered over the link the web address was for “https://cheapfixerproperties.com/…”.

We told the customer this was a Phishing attempt, and to not click on that button. They are ready had. We ran a full Vipre scan on their machine.

The URL takes you to a site that Google has already flagged.

Let us know if this helped you…

 

Recovering / Reset MS SQL 2008 SA Password

We recently dealt with an issue where the customer lost their MS SQL database “SA” password, and the “SA” account was disabled. They were unable to alter the structure of any of their databases.

We found this link which helped us reset the SA password.

https://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/

Here are the steps we took.

  1. Logged onto the server and downloaded “PSexec”. We used this link to download it. Download
  2. Unzip the files and copy them to your “C:\windows\system32” folder. There will be a number of files and we needed more than just “psexec.exe” to perform this action, so we copied all the files from the download to that directory.

    We used this video to learn to us PSExec properly.
    https://www.youtube.com/watch?v=MaAL3C-DuHQ

  3. Stop the database. We went into the MSSQL Server Manager and right-clicked on the top item and selected “stop”.
  4. We right-clicked and opened the command prompt as an administrator.
  5. We typed in the following command.
    PsExec -s -i ” C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\ssms.exe”

    I had to search for “ssms.exe” to find the path I needed. The path in the first article was different than ours.

    This will launch MS SQL Server Manager as “System”, so you are above SA.

  6. Once MS SQL Server Manager was launched we were able to go to the “Security” tab, enable SA’s account, and change the password.
  7. We logged back in a SA and everything was working.

Let us know if this helped you…

 

 

#550 4.4.7 QUEUE Exchange Unable To Send To Comcast

We recently had a customer get a ISP change and on the same day were moving their DNS to Godaddy.  A few weeks later they noticed a bunch of emails bouncing back with a lot of the email addresses being for Comcast. We weren’t sure if this was a Godaddy,DNS, Exchange, or ISP issue.

It turned out to be the ISP needed to a PTR (pointer record) to the IP address.

This link helped us know that the PTR record is set by the ISP.

https://community.spiceworks.com/topic/1212792-ptr-record-in-godaddy-not-working

Here are some of the other things we had tried.

  • Adding the static IP to their SPF record.
  • Adding a Reverse Zone Record in the exchange server.
  • Turned off Spam Filtering in their email account

Let us know if this helped you…