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

[Steve Swinsburg]

I also had a similar problem moving to a recent version of 5.1 on OS X but thought it was just me. Then one of my staff had a similar issue on Ubuntu, and the same fix worked, setting lower_case_table_names=1

My /etc/my.cnf:
 
[mysqld]
max_allowed_packet=100M
lower_case_table_names=1


cheers,
Steve

On 30/06/2010, at 12:21 AM, Anthony Whyte wrote:

> 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"
> 
> _______________________________________________
> 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/20100630/ea2a9f18/attachment.html