RE: mysql wont start - Mozilla

This is a discussion on RE: mysql wont start - Mozilla ; I did a history. I did install mySQL. Would doing a yum install mysql-server mess up the DB- it has over 1,000 bugs. [root@wireshark1 bugzilla]# history | grep yum 424 yum-instsll 425 yum-instal 426 yum DBD-mysql 427 yum-install DBD-mysql 428 ...

+ Reply to Thread
Results 1 to 5 of 5

Thread: RE: mysql wont start

  1. RE: mysql wont start

    I did a history. I did install mySQL. Would doing a yum install
    mysql-server mess up the DB- it has over 1,000 bugs.


    [root@wireshark1 bugzilla]# history | grep yum
    424 yum-instsll
    425 yum-instal
    426 yum DBD-mysql
    427 yum-install DBD-mysql
    428 yum --install DBD-mysql
    429 yum mysql
    468 yum install perl-DBI
    469 yum install perl-DBI-mysql
    470 yum search mysql
    471 yum imstall mysql-devel.i386
    472 yum install mysql-devel.i386
    474 yum search mysql
    475 yum install mysql-server.i386
    476 yum install mysql-DBD
    477 yum install perl-DBD-MySQL.i386
    478 yum uninstall perl-DBD-MySQL.i386
    479 yum erase perl-DBD-MySQL.i386
    480 yum install perl-DBD-MySQL.i386





    Reading ./localconfig...

    The following variables are no longer used in ./localconfig, and
    should be removed: severities, platforms, opsys, priorities

    Checking for DBD-mysql (v4.00) ok: found v4.008
    There was an error connecting to MySQL:

    Can't connect to local MySQL server through socket
    '/var/lib/mysql/mysql.sock' (111)

    This might have several reasons:

    * MySQL is not running.
    * MySQL is running, but there is a problem either in the
    server configuration or the database access rights. Read the Bugzilla
    Guide in the doc directory. The section about database configuration
    should help.
    * Your password for the 'root' user, specified in $db_pass, is
    incorrect, in './localconfig'.
    * There is a subtle problem with Perl, DBI, or MySQL. Make
    sure all settings in './localconfig' are correct. If all else fails,
    set
    '$db_check' to 0.

    [root@wireshark1 bugzilla]# cd /var/lib/mysql/
    [root@wireshark1 mysql]# ll
    total 45136
    drwx------ 2 mysql mysql 4096 Sep 2 06:58 bugs
    drwx------ 2 mysql mysql 4096 Aug 13 12:52 forums
    -rw-rw---- 1 mysql mysql 35651584 Oct 8 12:28 ibdata1
    -rw-rw---- 1 mysql mysql 5242880 Oct 8 12:28 ib_logfile0
    -rw-rw---- 1 mysql mysql 5242880 Oct 8 12:28 ib_logfile1
    drwx------ 2 mysql mysql 4096 Aug 13 12:51 mysql
    srwxrwxrwx 1 mysql mysql 0 Aug 13 11:32 mysql.sock
    drwx------ 2 mysql mysql 4096 Aug 26 10:45 test
    [root@wireshark1 mysql]#
































    -----Original Message-----
    From: support-bugzilla-bounces+jdawkins=pulselink.net@lists.mozilla.org
    [mailto:support-bugzilla-bounces+jdawkins=pulselink.net@lists.mozilla.or
    g] On Behalf Of Max Kanat-Alexander
    Sent: Thursday, October 09, 2008 9:18 AM
    To: support-bugzilla@lists.mozilla.org
    Subject: Re: mysql wont start

    On Thu, 9 Oct 2008 08:51:22 -0700 "Jason Dawkins"
    wrote:
    > chkconfig --list |grep sql
    >
    > postgresql 0ff 1ff 2ff 3ff 4ff 5ff 6ff


    Looks like it's not installed!

    yum install mysql-server

    -Max
    --
    http://www.everythingsolved.com/
    Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
    _______________________________________________
    support-bugzilla mailing list
    support-bugzilla@lists.mozilla.org
    https://lists.mozilla.org/listinfo/support-bugzilla
    PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you
    reply.

  2. Re: mysql wont start

    On Oct 9, 9:26*pm, "Jason Dawkins" wrote:
    > I did a history. I did install mySQL. Would doing a yum install
    > mysql-server mess up the DB- it has over 1,000 bugs.
    >
    > [root@wireshark1 bugzilla]# history | grep yum
    > * 424 *yum-instsll
    > * 425 *yum-instal
    > * 426 *yum DBD-mysql
    > * 427 *yum-install DBD-mysql
    > * 428 *yum --install DBD-mysql
    > * 429 *yum mysql
    > * 468 *yum install perl-DBI
    > * 469 *yum install perl-DBI-mysql
    > * 470 *yum search mysql
    > * 471 *yum imstall mysql-devel.i386
    > * 472 *yum install mysql-devel.i386
    > * 474 *yum search mysql
    > * 475 *yum install mysql-server.i386
    > * 476 *yum install mysql-DBD
    > * 477 *yum install perl-DBD-MySQL.i386
    > * 478 *yum uninstall perl-DBD-MySQL.i386
    > * 479 *yum erase *perl-DBD-MySQL.i386
    > * 480 *yum install perl-DBD-MySQL.i386
    >
    > Reading ./localconfig...
    >
    > The following variables are no longer used in ./localconfig, and
    > should be removed: severities, platforms, opsys, priorities
    >
    > Checking for * * * * * DBD-mysql (v4.00) * ok: found v4.008
    > There was an error connecting to MySQL:
    >
    > * * Can't connect to local MySQL server through socket
    > '/var/lib/mysql/mysql.sock' (111)
    >
    > This might have several reasons:
    >
    > * MySQL is not running.
    > * MySQL is running, but there is a problem either in the
    > * server configuration or the database access rights. Read the Bugzilla
    > * Guide in the doc directory. The section about database configuration
    > * should help.
    > * Your password for the 'root' user, specified in $db_pass, is
    > * incorrect, in './localconfig'.
    > * There is a subtle problem with Perl, DBI, or MySQL. Make
    > * sure all settings in './localconfig' are correct. If all else fails,
    > set
    > * '$db_check' to 0.
    >
    > [root@wireshark1 bugzilla]# cd /var/lib/mysql/
    > [root@wireshark1 mysql]# ll
    > total 45136
    > drwx------ 2 mysql mysql * * 4096 Sep *2 06:58 bugs
    > drwx------ 2 mysql mysql * * 4096 Aug 13 12:52 forums
    > -rw-rw---- 1 mysql mysql 35651584 Oct *8 12:28 ibdata1
    > -rw-rw---- 1 mysql mysql *5242880 Oct *8 12:28 ib_logfile0
    > -rw-rw---- 1 mysql mysql *5242880 Oct *8 12:28 ib_logfile1
    > drwx------ 2 mysql mysql * * 4096 Aug 13 12:51 mysql
    > srwxrwxrwx 1 mysql mysql * * * *0 Aug 13 11:32 mysql.sock
    > drwx------ 2 mysql mysql * * 4096 Aug 26 10:45 test
    > [root@wireshark1 mysql]#
    >
    > -----Original Message-----
    > From: support-bugzilla-bounces+jdawkins=pulselink....@lists.mozilla.org
    >
    > [mailto:support-bugzilla-bounces+jdawkins=pulselink....@lists.mozilla.or
    > g] On Behalf Of Max Kanat-Alexander
    > Sent: Thursday, October 09, 2008 9:18 AM
    > To: support-bugzi...@lists.mozilla.org
    > Subject: Re: mysql wont start
    >
    > On Thu, 9 Oct 2008 08:51:22 -0700 "Jason Dawkins"
    > wrote:
    > > chkconfig --list |grep sql

    >
    > > postgresql * * *0ff * 1ff * 2ff * 3ff * 4ff *5ff * 6ff

    >
    > * * * * Looks like it's not installed!
    >
    > * * * * yum install mysql-server
    >
    > * * * * -Max
    > --http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
    > _______________________________________________
    > support-bugzilla mailing list
    > support-bugzi...@lists.mozilla.orghttps://lists.mozilla.org/listinfo/support-bugzilla
    > PLEASE put support-bugzi...@lists.mozilla.org in the To: field when you
    > reply.


    looks like your mysql has crashed somehow..

    since your data is available under /var/lib/mysql, backup it at some
    other location, do a fresh install of mysql and try to use your backup
    data with it.

  3. RE: mysql wont start

    O.k. That worked Thanks you very everyone.
    I'm up and running, but now all the users are getting this error when trying to close bugs. It seems that can't close bugs when they enter 'Additional Comments'.

    Here is the error


    Software error:

    DBD::mysql::db do failed: Incorrect key file for table './bugs/bugs_fulltext.MYI'; try to repair it [for Statement "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ?
    WHERE bug_id = ?"] at Bugzilla/Bug.pm line 750
    Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH( 0x9c8ed90)') called at Bugzilla/Bug.pm line 707
    Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x9c8ed9 0)', '2008-10-09 12:28:31') called at /var/www/html/bugzilla/process_bug.cgi line 521



    For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.









    -----Original Message-----
    From: support-bugzilla-bounces+jdawkins=pulselink.net@lists.mozilla.org [mailto:support-bugzilla-bounces+jdawkins=pulselink.net@lists.mozilla.org] On Behalf Of Vaibhav Kushwaha
    Sent: Thursday, October 09, 2008 11:22 AM
    To: support-bugzilla@lists.mozilla.org
    Subject: Re: mysql wont start

    On Oct 9, 9:26*pm, "Jason Dawkins" wrote:
    > I did a history. I did install mySQL. Would doing a yum install
    > mysql-server mess up the DB- it has over 1,000 bugs.
    >
    > [root@wireshark1 bugzilla]# history | grep yum
    > * 424 *yum-instsll
    > * 425 *yum-instal
    > * 426 *yum DBD-mysql
    > * 427 *yum-install DBD-mysql
    > * 428 *yum --install DBD-mysql
    > * 429 *yum mysql
    > * 468 *yum install perl-DBI
    > * 469 *yum install perl-DBI-mysql
    > * 470 *yum search mysql
    > * 471 *yum imstall mysql-devel.i386
    > * 472 *yum install mysql-devel.i386
    > * 474 *yum search mysql
    > * 475 *yum install mysql-server.i386
    > * 476 *yum install mysql-DBD
    > * 477 *yum install perl-DBD-MySQL.i386
    > * 478 *yum uninstall perl-DBD-MySQL.i386
    > * 479 *yum erase *perl-DBD-MySQL.i386
    > * 480 *yum install perl-DBD-MySQL.i386
    >
    > Reading ./localconfig...
    >
    > The following variables are no longer used in ./localconfig, and
    > should be removed: severities, platforms, opsys, priorities
    >
    > Checking for * * * * * DBD-mysql (v4.00) * ok: found v4.008
    > There was an error connecting to MySQL:
    >
    > * * Can't connect to local MySQL server through socket
    > '/var/lib/mysql/mysql.sock' (111)
    >
    > This might have several reasons:
    >
    > * MySQL is not running.
    > * MySQL is running, but there is a problem either in the
    > * server configuration or the database access rights. Read the Bugzilla
    > * Guide in the doc directory. The section about database configuration
    > * should help.
    > * Your password for the 'root' user, specified in $db_pass, is
    > * incorrect, in './localconfig'.
    > * There is a subtle problem with Perl, DBI, or MySQL. Make
    > * sure all settings in './localconfig' are correct. If all else fails,
    > set
    > * '$db_check' to 0.
    >
    > [root@wireshark1 bugzilla]# cd /var/lib/mysql/
    > [root@wireshark1 mysql]# ll
    > total 45136
    > drwx------ 2 mysql mysql * * 4096 Sep *2 06:58 bugs
    > drwx------ 2 mysql mysql * * 4096 Aug 13 12:52 forums
    > -rw-rw---- 1 mysql mysql 35651584 Oct *8 12:28 ibdata1
    > -rw-rw---- 1 mysql mysql *5242880 Oct *8 12:28 ib_logfile0
    > -rw-rw---- 1 mysql mysql *5242880 Oct *8 12:28 ib_logfile1
    > drwx------ 2 mysql mysql * * 4096 Aug 13 12:51 mysql
    > srwxrwxrwx 1 mysql mysql * * * *0 Aug 13 11:32 mysql.sock
    > drwx------ 2 mysql mysql * * 4096 Aug 26 10:45 test
    > [root@wireshark1 mysql]#
    >
    > -----Original Message-----
    > From: support-bugzilla-bounces+jdawkins=pulselink....@lists.mozilla.org
    >
    > [mailto:support-bugzilla-bounces+jdawkins=pulselink....@lists.mozilla.or
    > g] On Behalf Of Max Kanat-Alexander
    > Sent: Thursday, October 09, 2008 9:18 AM
    > To: support-bugzi...@lists.mozilla.org
    > Subject: Re: mysql wont start
    >
    > On Thu, 9 Oct 2008 08:51:22 -0700 "Jason Dawkins"
    > wrote:
    > > chkconfig --list |grep sql

    >
    > > postgresql * * *0ff * 1ff * 2ff * 3ff * 4ff * 5ff * 6ff

    >
    > * * * * Looks like it's not installed!
    >
    > * * * * yum install mysql-server
    >
    > * * * * -Max
    > --http://www.everythingsolved.com/
    > Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
    > _______________________________________________
    > support-bugzilla mailing list
    > support-bugzi...@lists.mozilla.orghttps://lists.mozilla.org/listinfo/support-bugzilla
    > PLEASE put support-bugzi...@lists.mozilla.org in the To: field when you
    > reply.


    looks like your mysql has crashed somehow..

    since your data is available under /var/lib/mysql, backup it at some
    other location, do a fresh install of mysql and try to use your backup
    data with it.
    _______________________________________________
    support-bugzilla mailing list
    support-bugzilla@lists.mozilla.org
    https://lists.mozilla.org/listinfo/support-bugzilla
    PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you reply.

  4. RE: mysql wont start

    Quoting Jason Dawkins:
    > O.k. That worked Thanks you very everyone.
    > I'm up and running, but now all the users are getting this error when
    > trying to close bugs. It seems that can't close bugs when they enter
    > 'Additional Comments'.
    >
    > Here is the error
    >
    >
    > Software error:
    >
    > DBD::mysql::db do failed: Incorrect key file for table
    > './bugs/bugs_fulltext.MYI'; try to repair it [for
    > Statement "UPDATE bugs_fulltext SET comments = ?,

    comments_noprivate
    > = ? WHERE bug_id = ?"] at Bugzilla/Bug.pm line 750
    > Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH( 0x9c8ed90)') called
    > at Bugzilla/Bug.pm line 707
    > Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x9c8ed9 0)', '2008-10-09
    > 12:28:31') called at /var/www/html/bugzilla/process_bug.cgi line 521



    Run via mysql: REPAIR TABLE bugs_fulltext;

  5. RE: mysql wont start

    Thank you it worked. It repaired the table and fixed it.
    Thanks




    -----Original Message-----
    From: Tosh, Michael J [mailto:michael.j.tosh@lmco.com]
    Sent: Thursday, October 09, 2008 1:36 PM
    To: Jason Dawkins; support-bugzilla@lists.mozilla.org
    Subject: RE: mysql wont start

    Quoting Jason Dawkins:
    > O.k. That worked Thanks you very everyone.
    > I'm up and running, but now all the users are getting this error when
    > trying to close bugs. It seems that can't close bugs when they enter
    > 'Additional Comments'.
    >
    > Here is the error
    >
    >
    > Software error:
    >
    > DBD::mysql::db do failed: Incorrect key file for table
    > './bugs/bugs_fulltext.MYI'; try to repair it [for
    > Statement "UPDATE bugs_fulltext SET comments = ?,

    comments_noprivate
    > = ? WHERE bug_id = ?"] at Bugzilla/Bug.pm line 750
    > Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH( 0x9c8ed90)') called
    > at Bugzilla/Bug.pm line 707
    > Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x9c8ed9 0)', '2008-10-09
    > 12:28:31') called at /var/www/html/bugzilla/process_bug.cgi line 521



    Run via mysql: REPAIR TABLE bugs_fulltext;

+ Reply to Thread