Macports Newbie - XServe use

[grimmwerks]

On Apr 8, 2007, at 2:23 PM, Altoine Barker wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Alright let me see if I can help. I will first need to know your setup
> (i.e. mac os x server version, macports version, mysql version(s), and
> exact installation steps up and until the point that you received your
> errors). Here are some points to look at to try to find your problem
> blindly. I do not know if you installed your Mac OS X Server with  
> MySQL,
> but you should make sure that you have no MySQL Server instances  
> running
> before installyin/upgrading MySQL. Run this command:
>
> mysqladmin shutdown


Well, Tiger server comes with mysql4; I've reinstalled the Tiger  
server disks and also made sure that that is not running (subversion  
is the name of the machine):


> subversion:~ admin$ mysqladmin shutdown
> mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/var/ 
> mysql/mysql.sock' (2)'
> Check that mysqld is running and that the socket: '/var/mysql/ 
> mysql.sock' exists!
> subversion:~ admin$ mysqladmin5 shutdown
> mysqladmin5: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/opt/ 
> local/var/run/mysql5/mysqld.sock' (38)'
> Check that mysqld is running and that the socket: '/opt/local/var/ 
> run/mysql5/mysqld.sock' exists!
> subversion:~ admin$
> subversion:~ admin$ which mysql
> /usr/bin/mysql
> subversion:~ admin$ which mysql5
> /opt/local/bin/mysql5
> subversion:~ admin$

I've done 'top' and see no mysql5 running.

> subversion:~ admin$ sudo killall mysql
> Password:
> No matching processes were found
> subversion:~ admin$ sudo killall mysql5
> No matching processes were found
> subversion:~ admin$










>
> Then install/upgrade mysql. I think this is the reason for the
> mysql.sock error message. HTH
>
> - -Altoine
>
> grimm at grimmwerks.com wrote:
>> Thanks Paul, but I've googled my arse off, and have tried what  
>> others have
>> recommended:
>>
>> - setting the socket in my.cnf
>> - touching where the mysqld.sock should be, creating the file and  
>> making
>> permissions 775
>>
>> I've rebooted, restarted, etc. I've not had this problem on a non  
>> Tiger
>> Server machine, but on this xserve, it's totally flaky.
>>
>> I'll re-install mysql5 according to someone else's setup, but I  
>> really
>> need to know the correct steps for OSX Server -- there's something  
>> going
>> on there.
>>
>>
>>
>>
>>
>> On Apr 7, 2007, at 9:28 PM, grimm at grimmwerks.com wrote:
>>
>>>>> I could really still use some help with mysql5 on Tiger server; no
>>>>> matter
>>>>> what I do I get:
>>>>>
>>>>> ERROR 2002 (HY000): Can't connect to local MySQL server through  
>>>>> socket
>>>>> '/opt/local/var/run/mysql5/mysqld.sock' (38)
>>>>>
>>>>> I've tried setting it in the my.cnf, touching the actual file at
>>>>> /opt/local/var/run/mysql5/mysqld.sock
>>>>>
>>>>> Anybody? This is driving me insane.
>>>>>
>>>>> Thanks much.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (Darwin)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGGTMWS0foIafBdlkRAmXIAJ49td4d2A4E0SS3d+bbQkv5RKvAngCeI3Xx
> 8p/s20fG2EipLJP9QRq5TOc=
> =ODVP
> -----END PGP SIGNATURE-----
> _______________________________________________
> macports-users mailing list
> macports-users at lists.macosforge.org
> http://lists.macosforge.org/mailman/listinfo/macports-users