Results 1 to 8 of 8

Thread: Problems with starting MySQL server for Media Wiki

  1. #1
    Join Date
    Jul 2009
    Location
    Holland
    Posts
    47

    Question Problems with starting MySQL server for Media Wiki

    I try to install the media wiki on an webserver. I've installed all components I need. before intallation of de media wiki, the wiki gives me this status rapport:

    "# PHP 5.2.9 installed
    # Found database drivers for: MySQL PostgreSQL SQLite
    # PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)
    # Have XML / Latin1-UTF-8 conversion support.
    # Session save path (/var/lib/php5) appears to be valid.
    # PHP's memory_limit is 128M.
    # Couldn't find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.
    # Found GNU diff3: /usr/bin/diff3.
    # Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.
    # Found GD graphics library built-in.
    # Installation directory: /srv/www/htdocs/mediawiki
    # Script URI path: /mediawiki
    # Installing MediaWiki with php file extensions
    # Environment checked. You can install MediaWiki.
    "

    But the media wiki can't connect to te webserver.
    "# Database type: MySQL
    # Loading class: DatabaseMysql
    # Attempting to connect to database server as root...failed with error [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    ."

    I've initialized the grant tables:
    Code:
    linux-zbz3:/home/awo # cd /usr/bin
    Code:
    linux-zbz3:/usr/bin # ./mysql_install_db
    Installing MySQL system tables...
    OK
    Filling help tables...
    OK
    PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
    To do so, start the server, then issue the following commands:
    /usr/bin/mysqladmin -u root password 'new-password'
    /usr/bin/mysqladmin -u root -h linux-zbz3.site password 'new-password'
    
    Alternatively you can run:
    /usr/bin/mysql_secure_installation
    
    which will also give you the option of removing the test
    databases and anonymous user created by default.  This is
    strongly recommended for production servers.
    
    See the manual for more instructions.
    
    You can start the MySQL daemon with:
    cd /usr ; /usr/bin/mysqld_safe &
    
    You can test the MySQL daemon with mysql-test-run.pl
    cd mysql-test ; perl mysql-test-run.pl
    
    Please report any problems with the /usr/bin/mysqlbug script!
    
    The latest information about MySQL is available on the web at
    http://www.mysql.com
    Support MySQL by buying support/licenses at http://shop.mysql.com
    linux-zbz3:/usr/bin #
    But I get this error while startin the MySQL server:
    Code:
    linux-zbz3:/usr/bin # mysqld_safe awo=mysql &
    [1] 13639
    linux-zbz3:/usr/bin # nohup: invoer genegeerd en stderr gaat naar stdout
    Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/lib/mysql/linux-zbz3.site.pid
    090923 14:12:46  mysqld ended
    How can I solve this?
    Coffee is like Linux, only cool people use it. Tea is like Windows, only losers use it.

  2. #2
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    29,795

    Default Re: Problems with starting MySQL server for Media Wiki

    Your environment might be completely different (I do not have media Wiki), but my mySQL is started via YaST > syem > System services (runlevel).
    Henk van Velden

  3. #3
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Problems with starting MySQL server for Media Wiki

    First of all: the proper way to start the MySQL server is from yast or as root on the command line:

    Code:
    prompt# rcmysql start
    The argument may be stop or status as well. Then try:

    Code:
    prompt> mysqladmin ping
    and it should say 'mysqld is alive'. If not please have a look at the mysql error log. You find it in /var/lib/mysql and it has a filename ending in *.err

    Please post the end of this file where it says why mysql could not start.

  4. #4
    Join Date
    Jul 2009
    Location
    Holland
    Posts
    47

    Default Re: Problems with starting MySQL server for Media Wiki

    @hcw: When I try to start MySQL with Yast, I receive this error:
    "/etc/init.d/mysql start retourneerde 1 (niet gespecificeerde foutmelding):"

    translation:

    "/etc/init.d/mysql start returned 1 (not specified error):"

    @vodoo
    Code:
    linux-zbz3:~ # prompt# rcmysql start
    bash: prompt#: command not found
    or do you mean:
    Code:
    linux-zbz3:~ # rcmysql start
    Updating MySQL privilege database... 
    Looking for 'mysql' in: /usr/bin/mysql
    Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
    Running 'mysqlcheck'...
    Running 'mysql_fix_privilege_tables'...
    ERROR 1005 (HY000) at line 8: Can't create table 'db' (errno: 13)
    ERROR 1005 (HY000) at line 13: Can't create table 'host' (errno: 13)
    ERROR 1005 (HY000) at line 16: Can't create table 'user' (errno: 13)
    ERROR 1005 (HY000) at line 22: Can't create table 'func' (errno: 13)
    ERROR 1005 (HY000) at line 25: Can't create table 'tables_priv' (errno: 13)
    ERROR 1005 (HY000) at line 27: Can't create table 'columns_priv' (errno: 13)
    ERROR 1005 (HY000) at line 30: Can't create table 'help_topic' (errno: 13)
    ERROR 1005 (HY000) at line 33: Can't create table 'help_category' (errno: 13)
    ERROR 1005 (HY000) at line 36: Can't create table 'help_relation' (errno: 13)
    ERROR 1005 (HY000) at line 39: Can't create table 'help_keyword' (errno: 13)
    ERROR 1005 (HY000) at line 42: Can't create table 'time_zone_name' (errno: 13)
    ERROR 1005 (HY000) at line 45: Can't create table 'time_zone' (errno: 13)
    ERROR 1005 (HY000) at line 48: Can't create table 'time_zone_transition' (errno: 13)
    ERROR 1005 (HY000) at line 51: Can't create table 'time_zone_transition_type' (errno: 13)
    ERROR 1005 (HY000) at line 54: Can't create table 'time_zone_leap_second' (errno: 13)
    ERROR 1005 (HY000) at line 57: Can't create table 'proc' (errno: 13)
    ERROR 1005 (HY000) at line 60: Can't create table 'procs_priv' (errno: 13)
    ERROR 1017 (HY000) at line 76: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 80: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 82: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 83: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 84: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 87: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 88: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 89: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 95: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 100: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 106: Can't find file: './mysql/tables_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 109: Can't find file: './mysql/tables_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 118: Can't find file: './mysql/tables_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 132: Can't find file: './mysql/columns_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 136: Can't find file: './mysql/columns_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 146: Can't find file: './mysql/columns_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 154: Can't find file: './mysql/func.frm' (errno: 13)
    ERROR 1017 (HY000) at line 162: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 164: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 175: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 181: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 191: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 194: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 198: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 201: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 202: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 203: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 204: Can't find file: './mysql/func.frm' (errno: 13)
    ERROR 1017 (HY000) at line 208: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 212: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 237: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 242: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 256: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 260: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 274: Can't find file: './mysql/func.frm' (errno: 13)
    ERROR 1017 (HY000) at line 276: Can't find file: './mysql/func.frm' (errno: 13)
    ERROR 1017 (HY000) at line 283: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 288: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 289: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 291: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 292: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 294: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 295: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 300: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 301: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 303: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 304: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 306: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 307: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 312: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 318: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 323: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 324: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 326: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 327: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 329: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 330: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 335: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 336: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 338: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 339: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 341: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 342: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 344: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 345: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 347: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 348: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 353: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 354: Can't find file: './mysql/db.frm' (errno: 13)
    ERROR 1017 (HY000) at line 355: Can't find file: './mysql/host.frm' (errno: 13)
    ERROR 1017 (HY000) at line 360: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 367: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 369: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 370: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 371: Can't find file: './mysql/user.frm' (errno: 13)
    ERROR 1017 (HY000) at line 379: Can't find file: './mysql/procs_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 383: Can't find file: './mysql/procs_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 387: Can't find file: './mysql/procs_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 391: Can't find file: './mysql/procs_priv.frm' (errno: 13)
    ERROR 1017 (HY000) at line 399: Can't find file: './mysql/proc.frm' (errno: 13)
    ERROR 1017 (HY000) at line 443: Can't find file: './mysql/proc.frm' (errno: 13)
    ERROR 1017 (HY000) at line 445: Can't find file: './mysql/proc.frm' (errno: 13)
    FATAL ERROR: Upgrade failed
    And I've no fille *.err...
    There are 5 files:
    ibdata1
    ib_logfile0
    ib_logfile1
    mysql.log
    .run-mysql_upgrade
    Coffee is like Linux, only cool people use it. Tea is like Windows, only losers use it.

  5. #5
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Problems with starting MySQL server for Media Wiki

    I see. Something is completely broken. How did you install mysql? And what distro are you using?

    Please have a look what the permissions are for /var/lib/mysql

    Code:
    ls -ld /var/lib/mysql
    And what is the output of

    Code:
    df -l
    mysqld should be started as user 'mysql' and group 'mysql'. Please check that these exist.

  6. #6
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Problems with starting MySQL server for Media Wiki

    Looking at your initial post again I'm quite sure that you messed things up. You did run 'mysql_install_db' as user root with no arguments, didn't you? When run manually it must have some arguments like this:

    Code:
    mysql_install_db --user=mysql --datadir=/var/lib/mysql
    Yast would have taken care of this, but you created /var/lib/mysql with user privileges of root. MySQL can no longer write to this directory. (bummer)

    As you have not yet any data you can restart from the beginning. Remove /var/lib/mysql like this (as root)

    Code:
    rm -rf /var/lib/mysql
    and then go to yast and enable mysql. Good luck!

  7. #7
    Join Date
    Jul 2009
    Location
    Holland
    Posts
    47

    Default Re: Problems with starting MySQL server for Media Wiki

    MySQL works!

    I've delete the folder /var/lib/mysql
    I've reinstalled MySQL and MySQL components
    After that I've used the following commands:


    Code:
    mysql_install_db --user=mysql --datadir=/var/lib/mysql
    Code:
    rcmysql start
    Code:
    awo@linux-zbz3:~> mysqladmin ping
    mysqld is alive

    And it works now. Thanks!
    Coffee is like Linux, only cool people use it. Tea is like Windows, only losers use it.

  8. #8
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: Problems with starting MySQL server for Media Wiki

    I'm glad it works for you. BTW, step 2 would have taken care of step 1 automagically. And simply activating mysql from yast takes care of everything (except adding a password for root).

Tags for this Thread

Posting Permissions

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