Re: mysql won't start with tiger

• Subject: Re: mysql won't start with tiger
• From: mailing by GSoft <email@hidden>
• Date: Tue, 27 Sep 2005 10:33:17 +0200
• Delivered-to: email@hidden
• Delivered-to: email@hidden
• User-agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)

webmaster wrote:

On Sep 26, 2005, at 04:10 AM, mailing by GSoft wrote:

webmaster wrote:

On Sep 25, 2005, at 02:47 PM, mailing by GSoft wrote:

webmaster wrote:

On Sep 25, 2005, at 09:06 AM, mailing by GSoft wrote:

Dan Shoop wrote:

At 11:05 AM +0200 8/20/05, marco wrote:

hello list,

please anyone help me if you can. Tiger has problem to start mysql because
the mysql.sock has a different locacion now rispect panther.

Yes, the socket was placed in an insucre locationd was moved to a more secure one.

However none of this has anything to do with mysqld not running. It's runs just fine with the socket in the new, more secure location.

The issue, if there is one, is a programming issue, where if you are calling mysql though its socket you must know where it is and define this in your php configuration. It's easy.

If you're calling mysql using the more common method of by hostname, then this isn't an issue at all. I actually encourage this method since it allows you to disassociate the mysql host from where the php code is run from.

Well, the full story was:

a - after first installation of Tiger Server i have changed the MySQL standard 4.1.10a that ship normally with Tiger Server, with the new 4.1.4 release. At the finish of new installation, the sinergy between Php & MySQL engine was good and any operation inside phpmyadmin was permitted, only that any operation/access from terminal was impposible, with error about the path of file mysql.sock.
A day, during a normal investigation inside the MySQL folder, i seen that launching the cmd. mysql_config, any result information still keep info for the older 4.1.10a release (?!).
b - After many tentative to resolve the prob, i have launching a script by Entropy for disinstall the 4.1.14 MySQL release, leaving resident only the originary 4.1.10 on my Mac. Now all work fine, phpmyadmin, cmd mysql from terminal ecc, only that after a restart of the mac, my db won't start automatically. I'll open the Server Manager app, and start the btn, 'Start'.

c - In hostconfig MySQL=-YES- is already present, and in / Library/ Startupitem there is a folder MYSQL. There is a step inside the fiel MYSQL that for me probably is bad:

cd /usr/local/
       REALDIR=`perl -e 'print readlink "mysql"'`
       cd $REALDIR

       # We have to find out if we're starting a 3.x or a 4.x
       # MySQL database server                            #
       if [ -e ./bin/safe_mysqld ]
       then

               # This is version 3.x
               #
               ./bin/safe_mysqld --user=mysql &

       elif [ -e ./bin/mysqld_safe ]
       then

               # This is version 4.x
               #
               ./bin/mysqld_safe --user=mysql &

       else

the cmd cd/usr/local for me is an error because the ./bin/ safe_mysqld do not exist; but if i changed it with the simple cd / usr/ and restart my machine appear a strange Safari error (NSURLManagaer???)..

Sob..

Marco Giardina

That looks good to me but I guess you don't see the mysql_safe in the statement either.

Where is the new mysqld_safe installed? (actual bath)

hello webmaster,

the 'real' position (path) of the cmd mysqld_safe now is inside / usr/bin; how can make to update the script MySQL to work fine wthin this path?

Where is the new mysql installed (real path) ?

Where was this file originally installed (if you moved mysqld_safe, move it back) ?

many thanks at all for your precious help..

m.

-- Dale

webmaster,

i never moved this file, it's was always in /usr/bin/ for the *4.10.0a* standard version of MySQL of Tiger Server; the 4.10.0a ship with TS. Some day ago i have nake a tentative to install the new 4.14.0, but after some problem with the path of mysql.sock, i have disinstall it with a script build of entropy.

bye
m.

Since you have reverted back to the original mysql, replace the contents of "/System/Library/StartupItems/MySQL/MySQL" with:
(copy/paste from e-mail usually has problems so type it)
(leading whitespaces are tab characters and not spaces)

#!/bin/sh

. /etc/rc.common

StartService ()
{
        if [ "${MYSQL:=-NO-}" = "-YES-" ]; then
                ConsoleMessage "Starting MySQL"
                OPTIONS=`/usr/bin/mysqld_manager_options`
                /usr/bin/mysqld_safe --user=mysql ${OPTIONS} &
        fi
}

StopService ()
{
        /usr/bin/killall -0 -u mysql -c mysqld >/dev/null 2>&1
        if [ $? -eq 0 ]; then
                ConsoleMessage "Stopping MySQL"
                /usr/bin/killall -TERM -u mysql -c mysqld
        else
                ConsoleMessage "MySQL is not running"
        fi
}

RestartService ()
{
        StopService
        StartService
}

RunService "$1"

hello webmaster,

thanks for your tips, now all MySQL are starting well at boot..

thanks at all for your help..
Marco
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Macos-x-server mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/macos-x-server/email@hidden

• Prev by Date: Rotate log for apache behaves strange
• Next by Date: Network security
• Previous by thread: Re: mysql won't start with tiger
• Next by thread: Parity errors
• Index(es):
  • Date
  • Thread