Jump to content


Schoelje

Member Since 13 Aug 2013
Offline Last Active Aug 18 2017 06:28 PM
-----

Topics I've Started

ldap in Zurmo 2.0.21

21 August 2013 - 07:31 PM

When installing Zurmo 2.0.21 I get the message that ldap is installed, but still it says "FAIL".

Unfortunately, there's no further information.

 

Attached File  zurmo-2.0.21-ldap-fail.jpg   5.12KB   78 downloads

 

This is the info on php5-ldap (SolydK BO - runs Debian testing).

$ apt-cache policy php5-ldap
php5-ldap:
  Installed: 5.4.4-15.1
  Candidate: 5.4.4-15.1
  Version table:
 *** 5.4.4-15.1 0
        500 http://debian.solydxk.com/production/ testing/main amd64 Packages
        100 /var/lib/dpkg/status

Note: 2.0.18 did not show that message.

 

Zurmo 2.0.18 - Install halts

14 August 2013 - 08:46 AM

When installing the latest Zurmo on a clean install, the installation progress halts on "Connecting to Database".

 

Zurmo was extracted in /var/www
Permissions were set:
sudo chgrp -R www-data /var/www/zurmo/app/protected /var/www/zurmo/app/assets /var/www/zurmo/app/version.php
sudo chmod -R g+rwX,o-w /var/www/zurmo/app/protected /var/www/zurmo/app/assets /var/www/zurmo/app/version.php

In phpMySql I see that:

  1. User zurmo is created (zurmo@% where I expected zurmo@localhost).
  2. Database is created, but no tables.

Am I missing something?


Manual upgrade

13 August 2013 - 02:21 PM

I read the instructions to upgrade an existing install: http://zurmo.org/upgrades

 

However, for SolydK Back Office I packaged Zurmo (deb).

 

I'd like to know how to upgrade manually.

I know where the files go, how to set the right permissions, and edit the necessary configuration files.

My issue now is that I don't have an sql script to upgrade the MySql database.

 

Use case

User has version 1.5.12, and wants to upgrade to version 2.0.18.

The files are copied (old files overwritten) to /var/www/zurmo, configuration is changed, and permissions are set. An sql script is executed to upgrade the database to the newest version.

 

How can I realize this?

 

 

[EDIT]

Because the database is the only issue during an upgrade, I searched for a database compare method and see if It can be scripted.

This looks promising:

mysqldump --no-data --skip-comments --skip-extended-insert -u root -p zurmo_old>zurmo_old.sql
mysqldump --no-data --skip-comments --skip-extended-insert -u root -p zurmo_new>zurmo_new.sql
diff zurmo_old.sql zurmo_new.sql

Found here: http://stackoverflow...mysql-databases


url rewrite from IP to localhost

13 August 2013 - 09:05 AM

First of all I want to say what a magnificent piece of software this is!

 

We recently launched SolydK Back Office.

Zurmo is part of the software that's being used to support the main business processes of small, and medium businesses.

 

If our users want to start Zurmo from another PC, they open their web browser, and enter something like:

192.168.1.19/zurmo

The url is immediately rewritten to:

http://localhost/zur...o/default/login

which results in an obvious "page is not available" message.

If they then replace "localhost" with the IP address, they can login.

 

How can I prevent the URL from being rewritten?

 

[EDIT]

I think it's got to do something with this file:

app/protected/config/perInstance.php

and this line:

$instanceConfig['components']['request']['hostInfo']         = 'http://localhost';

 

But I don't know how to change the behavior.