The mailing list for listmasters using Sympa

[John Dalbec <address@concealed>]

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?

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.

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