AgileTrack
Put your development on the AgileTrack

License Renewal Not So Renewing

Hello,

Our license ran out so we purchased another year's worth. We are not using the server, our machines individually contact a central MySql database server directly. We all places a copy of our spiffy new licenses.dat in the usual spot and we are getting nagged to upgrade. Any idea how to fix this?

James

—Posted by James on Jan 15, 2008


	Forum General Discussion


	Reply

I'm not exactly sure why the new one's aren't being picked up. I'll look into the problem real soon and try to fix it.

In the meantime, here's a workaround that should help. Disconnect all of the AgileTrack clients. Connect to your AgileTrack MySQL database and run "UPDATE user SET license = NULL". Then connect from a client that has the licenses.dat and it should reset the license key for each user.

Let me know if that helps. Thanks.

—Posted by Adam Lane on Jan 15, 2008 at 8:42:53 AM

Well, no, it didn't help. In fact now we can't log in. :-(

James

—Posted by James on Jan 15, 2008 at 8:57:10 AM

I'm looking into it right now. I'll let you know what I find out real soon. Sorry about the trouble.

—Posted by Adam Lane on Jan 15, 2008 at 8:58:54 AM

Not a huge deal, but it would be nice to have solved soonest. I might be able to manually update the information in the user table. I am exploring that option now.

James

—Posted by James on Jan 15, 2008 at 9:05:42 AM

Guessing what to put in the database doesn't seem to work. I tried downloading and running the server in case I would have better luck with that, but I get the following error when trying to run it:
975 [Thread-2] INFO : persistence.GenericFullTextIndexer – Beginning full text indexer thread…
Create new persistence cache
Create new persistence cache
2500 [main] ERROR: mysql.TrackerMySQLDatabase – {type=User,userRoles=[48],userInstantMessenger=,userEmail=,userCell=,userPhone=,userLicenseStatus=MISSING,revision=1063190,userEnabled=true,modifiedDate=Tue Jan 15 10:33:45 CST 2008,userUsername=robert,deleted=false,name=Robert Green,createdDate=Fri Dec 15 11:24:56 CST 2006,createdBy=52,id=53}
org.apache.lucene.store.jdbc.JdbcStoreException: No entry for [_2ey.fnm] table lucene_index

I am pretty sure that I have the config file set up properly.

—Posted by James on Jan 15, 2008 at 9:26:45 AM

I set up a test and tried a few things.

After setting the licenses to null, when the licenses.dat file was where it's supposed to be, things worked pretty much as expected—the enabled users were assigned licenses from the file.

If the licenses.dat file wasn't there, a test license was used and given to one of the enabled users, but the rest became disabled and wouldn't be able to log in. I wonder if your users became disabled.

In the user table, you can manually set the license string for a user to be one of lines from the licenses.dat file. You can also manually set the user's enabled flag to be 1. Let me know how it goes.

—Posted by Adam Lane on Jan 15, 2008 at 9:27:02 AM

I am pretty sure that I have the config file set up properly.

—Posted by James on Jan 15, 2008 at 9:49:09 AM

I am pretty sure that I have the config file set up properly.

—Posted by James on Jan 15, 2008 at 10:03:34 AM

OK, I manually updated the database with the new keys, guessed on values for licens_status, made sure the folks with keys were enabled, and now it all works. I will start a new thread about trying to run the server.

—Posted by James on Jan 15, 2008 at 10:05:10 AM

Nevermind on the server as well. It seems once I got the licensing issues worked out the server is happy now.

—Posted by James on Jan 15, 2008 at 10:07:32 AM

Ok, I'm glad you got that worked out. Sorry it didn't work smoothly, but I'll try to figure out where things went wrong.

—Posted by Adam Lane on Jan 15, 2008 at 10:14:13 AM