[horde] Upgrading from 1.x to horde 4
Paul Ronald
jhon.higgins at gmail.com
Tue Oct 2 12:42:22 UTC 2012
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?
More information about the horde
mailing list