cancel
Showing results for 
Search instead for 
Did you mean: 
PhilM
Level 14
Report Inappropriate Content
Message 1 of 5

Invalid License Error after database recovery

Jump to solution

Let me start off by saying that the environment in question is not live. It is the environment I use for testing for trying anything on the live system. So if I've broken it past the point of reasonable recovery, don't worry - I will simply start again and learn from the experience.

My environment consists of 3 virtual machines:-

A 2003 Server, running ePO 4.5 (build 937) & SQL 2005 Express Database server

2 x Windows XP SP3 machines acting as clients, running McAfee Agent 4.5 & VSE 8.7.

The object of the exercise was to replace the SQL 2005 Express database with SQL 2008 - just to see if it was possible and to partially treat it as an attempted recovery exercise.

Using KB 52126, I stopped the ePO services and took a backup of the ePO database using Management Studio Express. I then removed SQL 2005 Express and re-booted the server.

I then installed SQL 2008 Express (not realising at the time that one of the installation options in 2008 Express was to upgrade from 2005!) giving it the exact same instance name as used by the previous 2005 Express installation. Once this was complete, I then restored the database from my backup file, giving the new database the same name as it's 2005 predecessor.

Using the ODBC tool, I checked to make sure that the database could be contacted and saw that the test was successful. So, I re-started the ePO services and for good measure re-booted the server.

With the server re-booted, I attempted to connect to ePO and was pleasantly surprised to see that there were no obvious database connection errors. But, there was the message "Failed to load license data. To enter a new license go here". Clicking on the link I was taken to a screen which  prompted me for a administrator username and password and provided a field to re-enter the ePO license (which I had written down as a precaution anyway).

Entering the necessary details and clicking on the Add License it then says "Your license key has been successfully updated".

Seemingly all is well. However, returning to the login screen it takes much longer for the login box to appear and it states that license for ePolicy Orchestrator is invalid.

I deleted all temporary data from the browser, just in case this was a cached page, but it hasn't made any difference.

Any suggestions on what can be done (if anything) and how?

Thanks in anticipation.

Phil.

1 Solution

Accepted Solutions

Re: Invalid License Error after database recovery

Jump to solution
4 Replies

Re: Invalid License Error after database recovery

Jump to solution
PhilM
Level 14
Report Inappropriate Content
Message 3 of 5

Re: Invalid License Error after database recovery

Jump to solution

Tom,

I did wonder whether the port number was going to be a factor here, but having previously seen "I can't connect to the database"-style messages on the ePO log in screen when the link between ePO and the database was broken, the fact that it didn't show any such errors lead me to believe that communication to the newly-restored database was OK and that re-entering the license key was simply a necessary task.

I looked at your recommended KB article and immediately decided to look at Workaround 2 as it referred to the releationship between ePO and the port number of the database server.


Edited the db.properties file and replaced the existing db.port= entry with the port number taken from the SQL Express Configuration manager, restarted the ePO services and I can log in once again

Thank you - that was spot on!


Regards,

Phil.

Re: Invalid License Error after database recovery

Jump to solution

This is because ePO uses two different webservers (apache and tomcat) both connecting too the same DB.

The error messages vary depending which webserver did not connect to the DB.

Setting the SQL Express Edition to a permanent port number is the best solution to eliminate this issue.

PhilM
Level 14
Report Inappropriate Content
Message 5 of 5

Re: Invalid License Error after database recovery

Jump to solution

I have to confess that discovering that SQL Express doesn't automatically use the standard MS SQL TCP port (1433) has left me scratching my head a little.

I've used SQL Express before with other products, but as I've never done anything along the lines of what I did with my ePO server, the fact that it wasn't using TCP port 1433 hadn't occurred to me.

More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community