The mailing list for listmasters using Sympa

[Dan Pritts <address@concealed>]

On Mar 17, 2011, at 9:07 AM, John Dalbec wrote:

> I'm not the OP.  I'm on 3.4.4.3, not 4.0.  So your scripts should allow me 
> to upgrade to 6.1.4?

Should work fine, again though YMMV.  :)

> Also, I think I've found the bug you were talking about on the linked page. 
>  The included_subscriber column is enum('0','1') so MySQL represents '0' 
> internally as 1 and '1' as 2.  When you compare the included_subscriber 
> column to the integer 1, it uses the internal representation to do the 
> comparison.  You can fix this by comparing against the string '1' instead.

wow, i never would have figured this out.  I will update the wiki with this.

> 
> Thanks,
> John
> 
> On 3/16/2011 11:26 PM, Dan Pritts wrote:
>> 
>> On Mar 15, 2011, at 4:35 PM, John Dalbec wrote:
>> 
>>> On the linked page it says you upgraded from 3.4 to 6.1.  Do the scripts 
>>> work for any 6.x version?
>> 
>> your mileage may vary.  :)
>> 
>> AFAIK they should work fine in 6.0 and 6.1.  I do not know what is 
>> changing for 6.2 so I don't know whether they will still work.  I would 
>> guess they would but I dunno.
>> 
>> I also don't know the difference between sympa 3.4 and 4.0, but i suspect 
>> it won't matter.
>> 
>>>  Also, if you want a literal control-M in Perl you should be able to use 
>>> "\r".  Ditto for literal NULs and "\0".
>>> Thanks,
>>> John Dalbec
>>> Software Specialist
>>> Youngstown State University
>>> 
>>> On 3/11/2011 2:46 PM, Dan Pritts wrote:
>>>> I did an upgrade from 3.x to 6.0 but i was too scared to try the upgrade 
>>>> process.
>>>> 
>>>> I wrote some tools, they are described here:
>>>> 
>>>> http://www.sympa.org/contribs/migration_and_archives/danno/index
>>>> 
>>>> On Mar 9, 2011, at 9:19 AM, BJ Walraven wrote:
>>>> 
>>>>> I think you're looking for the upgrading steps when moving to another 
>>>>> server, here:
>>>>> 
>>>>> https://www.sympa.org/manual/upgrading#moving_to_another_server
>>>>> 
>>>>> Specifically, it appears you're missing:
>>>>> 
>>>>> - the /home/sympa/list_data directory that contains list config;
>>>>> - the directory that contains the spools;
>>>>> 
>>>>> Although you'll want to make sure you do all the steps.
>>>>> 
>>>>> That being said, I haven't upgraded from that far back, so I'm not sure 
>>>>> if a move from 4.0 to 6.x will be successful...
>>>>> 
>>>>> Thanks,
>>>>> 
>>>>> BJ Walraven
>>>>> Messaging and Collaboration Systems Administrator
>>>>> Eastern Michigan University - Division of IT
>>>>> address@concealed
>>>>> 
>>>>> 
>>>>> ----- Original Message -----
>>>>> From: "Mail Administrator, Otto J. Makela"<address@concealed>
>>>>> To: address@concealed
>>>>> Sent: Wednesday, March 9, 2011 9:08:48 AM
>>>>> Subject: [sympa-users] Updating Sympa, do I need to become an expert?
>>>>> 
>>>>> I have a couple of old Sympa 4.0.a1 installations that desperately need
>>>>> upgrading, with about a hundred lists each. I've tried following the
>>>>> installation instructions for the new Sympa versions and was able to
>>>>> create a blank working installation.
>>>>> 
>>>>> However, I found that updating (since I really don't want to GUI in all 
>>>>> the
>>>>> information for the mailing lists) seems to be a quite a lot trickier 
>>>>> affair.
>>>>> 
>>>>> I tried restoring a full dump of the old database and then running the 
>>>>> update
>>>>> script on it, before I realized that (at least on the older Sympa), the 
>>>>> actual
>>>>> mailing lists do not seem to be a part of this database. So, where are 
>>>>> they,
>>>>> and why?
>>>>> 
>>>>> I'm sure all this is documented somewhere, but I haven't been able to 
>>>>> figure
>>>>> out where. Unfortunately, I am really too lazy to become an expert on 
>>>>> the
>>>>> internal workings of Sympa, but is it inevitable?
>>>>> 
>>>>> --
>>>>> address@concealed (Mail Administrator, Otto J. Makela)
>>>> 
>>>> 
>>>> danno
>>>> --
>>>> Dan Pritts, Sr. Systems Engineer
>>>> Internet2
>>>> office: +1-734-352-4953 | mobile: +1-734-834-7224
>>>> 
>>>> 
>>>> 
>>> 
>> 
>> Dan Pritts, Sr. Systems Engineer
>> Internet2
>> office: +1-734-352-4953 | mobile: +1-734-834-7224
>> 
>> 
>> 
> 

Dan Pritts, Sr. Systems Engineer
Internet2
office: +1-734-352-4953 | mobile: +1-734-834-7224