I need administrator access to our schooltool database

Asked by Trevor Joefield on 2010-07-10

I am working with a fisheries training institute that is using schooltool to maintain it student records. The database has records dating back for a number of years. When I started working with the institute I discovered that only one person had access to the database and he logs on as a user.

We need to move the database to a new server. We loaded a new version of schooltool-2009 on Ubuntu 10.04 and need to populate it with data existing in the previous version of schooltool (I cannot even tell what version that is, its data is stored i a file called data.fs with no version specified)

We tried copying this file and moving it to the data file of the new installation but that generated error when we tried starting schooltool. We concluded that we need to log on to the existing schooltool as an administrator, export the data as an XLS file and subsequently import the XLS file into the new installation. To do so we need administrative access.

Is this the correct way to populate the new installation? If not what is a better way to do so? Must we have administrative access to get our data out of the existing schooltool installation? If we must have administrative access, how do we create an account with administrative access? The current installation of schooltool is on Fedora 2.6

Any assistance received would be greatly appreciated.

Trevor

Question information

Language:
Spanish (Mexico) Edit question
Status:
Solved
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Solved by:
Justas Sadzevičius
Solved:
2010-08-14
Last query:
2010-08-14
Last reply:
2010-08-02
Tom Hoffman (tom-hoffman) said : #1

We'll get back to you about this question next week.

Can you please paste the following logs from the server running Ubuntu 10.4 after it generates errors (I'm assuming you installed SchoolTool via debs, Synaptic package manager or apt):
/var/log/schooltool/paste.log
/var/log/schooltool/schooltool-2009-error.log

Provided you have access to the old server, database version is specified in XXX/schooltool/generations/__init__.py , here XXX is the location of schooltool python sources.

Also the version of SchoolTool can be found at the bottom of every page of SchoolTool, near the copyright.

Thanks

Trevor Joefield (tjoefield) said : #3

Hi Justas,

Here is the log from the server with Ubuntu:

Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
INFO:zope.app.generations:main db/schooltool: running install generation
INFO:zope.app.generations:main db/schooltool.gradebook: running install generation
INFO:zope.app.generations:main db/schooltool.intervention: running install generation
INFO:zope.app.generations:main db/schooltool.stapp2008fall: running install generation
INFO:zope.app.generations:main db/zope.app: running install generation
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
WARNING:ZODB.FileStorage:Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/schooltool/schooltool-2009-Data.fs'
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/schooltool/schooltool-2009-Data.fs'
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM

Trevor

Trevor Joefield (tjoefield) said : #4

Justas

This is the schooltool-2009 error log file

2010-07-08 12:25:42,750 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 12:25:42,755 main db/schooltool: running install generation
2010-07-08 12:25:42,759 main db/schooltool.gradebook: running install generation
2010-07-08 12:25:42,777 main db/schooltool.intervention: running install generation
2010-07-08 12:25:42,821 main db/schooltool.stapp2008fall: running install generation
2010-07-08 12:25:42,842 main db/zope.app: running install generation
2010-07-08 13:05:59,399 Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
2010-07-08 13:05:59,445 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 13:16:14,734 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 19:37:48,969 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 20:12:18,825 main db: evolving in mode EVOLVEMINIMUM

Thanks for your help with determining the version of schooltool

Trevor

This seems to be the problem:
> Could not initialize the database:
> [Errno 13] Permission denied: '/var/lib/schooltool/schooltool-2009-Data.fs'

You have to copy the database again, and set the correct permissions from terminal (you'll need admin rights)

$ sudo /etc/init.d/schooltool-2009 stop
$ ... copy the data fs
$ sudo chown schooltool:schooltool /var/lib/schooltool/schooltool-2009-Data.fs
$ sudo chmod 640 /var/lib/schooltool/schooltool-2009-Data.fs
$ sudo /etc/init.d/schooltool-2009 start

If it's still not working, please add error and paste logs again.

Best of luck

Trevor Joefield (tjoefield) said : #6

Hi Justas,

I'm new to Linux so I'm not sure I got the second line right. Which data fs to copy. I have placed the data.fs file which I got from the existing schooltool database into the same directory of the schooltool-2009. Subsequently I renamed the data.fs files as follows:
1. The existing schooltool-2009-data.fs > schooltool-2009-data2.fs
2. The data.fs file which I got from the old database was renamed to schooltool-2009-data.fs
3. I ran lines 3, 4 and 5. It said ok to the start schooltool line
4. When I tried to browse I got an error saying unable to connect
5. When I attempted to stop school tool again I got the following error message on terminal

No PID file exists in /var/run/schooltool/schooltool-2009.pid
Could not stop daemon

I guess that I'm still doing something wrong.

When I copied the data.fs file from the existing schooltool database did I need to also copy the other files in the directory like the Index file etc?

Thanks again

Trevor

It looks like you did everything right. Copying Data.fs is enough, indexes and so on are rebuilt automatically.

No PID file when stopping means that SchoolTool failed to start.
$ sudo /etc/init.d/schooltool-2009 status
might be helpful in such cases.

Probably the Data.fs is really old, and it failed to run. Please paste again:
/var/log/schooltool/paste.log
/var/log/schooltool/schooltool-2009-error.log

Thanks

Trevor Joefield (tjoefield) said : #8

Hi Justas,

Here is the paste log

Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
INFO:zope.app.generations:main db/schooltool: running install generation
INFO:zope.app.generations:main db/schooltool.gradebook: running install generation
INFO:zope.app.generations:main db/schooltool.intervention: running install generation
INFO:zope.app.generations:main db/schooltool.stapp2008fall: running install generation
INFO:zope.app.generations:main db/zope.app: running install generation
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
WARNING:ZODB.FileStorage:Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/schooltool/schooltool-2009-Data.fs'
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/schooltool/schooltool-2009-Data.fs'
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
WARNING:ZopePublication:Competing writes/reads at /: database conflict error (oid 0xe0, class BTrees.OOBTree.OOBTree, serial this txn started with 0x038762de366361cc 2010-07-09 02:38:12.747237, serial currently committed 0x03876b0df6f44144 2010-07-10 13:33:57.879872)
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
WARNING:ZODB.FileStorage:Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
INFO:zope.app.generations:main db/schooltool: currently at generation 3, targetting generation 34
ERROR:zope.app.generations:main db/schooltool: failed to evolve to generation 4
Traceback (most recent call last):
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 494, in evolve
    manager.evolve(context, generation)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 145, in evolve
    evolver.evolve(context)
  File "/usr/lib/python2.6/dist-packages/schooltool/generations/evolve1.py", line 24, in evolve
    raise NotImplementedError("Evolving from versions prior to 2008.04 is not"
NotImplementedError: Evolving from versions prior to 2008.04 is not supported! Please upgrade to SchoolTool version 2008.04 first.
Traceback (most recent call last):
  File "/usr/bin/paster", line 18, in <module>
    command.run()
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 84, in run
    invoke(command, command_name, options, args[1:])
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 123, in invoke
    exit_code = runner.run(args)
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 218, in run
    result = self.command()
  File "/usr/lib/pymodules/python2.6/paste/script/serve.py", line 276, in command
    relative_to=base, global_conf=vars)
  File "/usr/lib/pymodules/python2.6/paste/script/serve.py", line 313, in loadapp
    **kw)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 204, in loadapp
    return loadobj(APP, uri, name=name, **kw)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 225, in loadobj
    return context.create()
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 625, in create
    return self.object_type.invoke(self)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 110, in invoke
    return fix_call(context.object, context.global_conf, **context.local_conf)
  File "/usr/lib/pymodules/python2.6/paste/deploy/util/fixtypeerror.py", line 57, in fix_call
    val = callable(*args, **kw)
  File "/usr/lib/python2.6/dist-packages/schooltool/paste/main.py", line 48, in schooltool_app_factory
    os.path.join(global_conf['here'], config_file))
  File "/usr/lib/python2.6/dist-packages/schooltool/paste/main.py", line 37, in __init__
    db = self.setup(options)
  File "/usr/lib/python2.6/dist-packages/schooltool/app/main.py", line 704, in setup
    notify(DatabaseOpened(db))
  File "/usr/lib/python2.6/dist-packages/zope/event/__init__.py", line 23, in notify
    subscriber(event)
  File "/usr/lib/python2.6/dist-packages/zope/component/event.py", line 26, in dispatch
    zope.component.subscribers(event, None)
  File "/usr/lib/python2.6/dist-packages/zope/component/_api.py", line 138, in subscribers
    return sitemanager.subscribers(objects, interface)
  File "/usr/lib/python2.6/dist-packages/zope/component/registry.py", line 323, in subscribers
    return self.adapters.subscribers(objects, provided)
  File "/usr/lib/python2.6/dist-packages/zope/interface/adapter.py", line 575, in subscribers
    subscription(*objects)
  File "/usr/lib/python2.6/dist-packages/zope/app/appsetup/bootstrap.py", line 175, in bootStrapSubscriber
    zope.event.notify(zope.processlifetime.DatabaseOpenedWithRoot(db))
  File "/usr/lib/python2.6/dist-packages/zope/event/__init__.py", line 23, in notify
    subscriber(event)
  File "/usr/lib/python2.6/dist-packages/zope/component/event.py", line 26, in dispatch
    zope.component.subscribers(event, None)
  File "/usr/lib/python2.6/dist-packages/zope/component/_api.py", line 138, in subscribers
    return sitemanager.subscribers(objects, interface)
  File "/usr/lib/python2.6/dist-packages/zope/component/registry.py", line 323, in subscribers
    return self.adapters.subscribers(objects, provided)
  File "/usr/lib/python2.6/dist-packages/zope/interface/adapter.py", line 575, in subscribers
    subscription(*objects)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 521, in evolveMinimumSubscriber
    evolve(event.database, EVOLVEMINIMUM)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 506, in evolve
    manager.generation)
zope.app.generations.interfaces.UnableToEvolve: (4, u'schooltool', 34)
Reading configuration from /etc/schooltool/schooltool-2009/main.conf
/usr/lib/pymodules/python2.6/pyPdf/pdf.py:52: DeprecationWarning: the sets module is deprecated
  from sets import ImmutableSet
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
INFO:zope.app.generations:main db: evolving in mode EVOLVEMINIMUM
INFO:zope.app.generations:main db/schooltool: currently at generation 3, targetting generation 34
ERROR:zope.app.generations:main db/schooltool: failed to evolve to generation 4
Traceback (most recent call last):
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 494, in evolve
    manager.evolve(context, generation)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 145, in evolve
    evolver.evolve(context)
  File "/usr/lib/python2.6/dist-packages/schooltool/generations/evolve1.py", line 24, in evolve
    raise NotImplementedError("Evolving from versions prior to 2008.04 is not"
NotImplementedError: Evolving from versions prior to 2008.04 is not supported! Please upgrade to SchoolTool version 2008.04 first.
Traceback (most recent call last):
  File "/usr/bin/paster", line 18, in <module>
    command.run()
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 84, in run
    invoke(command, command_name, options, args[1:])
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 123, in invoke
    exit_code = runner.run(args)
  File "/usr/lib/pymodules/python2.6/paste/script/command.py", line 218, in run
    result = self.command()
  File "/usr/lib/pymodules/python2.6/paste/script/serve.py", line 276, in command
    relative_to=base, global_conf=vars)
  File "/usr/lib/pymodules/python2.6/paste/script/serve.py", line 313, in loadapp
    **kw)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 204, in loadapp
    return loadobj(APP, uri, name=name, **kw)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 225, in loadobj
    return context.create()
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 625, in create
    return self.object_type.invoke(self)
  File "/usr/lib/pymodules/python2.6/paste/deploy/loadwsgi.py", line 110, in invoke
    return fix_call(context.object, context.global_conf, **context.local_conf)
  File "/usr/lib/pymodules/python2.6/paste/deploy/util/fixtypeerror.py", line 57, in fix_call
    val = callable(*args, **kw)
  File "/usr/lib/python2.6/dist-packages/schooltool/paste/main.py", line 48, in schooltool_app_factory
    os.path.join(global_conf['here'], config_file))
  File "/usr/lib/python2.6/dist-packages/schooltool/paste/main.py", line 37, in __init__
    db = self.setup(options)
  File "/usr/lib/python2.6/dist-packages/schooltool/app/main.py", line 704, in setup
    notify(DatabaseOpened(db))
  File "/usr/lib/python2.6/dist-packages/zope/event/__init__.py", line 23, in notify
    subscriber(event)
  File "/usr/lib/python2.6/dist-packages/zope/component/event.py", line 26, in dispatch
    zope.component.subscribers(event, None)
  File "/usr/lib/python2.6/dist-packages/zope/component/_api.py", line 138, in subscribers
    return sitemanager.subscribers(objects, interface)
  File "/usr/lib/python2.6/dist-packages/zope/component/registry.py", line 323, in subscribers
    return self.adapters.subscribers(objects, provided)
  File "/usr/lib/python2.6/dist-packages/zope/interface/adapter.py", line 575, in subscribers
    subscription(*objects)
  File "/usr/lib/python2.6/dist-packages/zope/app/appsetup/bootstrap.py", line 175, in bootStrapSubscriber
    zope.event.notify(zope.processlifetime.DatabaseOpenedWithRoot(db))
  File "/usr/lib/python2.6/dist-packages/zope/event/__init__.py", line 23, in notify
    subscriber(event)
  File "/usr/lib/python2.6/dist-packages/zope/component/event.py", line 26, in dispatch
    zope.component.subscribers(event, None)
  File "/usr/lib/python2.6/dist-packages/zope/component/_api.py", line 138, in subscribers
    return sitemanager.subscribers(objects, interface)
  File "/usr/lib/python2.6/dist-packages/zope/component/registry.py", line 323, in subscribers
    return self.adapters.subscribers(objects, provided)
  File "/usr/lib/python2.6/dist-packages/zope/interface/adapter.py", line 575, in subscribers
    subscription(*objects)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 521, in evolveMinimumSubscriber
    evolve(event.database, EVOLVEMINIMUM)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 506, in evolve
    manager.generation)
zope.app.generations.interfaces.UnableToEvolve: (4, u'schooltool', 34)

And here is the schooltool-2009 error log

2010-07-08 12:25:42,750 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 12:25:42,755 main db/schooltool: running install generation
2010-07-08 12:25:42,759 main db/schooltool.gradebook: running install generation
2010-07-08 12:25:42,777 main db/schooltool.intervention: running install generation
2010-07-08 12:25:42,821 main db/schooltool.stapp2008fall: running install generation
2010-07-08 12:25:42,842 main db/zope.app: running install generation
2010-07-08 13:05:59,399 Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
2010-07-08 13:05:59,445 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 13:16:14,734 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 19:37:48,969 main db: evolving in mode EVOLVEMINIMUM
2010-07-08 20:12:18,825 main db: evolving in mode EVOLVEMINIMUM
2010-07-10 06:34:08,899 Competing writes/reads at /: database conflict error (oid 0xe0, class BTrees.OOBTree.OOBTree, serial this txn started with 0x038762de366361cc 2010-07-09 02:38:12.747237, serial currently committed 0x03876b0df6f44144 2010-07-10 13:33:57.879872)
2010-07-10 11:18:08,783 main db: evolving in mode EVOLVEMINIMUM
2010-07-10 11:23:26,652 Ignoring index for /var/lib/schooltool/schooltool-2009-Data.fs
2010-07-10 11:23:51,152 main db: evolving in mode EVOLVEMINIMUM
2010-07-10 11:23:51,155 main db/schooltool: currently at generation 3, targetting generation 34
2010-07-10 11:23:51,194 main db/schooltool: failed to evolve to generation 4
Traceback (most recent call last):
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 494, in evolve
    manager.evolve(context, generation)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 145, in evolve
    evolver.evolve(context)
  File "/usr/lib/python2.6/dist-packages/schooltool/generations/evolve1.py", line 24, in evolve
    raise NotImplementedError("Evolving from versions prior to 2008.04 is not"
NotImplementedError: Evolving from versions prior to 2008.04 is not supported! Please upgrade to SchoolTool version 2008.04 first.
2010-07-10 11:26:27,262 main db: evolving in mode EVOLVEMINIMUM
2010-07-10 11:26:27,346 main db/schooltool: currently at generation 3, targetting generation 34
2010-07-10 11:26:27,499 main db/schooltool: failed to evolve to generation 4
Traceback (most recent call last):
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 494, in evolve
    manager.evolve(context, generation)
  File "/usr/lib/python2.6/dist-packages/zope/app/generations/generations.py", line 145, in evolve
    evolver.evolve(context)
  File "/usr/lib/python2.6/dist-packages/schooltool/generations/evolve1.py", line 24, in evolve
    raise NotImplementedError("Evolving from versions prior to 2008.04 is not"
NotImplementedError: Evolving from versions prior to 2008.04 is not supported! Please upgrade to SchoolTool version 2008.04 first.

Thanks again for your continued assistance in helping us to solve this problem!

Trevor

This is a very old database (dating mid 2005 it seems), it needs to be updated in SchoolTool 2008.04 before it can be run with SchoolTool 2010.04.

Unfortunately packages installable in Ubuntu Hardy (2008.04) currently cannot update the old databases (that stopped working some time in 2009-2010). We will work out instructions (and do fixes if needed) on updating databases as old as this one.

Eventually you'll likely need to install the old Ubuntu release to evolve the database to 2008.04, and only then use it in Lucid.

Current SchoolTool upgrade policy is same as Ubuntu: you can upgrade releases matching Ubuntu Long Term Support releases (2008.04 -> 2010.04) or follow the sequential path (2008.04->2008.10->2009.04->2009.10->2010.04), but we do not support jumping non-LTS upgrades (e.g. 2008.10->2009.10).

Tom Hoffman (tom-hoffman) said : #10

What data do you need out of this system specifically?

Trevor Joefield (tjoefield) said : #11

Hi Tom,

The existing database has records from 1997 to .2010. We would like to
migrate all of these records to schooltool-2009.

Through the help of your colleague Justas, we realise that the current
version of schooltool is Schooltool v0.11.3

We do not have administrative access to the database. It is currently
slowing down daily and data entry is becoming a very tedious exercise.
Additionally we have upgraded our network and needed to relocate schooltool
database. We are also looking to make the database accessible to our
students via the internet. However with the current performance of the
database we have planned the migration as our first approach.

Hence specifically, we need to migrate the data from the existing schooltool
database to schooltool-2009

Thanks for all the help given to date, especially from Justas

Trevor

On 12 July 2010 09:31, Tom Hoffman <email address hidden>wrote:

> Your question #117206 on SchoolTool changed:
> https://answers.edge.launchpad.net/schooltool/+question/117206
>
> Status: Open => Needs information
>
> Tom Hoffman requested for more information:
> What data do you need out of this system specifically?
>
> --
> To answer this request for more information, you can either reply to
> this email or enter your reply at the following page:
> https://answers.edge.launchpad.net/schooltool/+question/117206
>
> You received this question notification because you are a direct
> subscriber of the question.
>

Tom Hoffman (tom-hoffman) said : #12

Hi Trevor,

Yes, but *what* data are you storing in it?

Trevor Joefield (tjoefield) said : #13

Tom,

Cftdi is using the database to store student information for the persons they train. The students attend shoprt courses for one or two weeks duration. Course name, date, student info, course lecturers, student photos are stored. I hope this clears things up some more.

Trevor
------Original Message------
From: Tom Hoffman
Sender: <email address hidden>
To: <email address hidden>
ReplyTo: <email address hidden>
Subject: Re: [Question #117206]: I need administrator access to our schooltooldatabase
Sent: Jul 12, 2010 10:55 AM

Your question #117206 on SchoolTool changed:
https://answers.edge.launchpad.net/schooltool/+question/117206

    Status: Open => Needs information

Tom Hoffman requested for more information:
Hi Trevor,

Yes, but *what* data are you storing in it?

--
To answer this request for more information, you can either reply to
this email or enter your reply at the following page:
https://answers.edge.launchpad.net/schooltool/+question/117206

You received this question notification because you are a direct
subscriber of the question.

Sent from my BlackBerry® device from Digicel

Trevor Joefield (tjoefield) said : #14

Thanks very much Justas. I realise that I have a lot more work to do than I first anticipated. I will undertake the task of loading the older version of Ubuntu and schooltool and subsequently attempt the upgrade. I will keep you inform on our progress.

Trevor Joefield (tjoefield) said : #15

Hi Tom/Justas,

I Ubuntu 6.06.1 desktop i386 and subsequently installed schooltool. At the end of the installation process i am getting the following message...

.......Setting up schooltool (0.11.4-1build1) ...
 * Starting SchoolTool... Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
                                                                         [ ok ]

Setting up python-docutils (0.4-1ubuntu1) ...

tjoefield@tjoefield-Ubuntu:~$ sudo schooltool stop
Reading configuration from /etc/schooltool/schooltool.conf
Warning: font directory '/usr/share/fonts/truetype/msttcorefonts' does not exist.
PDF support disabled.
Could not initialize the database:
[Errno 11] Resource temporarily unavailable

Perhaps another SchoolTool instance is using it?

I am trying to install the older version of schooltool so I can import our existing data which is in Schooltool v0.11.3. Any suggestion on how I can resolved this issue.

In the mean time we have decided to begin entering data into the new inatallation of schooltool-2009. We are hoping however to recover the previous data in the existing database

Trevor

We investigated the data migration issues, it seems that there is no installation available through .debs in any PPA that would provide the migration path to current ST db version.

We'll make migration-only branches and write down the command line instructions on how to evolve the database. You'll definitely loose person images, maybe some of demographics data. There may be some quirks with timetables / calendar also.

After migration you should be able to use the database, but it would be probably best to just export the data to a spreadsheet. Please take a look sample_data.xls from "Manage -> XLS Import" in the schooltool-2009 server - that should give you the rough impression of what can be exported/imported.

I hope this is not a pressing matter.

Trevor Joefield (tjoefield) said : #17

Hi Justas,

Thanks for this update!

The approach we have decided on allows us some time to solve the data
migration problem. We have decided to do a new installation of
schooltool-2009 and begin entering all new data in it. When we solve the
data migration problem we will import as much data as we can into the new
installation of schooltool-2009

I actually practice with the sample data and have become familiar with what
can be don through this route. Our plan then is to simple get to export the
existing data and then import as many fields as possible into the new
system.

Thanks again

Trevor

Justas Sadzevičius suggests this article as an answer to your question:
FAQ #1222: “Upgrading from SchoolTool 0.11.x databases to SchoolTool 1.4”.

Trevor Joefield (tjoefield) said : #19

Hi Justas
Thanks for the link to the FAQ to resolve the data migration

I'm having difficulty running the second line in the code. I get the following error:

"$ bzr branch lp:~schooltool-owners/schooltool/database_exporter
You have not informed bzr of your Launchpad ID, and you must do this to
write to Launchpad or access private data. See "bzr help launchpad-login".
bzr: ERROR: Target directory "database_exporter" already exists."

How do I inform launchpad of my ID?

You can safely ignore the message - you don't need to *write* to launchpad (updated the FAQ entry).

$ cd database_exporter
and see the README.txt

Good luck!

Trevor Joefield (tjoefield) said : #21

Hi Justas

I followed that the direction in the readme.txt. When I run the Make command it generates a number of scripts at the end of which it indicates that ZODB3 3.9.4 was not installed. Any advice on correcting this?

Here is the last few line of the script after running the make command

"error: Setup script exited with error: command 'gcc' failed with exit status 1
An error occured when trying to install ZODB3 3.9.4. Look above this message for any errors that were output by easy_install.
While:
  Installing package.
  Getting distribution for 'ZODB3==3.9.4'.
Error: Couldn't install: ZODB3 3.9.4
make: *** [bin/export] Error 1"

Thanks much

Trevor

Trevor Joefield (tjoefield) said : #22

Hi Tom/Justas,

We have finally sorted things out. Thanks a million for all the help and guidance that you guys offered.
What we did was to load Edubuntu 6.06.1 which by default gave us access to the older version of schooltool. We then copied the data.fs file from our current system replacing the data.fs file in the new installation. After tweaking the file permission a bit on the copied file we are now able to see all of our records on the new installation. This Edubuntu machine is a virtual machine since we are running a windows environment.

We have decided not to merge this old data with that which we are now capturing in Schooltool-2009 since the structure varies in many ways and the process of manually correcting the data would be to labour intensive. Our approach then is to use the Edubuntu machine to access and view all of our previous data and the Ubuntu 10.04 machine to capture all new student information.

Thanks again

Trevor Joefield (tjoefield) said : #23

Thanks Justas Sadzevičius, that solved my question.