[Using Sakai] Demo Configuration. [Scanned]

[David Horwitz]

Hi Calvin,

There are some lines you need to edit to match the location etc of your
mysql database:


These need to match the user name and password of your database user:
# The username and password.  The defaults are for the out-of-the-box
HSQLDB.  Change to match your setup.
username at javax.sql.BaseDataSource=sakai
password at javax.sql.BaseDataSource=ironchef


This line needs to match the database host and databse name:
url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
(this one points to a database called sakai on the local host)

In all cases look at {tomcat_home}/logs/catalina.out this will tell you
what going wrong

Note that you need to create the database for sakai to connect to and
give the user/password combination all rights to it in the mysql consol


D



On 03/24/2010 11:12 AM, calvin mutsileng wrote:
> Thanks Guys for all your inputs, I have actually added the mysql
> connector to {tomcat home}/common/lib. And commented out the HSQDB and
> uncommented the Mysql block but still the demo cannot run on my browser.
>
>  
>
> Steve Swinsburg mentioned something about adjusting to my settings ,How
> can I go about doing that?
>
>
>
>  
>
> Kind Regards,
>
>  
>
> Calvin Mutsileng
>
> Webmaster(LMS)
>
> IT Services
>
> Ext:9843 or 9753
>
> "Give a man a fish you feed him for 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 David
> Horwitz
> Sent: Wednesday, March 24, 2010 10:42 AM
> To: sakai-user at collab.sakaiproject.org
> Subject: Re: [Using Sakai] Demo Configuration. [Scanned]
>
>  
>
> You will also need to add the mysql connector to
> {tomcat_home}/common/lib
>
> D
>
> On 03/24/2010 10:38 AM, Steve Swinsburg wrote: 
>
> Calvin,
>  
> In your sakai.properties find the Database section and comment out the
> HSQLDB entry and uncomment the MySQL block and adjust to your settings.
> I think this is still possible with the actual demo version (prebuilt
> and with it's own Tomcat) but I don't have a fast enough connection to
> download and check at the moment. Can you see a sakai.properties file in
> the sakai directory in Tomcat?
>  
> cheers,
> Steve
>  
> On 24/03/2010, at 7:34 PM, calvin mutsileng wrote:
>  
>   
>
> 	Warwick thanks for your response...I'm currently Sakai version
> 2.5.3.Pls I need it now pls psl.
> 	 
> 	Kind Regards,
> 	 
> 	Calvin Mutsileng
> 	Webmaster(LMS)
> 	IT Services
> 	Ext:9843 or 9753
> 	"Give a man a fish you feed him for day ,But teach him how to
> fish you feed him for  a life time"
> 	 
> 	From: warwick.chapman at gmail.com
> [mailto:warwick.chapman at gmail.com] On Behalf Of Warwick Chapman
> 	Sent: Wednesday, March 24, 2010 10:32 AM
> 	To: calvin mutsileng
> 	Cc: sakai-user
> 	Subject: Re: [Using Sakai] Demo Configuration. [Scanned]
> 	 
> 	Calvin
> 	 
> 	Which version are you using and what "demo"?
> 	 
> 	I am about to do this for 2.7 b5 which I have just installed.  I
> will share with you once completed.
> 	 
> 	-- Warwick Bruce Chapman | +27 83 7797 094 |
> http://warwickchapman.com
> 	 
> 	 
> 	On Wed, Mar 24, 2010 at 10:23 AM, calvin mutsileng
> <calvinmu at vut.ac.za> <mailto:calvinmu at vut.ac.za>  wrote:
> 	Still asking on how to configure my Sakai demo to point to mysql
> instead of the Default HSQLDB .I'm still struggling on doing this.
> Anyone who can help me further or deeper on this pls Help........
> 	 
> 	Kind Regards,
> 	 
> 	Calvin Mutsileng
> 	Webmaster(LMS)
> 	IT Services
> 	Ext:9843 or 9753
> 	"Give a man a fish you feed him for day ,But teach him how to
> fish you feed him for  a life time"
> 	 
> 	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"
> 	 
> 	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"
> 	    
>
>  
>  
>   
>  
>  
> _______________________________________________
> 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"
>   
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 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.
>
>