[Building Sakai] Startup mysql issues on MacOS 10.6.4, mysql 5.1.48

[Anthony Whyte]

I encountered similar problems on my new Mac laptop running Mac OS X 10.6.3 and MySQL 5.1.46.  I had no problems running MySQL 5.0.  I solved the Sakai startup problems by removing MySQL from my system completely and then reinstalling MySQL 5.1.

Be sure to perform a database dump before you do the following:

  * sudo rm /usr/local/mysql
  * sudo rm -rf /usr/local/mysql*
  * sudo rm -rf /Library/StartupItems/MySQLCOM
  * sudo rm -rf /Library/PreferencePanes/My*
  * edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
  * sudo rm -rf /Library/Receipts/mysql*
  * sudo rm -rf /Library/Receipts/MySQL*

Once completed, reinstall MySQL 5.1.

My current my.cnf is 

[mysqld]
default-storage-engine=InnoDB
lower_case_table_names=1

I create/drop my "sakai" db repeatedly while working on release management issues.  Since performing the above steps I have encountered no Sakai startup problems related to MySQL.

Cheers,

Anthony




On Jun 29, 2010, at 9:24 AM, Matthew Jones wrote:

> FYI: From the mysql manual, the value of 0 is not recommended for osx. [1] Though I guess this would depend on if you have your database files on a UFS (case sensitive) or HFS+ (case insensitive) volume though? Though probably not many people know the file-system for their mac installation.
> 
> The value of "1" usually seems to be the best way to go overall and is what we have been recommending in the Sakai Admin guide. [2] Might want to revise this if it needs some clarification. I have been running my dev Sakai DB's off of Windows Server 2008. 
> 
> This issue and the "default-storage-engine=InnoDB" come up as pretty common problems. :(
> 
> From the manual:
> Value 0: " Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). "
> 
> "On Unix, the default value of lower_case_table_names is 0. On Windows the default value is 1. On Mac OS X, the default value is 2."
> 
> [1] http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
> [2] http://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning
> 
> On Tue, Jun 29, 2010 at 7:32 AM, Stephen Marquard <stephen.marquard at uct.ac.za> wrote:
> Hi all
> 
> After upgrading my Macbook to Snow Leopard and reinstalling mysql to the latest 5.1.48 download for MacOS, I ran into startup problems with DDL errors (e.g. 'multiple primary key defined' trying to create or update tables).
> 
> I found a way to fix this, which is to specify in /usr/local/mysql/etc/my.cnf:
> 
> [mysqld]
> set-variable=lower_case_table_names=0
> 
> (and stop and start mysql, drop and recreate the sakai db).
> 
> Hope this helps someone.
> 
> Cheers
> Stephen
> 
> 
> 
> 
> 
> ###
> UNIVERSITY OF CAPE TOWN
> 
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.
> 
> ###
> 
> _______________________________________________
> 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"
> 
> _______________________________________________
> 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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100629/e31c55ea/attachment.html