The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

WOW i just got the MySQL 4.x upgrade

Discussion in 'General Discussion' started by sexy_guy, Apr 6, 2003.

  1. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Hmm i just received the latest MySQL from the nightly upgrade.

    MySQL-embedded is not up to date (Wed Dec 31 16:00:00 1969)
    Retrieving http://updates.cpanel.net/pub/sysup//7.2/MySQL-embedded/MySQL-embedded-4.0.12-0.i386.rpm
    Preparing... ##################################################
    MySQL-embedded ##################################################
    MySQL-client is not up to date (Thu Mar 13 11:13:56 2003)
    Retrieving http://updates.cpanel.net/pub/sysup//7.2/MySQL-client/MySQL-client-4.0.12-0.i386.rpm
    Preparing... ##################################################
    MySQL-client ##################################################
    MySQL-devel is not up to date (Thu Mar 13 11:13:56 2003)
    Retrieving http://updates.cpanel.net/pub/sysup//7.2/MySQL-devel/MySQL-devel-4.0.12-0.i386.rpm
    Preparing... ##################################################
    MySQL-devel ##################################################
    MySQL-bench is not up to date (Thu Mar 13 11:13:56 2003)
    Retrieving http://updates.cpanel.net/pub/sysup//7.2/MySQL-bench/MySQL-bench-4.0.12-0.i386.rpm
    Preparing... ##################################################
    MySQL-bench ##################################################
    MySQL-shared is not up to date (Thu Mar 13 11:13:56 2003)
    Retrieving http://updates.cpanel.net/pub/sysup//7.2/MySQL-shared/MySQL-shared-4.0.12-0.i386.rpm
    Preparing... ##################################################
    MySQL-shared ##################################################

    There is really a god!
     
  2. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Something is not right here, the control panel says its 4.x but the server stats says its the old version and not only that i can now see everyones database not only mine. This cant be right????!!!
     
  3. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    All my sites with Mysql are down

    mySQL query error: DELETE FROM ibf_sessions WHERE running_time < 1049614843 or ip_address='68.65.93.xx'

    mySQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    mySQL error code: 2002
    Date: Sunday 06th of April 2003 12:40:43 AM

    What the hell happened? All my MySQL sites are currently down. Thanks CPANEL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
     
    #3 sexy_guy, Apr 6, 2003
    Last edited: Apr 6, 2003
  4. FWC

    FWC Well-Known Member

    Joined:
    May 13, 2002
    Messages:
    354
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Ontario, Canada
    My first upgraded server had mysql die, too. I figured out it was something in the my.cnf file I've been using for months. I renamed it and went back to the default one with just the max connections line and it restarted when I tried. They are all upgraded and running now. I'm still not sure what the new mysql didn't like in that my.cnf file. I've been too busy answering support tickets. :rolleyes:
     
  5. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Ok i figured it out! The old mysql pids were still active. If you have "LSOF" install on your server you can type;

    /usr/sbin/lsof -i tcp:3306

    That will list the offending pids.

    Then do a kill -9 pidnumber to get rid of them.

    Restart MySQL and that fixes it. Dont forget to set the MYSQL ROOT PW!

    Only one of my boxes was affected the rest seem fine. Strange!

    :eek:
     
  6. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    We left our old my.cnf in place. We had to kill all the processes after the upgrade. Good thing i was still up at 1am otherwise we would have had a bunch of users screaming!! Now why is Mysql complaining that it couldnt connect on port 3306 is anyones guess. We are not accepting connection from external sources. I also had to open port 3306 on the firewall. What a mess!
     
  7. sexy_guy

    sexy_guy Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    848
    Likes Received:
    0
    Trophy Points:
    16
    Did you check your phpMyAdmin? Can you see everyones database?

    WOW security alert! I can see everyones databases. What happened here with the permissions?
     
  8. Dathorn_ADT

    Dathorn_ADT Active Member

    Joined:
    Nov 16, 2002
    Messages:
    41
    Likes Received:
    1
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    That is just wonderful. Makes you wonder how hard they actually check for this kind of stuff.
     
  9. Noldar

    Noldar Well-Known Member

    Joined:
    Jun 26, 2002
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Ponchatoula, LA
    Try running

    /usr/bin/mysql_fix_privilege_tables

    and then restart mysql. That seemed to fix the phpMyAdmin problem for me.

    Richard
     
  10. dianaward

    dianaward Well-Known Member

    Joined:
    Dec 9, 2002
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    USA
    cPanel Access Level:
    Root Administrator
    Twitter:
    Didn't change a thing for me.

    Unfortunately.
     
  11. Noldar

    Noldar Well-Known Member

    Joined:
    Jun 26, 2002
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Ponchatoula, LA
    I had some problems getting mysql to restart at first. You might try the following to make sure mysql has restarted.

    killall mysqld

    /etc/rc.d/init.d/mysql start


    Richard
     
  12. JeremyV

    JeremyV Well-Known Member

    Joined:
    Oct 20, 2002
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    Thanks for that update, I woke up this morning and was beginning to crap my pants. But that command did solve my issues :)

    For those of you who may not read if it generates an error, you probably have to run that script with the password argument. Do that, restart mysqld and you should be all secure again
     
  13. jmc67

    jmc67 Well-Known Member

    Joined:
    Mar 10, 2002
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    This isn't working for me. Any other suggestion?
     
  14. jmc67

    jmc67 Well-Known Member

    Joined:
    Mar 10, 2002
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Nevermind, it did work. For those who may experience this, just clear out your browser cache.
     
  15. mbarb

    mbarb Member

    Joined:
    Aug 14, 2001
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Hello,
    Hope this helps someone out.
    After the upgrade Mysql would not start. Even though I had never edited the my.cnf it was causing MySql to fail. Ther were also errors notied in the MySql error log The problem was with spaces between the "=" in the my.cnf

    OLD
    [mysqld]
    set-variable = max_connections=500
    set-variable = join_buffer = 4M
    set-variable = record_buffer = 1M
    set-variable = table_cache = 1024
    set-variable = key_buffer = 16M

    removing the spaces allowed MySql to start.

    [mysqld]
    set-variable = max_connections=500
    set-variable = join_buffer=4M
    set-variable = record_buffer=1M
    set-variable = table_cache=1024
    set-variable = key_buffer=16M
     
  16. FWC

    FWC Well-Known Member

    Joined:
    May 13, 2002
    Messages:
    354
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Ontario, Canada
    Yep, that was the problem with my conf files. Thanks! :cool:
     
  17. tekdns

    tekdns Well-Known Member

    Joined:
    Jun 9, 2002
    Messages:
    100
    Likes Received:
    0
    Trophy Points:
    16
    Where is problem on MySQL upgrading?

    Hi,

    Where is problem on MySQL upgrading?

    "[root@server1 root]# /usr/bin/mysql_fix_privilege_tables
    This scripts updates the mysql.user, mysql.db, mysql.host and the
    mysql.func tables to MySQL 3.22.14 and above.

    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

    If you get 'Access denied' errors, you should run this script again
    and give the MySQL root user password as an argument!
    Converting all privilege tables to MyISAM format

    If your tables are already up to date or partially up to date you will
    get some warnings about 'Duplicated column name'. You can safely ignore these!
    ERROR 1060 at line 2: Duplicate column name 'File_priv'

    Creating Grant Alter and Index privileges if they don't exists
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'Grant_priv'
    ERROR 1060 at line 2: Duplicate column name 'Grant_priv'
    ERROR 1060 at line 3: Duplicate column name 'Grant_priv'

    Setting default privileges for the new grant, index and alter privileges

    Adding columns needed by GRANT .. REQUIRE (openssl)
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'ssl_type'

    Creating the new table and column privilege tables
    Changing name of columns_priv.Type -> columns_priv.Column_priv
    You can ignore any Unknown column errors from this
    ERROR 1054 at line 1: Unknown column 'Type' in 'columns_priv'

    Fixing the func table
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'type'

    Adding new fields used by MySQL 4.0.2 to the privilege tables
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'Show_db_priv'

    Updating new privileges in MySQL 4.0.2 from old ones

    ERROR 1060 at line 1: Duplicate column name 'max_questions'
    ERROR 1060 at line 1: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1060 at line 4: Duplicate column name 'Create_tmp_table_priv'
    "

    Thanks for your help
     
  18. Silverado

    Silverado Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    154
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Backyard - Poolside
    what is the path to the my.cnf file please... I would like to try this to see if it fixes my upgrade errors.
     
  19. mbarb

    mbarb Member

    Joined:
    Aug 14, 2001
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    /etc/my.cnf
     
  20. Silverado

    Silverado Well-Known Member

    Joined:
    Mar 19, 2003
    Messages:
    154
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Backyard - Poolside
    Well scary thing is this is all that is in the my.cnf file
    [mysqld]
    set-variable = max_connections=500


    Any ideas on what to do from here?
     
Loading...

Share This Page