[Using Sakai] Using Sakai-Demo with MySQL

[Charles Severance]

Nicolas - Here is my sakai.properties:

content.html.forcedownload=false
profile2.official.image.enabled=true
profile.manager.integration.bean=org.sakaiproject.profile2.legacy.ProfileManager

display.userlogin.info=true

# xampp
# /Applications/xampp/xamppfiles/bin/mysql -uroot -p
# MAMP
# mysql -S /Applications/MAMP/tmp/mysql/mysql.sock -u root -p

# Make Database
# create database sakai default character set utf8;
# grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword';
# grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';

# showSql at org.sakaiproject.db.api.SqlService=true

username at javax.sql.BaseDataSource=sakaiuser
password at javax.sql.BaseDataSource=sakaipassword
vendor at org.sakaiproject.db.api.SqlService=mysql
driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
# XAMPP / Normal
url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
# MAMP:
# url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:8889/sakai?useUnicode=true&characterEncoding=UTF-8
validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

Hope this helps a little.

/Chuck

On Oct 14, 2012, at 5:27 PM, <mail at nicolaslehmann.de> <mail at nicolaslehmann.de> wrote:

> Hi at all,
>  
> I’m studying computer science at the free university of berlin.
>  
> I want to use MySQL (MySQL Server 5.5) with the sakai-demo (2.8.2) instead of the HSQLDB. (Using Windows 8)
>  
> My database is: sakai
> My database-user is: sakaiuser
> My database-password is: sakaipassword
> My database-server is: 127.0.0.1 or localhost
> My database-port is: 3306
>  
> I copied the JDBC-Driver (“mysql-connector-java-5.1.20.bin”) to the directory “c:\sakaidemo\common\lib\”.
> I changed the file “c:\sakaidemo\sakai\sakai.properties” as written in the documentation.
>  
> But it doesn’t work! Can anybody post me a configuration file that works? ...or give me a hint what I did wrong??
>  
> I’m really thankful for any help!
>  
> Greetings from Berlin
> Nicolas Lehmann
>  
> _______________________________________________
> 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/20121015/7ba962e2/attachment.html