[horde] Upgrading from 1.x to horde 4

Paul Ronald jhon.higgins at gmail.com
Thu Oct 4 14:08:50 UTC 2012


2012/10/2 Paul Ronald <jhon.higgins at gmail.com>

>
>
> 2012/10/2 Jan Schneider <jan at horde.org>
>
>>
>> Zitat von Paul Ronald <jhon.higgins at gmail.com>:
>>
>>  2012/10/1 Paul Ronald <jhon.higgins at gmail.com>
>>>
>>>
>>>>
>>>> 2012/10/1 Jan Schneider <jan at horde.org>
>>>>
>>>>
>>>>> Zitat von Paul Ronald <jhon.higgins at gmail.com>:
>>>>>
>>>>>  2012/9/28 Jan Schneider <jan at horde.org>
>>>>>
>>>>>>
>>>>>>  Zitat von Paul Ronald <jhon.higgins at gmail.com>:
>>>>>>
>>>>>>>
>>>>>>> .............................
>>>>>>>
>>>>>>>
>>>>>>>>
>>>>>>>>>>>>>>>>  The "problems" were in the stdout of the command "pear
>>>>>>>>>>>>>>>> install
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>  --alldeps
>>>>>>>>>>>>>>> horde/webmail", this command show problems with some
>>>>>>>>>>>>>>> packages,
>>>>>>>>>>>>>>> fileinfo,
>>>>>>>>>>>>>>> beta and alpha versions, etc. This is the point 1 of the link
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> In the point 2, i have correct the horde_dir.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>    - pear channel-discover pear.horde.org
>>>>>>>>>>>>>>>    - pear install horde/horde_role
>>>>>>>>>>>>>>>    - pear run-scripts horde/horde_role
>>>>>>>>>>>>>>>       - when it ask, i put the path to my horde installation
>>>>>>>>>>>>>>> 1.2.20,
>>>>>>>>>>>>>>>       /var/www/horde
>>>>>>>>>>>>>>>    - pear install --alldeps horde/webmail
>>>>>>>>>>>>>>>    - /usr/bin/webmail-install:
>>>>>>>>>>>>>>>       - the output of the command /usr/bin/webmail-install:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>       Warning: include_once(Log.php): failed to open stream:
>>>>>>>>>>>>>>> No
>>>>>>>>>>>>>>> such
>>>>>>>>>>>>>>> file
>>>>>>>>>>>>>>>       or directory in /var/www/horde/lib/Horde.php on line 14
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>       Warning: include_once(): Failed opening 'Log.php' for
>>>>>>>>>>>>>>> inclusion
>>>>>>>>>>>>>>>       (include_path='/var/www/horde/****
>>>>>>>>>>>>>>> ******lib:.:/usr/share/pear:/******
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> usr/***
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> *share/php')
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> in
>>>>>>>>>>>>>>>       /var/www/horde/lib/Horde.php on line 14
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>       Warning: set_error_handler() expects the argument
>>>>>>>>>>>>>>>       (Horde::errorHandler) to be a valid callback in
>>>>>>>>>>>>>>> /var/www/horde/lib/core.php
>>>>>>>>>>>>>>>       on line 57
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>       Installing Horde Groupware Webmail Edition
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>       Fatal error: Class 'Horde_Registry' not found in
>>>>>>>>>>>>>>>       /usr/share/pear/Horde/Core/**********Bundle.php on
>>>>>>>>>>>>>>> line 60
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> The installation 1.2.20 was done with a tar.gz and is not in
>>>>>>>>>>>>>>> separate
>>>>>>>>>>>>>>> PEAR
>>>>>>>>>>>>>>> installation.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> I use RHEL 6, i have tried upgrade and a new installation.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Thank you
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>  Don't install Horde 4 into the same directory of a Horde
>>>>>>>>>>>>>>> Groupware 1
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>  installation. You messed up files of different versions.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> Jan Schneider
>>>>>>>>>>>>>> The Horde Project
>>>>>>>>>>>>>> http://www.horde.org/
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> Horde mailing list
>>>>>>>>>>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>>>>>>>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.**
>>>>>>>>>>>>>> ********org<
>>>>>>>>>>>>>> horde-unsubscribe at lists.******hord**e.org <http://horde.org>
>>>>>>>>>>>>>> <
>>>>>>>>>>>>>> horde-unsubscribe at lists.****hord**e.org <http://horde.org><
>>>>>>>>>>>>>> horde-unsubscribe at lists.horde.****org<
>>>>>>>>>>>>>> horde-unsubscribe at lists.**horde.org<horde-unsubscribe at lists.horde.org>
>>>>>>>>>>>>>> >
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> >
>>>>>>>>>>>>>> >
>>>>>>>>>>>>>> >
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>  ¿The database can be the same or must be new? if must be new,
>>>>>>>>>>>>>> how
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>  do i
>>>>>>>>>>>>> import the users, calendars,notes,tasks, etc.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>  You can use the same database. Of course after doing a backup.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Jan Schneider
>>>>>>>>>>>> The Horde Project
>>>>>>>>>>>> http://www.horde.org/
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> Horde mailing list
>>>>>>>>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>>>>>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.**
>>>>>>>>>>>> ******org<
>>>>>>>>>>>> horde-unsubscribe at lists.****hord**e.org <http://horde.org> <
>>>>>>>>>>>> horde-unsubscribe at lists.horde.****org<horde-unsubscribe at lists.*
>>>>>>>>>>>> *horde.org <horde-unsubscribe at lists.horde.org>>
>>>>>>>>>>>>
>>>>>>>>>>>> >
>>>>>>>>>>>> >
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>  I had to unistall ol the packages of Horde in Pear and the
>>>>>>>>>>>>
>>>>>>>>>>> installation
>>>>>>>>>>> over a new directory with my DB of the old Horde was very well.
>>>>>>>>>>>
>>>>>>>>>>> I had some problem trying to login like Administrator, because
>>>>>>>>>>> was
>>>>>>>>>>> trying
>>>>>>>>>>> to authenticate IMP, i had to setup backends.local.php with my
>>>>>>>>>>> imap
>>>>>>>>>>> server
>>>>>>>>>>> and i could use the user administrator that i select in the
>>>>>>>>>>> execution
>>>>>>>>>>> of
>>>>>>>>>>> webmail-install script.
>>>>>>>>>>>
>>>>>>>>>>> Jan, thank you for your help. Can i edit the instructions of
>>>>>>>>>>> upgrade
>>>>>>>>>>> from
>>>>>>>>>>> 1 to 4, i would like to help the understanding of the upgrade.
>>>>>>>>>>>
>>>>>>>>>>> Now i have a new problem with INGO filters, whe i try to setup a
>>>>>>>>>>> new
>>>>>>>>>>> filter:
>>>>>>>>>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
>>>>>>>>>>> entry
>>>>>>>>>>> '0'
>>>>>>>>>>> for key 'PRIMARY'
>>>>>>>>>>> I suppose that this must be in another email with another
>>>>>>>>>>> subject to
>>>>>>>>>>> the
>>>>>>>>>>> list, no?.
>>>>>>>>>>>
>>>>>>>>>>> Thank you
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>  Hello,
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>  after upgrade i see this error:
>>>>>>>>>> Integrity constraint violation: 1062 Duplicate entry '0' for key
>>>>>>>>>> 'PRIMARY'
>>>>>>>>>> And the desc of ingo is this:
>>>>>>>>>>
>>>>>>>>>> mysql> desc ingo_rules;
>>>>>>>>>> +-----------------+-----------******---+------+-----+---------**
>>>>>>>>>> +-**
>>>>>>>>>>
>>>>>>>>>> --**----+
>>>>>>>>>>
>>>>>>>>>> | Field           | Type         | Null | Key | Default | Extra |
>>>>>>>>>> +-----------------+-----------******---+------+-----+---------**
>>>>>>>>>> +-**
>>>>>>>>>>
>>>>>>>>>> --**----+
>>>>>>>>>>
>>>>>>>>>> | rule_id         | int(11)      | NO   | PRI | NULL    |       |
>>>>>>>>>> | rule_owner      | varchar(255) | NO   | MUL | NULL    |       |
>>>>>>>>>> | rule_name       | varchar(255) | NO   |     | NULL    |       |
>>>>>>>>>> | rule_action     | int(11)      | NO   |     | NULL    |       |
>>>>>>>>>> | rule_value      | varchar(255) | YES  |     | NULL    |       |
>>>>>>>>>> | rule_flags      | int(11)      | YES  |     | NULL    |       |
>>>>>>>>>> | rule_conditions | longtext     | YES  |     | NULL    |       |
>>>>>>>>>> | rule_combine    | int(11)      | YES  |     | NULL    |       |
>>>>>>>>>> | rule_stop       | int(11)      | YES  |     | NULL    |       |
>>>>>>>>>> | rule_active     | int(11)      | NO   |     | 1       |       |
>>>>>>>>>> | rule_order      | int(11)      | NO   |     | 0       |       |
>>>>>>>>>> +-----------------+-----------******---+------+-----+---------**
>>>>>>>>>> +-**
>>>>>>>>>>
>>>>>>>>>> --**----+
>>>>>>>>>>
>>>>>>>>>> 11 rows in set (0.01 sec)
>>>>>>>>>>
>>>>>>>>>> rule_id shoud be autoincrement but has not change, this happens in
>>>>>>>>>> other
>>>>>>>>>> tables.
>>>>>>>>>>
>>>>>>>>>> Is there any step that i have not read
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>  Did you upgrade the tables at all?
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Jan Schneider
>>>>>>>>> The Horde Project
>>>>>>>>> http://www.horde.org/
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Horde mailing list
>>>>>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.******org<
>>>>>>>>> horde-unsubscribe at lists.horde.****org<horde-unsubscribe at lists.**
>>>>>>>>> horde.org <horde-unsubscribe at lists.horde.org>>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> No, i use the instructions of the
>>>>>>>> http://www.horde.org/apps/******webmail/docs/INSTALL<http://www.horde.org/apps/****webmail/docs/INSTALL>
>>>>>>>> <http://**www.horde.org/apps/**webmail/**docs/INSTALL<http://www.horde.org/apps/**webmail/docs/INSTALL>
>>>>>>>> >
>>>>>>>> <http://**www.horde.org/apps/**webmail/**docs/INSTALL<http://www.horde.org/apps/webmail/**docs/INSTALL>
>>>>>>>> <http://**www.horde.org/apps/webmail/**docs/INSTALL<http://www.horde.org/apps/webmail/docs/INSTALL>
>>>>>>>> >>document.
>>>>>>>>
>>>>>>>> The last command
>>>>>>>>
>>>>>>>> was webmail-install
>>>>>>>>
>>>>>>>> Where can i find the documentation or what must i do?
>>>>>>>>
>>>>>>>
>>
>>>>>>>>
>>>>>>>>  webmail-isntall *does* upgrade the database, you get notified about
>>>>>>> that.
>>>>>>> Did it succeed?
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Jan Schneider
>>>>>>> The Horde Project
>>>>>>> http://www.horde.org/
>>>>>>>
>>>>>>> --
>>>>>>> Horde mailing list
>>>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.******org<
>>>>>>> horde-unsubscribe at lists.**hord**e.org <http://horde.org> <
>>>>>>> horde-unsubscribe at lists.**horde.org<horde-unsubscribe at lists.horde.org>
>>>>>>> >
>>>>>>> >
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> This is the of the output of the webmail-install:
>>>>>>
>>>>>> ......
>>>>>> Writing main configuration file... done.
>>>>>> Creating and updating database tables... done.
>>>>>> Configuring administrator settings
>>>>>> Specify an existing mail user who you want to give administrator
>>>>>> permissions (optional): postmaster at mydomain.com
>>>>>> Writing main configuration file... done.
>>>>>> Thank you for using Horde Groupware Webmail Edition!
>>>>>>
>>>>>>
>>>>> Looks fine. How about the configuration interface once you are logged
>>>>> in?
>>>>> Does it show any outdated database schemes?
>>>>>
>>>>>
>>>>> --
>>>>> Jan Schneider
>>>>> The Horde Project
>>>>> http://www.horde.org/
>>>>>
>>>>> --
>>>>> Horde mailing list
>>>>> Frequently Asked Questions: http://horde.org/faq/
>>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.****org<
>>>>> horde-unsubscribe at lists.**horde.org<horde-unsubscribe at lists.horde.org>
>>>>> >
>>>>>
>>>>>
>>>>
>>>> Administration --> Configuration--> all components say "DB schema is
>>>> ready."
>>>>
>>>>
>>>
>>> Hi,
>>>
>>> i have tried running horde-db-migrate:
>>>
>>> horde-db-migrate --debug /var/www/horde/ingo/migration up
>>> [  INFO  ] Migrating DB up.
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0053s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0030s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0006s)
>>>     SELECT version FROM ingo_schema_info
>>> [  INFO  ] Current ingo schema version: 5
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0019s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0005s)
>>>     SELECT version FROM ingo_schema_info
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0029s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0005s)
>>>     SELECT version FROM ingo_schema_info
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0031s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0006s)
>>>     SELECT version FROM ingo_schema_info
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0028s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0007s)
>>>     SELECT version FROM ingo_schema_info
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0030s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0006s)
>>>     SELECT version FROM ingo_schema_info
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0028s)
>>>     SHOW TABLES
>>> 2012-10-02T12:46:20+02:00 DEBUG: SQL  (0.0005s)
>>>     SELECT version FROM ingo_schema_info
>>> [  INFO  ] Ending ingo schema version: 5
>>>
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>> statement.
>>>
>>> mysql> desc ingo_rules;
>>> +-----------------+-----------**---+------+-----+---------+---**----+
>>> | Field           | Type         | Null | Key | Default | Extra |
>>> +-----------------+-----------**---+------+-----+---------+---**----+
>>> | rule_id         | int(11)      | NO   | PRI | NULL    |       |
>>> | rule_owner      | varchar(255) | NO   | MUL | NULL    |       |
>>> | rule_name       | varchar(255) | NO   |     | NULL    |       |
>>> | rule_action     | int(11)      | NO   |     | NULL    |       |
>>> | rule_value      | varchar(255) | YES  |     | NULL    |       |
>>> | rule_flags      | int(11)      | YES  |     | NULL    |       |
>>> | rule_conditions | longtext     | YES  |     | NULL    |       |
>>> | rule_combine    | int(11)      | YES  |     | NULL    |       |
>>> | rule_stop       | int(11)      | YES  |     | NULL    |       |
>>> | rule_active     | int(11)      | NO   |     | 1       |       |
>>> | rule_order      | int(11)      | NO   |     | 0       |       |
>>> +-----------------+-----------**---+------+-----+---------+---**----+
>>> 11 rows in set (0.00 sec)
>>>
>>> There is not error in the output of horde-db-migrate and the table has
>>> not
>>> change the row rule_id to autoincrement.
>>> I am preparing the upgrade to Horde4, this is not production, i would
>>> like
>>> to have the procedure of upgrade and i need known if there is more people
>>> with this error or if is error only in my installation.
>>>
>>> Can i force, the change of the row type?
>>>
>>> Thank you
>>>
>>
>> This is the log from an already upgraded database. Try again with a Horde
>> 4 database, and watch for the upgrading step 2 IngoUpgradeAutoIncrement.
>>
>>
>> --
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.**org<horde-unsubscribe at lists.horde.org>
>>
>
>
> Hi Jan,
> I have tried with a clean database and all goes well, but i need with my
> users.....
> I dont understand "watch for the upgrading step 2
> IngoUpgradeAutoIncrement", can you explain me it?
>
>
>
>
>
Can i debug the upgrade to known if there is others problems in the upgrade?


More information about the horde mailing list