Macports Newbie - XServe use

[Alex Kac]

I've got a MySQL expert who works with the MySQL consulting folks. I  
had the same issue and here is what he told me to do and now it works  
great:

ustin2-webis-net:/opt/local/var/db/mysql5 root# ls -la
total 40976
drwxr-xr-x   10 mysql  mysql       340 Apr  5 21:17 .
drwxrwxr-x    4 root   admin       136 Apr  5 16:47 ..
-rw-r--r--    2 root   mysql         0 Apr  5 16:47 .turd_mysql5
-rw-rw----    1 mysql  mysql      3914 Apr  5 21:17 Austin2-webis- 
net.local.err
-rw-rw----    1 mysql  mysql   5242880 Apr  5 21:17 ib_logfile0
-rw-rw----    1 mysql  mysql   5242880 Apr  5 16:49 ib_logfile1
-rw-rw----    1 mysql  mysql  10485760 Apr  5 20:27 ibdata1
-rw-rw----    1 mysql  mysql      2197 Apr  5 20:52 localhost.err
drwx------   53 root   mysql      1802 Apr  5 20:49 mysql
drwx------    2 root   mysql        68 Apr  5 20:36 test
Austin2-webis-net:/opt/local/var/db/mysql5 root# cd ..
Austin2-webis-net:/opt/local/var/db root# chmod -R +x mysql5/
Austin2-webis-net:/opt/local/var/db root# chown -R mysql:mysql mysql5/

Of course, don't use the default my.cnf files - they are all horrible.

On Apr 1, 2007, at 8:07 PM, grimmwerks wrote:

> Alex - please let me know how you find all the macports  
> installation on the xserve goes for you; I don't have the  
> experience you do, but I've installed the same setups (+ruby) on  
> non-server machines with no problem. However, recently trying to  
> get all of this on the xserve has proven itself to be problematic  
> for me recently.
>
> I don't know if it's a permissions problem, or something I've done  
> in my own misunderstanding, but I don't have a solid setup right  
> now. The placement of the mysql.sock being a problem at first, the  
> permissions and ability to write to databases being another. As of  
> right now, mysql is a bit farked in that I DO have databases  
> created and users that can write to these dbs, but the minute that  
> I try to run rails to set up an initial database (I'm trying to  
> setup retrospectiva as a bugtracker) -- it all blows up.  I've even  
> tried to mySQL gui tools to add to the db, and they crash too.
>
> Apache is running (I get the 'It works!' page), but can't quite get  
> the mod svn working as yet.
>
> So, if you do get this all up and running smoothly, I'd really  
> appreciate it if you can hand down the steps to get this going on  
> an Xserve.

Alex Kac - President and Founder
Web Information Solutions, Inc. - Microsoft Certified Partner

"The optimist proclaims that we live in the best of all possible  
worlds; and the pessimist fears this is true."
-- James Clabell