[REQUEST] - HowTo setup startup services on Jaguar (10.2.3)

[wiz]

could someone ceate a [HowTo] on this?

thanks

for some reason my mysql setup won't work.

i've added the MYSQL=-YES- in the /etc/hostconfig

and created the folder /Library/StartupItems/MySQL
created file MySQL
created file StartupParametres.plist



but still it dosen't work

the problem seems to be,
the MYSQL env var is not not being read or its set to -NO- although i explictly set it to -YES-
and hence the mysqld is never initialized

otherwise everything is fine

[slur]

Did you install MySQL using the packages available at entropy.ch? These make it a lot easier.

So to troubleshoot...

- In my (entropy) installed version of MySQL there's also a "Resources" folder containing an "English.lproj" file. I'm not sure if this is necessary.

- The MySQL script has to be executable. Is it?

- The MySQL script should contain something like this:

#!/bin/sh

. /etc/rc.common

if [ "${MYSQL:=-YES-}" = "-YES-" ]; then

ConsoleMessage "Starting MySQL database server"

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

ulimit -n 6000

if [ -e ./bin/safe_mysqld ]; then
./bin/safe_mysqld --user=mysql &
elif [ -e ./bin/mysqld_safe ]; then
./bin/mysqld_safe --user=mysql &
else
ConsoleMessage "Found neither safe_mysqld nor mysqld_safe"
fi

fi

- My StartupParameters.plist file has these contents. How does it compare to yours?:

{
Description = "MySQL database server";
Provides = ("MySQL");
Requires = ("Resolver");
Preference = "Late";
Messages =
{
start = "Starting MySQL";
stop = "Stopping MySQL";
};
}

[LordCoven]

.... if you can start / stop the service manually with the SystemStarter command:

SystemStarter start MySQL
or
SystemStarter stop MySQL

If you get any errors with this (which I did), then you'll have to get this to work first. In my case, the script was using the default MySQL environment for startup, whereas the version directly from MySQL has to be configured slightly different. I can post my version of the script here later if you want.

C

[wiz]

well actually i got it working !!!
using the Jaguar style startup script!!
(/Library/StartupItems/MySQL/MySQL)

here my script...

#!/bin/sh

##
# MySQL Database Server
##

. /etc/rc.common

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

StopService ()
{
    ConsoleMessage "Stopping MySQL"
    /usr/local/mysql/bin/mysqladmin shutdown
}

RestartService ()
{
    if [ "${MYSQL:=-NO-}" = "-YES-" ]; then
	ConsoleMessage "Restarting MySQL"
	StopService
	StartService
    else
	StopService
    fi
}

RunService "$1"

this is cool actually since u can manually start/stop/restart the service by just typing this at command line

sudo /Library/StartupItems/MySQL/MySQL start
sudo /Library/StartupItems/MySQL/MySQL restart
sudo /Library/StartupItems/MySQL/MySQL stop

[wiz]

but tryin the system starter i get the following error:
Unable to load localization strings for

i guess thats because i don't have that English.lproj file

[wiz]

here is my StartupParameter.plist contents tooo, Jaguar style... (XML actually)
(/Library/StartupItems/MySQL/StartupParameter.plist)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>Description</key>
	<string>MySQL Database Server</string>
	<key>OrderPreference</key>
	<string>Late</string>
	<key>Provides</key>
	<array>
		<string>MySQL</string>
	</array>
	<key>Requires</key>
	<array>
		<string>Network</string>
	</array>
</dict>
</plist>

[roguephp]

so wiz,

to get your startup XML script to work, I create a directory inside System/Library/StartupItems called mySQL and put your script in there with the correct path to my mySQL directory?

Thanks

[wiz]

ditto

but the script might not work with MySQL 3.x
to get it working...

just replace the

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

with

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

notice it's changed from mysqld_safe (4.x) to safe_mysqld for (3.x).

NOTE: some newer binary releases of 4.x have a link name safe_mysqld that links to mysqld_safe

also don't forget to add the MYSQL=-YES- in the /etc/hostconfig
replacing it with MYSQL=-NO- will stop initializing the mysql server on startup

TIP: backup that hostconfig file, it's safer