[horde] Ingo rules not getting migrated

[Jan Schneider]

Zitat von John H. Bennett III <bennettj at thebennetthome.com>:

> Quoting Jan Schneider <jan at horde.org>:
>
>> Zitat von John H. Bennett III <bennettj at thebennetthome.com>:
>>
>>> Quoting Jan Schneider <jan at horde.org>:
>>>
>>>> Zitat von John H. Bennett III <bennettj at thebennetthome.com>:
>>>>
>>>>> Quoting "John H. Bennett III" <bennettj at thebennetthome.com>:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> Getting ready to migrate from horde 3 to latest horde 5, and I  
>>>>>> noticed during my tests, that none of my ingo rules, or  
>>>>>> whitelist/blacklist entries are being migrated.
>>>>>>
>>>>>> Before the migration, I see the rules in the horde_prefs  
>>>>>> tables.  pref_scope is ingo, pref_name is rules and pref_value  
>>>>>> has various entries. Whitelist entries are there with whitelist  
>>>>>> pref_name, and blacklist entries with blacklist pref_name.
>>>>>>
>>>>>> After the migration horde_prefs show pref_scope and name are  
>>>>>> the same, but under pref_value is [BLOB - 256 B].
>>>>>>
>>>>>> If I create a new rule, it does get placed in the ingo_rules  
>>>>>> table and is visible.  Creating a new white/black list is  
>>>>>> stored in the ingo_lists table.
>>>>>>
>>>>>> What have I missed in getting my rules migrated?
>>>>>>
>>>>>> Thank you,
>>>>>>
>>>>>> John
>>>>>>
>>>>>
>>>>> Got a little further today.  I changed the ingo storage driver  
>>>>> back to prefs and everything shows back up.  I had been using  
>>>>> the sql driver as I thought I had migrated the ingo filters to  
>>>>> use sql using the ingo-convert-prefs-to-sql script.  I ran that  
>>>>> by piping a filename that contained all of my users.  Have I  
>>>>> missed a step in getting my ingo filter rules migrated to sql?
>>>>>
>>>>> Thanks again,
>>>>>
>>>>> John
>>>>
>>>> The script tells you which users it is migrating and whether it succeeded.
>>>>
>>>> -- 
>>>> Jan Schneider
>>>> The Horde Project
>>>> http://www.horde.org/
>>>> https://www.facebook.com/hordeproject
>>>>
>>>> -- 
>>>> Horde mailing list
>>>> Frequently Asked Questions: http://horde.org/faq/
>>>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>>
>>>
>>> Yes, it does, and it says they have been converted.
>>>
>>> Here are my steps:
>>>
>>> 1. Login to horde, check ingo.  All Filters are there.
>>>
>>> 2. Execute script
>>>
>>> [root at www ~]# php /usr/bin/ingo-convert-prefs-to-sql < users.list
>>>
>>>    ====================
>>>
>>>    Fatal Error:
>>>    You need to configure an SQL storage backend in Ingo's configuration
>>>
>>>    1. Horde_Cli->fatal() /usr/bin/ingo-convert-prefs-to-sql:36
>>>
>>>
>>> 3. Above is known error, but ran just to show that it won't run  
>>> until you change ingo/conf.php
>>>
>>> from:  $conf['storage']['driver'] = 'prefs';
>>> to:    $conf['storage']['driver'] = 'sql';
>>>
>>>
>>> 4. Execute script
>>>
>>>    [root at www ~]# php /usr/bin/ingo-convert-prefs-to-sql < users.list
>>>    Converting filters for user: bennettj at mytest.com.....done
>>
>> Are you sure this is your internal Horde user name?
>>
>
> For this test server, yes.  Even when I go to the portal page, it  
> show's my name as I set it up per my identity, then  
> <bennettj at mytest.com>.  I'm setting a new test server up and can try  
> something else if you have any ideas.  I didn't have that many  
> rules, and can re-create them, I'm just really trying to figure what  
> went wrong with my upgrade and trying to use sql as the driver.
>
>>> On my system, user at domain is how things are saved in mysql.
>>>
>>> 5. Logout and back in to horde.  No filters are shown.
>>>
>>> John
>>
>>
>>
>> -- 
>> Jan Schneider
>> The Horde Project
>> http://www.horde.org/
>> https://www.facebook.com/hordeproject
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org

Enable debug logging so that you see the actual SQL queries. Then  
compare them with what you have in ingo_rules.

-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject