"Life is binary, one or zero, life or death"
  • About Me

  • November 19th, 2009

    [MySQL] I did the crap!

    Hi all,
    Ok, I confirm, I was jealous about Allan: after the “he broke it!” everyone know him. I wanted to be more popular, and maybe with my last crap I did.

    I changed configuration, pid and sock file path in MySQL; I was pretty sure that change didn’t broke anything except php, but…I failed.
    Yesterday I lost the whole day trying to fix this and in the night I found the solution: the problem was mysql set sock file path to /tmp/mysql.sock by default, I need to pass the option in configure. Don’t ask me why, but I thought that move sock file in a new location was a minor change and setting the new path into my.cnf was enough.
    mysql 5.1.41-2 is already in [extra] and will fix everything (qt applications, mysql-python, etc…).
    At least, with this “little story”, I’ll remember to put every package in [testing] first!

    Happy update :)

    4 Comments »

    1. Bash broke it!

      Comment by Allan AUSTRALIA Linux Mozilla Firefox 3.0.10 — November 19, 2009 @ 10:53 AM
    2. even with mysql 5.1.41-2 I had to edit /etc/php/php.ini and set:
      mysql.default_socket = /var/run/mysqld/mysqld.sock

      are you sure everything is ok?

      Comment by damjan THE FORMER YUGOSLAV REPUBLIC OF MACEDONIA Linux Mozilla Firefox 3.5.5 — November 19, 2009 @ 5:12 PM
    3. everything except php, Pierre is working on this.

      Comment by bash ITALY Linux Konqueror 4.3 — November 19, 2009 @ 5:19 PM
    4. Lol, so you’re the guy who caused that problem… Oh well, it only took me less than 5 minutes to fix all my mysql stuff.

      Comment by Garrett UNITED STATES Linux Mozilla 1.9.1.5 — November 24, 2009 @ 11:54 PM

    RSS feed for comments on this post. TrackBack URI

    Leave a comment

    CC-BY NC SA
    This blog is licensed under the CC-BY NC SA version 3.0 or later.
    Theme is aav1 by Aaron Adams, modified by Andrea Scarpino

    Arch Linux  Wordpress  kde-developer
    FireStats icon Powered by FireStats