[Building Sakai] Sakai Clustering

[given.shirinda at sita.co.za]

Hi Nuno. 

I tried that,it is not working. 

The following lines show how I did I setup my sakai environment. 

I got the following Servers. 

Server A and Server B. 

Server A (10.125.34.10) "apache-tomcat-5.5.25" 
Server B (10.125.34.12) "Mysql Database." 

Server A sakai.properties 


# The database username and password. The defaults are for the out-of-the-box HSQLDB. 
# Change to match your setup. Do NOT enable access to your database without a password. 
username at javax.sql.BaseDataSource=sakai 
password at javax.sql.BaseDataSource=sita77 

# MySQL settings 
vendor at org.sakaiproject.db.api.SqlService=mysql 
driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver 
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect 
url at javax.sql.BaseDataSource=jdbc:mysql://10.125.34.12:3306/sakai?useUnicode=true&characterEncoding=UTF-8 
validationQuery at javax.sql.BaseDataSource=select 1 from DUAL 
defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED 


Server B Mysql database creation 



mysql> create database sakai default character set utf8; 



mysql> grant all on sakai.* to sakai@' 10.125.34.12 ' identified by 'sita77'; 


Tell me if the above information is correct. 


Best Regards 

Given 






----- Original Message ----- 
From: "Nuno Fernandes" <nuno at ufp.edu.pt> 
To: "Given Shirinda" <given.shirinda at sita.co.za> 
Cc: "Kevin P. Foote" <kpfoote at iup.edu>, sakai-dev at collab.sakaiproject.org 
Sent: Thursday, September 17, 2009 1:25:31 PM GMT +02:00 Harare / Pretoria 
Subject: Re: [Building Sakai] Sakai Clustering 

Hi Given, 


Probably, you forgot to give permissions to the sakai user from a specified host (the one with the tomcat accessing mysql): 


grant all on sakai_26x.* to sakaiuser@'10.11.4.14' identified by 'sakaipassword'; 


Hope it helps, 
Nuno 



2009/9/17 Given Shirinda < given.shirinda at sita.co.za > 


Hi Foote. 

In the sakai.properties file,I did change the below line 

url at javax.sql.BaseDataSource=jdbc:mysql:// 127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8 

to 

url at javax.sql.BaseDataSource=jdbc:mysql:// 10.129.7.123:3306/sakai?useUnicode=true&characterEncoding=UTF-8 

sakai does not start up,reasons it doe not connect to sakai database to Server C. 

I dont know what to do now. 


Given 



_______________________________________________ 
sakai-dev mailing list 
sakai-dev at collab.sakaiproject.org 
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev 

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe" 



-- 
Nuno Fernandes [ www.linkedin.com/in/nfgrilo ] 
Software Developer - UFP-UV [Universidade Virtual] 
Software Developer - Sakai Foundation [ sakaiproject.org ] 
Sakai Fellow 2008 - Sakai Foundation [ confluence.sakaiproject.org/confluence/x/FIF9AQ ] 

Universidade Fernando Pessoa [ www.ufp.pt ] 
Praça 9 de Abril, 349 
4249-004 Porto 
tel: + 351 22 507 13 00 
fax: + 351 22 550 82 69 


-- 
*********************************************** 
STATE INFORMATION TECHNOLOGY AGENCY 
*********************************************** 
MIYELANI GIVEN SHIRINDA. 

E-LEARNING CONSULTANT [SAKAI] 
DEPARTMENT: TECHNOLOGY LAB 
_______________________________________________ 
Tel :012 470 1526 
Cell:0730133879 
E-Mail 1:given.shirinda at sita.co.za 
E-Mail 2:mgshirinda at webmail.co.za 
_______________________________________________ 

Failure is simply the opportunity to begin again,this time more intelligently. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090917/60f4e0cd/attachment.html