[Using Sakai] Sakai and MySQL
Anthony Whyte
arwhyte at umich.edu
Tue Mar 9 12:55:42 PST 2010
Calvin--do the following:
1. download and install MySQL 5.0.* (or 5.1 if you prefer)
2. create a MySQL my.cnf/my.ini configuration file and at a minimum set the default table type (e.g., storage engine) to Innodb (see install guide link below for example)
3. create a sakai database instance (see install guide link below for instructions)
4. download the MySQL connector package, crack it open, and copy the mysql-connector-java-<version>-bin.jar to $CATALINA_HOME/common/lib
5. modify the database settings in the demo sakai.properties file to point to your MySQL instance (see install guide link below for settings)
To really get to know Sakai I recommend you put the demo aside and instead download the Sakai source (e.g., 2.6.2) and follow the source install/development environment walkthrough and learn how to set up Sakai, Maven, Tomcat and MySQL. You will be better off if you learn how to work with all t these technologies.
MySQL connector (5.0)
http://dev.mysql.com/downloads/connector/j/5.0.html
Sakai 2.6.2
http://source.sakaiproject.org/release/2.6.2/
2.6 Configuration
Install Guide: http://confluence.sakaiproject.org/display/DOC/Configuration+%282.6%29
2.6 Source install Guide
http://confluence.sakaiproject.org/display/DOC/Install+Guide+-+Source+Install+%282.6%29
Developer Environment Walkthrough
http://confluence.sakaiproject.org/display/BOOT/Development+Environment+Setup+Walkthrough
Cheers,
Anth
On Mar 9, 2010, at 8:39 PM, calvin mutsileng wrote:
> Thanks Again Karen pls Help me on how to go about it I need step-by-step Help on configuring the Demo default Hypersonic DATABASE to point to MySQL.
>
> Kind Regards,
>
> Calvin Mutsileng
> Instructional Designer
> IT Services
> Vaal University of Technology
> <image002.jpg>
> Tel no:016 950 9843 / 9753
> Email: calvinmu at vut.ac.za
> "Give a man a fish you feed him for the day ,But teach him how to fish you feed him for a life time"
>
>
> From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
> Sent: 09 March 2010 08:35 PM
> To: calvin mutsileng
> Cc: DAVID ROLDAN MARTINEZ; sakai-user
> Subject: Re: [Using Sakai] Random drawn quiz [Scanned]
>
> You can edit your sakai.properties. Modify the MySQL settings section to point to your MySQL database.
>
> Thanks,
> Karen
>
> On Tue, Mar 9, 2010 at 9:55 AM, calvin mutsileng <calvinmu at vut.ac.za> wrote:
> Thanks Karen for your reply.
>
> One more question ,I’m testing something using the Sakai-demo ,And I want to configure the Demo to use MySQL Database not the default Hypersonic ,How do I go about doing that?
>
> Kind Regards,
>
> Calvin Mutsileng
> Instructional Designer
> IT Services
> Vaal University of Technology
> <image004.jpg>
> Tel no:016 950 9843 / 9753
> Email: calvinmu at vut.ac.za
> "Give a man a fish you feed him for the day ,But teach him how to fish you feed him for a life time"
>
>
> From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
> Sent: 09 March 2010 07:51 PM
> To: calvin mutsileng
> Cc: DAVID ROLDAN MARTINEZ; sakai-user
>
> Subject: Re: [Using Sakai] Random drawn quiz [Scanned]
>
> Yes. Let's say you want students to take 10 questions in this test. Then 10 questions will get drawn randomly from the 1000 questions .
>
> Thanks,
> Karen
>
> On Tue, Mar 9, 2010 at 12:57 AM, calvin mutsileng <calvinmu at vut.ac.za> wrote:
> If you set-up a Test with Random draw. Suppose you have 1000 questions in your pool ,
> Do students see different Questions though it’s the same Test?
>
> Kind Regards,
>
> Calvin Mutsileng
> Instructional Designer
> IT Services
> Vaal University of Technology
> <image004.jpg>
> Tel no:016 950 9843 / 9753
> Email: calvinmu at vut.ac.za
> "Give a man a fish you feed him for the day ,But teach him how to fish you feed him for a life time"
>
>
> From: sakai-user-bounces at collab.sakaiproject.org [mailto:sakai-user-bounces at collab.sakaiproject.org] On Behalf Of Karen Tsao
> Sent: 09 March 2010 12:52 AM
> To: DAVID ROLDAN MARTINEZ
> Cc: sakai-user
> Subject: Re: [Using Sakai] Random drawn quiz [Scanned]
>
> Please try the following query. It returns the student id and the question text:
>
> SELECT ag.agentid student_id, pit.text question_text
> FROM sam_assessmentgrading_t ag, sam_itemgrading_t ig, sam_publisheditemtext_t pit
> WHERE ag.forgrade = 1 and ag.assessmentgradingid = ig.assessmentgradingid
> AND ig.publisheditemtextid = pit.itemtextid
> AND ag.publishedassessmentid = :published_assessment_id
> GROUP by ag.assessmentgradingid, pit.itemtextid
> ORDER BY ag. agentid, ig.itemgradingid
>
> Thanks,
> Karen
>
> On Mon, Mar 8, 2010 at 2:07 PM, DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es> wrote:
> Karen,
>
> Can you post a sample query to do this, please? For us it would be very useful, too.
>
> Thank you very much in advance.
>
> David
> ________________________________________
> De: sakai-user-bounces at collab.sakaiproject.org [sakai-user-bounces at collab.sakaiproject.org] En nombre de Karen Tsao [ktsao at stanford.edu]
> Enviado el: lunes, 08 de marzo de 2010 23:04
> CC: sakai-user
> Asunto: Re: [Using Sakai] Random drawn quiz
>
> Hi Greg,
>
> I think the only way is querying database directly. If you need my help with the queries, please let me know.
>
> Thanks,
> Karen
>
> On Mon, Mar 8, 2010 at 1:01 AM, Gregory Doyle <Gregory.Doyle at uct.ac.za<mailto:Gregory.Doyle at uct.ac.za>> wrote:
> Hi
> We've set up a quiz with questions randomly drawn from a question pool (25 from 38). The instructor did not realise there would be no item analysis - is there anyway to determine which questions each student got?
>
> Thanks
> greg
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org<mailto:sakai-user at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org<mailto:sakai-user-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
>
>
> Disclaimer: This message and any attachments are confidential and intended solely for the addressee. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Unauthorised disclosure and/or use of information contained in this email may result in civil and criminal liability. Neither the sender of the e-mail, nor Vaal University of Technology shall be held liable to any party for any direct, indirect or consequential damages, including, without limitation, loss of profit, interruption of business or loss of information, data or software or otherwise. No warranties are created or implied that an employee of Vaal University of Technology and/or a contractor of Vaal University of Technology is authorized to create and send this e-mail.
>
> Disclaimer: This message and any attachments are confidential and intended solely for the addressee. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Unauthorised disclosure and/or use of information contained in this email may result in civil and criminal liability. Neither the sender of the e-mail, nor Vaal University of Technology shall be held liable to any party for any direct, indirect or consequential damages, including, without limitation, loss of profit, interruption of business or loss of information, data or software or otherwise. No warranties are created or implied that an employee of Vaal University of Technology and/or a contractor of Vaal University of Technology is authorized to create and send this e-mail.
>
> Disclaimer: This message and any attachments are confidential and intended solely for the addressee. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Unauthorised disclosure and/or use of information contained in this email may result in civil and criminal liability. Neither the sender of the e-mail, nor Vaal University of Technology shall be held liable to any party for any direct, indirect or consequential damages, including, without limitation, loss of profit, interruption of business or loss of information, data or software or otherwise. No warranties are created or implied that an employee of Vaal University of Technology and/or a contractor of Vaal University of Technology is authorized to create and send this e-mail. _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100309/088372d9/attachment-0001.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2417 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20100309/088372d9/attachment-0001.bin
More information about the sakai-user
mailing list