SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Wanna help a newbie with install? Here r the errors...

    I'm newbie with a PHP/MySQL project. I'm using the sitepoint book by Yank. I already had MySQL installed and running from the Fedora 11 DVD install. I installed Apache from the book, its still workin. Then tried to install PHP and everything was in the wrong place. When I located the mysql_config it would not work for PHP install ./configure file.

    OK. so I went through yum'n out mysql. I'm going to redo it from scratch as per the book (gee, I hope Apache 'll be ok with that).

    Right now, mysql is not processing the install script on page 35=
    [root@xtian mysql]# scripts/mysql_install_db --user=mysql

    scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
    Neither host 'xtian' nor 'localhost' could be looked up with
    ./bin/resolveip
    Please configure the 'hostname' command to return a correct
    hostname.
    If you want to solve this at a later stage, restart this script
    with the --force option

    Naturally this didn't bother me cuz there is no host yet. I'm using local host and Apache is fine with that right now. I try it with the --force option
    [root@xtian mysql]# scripts/mysql_install_db --force --user=mysql
    scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
    Installing MySQL system tables...
    scripts/mysql_install_db: line 351: ./bin/mysqld: cannot execute binary file
    Installation of system tables failed!

    Examine the logs in ./data for more information.
    You can try to start the mysqld daemon with:
    ./bin/mysqld --skip-grant &
    I'm not comfortable doing that yet. especiall since I can't find any explanation in a forum search for the previous problems.

    and use the command line tool
    ./bin/mysql to connect to the mysql
    database and look at the grant tables:
    shell> ./bin/mysql -u root mysql
    mysql> show tables

    Try 'mysqld --help' if you have problems with paths. Using --log
    gives you a log in ./data that may be helpful.
    Nope, no mysql --help
    The latest information about MySQL is available on the web at
    newbiecantposturls
    Please consult the MySQL manual section: 'Problems running mysql_install_db',
    and the manual section that describes problems on your OS.
    Another information source is the MySQL email archive.
    Please check all of the above before mailing us!
    And if you do mail us, you MUST use the ./bin/mysqlbug script!

    So I tried the manual pages for mysql. According to my install there is a man directory in the mysql directory. It just doesn't work...
    [root@xtian mysql]# man mysql
    No manual entry for mysql
    Whatever! So maybe it really started and this is all just trying to get on my nerves! No and Yes (^_^)......
    [root@xtian /]# /usr/local/mysql/bin/mysqladmin -u root status
    bash: mysqladmin: command not found
    [root@xtian /usr/local/mysql/bin]# find ./ -name 'mysqladmin'
    ./mysqladmin
    Appreciate anyone who wants to explain whats going on step by step. More kudos for what to do next .

    Xtian

  2. #2
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In a feat of daring intended to astound you,
    I will solve my own problems, here, for your entertainment...

    Quote Originally Posted by xtiansimon View Post
    [root@xtian mysql]# scripts/mysql_install_db --user=mysql
    scripts/mysql_install_db: line 205: ./bin/my_print_defaults: cannot execute binary file
    Neither host 'xtian' nor 'localhost' could be looked up with
    ./bin/resolveip
    Please configure the 'hostname' command to return a correct
    hostname.
    If you want to solve this at a later stage, restart this script
    with the --force option
    THINKING_TO_HIMSELF-- Apache doesn't require a host name. Maybe MySQL does. First i will look at this resolveip file and see if it is editable. Since I'm accessing the internet from my public library I will now have to do an internet search on this file and what it does. Oh wait. I have to be at my just-over-minimum-wage-part-time job in two hours. I will see what I can do --/THINKING_TO_HIMSELF

  3. #3
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Bugs related to this in v4.

    wwwDOTgoogleDOTcom/url?sa=t&source=web&ct=res&cd=1&ved=0CAoQFjAA&url=http%3A%2F%2Fbugs.mysql.com%2Fbug.php%3Fid%3D4215&rct=j&q=%2Fbin%2Fresolveip&ei=tBLWSolj0oaUB_Hi8ZwJ&usg=AFQjCNHCSmWtLrzrLSukT-xEckr8SZE5JA

    Anything to do with a 64-bit install? I really don't know how to tell if I have a 64-bit computer. What--he asks himself--would be the error for installing a 64-bit mySQL package on a 32 bit machine?

    The best next step given that I have to log off the library's computer in the next ten minutes cuz I only get 1 hour per day internet time, is to go home and try to install the other 32bit version.

    ... Good Luck Dude!

  4. #4
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok.
    1. Updated glibc with YUM
    2. Switched to new install: i686-glibc... install from the 64 bit version. For my use its a better choice since i686 will run even on a 64bit-whatever..
    3. CHOWNed the files, then CHOWNed em again as per the MySQL REFMAN instead of the Yank book.
    4. Running the commands to test if the server is running, there was a strange output to the command line. checked the error file in mysql and found this:
    A mysqld process already exists at Thu Oct 15 15:56:08 EDT 2009

    Working on what this means since there's nothing after "at". Some straggler from the previous install not removed by YUM? Now I just have to find where that would be. Why didn't the new install overwrite it?

    Xtian

  5. #5
    SitePoint Zealot
    Join Date
    Oct 2009
    Posts
    114
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysql is not listed in PS before running the mysqld_safe command
    Here is the output from this command

    # bin/mysqld_safe --user=mysql
    nohup: ignoring input and redirecting stderr to stdout
    Starting mysqld daemon with databases from /usr/local/mysql/data


    Then the prompt hangs there.

    I did a search on the nohup and found this more advanced problem. I can't imagine the two are related:
    http://www.sitepoint.com/forums/show...ighlight=nohup

    I don't know what else to do. It is running according to PS. The original issue was PHP would not install because it couldn't find some part of MySQL. now that I've moved the MySQL to this new directory, maybe that problem will go away. HAHAHA!

    I'LL BE BACK...


Bookmarks

Posting Permissions

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