Upgrading to V6

Gabbitas

Hi Guys,

I want to upgrade to version 6 but before going the whole hog and upgrading my production server I have decided to do some testing first on my windows laptop. I want to be sure of the effect v6 will have on my clients data / user experience. My production server runs AwareIM version 5.9. So far I have taken the following steps:

1) Installed MySQL on my laptop
2) Installed evaluation AwareIM version 6 on my laptop

Now the best way to test something is to use some real life data so next I took the following steps:

3) Exported a BSV from my production server
4) Created a new BSV with the same name on my laptop and imported the BSV from the step 3
5) Published it and confirmed I could log into the operation mode

All good so far, no probs. However here is the bit that fails for me:

6) I want to use some 'live' data from the production server so I create a backup from within MySQL Workbench. I create the backup but only include the tables that start with MyBusinessSpaceName (I don't include and bas tables apart from bas_idgen)
7) I import this backup on my laptop using MySQL Workbench and it confirms the backup was restored.
8 ) PROBLEM: When I now try to log into the operation mode on my laptop all I get is an error stating that I have entered invalid credentials, even throws the error if I try to log in as the administrator as in step 5.

I have tried restarting awareIM, publishing a new version, publishing a test version all to no a avail. It just won't allow me to log in.

Can anyone spot where I'm going wrong here? Is this because I'm using a MySQL backup that is from a server running AwareIM 5.9 and version 6 won't support it?

Any ideas welcomed,

Many Thanks

customaware

Gabriel,

Just a stabin the dark.....

What is the exact error you are getting?

If it is invalid credentials rather than a license expiry type error then it would indicate to me to check the following....

You imported the bsv and when you ran it, I assume initially in test mode and then in operation mode with no data I would have expected it to create a new admin RegularUser.

Now, if you then imported all the operational data into BASDB then you would have possibly imported another admin RegularUser which may have had a different password on your production server.

I would have a look at the data in MySQL on your laptop and compare the admin records to see if the password is different...if you know what I mean.

kklosson

The problem is that you have migrated all data which includes licensing information which is tied to the machine's MAC id. If you have set up a trial system and want to migrate data from your live server, then do a SQL dump from your live server by dumping all tables from the basdb database that start with the application name plus the bas_idgen table, and no other tables.

If all you are using is the test db, then I think you can take all tables.

customaware

Hi Kingsley,

If I read it right, Gabriel said he did not include any BAS tables except bas_idgen which I would have expected to be ok.

His license must be in tact else he would have got a license error.

Have I missed something?

kklosson

Yeah, I read into that one instead of reading it. You can disregard me this.

crisg0112

there's a new column added on the RegularUser table in V6 which might be the cause not 100% sure

I would do a 'script copy of the data' instead of 'backup/restore'

Gabbitas

Hi Guys,

Thanks for your help on this one. Got it solved now. Here are the steps I took....

1) Installed evaluation version of 5.9 on laptop.
2)Created BSVs with same name as production server
3) Imported BSVs to laptop
4) Backed up data on production server (not any bas_tables)
5) Imported data onto laptop
6) Upgraded 5.9 on laptop to V6 evaluation

Works great. Can now do some testing to see how V6 behaves with my data.

customaware

Glad you got it solved Gabriel.

rocketman

hi guys,

I'm just going through this hoop from V5.9 to V8 (yeah it's been a while.) My problem is production server is Win 2012 home dev machine is Mac. I can't seem to find a legacy download page where I can obtain a 5.9 mac install to kick this process off.

Does anyone know of one ? Vlad?