[ingo] Problems with convert_prefs_to_sql.php

[Arminas]

Hi again,

here is my ingo tables from database:
ingo_forwards
 ingo_lists
 ingo_rules
 ingo_rules_seq
 ingo_shares
 ingo_shares_groups
 ingo_shares_users
 ingo_spam
 ingo_vacations

I have old table horde_prefs (2.2.9) . But the script doesn't work: #
php convert_prefs_to_sql.php < filename

in file "filename" there are all user's id (owner id)..

Br,
Arminas

2008/6/6 Michael Menge <michael.menge at zdv.uni-tuebingen.de>:
> Hi
>
> Quoting Arminas <g.arminas at gmail.com>:
>
>> Sry if im disturbing you, but is this script for moving rules from
>> horde_prefs to ingo_rules? :) I've tried to use this for my own
>> purposes but it didnt worked (all cells empty in ingo_rules). So here
>> is my question again: is this for moving rules from horde_prefs to
>> ingo_rules table?
>>
>
>
> Yes it is for moving. Read docs/UPGRADING for infos how to use it.
> If you find entries in ingo_lists, ingo_vacation, ingo_forwards or ingo_spam
> you may have the same problem that ingo_rules_seq is not created on demand.
>
>
>> 2008/6/6 Michael Menge <michael.menge at zdv.uni-tuebingen.de>:
>>>
>>> I solved most of the problems
>>>
>>> ingo_rules_seq was not created on demand. After creating it by hand
>>> the memoryusage ist still growing, but is much smaller now.
>>> The rules are converted as expected and shown on the webpage.
>>>
>>> The 2. problem still exists
>>>
>>> Quoting Michael Menge <michael.menge at zdv.uni-tuebingen.de>:
>>>
>>>> Hi,
>>>>
>>>> We are in the proces of testing the new Horde-3.2 and Ingo-1.2.
>>>> During the migration to the new SQL-Storage we encounterd some problems.
>>>>
>>>> 1. the memory usage of convert_prefs_to_sql.php is huge. The script
>>>> hit the memorylimmit of 2GB after converting about 4500 users. We can
>>>> split the users ins smaller packages but there might be some other
>>>> probles und the memory usage is only the symptom and not the real
>>>> problem.
>>>>
>>>> 2. The output of the script is only done at the end of the script,  so
>>>> we
>>>> don't
>>>> see any progress during the converting process.
>>>>
>>>> 3. White-/Blacklists, Vacations and Forwards are convertet but there
>>>> are no entries in ingo_rules. Is a sequence needed for the migration,
>>>> we had the problem that the sequences where not created on demand, but
>>>> we didn't see the
>>>> error messages saw with the SQL share driver.
>>>>
>>>> 4. going to ingos filter-page shows no filters at all. Editing
>>>> White-/Blacklists, Vacation or Forwards is possible by using the top
>>>> menue.
>>>> But filter-page stays empty and the created script only contains the
>>>> leading
>>>> comments. Switching back to the Pref-Storage works without problems.
>>>>
>>>> Has anybody had the same problems? And/or knows how to solve them?
>>>>
>>>> Regards
>>>>
>>>>      Michael Menge
>>>>
>>>>
>>>>
>>>> --------------------------------------------------------------------------------
>>>> M.Menge                                 Tel.: (49) 7071/29-70316
>>>> Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
>>>> Zentrum fuer Datenverarbeitung          mail:
>>>> michael.menge at zdv.uni-tuebingen.de
>>>> Waechterstrasse 76
>>>> 72074 Tuebingen
>>>
>>>
>>>
>>>
>>> --------------------------------------------------------------------------------
>>> M.Menge                                 Tel.: (49) 7071/29-70316
>>> Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
>>> Zentrum fuer Datenverarbeitung          mail:
>>> michael.menge at zdv.uni-tuebingen.de
>>> Waechterstrasse 76
>>> 72074 Tuebingen
>>>
>>> --
>>> Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
>>> Frequently Asked Questions: http://horde.org/faq/
>>> To unsubscribe, mail: ingo-unsubscribe at lists.horde.org
>>>
>>>
>> --
>> Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: ingo-unsubscribe at lists.horde.org
>>
>
>
>
> --------------------------------------------------------------------------------
> M.Menge                                 Tel.: (49) 7071/29-70316
> Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
> Zentrum fuer Datenverarbeitung          mail:
> michael.menge at zdv.uni-tuebingen.de
> Waechterstrasse 76
> 72074 Tuebingen
>
> --
> Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: ingo-unsubscribe at lists.horde.org
>
>