vtiger Open Source CRM Discussions

Call Us : +1 408-733-3229

Log in

Search this forum

FAQ

Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Forum Home -> Installation 5.x

Previous topic :: Next topic

Goto page 1, 2 Next

navitas Post subject: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Wed Aug 05, 2009 9:13 pm
Posts: 21

Hi All

We currently have vTiger 5.0.4 running on a Ubuntu machine, working fine for over a year. We have been waiting for 5.1 as we really needed the new services features - however we want to move vTiger onto a dedicated server we have on the internet - it is running Windows 2003 Server and IIS.

We have tried several different ways of making this change - but one thing or another goes wrong and we don't have full functionality. If we try a 'Migrate', we dont have the original 5.0.4 installation path - we tried to make a new vtiger504 database and import all the data from our Ubuntu machine data dump - but we ended up having to make 3 databases as the migration couldn't find things it needed during the migration.

If we try and perform a brand new installation, trying to import the data dump from the old database seems to 'remove' several new tables that is required by 5.1 and the data is not actually 'migrated' to confirm with the new layout of the database.

I am trying to find out a definitive list of steps to follow to migrate from 5.0.4 to 5.1 whilst migrating from Ubuntu to Windows. From reading the various forums I have picked up one or two pointers (like backing up the privileges folder, storage folder) but just really hoping someone can help us with this migration/upgrade/change

Thanks
Paul

nitin Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS
Senior Member

Thu Aug 06, 2009 11:36 am
Posts: 156

Hi navitas,

Take the dump of database by using phpmyadmin or by using this command:

Code:

mysqldump -u(mysql_username) -p(mysql-password) -P(mysql_port) database_name > dump_filename.sql

Take the backup of your old vtiger source specially user_privileges, test and storage directory.

Now configure your IIS server for vtiger for that go through this link: http://wiki.vtiger.com/index.php/vtiger510:Installation_on_Windows#On_IIS
Once you done with configuring IIS server, install vtigercrm-5.0.4 on IIS server.
Then create a database with utf-8 support by using phpmyadmin or by command mode, using this commands

Code:

create database <new_db_name> DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

After this import the sql dump into this database by using phpmyadmin or by command mode, using this commands

Code:

use new_db_name;
source <path of database dump/dumpfilename.sql>

Once you are done with importing, go to your vtigercrm directory and look for config.inc.php file, in this file change the value of $dbconfig['db_name'] to the new database.

Once you are done with that replace the storage and test folder in the source by the old storage folder(which you have backup)

Now launch the vtigercrm5.0.4 and login as admin user, now go to settings page and click on sharing access. Here is a option for recalculating the sharing access, click on that.

After this put the source of the vtigercrm-5.1.0 there and then follow this link:http://wiki.vtiger.com/index.php/vtiger510:Migration

If you still face any issue, get back to us.
_________________
Regards,
Nitin Goyal
Vtiger Team

navitas Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Fri Aug 07, 2009 1:34 pm
Posts: 21

Hi THere

Thanks for the above steps - I have been following them to the letter and have come across a few problems.

I took the dump of our 504 database - no problem
I took the backup of our 504 source - no problem
Configured the IIS server - no problem
Install vtigercrm504 on IIS server - no problem
Create new database with utf8 - no problem
Import the SQL dump into new database - no problem
Look for config.inc.php - opened up the file, and it is blank ?

I then figured that when you said install vtigerccrm504 on IIS server - you might have meant, using my backup that I took..... so

copied my old source backup onto IIS server - no problem
look for config.inc.php - edited the $dgconfig name to new name
no need to replace the storage/test as they are already from my backup
launch vtigercrm504 (from IIS) and log in as admin - get error "Module name is missing, Please check the module name" with nothing else on the page

So - I dont want to continue on as it seems important to reset the sharing access before putting 5.1 source over the top - so if you have any further suggestions that would be appreciated

Thanks
Paul (Navitas)

nitin Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS
Senior Member

Fri Aug 07, 2009 1:55 pm
Posts: 156

Hi Paul,

By Installation means launch vtigercrm from browser and then follow the installation steps.

Anyways you can also use your old source but for that you need to change some more parameters in the config.inc.php files

I am listing all of them, change the value of

Code:

$dbconfig['db_server'] (to your new database server)
$dbconfig['db_port'] (new mysql port)
$dbconfig['db_username'] (new mysql user name)
$dbconfig['db_password'] (new mysql password)

$site_URL (to your IIS site url)
$root_directory (path to the vtigercrm directory)

And if you are coping your old source you need not to recalculate your sharing access as well. Once you done with this put vtigercrm 510 in your IIS and then follow the migration.

If you still face any issue, get back to us.
_________________
Regards,
Nitin Goyal
Vtiger Team

navitas Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Fri Aug 07, 2009 2:37 pm
Posts: 21

Hi

Thanks for clarifying on the installation of 5.0.4 - I went back to this step and did as suggested following the original steps - however I just wanted to clear up something further before I proceed

On a subsequent step you have told me to put the source of vtigercrm-5.1.0 there and then go through the migration steps - do you mean I should copy the source of 5.1.0's vtigercrm directory over the top of the 5.0.4 vtigercrm directory, or should I putting it in a folder 'beside' the 5.0.4 ? If it is beside then I am thinking I will have to configure IIS again to be able to point to the 5.1.0 folder - however, if it is 'over the top' then where do I point the migration tool when it asks for 'previous version source' location ?

Thanks for you help (and patience) with this

cheers
Paul (Navitas)

navitas Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Fri Aug 07, 2009 3:11 pm
Posts: 21


Actually - just as a 'side note' I just went through most things in the 5.0.4 version I now have running on the IIS server and when I go into Accounts and try and see the 'More Information' tab - nothing is displayed except for a blank page ?? Have I done something wrong here? Cheers Paul

nitin Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS
Senior Member

Fri Aug 07, 2009 3:38 pm
Posts: 156

Hi Paul,

also before you start migration, check this file user_previleges/default_module_view.php looks like its empty, if so can you copy the file from original source.

migration to vtigercrm510 can done both we suggest that you extract 5.1.0 source in your IIS webroot folder and configure (if needed) your IIS. then start with migration and in migration step give the path your old 5.0.4 source directory. watch this video it can be of help.

http://www.youtube.com/watch?v=Gh6phZZ7L1s
_________________
Regards,
Nitin Goyal
Vtiger Team

navitas Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Fri Aug 07, 2009 4:29 pm
Posts: 21

Hi

I checked my user_previleges/default_module_view.php on the old 5.0.4 and on the 5.1 and they are the same - they have the value set to false

I copied the 5.1 source onto IIS and pointed the IIS server to the new folder and proceeded with the migration - it went through ok with one or two minor errors in the database migration script (mainly pointing to its inability to update notes fields').

I then logged in to 5.1 and had a look around - I noticed the contacts, ticket numbers, account etc dont have numbers anymore - so went into settings and ran the Customise Record Numbering for each of the modules and that went through fine.

Then checked Accounts and still the More Information tab is showing as blank page? All other more information pages are fine (such as in contacts, trouble tickets, sales orders etc) - its just the Accounts one that doesn't display.

I went into Settings and changed the default pane view to SINGLE and then when I go to accounts - we dont see anything at all !!!

I then tried to navigate to the new Customer Portal using www.wwwww.co.uk/vtigercrm/modules/customerportal - however I get a blank screen with the following error

Warning: require(user_privileges/user_privileges_.php) [function.require]: failed to open stream: No such file or directory in D:\vtigercrm510\modules\CustomerPortal\index.php on line 12

I looked into the user_privileges directory and there is no user_privileges_.php file - there are several others ending in 1,2,3 etc. Looking at the PHP code it is supposed to be using

'user_privileges/user_privileges_'.$current_user->id.'.php'

but it doesn't seem to be picking up the $current_user->id in order to construct the file name it needs?

Any suggestions on how to resolve the above two issues - after this I think we are done ...... hopefully

Cheers
Paul

nitin Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS
Senior Member

Mon Aug 10, 2009 7:15 am
Posts: 156


Hi Paul, Login as admin user and then recalculate the sharing access form the settings page, this will create the user_privileges_.php files. _________________ Regards, Nitin Goyal Vtiger Team

navitas Post subject: Re: Migrate from 5.0.4 on Ubuntu to 5.1 on Windows IIS

Mon Aug 10, 2009 1:22 pm
Posts: 21


Hi There I had already tried that - but did it again, with no change - the Accounts 'More Information' tab still doesn't appear and the Customer Portal brings up the error about the missing file Any other suggestions? Thanks Paul

Display posts from previous:

	vtiger Forum Index -> Installation 5.x	All times are GMT Leave a Testimonial Goto page 1, 2 Next
Page 1 of 2

Jump to: