Not signed in (Sign In)

Choose a language

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Support and General Discussion: MySQL Help: MySQL start problem

Bottom of Page

1 to 14 of 14

  1.  
    • CommentAuthorRainMaker
    • CommentTimeApr 9th 2008
     # 1
    Hi Guys, I installed MySQL, everything is fine, but when I try to start it, it gives me an error:

    StartTask MySQL
    Starting MySQL./System/Links/Tasks/MySQL: line 159: kill: (1899) - No such process
    ERROR!
    StartTask: MySQL: Returned code 1 => FAILED

    Any ideas?

    Thanks.
    • CommentAuthorMohjive
    • CommentTimeApr 9th 2008
     # 2
    How did you install MySQL and what version?
    Does the directory /Files/MySQL exist and is it owned by user "mysql"?
    • CommentAuthorRainMaker
    • CommentTimeApr 10th 2008
     # 3
    I just fired up Konsole and type in "Compile MySQL" And yeah it installed it.
    Yeah, /Files/MySQL does exist, but I don't get what you mean by "is it owned by user "mysql"?".
    • CommentAuthorMohjive
    • CommentTimeApr 10th 2008
     # 4
    If you do 'ls -l /Files/MySQL' you should get something like this:

    total 20511
    drwxrwxr-x 4 mysql sys 256 2008-01-21 09:25 .
    drwxrwxr-x 12 gobo sys 304 2008-04-04 22:42 ..
    drwxrwx--- 2 mysql sys 1752 2007-12-15 18:48 mysql
    drwxrwx--- 2 mysql sys 1872 2008-01-22 05:06 test

    Here you have permissions, link count, owner, group, size, modification time and date and finally the file/directory name. Make sure you have these directories (test isn't really needed) and that the owner is set to "mysql" for the mysql, test and . directories.
    • CommentAuthorRainMaker
    • CommentTimeApr 11th 2008 edited
     # 5
    Okay, I typed in that, and it showed me what you had posted, and I seriously don't know how that thing is going to tell me what or who the owner is, how do you set the owner as "mysql"?
    • CommentAuthorMohjive
    • CommentTimeApr 11th 2008 edited
     # 6
    The owner is the third column, but if it already shows "mysql" is in my listing above you don't have to change anything. I will look into this issue a bit more and see if I can reproduce the error here.

    What version of Compile and Scripts do you have installed?
    Also, did you install it as normal or superuser?
    • CommentAuthorMohjive
    • CommentTimeApr 11th 2008
     # 7
    I have verified the behaviour you reported. It seems that some change to the build procudure broke the recipe. To fix it locally you should run sudo chown -R mysql /Files/MySQL
    Looking at the problem I found that there were an upstream release available (5.0.51a), so I made a new version of the recipe at the same time. It will be available in the recipe store soon.
    • CommentAuthorRainMaker
    • CommentTimeApr 12th 2008 edited
     # 8
    Okay, well on mine it shows:

    total 20508
    -rw-rw---- 1 mysql mysql 10485760 2008-04-08 16:10 ibdata1
    -rw-rw---- 1 mysql mysql 5242880 2008-04-11 14:43 ib_logfile0
    -rw-rw---- 1 mysql mysql 5242880 2008-04-08 16:10 ib_logfile1
    drwx------ 2 mysql mysql 48 2008-04-07 22:08 mysql
    -rw-rw---- 1 mysql mysql 4460 2008-04-11 14:43 serenity.err
    drwx------ 2 mysql mysql 48 2008-04-07 22:08 test


    So I'm guessing "mysql" isn't the owner.

    I ran
    sudo chown -R mysql /Files/MySQL


    And get this:

    reka@serenity ~]sudo chown -R mysql /Files/MySQL
    reka@serenity ~]


    Nothing much happens, really, after running

    reka@serenity ~]sudo chown -R mysql /Files/MySQL
    reka@serenity ~]


    I assumed the problem was fixed, so I tried to start it but it gave me the start error.

    Oh, and I don't know what Compile and Scripts I have, I just use Konsole how it is, I don't really look into it much..

    Yes I did install it as superuser.
    • CommentAuthorMohjive
    • CommentTimeApr 15th 2008
     # 9
    The files are owned by mysql as you can see in the third column in the file listing. chown wasn't really needed in this case. Could you please try to Compile the new recipe I commited, but running Compile mysql again

    The Compile and Scripts version you can get from readlink /Programs/Compile/Current and readlink /Programs/Scripts/Current (Compile --version and InstallPackage --version would work as well).
    • CommentAuthorRainMaker
    • CommentTimeApr 15th 2008
     # 10
    Okay, I'll Compile MySQL again then.

    My Compile and Scripts version is : 1.10.0
    • CommentAuthorMohjive
    • CommentTimeApr 15th 2008
     # 11
    You should upgrade Compile to 1.10.2. Also, what is your Scripts version? There are two packages, I gave you two commands to run.
    • CommentAuthorRainMaker
    • CommentTimeApr 16th 2008
     # 12
    MySQL works fine now ^.^, okay, well what command do I use to upgrade Compile? Oh, the Scripts version is: 2.8.2.
    • CommentAuthorMohjive
    • CommentTimeApr 16th 2008
     # 13
    You upgrade Compile and Scripts with InstallPackage scriptsInstallPackage compile
    • CommentAuthorRainMaker
    • CommentTimeApr 18th 2008 edited
     # 14
    Everything works fine now, great! Thanks for helping out Mohjive! :)

    You are awesome!

1 to 14 of 14

  1.