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