Question about upgrading ingo

[Patrick Boutilier]

Is there any reason the SQL statement to get the list of users can't be
changed to only include users that actually have any ingo rules? In my
case that drops the number of users that need to be parsed by
convert_prefs_to_sql.php from 112,106 to 16,207 . Am I making a wrong
assumption that only these users will have ingo rules that need upgrading?

Thanks.




'SELECT DISTINCT pref_uid FROM horde_prefs where pref_scope LIKE 'ingo''






 From docs/UPGRADING:


Upgrading Ingo From 1.1.x To 1.2
==================================


This is a non-exhaustive, quick explanation of what has changed between Ingo
version 1.1.x and 1.2.x.


SQL Backend
-----------

An SQL table has been added than can optionally be used as a storage backend
for the filter rules. Using this backend no longer limits the number and
size
of rules.


Execute the provided SQL script to add the table to your database, e.g.::

    mysql --user=root --password=<MySQL-root-password> <db name> <
scripts/sql/ingo.sql

You also have to execute the provided PHP script to migrate the existing
rules
from the preferences backend to the new database table::


    php scripts/upgrades/convert_prefs_to_sql.php < filename

``filename`` is a file that contains a list of users, one username per line.
The username should be the same as how the preferences are stored in the
preferences backend (e.g. usernames may have to be in the form
user@...). You can create such a list with the following MySQL
command::

    mysql --user=root --password=<MySQL-root-password>
--skip-column-names --batch --execute='SELECT DISTINCT pref_uid FROM
horde_prefs' <dbname>




--
Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: ingo-unsubscribe@...

[Jan Schneider]

Zitat von Patrick Boutilier <boutilpj@...>:

> Is there any reason the SQL statement to get the list of users can't be
> changed to only include users that actually have any ingo rules? In my
> case that drops the number of users that need to be parsed by
> convert_prefs_to_sql.php from 112,106 to 16,207 . Am I making a wrong
> assumption that only these users will have ingo rules that need upgrading?
>
> Thanks.
>
>
>
>
> 'SELECT DISTINCT pref_uid FROM horde_prefs where pref_scope LIKE 'ingo''

Yes. But we can't use this by default because your preference backend  
is not necessarily SQL.

Jan.

--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/

--
Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: ingo-unsubscribe@...

[Patrick Boutilier]

Jan Schneider wrote:

> Zitat von Patrick Boutilier <boutilpj@...>:
>
>> Is there any reason the SQL statement to get the list of users can't be
>> changed to only include users that actually have any ingo rules? In my
>> case that drops the number of users that need to be parsed by
>> convert_prefs_to_sql.php from 112,106 to 16,207 . Am I making a wrong
>> assumption that only these users will have ingo rules that need
>> upgrading?
>>
>> Thanks.
>>
>>
>>
>>
>> 'SELECT DISTINCT pref_uid FROM horde_prefs where pref_scope LIKE 'ingo''
>
> Yes. But we can't use this by default because your preference backend is
> not necessarily SQL.
>

That makes sense.

Thanks.



> Jan.
>


[boutilpj.vcf]

---

begin:vcard
fn:Patrick Boutilier
n:Boutilier;Patrick
org:;Nova Scotia Department of Education
adr:;;2021 Brunswick Street;Halifax;NS;B3K 2Y5;Canada
email;internet:boutilpj@...
title:WAN Communications Specialist
tel;work:902-424-6800
tel;fax:[phone]
version:2.1
end:vcard

---

--
Ingo mailing list - Join the hunt: http://horde.org/bounties/#ingo
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: ingo-unsubscribe@...