I need administrator access to our schooltool database
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:
- Last query:
- Last reply:
Related bugs
Revision history for this message
|
#1 |
We'll get back to you about this question next week.
Revision history for this message
|
#2 |
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/
/var/log/
Provided you have access to the old server, database version is specified in XXX/schooltool/
Also the version of SchoolTool can be found at the bottom of every page of SchoolTool, near the copyright.
Thanks
Revision history for this message
|
#3 |
Hi Justas,
Here is the log from the server with Ubuntu:
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
WARNING:
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Trevor
Revision history for this message
|
#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.
2010-07-08 12:25:42,777 main db/schooltool.
2010-07-08 12:25:42,821 main db/schooltool.
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/
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
Revision history for this message
|
#5 |
This seems to be the problem:
> Could not initialize the database:
> [Errno 13] Permission denied: '/var/lib/
You have to copy the database again, and set the correct permissions from terminal (you'll need admin rights)
$ sudo /etc/init.
$ ... copy the data fs
$ sudo chown schooltool:
$ sudo chmod 640 /var/lib/
$ sudo /etc/init.
If it's still not working, please add error and paste logs again.
Best of luck
Revision history for this message
|
#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-
2. The data.fs file which I got from the old database was renamed to schooltool-
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/
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
Revision history for this message
|
#7 |
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.
might be helpful in such cases.
Probably the Data.fs is really old, and it failed to run. Please paste again:
/var/log/
/var/log/
Thanks
Revision history for this message
|
#8 |
Hi Justas,
Here is the paste log
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
WARNING:
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
Could not initialize the database:
[Errno 13] Permission denied: '/var/lib/
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
WARNING:
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
WARNING:
INFO:zope.
INFO:zope.
ERROR:zope.
Traceback (most recent call last):
File "/usr/lib/
manager.
File "/usr/lib/
evolver.
File "/usr/lib/
raise NotImplementedE
NotImplementedE
Traceback (most recent call last):
File "/usr/bin/paster", line 18, in <module>
command.run()
File "/usr/lib/
invoke(command, command_name, options, args[1:])
File "/usr/lib/
exit_code = runner.run(args)
File "/usr/lib/
result = self.command()
File "/usr/lib/
relative_
File "/usr/lib/
**kw)
File "/usr/lib/
return loadobj(APP, uri, name=name, **kw)
File "/usr/lib/
return context.create()
File "/usr/lib/
return self.object_
File "/usr/lib/
return fix_call(
File "/usr/lib/
val = callable(*args, **kw)
File "/usr/lib/
os.
File "/usr/lib/
db = self.setup(options)
File "/usr/lib/
notify(
File "/usr/lib/
subscriber(
File "/usr/lib/
zope.
File "/usr/lib/
return sitemanager.
File "/usr/lib/
return self.adapters.
File "/usr/lib/
subscriptio
File "/usr/lib/
zope.
File "/usr/lib/
subscriber(
File "/usr/lib/
zope.
File "/usr/lib/
return sitemanager.
File "/usr/lib/
return self.adapters.
File "/usr/lib/
subscriptio
File "/usr/lib/
evolve(
File "/usr/lib/
manager.
zope.app.
Reading configuration from /etc/schooltool
/usr/lib/
from sets import ImmutableSet
Warning: font directory '/usr/share/
PDF support disabled.
INFO:zope.
INFO:zope.
ERROR:zope.
Traceback (most recent call last):
File "/usr/lib/
manager.
File "/usr/lib/
evolver.
File "/usr/lib/
raise NotImplementedE
NotImplementedE
Traceback (most recent call last):
File "/usr/bin/paster", line 18, in <module>
command.run()
File "/usr/lib/
invoke(command, command_name, options, args[1:])
File "/usr/lib/
exit_code = runner.run(args)
File "/usr/lib/
result = self.command()
File "/usr/lib/
relative_
File "/usr/lib/
**kw)
File "/usr/lib/
return loadobj(APP, uri, name=name, **kw)
File "/usr/lib/
return context.create()
File "/usr/lib/
return self.object_
File "/usr/lib/
return fix_call(
File "/usr/lib/
val = callable(*args, **kw)
File "/usr/lib/
os.
File "/usr/lib/
db = self.setup(options)
File "/usr/lib/
notify(
File "/usr/lib/
subscriber(
File "/usr/lib/
zope.
File "/usr/lib/
return sitemanager.
File "/usr/lib/
return self.adapters.
File "/usr/lib/
subscriptio
File "/usr/lib/
zope.
File "/usr/lib/
subscriber(
File "/usr/lib/
zope.
File "/usr/lib/
return sitemanager.
File "/usr/lib/
return self.adapters.
File "/usr/lib/
subscriptio
File "/usr/lib/
evolve(
File "/usr/lib/
manager.
zope.app.
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.
2010-07-08 12:25:42,777 main db/schooltool.
2010-07-08 12:25:42,821 main db/schooltool.
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/
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.
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/
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/
manager.
File "/usr/lib/
evolver.
File "/usr/lib/
raise NotImplementedE
NotImplementedE
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/
manager.
File "/usr/lib/
evolver.
File "/usr/lib/
raise NotImplementedE
NotImplementedE
Thanks again for your continued assistance in helping us to solve this problem!
Trevor
Revision history for this message
|
#9 |
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-
Revision history for this message
|
#10 |
What data do you need out of this system specifically?
Revision history for this message
|
#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:/
>
> 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:/
>
> You received this question notification because you are a direct
> subscriber of the question.
>
Revision history for this message
|
#12 |
Hi Trevor,
Yes, but *what* data are you storing in it?
Revision history for this message
|
#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:/
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:/
You received this question notification because you are a direct
subscriber of the question.
Sent from my BlackBerry® device from Digicel
Revision history for this message
|
#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.
Revision history for this message
|
#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/
PDF support disabled.
Setting up python-docutils (0.4-1ubuntu1) ...
tjoefield@
Reading configuration from /etc/schooltool
Warning: font directory '/usr/share/
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
Revision history for this message
|
#16 |
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.
Revision history for this message
|
#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
Revision history for this message
|
#18 |
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”.
Revision history for this message
|
#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?
Revision history for this message
|
#20 |
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!
Revision history for this message
|
#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
Revision history for this message
|
#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
Revision history for this message
|
#23 |
Thanks Justas Sadzevičius, that solved my question.