Upgrading from 1.7 to the latest version.

Hello all.

I am running 1.7.0 and would like to upgrade to 2.X.  I
tried to run
the 1.7 to 1.7.1 upgrade first but I get an error message
when I
attempt to that. I have dug around the email archives and
other people
have reported the same problem but no solution was put
forward.

I have two questions.

Can I migrate from 1.7 directly to 2.X?

Can I install the 2.X in a separate directory and only make
the
changes needed to the database (using same database)

I presume if I did the latter my preferences would be
carried forward
right? I definitely want to use the same database.

Thanks.

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

Hi Tim,

Tim Uckun wrote:
> Hello all.
> 
> I am running 1.7.0 and would like to upgrade to 2.X.  I
tried to run
> the 1.7 to 1.7.1 upgrade first but I get an error
message when I
> attempt to that. I have dug around the email archives
and other people
> have reported the same problem but no solution was put
forward.

What was the error message?

> I have two questions.
> 
> Can I migrate from 1.7 directly to 2.X?

Between 1.7 and 2.0.0 there are database changes you need to
run and a 
script to change the format of the config file.

> Can I install the 2.X in a separate directory and only
make the
> changes needed to the database (using same database)

Yes, but you will manually need to copy certain settings in
your old 
config files into the new config file.

> I presume if I did the latter my preferences would be
carried forward
> right? I definitely want to use the same database.

Which preferences are you referring to?

Best Regards,
-- 
Bryan Alsdorf, Manager of Support Systems
MySQL AB, www.mysql.com

Discover new MySQL Monitoring & Advisory features at:
http://www.mysql.com/products/enterprise/whats_new.html

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

> >
> > I am running 1.7.0 and would like to upgrade to
2.X.  I tried to run
> > the 1.7 to 1.7.1 upgrade first but I get an error
message when I
> > attempt to that. I have dug around the email
archives and other people
> > have reported the same problem but no solution was
put forward.
>
> What was the error message?


Here is what I did. I untarred the 1.7.1 file and copied the
files
over my old install. I then navigated to the
misc/upgrade/v1.7.0_to_v1.7.1/  URL and clicked on the
"upgrade the
configuration file" link

It redirected me to a URL like
eventum/misc/upgrade/v1.7.0_to_v1.7.1/setup/ which gave a
NOT FOUND
error.

I figured that was supposed to be /setup and not
/misc/upgrade/v1.7.0_to_v1.7.1/setup/ so I changed the URL
manually to
/setup

This gave me a FORBIDDEN error. Sure enough the permissions
on the
setup folder are

d--x------   2 root     wheel     4096 Feb 23  2006 setup/

So I set the permissions to 777 just for giggles and ran the
URL
again. This time I get the following errors

Warning: Unknown(/var/www/html/eventum/setup/index.php):
failed to
open stream: Permission denied in Unknown on line 0

Warning: (null)(): Failed opening
'/var/www/html/eventum/setup/index.php' for inclusion
(include_path='.:/usr/share/pear') in Unknown on line 0



> > Can I migrate from 1.7 directly to 2.X?
>
> Between 1.7 and 2.0.0 there are database changes you
need to run and a
> script to change the format of the config file.
>
> > Can I install the 2.X in a separate directory and
only make the
> > changes needed to the database (using same
database)
>
> Yes, but you will manually need to copy certain
settings in your old
> config files into the new config file.


I think I will try this method next.

Is there a document which explains what the database changes
are and
what setting need to be migrated?

Thanks.

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

Hi Tim,

Tim Uckun wrote:
>>> I am running 1.7.0 and would like to upgrade to
2.X.  I tried to run
>>> the 1.7 to 1.7.1 upgrade first but I get an
error message when I
>>> attempt to that. I have dug around the email
archives and other people
>>> have reported the same problem but no solution
was put forward.
>> What was the error message?
> 
> 
> Here is what I did. I untarred the 1.7.1 file and
copied the files
> over my old install. I then navigated to the
> misc/upgrade/v1.7.0_to_v1.7.1/  URL and clicked on the
"upgrade the
> configuration file" link
> 
> It redirected me to a URL like
> eventum/misc/upgrade/v1.7.0_to_v1.7.1/setup/ which gave
a NOT FOUND
> error.

After extracting 1.7.1 you will need to copy your old
config.inc.php and 
setup.conf.php. This was one of the short comings of the 1.x
series. 
After you upgrade to 2.0 the upgrade is a bit easier.

> I figured that was supposed to be /setup and not
> /misc/upgrade/v1.7.0_to_v1.7.1/setup/ so I changed the
URL manually to
> /setup
> 
> This gave me a FORBIDDEN error. Sure enough the
permissions on the
> setup folder are
> 
> d--x------   2 root     wheel     4096 Feb 23  2006
setup/
> 
> So I set the permissions to 777 just for giggles and
ran the URL
> again. This time I get the following errors
> 
> Warning:
Unknown(/var/www/html/eventum/setup/index.php): failed to
> open stream: Permission denied in Unknown on line 0
> 
> Warning: (null)(): Failed opening
> '/var/www/html/eventum/setup/index.php' for inclusion
> (include_path='.:/usr/share/pear') in Unknown on line
0
> 
>>> Can I migrate from 1.7 directly to 2.X?
>> Between 1.7 and 2.0.0 there are database changes
you need to run and a
>> script to change the format of the config file.
>>
>>> Can I install the 2.X in a separate directory
and only make the
>>> changes needed to the database (using same
database)
>> Yes, but you will manually need to copy certain
settings in your old
>> config files into the new config file.
> 
> I think I will try this method next.
> 
> Is there a document which explains what the database
changes are and
> what setting need to be migrated?

No document, the database changes are all in 
misc/upgrade/vX_to_vY/database_changes.php

We are working on releasing 2.1 right now, but if you
upgrade to 2.0.1 
upgrading to 2.1 should be trivial.

Best Regards,
-- 
Bryan Alsdorf, Manager of Support Systems
MySQL AB, www.mysql.com

Discover new MySQL Monitoring & Advisory features at:
http://www.mysql.com/products/enterprise/whats_new.html

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

>
> After extracting 1.7.1 you will need to copy your old
config.inc.php and
> setup.conf.php. This was one of the short comings of
the 1.x series.
> After you upgrade to 2.0 the upgrade is a bit easier.

Thanks for the instant reply!!.

Where do I copy these files to?

I would rather go through an orderly upgrade if at all
possible.


> >
> > Is there a document which explains what the
database changes are and
> > what setting need to be migrated?
>
> No document, the database changes are all in
> misc/upgrade/vX_to_vY/database_changes.php


How about the config file changes? Can I just run the
install program
and enter my setting again without harming the the data (is
it
destructive to the existing database?)

>
> We are working on releasing 2.1 right now, but if you
upgrade to 2.0.1
> upgrading to 2.1 should be trivial.
>
>

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

Hi,

Tim Uckun wrote:
>> After extracting 1.7.1 you will need to copy your
old config.inc.php and
>> setup.conf.php. This was one of the short comings
of the 1.x series.
>> After you upgrade to 2.0 the upgrade is a bit
easier.
> 
> Thanks for the instant reply!!.
> 
> Where do I copy these files to?

These files would need to be copied back to Eventum's main
directory, 
over writing the new config.inc.php and setup.conf.php that
the 1.7.1 files.

> I would rather go through an orderly upgrade if at all
possible.
> 
> 
>>> Is there a document which explains what the
database changes are and
>>> what setting need to be migrated?
>> No document, the database changes are all in
>> misc/upgrade/vX_to_vY/database_changes.php
> 
> 
> How about the config file changes? Can I just run the
install program
> and enter my setting again without harming the the data
(is it
> destructive to the existing database?)

The setup program will try to create a new database / tables
depending 
on your options and if you check a certain box will drop old
tables. You 
can point it to a database of a different name and then
change the 
config file to point to the old database before running the
upgrade scripts.

Best Regards,
-- 
Bryan Alsdorf, Manager of Support Systems
MySQL AB, www.mysql.com

Discover new MySQL Monitoring & Advisory features at:
http://www.mysql.com/products/enterprise/whats_new.html

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com

For the benefit of all this is what you need to do in order
to upgrade
from 1.7.0 to 1.7.1

cp -r /tmp/eventum/eventum-1.7.1/* /var/www/html/eventum/
cp -rp /tmp/eventum/eventum_backup/config.inc.php
/var/www/html/eventum/
cp -rp /tmp/eventum/eventum_backup/setup.conf.php
/var/www/html/eventum/setup/
chmod -R  777 /var/www/html/eventum/setup
rm /var/www/html/eventum/config.inc.pre_1_7_1.php

Once you are done with all that you can run

eventum.url.com/misc/upgrade/v1.7.0_to_v1.7.1/

Somebody might want to update the documentation because the
current
one doesn't work.

Next up I will be trying to move to 2.0, with me luck.

-- 
Eventum Developers Mailing List
For list archives: http://lists.mys
ql.com/eventum-devel
To unsubscribe:    htt
p://lists.mysql.com/eventum-devel?unsub=nesstosharedlog.com