[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.

Michael,

Sorry I wasn't clear enough! I was talking about the DB username.  Try and see if the DB username that you are using to connect to the database can see the tables.  IN oracle you do a desc on the table to see the columns in that table.  If the table does not exist you will get "Table not found error".  Then you know the table was not created.  Unfortunately I don't know HyperSQL so don't know what they use.  But thinking further about the problem I don't think this is the actual problem as you are still deploying so the same DB  user code is used.

Let's hope that Adrian can provide you with database creation scripts!

Sorry I could not be of more help.

Sonette

-----Original Message-----
From: Michael Chale [mailto:mike.chale at warrington.ufl.edu]
Sent: 28 June 2010 03:22 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

Hello, Sonette.

There are no stupid questions because this is literally my first time running Sakai.

I'm logging in as the demo's default admin account so I have to assume I have permissions.  I've also double-checked the files on my computer have the right permissions.
It looks like I need to write some Java to check what's in the database since the demo uses HyperSQL.  If so, it will take a while for me to check; I just don't have the time to spend right now.

A script would be excellent, but I don't know if one exists.

Adrian, do you have any database creation scripts?

Thank you for your continued help,



  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 8:44 AM
To: Michael Chale; Adrian Fish
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 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