[Using Sakai] testing database setup with Sakai

[Mark Norton]

On 2/23/2011 7:00 AM, Tapas Mishra wrote:
> I am using Sakai 2.7 based on configure section of this page
> https://confluence.sakaiproject.org/display/DOC/Sakai+2.7
> in my sakai.properties file
> I have changed
> auto.ddl=true to
> auto.ddl=fales
> and
> username at javax.sql.BaseDataSource=yourDbUserName
> password at javax.sql.BaseDataSource=yourDbPassword
>   to my details and uncommented the Mysql section as given in section 7
> of above link.
Generally, it's a good idea to leave auto.ddl to be true.  This flag is 
used to control the creation of database tables at start-up time.  The 
only reason you might want to set it to false would be if you had 
altered the table definitions for some reason (sometimes done for 
efficiency reasons, but pretty rare).
> Kept mysql-connector-java-5.1.9-bin.jar to $CATALINA_HOME/common/lib
>
> and default character set for sakai database is utf8.
>
> How do I test whether my settings are working ?

If you have compiled and built Sakai property, start it up in tomcat.  
Watch the console or follow catalina.out with "tail -f catalina.out".  
If the database is not working correctly, you will start to see errors 
pretty quick.
> I want to know if I can log in to my sakai instance and see if things
> are working so what can I do to check that?
Once Sakai is fully up an running (verify in the console or 
catalina.out), then you can log into Sakai by entering 
"http://localhost:8080/portal" into your browser (assuming you are 
running it locally).  You should see the Sakai login screen.  Enter 
"admin" / "admin" and you should be able log in.  In a production 
environment, you should change the admin password.
> I also want to know in Section 8 of same page
> https://confluence.sakaiproject.org/display/DOC/Sakai+2.7
> it has been mentioned to define
> MYSQL_HOME and my.cnf
> is all that necessary?

I strongly suggest that you have a close look at 
https://confluence.sakaiproject.org/display/DOC/Install+Guide+-+Source+Install+%282.7%29.  
Follow the directions careful and you shouldn't have any problems.
> I have installed mysql-server on Ubuntu by apt-get install mysql-server
> and many other applications are working.
> I have created a sakai database for sakai instance though.
Mark Norton