Infralution Support

[nmunro]

We have products that we sell multiple license pack formats. After an update to the database using License Tracker database update tool, all current muti pack licenses now are listed as being completely used up, even if the customer has not authorized the allowable number of licenses. Any suggestions on how to approach a fix for this? It is a SQL database and we have a back-up of the database just prior to the update. Thanks.

[Infralution]

What version of License Tracker were you upgrading from?

Are you running the Authentication Server with its own separate database or connected directly to the License Tracker database?

Do you have a product variant for your multi-pack license in which you are setting the Max Authentications for individual keys? Have you opened the product dialog and checked that this is still set?

When you say "all current muti pack licenses now are listed as being completely used up" do you mean that licenses issued before the upgrade are having the issue or just licenses issued after the upgrade?
_________________
Infralution Support

[nmunro]

What version of License Tracker were you upgrading from?
It was not an upgrade really. We ran into some issues with IPN talking to ILS so I ran the database update as part of the process to track down the problem. The ILS installation was already at 4.7.3. No issues were reported during the update.

Are you running the Authentication Server with its own separate database or connected directly to the License Tracker database?
Separate database.

Do you have a product variant for your multi-pack license in which you are setting the Max Authentications for individual keys? Have you opened the product dialog and checked that this is still set?
I'm not sure what you mean here. All our muti-pack licenses are product variations of a single license product. They all use the same product key.

When you say "all current muti pack licenses now are listed as being completely used up" do you mean that licenses issued before the upgrade are having the issue or just licenses issued after the upgrade
Existing users are complaining that when the go to authorize a new install, the License Server complains that they have already used up all their licenses when this is not true.

[nmunro]

Just another note. The issue ended up being on the IPN side and we had to update the IPN server with a recompiled IPN.dll (product data embedded in dll) and our custom product info dll. This updated the IPN side to work with the 4.7.3 version of InfralutionLicensing.dll

[Infralution]

What version of IPN.NET are you using? It sounds like maybe an older version if you have the product data hard coded in the DLL.

If your database was already the current version then running either the License Tracker Database wizard or the Authentication install page won't actually do anything.

Look at one of the license keys that is giving problems in License Tracker license key tab. Check the Max Authentications column - is it set to the correct value? Import Authentications from the Authentication Server - check how many computers the license is installed on.

If the Max Authentications is not set correctly then it may be that the problem is in IPN.NET and your IPN.NET is not calling the Authentication Server to set Max Authentication limit. I'd recommend using the latest version of IPN.NET which uses a database for the product data rather than XML config files (or hard coding the product data). The products can then be configured directly from License Tracker.
_________________
Infralution Support

[nmunro]

Thanks for the pointers. We are using the latest version of IPN that works with ILS 4. We are using the suggested methods in the documentation, embedding the product data in the IPN dll rather than having a separate IPNSettings.xml file, and using a custom product dll (sorry if I don't have the name correct, not at development machine) to provide a bit more security.

We will look at what ILS is showing and report back.

[Infralution]

Sorry I missed that you were using Version 4.7 of ILS not Version 5.
_________________
Infralution Support

[nmunro]

It appears that the max authorizations on the Authentcation DB no longer match the max authorizations in the License Tracker DB (not sure if it is for all, or just some). For example, we have a customer with a 50 seat license who has activated on 24 machines. A search of the Authentication DB tables shows the same 24 activations but it reports the Max Authorizations for that Lic ID as 20?

Is there a method to push the Max Auth's from the License Tracker DB to the Authentication DB ont the server?

[Infralution]

I'm not sure how that could happen. You can use the Authentication > Set Limits menu in License Tracker to set the limit for selected license keys. In version 4 this doesn't default to the current value for the license key - but you could select all of the license keys for the given product variant and then set the max authentication limit to the required value.

In version 5 you could just use the upload option when Configuring the Authentication Server and this syncs all the data in License Tracker into the Authentication database. In version 4 the Authentication > Export Data to Server function is similar but it only adds new keys and won't update existing keys/authentications. One option would be to backup your authentication database and ensure that the License Tracker database is up to date by downloading using the Authentication > Import Data from Server menu. Then you could delete all the license keys from the Authentication database using Access or SQL Server then use the Authentication > Export Data to Server to upload the License Tracker data again.
_________________
Infralution Support

[nmunro]

Thanks again for the prompt support. That is the solution we have come with as well (manual write of the Limits back to the Auth DB). Very strange, can't see how it could have occurred either. We will upgrade to the latest ILS and IPN products for our next software release.