[Building Sakai] Sakai Clustering

[Nuno Fernandes]

Hi Given,
Since Server A is the one with Sakai (Tomcat) that is accessing your db (in
Server B), your line should reflect Server A IP address instead:

grant all on sakai.* to sakai@'10.125.34.*10*' identified by 'sita77';

Hope it helps,
Nuno


2009/9/17 <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 <1%3Agiven.shirinda at sita.co.za>
> E-Mail 2:mgshirinda at webmail.co.za <2%3Amgshirinda at webmail.co.za>
> _______________________________________________
>
> Failure is simply the opportunity to begin again,this time more
> intelligently.
>



-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090917/dc11f58b/attachment.html