[horde] Upgrading from 1.x to horde 4
Jan Schneider
jan at horde.org
Tue Oct 2 11:09:38 UTC 2012
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>
>>>>>>>>>>>> >
>>>>>>>>>>>> >
>>>>>>>>>>>> >
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> ¿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>
>>>>>>>>>> >
>>>>>>>>>> >
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 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>
>>>>>>> >
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> 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>>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.**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>
>>>
>>
>>
>> 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/
More information about the horde
mailing list