Results 1 to 7 of 7

Thread: Start script for mysql

  1. #1
    Join Date
    Nov 2009
    Location
    Uruguay
    Posts
    742

    Default Start script for mysql

    -----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 hlar nan hd gn
    -----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. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,683
    Blog Entries
    4

    Default Re: Start script for mysql

    Forgot to attach something?

  3. #3
    Join Date
    Nov 2009
    Location
    Uruguay
    Posts
    742

    Default Re: Start script for mysql

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

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

    - --
    VampirD
    No in elenath hlar nan hd gn
    -----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. #4
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,683
    Blog Entries
    4

    Default Re: Start script for mysql

    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:

    Code:
    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. #5
    Join Date
    Nov 2009
    Location
    Uruguay
    Posts
    742

    Default Re: Start script for mysql

    -----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 hlar nan hd gn
    -----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. #6
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,683
    Blog Entries
    4

    Default Re: Start script for mysql

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

  7. #7

    Default Re: Start script for mysql

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •