7 replies to this topic

[Marcelo Origoni]

Hello Everyone, I was contacted by ray to give some feedback about the installation process. I tried installing in 3 different machines, with 3 different setups each, and still no luck.

The first Machine runs Windows XP SP3, with apache 2.2, PHP 5.3 and Mysql 5.1, no wampp/xamp/etc., I instaleld every application separately. In this setup, I couldn't find the APC extension, thus I gave up quite fast (I still plan on comming back, and compile the APC extension, suing VB6, but I need to install Visual Studio, and I don't have time right now)

Second Machine it's a shared Server hosted on hostgator, (you can check it here http://zurmo.origoni.com.ar). This gave me the weirdest error, the installation page did not even appear.

The last Computer it's my boy's computer, running ubuntu 12.04. He didn't had apache, nor php installed, so I went throught the installation and setup of the whole server, this is the email I sent Ray, and I want to share with you.

I'm, installing on the ubuntu box, and the first thing I found out, is the tar.gz file, doesn't contain the folder (which usually contains), and now I have all the files spread in my root folder, it's not a big deal to move them, specially because it was clean, but if I had a couple of files and folders there before, I could en up overwritting some files

I then went through the installation process, the first screen alerted me I didn't have cURL, APC, memcache and IMAP extension installed, and some settings in the php.ini file should be changed. In this step, even though we can assume it's a "php thing", saying it won't harm, a quick googling will tell you it's php and no apache, for instance. Also telling the route to the php.ini file would be awesome, so you know which file you need to modify.

I configured the db settings, and clicked on next. I assumed that by checking the "erase data" checkbox, the system would use any exiting db, and erase the data, if any. This doesn't seem to be the case, since I had created the db before installing, and I got an error saying the db already exists. Not a big deal, I deleted the db, and went through the next step.

Again, I got a couple of config issues, and this time I was not sure if it was php, or what that was misconfigured. A quick googling again told me it was mysql, so I changed the values through phpmyadmin, only to discover there was a readonly variable, I needed to change from the my.conf file, so I changed all the other values form phpmyadmin, and this only variable ( thread_stack) in the my.conf. Of course I needed to restart the mysql service, and I got a nice surprise, the value I changed using phpmyadmin, where valid only for the current session. Again, a little clarification on this screen to know how and where to change the values would be great.

I got to the next screen, and the nice "Installation in progress. Please wait." I waited a couple of minutes, and decided to scroll down, to discovered a bunch of errors, saying the user (which was created by the installer) didn't have enough permission. This is strange, since it should be created by the installer and granted all privileges.
So I restarted the installation process again, assuming all the errors I got caused some issue, I selected to create a new db and new user, so we can be sure there's no relation with the db I created. But I got the same error again.
When I try to log in using phpmyadmin, I get an error message "1045 Cannot log in to the MySQL server" not sure if this is a mysql config issue, or an issue when creating the user.

After I sent the email, I tried to conenct to mysql using the shell, and I could connect to the MySQL server, of course there were no tables created, nor data to query. So I think this might be an issue between PHP and MySQL, but I could conenct using the root user to phpMyAdmin.

Best

Marcelo

[Stafford]

Hey Marcelo,

Thank you for your really thorough feedback. Hey - you are in Buenos Aires! Any chance you can join us at our launch party there on October 17th? Would be great to see you there!

Below, I have put your main issues in bold so that our lead development team can address them:

1) - The first Machine runs Windows XP SP3, with apache 2.2, PHP 5.3 and Mysql 5.1, no wampp/xamp/etc., I instaleld every application separately. In this setup, I couldn't find the APC extension, thus I gave up quite fast (I still plan on comming back, and compile the APC extension, suing VB6, but I need to install Visual Studio, and I don't have time right now)

2) - Second Machine it's a shared Server hosted on hostgator, (you can check it here http://zurmo.origoni.com.ar). This gave me the weirdest error, the installation page did not even appear.

3) - The last Computer it's my boy's computer, running ubuntu 12.04. He didn't had apache, nor php installed, so I went throught the installation and setup of the whole server, this is the email I sent Ray, and I want to share with you.

I'm, installing on the ubuntu box, and the first thing I found out, is the tar.gz file, doesn't contain the folder (which usually contains), and now I have all the files spread in my root folder, it's not a big deal to move them, specially because it was clean, but if I had a couple of files and folders there before, I could en up overwritting some files

I then went through the installation process, the first screen alerted me I didn't have cURL, APC, memcache and IMAP extension installed, and some settings in the php.ini file should be changed. In this step, even though we can assume it's a "php thing", saying it won't harm, a quick googling will tell you it's php and no apache, for instance. Also telling the route to the php.ini file would be awesome, so you know which file you need to modify.

I configured the db settings, and clicked on next. I assumed that by checking the "erase data" checkbox, the system would use any exiting db, and erase the data, if any. This doesn't seem to be the case, since I had created the db before installing, and I got an error saying the db already exists. Not a big deal, I deleted the db, and went through the next step.

Again, I got a couple of config issues, and this time I was not sure if it was php, or what that was misconfigured. A quick googling again told me it was mysql, so I changed the values through phpmyadmin, only to discover there was a readonly variable, I needed to change from the my.conf file, so I changed all the other values form phpmyadmin, and this only variable ( thread_stack) in the my.conf. Of course I needed to restart the mysql service, and I got a nice surprise, the value I changed using phpmyadmin, where valid only for the current session. Again, a little clarification on this screen to know how and where to change the values would be great.

I got to the next screen, and the nice "Installation in progress. Please wait." I waited a couple of minutes, and decided to scroll down, to discovered a bunch of errors, saying the user (which was created by the installer) didn't have enough permission. This is strange, since it should be created by the installer and granted all privileges.
So I restarted the installation process again, assuming all the errors I got caused some issue, I selected to create a new db and new user, so we can be sure there's no relation with the db I created. But I got the same error again.
When I try to log in using phpmyadmin, I get an error message "1045 Cannot log in to the MySQL server" not sure if this is a mysql config issue, or an issue when creating the user.

After I sent the email, I tried to conenct to mysql using the shell, and I could connect to the MySQL server, of course there were no tables created, nor data to query. So I think this might be an issue between PHP and MySQL, but I could conenct using the root user to phpMyAdmin.

[Marcelo Origoni]

Hi Stafford, I'll do everything I can to assist to the Party, just tell me where and which hour it is.

I continued the installation process, I need to correct some information in my previous message, the insllation it did give the correct error message when trying to use an existing db, I didn't read it all, or I was tired. It told me the db already existed, and I should not provide the admin user and pass.

I could figure out the user didn't have the grant on the db, also I added the user to the localhost scope of the mysql (apart of the % wildcard).

After I got this sorted out, the db installation went through smoothly, both the table creation, and the db population of the demo data.

I can finally get started with the application, I'll try to provide a godo feedback, sometime next week.

Marcelo

[Ivica]

Here are my thoughts on your installation issues:

1. APC is optional requirements, so you are able to install Zurmo without APC library(APC is used just for opcode caching).

2. Zurmo can't run on Hostgator shared hosting, because MySql settings required for Zurmo.

3. I suppose this is not issue anymore, because you were able to install it.

[Marcelo Origoni]

I didn't know APC or memcache were optional, so I went ahead I tried to complete the isntallation in the windows XP box, and I got this, after setting up the db:


I tried rechecking the system, but still didn't get the names of the failing services

[Ivica]

Weird that some messages about services are not showing, I will check that issue.
But as I can see problem here is MySql database, which version is installed on your computer? And have you setup MySql port and username/passwords correctly?

[Marcelo Origoni]

Hi Ivica, port, suer and pass are correct.

mysql version is 5.1.50-community

and this is the server setup:

• Apache/2.2.16 (Win32) mod_ssl/2.2.16 OpenSSL/0.9.8o PHP/5.3.3
• MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 $
• PHP extension: mysql

I got all the information from phpMyAdmin, I have created a super user for you, and will send you login information via Private Message

[Ivica]

You should have PDO MySql library installed too, although at this point it is not important.