[Building Sakai] Using YAFT with Sakai 2.6.2 demo

[Yzelle, Sonette]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.

Hi Michael,

Maybe I am going to ask stupid questions that you have already tried, but I am just trouble-shooting!
Does the sakai user you are using have permissions to create tables?
When you go in to the database can you do a manual describe on the tables? Do they exist or don't they.
If they exist maybe you just need some grants for a specific db user to those tables.
If they don't exist I think you must check if your db user is allowed to create tables.

If none of the above is working maybe we can ask Adrian if he has a HypersonicSQL script to create the yaft database?  We only had one table missing so it was easy to go through DefaultSqlGenerator.java to get the schema for that table.

Maybe we can even suggest this to the Sakai community that all tools must be accompanied by a script to create tables for a tool manually?  I know some tools do have manual scripts.  This would also help Unisa because our autoddl is always set to false.

Regards
Sonette

-----Original Message-----
From: Michael Chale [mailto:mike.chale at warrington.ufl.edu]
Sent: 28 June 2010 02:25 PM
To: Yzelle, Sonette; Adrian Fish
Cc: sakai-dev at collab.sakaiproject.org
Subject: RE: [Building Sakai] Using YAFT with Sakai 2.6.2 demo

Hi,

The errors I'm getting start with:
* ERROR main org.sakaiproject.yaft.impl.YaftPersistenceManager - Caught exception whilst setting up tables. Rolling back ...
* Table not found in statement [SELECT * FROM YAFT_PREFERENCES]
* Table not found in statement [SELECT DISCUSSION_ID FROM YAFT_DISCUSSION_UNSUBS]
* and so on.

If I knew how to manually create the tables in the HypersonicSQL db I would, but I haven't found that information yet (nor do I know the table schemas.)


  Michael Chale
  Software Developer
  Web, Data, and Communication Services

-----Original Message-----
From: Yzelle, Sonette [mailto:SYzelle at unisa.ac.za]
Sent: Monday, June 28, 2010 7:40 AM
To: Adrian Fish; Michael Chale
Cc: sakai-dev at collab.sakaiproject.org
Subject: RE: [Building Sakai] Using YAFT with Sakai 2.6.2 demo

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.

Hi,

Yaft is working 100% for Unisa on Sakai 2.6.2 on our production environment.

We did experience problems with the yaft tables, 1 tables were not created.  We also had to create grants for another table. We use Oracle database.
The tool deployed successfully we only picked up the missing tables when we started
using the tool.  I ended up giving a script to the DBA to create the table.

What was the error message you were getting again?  Sorry can't remember but I did see the e-mail.

Regards
Sonette