Upgrade Stack (FastStack 6.0 --> FastStack 6.4)

[blak3r]

The fast stack installer for 6.4 has a number of improvements. PHP5.3, Mysql 5.1, and binaries for opcode caching.

So, I want to upgrade.

Here's what i did, ran the installer and installed to a different directory, and installed apache and mysql on different ports as my other instance. As a result, I had two

Removed the sugarcrmce app.
Made a copy of my existing sugarcrm pro htdocs folder.

I didn't update the config.php so my new copy running in newer apache and with php 5.3 was still connecting to the original mysql instance.

I get these errors when I start the new apache:

[Sat Feb 18 01:14:19 2012] [error] [client 74.84.138.114] PHP Warning: mysqli_connect(): Premature end of data (mysqlnd_wireprotocol.c:553) in C:\\sugarcrm-6.4.0\\apps\\sugarcrm\\htdocs\\include\\database\\ MysqliManager.php on line 274
[Sat Feb 18 01:14:19 2012] [error] [client 74.84.138.114] PHP Warning: mysqli_connect(): OK packet 1 bytes shorter than expected in C:\\sugarcrm-6.4.0\\apps\\sugarcrm\\htdocs\\include\\database\\ MysqliManager.php on line 274
[Sat Feb 18 01:14:19 2012] [error] [client 74.84.138.114] PHP Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in C:\\sugarcrm-6.4.0\\apps\\sugarcrm\\htdocs\\include\\database\\ MysqliManager.php on line 274
[Sat Feb 18 01:14:19 2012] [error] [client 74.84.138.114] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\\sugarcrm-6.4.0\\apps\\sugarcrm\\htdocs\\include\\database\\ MysqliManager.php on line 125

My plan to fix this is to: copy the entire data folder form my old mysql to the new one.
Then rnysql_upgrade.exe (this will in theory upgrade it from 5.0 to 5.1).
Then update my config.php to point to the new mysql port.
If I still get that error, I'll try to run mysqladmin and set the password.

Copying the entire data folder is going to take a couple hours so experimentation is somewhat time consuming. If anyone has any advice that could save me some time, I'd appreciate it.

[blak3r]

I fixed the error above by running

SET PASSWORD = PASSWORD('your_existing_password')

from the mysqladmin tool.


Haven't figured out how to migrate the database yet (haven't needed to yet)... Will post back when I do.

[roblaus]

Hmm, this sounds very complicated to me. I'd rather do the following: Make a copy of your entire stack installation and then uninstall the stack. Install the new stack, copy your old Sugar directory back under htdocs and the old mysql data directory to where it belongs (alternatively: import a dump of your Sugar database with the same name as the old one) and then run Sugar as usual. Update Sugar only with the appropriate Sugar update file.