Start script for mysql

English Programming/Scripting
#1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I don’t understand the script or the pid_file variable is never set?
anyone can verify this?

VampirD
No in elenath hîlar nan hâd gîn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/

iEYEARECAAYFAk3FQVwACgkQJQ+0ABWtaVkUvACfVaUQRcR8nPgHV80WWVFt9Akv
LgAAn2gcTpuQrsqIU08DNx115TqawSnK
=gVrH
-----END PGP SIGNATURE-----

#2

Forgot to attach something?

#3

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No, simply type vi /etc/rc.d/mysql

VampirD
No in elenath hîlar nan hâd gîn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/

iEYEARECAAYFAk3Fn0kACgkQJQ+0ABWtaVmn6ACfc/wBgEqHo0QncFhveGgtKjdm
EWUAnirEvFeGGiq+s6GPgCz8bfsQtPe+
=AfI4
-----END PGP SIGNATURE-----

#4

Ignoring the fact that you didn’t specify the openSUSE release and the script might differ slightly between versions, let’s look at the one on 11.3. I don’t see why you think it’s never set. There are two possible ways it could be set:

65:      --pid-file=*)  pid_file="`echo "$arg"  | sed -e 's/^^=]*=//'`" ;;

253:    pid_file=/var/run/mysql/mysqld.pid

The first is from the settings in /etc/my.cnf. The second is presumably a fallback value. And even when not set, it would expand to the empty string in places where it’s used. You’d have to explain the execution path where not being set is a problem. Perhaps you should state the real problem instead of guessing that pid_file is the solution?

#5

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, I have a mysql server running on openSUSE 11.4 x86, every time it
boot, I see Starting service MySQL chmod: cannot access ‘’: No such file
or directory and I track it to the line 437 where it say: chmod a+r
“$pid_file”, if I run manualy the script the server start up, and I can
run it many times succesfuly

VampirD
No in elenath hîlar nan hâd gîn
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org/

iEYEARECAAYFAk3GmbQACgkQJQ+0ABWtaVnM1QCgvwcOjpW69M02o47I3vjyd5tJ
XN0AoMIgxGgZjcfcZiTOyBJISc7aZf+F
=f5T5
-----END PGP SIGNATURE-----

#6

Perhaps you should file a bug report and see what the devs say. I’m still on 11.3 here.

#7

Hi, alternatively, try to modify the script so that it prints the content of $pid_file to a file, so that you know just what it’s trying to operate on…
HTH

Lenwolf