Results 1 to 9 of 9
  1. #1
    Junior Member
    Join Date
    Dec 2006
    Posts
    9

    Unhappy Can Not Install DBD:MySQL

    I'm new to Westhost and have been able to get most everything I need up and running except for DBD:MySql.
    I keep getting the following error:

    ##############################
    'perldoc INSTALL'.

    Checking if your kit is complete...
    Looks good
    Using DBI 1.53 (for perl 5.008007 on i686-linux) installed in /usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBI/
    Writing Makefile for DBD::mysql
    cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
    cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
    cp lib/Mysql.pm blib/lib/Mysql.pm
    cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
    cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
    cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
    gcc -c -I/usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBI -I/usr/include -mcpu=pentiumpro -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\" -fpic "-I/usr/local/perl/lib/5.8.7/i686-linux/CORE" dbdimp.c
    In file included from dbdimp.c:20:
    dbdimp.h:21:49: mysql.h: No such file or directory
    dbdimp.h:22:45: mysqld_error.h: No such file or directory
    dbdimp.h:23:49: errmsg.h: No such file or directory
    ###############################

    Here are my path settings:
    I will use the following settings for compiling and testing:

    ################################

    cflags (mysql_config) = -I/usr/include -mcpu=pentiumpro
    embedded (mysql_config) =
    libs (mysql_config) = -L/usr/lib -lmysqlclient -lcrypt -lnsl -lm -lz -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
    mysql_config (guessed ) = mysql_config
    nocatchstderr (default ) = 0
    nofoundrows (default ) = 0
    ssl (guessed ) = 0
    testdb (default ) = test
    testhost (default ) =
    testpassword (default ) =
    testsocket (default ) =
    testuser (default ) =

    ##############################

    It appears to me that I might be missing some libraries, perhaps I need to install the MySql-Devel package first? If so, that only comes in an RPM from what I've seen.

    Has anyone had success with this installation and can anyone point me in the right direction before I lame out and wind up paying custom services $95 :-)

    Thanks

  2. #2
    Moderator wildjokerdesign's Avatar
    Join Date
    Jun 2003
    Location
    Kansas City Mo
    Posts
    5,720

    Default

    Have you installed MySQL and Perl - MySQL Libs via your Site Manager? You should not have to install this manually.
    Shawn
    Please remember your charity of choice: http://www.redcross.org

    Handy Links: wildjokerdesign.net | Plain Text Editors: EditPlus | Crimson

  3. #3
    Junior Member
    Join Date
    Dec 2006
    Posts
    9

    Default DBD:MySql

    Yes, I have installed MySql and I already created my db and tables succesfully using phpadmin.

    I installed everything from sitemanager (probably too much!) that I thought might be able to give me the files that DBD:MySql is looking for but no luck.

    Any other thoughts?

    thanks

  4. #4
    Senior Member rolling's Avatar
    Join Date
    May 2004
    Location
    Different day, different place
    Posts
    486

    Default

    Quote Originally Posted by jackster
    gcc -c -I/usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBI -I/usr/include -mcpu=pentiumpro -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\"3.0008\" -DXS_VERSION=\"3.0008\" -fpic "-I/usr/local/perl/lib/5.8.7/i686-linux/CORE" dbdimp.c
    In file included from dbdimp.c:20:
    dbdimp.h:21:49: mysql.h: No such file or directory
    dbdimp.h:22:45: mysqld_error.h: No such file or directory
    dbdimp.h:23:49: errmsg.h: No such file or directory
    The obvious thing to do is to check how mysql.h, mysqld_error.h and errmsg.h are called in dbdimp.c (line 20)
    Your include paths are defined as
    /usr/local/perl/lib/site_perl/5.8.7/i686-linux/auto/DBI
    /usr/include
    /usr/local/include

    but mysql.h, mysqld_error.h and errmsg.h are located in /usr/local/mysql/include

    I would try running configure again and telling it where to find mysql
    Richard

    I have jotted down some of my meddlings at http://www.rollingr.net/wordpress
    Click here for a full list of formatting codes for this forum

  5. #5

    Default

    jackster,

    I may not be understanding what you are trying to do, so I just wanted to clarify. When you say that it can't find the files that DBD::mysql is looking for, are you talking about files for building/compiling DBD::mysql or for *using* DBD::mysql? From the output that you posted it looks like you are trying to build it, but as Wildjoker mentioned, DBD::mysql should already be installed on the account as part of the PerlMysql Site Application. So if you have installed that then you shouldn't need to do anything else to use it. Hence my confusion.

    If it isn't installed on your account I would contact tech support and have them look into it. If it is installed and you are having problems getting it to work then post the error you are getting and we'll see what we can do from there. Or if I'm missing the point entirely just ignore me

    -Blender

  6. #6
    Junior Member
    Join Date
    Nov 2006
    Posts
    16

    Default

    I have a similar problem. I need to install this in order to install MovableType. Unfortunately, there is no Perl MySQL-Libs package for me to install in the Site Manager. In fact I used to see more, now I hardly see anything.

    So I have to install GCC to run Make? It's hard to believe that's not in the OS. And I cannot even run the man command. It doesn't show.

    Something is probably not configured right.

  7. #7
    Moderator wildjokerdesign's Avatar
    Join Date
    Jun 2003
    Location
    Kansas City Mo
    Posts
    5,720

    Default

    I would really urge those who do not have the Perl MySQL Libs available to them via the Site Manager to contact support. I am pretty sure they are part of all the Packages except the Basic Personal which does not even offer MySQL. If you did used to have something in your Site Manager and now do not see it then you should contact WH. In the past WH has never "downgraded" a persons account when they have reworked their plans so I can't see that you would lose Applications for that reason unless they have changed thier policy.
    Shawn
    Please remember your charity of choice: http://www.redcross.org

    Handy Links: wildjokerdesign.net | Plain Text Editors: EditPlus | Crimson

  8. #8
    Junior Member
    Join Date
    Dec 2006
    Posts
    9

    Default problem resolved

    Looks like I got my problem resolved. I went back into site manager and noticed that I didn't install perlDBI, so I did. I also installed Net::Mysql from CPAN and everything is working. I would think that the Net::Mysql wasn't what what fixed it but I have no way of knowing since I installed perlMysql and Net:Mysql before I tested successfully.

    Thanks for all the help.

    I have to say that this forum is a lot better than I expected...

  9. #9
    Junior Member
    Join Date
    Nov 2006
    Posts
    16

    Default Thanks

    I did just that. Funny is those options used to be in the site manager and are now gone. I hate the thought of trying to install all these packages myself.

Similar Threads

  1. Replies: 5
    Last Post: 03-05-2008, 09:43 PM
  2. Bugzilla install. Running into Perl module issues
    By codehooligans in forum CGI Scripts / Perl
    Replies: 1
    Last Post: 09-11-2005, 02:55 PM
  3. Spamassassin upgrade isn't working - part 2
    By bstreet in forum E-mail / FTP Management
    Replies: 2
    Last Post: 06-10-2005, 02:16 PM
  4. MySQL Fresh Install - How To?
    By howard in forum PHP / MySQL
    Replies: 4
    Last Post: 04-24-2005, 04:37 PM
  5. Unable to install SOAP::Lite
    By Jerry in forum CGI Scripts / Perl
    Replies: 0
    Last Post: 04-07-2005, 05:38 PM

Posting Permissions

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